# JD Edwards World Key File (Table) Reference > Source: https://netray.co/tools/jde-world-key-file-reference-table > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A searchable lookup of widely used JD Edwards World files with the module, purpose and key field prefix, useful for queries, reports and migration mapping. ## Category oracle ## Erp Oracle JD Edwards World ## Audience - JDE World developer - Data migration analyst - Report writer - Business analyst ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### File **Key:** file **Type:** text #### Description **Key:** name **Type:** text #### Module **Key:** module **Type:** text #### Field prefix **Key:** prefix **Type:** text #### Typical use **Key:** use **Type:** text **Rows:** #### Address Book Master **File:** F0101 **Module:** Address Book **Prefix:** AB **Use:** One record per customer, supplier, employee or other address number #### Who's Who **File:** F0111 **Module:** Address Book **Prefix:** WW **Use:** Contact names linked to an address number #### Phone Numbers **File:** F0115 **Module:** Address Book **Prefix:** WP **Use:** Phone numbers for an address number and contact #### Address by Date **File:** F0116 **Module:** Address Book **Prefix:** AL **Use:** Mailing address lines, city, state, postal code, country #### User Defined Code Types **File:** F0004 **Module:** Foundation **Prefix:** DT **Use:** Defines each UDC list, such as product and system code #### User Defined Codes **File:** F0005 **Module:** Foundation **Prefix:** DR **Use:** Values and descriptions in each UDC list #### Business Unit Master **File:** F0006 **Module:** General Accounting **Prefix:** MC **Use:** Business units, branch plants, jobs and cost centers #### Company Constants **File:** F0010 **Module:** General Accounting **Prefix:** CC **Use:** Company level settings including fiscal date pattern #### Automatic Accounting Instructions **File:** F0012 **Module:** General Accounting **Prefix:** AI **Use:** Rules that derive accounts for system generated entries #### Account Master **File:** F0901 **Module:** General Accounting **Prefix:** GM **Use:** Chart of accounts, one record per business unit and object account #### Account Balances **File:** F0902 **Module:** General Accounting **Prefix:** GB **Use:** Period balances by account and fiscal year #### Account Ledger **File:** F0911 **Module:** General Accounting **Prefix:** GL **Use:** Posted and unposted ledger transactions, the detailed general ledger #### Supplier Master **File:** F0401 **Module:** Accounts Payable **Prefix:** A6 **Use:** Supplier specific data such as payment terms and payee #### Accounts Payable Ledger **File:** F0411 **Module:** Accounts Payable **Prefix:** RP **Use:** Vouchers and open payables #### A/P Matching Document **File:** F0413 **Module:** Accounts Payable **Prefix:** RM **Use:** Payment header, one record per payment #### A/P Matching Document Detail **File:** F0414 **Module:** Accounts Payable **Prefix:** RN **Use:** Vouchers paid by each payment #### Customer Master by Line of Business **File:** F03012 **Module:** Accounts Receivable **Prefix:** AI **Use:** Customer credit, terms and billing data #### Customer Ledger **File:** F03B11 **Module:** Accounts Receivable **Prefix:** RP **Use:** Invoices and open receivables #### Item Master **File:** F4101 **Module:** Inventory **Prefix:** IM **Use:** Item number, description, stocking type and unit of measure #### Item Branch **File:** F4102 **Module:** Inventory **Prefix:** IB **Use:** Item data by branch plant such as planning and costing method #### Item Location **File:** F41021 **Module:** Inventory **Prefix:** LI **Use:** On hand quantities by item, location and lot #### Item Cross Reference **File:** F4104 **Module:** Inventory **Prefix:** IV **Use:** Customer or supplier item numbers and cross references #### Item Cost **File:** F4105 **Module:** Inventory **Prefix:** CO **Use:** Cost records by item, branch plant and cost method #### Item Ledger (Cardex) **File:** F4111 **Module:** Inventory **Prefix:** IL **Use:** Inventory transaction history #### Sales Order Header **File:** F4201 **Module:** Sales Order Management **Prefix:** SH **Use:** One record per sales order #### Sales Order Detail **File:** F4211 **Module:** Sales Order Management **Prefix:** SD **Use:** Sales order lines with quantities, dates and status codes #### Purchase Order Header **File:** F4301 **Module:** Procurement **Prefix:** PH **Use:** One record per purchase order #### Purchase Order Detail **File:** F4311 **Module:** Procurement **Prefix:** PD **Use:** Purchase order lines with quantities, prices and status #### Purchase Order Receiver **File:** F43121 **Module:** Procurement **Prefix:** PR **Use:** Receipts and matching records for purchase orders #### Bill of Material Master **File:** F3002 **Module:** Shop Floor Management **Prefix:** IX **Use:** Parent to component relationships #### Routing Master **File:** F3003 **Module:** Shop Floor Management **Prefix:** IR **Use:** Routing operations by item and branch plant #### Work Order Master **File:** F4801 **Module:** Shop Floor Management **Prefix:** WA **Use:** Work order header with status, dates and quantity #### Work Order Parts List **File:** F3111 **Module:** Shop Floor Management **Prefix:** WM **Use:** Component requirements for each work order #### Work Order Routing **File:** F3112 **Module:** Shop Floor Management **Prefix:** WL **Use:** Operations on each work order **Notes:** Field prefixes and file layouts can differ by release and local modification. Confirm column names on your own system, for example with the data dictionary or by listing columns from QSYS2.SYSCOLUMNS. This list is general guidance and not a complete data model. ## Content **Intro:** When you write a query, a report or a migration mapping in JD Edwards World, the first question is which file holds the data. This reference lists commonly used World files with module, purpose and field prefix, so you can find the starting point quickly. **Sections:** #### How to use the reference **Body:** Search by file number, name or module. For example, type ledger to find the general ledger and payables ledgers, or type item to see the inventory files. Use the prefix column to recognize field names: in F0911 the amount is GLAA, and the account is GLAID. Combine this with the SQL generator to list columns and count rows. Export the filtered list to Excel or CSV to include in a mapping workbook or a data dictionary document. #### How World files fit together **Body:** World follows a consistent pattern. Master files such as F0101 for addresses and F4101 for items hold the entity. Branch or company level files, such as F4102 and F03012, add context by location or role. Transaction files, such as F4211 and F0911, hold the activity. Ledger and balance files, such as F0911 and F0902, give a detailed and summarized view of the same accounting. User defined codes in F0005 supply descriptions for coded fields across the system. **Bullets:** - Address number links F0101 to customers and suppliers - Item and branch plant link F4101, F4102 and F41021 - Order number and type link headers to detail - F0005 explains codes used throughout #### Cautions for reporting and migration **Body:** Do not assume that every file is populated, as some are only used when a feature is turned on. Dates are often stored in CYYDDD Julian format and amounts without a decimal point. Status codes such as order next and last status are user-defined and differ between companies. When mapping for migration, confirm with sample data and reconcile totals, such as ledger balances against F0902, rather than relying on file descriptions alone. Local modifications may add fields or files that never appear in a standard list. **Cta:** If you are mapping World data into another system, Netray can discuss an approach that reads from the files and reconciles to the ledger. The reference is free to use. **Faq:** #### What is the F0911 file in JD Edwards World? **Answer:** F0911 is the Account Ledger, the detailed general ledger. It holds one record per ledger transaction, with account, amount, date, document number and posting status. F0902 holds period balances summarized from it. #### Are World and EnterpriseOne table names the same? **Answer:** Many core file names, such as F0101, F0911 and F4101, are shared in concept and name, but column definitions and details differ. Do not assume a direct match, and verify layouts in each system. #### How do I see the columns of a World file? **Answer:** Use the data dictionary in World, or query QSYS2.SYSCOLUMNS in DB2 for i with the library and file name. Column names start with the file prefix, such as GL for F0911. #### Is this list complete? **Answer:** No. It covers frequently used files across the main modules. World has many more files, and your system may contain custom ones. Treat it as a starting point for exploration. ## Search terms jde world table list, jd edwards f0911 account ledger, f0101 address book master, jde f4101 item master, jd edwards world file reference, jde world data dictionary tables, jd edwards f4211 sales order detail, jde world file names --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json