Snowflake VM Object: Plan Rate Schedules
- ► Plan Rate Schedules
-
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 SCHEDULE_NO NUMBER the schedule_no for the referenced record CLIENT_RATE_SCHEDULE_ID TEXT the client_rate_schedule_id for the referenced record AVAILABLE_FROM_DATE DATE the available_from_date for the referenced record AVAILABLE_TO_DATE DATE the available_to_date for the referenced record CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data CURRENCY_CODE TEXT the currency_code for the referenced record FOLLOWUP_DEFAULT_RATE_SCHEDULE TEXT the followup_default_rate_schedule for the referenced record IS_DEFAULT_FOR_CURRENCY BOOLEAN A True or False indicator showing if the record is the default for currency LOCALE_DETAILS VARIANT An embedded one to many JSON subrecord related to the records locale NAME TEXT the name for the referenced record QUEUED_RATE_CHANGE_DATE DATE the queued_rate_change_date for the referenced record RECURRING_BILLING_INTERVAL_TYPE NUMBER the recurring_billing_interval_type for the referenced record RECURRING_BILLING_INTERVAL_TYPE_NO NUMBER the recurring_billing_interval_type_no for the referenced record TIERS VARIANT An embedded one to many JSON subrecord related to tiers USAGE_BILLING_INTERVAL_TYPE NUMBER the usage_billing_interval_type for the referenced record USAGE_BILLING_INTERVAL_TYPE_NO NUMBER the usage_billing_interval_type_no 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
LOCALE_DETAILS PLAN_RATE_SCHEDULES VM_PRS_LOCALE_DETAILS TIERS PLAN_RATE_SCHEDULES VM_PRS_TIERS TIERS PLAN_RATE_SCHEDULES VM_PRS_TIERS_LOCALE_DETAILS