CP_RULE_DETL

(SQL Table)
 Index Back

CP Rule Detail

The Rule Detail table contains the conditions and actions to be performed based on the rule action code defined on the rule header.

  • Related Language Record: CP_RULE_D_LANG

  • Parent record: CP_RULE_HDR

    • # 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.
    2 CP_AREA Character(1) VARCHAR2(1) NOT NULL Functional Area Field
    0=Distribution
    1=Production
    3 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule
    4 RULE_SEQUENCE Number(5,0) INTEGER NOT NULL Sequence

    Default Value: 1

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

    Prompt Table: CP_OPT_VAR_VW

    6 CP_LONG_DESCR Character(254) VARCHAR2(254) NOT NULL Long Description Field
    7 CP_CONTROL_TYPE Character(1) VARCHAR2(1) NOT NULL Panel Control Type for the Product Configurator
    C=Check Box
    D=Dropdown List
    E=Edit Box
    R=Radio Button
    T=Text Box

    Default Value: E

    8 CP_USER_CD Character(10) VARCHAR2(10) NOT NULL Value List Field

    Prompt Table: CP_USERCD_VW

    9 CP_USER_CD_EXPR Character(18) VARCHAR2(18) NOT NULL Dynamic Value List Expression Syntax Field

    Prompt Table: CP_EXPR

    10 CP_DEFAULT_EXPR Character(18) VARCHAR2(18) NOT NULL Default Expression Value Field

    Prompt Table: CP_EXPR

    11 CP_PRINT_CODE Character(4) VARCHAR2(4) NOT NULL Print Code Field

    Prompt Table: CP_PRINTCD

    12 CP_CONSTRAINT Character(10) VARCHAR2(10) NOT NULL Constraint Field

    Prompt Table: CP_CONSTRT_VW1

    13 CP_NUMVAL_FLAG Character(1) VARCHAR2(1) NOT NULL Numeric Date Validation Field

    Y/N Table Edit

    Default Value: N

    14 CP_USERCD_DESC Character(1) VARCHAR2(1) NOT NULL Value List Description Field

    Y/N Table Edit

    Default Value: Y

    15 CP_MORE_INFO Long Character CLOB More Information Field Date Initials Issue # Description 020601 LPL DI-LLIU-6 8.02 - More Option Information Enhancement More Option Info field
    16 CP_STATUS Character(1) VARCHAR2(1) NOT NULL Option Status Field
    0=Required
    1=Included
    2=Optional
    3=Conditional

    Default Value: 0

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

    Prompt Table: CP_EXPR

    18 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.