F4100 |
Stores basic information about each warehouse location, such as zones and level of detail. |
F4101 |
Stores basic information about each item, including:
|
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. |