Table Name:
|
mls_hist_base
|
|
Full Name:
|
Material Summary History
|
|
Table Type:
|
Production and Job Parameter
|
|
Description:
|
General information about completed material lots
|
|
Record Frequency:
|
1 per production run per child
|
|
Updated By:
|
Shop floor daemon
|
|
Primary Keys:
|
mach_seq, mls_mseq, child_idx
|
|
Fields:
|
mach_seq, mls_mseq, child_idx, mach_name, family_seq, start_time, start_ev, end_time, end_ev, host_lock, total_cycles, up_cycles, slow_cycles, fast_cycles, gross_pieces, net_pieces, net_box_count, idle_time, up_time, total_down_time, total_assist_time, total_reject, total_down_count, total_assist_count, job_seq, comments, job, product, prod_seq, tool, family_count, mat_formula, user_text_1, user_text_2, user_text_3, user_text_4, pieces_required, std_rate_factor, weight, tote_box_size, tote_reject, std_mult, act_mult, std_cycle, cycle_tol, cycle_window, down_thresh, reject_thresh, reject_mult, std_setup_time, net_mult, required_by, refeed_runner, refeed_scrap, std_shot_weight, act_shot_weight, sched_now, sched_factory, spc_n, spc_interval, ss_mseq
|
|