# JD Edwards AP and AR Ledger Tables: F0411, F0413, F0414, F03B11, F03B13, F03B14 > Source: https://netray.co/tools/jde-ap-ar-ledger-tables-f0411-f03b11-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Keys and working columns for the JDE 9.2 payables and receivables ledgers, payment and receipt tables, batch input tables and the supplier and customer contact tables. ## Category oracle ## Erp JD Edwards EnterpriseOne ## Audience - JDE financial consultant - JDE developer - AP and AR analyst - Report writer ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Name **Key:** name **Type:** text #### Key columns **Key:** keys **Type:** text #### Important columns **Key:** important **Type:** text #### Batch input (Z) table **Key:** batch **Type:** text #### Notes **Key:** notes **Type:** text **Rows:** #### Accounts Payable Ledger **Table:** F0411 **Keys:** RPDOC, RPDCT, RPKCO, RPSFX, RPSFXE **Important:** RPAN8 supplier, RPPYE payee, RPDIVJ invoice date, RPDGJ G/L date, RPDDJ net due, RPAG gross, RPAAP open, RPPST pay status, RPICU batch, RPPOST posted code, RPCRCD, RPVINV supplier invoice, RPPO/RPPDCT/RPPKCO purchase order **Batch:** F0411Z1 **Notes:** One row per voucher pay item. Open payables = RPAAP not 0. #### RPPST pay status (UDC 00/PS) **Table:** F0411 **Important:** A approved for payment, H hold pending approval, P paid in full, R retainage, % withholding applies, # payment in process **Notes:** Sites can add their own hold codes to 00/PS; check the list on your system. #### Amounts and dates **Table:** F0411 **Important:** RPAG, RPAAP stored with 2 implied decimals; RPDIVJ, RPDGJ, RPDDJ are Julian CYYDDD **Notes:** Foreign amounts in RPACR and RPFAP use the currency in RPCRCD. #### Voucher Transactions - Batch Upload **Table:** F0411Z1 **Keys:** VLEDUS, VLEDBT, VLEDTN, VLEDLN **Important:** VLKCO, VLDOC, VLDCT, VLSFX, VLAN8, VLPYE, EDI control columns VLEDSP processed flag, VLEDTC action **Batch:** Itself **Notes:** VL prefix. Processed into F0411 and F0911 by the batch voucher processor. #### Accounts Payable - Matching Document (payment header) **Table:** F0413 **Keys:** RMPYID **Important:** RMDOCM payment number, RMDCTM matching doc type, RMPYE payee, RMGLBA bank account, RMDMTJ payment date, RMPAAP payment amount, RMVDGJ void date, RMICU batch, RMISTP post status **Notes:** One row per payment. RMPYID is an internal ID from next numbers. #### Accounts Payable Matching Document Detail (payment detail) **Table:** F0414 **Keys:** RNPYID, RNRC5 **Important:** RNDOC, RNDCT, RNKCO, RNSFX, RNSFXE voucher being paid, RNPAAP amount paid, RNADSA discount taken, RNPOST **Notes:** Join F0413 on PYID, then F0411 on DOC, DCT, KCO, SFX, SFXE. #### Supplier Master **Table:** F0401 **Keys:** A6AN8 **Important:** A6APC G/L offset, A6TRAP payment terms, A6PYIN payment instrument, A6HDPY hold payment code, A6CRRP currency **Notes:** Supplier name and address come from F0101 and F0116. #### Customer Ledger (AR invoices) **Table:** F03B11 **Keys:** RPDOC, RPDCT, RPKCO, RPSFX **Important:** RPAN8 customer, RPDIVJ invoice date, RPDGJ G/L date, RPDDJ net due, RPAG gross, RPAAP open, RPPST pay status, RPICU, RPPOST, RPCRCD, RPSDOC/RPSDCT sales order, RPVR01, RPPYID **Batch:** F03B11Z1 **Notes:** Same RP prefix as F0411 but a different table. No SFXE in the AR key. #### Batch Invoices **Table:** F03B11Z1 **Keys:** VJEDUS, VJEDBT, VJEDTN, VJEDLN **Important:** VJDOC, VJDCT, VJKCO, VJSFX, VJAN8, VJDGJ, VJDIVJ **Batch:** Itself **Notes:** VJ prefix. Processed into F03B11 and F0911 by the batch invoice processor. #### Receipts Header **Table:** F03B13 **Keys:** RYPYID **Important:** RYCKNU receipt number, RYAN8, RYPYR payor, RYDMTJ receipt date, RYDGJ G/L date, RYCKAM receipt amount, RYAAP unapplied, RYPOST, RYICU batch, RYCRCD **Notes:** One row per receipt. RYAAP shows the unapplied amount. #### Receipts Detail **Table:** F03B14 **Keys:** RZPYID, RZRC5 **Important:** RZDOC, RZDCT, RZKCO, RZSFX invoice paid, RZPAAP amount, RZADSA discount taken, write-off and chargeback amounts, RZDGJ **Notes:** Join F03B13 on PYID, then F03B11 on DOC, DCT, KCO, SFX. #### Customer Master by Line of Business **Table:** F03012 **Keys:** AIAN8, AICO **Important:** AIARC G/L offset, AITRAR payment terms, AIACL credit limit, AIHDAR hold invoices, AIRYIN payment instrument, AICRCD **Notes:** Company 00000 holds the default record when line of business is off. #### Address Book - Who's Who **Table:** F0111 **Keys:** WWAN8, WWIDLN **Important:** WWALPH name, WWMLNM mailing name, WWGNNM given, WWSRNM surname, WWATTL title, WWTYC type code **Notes:** WWIDLN 0 is the entity itself; contacts start at 1. Basis of a supplier or customer contact list. #### Address Book - Contact Phone Numbers **Table:** F0115 **Keys:** WPAN8, WPIDLN, WPCNLN, WPRCK7 **Important:** WPPHTP phone type, WPAR1 prefix, WPPH1 number **Notes:** Join F0111 on AN8 and IDLN. #### Electronic Address **Table:** F01151 **Keys:** EAAN8, EAIDLN, EARCK7 **Important:** EAETP address type (E email), EAEMAL address, EAECLASS category **Notes:** Join F0111 on AN8 and IDLN for contact emails. **Notes:** From the 9.2 table definitions and the Accounts Payable guide for pay status values. Vendor contact list query: F0401 joined to F0111 on AN8, then left join F0115 and F01151 on AN8 and IDLN. Amounts are stored without decimals; dates are Julian CYYDDD. ## Content **Intro:** This reference lists keys and working columns for the JD Edwards EnterpriseOne 9.2 payables and receivables tables: F0411 vouchers, F0413 and F0414 payments, F03B11 invoices, F03B13 and F03B14 receipts, the Z1 batch input tables and the who's who contact tables. Use it to write aging, payment and contact queries that join correctly. **Sections:** #### How the tables fit **Body:** On the payables side, each voucher pay item is a row in F0411, keyed by document number, type, company, pay item and pay item extension. A payment is one F0413 header (RMPYID) with one F0414 line per voucher pay item paid. On the receivables side, each invoice pay item is a row in F03B11, keyed by document, type, company and pay item; a receipt is one F03B13 header (RYPYID) with F03B14 lines per invoice applied. Both ledgers use the RP prefix, so always qualify the table name in SQL. Imports go through F0411Z1 (VL prefix) and F03B11Z1 (VJ prefix). #### Open items and pay status **Body:** The open amount is RPAAP in both F0411 and F03B11; a fully paid item has RPAAP 0 and, in A/P, pay status P. A/P pay status codes come from UDC 00/PS: A approved for payment, H hold pending approval, P paid in full, R retainage, % withholding applies and # payment in process. Hold codes beyond H are site specific. For aging, use RPDDJ (net due) against your as-of date, and remember that posted status RPPOST tells you whether the G/L entry exists, not whether the item is paid. **Bullets:** - Open AP: F0411 where RPAAP <> 0 - Open AR: F03B11 where RPAAP <> 0 - Unapplied cash: F03B13 where RYAAP <> 0 #### Worked example: who paid this invoice? **Body:** A customer disputes invoice 50231 RI in company 00100, pay item 001. Find it in F03B11 with RPDOC = 50231, RPDCT = 'RI', RPKCO = '00100'. Then select F03B14 where RZDOC, RZDCT, RZKCO and RZSFX match; each row gives RZPYID and the amount applied, discount and write-off. Join RZPYID to F03B13.RYPYID for the receipt number (RYCKNU), date (RYDMTJ) and payor. The same pattern works for A/P: F0411 to F0414 on document keys, then F0413 for the payment number and bank account. #### Gotchas **Body:** F0411 includes RPSFXE in its primary key; F03B11 does not. Divide amounts by 100 for two decimal currencies, and by the right power of ten for others. A supplier contact list needs F0111 lines with WWIDLN greater than 0 for people; line 0 is the company itself. Phones and emails are child rows keyed by AN8, IDLN and a line number, so a contact can have several. Voided payments keep their F0413 row with a void date in RMVDGJ, so filter them out of cash reports. **Cta:** If your AP and AR teams want to ask 'what is open for this supplier' or 'who paid this invoice' in plain English, answered from F0411 and F03B11 on your own servers, we can set that up. **Faq:** #### What is the F0411 table in JDE? **Answer:** F0411 is the Accounts Payable Ledger. Each row is a voucher pay item, keyed by RPDOC, RPDCT, RPKCO, RPSFX and RPSFXE. It holds supplier, payee, invoice, G/L and due dates, gross and open amounts, pay status and batch information. Payments against it are in F0413 and F0414. #### What is the F03B11 table in JDE? **Answer:** F03B11 is the Customer Ledger for accounts receivable invoices, keyed by RPDOC, RPDCT, RPKCO and RPSFX. It stores customer, invoice and due dates, gross and open amounts, pay status and the related sales order. Receipts applied to it are in F03B13 (header) and F03B14 (detail). #### How do I build a vendor contact list in JDE 9.2? **Answer:** Start from F0401 for suppliers, join F0101 for the name, then F0111 on AN8 for who's who lines (WWIDLN above 0 for contacts). Left join F0115 for phones and F01151 for email addresses on AN8 and IDLN. Filter EAETP = 'E' for email addresses. #### Which tables hold JDE payments and receipts? **Answer:** A/P payments: F0413 header keyed by RMPYID and F0414 detail keyed by RNPYID and RNRC5. A/R receipts: F03B13 header keyed by RYPYID and F03B14 detail keyed by RZPYID and RZRC5. Detail rows carry the voucher or invoice keys, so you can join back to F0411 or F03B11. ## Search terms jde f0411 table, f0411 table in jde, f03b11 table in jde, jd edwards accounts receivable, jde 9.2 vendor contact list, jde f0413 f0414 payment tables, jde f03b13 f03b14 receipts, jde pay status codes --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json