Snowflake VM Object: Recurring Credits
- ► Recurring 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 RECURRING_CREDIT_NO NUMBER the recurring_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 CANCEL_COMMENTS TEXT the cancel_comments for the referenced record CANCEL_DATE DATE the cancel_date for the referenced record COMMENTS TEXT The detailed comments related to the referenced data CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data CREDIT_INTERVAL_MONTHS NUMBER the credit_interval_months for the referenced record CREDIT_SERVICE TEXT the credit_service for the referenced record CURRENCY_CD TEXT The ISO currency code of the referenced data ELIGIBLE_PLAN_INSTANCES VARIANT An embedded one to many JSON subrecord related to eligible plan instances ELIGIBLE_PLANS VARIANT An embedded one to many JSON subrecord related to eligible plans ELIGIBLE_SERVICE_TYPES VARIANT An embedded one to many JSON subrecord related to eligible service types EXPIRATION_DATE DATE the expiration_date for the referenced record EXPIRATION_MONTHS NUMBER the expiration_months for the referenced record EXPIRATION_TYPE_INDICATOR TEXT the expiration_type_indicator for the referenced record FIRST_CREDIT_DATE DATE the first_credit_date for the referenced record LAST_CREDIT_DATE DATE the last_credit_date 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 NEXT_CREDIT_DATE DATE the next_credit_date for the referenced record NUMBER_OF_CREDITS_REMAINING NUMBER the number_of_credits_remaining for the referenced record NUMBER_OF_CREDITS_REQUIRED NUMBER the number_of_credits_required for the referenced record PERCENTAGE_SOURCE_PLAN NUMBER the percentage_source_plan for the referenced record PERCENTAGE_SOURCE_SERVICE NUMBER the percentage_source_service for the referenced record REASON_NO NUMBER the reason_no for the referenced record RECURRING_CREDIT_AMOUNT NUMBER the recurring_credit_amount for the referenced record RECURRING_CREDIT_TYPE_NO NUMBER the recurring_credit_type_no for the referenced record SOURCE_COUPON TEXT the source_coupon for the referenced record STATUS_NO NUMBER The clients status was updated at the timestamp for the customer referenced 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
ELIGIBLE_PLANS RECURRING_CREDITS VM_RC_ELIGIBLE_PLANS ELIGIBLE_PLAN_INSTANCES RECURRING_CREDITS VM_RC_ELIGIBLE_PLAN_INSTANCES ELIGIBLE_SERVICE_TYPES RECURRING_CREDITS VM_RC_ELIGIBLE_SERVICE_TYPES