Skip to main content
Aria Knowledge Central

Snowflake VM Object: Surcharges

► Surcharges

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
CLIENT_SURCHARGE_ID TEXT the client_surcharge_id for the referenced record
APPLICATION_SCOPE_NO NUMBER the application_scope_no for the referenced record
ASSIGNMENT_LEVEL_NO NUMBER the assignment_level_no for the referenced record
CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data
DESCRIPTION TEXT The detailed description related to the referenced data
EXTERNAL_DESCRIPTION TEXT the external_description for the referenced record
IS_APPLIED_BEFORE_DISCOUNT BOOLEAN the is_applied_before_discount for the referenced record
IS_INLINE_SURCHARGE BOOLEAN A True or False indicator showing if the record is an inline surcharge
LOCALE_DETAILS VARIANT An embedded one to many JSON subrecord related to the records locale
SURCHARGE_NAME TEXT the surcharge_name for the referenced record
NONSUBSCRIPTION_OFFERINGS VARIANT An embedded one to many JSON subrecord related to nonsubscription offerings
PLAN_SERVICE_DETAILS VARIANT An embedded one to many JSON subrecord related to plan_service_details
PLANS VARIANT An embedded one to many JSON subrecord related to plans
RATE_CALCULATION_TYPE TEXT the rate_calculation_type for the referenced record
SERVICES VARIANT An embedded one to many JSON subrecord related to services
SURCHARGE_RATE_SCHEDULES VARIANT An embedded one to many JSON subrecord related to surcharge_rate_schedules
TAX_SERVICE_GROUP TEXT the tax_service_group 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 SURCHARGES VM_SURCHARGE_LOCALE_DETAILS
NONSUBSCRIPTION_OFFERINGS SURCHARGES VM_SURCHARGE_NONSUBSCRIPTION_OFFERINGS
PLANS SURCHARGES VM_SURCHARGE_PLANS
PLAN_SERVICE_DETAILS SURCHARGES VM_SPSD_SERVICES
PLAN_SERVICE_DETAILS SURCHARGES VM_SURCHARGE_PLAN_SERVICE_DETAILS
SERVICES SURCHARGES VM_SURCHARGE_SERVICES
SURCHARGE_RATE_SCHEDULES SURCHARGES VM_SURCHARGE_SURCHARGE_RATE_SCHEDULES
  • Was this article helpful?