Snowflake VM Object: Orders
- ► Orders
-
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 ORDER_NO NUMBER the order_no for the referenced record ACCOUNT_NO NUMBER The account number related to the customer referenced CLIENT_ACCOUNT_ID TEXT The clients unique identified for account 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 CLIENT_ORDER_ID TEXT the client_order_id for the referenced record COMMENTS TEXT The detailed comments related to the referenced data CREATED_RECEIPT_ID TEXT the created_receipt_id for the referenced record CURRENCY_CD TEXT The ISO currency code of the referenced data FULFILL_DATE DATE the fulfill_date 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 CLIENT_PLAN_INSTANCE_ID TEXT The occurrence (instance) of a plan for the referenced data PLAN_INSTANCE_NO NUMBER The Aria facing unique identifier for a plan_instance PURCHASE_ORDER_NUMBER TEXT The aria facing unique identifier for a purchase order STATEMENT_MESSAGE TEXT the statement_message for the referenced record STATUS_NO NUMBER The clients status was updated at the timestamp for the customer referenced UPDATED_RECEIPT_ID TEXT the updated_receipt_id for the referenced record CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data 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 ORDERS