Snowflake VM Object: Transactions
- ► Transactions
-
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 TRANSACTION_NO NUMBER the transaction_no for the referenced record TRANSACTION_TYPE_NO NUMBER the transaction_type_no for the referenced record CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data SOURCE_NO NUMBER the source_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 CURRENCY_CD TEXT The ISO currency code of the referenced data AMOUNT NUMBER The amount of the referenced transaction value in the asociated currency APPLIED_AMOUNT NUMBER The applied amount of the referenced transaction value in the asociated currency FULLY_APPLIED_TSTAMP TIMESTAMP_NTZ the fully_applied_tstamp for the referenced record STATEMENT_NO NUMBER the statement_no for the referenced record MASTER_PLAN_INSTANCE_NO NUMBER The Aria facing unique identifier for an master plan instance MASTER_CLIENT_PLAN_INSTANCE_ID TEXT The client facing unique identifier for an master plan instance API_RECEIPT_ID TEXT the api_receipt_id for the referenced record TRANSACTION_SUPP_FIELDS VARIANT An embedded one to many JSON subrecord related to transaction_supp_fields VOIDED_TRANSACTION_NO NUMBER the voided_transaction_no for the referenced record VOIDING_TRANSACTION_NO NUMBER the voiding_transaction_no for the referenced record APPLICATIONS VARIANT An embedded one to many JSON subrecord related to applications PAYMENT_TSTAMP TIMESTAMP_NTZ the payment_tstamp for the referenced record REFERENCE_ID TEXT the reference_id for the referenced record COLLECTION_STATUS_NO NUMBER the collection_status_no for the referenced record PAYMENT_METHOD_NO NUMBER the payment_method_no for the referenced record CLIENT_PAYMENT_METHOD_ID TEXT the client_payment_method_id for the referenced record PROCESSOR_PAYMENT_ID TEXT the processor_payment_id for the referenced record PAYMENT_PROCESSOR_NO NUMBER the payment_processor_no for the referenced record PAYMENT_METHOD_TYPE_NO NUMBER the payment_method_type_no for the referenced record PROCESSOR_STATUS_CD TEXT the processor_status_cd for the referenced record PROCESSOR_STATUS_LABEL TEXT the processor_status_label for the referenced record 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