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