Tables Used in the Inventory Management System

A Tables Used in the Inventory Management System

This appendix contains the following topics:

A.1 Inventory Management Tables

This section lists the tables used in the JD Edwards EnterpriseOne Inventory Management system.

A.1.1 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.