EOEC_CCI_PAYDAT (SQL Table)	Index Back
CCI Pay Date Credit Card Interface Pay Date

EOEC_CCI_PAYDAT

(SQL Table)

CCI Pay Date

Credit Card Interface Pay Date

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEC_CCI_TRANSACT Character(2) VARCHAR2(2) NOT NULL Indicator for Credit Card Transaction Type.
1=Authorize Only
10=Authorize Subscription
11=Authorize Bill Subscription
12=Retrieve Subscription
2=Authorize and Bill
3=Bill Only
4=Credit Only
5=Authorization Reversal
6=Error
7=Create Account
8=Modify Account
9=Delete Account

2 EOEC_SUBSCRIPTION Number(26,0) DECIMAL(26) NOT NULL Subscription ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEC_CCI_TRANSACT	Character(2)	VARCHAR2(2) NOT NULL	Indicator for Credit Card Transaction Type. 1=Authorize Only 10=Authorize Subscription 11=Authorize Bill Subscription 12=Retrieve Subscription 2=Authorize and Bill 3=Bill Only 4=Credit Only 5=Authorization Reversal 6=Error 7=Create Account 8=Modify Account 9=Delete Account
2	EOEC_SUBSCRIPTION	Number(26,0)	DECIMAL(26) NOT NULL	Subscription ID