Snowflake VM Object: Transactions

Last updated
Save as PDF

► 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