EOEC_CCI_O_HDR(SQL Table) |
Index Back |
|---|---|
e |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOEC_CCI_ORDR_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Order Number |
| 2 | EOEC_CCI_VENDOR | Character(16) | VARCHAR2(16) NOT NULL |
Payment Processor Name
Prompt Table: EOEC_CCI_INSTAL |
| 3 | EOEC_CCI_RQSTR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 4 | EOEC_CCI_ORDR_TOT | Number(8,2) | DECIMAL(7,2) NOT NULL | Order Total Cost |
| 5 | EOEC_CCI_ORDR_DTTM | DateTime(26) | TIMESTAMP | Datetime action was taken on a worklist |
| 6 | EOEC_CCI_TRANSACT | Character(2) | VARCHAR2(2) NOT NULL |
Indicator for Credit Card Transaction Type.
1=Authorize Only 10=Authorize Subscription 11=Authorize Bill Subscription 12=Retrieve Subscription 2=Authorize and Bill 3=Bill Only 4=Credit Only 5=Authorization Reversal 6=Error 7=Create Account 8=Modify Account 9=Delete Account |