Database table: MATL

Materials represent inventories of items that are not actively processing. Materials generally represent subcomponents that continue processing under a different item and/or order number. Some example uses of materials are:

  • Pieces of bar stock cut to size for downstream processing
  • Electronic circuitry added to blanked and punched ceramic boards
  • Co-products
  • By-products

Materials are defined for each classification of consumable inventory. A material may represent a broad classification of items, such as a subassembly required by numerous orders. Materials can also represent specific classifications required only by a particular order.

The characteristics of materials remain constant throughout the Scheduler run except for the current quantity in inventory. When processing loads on the material interaction operations, the Scheduler increments or decrements the material’s current quantity. Before starting the run, specify the initial quantity in the MATL.QUONHAND field.

Note: The Planner uses the MATL table for both end items and material subcomponents.