CNT_ST_CL_LVW(SQL View) |
Index Back |
---|---|
Contract Style Lang View11/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 |
# | 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 |