CP_RULE_SVW_LNG

(SQL View)
 Index Back

CP Rule Number Select View RLR

CP Rule Number Select View Related Language

SELECT SETID , CP_AREA , RULE_NUMBER , LANGUAGE_CD , RULE_DESCRIPTION FROM PS_CP_RULE_H_LANG

  • Related Language Record for CP_RULE_SEL_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
    3 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule

    Prompt Table: CP_RULE_VW

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 RULE_DESCRIPTION Character(50) VARCHAR2(50) NOT NULL Field used for storing Rule Description