EOEC_CCI_TRANSIDEOEC_CCI_TRRSLT(SQL Table) |
Index Back |
|---|---|
CCI TransactionCredit Card Interface Transaction Results |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEC_CCI_TRANSID |
Character(30) | VARCHAR2(30) NOT NULL | Transaction ID |
| 2 | EOEC_CCI_RESULT | Signed Number(5,0) | DECIMAL(4) NOT NULL | Result Code |
| 3 | EOEC_RET_AVS | Character(1) | VARCHAR2(1) NOT NULL | Address verification |
| 4 | EOEC_CCI_CVRESULT | Character(22) | VARCHAR2(22) NOT NULL | Credit Verification Result |
| 5 | EOEC_CCI_RET_MSG | Character(100) | VARCHAR2(100) NOT NULL | Return Message |
| 6 | EOEC_CCI_TRANS_REF | Character(30) | VARCHAR2(30) NOT NULL | Transaction Reference Number |
| 7 | EOEC_RET_AUTHCD | Character(10) | VARCHAR2(10) NOT NULL | Authorization code |
| 8 | EOEC_CCI_HOSTCODE | Character(6) | VARCHAR2(6) NOT NULL | Host Code |
| 9 | EOEC_SUBSCRIPTION | Number(26,0) | DECIMAL(26) NOT NULL | Subscription ID |
| 10 | EOEC_CCI_HOST_URL | Character(254) | VARCHAR2(254) NOT NULL | Host URL |
| 11 | EOEC_CCI_ORIGRSLT | Signed Number(5,0) | DECIMAL(4) NOT NULL | Result Code |
| 12 | EOEC_RET_STATUS | Signed Number(5,0) | DECIMAL(4) NOT NULL | Return status |
| 13 | EOEC_RET_STATUSMSG | Character(100) | VARCHAR2(100) NOT NULL | Return status message |
| 14 | EOEC_RET_AUTHDTTM | DateTime(26) | TIMESTAMP | Authorizaiton date time in vendor format |
| 15 | EOEC_CCI_RQSTTOKEN | Long Character(256) | VARCHAR2(256) | Request Token |