Skip to main content
Aria Knowledge Central

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