Snowflake VC Object: Billing Groups

Last updated
Save as PDF

► Billing Groups

FIeld	Datatype	Description
CLIENT_NO	NUMBER	CLIENT_NO uniquely identifying each unique client
BATCH_ID	NUMBER	BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID	NUMBER	CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP	TIMESTAMP_NTZ	EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID	TEXT	EVENT_ID for the change JSON record
CREATETIME	NUMBER	CREATETIME createtime of the changed JSON record
ACTIONS	TEXT	ACTIONS for create, load, update, delete determining processing behavior for the record.
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
BILLING_GROUP_NO	NUMBER	The designated billing group number for the referenced data.
CLIENT_BILLING_GROUP_ID	TEXT	The client_billing_group_id for the referenced record
NAME	TEXT	The billing groups name
DESCRIPTION	TEXT	A verbose description of the billing group.
STATUS_NO	NUMBER	The clients status number on their account for the customer referenced
NOTIFY_METHOD_NO	NUMBER	The unique identifier for a notify method number.
NOTIFICATION_TEMPLATE_GROUP_NO	NUMBER	The unique identifier for a notification template group number.
PRIMARY_PAYMENT_METHOD_NO	NUMBER	The unique identifier for a primary payment method number.
BACKUP_PAYMENT_METHOD_NO	NUMBER	The unique identifier for a backup payment method number.
STATEMENT_CONTACT_NO	NUMBER	The unique identifier for a statement contact number.
PAYMENT_TERM_NO	NUMBER	The payment_term_no for the referenced record.
CREDIT_NOTE_TEMPLATE_NO	NUMBER	The unique identifier for a credit note template number.
EAN_GLN_NUM	TEXT	The EAN or GLN number.
EAN_GLN_REQUISITION_NUM	TEXT	The EAN or GLN requisition number.
STATEMENT_TEMPLATE_NO	NUMBER	The unique identifier for a statement template number.
CREDIT_MEMO_TEMPLATE_NO	NUMBER	The unique identifier for a credit memo template number.
REBILL_TEMPLATE_NO	NUMBER	The unique identifier for a rebill template number.