DUNS_NUMBERCCR_DUNS_PLUS4SETIDPrompt Table: SETID_TBL
Default Value: N
N=Don't withholding
Y=Withholdeable
CCR_V_XREF_SCR(SQL View) |
Index Back |
|---|---|
CCR Supplier Cross Reference VCCR Contractors to PeopleSoft Suppliers Cross Reference View |
| SELECT DUNS_NUMBER , CCR_DUNS_PLUS4 , SETID , 'Y' , ' ' , ' ' , ' ' ,' ' 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
Prompt Table: SETID_TBL |
| 4 | EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Exist
Default Value: N |
| 5 | WTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Withhold if missing
N=Don't withholding Y=Withholdeable |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 7 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 8 | TRADING_PARTNER | Character(6) | VARCHAR2(6) NOT NULL | Trading Partner Code |