CREDIT_CRD_AUTH(SQL Table) |
Index Back |
|---|---|
Credit Card Authorization TblThis record is created when a Sales Order or Quotation is entered. The order header stores information about the order or quote. Much of this information is defaulted from the customer records and order group table. This record is the parent to ORD_LINE. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_OM_NONVW |
| 2 | 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
Default Value: NEXT Prompt Table: ORD_AN_VW |
| 3 | CC_REC_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Record Status |
| 4 | CC_INPUT_METH | Character(1) | VARCHAR2(1) NOT NULL |
Input Method
M=Manual T=Transmission |
| 5 | CC_TRANS_CODE | Character(1) | VARCHAR2(1) NOT NULL | Transaction Code |
| 6 | CC_TRANS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Transaction Type |
| 7 | CC_WCC | Character(1) | VARCHAR2(1) NOT NULL | WCC |
| 8 | 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 |
| 9 | CC_AMOUNT | Number(27,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 10 | CC_STATE | Character(2) | VARCHAR2(2) NOT NULL | State |
| 11 | CC_PRODUCT_ID | Character(10) | VARCHAR2(10) NOT NULL | Product ID |
| 12 | CCARD_APPROVAL_CD | Character(10) | VARCHAR2(10) NOT NULL | Approval Code |
| 13 | CC_AUTH_DATE | Date(10) | DATE | Authorization Date |
| 14 | CC_RETURN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Return Code |
| 15 | CC_AUTH_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Authorization Flag
A=Approved D=Denied |
| 16 | CC_ADDRESS | Character(20) | VARCHAR2(20) NOT NULL | AVS Address |
| 17 | CC_ZIP | Character(9) | VARCHAR2(9) NOT NULL | Zip Code |
| 18 | CC_RESPONSE | Character(2) | VARCHAR2(2) NOT NULL | Address Verification Response |
| 19 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 20 | EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 21 | NAME_EXACT | Character(40) | VARCHAR2(40) NOT NULL | Exact Name on Card |
| 22 | LOCATION_ID | Character(3) | VARCHAR2(3) NOT NULL | Location ID |
| 23 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |