JDE Reference
Interactive Tool
JDE Reference Database
A searchable reference for JD Edwards EnterpriseOne tables, programs, fields, and relationships. Built for supply chain and analytics practitioners extracting EnterpriseOne data into Databricks, Snowflake, or any downstream analytics platform — with a quirks guide for the Julian dates, implied decimals, and UDC decodes that trip up every first JDE extract.
/
43
Tables
33
Programs
19
Modules
10
Quirks
How this is scoped
- Scope: the supply-chain core — Sales Order Management, Procurement, Inventory, and Address Book, plus the General Ledger and the Foundation control tables (companies, fiscal patterns, currencies, UDCs, next numbers, business units). The catalog now spans 43 tables and is still growing; it leads with the objects an analyst reaches for most, not a full data-dictionary dump.
- Release awareness: EnterpriseOne 9.2 ships under Continuous Delivery and is supported into the mid-2030s, so the classic tables here stay current — there is no forced re-platforming to a new data model on the horizon. Tables that also exist in JDE World A9.x carry an “Also in JDE World” tag, and any superseded table names a successor.
- Field data: key and analytics-relevant columns are populated per table, each carrying the semantic flags that drive correct SQL — Julian date, implied decimals, padded string, and UDC decode. Structure is cross-checked against erpref.com and the Oracle EnterpriseOne documentation; descriptions are original wording. Last verified July 2026.
- Built for analytics: relationships focus on the joins you'll actually write — header/detail pairs, the sales-update history split, foreign keys on shared data-dictionary aliases (AN8, ITM, MCU), and the UDC decode hop to F0005 that no other free reference visualizes.
Frequently Referenced Tables
The workhorses of JDE distribution analytics — sales orders, item master and balances, the inventory ledger, and the address book.
- F4211Sales order detail — one row per order line; the core sales transaction table
- F4201Sales order header — one row per order carrying customer, dates, totals, and shipping terms
- F4101Item master — one row per item with descriptions, units of measure, and category codes shared across branches
- F41021Item location — on-hand, committed, and inbound quantities by item, branch, location, and lot
- F4111Item ledger (Cardex) — every inventory movement with quantity, cost, and links back to source documents
- F0101Address book master — the shared registry of customers, suppliers, employees, and other entities
- F0911General ledger transaction detail: every journal entry line with its account, G/L date, amount, batch, subledger, and source-document references.
- F4311Purchase order detail - one row per PO line with item, branch, quantities, unit/extended costs, and the status flow
- F43121Purchase order receiver - receipt and voucher-match rows linking PO lines to inventory receipts and A/P vouchers (the 3-way match backbone)
- F4106Item base price table: effective-dated unit and credit prices by item and branch, optionally specific to a customer, customer group, currency, and unit of measure.
Frequently Used Programs
The interactive applications and batch jobs (UBEs) behind the order-to-cash data — what writes the rows you're querying.
- P4210Sales Order Entry — the interactive application that creates and maintains F4201/F4211 orders
- R42800Sales Update — the batch job that books shipped orders to the G/L and A/R and moves finished lines to history (F42119)
- P4101Item Master — the interactive application that creates and maintains F4101 items
- R42565Invoice Print — the batch job that generates customer invoices from sales order lines
- R42520Pick Slip Print — the batch job that produces warehouse pick documents and commits inventory
- P4310Purchase Order Entry — create and revise purchase orders, requisitions, and quotes (header and detail lines)
- P4312PO Receipts — record receipt of goods against purchase orders, updating on-hand inventory and creating receiver records
- R09801General Ledger Post — validate approved journal entry batches and post them to account balances
- R43500Purchase Order Print — batch-print purchase orders for suppliers and advance order line statuses
The JDE quirks guide
The encoding traps that make a first JDE extract wrong in ways that look right. Each links to a worked Databricks SQL pattern.
Julian dates (CYYDDD)
Turn the 6-digit CYYDDD number into a real DATE — and reverse it for filters.
Implied decimals
Why 100000 means 1,000.00, and how to scale amounts with the F9210 setting.
No nulls — blanks & zeros
JDE stores blanks and zeros, not NULL. NULLIF patterns for clean aggregates.
Business unit padding (MCU)
MCU is right-justified CHAR(12) — the silent join-killer. TRIM both sides.
Item numbers (ITM / LITM / AITM)
Short, long, and third item numbers, and the F4101 cross-reference join.
UDC decode (F0005 / F0004)
Decode coded fields with the composite DRSY/DRRT/DRKY key — a worked example.
Audit columns
USER/PID/JOBN/UPMJ/TDAY, and using PID as a lineage marker.
Sales history (F4211 → F42119)
Lines move to F42119 at sales update. The open + closed UNION pattern.
Z tables (interface staging)
EDI/interface staging tables — exclude them from analytics.
Next numbers (F0002)
How JDE assigns document numbers, and why sequence gaps are normal.
Browse by Module
Organized by JD Edwards system code. Click a module to see its tables and programs.
- 00FoundationTechnical foundation shared by every application: user defined codes, next numbers, companies, and business units9 tables · 5 programs
- 01Address BookThe central registry of customers, suppliers, employees, and other entities every module points back to6 tables · 1 programs
- 03BAccounts ReceivableCustomer invoices, receipts, and aging that close out the sell side of the order-to-cash cycle0 tables · 0 programs
- 04Accounts PayableSupplier vouchers and payments that close out the buy side of the procure-to-pay cycle1 tables · 0 programs
- 09General AccountingThe general ledger — account master, balances, and the account ledger every subsystem posts into3 tables · 2 programs
- 12Fixed AssetsAsset master, depreciation, and asset accounting tied back to the general ledger0 tables · 0 programs
- 30Product Data ManagementBills of material, routings, and product costing that define how items are built0 tables · 0 programsSupply chain
- 31Shop Floor ManagementWork order execution, parts lists, and routing instructions for the manufacturing floor0 tables · 0 programsSupply chain
- 32ConfiguratorRules-driven configuration of assemble-to-order items at order entry0 tables · 0 programsSupply chain
- 34Requirements PlanningMRP, master scheduling, and DRP that translate demand into planned supply0 tables · 0 programsSupply chain
- 40Distribution BaseShared setup for the distribution suite: order activity rules, line types, and automatic accounting instructions3 tables · 0 programsSupply chain
- 41Inventory ManagementItem master, branch/plant records, on-hand balances, and the inventory movement ledger12 tables · 13 programsSupply chain
- 42Sales Order ManagementOrder-to-cash from order entry through shipment, invoicing, and sales history5 tables · 7 programsSupply chain
- 43ProcurementPurchase order entry, receipts, and voucher matching across the procure-to-pay cycle4 tables · 5 programsSupply chain
- 45Advanced PricingRules-based pricing and adjustments layered over base sales and procurement pricing0 tables · 0 programsSupply chain
- 46Warehouse ManagementDirected putaway, picking, and replenishment inside the four walls of the warehouse0 tables · 0 programsSupply chain
- 47Electronic Data InterchangeInbound and outbound EDI staging tables that exchange documents with trading partners0 tables · 0 programsSupply chain
- 49Transportation ManagementShipment and load planning, routing, and freight for outbound and inbound movements0 tables · 0 programsSupply chain
- 52Contract BillingContract-based billing for project and service work invoiced against agreed terms0 tables · 0 programs
Sources & further reading
Table structure, program behavior, and release status are authoritative only at source. Use these references to verify before building on any claim in this reference.
Oracle official
- Oracle JD Edwards EnterpriseOne documentation library — the authoritative source for application functionality, table appendices ("Tables Used by…"), and release notes across the EnterpriseOne suite.
Community references
- erpref.com — the deepest free JDE table/column reference (full 920-schema dumps). Useful for spot-checking columns, keys, and data-dictionary aliases against this catalog.
- JDELIST forums — long-running practitioner community; the fastest place to sanity-check real-world behavior of a program, table, or setup.
- Quest Oracle Community — Oracle user group with JD Edwards content, events, and roadmap briefings.