DUNS_NUMBERCCR_DUNS_PLUS4CCR_ADDR_TYPESOURCE_SYSTEMCCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer
Default Value: CCR
CCR_VNDR_ADDR(SQL Table) |
Index Back |
|---|---|
CCR Address Record |
| # | 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_ADDR_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | SAM Address Type |
| 4 | SOURCE_SYSTEM |
Character(3) | VARCHAR2(3) NOT NULL |
Source System
CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer Default Value: CCR |
| 5 | OPERATIONNAME | Character(60) | VARCHAR2(60) NOT NULL | Operation |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 8 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 9 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 10 | ADDRESS5 | Character(35) | VARCHAR2(35) NOT NULL | ADDRESS5 |
| 11 | ADDRESS6 | Character(35) | VARCHAR2(35) NOT NULL | ADDRESS6 |
| 12 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 13 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 14 | CPARTY_PHONE_NBR | Character(30) | VARCHAR2(30) NOT NULL | The phone number for a given bank/counterparty contact person. |
| 15 | EXT_REF_NBR | Number(10,0) | DECIMAL(10) NOT NULL | External Reference Number |
| 16 | PHONE_SUFFIX | Character(40) | VARCHAR2(40) NOT NULL | Dialing Suffix |
| 17 | CPARTY_FAX_NBR | Character(30) | VARCHAR2(30) NOT NULL | The facsimile number for a given bank/counterparty contact person. |
| 18 | EMAIL_TO | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_TO |
| 19 | CC_PARENT_DUNS | Character(13) | VARCHAR2(13) NOT NULL | Parent Company DUNS Number |