EOEC_CCI_TEST(SQL Table) |
Index Back |
|---|---|
Test CCIRecord to contain test records for the Credit Card Interface. This record is merely used to verify the working of the credit card subrecord. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | EOEC_CCI_AMOUNT | Number(27,3) | DECIMAL(26,3) NOT NULL | Amount for credit card transactions. Always positive, the service type (bill or credit) will determine the difference between debit and credit. |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 5 | EOEC_CCI_RQSTID | Character(30) | VARCHAR2(30) NOT NULL | Request ID |
| 6 | EOEC_CCI_NUMBER | Character(200) | VARCHAR2(200) NOT NULL | Use in the Credit Card Number Capture Process |
| 7 | EOEC_CCI_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Credit Card Name
Prompt Table: EOEC_CCI_TP_VW |
| 8 | EOEC_CCI_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Hold Credit Card Status.
Valid Values
1. Active
2. Inactive
A=Active I=Inactive Default Value: A |
| 9 | EOEC_CCI_FNAME | Character(60) | VARCHAR2(60) NOT NULL | Use in the Credit Card Number Capture Process |
| 10 | EOEC_CCI_LNAME | Character(60) | VARCHAR2(60) NOT NULL | Use in the Credit Card Number Capture Process |
| 11 | EOEC_CCI_APPEARS | Character(80) | VARCHAR2(80) NOT NULL | Hold Credit Card Name as it appears in the Card |
| 12 | 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 |
| 13 | 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 |
| 14 | EOEC_CCI_4DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Use in the Credit Card Number Capture Process |
| 15 | EOEC_CCI_AUTH | Number(5,0) | INTEGER NOT NULL | Holds Credit Card Authorization Number. Few credit cards have some extra numbers, which is required for authoization. |
| 16 | EOEC_CCI_CVNUM | Character(4) | VARCHAR2(4) NOT NULL | Card Verification Number |
| 17 | CREATEDTTM | DateTime(26) | TIMESTAMP | DateTime of Query Creation |
| 18 | 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. |
| 19 | 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. |
| 20 | EOEC_CCI_RQSTTOKEN | Long Character(256) | VARCHAR2(256) | Request Token |
| 21 | EOEC_SUBSCRIPTION | Number(26,0) | DECIMAL(26) NOT NULL | Subscription ID |