VENDOR_SETIDVENDOR_IDCNT_MFG_GLN_INQ(SQL View) |
Index Back |
|---|---|
Cntrct GLN ViewPO002 Manufacturer Contract. This view is for showing GLN on contract inquiry page for manufacturer contract. |
| SELECT A.SETID , A.VENDOR_ID , B.STD_ID_NUM FROM PS_VENDOR A , PS_VENDOR_ID_NBRS B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.STD_ID_NUM_QUAL = 'GLN' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | STD_ID_NUM | Character(35) | VARCHAR2(35) NOT NULL | ID Number |