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

EOEC_CCI_TP_LVW

(SQL View)

Credit Card Types

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

SELECT A.EOEC_CCI_TYPE ,B.LANGUAGE_CD ,B.EOEC_CCI_NAME FROM PS_EOEC_CCI_TYPE A ,PS_EOEC_CCI_TP_LNG B WHERE A.EOEC_CCI_TYPE=B.EOEC_CCI_TYPE AND A.EOEC_CCI_TYPESTAT = 'A'

Related Language Record for EOEC_CCI_TP_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EOEC_CCI_NAME Character(32) VARCHAR2(32) NOT NULL Use in the Credit Card Number Capture Process

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEC_CCI_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Credit Card Name
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EOEC_CCI_NAME	Character(32)	VARCHAR2(32) NOT NULL	Use in the Credit Card Number Capture Process