DUNS_NUMBERCCR_DUNS_PLUS4FED_CST_TEAM_VW(SQL View) |
Index Back |
|---|---|
FEDREG New Cust Team |
| SELECT DUNS_NUMBER , CCR_DUNS_PLUS4 , ' ' , ' ' FROM PS_CCR_VNDR_HDR WHERE SOURCE_SYSTEM = 'FED' AND FR_BUS_TYPE IN ('2','3') |
| # | 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 | SUPPORT_TEAM_CD | Character(6) | VARCHAR2(6) NOT NULL | Support Team Code |
| 4 | DEFAULT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Default |