CCR_VNDR_CD(SQL Table) |
Index Back |
|---|---|
CCR Code Values |
| # | 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 | CCR_CD_QUAL |
Character(3) | VARCHAR2(3) NOT NULL |
Codetype
BUS=Business Types FSC=Federal Supply Class ORG=Organization Codes PSC=Public Service Codes SIC=Standard Industry Codes USA=NAICS Code |
| 4 | CCR_VNDR_CODE |
Character(40) | VARCHAR2(40) NOT NULL | Vendor CCR Codes |
| 5 | SOURCE_SYSTEM |
Character(3) | VARCHAR2(3) NOT NULL |
Source System
CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer Default Value: CCR |
| 6 | EXPIRATION_DATE | Date(10) | DATE | Expiration Date |