Skip to main content
Aria Knowledge Central

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

Child Views

Variant

Source Table

Child View Name

APPLICATIONS TRANSACTIONS  
TRANSACTION_SUPP_FIELDS TRANSACTIONS VM_TRANSACTION_SUPP_FIELDS
  • Was this article helpful?