Snowflake VM Object: Transaction Applications
- ► Transaction Applications
-
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 APPLICATION_NO NUMBER the application_no for the referenced record PAYMENT_TRANSACTION_NO NUMBER the payment_transaction_no for the referenced record CHARGE_TRANSACTION_NO NUMBER the charge_transaction_no for the referenced record CREATED_TSTAMP DATE The original source system created timestamp for the referenced data APPLIED_AMOUNT NUMBER The applied amount of the referenced transaction value in the asociated currency 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 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 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