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