SETIDCNTRCT_ID_DSTLANGUAGE_CDCNT_DST_LVW(SQL View) |
Index Back |
|---|---|
Distributor Cntrct Lang ViewPO002 Manufacturer Contract. Language view for distirbutor contract list on Manufacturer Contract. |
| SELECT DISTINCT A.SETID , A.CNTRCT_ID , SL.LANGUAGE_CD , SL.CNTRCT_STYLE_NAME , VL.NAME1 FROM PS_CNTRCT_HDR A , PS_VENDOR B , PS_CNTRCT_STYLE S , PS_CNTRCT_STL_LNG SL , PS_VENDOR_LANG VL WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.CNTRCT_STYLE = S.CNTRCT_STYLE AND B.SETID = VL.SETID AND B.VENDOR_ID = VL.VENDOR_ID AND S.CNTRCT_STYLE = SL.CNTRCT_STYLE AND VL.LANGUAGE_CD = SL.LANGUAGE_CD AND A.CNTRCT_PROC_OPT = 'DST' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID_DST |
Character(25) | VARCHAR2(25) NOT NULL | Contract ID To |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | CNTRCT_STYLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Style |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |