Snowflake VC 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
BATCH_ID	NUMBER	BATCH_ID uniquely identifying each batch run by numeric format YYYYMMDDHH24MI
CHG_ID	NUMBER	CHG_ID uniquely identifying each changed record sort to be processed in soonest first order of the format YYYYMMDDHH24MI and a sequence number
EVENT_TSTAMP	TIMESTAMP_NTZ	EVENT_TSTAMP of the JSON record showing when the change was generated
EVENT_ID	TEXT	EVENT_ID for the change JSON record
CREATETIME	NUMBER	CREATETIME createtime of the changed JSON record
ACTIONS	TEXT	ACTIONS for create, load, update, delete determining processing behavior for the record.
QUEUE_NO	NUMBER	The unique indentifier for the queue
ACCOUNT_NO	NUMBER	The account number related to the customer referenced
USERID	TEXT	The userid for login related to the customer referenced
CLIENT_ACCOUNT_ID	TEXT	The clients unique identified for account related to the customer referenced
ALTERNATE_PLAN_INSTANCE_START_DATE	DATE	The date of the alternate plan instance start milestone.
ALTERNATE_PRORATION_START_DATE	DATE	The date of the alternate proration start milestone.
AUTO_CANCEL_INCOMPATIBLE_SUPP_PLANS	BOOLEAN	Auotmatically cancel incompatible supplemental plans.
AUTO_OFFSET_MONTHS_OPTION_NO	NUMBER	The unique identifier for a auto offset months option number.
CHANGE_TYPE_NO	NUMBER	The unique identifier for a change type number.
COMMENTS	TEXT	A verbose explanation of details related to the referenced data.
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data.
EFFECTIVE_DATE	DATE	The date the record goes into effect.
EXECUTE_ON_ANNIVERSARY	BOOLEAN	Execute the queued plan on the anniversary.
FORCE_BILL_DATE_RESET_NO	NUMBER	The unique identifier for the force bill reset date
FORCE_MASTER_BILL_DATE_RESET_NO	NUMBER	The unique identifier for the force master bill reset date
INVOICE_UNBILLED_USAGE	BOOLEAN	The unbilled invoice usage.
INVOICING_OPTION_NO	NUMBER	The unique identifier for a invoice option number.
NSO_BILL_IMMEDIATELY	BOOLEAN	Bill immediately on the NSO
OFFSET_MONTHS	NUMBER	The number of offset months.
OVERRIDE_BILL_THROUGH_DATE	DATE	The date of the override bill through date milestone.
PLAN_INSTANCE_NO	NUMBER	The parent_plan_instance_no for the referenced record.
CLIENT_PLAN_INSTANCE_ID	TEXT	The unique identifier for a client plan instance id.
PIC_BILL_DAY	NUMBER	The PIC billing day.
PIC_BILL_LAG_DAYS	NUMBER	The PIC billing lag days.
PIC_CLIENT_PLAN_INSTANCE_ID	TEXT	The unique identifier for a pic client plan instance id.
PIC_PLAN_NO	NUMBER	The pic_plan_no for the referenced record
PIC_PLAN_UNITS	NUMBER	The quantity of plan units for the referenced data.
PIC_PURCHASE_ORDER_NUMBER	TEXT	The pic purchase order number.
PIC_PROMOTION_CODE	TEXT	The pic promotion code.
PIC_CLIENT_PLAN_ID	TEXT	The unique identifier for a pic client plan record.
PIC_PLAN_INSTANCE_STATUS_NO	NUMBER	The unique identifier for a pic plan instance status number.
PIC_PLAN_RATE_SCHEDULE_NO	NUMBER	The pic_plan_rate_schedule_no for the referenced record.
PIC_CLIENT_PLAN_RATE_SCHEDULE_ID	TEXT	The client_plan_rate_rate_schedule_id for the referenced record.
PIC_PLAN_INSTANCE_DESCRIPTION	TEXT	A verbose pic plan instance description.
PRORATION_DIRECTIVE_NO	NUMBER	The unique identifier for a proration directive number.
PRORATION_INVOICE_TIMING_OPTION_NO	NUMBER	The unique identifier for a proration invoice timing option number.
REMOVE_PLAN_INSTANCE_CUSTOM_RATES	BOOLEAN	Remove the plan instance custom rates.
RETROACTIVE_START_DATE	DATE	The retroactive start date.
STATUS_NO	NUMBER	The unique identifier for a status number.
STATUS_NO_UNTIL_ALTERNATE_START_DATE	NUMBER	The date the status no alternative starts.
UPDATED_TSTAMP	TIMESTAMP_NTZ	The original source system updated timestamp for the referenced data.