Snowflake VC Object: Plans

Last updated
Save as PDF

► Plans

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.
PLAN_NO	NUMBER	The plan_no for the referenced record
CLIENT_PLAN_ID	TEXT	The unique identifier for a client plan record.
NAME	TEXT	The plan name.
DESCRIPTION	TEXT	A verbose description of the plan.
IS_ACTIVE	BOOLEAN	Is the refernced data active?
IS_SUPPLEMENTAL_PLAN	BOOLEAN	Is the referenced data a supplemental plan?
IS_TEMPLATE	BOOLEAN	Is the referenced data a template?
PRORATION_INVOICE_TIMING_CD	NUMBER	The proration invoice timing code.
STATEMENT_TEMPLATE_NO	NUMBER	The unique identifier for a statement template number.
NOTIFICATION_TEMPLATE_GROUP_NO	NUMBER	The unique identifier for a notification template group number.
CREDIT_NOTE_TEMPLATE_NO	NUMBER	The unique identifier for a credit note template number.
CREDIT_MEMO_TEMPLATE_NO	NUMBER	The unique identifier for a credit memo template number.
REBILL_TEMPLATE_NO	NUMBER	The unique identifier for a rebill template number.
HAS_PLAN_CANCELLATION_FEE	BOOLEAN	Does the plan have a cancellation fee?
CANCELLATION_MINIMUM_MONTHS	NUMBER	The minimum number of months before cancellation is allowed.
NONSUBSCRIPTION_OFFERING_BUNDLE_TYPE_CD	TEXT	The nonsubscription offering bundle type code.
AVAILABLE_NONSUBSCRIPTION_OFFERING_SCOPE_IND	NUMBER	The nonsubscription offering bundle scope indicator code.
DEFAULT_CURRENCY_CD	TEXT	The default_currency_cd for the referenced record.
INITIAL_FREE_PERIOD_QUANTITY	NUMBER	The qunatity of the initial free period.
INITIAL_FREE_PERIOD_TYPE_NO	NUMBER	The unique identifier for a initial free period type number.
INITIAL_PLAN_INSTANCE_STATUS_NO	NUMBER	The unique identifier for a initial plan instance status number.
PLAN_INSTANCE_STATUS_ROLLOVER_PERIOD_QUANTITY	NUMBER	The qunatity of the plan instance rollover period.
PLAN_INSTANCE_STATUS_ROLLOVER_PERIOD_TYPE_NO	NUMBER	The unique identifier for a plan instance status rollover period type number.
ROLLOVER_PLAN_INSTANCE_STATUS_NO	NUMBER	The unique identifier for a rollover plan instance status number.
ROLLOVER_PLAN_NO	NUMBER	The rollover_plan_no for the referenced record
ROLLOVER_PLAN_PERIOD_QUANTITY	NUMBER	The quantity of the rollover plan period.
ROLLOVER_PLAN_PERIOD_TYPE_NO	NUMBER	The unique identifier for a rollover plan period type number.
CONTRACT_COMPLETION_ROLLOVER_PLAN_NO	NUMBER	The contract_completion_rollover_plan_no for the referenced record
CREATED_TSTAMP	TIMESTAMP_NTZ	The original source system created timestamp for the referenced data.