Snowflake VM Object: Queued Plan Instance Changes

Last updated
Save as PDF

► 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