DUNS_NUMBERCCR_DUNS_PLUS4Prompt Table: SP_SETID_NONVW
CCR_VNDR_SRCH(SQL View) |
Index Back |
|---|---|
CCR Supplier Search Record |
| SELECT A.DUNS_NUMBER , A.CCR_DUNS_PLUS4 , A.LEGAL_BUS_NAME , A.FULLNAME , A.EIN_NUMBER , A.SSN , B.SETID , B.VENDOR_ID FROM PS_CCR_VNDR_HDR A , PS_CCR_VNDR_XREF B WHERE (A.DUNS_NUMBER||A.CCR_DUNS_PLUS4) = (B.DUNS_NUMBER(+)||B.CCR_DUNS_PLUS4(+)) AND A.SOURCE_SYSTEM='CCR' |
| # | 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 | LEGAL_BUS_NAME | Character(120) | VARCHAR2(120) NOT NULL | Legal Business Name |
| 4 | FULLNAME | Character(60) | VARCHAR2(60) NOT NULL | Full name |
| 5 | EIN_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | Employer Identification Number |
| 6 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |