wo_mstr


Field Name	Label	Col-Label	Format	Dec
oid_wo_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
wo__chr01			x(8)
wo__chr02			x(8)
wo__chr03			x(8)
wo__chr04			x(8)
wo__chr05			x(8)
wo__dec01			>>>,>>>,>>9.99	10
wo__dec02			>>>,>>>,>>9.99	10
wo__dec03			->>>,>>>,>>9.99	10
wo__dec04			->>>,>>>,>>9.99	10
wo__dte01			99/99/99
wo__dte02			99/99/99
wo__log01			yes/no
wo__qad01			x(8)
wo__qadc01	QAD Character Field 1		X(8)
wo__qadc02	QAD Character Field 2		X(8)
wo__qadc03	QAD Character Field 3		X(8)
wo__qade01	QAD Decimal Field 1		->,>>>,>>9.9<<<	10
wo__qade02	QAD Decimal Field 2		->,>>>,>>9.9<<<	10
wo__qade03	QAD Decimal Field 3		->,>>>,>>9.9<<<	10
wo__qadi01	QAD Integer Field 1		->,>>>,>>9
wo__qadi02	QAD Integer Field 2		->,>>>,>>9
wo__qadl01	QAD Logical Field 1		yes/no
wo__qadl02	QAD Logical Field 2		yes/no
wo__qadt01	QAD Date Field 1		99/99/99
wo__qadt02	QAD Date Field 2		99/99/99
wo_acct	Account		x(8)
wo_acct_close	Accounting Closed	Cls	yes/no
wo_app_owner	Owner Application		x(12)
wo_assay	Assay %		>>9.99%	10
wo_base_id	Base ID		x(8)
wo_batch	Batch		x(18)
wo_bdn_tot	Burden Cost		->>>,>>>,>>9.99<<<	10
wo_bdn_totx	Burden Cost		->>>,>>>,>>9.99<<<	10
wo_bdn_up	Update Current Burden Cost		yes/no
wo_bdn_var	Bdn Variance		->>>>,>>9.99	10
wo_bo_chg	Qty B/O		->,>>>,>>9.9<<<<<<<<	10
wo_bom_code	BOM/Formula		x(18)
wo_ca_int_type	Work Code		x(8)
wo_cc	Cost Center	CC	x(4)
wo_close_date	Accounting Close Date	Acctg Close	99/99/99
wo_close_eff	Effective	Eff Date	99/99/99
wo_cmtindx	Comment Index	Comment	>>>>>>>9
wo_date_posted			99/99/99
wo_doc_id	Document ID		x(24)
wo_domain	Domain		x(8)
wo_draw	Drawing		x(18)
wo_due_date	Due Date	Due	99/99/99
wo_due_date_anchor	Due Date Anchored		yes/no
wo_duration_buffer	Duration Buffer		>>>>>9
wo_eng_code	Engineer		X(8)
wo_expire	Expire Date	Expire	99/99/99
wo_flr_acct	Floor Stock Account	Flr Acct	x(8)
wo_flr_cc	Floor Stock CC	CC	x(4)
wo_flr_sub	Floor Stock Sub-Acct	Sub-Acct	x(8)
wo_fsm_type	SSM Type		x(8)
wo_gl_bdn	Create GL for Burden Variance		yes/no
wo_gl_lbr	Create GL for Labor Variance		yes/no
wo_grade	Grade	Grd	x(2)
wo_iss_site	Issue Site		x(8)
wo_itm_line	Item Line		>>>>>>>>9
wo_joint_type	Co/By Type	CT	x(1)
wo_lbr_tot	Labor Cost		->>>,>>9.99	10
wo_lbr_totx	Labor Cost		->>>,>>9.99	10
wo_lbr_up	Update Current Labor Cost		yes/no
wo_lbr_var	Lbr Variance		->>>>,>>9.99	10
wo_lead_time	W/O Lead Time	W/O Lead	->,>>>,>>9
wo_line	Production Line	Line	x(8)
wo_loc	Location		x(8)
wo_lot	ID		x(8)
wo_lot_next	Lot/Serial		x(18)
wo_lot_prev	Previous ID	Prev ID	x(8)
wo_lot_rcpt	Single Lot		yes/no
wo_mix_var	Mix Variance		->>>>,>>9.99	10
wo_mthd_var	Mthd Chg Var		->>>>,>>9.99	10
wo_mtl_tot	Material Cost		->>>,>>>,>>9.99<<<	10
wo_mtl_totx	Material Cost		->>>,>>>,>>9.99<<<	10
wo_mtl_var	Mtl Variance		->>>>,>>9.99	10
wo_mvar_acct	Material Usage Var	Mtl Use	x(8)
wo_mvar_cc	Material Usage Variance CC	CC	x(4)
wo_mvar_sub	Mtl Usage Var Sub	Sub-Acct	x(8)
wo_mvrr_acct	Material Rate Var	Mtl Rate	x(8)
wo_mvrr_cc	Material Rate Variance CC	CC	x(4)
wo_mvrr_sub	Mtl Rate Var Sub	Sub-Acct	x(8)
wo_myld_var	Mix & Yield Var	M&Y Var	->>>>,>>9.99	10
wo_nbr	Work Order		x(18)
wo_nbr_lines	Number of Production Lines		>>9.9<	2
wo_ord_date	Order Date		99/99/99
wo_order_sheet_printed	Route Printed		yes/no
wo_ovh_tot	Ovhead Cost		->>>,>>9.999	10
wo_ovh_totx	Ovhead Cost		->>>,>>9.999	10
wo_part	Item Number		x(18)
wo_per_date	Performance Date	Perform	99/99/99
wo_prod_pct	Process		>>9.99%	10
wo_project	Project		x(8)
wo_qty_booked	Qty Ser Booked		>,>>>,>>9
wo_qty_chg	Receipt Qty		->,>>>,>>9.9<<<<<<<<	10
wo_qty_comp	Qty Completed		->,>>>,>>9.9<<<<<<<<	10
wo_qty_ord	Qty Ordered		->,>>>,>>9.9<<<<<<<<	10
wo_qty_rjct	Qty Reject		->,>>>,>>9.9<<<<<<<<	10
wo_qty_type	Qty Type	QT	x(1)
wo_queue_eff	Queue Pct		>>9.9<	10
wo_rate	Production Rate	Prod Rate	>>>,>>>,>>9.99	10
wo_rctstat	Receipt Status	Status	x(8)
wo_rctstat_active	Active	Act	yes/no
wo_record_date	Last Record Date		99/99/99
wo_ref	Reference		x(8)
wo_rel_date	Release Date	Release	99/99/99
wo_rev	Rev		x(4)
wo_rjct_chg	Reject Qty		->,>>>,>>9.9<<<<<<<<	10
wo_rjct_tot	Rejected Cost		->>>,>>>,>>9.99<<<	10
wo_rmks	Remarks		x(40)
wo_routing	Routing Code		x(18)
wo_run_size	Run Crew Size		>>>9
wo_rval_tot	Revalued Total		->>>,>>>,>>9.99<<<	10
wo_schd_type	Schedule Code		x(1)
wo_selected_for_print	Selected For Print		yes/no
wo_seq	Sequence		>>>>9.9<	2
wo_serial	Lot/Serial		x(18)
wo_setup_time	Setup Time		999999
wo_shift	Shift		x(2)
wo_site	Site		x(8)
wo_so_job	Sales/Job	SO/Job	x(8)
wo_stat_close_date	WO Close Date	WO Close	99/99/99
wo_stat_close_userid	WO Close UserID		x(8)
wo_status	Status	St	x(1)
wo_sub	Sub-Account	Sub-Acct	x(8)
wo_sub_tot	Subcontract Cost		->>>,>>>,>>9.99<<<	10
wo_sub_totx	Subcontract Cost		->>>,>>>,>>9.99<<<	10
wo_sub_var	Sub Variance		->>>>,>>9.99	10
wo_svar_acct	Subcontract Usage Var	Sub Use	x(8)
wo_svar_cc	Subcontract Usage Variance CC	CC	x(4)
wo_svar_sub	Sub Usage Var Sub	Sub-Acct	x(8)
wo_svrr_acct	Subcontract Rate Var	Sub Rate	x(8)
wo_svrr_cc	Subcontract Rate Variance CC	CC	x(4)
wo_svrr_sub	Sub Rate Var Sub	Sub-Acct	x(8)
wo_tool	Tool Code	Tool	x(8)
wo_type	Type	T	x(1)
wo_unit_cost	Unit Cost		->>>,>>>,>>9.99<<<	10
wo_user1	Ufld1		x(8)
wo_user2	Ufld2		x(8)
wo_var	Post variances at SFC		yes/no
wo_vend	Supplier		x(8)
wo_wip_tot	Wip Cost		->>>,>>>,>>9.99<<<	10
wo_xvar_acct	Mix Variance	Mix	x(8)
wo_xvar_cc	Mix Variance CC	CC	x(4)
wo_xvar_sub	Mix Variance Sub-Acct	Sub-Acct	x(8)
wo_yield_pct	Yield		>>9.99%	10

	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_wo_mstr	yes	oid_wo_mstr	yes	no
	wo_due_part	no	wo_domain	yes	no
			wo_due_date	yes	no
			wo_part	yes	no
			wo_site	yes	no
	wo_fsm_type	no	wo_domain	yes	no
			wo_fsm_type	yes	no
			wo_nbr	yes	no
			wo_itm_line	yes	no
	wo_line_due	no	wo_domain	yes	no
			wo_site	yes	no
			wo_line	yes	no
			wo_due_date	yes	no
			wo_part	yes	no
	wo_lot	yes	wo_domain	yes	no
			wo_lot	yes	no
∗	wo_nbr	yes	wo_domain	yes	no
			wo_nbr	yes	no
			wo_lot	yes	no
	wo_part	no	wo_domain	yes	no
			wo_part	yes	no
			wo_site	yes	no
			wo_due_date	yes	no
	wo_part_rel	no	wo_domain	yes	no
			wo_part	yes	no
			wo_site	yes	no
			wo_rel_date	yes	no
	wo_rel_date	no	wo_domain	yes	no
			wo_site	yes	no
			wo_line	yes	no
			wo_rel_date	yes	no
	wo_site	no	wo_domain	yes	no
			wo_site	yes	no
			wo_nbr	yes	no
			wo_part	yes	no
	wo_type_nbr	yes	wo_domain	yes	no
			wo_type	yes	no
			wo_nbr	yes	no
			wo_lot	yes	no
	wo_type_part	no	wo_domain	yes	no
			wo_type	yes	no
			wo_part	yes	no
			wo_site	yes	no
			wo_due_date	yes	no