Snowflake VM Object: Surcharge Rate Schedules
- ► Surcharge 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 SURCHARGE_NO NUMBER the surcharge_no for the referenced record SCHEDULE_NO NUMBER the schedule_no for the referenced record CURRENCY_CODE TEXT the currency_code for the referenced record INCLUDE_ZERO_IN_RATE_TIER BOOLEAN the include_zero_in_rate_tier 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 MINIMUM_SURCHARGE_TO_APPLY NUMBER the minimum_surcharge_to_apply for the referenced record NAME TEXT the name for the referenced record SURCHARGE_RATE_SCHEDULE_TIERS VARIANT An embedded one to many JSON subrecord related to surcharge_rate_schedule_tiers 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 SURCHARGE_RATE_SCHEDULES VM_SRS_LOCALE_DETAILS SURCHARGE_RATE_SCHEDULE_TIERS SURCHARGE_RATE_SCHEDULES VM_SRS_TIERS SURCHARGE_RATE_SCHEDULE_TIERS SURCHARGE_RATE_SCHEDULES VM_SRS_TIERS_LOCALE_DETAILS