Snowflake VC Object: Invoices
- ► Invoices
-
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 USERID TEXT The userid for login related to the customer referenced INVOICE_NO NUMBER The Aria facing unique identifier for an invoice. STATUS_NO NUMBER The clients status number on their account for the customer referenced BILLING_GROUP_NO NUMBER The designated billing group number for the referenced data. STATEMENT_NO NUMBER The statement_no for the referenced record. ORIGINAL_INVOICE_NO NUMBER The Aria facing unique identifier for an original invoice. REBILL_INVOICE_NO NUMBER The Aria facing unique identifier for an rebill invoice. REBILL_REASON_NO NUMBER The unique identifier for a rebill reason number. TAXATION_ADDRESS_CONTACT_NO NUMBER The unique identifier for a taxation address contact number. RECURRING_BILL_FROM DATE The recurring billing from date. RECURRING_BILL_THROUGH DATE The recurring billing through date. USAGE_FROM DATE The usage from date. USAGE_THROUGH DATE The usage through date. CURRENCY_CD TEXT The default_currency_cd for the referenced record. AMOUNT NUMBER The currency amount. INVOICE_BALANCE_FORWARD NUMBER The invoice forwarded balance currency amount. TOTAL_DUE NUMBER The total currency amount due. BILLED_TSTAMP TIMESTAMP_NTZ The timestamp of the billed milestone. PAID_TSTAMP TIMESTAMP_NTZ The timestamp of the paid milestone. CUSTOM_STATUS_LABEL TEXT A verbose custom status label of the invoices. CUSTOM_STATUS_DESCRIPTION TEXT A verbose custom status description of the invoices. INVOICE_COMMENTS TEXT A verbose explanation of details related to the invoice. ADDITIONAL_COMMENTS TEXT A verbose explanation of additional comments. CLIENT_NOTES TEXT A verbose explanation of client comments. 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. INVOICE_USAGE_STATUS_CD TEXT The invoice usage status code. INVOICE_TYPE_CD TEXT The invoice usage type code. Child ViewsChild ViewsChild Views Variant
Source Table
Child View Nam
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