Knowledge Base

Welcome to the SmarterCommerce documentation portal

What can we help you find?

SMARTERCOMMERCE

Search and Learn about Unified Commerce and Our SmarterCommerce Solutions
Payment Processing

Tables Used by PayPal® Express Checkout as Currency


Name Explanation
Sales Order Header (F4201)
Stores the following header information:
Customer address book number
Payment instrument
Prepayment Transactions (F004201)
Stores the following payment information related to the sales order: 
Payment type (order or authorization)
PN reference number  
Prepayment transaction status
Authorized amount
Settled amount
Prepayment Tag File (FQ670041)
Stores the following payment information related to the sales order: 
Capture PN reference number  
Original PN reference number  
Electronic Receipts (F03B13Z1)
Stores the following receipts information:  
Settled payment amounts to be applied
Document invoice number
Customer address book number
Receipts Header (F03B13)
Stores the following receipts header information:
Total receipt to be applied
Status of receipt to be applied

Receipts Detail (F03B14)
Stores the following receipts detail information:  
 Invoice detail applied against
 Receipt detail

Customer Ledger (F03B11)
Stores the following receipts detail information:  
 Invoice detail applied against
 Receipt detail

Connection Settings (FQ67SYS1)
Stores the following connection information:  
Business unit
Environment 
Payment instrument
Currency code
Connection name
Provider name
Processor level

Provider Settings (FQ67SYS2)
Stores the following provider information:  
Server name
Environment
Provider name
API path to access the JDE interop.dll
URL path to access web service

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