SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SETID_TBL
VENDOR_IDLANGUAGE_CDVENDOR_SES_LVW(SQL View) |
Index Back |
|---|---|
Supplier Header PTSF view |
| SELECT A.SETID , A.VENDOR_ID , l.language_cd , A.VENDOR_NAME_SHORT , A.VNDR_NAME_SHRT_USR , A.NAME1 , A.NAME2 , A.NAME1_AC , A.NAME2_AC , A.SETID FROM PS_VENDOR_LANG L , (PS_VENDOR A LEFT OUTER JOIN PS_VNDR_RPT_ELEM B ON A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID) WHERE L.SETID = A.SETID AND L.VENDOR_ID = A.VENDOR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SETID_TBL |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 5 | VNDR_NAME_SHRT_USR | Character(10) | VARCHAR2(10) 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 |
| 8 | NAME1_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 1 Alternate Char Set |
| 9 | NAME2_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 2 Alternate Char Set |
| 10 | DESCR120 | Character(120) | VARCHAR2(120) NOT NULL | Description |