Snowflake VM Object: Credit Memos
- ► Credit Memos
-
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 CREDIT_MEMO_NO NUMBER the credit_memo_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 CREDIT_REASON_NO NUMBER the credit_reason_no for the referenced record CREDIT_REF_TYPE_NO NUMBER the credit_ref_type_no for the referenced record CURRENCY_CD TEXT The ISO currency code of the referenced data CUSTOMER_NOTE TEXT the customer_note for the referenced record INVOICE_NO NUMBER The aria facing unique identifier for an invoice 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 Child Views Variant
Source Table
Child View Name
LINES CREDIT_MEMOS VM_CM_LINES TAX_DETAILS CREDIT_MEMOS VM_CM_TAX_DETAILS