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