Snowflake VM Object: Invoices
- ► Invoices
-
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 INVOICE_NO NUMBER The aria facing unique identifier for an invoice STATUS_NO NUMBER The clients status was updated at the timestamp for the customer referenced INVOICE_TYPE_CD TEXT the invoice_type_cd 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 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 STATEMENT_NO VARIANT the statement_no for the referenced record ORIGINAL_INVOICE_NO NUMBER the original_invoice_no for the referenced record REBILL_INVOICE_NO NUMBER the rebill_invoice_no for the referenced record REBILL_REASON_NO NUMBER the rebill_reason_no for the referenced record TAXATION_ADDRESS_CONTACT_NO VARIANT the taxation_address_contact_no for the referenced record RECURRING_BILL_FROM DATE the recurring_bill_from for the referenced record RECURRING_BILL_THROUGH DATE the recurring_bill_through for the referenced record USAGE_FROM DATE the usage_from for the referenced record USAGE_THROUGH DATE the usage_through for the referenced record CURRENCY_CD TEXT The ISO currency code of the referenced data AMOUNT NUMBER The amount of the referenced transaction value in the asociated currency INVOICE_BALANCE_FORWARD NUMBER the invoice_balance_forward for the referenced record TOTAL_DUE NUMBER the total_due for the referenced record BILLED_TSTAMP TIMESTAMP_NTZ the billed_tstamp for the referenced record PAID_TSTAMP TIMESTAMP_NTZ the paid_tstamp for the referenced record CUSTOM_STATUS_LABEL TEXT the custom_status_label for the referenced record CUSTOM_STATUS_DESCRIPTION TEXT the custom_status_description for the referenced record INVOICE_COMMENTS TEXT the invoice_comments for the referenced record ADDITIONAL_COMMENTS TEXT The additional comments related to the referenced data CLIENT_NOTES TEXT the client_notes for the referenced record CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data LINES VARIANT An embedded one to many JSON subrecord related to lines PENDING_LINES VARIANT An embedded one to many JSON subrecord related to pending_lines TAX_DETAILS VARIANT An embedded one to many JSON subrecord related to tax details PENDING_TAX_DETAILS VARIANT An embedded one to many JSON subrecord related to pending_tax_details INVOICE_USAGE_STATUS_CD TEXT the invoice_usage_status_cd for the referenced record DISCOUNT_DETAILS VARIANT An embedded one to many JSON subrecord related to discount details PENDING_DISCOUNT_DETAILS VARIANT An embedded one to many JSON subrecord related to pending_discount_details SURCHARGE_DETAILS VARIANT An embedded one to many JSON subrecord related to surcharge_details PENDING_SURCHARGE_DETAILS VARIANT An embedded one to many JSON subrecord related to pending_surcharge_details 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
DISCOUNT_DETAILS INVOICES VM_INVOICE_DISCOUNT_DETAILS LINES INVOICES VM_INVOICE_LINES PENDING_DISCOUNT_DETAILS INVOICES VM_INVOICE_PENDING_DISCOUNT_DETAILS PENDING_LINES INVOICES VM_INVOICE_PENDING_LINES PENDING_SURCHARGE_DETAILS INVOICES VM_INVOICE_PENDING_SURCHARGE_DETAILS PENDING_TAX_DETAILS INVOICES VM_INVOICE_PENDING_TAX_DETAILS SURCHARGE_DETAILS INVOICES VM_INVOICE_SURCHARGE_DETAILS TAX_DETAILS INVOICES VM_INVOICE_TAX_DETAILS