Snowflake VC Object: Transactions
- ► Transactions
-
Field
Datatype
Description
CLIENT_NO NUMBER CLIENT_NO uniquely identifying each unique client BATCH_ID NUMBER BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI CHG_ID NUMBER CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number EVENT_TSTAMP TIMESTAMP_NTZ EVENT_TSTAMP of the JSON record showing when the change was generated EVENT_ID TEXT EVENT_ID for the change JSON record CREATETIME NUMBER CREATETIME createtime of the changed JSON record ACTIONS TEXT ACTIONS for create, load, update, delete determining processing behavior for the record. TRANSACTION_NO NUMBER The unique identifier for a transaction. TRANSACTION_TYPE_NO NUMBER The unique identifier for a transaction type number. CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data. SOURCE_NO NUMBER The source number. 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 currency code for the referenced record. AMOUNT NUMBER The currency amount. APPLIED_AMOUNT NUMBER The currency applied amount. FULLY_APPLIED_TSTAMP TIMESTAMP_NTZ The timestamp of the fully applied milestone. STATEMENT_NO NUMBER The statement_no for the referenced record. MASTER_PLAN_INSTANCE_NO NUMBER The master_plan_instance_no for the referenced record. CLIENT_MASTER_PLAN_INSTANCE_ID TEXT The unique identifier for a client master plan instance. API_RECEIPT_ID TEXT The API receipt id. VOIDED_TRANSACTION_NO NUMBER The unique identifier for a voided transaction. VOIDING_TRANSACTION_NO NUMBER The unique identifier for a voiding transaction. PAYMENT_TSTAMP TIMESTAMP_NTZ The timestamp of the payment milestone. REFERENCE_ID TEXT The reference id. COLLECTION_STATUS_NO NUMBER The unique identifier for a collection status number. PAYMENT_METHOD_NO NUMBER The unique identifier for a payment method number. CLIENT_PAYMENT_METHOD_ID TEXT The unique identifier for a client payment method id. PROCESSOR_PAYMENT_ID TEXT The transaction processers payment id. PAYMENT_PROCESSOR_NO NUMBER The unique identifier for a payment processor id. PAYMENT_METHOD_TYPE_NO NUMBER The unique identifier for a payment method type number. PROCESSOR_STATUS_CD TEXT The processor status code. PROCESSOR_STATUS_LABEL TEXT The processor status label. INVOICE_NO NUMBER The Aria facing unique identifier for an invoice. LINE_NO NUMBER The unique identifier for an invoice line. PLAN_NO NUMBER The plan_no for the referenced record CLIENT_PLAN_ID TEXT The unique identifier for a client plan record. PLAN_INSTANCE_NO NUMBER The plan_instance_no for the referenced record. CLIENT_PLAN_INSTANCE_ID TEXT The unique identifier for a client plan instance id. SERVICE_NO NUMBER The service_no for the referenced record. CLIENT_SERVICE_ID TEXT The unique identifier for the client service id. USAGE_TYPE_NO NUMBER The unique identifier for a usage_type record. USAGE_TYPE_CD TEXT The unique code for a usage_type record. ORDER_NO NUMBER The unique identifier for an order. ORDER_LINE_NO NUMBER The unique identifier for an order line. SURCHARGE_NO NUMBER The surcharge_no for the referenced record. PLAN_RATE_SCHEDULE_NO NUMBER The plan_rate_rate_schedule_no for the referenced record. CLIENT_PLAN_RATE_SCHEDULE_ID TEXT The client_plan_rate_rate_schedule_id for the referenced record. PLAN_RATE_SCHEDULE_SERVICE_TIER NUMBER The plan rate schedule service tier. SERVICE_CREDIT_NO NUMBER The unique identifier for a service credit number. SERVICE_CREDIT_SOURCE_TRANSACTION_NO NUMBER The unique identifier for a service credit source transaction. SERVICE_CREDIT_TARGET_TRANSACTION_NO NUMBER The unique identifier for a service credit target transaction. CREDIT_COUPON_CODE TEXT The credit coupon code. CREDIT_REASON_NO NUMBER The unique identifier for a credit reason number. PURCHASE_ORDER_NUMBER TEXT The purchase order number. START_DATE DATE The start date. END_DATE DATE The end date. RATE NUMBER The rate for the referenced data. UNITS NUMBER The quantity of units for the referenced data. BASE_PLAN_UNITS NUMBER The quantity of base plan units for the referenced data. PROMPT_PAYMENT_DISCOUNT_AMOUNT NUMBER The currency prompt payment discount amount. PROMPT_PAYMENT_DISCOUNT_CUTOFF_DATE DATE The date the prompt payment discount is cutoff. PRORATION_FACTOR NUMBER The proration factor. PRORATION_DESCRIPTION TEXT A verbose proration description of the record referenced. PRORATION_REMAINING_DAYS NUMBER The number of days for proration. ADVANCE_BILLING_PERIOD_TOTAL_DAYS NUMBER The advanced billing period totals days. IS_TAX_RELATED BOOLEAN Is the record tax related? COMMENTS TEXT A verbose explanation of details related to the referenced data. SURCHARGE_RATE_SCHEDULE_NO NUMBER The surcharge_rate_rate_schedule_no for the referenced record. SURCHARGE_RATE_SCHEDULE_TIER NUMBER The surcharge_rate_rate_schedule_tier for the referenced record. PRORATION_OPERATION_TYPE_NO NUMBER The unique identifier for a proration operation type number. IS_CUSTOM_RATED BOOLEAN Is the record custom rated? FROM_ACCOUNT_NO NUMBER The unique identifier for a from account number. FROM_CLIENT_ACCOUNT_ID TEXT The unique identifier for a from client account id. FROM_MASTER_PLAN_INSTANCE_NO NUMBER The from_master_plan_instance_no for the referenced record. FROM_CLIENT_MASTER_PLAN_INSTANCE_ID TEXT The unique identifier for a from client master plan instance. TO_ACCOUNT_NO NUMBER The unique identifier for the to account number. TO_CLIENT_ACCOUNT_ID TEXT The unique identifier for the to client account id. TO_MASTER_PLAN_INSTANCE_NO NUMBER The to_master_plan_instance_no for the referenced record. TO_CLIENT_MASTER_PLAN_INSTANCE_ID TEXT The unique identifier for a to client master plan instance. WRITE_OFF_TSTAMP TIMESTAMP_NTZ The timestamp of the write off. WRITE_OFF_REASON_NO NUMBER The unique identifier for the write off reason number. SECONDARY_WRITE_OFF_REASON_NO NUMBER The unique identifier for a secondary write off reason number. DISPUTE_HOLD_EXPIRE_DAYS NUMBER The number of holds days during a dispute. REFUND_REASON_NO NUMBER The unique identifier for a refund reason number. REVERSAL_NO NUMBER The unique identifier for the reversal number. PROCESSED_TSTAMP TIMESTAMP_NTZ The timestamp for the processing milestone. CREDIT_MEMO_NO NUMBER The unique identifier for a credit memo number. INVOICE_LINE_TRANSACTION_NO NUMBER The unique identifier for a invoice line transaction.