JDE Reference
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 what a first extract gets wrong.
Free & ungated · Last verified September 2026
94
Tables
92
Programs
18
Modules
12
Quirks
How this is scoped
- Scope: the supply-chain core (Sales Order Management, Procurement, Inventory, and Address Book), extended into manufacturing (bills of material, routings, work orders, MRP and forecasting), warehouse execution (directed putaway, picking, and replenishment), transportation and freight (shipments, loads, carriers, freight audit), EDI staging (inbound orders and acknowledgments, outbound ship notices and invoices), the financials that settle it (receivables, payables, fixed assets), and Advanced Pricing, plus the General Ledger and the Foundation control tables (companies, fiscal patterns, currencies, UDCs, next numbers, business units). The catalog now spans 94 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 carries Premier Support through at least 2037 (opens in new tab), so the classic tables here stay current — there is no forced re-platforming to a new data model on the horizon. Since October 2025 Oracle names updates by year (“Release 26 (opens in new tab)” means Applications Update 26 on Tools 9.2.26), but the codeline is still 9.2, and the table structures here are unchanged by it. Tables that also exist in JDE World A9.x carry an “Also in JDE World” tag. No curated table currently declares a successor; any future superseded record must name one.
- 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 (opens in new tab) and the Oracle EnterpriseOne documentation (opens in new tab); descriptions are original wording. Last verified September 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 — current sales lines, including completed lines retained by the site's purge processing options
- 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.
- F4801Work order header — one row per work order carrying the item being made, branch, quantities ordered/completed/scrapped, status, and the requested/start/completion dates that drive shop floor and maintenance analytics
- F4215One row per shipment - the anchor record Transportation Management creates when order lines are grouped for delivery; despite the F42xx name it belongs to system 49. Carries status, mode, geography, weight, value, and promised dates.
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 — books shipped orders to the G/L and A/R; processing options control whether eligible detail is copied to F42119 and purged from F4211
- 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
- R31410Order Processing — the batch job that attaches the parts list and routing to work orders, commits inventory, and prints shop floor paperwork in one pass.
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.
Read all 12 quirksGetting JDE into your lakehouse
AIS and Orchestrator provide queries and bounded file exports. For a replicated feed with delete capture, getting EnterpriseOne data out is database work. The extraction guide covers log-based CDC on the Oracle and SQL Server back ends, what audit columns can and can't do as a watermark, physical deletes, and the MERGE patterns that land them correctly in bronze.
Read the extraction guideBrowse 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 cycle4 tables · 9 programs
- 04Accounts PayableSupplier vouchers and payments that close out the buy side of the procure-to-pay cycle4 tables · 5 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 ledger2 tables · 3 programs
- 30Product Data ManagementBills of material, routings, and product costing that define how items are built3 tables · 3 programsSupply chain
- 31Shop Floor ManagementWork order execution, parts lists, and routing instructions for the manufacturing floor3 tables · 8 programsSupply chain
- 34Requirements PlanningMRP, master scheduling, and DRP that translate demand into planned supply4 tables · 6 programsSupply chain
- 40Distribution BaseShared setup for the distribution suite: order activity rules, line types, and automatic accounting instructions2 tables · 0 programsSupply chain
- 41Inventory ManagementItem master, branch/plant records, on-hand balances, and the inventory movement ledger10 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 pricing9 tables · 2 programsSupply chain
- 46Warehouse ManagementDirected putaway, picking, and replenishment inside the four walls of the warehouse7 tables · 7 programsSupply chain
- 47Electronic Data InterchangeInbound and outbound EDI staging tables that exchange documents with trading partners9 tables · 9 programsSupply chain
- 48Work Order ProcessingThe shared work-order backbone (header/master) used by manufacturing, maintenance, and service2 tables · 1 programsSupply chain
- 49Transportation ManagementShipment and load planning, routing, and freight for outbound and inbound movements8 tables · 6 programsSupply chain
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.
Show all 12 sources, graded by group
Oracle official
- Oracle JD Edwards EnterpriseOne documentation library (opens in new tab) — the authoritative source for application functionality, table appendices ("Tables Used by…"), and release notes across the EnterpriseOne suite.
- Oracle LearnJDE (opens in new tab) — Oracle's release and roadmap hub: Continuous Delivery, the Premier Support horizon, and the Release 26 naming realignment. The source behind the release-awareness claims on this page — verify them here.
- Oracle JD Edwards EnterpriseOne product page (opens in new tab) — Oracle's canonical product landing page: positioning, release news, and entry points into documentation and support. Marketing-voiced; use the documentation library above for technical claims.
Community references
- erpref.com (opens in new tab) — 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 (opens in new tab) — long-running practitioner community; the fastest place to sanity-check real-world behavior of a program, table, or setup.
- Quest Oracle Community (opens in new tab) — Oracle user group with JD Edwards content, events, and roadmap briefings.
Integration & extraction
- Oracle JDE Interoperability Fundamentals Guide (opens in new tab) — the architecture behind the Z-file and system-47 EDI staging pattern this reference catalogs: inbound processors, flat-file conversion, and the EDSP processed flag.
- Oracle JDE Tools Data Dictionary Guide (opens in new tab) — documents F9210 and the data dictionary: display decimals, edit rules, item classes. Where to verify the implied-decimal counts this reference tells you to check.
- Oracle JDE Tools Orchestrator Guide (opens in new tab) — Oracle's supported path for scheduled extraction: orchestrations, connectors, and REST data requests against EnterpriseOne.
- AIS REST API — query tables and views (opens in new tab) — the dataservice operation: query a named table or business view over REST with filters and aggregation, no DBA required.
- Databricks Lakeflow Connect (opens in new tab) — first-party CDC connectors for SQL Server (GA) and Oracle (Beta) — the back ends JDE runs on.
- JDELIST — SQL Server Change Data Capture (CDC) thread (opens in new tab) — community practice for enabling native CDC on JDE tables.