OracleFree referencePDF, Excel, Word exportOracle JD Edwards World

JD Edwards World Key File (Table) Reference

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.

Download:

File	Description	Module	Field prefix	Typical use
F0101	Address Book Master	Address Book	AB	One record per customer, supplier, employee or other address number
F0111	Who's Who	Address Book	WW	Contact names linked to an address number
F0115	Phone Numbers	Address Book	WP	Phone numbers for an address number and contact
F0116	Address by Date	Address Book	AL	Mailing address lines, city, state, postal code, country
F0004	User Defined Code Types	Foundation	DT	Defines each UDC list, such as product and system code
F0005	User Defined Codes	Foundation	DR	Values and descriptions in each UDC list
F0006	Business Unit Master	General Accounting	MC	Business units, branch plants, jobs and cost centers
F0010	Company Constants	General Accounting	CC	Company level settings including fiscal date pattern
F0012	Automatic Accounting Instructions	General Accounting	AI	Rules that derive accounts for system generated entries
F0901	Account Master	General Accounting	GM	Chart of accounts, one record per business unit and object account
F0902	Account Balances	General Accounting	GB	Period balances by account and fiscal year
F0911	Account Ledger	General Accounting	GL	Posted and unposted ledger transactions, the detailed general ledger
F0401	Supplier Master	Accounts Payable	A6	Supplier specific data such as payment terms and payee
F0411	Accounts Payable Ledger	Accounts Payable	RP	Vouchers and open payables
F0413	A/P Matching Document	Accounts Payable	RM	Payment header, one record per payment
F0414	A/P Matching Document Detail	Accounts Payable	RN	Vouchers paid by each payment
F03012	Customer Master by Line of Business	Accounts Receivable	AI	Customer credit, terms and billing data
F03B11	Customer Ledger	Accounts Receivable	RP	Invoices and open receivables
F4101	Item Master	Inventory	IM	Item number, description, stocking type and unit of measure
F4102	Item Branch	Inventory	IB	Item data by branch plant such as planning and costing method
F41021	Item Location	Inventory	LI	On hand quantities by item, location and lot
F4104	Item Cross Reference	Inventory	IV	Customer or supplier item numbers and cross references
F4105	Item Cost	Inventory	CO	Cost records by item, branch plant and cost method
F4111	Item Ledger (Cardex)	Inventory	IL	Inventory transaction history
F4201	Sales Order Header	Sales Order Management	SH	One record per sales order
F4211	Sales Order Detail	Sales Order Management	SD	Sales order lines with quantities, dates and status codes
F4301	Purchase Order Header	Procurement	PH	One record per purchase order
F4311	Purchase Order Detail	Procurement	PD	Purchase order lines with quantities, prices and status
F43121	Purchase Order Receiver	Procurement	PR	Receipts and matching records for purchase orders
F3002	Bill of Material Master	Shop Floor Management	IX	Parent to component relationships
F3003	Routing Master	Shop Floor Management	IR	Routing operations by item and branch plant
F4801	Work Order Master	Shop Floor Management	WA	Work order header with status, dates and quantity
F3111	Work Order Parts List	Shop Floor Management	WM	Component requirements for each work order
F3112	Work Order Routing	Shop Floor Management	WL	Operations on each work order

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.

Optional help mapping World data

If you are building a field-level mapping from World files, we can discuss ways to speed it up and reconcile the result.

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

How to use the reference

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

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.

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

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.

Frequently Asked Questions

What is the F0911 file in JD Edwards World?

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?

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?

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?

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.

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.

Talk to an Expert Explore More Free Tools