EOEC_CCI_BILLTO(SQL Table) |
Index Back |
---|---|
CCI Bill ToCredit Card Interface Bill To |
# | 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 | Phone |
5 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
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 |