Tote Totals
Tote totals are summary records for each Tote.Tote totals can be for the current tote (ts_cur_base) or completed totes (ts_hist_base).
A job change automatically starts a new tote record.
If a Tote is in use during a shift or material lot change, the Tote totals are broken into pieces for each of these changes. For example Tote A begins. When a new shift starts an ts_hist_base record is written to cover the time from login to job change. When a material lot changes, a new record is written from the shift change to the material lot change. When the Tote ends a third record is written from the material lot change to the Tote change.
For a complete history of a Tote the Tote id can be used to get all records using that Tote.
Tote Total for the current tote are stored in ts_cur_base base summary information.
Tote Total information for completed totes are stored in ts_hist_base base summary and parameter information.