DUNS_NUMBERCCR_DUNS_PLUS4SETIDVENDOR_IDA=Automatic
M=Manual
Default Value: M
CCR_V_XREF_VW(SQL View) |
Index Back |
|---|---|
CCR Supplier Cross Reference VCCR Contractors to PeopleSoft Suppliers Cross Reference View |
| SELECT DUNS_NUMBER , CCR_DUNS_PLUS4 , SETID , VENDOR_ID , VNDR_CCR_ORGIN FROM PS_CCR_VNDR_XREF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DUNS_NUMBER |
Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 2 | CCR_DUNS_PLUS4 |
Character(4) | VARCHAR2(4) NOT NULL | DUNS Suffix |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VNDR_CCR_ORGIN | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Origin
A=Automatic M=Manual Default Value: M |