EOEC_CCI_TYPE_L (SQL Table)	Index Back
Credit Card Types This record contains the valid prefixes of credit cards for error checking before sending to CyberSource or other suppliers.

EOEC_CCI_TYPE_L

(SQL Table)

Credit Card Types

This record contains the valid prefixes of credit cards for error checking before sending to CyberSource or other suppliers.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEC_CCI_TYPE Character(3) VARCHAR2(3) NOT NULL Credit Card Name

2 EOEC_CCI_LENGTH Number(3,0) SMALLINT NOT NULL Use in the Credit Card Number Capture Process

3 EOEC_CCI_PREFIX Character(60) VARCHAR2(60) NOT NULL Use in the Credit Card Number Capture Process

4 EOEC_CCI_TYPESTAT Character(1) VARCHAR2(1) NOT NULL Use in the Credit Card Number Capture Process
A=Active Credit Card
I=Inactive Credit Card
Default Value: I

5 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEC_CCI_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Credit Card Name
2	EOEC_CCI_LENGTH	Number(3,0)	SMALLINT NOT NULL	Use in the Credit Card Number Capture Process
3	EOEC_CCI_PREFIX	Character(60)	VARCHAR2(60) NOT NULL	Use in the Credit Card Number Capture Process
4	EOEC_CCI_TYPESTAT	Character(1)	VARCHAR2(1) NOT NULL	Use in the Credit Card Number Capture Process A=Active Credit Card I=Inactive Credit Card Default Value: I
5	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
6	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.