Tables used by Credit Card Reconciliation
| Name | Explanation |
|---|---|
| Report Information (FQ674225) | Stores the following information: Report Id Connection Name Processor Name Date From Start Time Date thru End Time Time Zone Program ID Work Station ID User ID Date-updated Time-last updated Result Message |
| Settled Transactions (FQ674226) | Stores the following information: Transaction Id Date-Order/Transaction Type Tender Type Account Number Expiration Date Currency Code-From Amount-Extended Price Result Message Comment Comment Batch ID Item Number Report ID Reconcile Code User Reserve Code User Reserve Date User Reserve Amount User Reserve Number User Reserve Reference User Reserve Reference Generic Desc1 Generic Desc2 Generic Desc3 |
| Connection Name by Processor and Merchant Bank (FQ674227) | Stores the following information: Connection Name Credit Card type Processor Name Item Number Description Date-Order/Transaction Start time End time Program ID Workstation ID User ID Date-updated Time-last updated |
Read Next
This Section Also Contains
- Credit Card Prepayment Information Flow
- Credit Card Prepayment Flow
- Credit Card Prepayment Setup
- Entering Sales Orders
- Updating Credit Card Prepayment Information - PQ670041
- Clearing Multiple Accounts Receivable Invoices with Credit Card Payment - PQ670042
- Uploading Customer Credit Cards on File - PQ670043
- Work with Future Dated Receipts - PQ670313
- Auto Invoice Payment Rules - PQ670315
- Authorize by Message Status Application - PQ674236
- Pay Invoice by Message Status - PQ674237
- Work with Companies by Store - PQ679912
- Credit Cards on File - PQ67CCIF
- Apply AutoPay Rules - RQ670315
- Surcharge Errors - PQ67SUER
- Batch Authorization of Credit Card Transactions - RQ6704201
- Settling Credit Card Transactions - RQ6704202
- Recording Settled Credit Card Transactions into Financial System - RQ6704203
- Credit Card Prepayment Analysis Report - RQ6704204
- Authorized Credit Card Expiring Report - RQ6704205
- Clearing Sensitive Card Holder Information - RQ6704208
- Credit Card AR Settlement Report - RQ6704209
- Deposit Settlement Report - RQ6704210
- Renew Credit Card on File - RQ6704212
- Credit Card Reconciliation - RQ6704213 & RQ6704214
- Credit Card Surcharge Fee Batch Report - RQ6704215
- Authorize by Email Automated Process - RQ6704216
- Create Invoice Payment by Email Process - RQ6704217
- Pay Invoice by Email Process - RQ6704218
- Update JDE Payments to PayCloud - Email Payment Document - RQ6704219
- Change Invoice Email Status to Expired - RQ6704220
- Credit Card Future Payments Process - RQ670429F
- Import Credit Card on File Information from Cloud - RQ67CCIF