Material Lot Totals
Material Lot Totals are summary information for a Material Lot.Material Lot totals are stored in tables beginning with mls_
Material Lot totals can be for the currently running Material Lot record (mls_cur_ ) or completed Material Lots (mls_hist_ ).
When a job changes, a set of mls_hist_ records are created for the portion of the Material Lot that is associated with the completed job. If the new job uses the same material lot, a new set of mls_cur records are begun for the new job.
When a shift changes a new mls_hist record is written as well.
Material Lot Total for the current Material Lot are stored in
mls_cur_base base summary information
mls_cur_mat material component information
Material Lot Total information for completed Material Lots are stored in
mls_hist_base base summary and parameter information
mls_hist_mat material component parameters
An additional table of interest for Material Lot histories is mat_lot_hist. Since a material lot can be shared between machines, the mat_lot_id contains start and end times of the material lot across the shop floor.
A graphic relationship of material lot tables is available.