Table Name:
|
upd_ls_hist_base
|
|
|
|
|
|
|
|
|
|
|
Table Type:
|
Internal
|
|
|
|
|
|
|
|
|
|
|
Description:
|
Internal table used to control update of labor records at DCM
|
|
|
|
|
|
|
|
|
|
|
Updated By:
|
Shop floor daemon and Monitor
|
|
|
|
|
|
|
|
|
|
|
Primary Keys:
|
upd_seq, child_idx
|
|
|
|
|
|
|
|
|
|
|
Fields:
|
job, product, tool, family_count, labor_costupd_seq, child_idx, mach_seq, family_seq, employee_id, cat_idx, start_time, start_ev, end_time, end_ev, host_lock, gross_pieces, net_pieces, idle_time, up_time, total_down_time, total_assist_time, total_reject, logged_time, ss_mseq, jts_mseq, job_seq, employee_name, labcat, mach_name, shift_id,
|
|
|
|
|
|
|
|
|
|
|