EOEC_CCI_ORDR_NUMEOEC_CCI_O_PRSN(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEC_CCI_ORDR_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Order Number |
| 2 | EOEC_CCI_FNAME | Character(60) | VARCHAR2(60) NOT NULL | Use in the Credit Card Number Capture Process |
| 3 | EOEC_CCI_LNAME | Character(60) | VARCHAR2(60) NOT NULL | Use in the Credit Card Number Capture Process |
| 4 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 5 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 6 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 7 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 9 | EOEC_EMAIL_ADDR | Long Character | CLOB | Email Address |
| 10 | EOEC_SUBSCRIPTION | Number(26,0) | DECIMAL(26) NOT NULL | Subscription ID |