Skip to main content
Aria Knowledge Central

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