USF_V_XREF_SCR(SQL View) |
Index Back |
|---|---|
SAM Vendor XREF & CreateCloned from CCR_V_XREF_SCR |
| SELECT DISTINCT A.USF_UEID , A.USF_EFT_IND , A.VENDOR_SETID, A.DUNS_NUMBER , 'Y' , ' ' , ' ' , ' ' , L.TRADING_PARTNER , A.USF_DUNS_PLUS4 FROM PS_USF_VNDR_XREF A , PS_VENDOR V , PS_VENDOR_LOC L WHERE V.SETID = A.VENDOR_SETID AND V.VENDOR_ID = A.VENDOR_ID AND L.SETID = V.SETID AND L.VENDOR_ID = V.VENDOR_ID AND L.VNDR_LOC = V.DEFAULT_LOC AND L.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VENDOR_LOC S WHERE S.SETID = L.SETID AND S.VENDOR_ID = L.VENDOR_ID AND S.VNDR_LOC = L.VNDR_LOC ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  USF_UEID |
Character(12) | VARCHAR2(12) NOT NULL |
Unique Entity Identifier
Default Value: USF_VNDR_HDR.USF_UEID |
| 2 | USF_EFT_IND |
Character(4) | VARCHAR2(4) NOT NULL |
Entity EFT Indicator
Default Value: USF_VNDR_HDR.USF_UEID |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETVC_NONVW |
| 4 | DUNS_NUMBER | Character(9) | VARCHAR2(9) NOT NULL |
DUNS Number
Default Value: USF_VNDR_HDR.DUNS_NUMBER |
| 5 | EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Exist
Default Value: N |
| 6 | WTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Withhold if missing
N=Don't withholding Y=Withholdeable |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 8 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 9 | TRADING_PARTNER | Character(6) | VARCHAR2(6) NOT NULL | Trading Partner Code |
| 10 | USF_DUNS_PLUS4 | Character(4) | VARCHAR2(4) NOT NULL |
DUNS Suffix
Default Value: USF_VNDR_HDR.USF_DUNS_PLUS4 |