Skip to main content
Aria Knowledge Central

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
  • Was this article helpful?