CP_RULE_HDR

(SQL Table)
 Index Back

CP Rule Header

This table contains all rules to be used during the execution of the product configurator.

  • Related Language Record: CP_RULE_H_LANG

  • Parent Record Of CP_RULECPY_VW CP_RULE_DETL CP_RULE_DETL_AD CP_RULE_DETL_CL CP_RULE_DETL_OS CP_RULE_HTML CP_RULE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CP_AREA Character(1) VARCHAR2(1) NOT NULL Functional Area Field
    0=Distribution
    1=Production

    Default Value: 0

    3 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule
    4 ACTION_INTL_CD Character(2) VARCHAR2(2) NOT NULL CP Action International Code Field
    01=Condition
    02=Secondary Variable
    03=Global Variable
    04=Option Variable
    05=Internal Variable Override
    06=Create External Parameter
    07=Configuration Detail
    08=Start Trace
    09=End Trace
    20=Page Generation
    21=Page Validation
    22=Configured Component
    23=Purchase Item
    24=Finalized Price
    25=Finalized Cost
    26=Finalized Date
    27=Availability Date
    28=Workflow
    29=Kit Component
    30=Component List
    31=Operation Sequence
    32=Generate Comment
    33=Product Selector
    34=Kit Generation
    35=Finalized Weight
    36=Finalized Volume
    5 RULE_DESCRIPTION Character(50) VARCHAR2(50) NOT NULL Field used for storing Rule Description
    6 RULE_SRCH_1 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 1
    7 RULE_SRCH_2 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 2
    8 RULE_SRCH_3 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 3
    9 RULE_SRCH_4 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 4
    10 RULE_SRCH_5 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 5
    11 RULE_PANEL_TITLE Character(254) VARCHAR2(254) NOT NULL Page Title
    12 RULE_PANEL_COL Character(1) VARCHAR2(1) NOT NULL Date Initials Issue # Description 020601 LPL DI-LLIU-6 8.02 - Custom HTML Enhancement Changed Short Name description
    1=Deferred Mode
    2=Real-Time Mode
    3=On Display Mode

    Default Value: 1

    13 RULE_ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Status
    N=Inactive
    Y=Active

    Default Value: Y

    14 CP_CONDITION_EXPR Character(18) VARCHAR2(18) NOT NULL Condition Expression ID Field

    Prompt Table: CP_EXPR

    15 CP_EXPR_ID Character(18) VARCHAR2(18) NOT NULL Expression ID Field

    Prompt Table: CP_EXPR

    16 CP_EXPR_ID2 Character(18) VARCHAR2(18) NOT NULL Expression ID 2 Field

    Prompt Table: CP_EXPR

    17 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BUINIT_NONVW

    18 CP_VARIABLE Character(18) VARCHAR2(18) NOT NULL Variable Field

    Prompt Table: %EDITTABLE

    19 CP_INTRN_VAR_NAME Character(18) VARCHAR2(18) NOT NULL Internal Variable Name Field

    Prompt Table: CP_INTRN_VAR_VW

    20 CP_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Field Type
    C=Character
    N=Numeric

    Default Value: C

    21 CONFIG_DETL_SEQ Number(3,0) SMALLINT NOT NULL Configuration Detail Sequence
    22 CP_PRINT_CODE Character(4) VARCHAR2(4) NOT NULL Print Code Field

    Prompt Table: CP_PRINTCD

    23 CP_OPTION_FLAG Character(1) VARCHAR2(1) NOT NULL Option Variable Flag Field
    N=Use Literal for Description
    Y=Use Option for Description

    Default Value: N

    24 OPTION_DESC Character(25) VARCHAR2(25) NOT NULL Description
    25 CP_PAGE_LAYOUT Character(1) VARCHAR2(1) NOT NULL Page Layout Options Field Date Initials Issue # Description 020601 LPL DI-LLIU-6 8.02 - Custom HTML Enhancement Page Layout selection
    0=Standard Layout
    1=Custom Layout

    Default Value: 0

    26 CP_DISPLAY Character(1) VARCHAR2(1) NOT NULL Configuaration Summary Display Yes/No

    Y/N Table Edit

    Default Value: N

    27 CP_STD_PAGE_OPT Character(1) VARCHAR2(1) NOT NULL Standard Page Layout Options Field Date Initials Issue # Description 020601 LPL DI-LLIU-6 8.02 - Custom HTML Enhancement Standard Page Layout selection
    1=Style 1
    2=Style 2
    3=Style 3

    Default Value: 1

    28 CP_MESSAGE_ID Character(18) VARCHAR2(18) NOT NULL Message ID Field

    Prompt Table: CP_MESSAGE

    29 CP_MESSAGE_TYPE Character(1) VARCHAR2(1) NOT NULL Message Type Field
    E=Error Message
    M=Information Message
    W=Warning Message

    Default Value: E

    30 COMP_OCCUR Character(2) VARCHAR2(2) NOT NULL Component Occurance

    Default Value: 01

    31 CP_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Item/Product Flag Field
    0=Product ID
    1=Item ID

    Default Value: 0

    32 CP_VAR_TYPE2 Character(2) VARCHAR2(2) NOT NULL Variable Type 2 Field

    Prompt Table: CP_VAR_TMP_VW

    33 CP_VAR_TYPE Character(2) VARCHAR2(2) NOT NULL Variable Type Field

    Prompt Table: CP_VAR_TMP_VW

    34 CP_DATEVAR Character(18) VARCHAR2(18) NOT NULL Date Variable Field

    Prompt Table: %EDITTABLE

    35 CP_PRICEVAR Character(18) VARCHAR2(18) NOT NULL Purchase Price Variable Field

    Prompt Table: %EDITTABLE2

    36 CP_PRICING_FLAG Character(1) VARCHAR2(1) NOT NULL Configurator Pricing Field
    0=Return Net Unit Price
    1=Return List Price

    Default Value: 0

    37 CP_AVAIL_CHECK Character(1) VARCHAR2(1) NOT NULL Availability Check Field
    T=Time Phase Check

    Default Value: T

    38 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

    Prompt Table: BUSPROCNAME_VW

    39 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

    Prompt Table: CP_WF_ACTV_VW

    40 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

    Prompt Table: CP_WF_EVENT_VW

    41 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without

    Y/N Table Edit

    Default Value: N

    42 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
    ASY=Assembly
    ORD=Order

    Default Value: ASY

    43 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    CS=Case
    EA=Each
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_STD_VW

    44 CP_CONSTRT_PGLVL Character(10) VARCHAR2(10) NOT NULL Constraint Page Level Field

    Prompt Table: CP_CONSTRT_VW0

    45 CP_OS_TIME Character(1) VARCHAR2(1) NOT NULL Operation Times Field
    0=Use Standard Operation Times
    1=Use Rule Based Operation Times

    Default Value: 0

    46 CP_PRODUCT_ID Character(1) VARCHAR2(1) NOT NULL Product ID Field

    Y/N Table Edit

    Default Value: N

    47 CP_PRODUCT_IMAGE Character(1) VARCHAR2(1) NOT NULL Product Image Field

    Y/N Table Edit

    Default Value: N

    48 CP_PRODUCT_PRICE Character(1) VARCHAR2(1) NOT NULL Product Price Field

    Y/N Table Edit

    Default Value: N

    49 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label
    50 DATE_OBSOLETE Date(10) DATE Obsolete Date
    51 CP_USE_MG Character(1) VARCHAR2(1) NOT NULL Direct Production Field

    Y/N Table Edit

    Default Value: Y

    52 CP_USE_OM Character(1) VARCHAR2(1) NOT NULL Order Management Field

    Y/N Table Edit

    Default Value: Y

    53 CP_USE_RQ Character(1) VARCHAR2(1) NOT NULL Direct Requisition Field................................

    Y/N Table Edit

    Default Value: Y

    54 CP_USE_WS Character(1) VARCHAR2(1) NOT NULL CRM External Field

    Y/N Table Edit

    Default Value: Y

    55 CP_USE_RSF Character(1) VARCHAR2(1) NOT NULL CRM Internal Field

    Y/N Table Edit

    Default Value: Y

    56 CP_USE_CN Character(1) VARCHAR2(1) NOT NULL Model Tester Field

    Y/N Table Edit

    Default Value: Y

    57 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.