Snowflake VM Object: Dunning Groups

► Dunning Groups

Field	Datatype	Description
CLIENT_NO	NUMBER	CLIENT_NO uniquely identifying each unique client
IS_DELETED	BOOLEAN	Denotes a True/False as to if the referenced data has been deleted via soft delete
REF_PK	TEXT	REF_PK The PK of the ref_type concatenated with a pipe as needed within the JSON
DUNNING_GROUP_NO	NUMBER	the dunning_group_no for the referenced record
CLIENT_DUNNING_GROUP_ID	TEXT	the client_dunning_group_id for the referenced record
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
DESCRIPTION	TEXT	The detailed description related to the referenced data
DUNNING_PROCESS	TEXT	the dunning_process for the referenced record
NAME	TEXT	the name for the referenced record
DUNNING_STATUS_NO	NUMBER	the dunning_status_no for the referenced record
CREATED_BATCH_ID	NUMBER	The aria facing creation batch id assigned upon landing for the referenced data
CREATED_BATCH_TSTAMP	TIMESTAMP_NTZ	The aria facing batch timstamp assigned upon landing for the referenced data, showing its creation in snowflake
UPDATED_BATCH_ID	NUMBER	The aria facing update batch id assigned upon landing for the referenced data
UPDATED_BATCH_TSTAMP	TIMESTAMP_NTZ	The aria facing batch timstamp assigned upon landing for the referenced data, showing its update in snowflake