Skip to main content
Aria Knowledge Central

Snowflake VC Object: Plans

► 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.
Child Views

Variant

Source Table

Child View Name

AVAILABLE_NONSUBSCRIPTION_OFFERINGS PLANS VM_PLAN_AVAILABLE_NONSUBSCRIPTION_OFFERINGS
CONTRACT_COMPLETION_ROLLOVER_RATE_SCHEDULES PLANS VM_PLAN_CONTRACT_COMPLETION_ROLLOVER_RATE_SCHEDULES
LOCALE_DETAILS PLANS VM_PLAN_LOCALE_DETAILS
NONSUBSCRIPTION_OFFERING_GROUP PLANS VM_PLAN_NONSUBSCRIPTION_OFFERING_GROUPS
NONSUBSCRIPTION_OFFERING_GROUP PLANS VM_PLAN_NSOG_PLAN_NONSUBSCRIPTION_OFFERINGS_NONSUBSCRIPTION_OFFERING_SCHEDULE_ASSIGNMENTS
NONSUBSCRIPTION_OFFERING_INDIVIDUALS PLANS VM_PLAN_NONSUBSCRIPTION_OFFERING_INDIVIDUALS
PLAN_RATE_SCHEDULES PLANS VM_PLAN_PLAN_RATE_SCHEDULES
PRODUCT_FIELD_ASSIGNMENTS PLANS VM_PLAN_PFA_VALUES
PRODUCT_FIELD_ASSIGNMENTS PLANS VM_PLAN_PFA_VALUE_LOCALE_DETAILS
PRODUCT_FIELD_ASSIGNMENTS PLANS VM_PLAN_PRODUCT_FIELD_ASSIGNMENTS
PRODUCT_FIELD_CATEGORIES PLANS VM_PLAN_PRODUCT_FIELD_CATEGORIES
SERVICE_DETAILS PLANS VM_PLAN_SD_USAGE_THRESHOLDS
SERVICE_DETAILS PLANS VM_PLAN_SD_UT_LEVELS
SERVICE_DETAILS PLANS VM_PLAN_SERVICE_DETAILS
SURCHARGES PLANS VM_PLAN_SURCHARGES
  • Was this article helpful?