Knowledge Base

Welcome to the SmarterCommerce documentation portal

What can we help you find?

Credit Card Prepayment Information Flow

As you accept prepayments, information is stored in tables within JDE for later use during the sales order cycle. Below is an outline of when this information is collected and the associated tables.

When you enter a payment instrument representing credit card in the sales order it is stored in the Sales Order Header (F4201) and Sales Order Detail (F4211) tables in JDE.

When you process a credit card authorization and/or settlement the information is stored in the Prepayment Transaction (F004201), Prepayment Tag File (FQ670041), and Credit Card Information (FQ67CCIF) tables.

Credit card payments that are applied after settlement are written to the Electronic Receipts Input (F03B13Z1), Receipts Header (F03B13), Receipt Details (F03B14), and Customer Ledger (F03B11) files.

When you post a credit card payment information is written to the Account Ledger (F0911) and Account Balance (F0902) tables.

Payflow™ Payment Gateway and Web Service information holds data the Connection Settings (FQ67SYS1) and Provider Settings (FQ67SYS2) tables.

Please note that when you go directly to your gateway (PayPal, Computop, BrainTree, EBANX) and process a credit card sale directly in their system JDE will not be aware of the payment. Therefore, you will have to process the payment manually in JDE through the steps automation would have handled. This includes expiring/voiding the authorization in JDE if you perform a settlement directly.

This Section Also Contains

Bring It All Together

We bring together digital commerce, retail and call center channels with a united approach that leverages the power of onmi-channel while prioritizing JD Edwards connectivity.

CONNECT WITH AN EXPERT