JDE Reference
All JDE Tables
Every table in the reference, sorted alphabetically. Use the jump-bar to skip to a letter, or filter by module, data class, and lifecycle. Tables in the F55–F59 systems are deliberately absent: those system codes are reserved for customer-built objects and exist only at the site that built them.
What the badges mean
- Superseded
- Superseded — a newer table has replaced it, but older scripts still read this one.
- Also in JDE World
- Also present in JDE World A9.x on the same table name.
- master
- Data class: what the table holds — master data, transaction documents, control/setup values, history, or a workfile.
- Read/write access
- Access mode: how the paired program reads or writes this table — R (read), W (write), or R/W (both).
No lifecycle badge means the table is current and not documented in JDE World. In field listings, K marks a primary-key field.
FilterShowing 94 of 94 tables
Module
Tables starting with F
- F0002Next numbers — the per-system counters JDE uses to assign document and record numberscontrol00
- F0004User defined code types — defines each UDC table (system + type) and how its values behavecontrol00
- F0005User defined code values — the lookup rows behind every UDC-validated field, keyed by system, type, and codecontrol00
- F0006Business unit master — branch/plants, cost centers, and jobs with their reporting category codesmaster00
- F0008Defines each fiscal date pattern: the fiscal-year start date and the ending date of every accounting period, used to map calendar dates to fiscal periods.control00
- F0010One row of setup constants per company: fiscal calendar assignment, current periods, base currency, and A/R and A/P aging configuration.control00
- F0013Master list of currency codes with their display decimals; the lookup behind every CRCD column.master00
- F0014Payment terms definitions: discount percentage and window, net days to pay, and split/installment settings referenced by customer and supplier masters.control00
- F0015Currency exchange rate table: dated conversion rates between currency pairs, including multiplier and divisor forms and triangulation settings.control00
- F0101Address book master — the shared registry of customers, suppliers, employees, and other entitiesmaster01
- F0111Contact (Who's Who) records attached to address book entries: individual names, titles, and contact classifications, keyed by address number and line.master01
- F0115Phone numbers for address book entries and their contacts, keyed by address number, Who's Who line, and phone line.master01
- F01151Email and other electronic addresses (URLs, EDI endpoints) for address book entries and contacts, one row per address line.master01
- F0116Effective-dated postal addresses for address book entries; the row with the latest effective date at or before a given date is the current address.master01
- F0150Parent/child links between address book numbers, organized by structure type — the hierarchy behind org structures, buying groups, and rollups.master01
- F03012Customer master by line of business: one row per customer address number and company holding A/R credit terms, collection settings, sales defaults, and rolled-up invoice history.master03B
- F03B11Customer ledger: one row per invoice pay item carrying gross, open, discount, and tax amounts plus the dates and status codes that drive A/R aging and collections.transaction03B
- F03B13Receipts header: one row per customer receipt or draft with the check amount, unapplied balance, bank account, and G/L batch identity.transaction03B
- F03B14Receipts detail: one row per application of a receipt against an invoice pay item, splitting the cash into payment, discount, write-off, chargeback, and deduction amounts.transaction03B
- F0401Supplier master - A/P defaults, payment controls, and purchasing settings for each supplier address numbermaster04
- F0411Accounts payable ledger: one row per voucher pay item with gross, open, discount, and tax amounts, due dates, pay status, and the PO keys behind three-way match.transaction04
- F0413A/P matching document: one row per supplier payment (check, EFT, draft) with the payment amount, bank account, dates, and void/reconciliation state.transaction04
- F0414A/P matching document detail: one row per application of a payment against a voucher pay item, carrying the paid amount and discount taken in both currencies.transaction04
- F0901Chart of accounts master: one row per account with its business unit, object, and subsidiary segments, posting controls, and reporting category codes.master09
- F0902Account balances: one row per account, ledger type, fiscal year, and subledger holding the beginning balance and fourteen period net-posting buckets.transaction09
- F0911General ledger transaction detail: every journal entry line with its account, G/L date, amount, batch, subledger, and source-document references.transaction09
- F1201Asset master: one row per fixed asset or piece of equipment with its company, responsible business unit, classification codes, account mapping, and acquisition/disposal dates.master12
- F1202Asset account balances: one row per asset, account, ledger type, subledger, and fiscal year holding the beginning balance and fourteen period net-posting buckets — the fixed-asset mirror of F0902.transaction12
- F30006One row per work center within a branch/plant, holding the capacity, efficiency, crew, and shift-hour attributes used by scheduling, capacity planning, and cost rollups.master30
- F3002One row per component line on a parent item's bill of material at a branch/plant, effective-dated, holding the quantity-per and usage rules that drive BOM explosion and product costing.master30
- F3003One row per operation step in an item's routing at a branch/plant, effective-dated, carrying the work center, time standards, and yield percentages that drive scheduling and labor costing.master30
- F3102One row per cost bucket on a work order — keyed by order, item, cost component, parent/child flag, and work center — holding standard, current, planned, actual, completed, and scrapped units and amounts used for manufacturing variance analysis.transaction31
- F3111Work order parts list — one row per component required by a work order, with required vs. issued quantities, scrap, commitments, and the operation each part feedstransaction31
- F3112Work order routing — one row per operation on a work order, carrying the work center, standard vs. actual machine/labor/setup hours, and quantities completed or scrapped at each steptransaction31
- F3411MRP action messages — one row per recommendation the planning run generates (order, expedite, defer, cancel, increase, decrease) for an item/branch; planners work this queue after each runtransaction34
- F3412MRP pegging — one row per lower-level requirement showing which parent item/order generated demand for a component, so you can trace a shortage up to the end-item order that caused ittransaction34
- F3413MRP time series — one row per item/branch/quantity-type/date bucket; the quantity-type dimension (demand, supply, projected on-hand, ATP, etc.) turns this narrow table into the full planning gridtransaction34
- F3460One row per forecast quantity/amount — keyed by item, branch, forecast type, requested date, year, and customer — holding the demand forecasts (both generated and adjusted) that feed MRP/DRP.transaction34
- F4009Distribution/inventory constants - system-level configuration flags stored one row per system codecontrol40
- F40205Line type control constants - defines how each order line type behaves against G/L, inventory, A/R, A/P, and taxescontrol40
- F4071One row per price adjustment definition: the named rule (discount, rebate, promotion, override) with the control switches that decide how it applies — group keys, level-break type, adjustment level, mandatory and G/L behavior.control45
- F4072One row per adjustment rate: the factor value for a given adjustment name, item or item group, customer or customer group, currency, UOM, quantity level break, and effective-date window. The rate lookup behind every Advanced Pricing calculation.master45
- F4074Price adjustment ledger - the pricing history behind each order line, one row per adjustment applied by Advanced Pricingtransaction45
- F4092One row per price group definition: names an item, customer, or order group and lists which category-code keys (up to 10) make up the group, ordered by the key columns.control45
- F40941One row per item price group combination: an item group plus a specific set of item category-code values, assigned a numeric key ID (IGID) that F4072 rate rows point at.control45
- F40942One row per customer price group combination: a customer group plus a specific set of customer category-code values, assigned a numeric key ID (CGID) that F4072 rate rows point at.control45
- F40943One row per order detail group combination: an order detail group plus a specific set of sales-order line attribute values (up to 8), assigned a numeric key ID (OGID) that F4072 rate rows point at.control45
- F4100Warehouse location master: one row per storage location within a branch/plant, defining physical attributes plus putaway, pick, and replenishment behavior.master41
- F41001Branch/plant inventory constants: the per-branch switchboard for item number symbols, location formatting, costing methods, commitment rules, and G/L interface options.control41
- F41002Item-level unit of measure conversions: the factor that translates one UOM into another for a given item and branch, used everywhere quantities change units.control41
- F4101Item master — one row per item with descriptions, units of measure, and category codes shared across branchesmaster41
- F4102Item branch — branch/plant-level item attributes, planning parameters, and sourcing responsibilitymaster41
- F41021Item location — on-hand, committed, and inbound quantities by item, branch, location, and lotmaster41
- F4104Item cross-reference: links internal item numbers to external identifiers such as customer or supplier part numbers, substitutes, and replacements, keyed by cross-reference type.master41
- F4105Item cost table: one row per item, branch, location, lot, and cost method carrying the unit cost used to value inventory and purchasing transactions.master41
- 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.master45
- F41061Supplier price catalog: supplier- and catalog-specific purchase prices with quantity breaks and effective date ranges, feeding PO unit cost retrieval.master45
- F4108Lot master: one row per lot or serial number by item and branch, holding lot status, grade, potency, supplier lot linkage, and the full set of lot control dates.master41
- F4111Item ledger (Cardex) — every inventory movement with quantity, cost, and links back to source documentstransaction41
- F4201Sales order header — one row per order carrying customer, dates, totals, and shipping termstransaction42
- F4209Held orders file - one row per order or line currently or previously on hold, including who released it and whentransaction42
- F4211Sales order detail — current sales lines, including completed lines retained by the site's purge processing optionstransaction42
- F42119Sales order detail history — eligible lines copied from F4211 by configured sales-update/history purging; same layout as F4211history42
- 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.transaction49
- F42199Sales order detail ledger - writes a history row every time an F4211 line changes, so each line can appear many times keyed by update date/timehistory42
- F4301Purchase order header - one row per procurement document carrying supplier, order-level dates, totals, terms, and currencytransaction43
- F4311Purchase order detail - one row per PO line with item, branch, quantities, unit/extended costs, and the status flowtransaction43
- F43121Purchase order receiver - receipt and voucher-match rows linking PO lines to inventory receipts and A/P vouchers (the 3-way match backbone)transaction43
- F43199P.O. detail ledger - audit history of purchase order line changes, including change-order tracking, keyed by an internal unique IDhistory43
- F4600One row per requested warehouse movement — the demand side of WMS: a putaway, pick, or replenishment waiting for the system to decide where stock should move.transaction46
- F46010Item warehouse profile: one row per branch/item holding WMS handling rules — mixing, one- vs two-phase movement, and the item's fixed special-purpose locations.master46
- F46011Item unit-of-measure definition for WMS: one row per branch, item or dimension group, and UOM carrying physical dimensions, weight, cube, container, and stacking rules the capacity engine uses.master46
- F4602Warehouse-managed contents of each location: one row per item/lot/UOM-structure detail with on-hand, committed, inbound/outbound quantities, and the cube and weight consumed.master46
- F46022Location dimension definitions: gross and usable width, depth, height, and cube per branch and location dimension group — the location side of putaway capacity math.control46
- F46024Location capacity by quantity: the maximum count of an item or item dimension group, per UOM and container, that a location dimension group can hold — used when capacity is checked by quantity instead of volume.control46
- F4611One row per system-generated movement suggestion answering an F4600 request: the proposed from/to location, quantity, cube and weight charged, and wave/task assignment.transaction46
- F47011One row per inbound EDI customer purchase order (X12 850) waiting to become a JDE sales order header; staging mirror of F4201.workfile47
- F47012One row per line on an inbound EDI customer purchase order (850); staging mirror of the sales order detail F4211.workfile47
- F47021One row per inbound EDI purchase order acknowledgment (X12 855) from a supplier, staged against a JDE purchase order header.workfile47
- F47022One row per acknowledged purchase order line on an inbound 855; staging mirror of the PO detail F4311.workfile47
- F47036One row per outbound advance ship notice (X12 856) at the shipment level, written by the R47032 extraction at the top hierarchy break.workfile47
- F47037One row per hierarchy line of an outbound 856 (order, pack, or item level) under a shipment header; sales-order lines plus SSCC/UPC pack identifiers.workfile47
- F47046One row per outbound EDI invoice (X12 810) header extracted from billed sales orders; the staging copy of what was billed to the customer.workfile47
- F470461The additional-header companion to F47046: one row per outbound EDI invoice (810) carrying the invoice-level totals rolled up from the selected detail lines, the tax authorities and rates behind them, and the payment terms — none of which the base header holds.workfile47
- F47047One row per line on an outbound EDI invoice (810); billed quantities and prices by sales order line, staged for transmission.workfile47
- 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 analyticstransaction48
- F4801TWork order tag — one row per work order (same key as F4801) holding manufacturing extensions: line/cell, shift, planned cost buckets, secondary quantities, and production-number fieldstransaction48
- F4906One row per carrier - the transportation attributes (SCAC code, auto-pay, performance rating) hung off an address book number that acts as a carrier.master49
- F4941One row per routing step of a shipment - where the carrier, mode, load assignment, scheduled vs. actual ship/delivery timestamps, and billable vs. payable freight totals live. The workhorse table for carrier performance and freight cost analysis.transaction49
- F4942One row per order line per shipment routing step - the bridge between order detail and the shipment, carrying the line's shipped quantity, weight, volume, and value.transaction49
- F4945One row per calculated freight charge on a shipment routing step or load - billable (customer) and payable (carrier) charges by rate name and charge code, as they stand before freight update moves them to history.transaction49
- F4960One row per load (trip) - a planned vehicle departure that groups shipments, keyed by trip depot plus load number, with carrier, vehicle, load status, and distance.transaction49
- F4961One row per leg of a load - a depot-to-stop slice of the trip with scheduled versus confirmed weight, volume, and cube, plus scheduled and actual ship dates.transaction49
- F4981One row per freight charge written by freight update (R4981) - the permanent audit trail that ties every billable and payable charge to the G/L document (voucher or invoice) it created. The system-of-record table for freight spend analytics.history49