Snowflake VM Object: Statements
- ► Statements
-
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 STATEMENT_NO NUMBER the statement_no 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 INVOICE_NO NUMBER The aria facing unique identifier for an invoice BILLING_GROUP_NO NUMBER The designated billing group number for the referenced data PAYMENT_METHOD_NO NUMBER the payment_method_no for the referenced record MASTER_PLAN_INSTANCES VARIANT An embedded one to many JSON subrecord related to master plan instances SEQ_STATEMENT_ID TEXT the seq_statement_id for the referenced record STATEMENT_CONTACT_NO NUMBER the statement_contact_no for the referenced record CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data DUE_DATE DATE the due_date for the referenced record DUE_DATE_PLUS_GRACE_PERIOD DATE the due_date_plus_grace_period for the referenced record SENT_TSTAMP TIMESTAMP_NTZ the sent_tstamp for the referenced record RESENT_TSTAMP TIMESTAMP_NTZ the resent_tstamp for the referenced record STATUS_NO NUMBER The clients status was updated at the timestamp for the customer referenced IS_REBILL BOOLEAN A True or False indicator showing if the record is a rebill CURRENCY_CD TEXT The ISO currency code of the referenced data NEW_CHARGES_AMOUNT NUMBER the new_charges_amount for the referenced record NEW_PAYMENTS_AMOUNT NUMBER the new_payments_amount for the referenced record BALANCE_FORWARD_AMOUNT NUMBER the balance_forward_amount for the referenced record TOTAL_OWED NUMBER the total_owed for the referenced record UNAPPLIED_CREDIT_BALANCE NUMBER the unapplied_credit_balance for the referenced record UNAPPLIED_PAYMENT_BALANCE NUMBER the unapplied_payment_balance for the referenced record TRANSACTIONS VARIANT the transactions for the referenced record MPI_TRANSFERS_IN VARIANT An embedded one to many JSON subrecord related to MPI transfers in MPI_TRANSFERS_OUT VARIANT An embedded one to many JSON subrecord related to MPI transfers out 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
MASTER_PLAN_INSTANCES STATEMENTS VM_STATEMENT_MASTER_PLAN_INSTANCES MPI_TRANSFERS_IN STATEMENTS VM_STATEMENT_MPI_TRANSFERS_IN MPI_TRANSFERS_OUT STATEMENTS VM_STATEMENT_MPI_TRANSFERS_OUT TRANSACTIONS STATEMENTS VM_STATEMENT_TRANSACTIONS