OracleFree referencePDF, Excel, Word exportOracle JD Edwards EnterpriseOneManufacturing

JD Edwards EnterpriseOne Core Table Reference (F0911, F4801, F41021 and more)

JD Edwards EnterpriseOne table names look cryptic until you know the pattern: an F, a system code, and a sequence, with every column prefixed by two letters. This reference lists the tables CNC admins, report writers and functional consultants reach for most, with the prefix and the fields that usually go in a WHERE clause.

Download:

Table	Description	Area	Column prefix	Common key and filter fields
F0004	User Defined Code Types	Foundation	DT	DTSY (system code), DTRT (code type)
F0005	User Defined Code Values	Foundation	DR	DRSY, DRRT, DRKY (code value)
F0002	Next Numbers	Foundation	NN	NNSY (system code)
F0006	Business Unit Master	Foundation	MC	MCMCU (business unit, right justified)
F0010	Company Constants	Financials	CC	CCCO (company)
F0013	Currency Codes	Financials	CV	CVCRCD (currency code)
F0015	Currency Exchange Rates	Financials	CX	CXCRCD, CXCRDC, CXEFT (effective date)
F0092	Library List - User	Technical	UL	ULUSER (user ID)
F0111	Address Book - Who's Who	Address Book	WW	WWAN8 (address number), WWIDLN (line ID)
F0115	Address Book - Phone Numbers	Address Book	WP	WPAN8, WPIDLN, WPRCK7 (line number)
F0116	Address by Date	Address Book	AL	ALAN8, ALEFTB (effective flag)
F0150	Address Organization Structure Master	Address Book	MA	MAOSTP (structure type), MAPA8 (parent), MAAN8 (child)
F0401	Supplier Master	Accounts Payable	A6	A6AN8 (supplier address number)
F0411	Accounts Payable Ledger	Accounts Payable	RP	RPKCO, RPDCT, RPDOC, RPSFX (pay item)
F03012	Customer Master by Line of Business	Accounts Receivable	AI	AIAN8 (customer), AICO (company)
F0311	Accounts Receivable Ledger	Accounts Receivable	RP	RPKCO, RPDCT, RPDOC, RPSFX
F0901	Account Master	General Accounting	GM	GMAID (account ID), GMMCU, GMOBJ, GMSUB
F0902	Account Balances	General Accounting	GB	GBAID, GBCTRY, GBFY, GBLT (ledger type), GBCO
F0911	Account Ledger	General Accounting	GL	GLKCO, GLDCT, GLDOC, GLDGJ (GL date), GLLT, GLEXTL
F4100	Location Master	Inventory	LM	LMMCU (branch), LMLOCN (location)
F4104	Item Cross Reference	Inventory	IV	IVXRT (cross reference type), IVITM, IVAN8
F4105	Item Cost File	Inventory	CO	COITM, COMCU, COLOCN, COLOTN, COLEDG (cost method)
F4106	Item Base Price File	Inventory	BP	BPITM, BPMCU, BPUOM, BPCRCD, BPEXDJ (expiration)
F41021	Item Location	Inventory	LI	LIITM, LIMCU, LILOCN, LILOTN, LIPQOH (on hand)
F4111	Item Ledger (Cardex)	Inventory	IL	ILITM, ILMCU, ILDCT, ILDOC, ILTRDJ (transaction date)
F40205	Line Type Constants	Distribution	LF	LFLNTY (line type)
F4201	Sales Order Header File	Sales Order Management	SH	SHKCOO, SHDOCO, SHDCTO
F4301	Purchase Order Header	Procurement	PH	PHKCOO, PHDOCO, PHDCTO
F43121	Purchase Order Receiver File	Procurement	PR	PRMATC (match type), PRDOC, PRDCT
F3002	Bill of Material Master	Product Data Management	IX	IXKITL (parent), IXCPNT (component), IXMMCU
F3003	Routing Master	Product Data Management	IR	IRKIT (parent), IROPSQ (operation sequence), IRMMCU
F4801	Work Order Master File	Shop Floor	WA	WADOCO (order number), WADCTO (type), WAMCU, WAITM
F3111	Work Order Parts List	Shop Floor	WM	WMDOCO, WMCPIT (component item), WMCOBY (line)
F3112	Work Order Routing	Shop Floor	WL	WLDOCO, WLOPSQ (operation sequence)
F00165	Media Object Data (attachments)	Technical	GD	GDOBNM (object name), GDTXKY (text key)
F9210	Data Dictionary Field Specifications	Technical	FR	FRDTAI (data item name)
F9860	Object Librarian Master	Technical	OM	OMOBNM (object name)
F983051	Versions List	Technical	VR	VRPID (UBE or application), VRVERS (version)
F986110	Job Control Status Master	Technical	JC	JCJOBNBR (job number), JCFNDFUF1 (UBE name)

Most JDE tables store dates as Julian values (CYYDDD) and amounts without decimals, so convert before reporting. Table and field names are the standard ones; confirm against the Data Dictionary and Object Librarian in your own release, since customised or added fields differ.

Ask your JDE data in plain English

Optional: a short review of how a read-only natural language layer could sit over your JDE tables.

Optional. The tool and every export work without this. No spam.

How to use the reference

Type a table number, a description word or a column prefix into the search box. For example, searching for GL finds F0911, and searching for work order finds F4801, F3111 and F3112. Use the key column to decide which fields to filter on first so your query hits the table index. Export the filtered list to Excel or CSV when you are building a data dictionary for a reporting or integration project.

How JDE names tables and columns

A table name is F plus the product system code plus a sequence, so F0911 belongs to system 09 (General Accounting) and F4801 to system 48. Column names take a two-letter prefix that is unique per table, followed by the data dictionary alias. GLDOC is the document number column in F0911 (prefix GL), and WADOCO is the order number in F4801 (prefix WA). Once you know the prefix you can read an unfamiliar SQL statement quickly.

Tables live in business data libraries or schemas such as PRODDTA, TESTDTA and CRPDTA.
Control tables such as F0005 and F00921 usually live in PRODCTL.
Views start with V and are not listed here.

Reading values correctly

Dates are stored as Julian numbers in CYYDDD form, where C is the century offset from 1900, YY the year and DDD the day of year. Amounts are stored as integers with implied decimals, so GLAA of 123456 is 1,234.56 in a two-decimal currency. Business unit values such as GLMCU are right justified and padded with spaces, so compare with LTRIM or pad your literal.

Common mistakes

Querying production tables with a full scan during business hours, forgetting the ledger type filter on F0911 and F0902 (AA is actual, BA is budget), and joining on item number fields without noticing that the short item number ITM and the second item number LITM are different columns. Always test in a copy path code first.

Frequently Asked Questions

What does the F in F0911 mean?

F marks a file or table in the JD Edwards naming convention. The next digits are the system code and a sequence, so F0911 is a table in system 09, General Accounting. Business functions start with B, applications with P and batch reports with R.

Why are JDE dates numbers like 126292?

JDE stores dates in Julian form CYYDDD. The first digit is years since 1900 divided by 100, then two digits for the year and three for the day of year. 126292 is day 292 of 2026, which is 19 October 2026.

Where do the amounts get their decimals?

The database holds integers. The Data Dictionary item defines display decimals, and for amount fields the currency decides the scale. In most currencies you divide by 100 to get the real value, but zero and three decimal currencies differ.

Is this list complete?

No. EnterpriseOne has thousands of tables. This list covers the ones most queried in distribution, manufacturing and financials. For anything else search the Object Librarian or the Data Dictionary in your own environment.

If you spend time hunting for the right JDE table, we can put a natural language layer over your JDE data that shows the SQL it runs, read-only and under your existing roles.

Talk to an Expert Explore More Free Tools

Related Tools

Developer Tools

More Oracle tools

See all

Back to All Tools