Exporting Level Mix Workbench Data


Field Name	Format	Description
RECORD TYPE “H”
record_type	character	H
zero_constant	integer	0
site	character	Site of the process
process_id	character	Process
production_line	character	Production line for process. Any flow orders imported or exported must reference this production line.
hist_work_days	integer	Number of historical days to use to determine average demand
fut_work_days	integer	Number of future days used to calculate average demand
time_fence	integer	Number of days (from today) considered frozen. Flow orders in frozen dates can be changed, but will not be replanned by the workbench recalculation logic.
pitch_quantity	decimal	Pitch size for the process
pitch_um	character	Pitch unit of measure
tolerance_pct	decimal	Difference between total modified orders and total planned orders that will generate a warning message
epei_disp	integer	Indicates how EPEI displays (weeks, days, hours, minutes, etc.)
cycle_time_sec	integer	Cycle time in seconds for the process
time_adj1	character	Shift adjustment reference code
time_adj2	character	Shift adjustment reference code
time_adj3	character	Shift adjustment reference code
time_adj4	character	Shift adjustment reference code
time_adj5	character	Shift adjustment reference code
days_per_period	integer	For future use. Currently always set to 1.
takt_time_revised	decimal	New takt time as a result of order modifications (to be posted to process record)
RECORD TYPE “P”
record_type	character	P
zero_constant	integer	0
part	character	Item number
epei_disp_amt	decimal	EPEI converted to the desired display format
hist_demand	decimal	Total historical demand
fut_demand	decimal	Total future demand
kanban_quantity	decimal	Kanban quantity
cycle_time_sec	integer	Cycle time for item in seconds
epei_sec	integer	EPEI for item in seconds
seq_nbr	integer	Used to determine the order in which items are to be considered when being planned
seq_work	integer	Work field used to determine sequence number
mfg_seq	integer	User-defined manufacturing sequence number for this item
req_operators	decimal	User-defined required number of operators
knb_keyid	decimal	Kanban Loop ID: Internal keyid of knb_mstr record exported from the system
max_buffer	decimal	Maximum buffer size for loop
buf_adj_revised	decimal	User-entered change to maximum buffer size (can be positive or negative number)
RECORD TYPE “D”
record_type	character	D
shift	integer	Shift
date	date	Date
day_of_week	character	Monday, Tuesday, etc.
days_in_period	integer	Number of days in period
total_hours	decimal	Total work hours available in shift
time_adj_amt1	decimal	Time adjustments for adj category 1
time_adj_amt2	decimal	Time adjustments for adj category 2
time_adj_amt3	decimal	Time adjustments for adj category 3
time_adj_amt4	decimal	Time adjustments for adj category 4
time_adj_amt5	decimal	Time adjustments for adj category 5
time_adj_amt_other	decimal	Time adjustments for all other adj categories
avail_hours	decimal	Total hours in shift less all adjustments
frozen	Yes/No	Indicates if this is a date within the time fence horizon
time_adj_amt1_revised	decimal	User-entered amount for adjustment category 1
time_adj_amt2_revised	decimal	User-entered amount for adjustment category 2
time_adj_amt3_revised	decimal	User-entered amount for adjustment category 3
time_adj_amt4_revised	decimal	User-entered amount for adjustment category 4
time_adj_amt5_revised	decimal	User-entered amount for adjustment category 5
RECORD TYPE “Q”
record_type	character	Q
shift	integer	Shift (1 through 4)
date	date	Flow order date
part	character	Flow order item
ord_qty	decimal	Flow original order quantity
comp_qty	decimal	Flow quantity completed so far
wb_qty	decimal	Calculated value of ord_qty – comp_qty
frozen	Yes/No	Indicates if flow order is within the time fence horizon
seq_nbr	integer	Flow order sequence number
order_qty_revised	decimal	Revised quantity entered by user. If zero found and flow order exists, it will be deleted.