RO_DEFN_LNPRLNG

(SQL View)
 Index Back

Line Status DropDown

Line Statuses

SELECT a.setid , a.status_type , a.status_code_from , a.status_code , b.language_cd , b.descr50 FROM ps_ro_defn_lnprmpt a , PS_RO_DEFNLNST_LNG b WHERE a.setid = b.setid AND a.status_code = b.status_code

  • Related Language Record for RO_DEFN_LNPR_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.

    Prompt Table: SP_SETID_NONVW

    2 STATUS_TYPE Character(5) VARCHAR2(5) NOT NULL Field used to repersent Status used as Drop-down and Edit Box for pricing defintion setup

    Prompt Table: RO_DEFN_LS_TYPE

    3 STATUS_CODE_FROM Signed Number(6,0) DECIMAL(5) NOT NULL Status Code

    Prompt Table: RO_DEFN_LNSTAT

    4 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code

    Prompt Table: RO_DEFN_LNSTAT

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50