# JD Edwards EnterpriseOne Core Table Reference (F0911, F4801, F41021 and more) > Source: https://netray.co/tools/jde-enterpriseone-core-table-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Searchable list of the JD Edwards EnterpriseOne tables you query most often, with column prefix and the key fields to filter on. ## Category oracle ## Erp Oracle JD Edwards EnterpriseOne ## Industry Manufacturing ## Audience - JDE CNC administrator - JDE functional consultant - JDE developer - Report writer ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Description **Key:** name **Type:** text #### Area **Key:** area **Type:** text #### Column prefix **Key:** prefix **Type:** text #### Common key and filter fields **Key:** keys **Type:** text **Rows:** #### User Defined Code Types **Table:** F0004 **Area:** Foundation **Prefix:** DT **Keys:** DTSY (system code), DTRT (code type) #### User Defined Code Values **Table:** F0005 **Area:** Foundation **Prefix:** DR **Keys:** DRSY, DRRT, DRKY (code value) #### Next Numbers **Table:** F0002 **Area:** Foundation **Prefix:** NN **Keys:** NNSY (system code) #### Business Unit Master **Table:** F0006 **Area:** Foundation **Prefix:** MC **Keys:** MCMCU (business unit, right justified) #### Company Constants **Table:** F0010 **Area:** Financials **Prefix:** CC **Keys:** CCCO (company) #### Currency Codes **Table:** F0013 **Area:** Financials **Prefix:** CV **Keys:** CVCRCD (currency code) #### Currency Exchange Rates **Table:** F0015 **Area:** Financials **Prefix:** CX **Keys:** CXCRCD, CXCRDC, CXEFT (effective date) #### Library List - User **Table:** F0092 **Area:** Technical **Prefix:** UL **Keys:** ULUSER (user ID) #### Address Book - Who's Who **Table:** F0111 **Area:** Address Book **Prefix:** WW **Keys:** WWAN8 (address number), WWIDLN (line ID) #### Address Book - Phone Numbers **Table:** F0115 **Area:** Address Book **Prefix:** WP **Keys:** WPAN8, WPIDLN, WPRCK7 (line number) #### Address by Date **Table:** F0116 **Area:** Address Book **Prefix:** AL **Keys:** ALAN8, ALEFTB (effective flag) #### Address Organization Structure Master **Table:** F0150 **Area:** Address Book **Prefix:** MA **Keys:** MAOSTP (structure type), MAPA8 (parent), MAAN8 (child) #### Supplier Master **Table:** F0401 **Area:** Accounts Payable **Prefix:** A6 **Keys:** A6AN8 (supplier address number) #### Accounts Payable Ledger **Table:** F0411 **Area:** Accounts Payable **Prefix:** RP **Keys:** RPKCO, RPDCT, RPDOC, RPSFX (pay item) #### Customer Master by Line of Business **Table:** F03012 **Area:** Accounts Receivable **Prefix:** AI **Keys:** AIAN8 (customer), AICO (company) #### Accounts Receivable Ledger **Table:** F0311 **Area:** Accounts Receivable **Prefix:** RP **Keys:** RPKCO, RPDCT, RPDOC, RPSFX #### Account Master **Table:** F0901 **Area:** General Accounting **Prefix:** GM **Keys:** GMAID (account ID), GMMCU, GMOBJ, GMSUB #### Account Balances **Table:** F0902 **Area:** General Accounting **Prefix:** GB **Keys:** GBAID, GBCTRY, GBFY, GBLT (ledger type), GBCO #### Account Ledger **Table:** F0911 **Area:** General Accounting **Prefix:** GL **Keys:** GLKCO, GLDCT, GLDOC, GLDGJ (GL date), GLLT, GLEXTL #### Location Master **Table:** F4100 **Area:** Inventory **Prefix:** LM **Keys:** LMMCU (branch), LMLOCN (location) #### Item Cross Reference **Table:** F4104 **Area:** Inventory **Prefix:** IV **Keys:** IVXRT (cross reference type), IVITM, IVAN8 #### Item Cost File **Table:** F4105 **Area:** Inventory **Prefix:** CO **Keys:** COITM, COMCU, COLOCN, COLOTN, COLEDG (cost method) #### Item Base Price File **Table:** F4106 **Area:** Inventory **Prefix:** BP **Keys:** BPITM, BPMCU, BPUOM, BPCRCD, BPEXDJ (expiration) #### Item Location **Table:** F41021 **Area:** Inventory **Prefix:** LI **Keys:** LIITM, LIMCU, LILOCN, LILOTN, LIPQOH (on hand) #### Item Ledger (Cardex) **Table:** F4111 **Area:** Inventory **Prefix:** IL **Keys:** ILITM, ILMCU, ILDCT, ILDOC, ILTRDJ (transaction date) #### Line Type Constants **Table:** F40205 **Area:** Distribution **Prefix:** LF **Keys:** LFLNTY (line type) #### Sales Order Header File **Table:** F4201 **Area:** Sales Order Management **Prefix:** SH **Keys:** SHKCOO, SHDOCO, SHDCTO #### Purchase Order Header **Table:** F4301 **Area:** Procurement **Prefix:** PH **Keys:** PHKCOO, PHDOCO, PHDCTO #### Purchase Order Receiver File **Table:** F43121 **Area:** Procurement **Prefix:** PR **Keys:** PRMATC (match type), PRDOC, PRDCT #### Bill of Material Master **Table:** F3002 **Area:** Product Data Management **Prefix:** IX **Keys:** IXKITL (parent), IXCPNT (component), IXMMCU #### Routing Master **Table:** F3003 **Area:** Product Data Management **Prefix:** IR **Keys:** IRKIT (parent), IROPSQ (operation sequence), IRMMCU #### Work Order Master File **Table:** F4801 **Area:** Shop Floor **Prefix:** WA **Keys:** WADOCO (order number), WADCTO (type), WAMCU, WAITM #### Work Order Parts List **Table:** F3111 **Area:** Shop Floor **Prefix:** WM **Keys:** WMDOCO, WMCPIT (component item), WMCOBY (line) #### Work Order Routing **Table:** F3112 **Area:** Shop Floor **Prefix:** WL **Keys:** WLDOCO, WLOPSQ (operation sequence) #### Media Object Data (attachments) **Table:** F00165 **Area:** Technical **Prefix:** GD **Keys:** GDOBNM (object name), GDTXKY (text key) #### Data Dictionary Field Specifications **Table:** F9210 **Area:** Technical **Prefix:** FR **Keys:** FRDTAI (data item name) #### Object Librarian Master **Table:** F9860 **Area:** Technical **Prefix:** OM **Keys:** OMOBNM (object name) #### Versions List **Table:** F983051 **Area:** Technical **Prefix:** VR **Keys:** VRPID (UBE or application), VRVERS (version) #### Job Control Status Master **Table:** F986110 **Area:** Technical **Prefix:** JC **Keys:** JCJOBNBR (job number), JCFNDFUF1 (UBE name) **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the reference **Body:** 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 **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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. **Cta:** 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. **Faq:** #### What does the F in F0911 mean? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms jde table list, jd edwards f0911 table, jde f4801 work order table, jd edwards table prefix, jde f41021 item location, jde account ledger table, jd edwards table reference excel, jde sql table names --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json