Snowflake VM Object: Queued Plan Instance Changes
- ► Queued Plan Instance Changes
-
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 QUEUE_NO NUMBER the queue_no for the referenced record ACCOUNT_NO NUMBER The account number related to the customer referenced USERID TEXT The userid for login related to the customer referenced AMOUNT NUMBER The amount of the referenced transaction value in the asociated currency ALL_RATES VARIANT An embedded one to many JSON subrecord related to all rates ALTERNATE_PLAN_INSTANCE_START_DATE DATE the alternate_plan_instance_start_date for the referenced record ALTERNATE_PRORATION_START_DATE DATE the alternate_proration_start_date for the referenced record AUTO_CANCEL_INCOMPATIBLE_SUPP_PLANS TEXT the auto_cancel_incompatible_supp_plans for the referenced record AUTO_OFFSET_MONTHS_OPTION TEXT the auto_offset_months_option for the referenced record BILLING_GROUP_NO NUMBER The designated billing group number for the referenced data CHANGE_TYPE_NO NUMBER the change_type_no for the referenced record COMMENTS TEXT The detailed comments related to the referenced data COUPON_CHANGES VARIANT An embedded one to many JSON subrecord related to coupon changes CREATED_TSTAMP TIMESTAMP_NTZ The original source system created timestamp for the referenced data CURRENT_PI_STATUS_LABEL TEXT the current_pi_status_label for the referenced record CURRENT_PLAN_NAME TEXT the current_plan_name for the referenced record CURRENT_PLAN_NO NUMBER the current_plan_no for the referenced record CURRENT_RATE_SCHEDULE_NO NUMBER the current_rate_schedule_no for the referenced record CURRENT_UNITS NUMBER the current_units for the referenced record EFFECTIVE_DATE DATE the effective_date for the referenced record EXECUTE_ON_ANNIVERSARY BOOLEAN the execute_on_anniversary for the referenced record FORCE_BILL_DATE_RESET BOOLEAN the force_bill_date_reset for the referenced record FORCE_MASTER_BILL_DATE_RESET BOOLEAN the force_master_bill_date_reset for the referenced record INVOICE_UNBILLED_USAGE NUMBER the invoice_unbilled_usage for the referenced record INVOICING_OPTION_NO NUMBER the invoicing_option_no for the referenced record NSO_BILL_IMMEDIATELY BOOLEAN the nso_bill_immediately for the referenced record NSO_ITEMS VARIANT An embedded one to many JSON subrecord related to nso items OFFSET_MONTHS NUMBER the offset_months for the referenced record OVERRIDE_BILL_THROUGH_DATE DATE the override_bill_through_date for the referenced record PARENT_CLIENT_PLAN_INSTANCE_ID TEXT the parent_client_plan_instance_id for the referenced record PLAN_INSTANCE_NO NUMBER The Aria facing unique identifier for a plan_instance CLIENT_PLAN_INSTANCE_ID TEXT The occurrence (instance) of a plan for the referenced data PLAN_INSTANCE_CHANGE_BILL_DAY NUMBER the plan_instance_change_bill_day for the referenced record PLAN_INSTANCE_CHANGE_BILL_LAG_DAYS NUMBER the plan_instance_change_bill_lag_days for the referenced record PLAN_INSTANCE_CHANGE_CLIENT_PLAN_INSTANCE_ID TEXT the plan_instance_change_client_plan_instance_id for the referenced record PLAN_INSTANCE_CHANGE_CUSTOM_RATES VARIANT An embedded one to many JSON subrecord related to plan_instance_change_custom_rates PLAN_INSTANCE_CHANGE_PLAN_NO NUMBER the plan_instance_change_plan_no for the referenced record PLAN_INSTANCE_CHANGE_CLIENT_PLAN_ID TEXT the plan_instance_change_client_plan_id for the referenced record PLAN_INSTANCE_DESCRIPTION TEXT the plan_instance_description for the referenced record PLAN_UNITS NUMBER the plan_units for the referenced record PROMOTION_CODE TEXT the promotion_code for the referenced record PURCHASE_ORDER_NUMBER TEXT The aria facing unique identifier for a purchase order SCHEDULE_NO NUMBER the schedule_no for the referenced record CLIENT_RATE_SCHEDULE_ID TEXT the client_rate_schedule_id for the referenced record PLAN_INSTANCE_CHANGE_STATUS_NO NUMBER the plan_instance_change_status_no for the referenced record PRODUCT_FIELD_CHANGES VARIANT An embedded one to many JSON subrecord related to product_field_changes PRORATION_DIRECTIVE_NO NUMBER the proration_directive_no for the referenced record PRORATION_INVOICE_TIMING_OPTION TEXT the proration_invoice_timing_option for the referenced record REMOVE_PLAN_INSTANCE_CUSTOM_RATES BOOLEAN the remove_plan_instance_custom_rates for the referenced record RETROACTIVE_START_DATE DATE the retroactive_start_date for the referenced record STATUS_NO NUMBER The clients status was updated at the timestamp for the customer referenced STATUS_UNTIL_ALTERNATE_START_DATE DATE the status_until_alternate_start_date for the referenced record SURCHARGE_CHANGES VARIANT An embedded one to many JSON subrecord related to surcharge_changes TARGET_PI_STATUS_LABEL TEXT the target_pi_status_label for the referenced record TARGET_PLAN_NAME TEXT the target_plan_name for the referenced record UPDATED_TSTAMP TIMESTAMP_NTZ The original source system updated timestamp for the referenced data 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
COUPON_CHANGES QUEUED_PLAN_INSTANCE_CHANGES VM_QPIC_COUPON_CHANGES NSO_ITEMS QUEUED_PLAN_INSTANCE_CHANGES VM_QPIC_NSO_ITEMS PIC_CUSTOM_RATES QUEUED_PLAN_INSTANCE_CHANGES VM_QPIC_PIC_CUSTOM_RATES PRODUCT_FIELDS_CHANGES QUEUED_PLAN_INSTANCE_CHANGES VM_QPIC_PFC_VALUES PRODUCT_FIELDS_CHANGES QUEUED_PLAN_INSTANCE_CHANGES VM_QPIC_PRODUCT_FIELD_CHANGES SURCHARGE_CHANGES QUEUED_PLAN_INSTANCE_CHANGES VM_QPIC_SURCHARGE_CHANGES