EOEC_CCI_CARD(SQL Table) |
Index Back |
---|---|
CCI CardCredit Card Interface Card |
# | 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_NUMBER | Character(200) | VARCHAR2(200) NOT NULL | Use in the Credit Card Number Capture Process |
3 | EOEC_CCI_EXPYR | Character(4) | VARCHAR2(4) NOT NULL |
Use in the Credit Card Number Capture Process
2001=2001 2002=2002 2003=2003 2004=2004 2005=2005 2006=2006 2007=2007 2008=2008 2009=2009 2010=2010 |
4 | EOEC_CCI_EXPMO | Character(2) | VARCHAR2(2) NOT NULL |
Credit Card Expiry Month
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
5 | EOEC_CCI_CVNUM | Character(4) | VARCHAR2(4) NOT NULL | Card Verification Number |
6 | EOEC_CCI_MAGDATA | Character(80) | VARCHAR2(80) NOT NULL | Magnetic Strip Data |
7 | EOEC_CCI_FULLNAME | Character(70) | VARCHAR2(70) NOT NULL | Full Name |
8 | EOEC_CCI_FNAME | Character(60) | VARCHAR2(60) NOT NULL | Use in the Credit Card Number Capture Process |
9 | EOEC_CCI_LNAME | Character(60) | VARCHAR2(60) NOT NULL | Use in the Credit Card Number Capture Process |