Snowflake VM Object: Service Credits
- ► Service Credits
-
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 CREDIT_NO NUMBER the credit_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 AMOUNT NUMBER The amount of the referenced transaction value in the asociated currency AMOUNT_REVERSED_FOR_ANNIVERSARY NUMBER the amount_reversed_for_anniversary for the referenced record CANCEL_USER TEXT the cancel_user for the referenced record CANCELLED_TSTAMP TIMESTAMP_NTZ The original source system cancelled timestamp for the referenced data COMMENTS TEXT The detailed comments related to the referenced data CREATE_USER TEXT the create_user for the referenced record CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data CREDIT_REASON_NO NUMBER the credit_reason_no for the referenced record CREDIT_SERVICE_NO NUMBER the credit_service_no for the referenced record CREDIT_CLIENT_SERVICE_ID TEXT the credit_client_service_id for the referenced record CURRENCY_CODE TEXT the currency_code for the referenced record EXPIRY_MONTHS NUMBER the expiry_months for the referenced record EXPIRY_TSTAMP TIMESTAMP_NTZ the expiry_tstamp for the referenced record IS_ORDER_BASED BOOLEAN A True or False indicator showing if the record is the order based MASTER_PLAN_INSTANCE_NO NUMBER The Aria facing unique identifier for an master plan instance MASTER_CLIENT_PLAN_INSTANCE_NO TEXT the master_client_plan_instance_no for the referenced record ORIGINATING_COUPON TEXT the originating_coupon for the referenced record ORIGINATING_INVOICE_LINE_TRANSACTION_NO NUMBER the originating_invoice_line_transaction_no for the referenced record ORIGINATING_RECURRING_CREDIT NUMBER the originating_recurring_credit for the referenced record REMAINING_DAYS_WHEN_PRORATED NUMBER the remaining_days_when_prorated for the referenced record SERVICE_CREDIT_ELIGIBILITIES VARIANT An embedded one to many JSON subrecord related to service_credit_eligibilities TOTAL_DAYS_WHEN_PRORATED NUMBER the total_days_when_prorated for the referenced record UNCONSUMED_AMOUNT NUMBER the unconsumed_amount for the referenced record USE_CHARGE_SERVICE BOOLEAN the use_charge_service 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
SERVICE_CREDIT_ELIGIBILITIES SERVICE_CREDITS VM_SC_SERVICE_CREDIT_ELIGIBILITIES