Snowflake VM Object: Billing Groups
- ► Billing Groups
-
Field
Datatype
Description
UPDATED_BATCH_TSTAMP TIMESTAMP_NTZ The aria facing batch timstamp assigned upon landing for the referenced data, showing its update in snowflake 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 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 ACCOUNT_NO NUMBER The account number related to the customer referenced USERID TEXT The userid for login related to the customer referenced CLIENT_ACCOUNT_ID TEXT The clients unique identified for account related to the customer referenced NAME TEXT the name for the referenced record DESCRIPTION TEXT The detailed description related to the referenced data STATUS_NO NUMBER The clients status was updated at the timestamp for the customer referenced NOTIFY_METHOD_NO NUMBER the notify_method_no for the referenced record NOTIFICATION_TEMPLATE_GROUP_NO NUMBER the notification_template_group_no for the referenced record CLIENT_NOTIFICATION_TEMPLATE_GROUP_ID TEXT the client_notification_template_group_id for the referenced record PRIMARY_PAYMENT_METHOD_NO NUMBER the primary_payment_method_no for the referenced record CLIENT_PRIMARY_PAYMENT_METHOD_ID TEXT the client_primary_payment_method_id for the referenced record BACKUP_PAYMENT_METHOD_NO NUMBER the backup_payment_method_no for the referenced record CLIENT_BACKUP_PAYMENT_METHOD_ID TEXT the client_backup_payment_method_id for the referenced record STATEMENT_CONTACT_NO NUMBER the statement_contact_no for the referenced record PAYMENT_TERM_NO NUMBER the payment_term_no for the referenced record CLIENT_PAYMENT_TERM_ID TEXT the client_payment_term_id for the referenced record CREDIT_NOTE_TEMPLATE_NO NUMBER the credit_note_template_no for the referenced record CLIENT_CREDIT_NOTE_TEMPLATE_ID TEXT the client_credit_note_template_id for the referenced record EAN_GLN_NUM TEXT the ean_gln_num for the referenced record EAN_GLN_REQUISITION_NUM TEXT the ean_gln_requisition_num for the referenced record STATEMENT_TEMPLATE_NO NUMBER the statement_template_no for the referenced record CLIENT_STATEMENT_TEMPLATE_ID TEXT the client_statement_template_id for the referenced record CREDIT_MEMO_TEMPLATE_NO NUMBER the credit_memo_template_no for the referenced record CLIENT_CREDIT_MEMO_TEMPLATE_ID TEXT the client_credit_memo_template_id for the referenced record REBILL_TEMPLATE_NO NUMBER the rebill_template_no for the referenced record CLIENT_REBILL_TEMPLATE_ID TEXT the client_rebill_template_id for the referenced record CC_EMAIL_ADDRESSES VARIANT An embedded one to many JSON subrecord related to cc email addresses BCC_EMAIL_ADDRESSES VARIANT An embedded one to many JSON subrecord related to bcc email addresses COLLECTION_ACCOUNT_GROUPS VARIANT An embedded one to many JSON subrecord related to collection account groups 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 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