JDE Reference
JDE Reference Database
EnterpriseOne is a system of conventions rather than data types: dates arrive as Julian CYYDDD numbers, quantities as implied decimals, every item carries three numbers, and a coded column means nothing until you decode it against F0005. A searchable reference for extracting EnterpriseOne data, with a quirks guide for what a first extract gets wrong.
Free & ungated · Last verified September 2026
- Tables
- 94
- Programs
- 92
- Modules
- 18
- Quirks
- 12
How this is scoped
- Scope: the supply-chain core, from Sales Order Management, Procurement, and Inventory back to the Address Book, then outward: manufacturing (bills of material, routings, work orders, MRP, forecasting), warehouse execution (directed putaway, picking, 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), Advanced Pricing, and the General Ledger with the Foundation control tables (companies, fiscal patterns, currencies, UDCs, next numbers, business units). It spans 94 tables, leads with the objects an analyst reaches for most rather than a full data-dictionary dump, and is still growing.
- Feeds: the business-problem grid draws on this reference for Inventory & Working Capital, Demand Planning & Forecasting, Customer Service & Fulfillment, Procurement & Supply and Manufacturing & Production.
- 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 as a structural cross-version cue, not a support signal; Oracle moved World A9.4 to sustaining support on May 1, 2025. 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. Database ingestion can use log-based CDC or a scheduled Lakeflow query-based path when a table has one reliable monotonic cursor. The extraction guide covers both Oracle and SQL Server back ends, why JDE’s split Julian date/time audit columns complicate cursor ingestion, physical deletes, and the MERGE patterns that land changes 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 16 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.
- Quest — Integrating JD Edwards with external systems (opens in new tab) — practitioner guidance on using Orchestrator for external-system integration, complementing Oracle’s endpoint documentation.
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 Data Interface for EDI Implementation Guide (opens in new tab) — first-party documentation for system-47 interface tables, inbound and outbound processors, processed flags, and purge programs.
- 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.
- AIS REST API — execute orchestrations (opens in new tab) — Oracle’s Orchestrator service endpoints for invoking named orchestrations through AIS.
- Databricks Lakeflow Connect (opens in new tab) — first-party CDC connectors for SQL Server (GA) and Oracle (Beta) — the back ends JDE runs on.
- Databricks query-based connector reference (opens in new tab) — scheduled database ingestion with one monotonic cursor column, optional soft-delete conditions, and Beta hard-delete tracking.
- JDELIST — SQL Server Change Data Capture (CDC) thread (opens in new tab) — community practice for enabling native CDC on JDE tables.