Snowflake VC Object: Billing Groups
- ► 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. Child Views Variant
Source Table
Child View Name
BCC_EMAIL_ADDRESSES BILLING_GROUPS VM_BG_BCC_EMAIL_ADDRESSES CC_EMAIL_ADDRESSES BILLING_GROUPS VM_BG_CC_EMAIL_ADDRESSES COLLECTION_ACCOUNT_GROUPS BILLING_GROUPS VM_BG_COLLECTION_ACCOUNT_GROUPS