SETIDPrompt Table: SP_SETID_NONVW
MFG_IDLANGUAGE_CDCNT_MFG_LANG(SQL View) |
Index Back |
|---|---|
Language View of Mfg PromptPO002 Manufacturer Contract. Language View for MFG_ID prompt view in record CNTRCT_HDR. |
| SELECT A.SETID , A.MFG_ID , L.LANGUAGE_CD , L.DESCR60 , B.VENDOR_NAME_SHORT , B.NAME1 , B.NAME2 FROM PS_MANUFACTURER A LEFT OUTER JOIN PS_VENDOR_LANG B ON A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID , PS_MANUFACT_LANG L WHERE A.SETID = L.SETID AND A.MFG_ID = L.MFG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | MFG_ID |
Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 5 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |