This record is created/updated whenever a credit card authorization, capture or sale is made.
The CCTran record points back to the order number or invoice numbers using the Doc_Type and Doc_No fields. One CCTRAN record points to one authorization/charge/sale. If an order is shipped in multiple shipments, with multiple CC, charges there will be multiple CCTRAN records
Doc Type |
Doc Number |
S - Sales Order |
Order Number |
I - Invoice (POS) |
Invoice Number |
T - Ticket |
Picklist ticket number |
A CCTRAN record is written/updated every time a CC authorization, Capture or Sale or is done. The status of the record is either:
A - Authorized
C - Captured
S - Sale
V - Voided
To code
CCTran lookup from old Review * Order /invoice header
Clear auth from Review Panel.
Allow auth from Review Panel.
Setup
Terms codes for credit card processing must have a processing code of 1 for manual, or 9 for Automatic mode.
The following parameters are used depending on configuration and software being used.
CCAPFRTA |
50 |
Freight amount to add to authorization |
CCAPTAXA |
1.09 |
Tax authorization |
CCPADAYS |
100 |
This is the # of days to wait to reauthorize |
CCPCLEAR |
6 |
Credit Card Clearing Auto post Number |
CCPFADDR |
1 |
Check addresses above this amount. |
CCPFAGES |
60 |
CCPF Shipto address aging |
CCPFBASE |
200 |
CCPF Base amount for drop ship orders |
CCPFHRED |
5000 |
High value for red. Over this amount go |
CCPFHVAL |
5000 |
Credit Card High Value check |
CCPFRTA |
50 |
Freight authorization |
CCPFSALD |
120 |
Recent sales data range. |
CCPFSALV |
500 |
Recent sales data value. |
Testing
To test Credit Card Processing use the Credit Card Processing View on the Maintenance/Utilities AR Menu. This View allows direct AR transactions with no update of the database. You must manually do any database updates.
More: