Inventory Management Tables

The JD Edwards EnterpriseOne Inventory Management system uses these tables:

Table	Description
F4100	Stores basic information about each warehouse location, such as zones and level of detail.
F4101	Stores basic information about each item, including: Item number Description Search keys Category codes Default units of measure Process groups for the JD Edwards EnterpriseOne Warehouse Management system Item dimension group
F4102	Stores default item information, including each item's process and dimension groups, and other parameters that are common to every unit of that item in the warehouse.
F4104	Stores item descriptions that the Item Search program (P41200) uses.
F4105	Stores inventory cost records.
F4106	Stores inventory price records.
F4108	Stores information used in lot processing
F4111	Stores a history of all inventory movements.
F4115	Stores item master history.
F4140 and F4141	Stores information about physical inventories using the cycle count method.
F4160	Stores information about physical inventories using the tag count method.
F4170	Stores information about activity rules for lot statuses.
F41001	Stores information for day-to-day transactions, including: Location number definition Warehouse control data Default units of measure Inclusion rule, which determines the document types and status codes to process through the system
F41002	Stores the unit of measure conversion equations that are unique to the warehouse item and its default unit of measure structure information.
F41003	Stores the unit of measure conversion equations that are common to all warehouse items.
F41006	Stores information required to print the Inventory Turn Report (R41116).
F41013	Stores information about product numbers.
F41021	Stores each item's quantity information, general ledger class, and lot status in each location.
F41023	Stores definitions for item locations.
F41081	Stores information about lot statuses.
F41112	Stores information summarized from the Item Ledger File table (F4111), which the Item Ledger - Running Balance program (P41112) creates and updates.
F41113	Stores information about lot ledgers.
F41829	Stores information that the Item Word Build program extracted from the F4101, F4102, F4100, F4108, F4101D, and F4104 tables.

The JD Edwards EnterpriseOne Inventory Management system also uses these tables from other systems:

Table	Description
F4009	Stores information that specifies whether the item unit of measure conversions are unique for each item or applicable to each item in the warehouse.
F4016 and F4017	Stores predefined messages that print on documents such as sales orders and purchase orders.
F4095	Stores the AAIs used by JD Edwards EnterpriseOne Logistics and Manufacturing systems.
F00090, F00090D, and F00091	Stores information used by the Supplemental Data Setup program (P00091).
F00092	Stores information used by the Supplemental Data by Item or by Item/Branch program (P00092).
F34004	Stores the order types (sales, procurement, and so on) and the order statuses at which the system will create a request.
F40039	Stores information about document types for the JD Edwards EnterpriseOne Inventory Management system, the JD Edwards EnterpriseOne Sales Order Management system, the JD Edwards EnterpriseOne Procurement system, and the JD Edwards EnterpriseOne Customer Service Management system.
F40095	Stores the default warehouse code (branch/plant) and the default printer output queue for transactions that you process through the subsystem.