CCAUTH_TEO1(SQL Table) |
Index Back |
|---|---|
CCU TEO Temp TableCCU temporary table for CREDIT_CRD_AUTH Date Init. Issue # Description 012902 JJM 8.40 Created record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_OM_NONVW |
| 3 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Prompt Table: ORD_AN_VW |
| 4 | CC_REC_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Record Status |
| 5 | CC_INPUT_METH | Character(1) | VARCHAR2(1) NOT NULL |
Input Method
M=Manual T=Transmission |
| 6 | CC_TRANS_CODE | Character(1) | VARCHAR2(1) NOT NULL | Transaction Code |
| 7 | CC_TRANS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Transaction Type |
| 8 | CC_WCC | Character(1) | VARCHAR2(1) NOT NULL | WCC |
| 9 | CR_CARD_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
"See OM
01=Visa 02=MasterCard 03=Diners Club/Carte Blanche 04=AMEX 05=Discover 06=EnRoute Prompt Table: ORDENT_CCTYP_VW |
| 10 | CC_AMOUNT | Number(27,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 11 | CC_STATE | Character(2) | VARCHAR2(2) NOT NULL | State |
| 12 | CC_PRODUCT_ID | Character(10) | VARCHAR2(10) NOT NULL | Product ID |
| 13 | CCARD_APPROVAL_CD | Character(10) | VARCHAR2(10) NOT NULL | Approval Code |
| 14 | CC_AUTH_DATE | Date(10) | DATE | Authorization Date |
| 15 | CC_RETURN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Return Code |
| 16 | CC_AUTH_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Authorization Flag
A=Approved D=Denied |
| 17 | CC_ADDRESS | Character(20) | VARCHAR2(20) NOT NULL | AVS Address |
| 18 | CC_ZIP | Character(9) | VARCHAR2(9) NOT NULL | Zip Code |
| 19 | CC_RESPONSE | Character(2) | VARCHAR2(2) NOT NULL | Address Verification Response |
| 20 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 21 | EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 22 | NAME_EXACT | Character(40) | VARCHAR2(40) NOT NULL | Exact Name on Card |
| 23 | LOCATION_ID | Character(3) | VARCHAR2(3) NOT NULL | Location ID |
| 24 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 25 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |