DUNS_NUMBERUSF_DUNS_PLUS4USF_DUNS_VW2(SQL View) |
Index Back |
|---|---|
USF Search Vw |
| SELECT DISTINCT A.DUNS_NUMBER , A.USF_DUNS_PLUS4 , A.USF_UEID , A.USF_EFT_IND , A.LEGAL_BUS_NAME , A.DBANAME FROM PS_USF_VNDR_HDR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DUNS_NUMBER |
Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 2 | USF_DUNS_PLUS4 |
Character(4) | VARCHAR2(4) NOT NULL | DUNS Suffix |
| 3 | USF_UEID | Character(12) | VARCHAR2(12) NOT NULL | Unique Entity Identifier |
| 4 | USF_EFT_IND | Character(4) | VARCHAR2(4) NOT NULL | Entity EFT Indicator |
| 5 | LEGAL_BUS_NAME | Character(120) | VARCHAR2(120) NOT NULL | Business Name |
| 6 | DBANAME | Character(120) | VARCHAR2(120) NOT NULL | Doing Business As |