VENDOR_IDSUPOB_ADTRL_SUP(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.VENDOR_ID ,A.AUC_COMPANY_NAME FROM PS_SUP_OB_ADT_TL_V A , PS_AUC_BIDDER_XREF B WHERE B.BIDDER_SETID = B.BIDDER_SETID AND A.BIDDER_ID = B.BIDDER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 2 | AUC_COMPANY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Company ID - Company Tax ID |