Snowflake VM Object: Invoice Reversals
- ► Invoice Reversals
-
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 REVERSAL_NO NUMBER the reversal_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 AMOUNT NUMBER The amount of the referenced transaction value in the asociated currency COMMENTS TEXT The detailed comments related to the referenced data CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data CURRENCY_CD TEXT The ISO currency code of the referenced data LINES VARIANT An embedded one to many JSON subrecord related to lines TAX_DETAILS VARIANT An embedded one to many JSON subrecord related to tax 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