CNT_ST_CL_LVW

(SQL View)
Index Back

Contract Style Lang View

11/15/2015 JOHAN PO0025 - Master contract fluid

SELECT A.CNTRCT_STYLE , L.LANGUAGE_CD , L.CNTRCT_STYLE_NAME , L.DESCR50 FROM PS_CNTRCT_STYLE A , PS_CNTRCT_STL_LNG L WHERE A.CNTRCT_PROC_OPT IN ( 'AP', 'BPO','GN','PADV','PO','PPAY','RPOV','MFG') AND A.CNTRCT_STYLE = L.CNTRCT_STYLE

  • Related Language Record for CNTRCT_CL_VW CNTRCT_DC_VW CNTRCT_ST_CL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Short Description
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50