| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
EOEC_CCI_CUSTID |
Character(12) |
VARCHAR2(12) NOT NULL |
Use in the Credit Card Number Capture Process
|
| 2 |
EOEC_CCI_FULLNAME |
Character(70) |
VARCHAR2(70) NOT NULL |
Full Name
|
| 3 |
EOEC_EMAIL_ADDR |
Long Character |
CLOB |
Email Address
|
| 4 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
This field stores the Telephone number.
|
| 5 |
FAX |
Character(24) |
VARCHAR2(24) NOT NULL |
This is the fax number field.
|
| 6 |
EOEC_CCI_CUSTCODE |
Character(17) |
VARCHAR2(17) NOT NULL |
Customer Code
|
| 7 |
EOEC_CCI_PO_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Purchase Order Number
|
| 8 |
EOEC_CCI_TAXEXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt
|