EOEC_CCI_BILLTO (SQL Table)	Index Back
CCI Bill To Credit Card Interface Bill To

EOEC_CCI_BILLTO

(SQL Table)

CCI Bill To

Credit 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 Telephone

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

#	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	Telephone
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