CP_RULE_SEL_VW

(SQL View)
 Index Back

CP Rule Number Select View

View of CP_RULE_HDR

SELECT SETID , CP_AREA , RULE_NUMBER , RULE_DESCRIPTION , ACTION_INTL_CD , RULE_SRCH_1 , RULE_SRCH_2 , RULE_SRCH_3 , RULE_SRCH_4 , RULE_SRCH_5 FROM PS_CP_RULE_HDR

  • Related Language Record: CP_RULE_SVW_LNG

    • # 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
    3 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule
    4 RULE_DESCRIPTION Character(50) VARCHAR2(50) NOT NULL Field used for storing Rule Description
    5 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
    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