| MPS/MRP/DRP Message File (F3411) |
Contains the action messages that are generated by MPS, MRP, or DRP.
Stores the production number and production number short.
|
| MPS/MRP/DRP Lower Level Requirements File (F3412) |
Contains the source of gross requirements that are posted to items from parent items.
Stores the production number short.
|
| MPS/MRP/DRP Summary File (F3413) |
Contains the time series data for forms and reports. |
| Vendor Schedule Quantity File (F3430) |
Stores blanket order-based schedules.
Stores the production number and production number short.
|
| Vendor Schedule Commitment File (F3435) |
Stores commitment information for blanket order-based schedules.
Stores the production number and production number short.
|
| Production Number Master File (F34401) |
Stores production number information including company, production number short, item number, branch/plant (Release 9.1 Update), type, status, dates, and segment values. |
| Production Number Master Tag File (F34401T) (Release 9.1 Update) |
Stores production number information including company, production number, production number short, branch/plant, order number from sales order detail line, production number long (Future Use field), and audit fields. (Release 9.1 Update) |
| Production Number Structure File (F34402) |
Stores the production number structure definition including production type, separator option, separator value, segments, and segment sequence. |
| Adhoc Vendor Schedule File (F3450) |
Stores supplier release schedules without supplier and blanket order information.
Stores the production number and production number short.
|
| Forecast File (F3460) |
Stores the forecast data that Resource Requirements Planning (RRP) validates. The data is then used as input to MPS/MRP/DRP.
Stores production number and production number short.
|
| Item Transactions Detail File (F41UI001) |
Stores the production number, production number short, and production number controlled setting. Stores a process flag to determine if inventory consumption form is required to consume on-hand quantity. |
| Item Master (F4101) |
Stores basic information about each item in inventory, such as item numbers, description, category codes, and units of measure.
Stores production number controlled setting.
|
| F4101 Item Master Unedited Transaction Table (F4101Z1) |
Stores production number controlled setting. |
| Item File (F4101A) |
Stores item information in a work file.
Stores production number controlled setting.
|
| Item Branch (F4102) |
Stores the branch/plant information for an item, such as quantities, category codes, and cost information.
Stores production number controlled setting.
|
| Item Location File (F41021) |
Stores primary and secondary locations for an item.
Stores the cumulative on-hand quantity of generic and production controlled inventory.
|
| Item Location Tag File (F41021T) |
Stores on-hand quantity information by production number. |
| Item Ledger File (F4111) |
Stores transaction history for all items.
Stores the production number and production number short.
|
| Cycle Count Transaction Tag File (F4141T) |
Stores on-hand quantities by production number for items in the cycle count process. |
| SO Detail Cache File (MBF) (F42UI11) |
Stores the production number and production number short. |
| Sales Order Detail (F4211) |
Stores detail information for each sales order line (item number, quantity ordered, price, and so forth).
Stores the production number and production number short.
|
| Sales Order History (F42119) |
Contains past sales data, which provides the basis for the forecast calculations.
Stores the production number and production number short.
|
| S.O. Detail Ledger File (F42199) |
Stores order history information.
Stores the production number and production number short.
|
| Purchase Order Detail File (F4311) |
Stores the detail information for the purchase order. This includes the category codes 01 through 04 fields. The Job Typ field for Project and Government Contract Accounting is stored in this table.
The column GBCFG (Generated by Configurator) has a flag that indicates that the purchase order has a related configured order.
Stores the production number and production number short.
|
| Purchase Order Generator File (F4311Z) |
Stores purchase order information.
Stores the production number and production number short.
|
| Purchase Order Detail Unedited Transaction Table (F4311Z1) |
Stores purchase order detail information for Procurement outbound interoperability. This includes user-defined fields. The records for the Purchase Order Clauses table (F4320) are not written to any Z file.
Stores the production number and production number short.
|
| Purchase Order Receiver File (F43121) |
Stores receipt record and voucher record information with details such as open quantity and open amount. The Job Typ field for Project and Government Contracting is stored in this table.
Stores the production number and production number short.
|
| Receiver workfile (F43121Z) |
Stores receipt record and voucher record information in a temporary work file.
Stores the production number and production number short.
|
| Receipts Unedited Transaction Table (F43121Z1) |
Stores purchase order receipt information for Procurement outbound interoperability.
Stores the production number and production number short.
|
| P.O. Detail Ledger File - Flexible Version (F43199) |
Stores detail information for each purchase order line, such as item number, price, quantity ordered, and purchase amount (PA) ledger type.
Stores the production number and production number short.
|
| EDI Purchase Order Detail - Inbound (F47012) |
Stores the production number and production number short. |
| EDI Product Activity Data Detail - Inbound (F47122) |
Stores information for the product activity data inbound transactions.
Stores production number and production number short for inventory issues, adjustments, and transfers.
|
| EDI Purchase Order Change Detail - Inbound (F47132) |
Stores the production number and production number short. |
| Work Order Master Tag (F4801T) |
Stores additional information about a work order.
Stores the production number and production number short.
|
| Outbound Work Order Header (F4801Z1) |
Stores work order information.
Stores the production number and production number short.
|