isb_mstr


Field Name	Label	Col-Label	Format	Dec
isb__chr01			x(8)
isb__chr02			x(8)
isb__chr03			x(8)
isb__chr04			x(8)
isb__chr05			x(8)
isb__chr06			x(8)
isb__chr07			x(8)
isb__chr08			x(8)
isb__chr09			x(8)
isb__chr10			x(8)
isb__dec01			->>>,>>>,>>9.99	10
isb__dec02			->>>,>>>,>>9.99	10
isb__dec03			->>>,>>>,>>9.99	10
isb__dte01			99/99/99
isb__dte02			99/99/99
isb__dte03			99/99/99
isb__dte04			99/99/99
isb__log01			yes/no
isb__log02			yes/no
isb__log03			yes/no
isb__log04			yes/no
isb__log05			yes/no
isb__qadc01	QAD Character Field 1		X(8)
isb__qadc02	QAD Character Field 2		X(8)
isb__qadc03	QAD Character Field 3		X(8)
isb__qadc04	QAD Character Field 4		x(8)	0
isb__qade01	QAD Decimal Field 1		->>>,>>>,>>9.99	10
isb__qade02	QAD Decimal Field 2		->>>,>>>,>>9.99	10
isb__qade03	QAD Decimal Field 3		->>>,>>>,>>9.99	10
isb__qadi01	QAD Integer Field 1		->,>>>,>>9
isb__qadi02	QAD Integer Field 2		->,>>>,>>9
isb__qadi03	QAD Field		>>>>>9
isb__qadi04	QAD Integer Field 4		>>>>9
isb__qadl01	QAD Logical Field 1		yes/no
isb__qadl02	QAD Logical Field 2		yes/no
isb__qadl03	QAD Logical Field 3		yes/no
isb__qadt01	QAD Date Field 1		99/99/99
isb__qadt02	QAD Date Field 2		99/99/99
isb__qadt03	QAD Date Field 3		99/99/99
isb_article	Article Number		x(18)
isb_calib_date	Calibration Date		99/99/99
isb_calibration	Calibration		->,>>>,>>9.9<<<<<<<<	10
isb_classification	Classification		x(12)
isb_cmtindx	Comment Index	Comment	>>>>>>>9
isb_comp	Component	Comp	yes/no
isb_customer_id	Customer Id		x(18)
isb_desc1	Description		x(24)
isb_desc2	Description		x(24)
isb_domain	Domain		x(8)
isb_eco	ECO		x(8)
isb_eng_code	Engineer		x(8)
isb_eu_nbr	End User		x(8)
isb_eud_trnbr	End User ID		>>>>>>>>>9
isb_ic_ref	Inventory Ref		x(18)
isb_ins_date	Install Date	Install	99/99/99
isb_inv_nbr	Invoice		x(22)
isb_last_pm	Last PM date	Last PM	99/99/99
isb_lb_warr_exp	Labor Warranty Exp	Lbr Exp	99/99/99
isb_location	Location		x(24)
isb_lst_upd	Last Updated		99/99/99
isb_meter_date	Meter Reading Date		99/99/99
isb_meter_interval	Meter Reading Interval	Interval	>>>>,>>>,>>9.99<<<	10
isb_meter_rdg	Latest Meter Reading	Meter	>>>>,>>>,>>9.99<<<	10
isb_meter_um	Meter Reading Units		X(2)
isb_mod_date	Modified Date	Mod Date	99/99/99
isb_mod_userid	User ID		X(8)
isb_model	Model		x(18)
isb_next_pm	Next PM Date	Next PM	99/99/99
isb_orig_ins	Original Install		99/99/99
isb_origin	Country of Origin		x(12)
isb_owner	Ownership		x(8)
isb_parent	Parent		yes/no
isb_part	Item Number	Item	x(18)
isb_plant_maint	Internal Plant Maint		yes/no
isb_pm_days	PM days		>>>>>9
isb_pm_um	UM		x(2)
isb_price_sold	Price Sold		>>>>,>>>,>>9.99<<<	10
isb_qty	Qty		>,>>>,>>>,>>9.9<<	10
isb_rebuild	Rebuild ISB		yes/no
isb_ref	Ref		>>>>>>>9
isb_rev	Rev Level	Rev	x(10)
isb_seq	Seq		>>>>>>>9
isb_serial	Serial		x(18)
isb_ship_date	Ship Date		99/99/99
isb_so_line	Sales Order Line	SO Line	>>>>9
isb_so_nbr	Sales Order	Order	x(8)
isb_sold_to	Sold to		x(8)
isb_status	Status		x(8)
isb_sys_type	Item Type		x(2)
isb_tarrif	Tariff		x(8)
isb_updates	Updates		x(8)
isb_user1	Ufld1		x(8)
isb_user2	Ufld2		x(8)
isb_warr_cd	Warranty Code	Warr Cd	x(8)
isb_warr_dur	Warranty Duration	War Dur	>>>>>9
isb_warr_exp	Warranty Expiration	Warr Exp	99/99/99
isb_warr_override	Warranty Override		yes/no
oid_isb_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
	isb_classification	no	isb_domain	yes	no
			isb_classification	yes	no
			isb_part	yes	no
	isb_eu_ser	no	isb_domain	yes	no
			isb_eu_nbr	yes	no
			isb_serial	yes	no
			isb_part	yes	no
∗	isb_eupartsr	yes	isb_domain	yes	no
			isb_eu_nbr	yes	no
			isb_part	yes	no
			isb_serial	yes	no
			isb_ref	yes	no
	isb_model	no	isb_domain	yes	no
			isb_eu_nbr	yes	no
			isb_model	yes	no
			isb_serial	yes	no
			isb_ref	yes	no
	isb_part_ser	yes	isb_domain	yes	no
			isb_part	yes	no
			isb_serial	yes	no
			isb_ref	yes	no
	isb_serial	no	isb_domain	yes	no
			isb_serial	yes	no
			isb_ref	yes	no
	isb_sys_bld	no	isb_domain	yes	no
			isb_eu_nbr	yes	no
			isb_rebuild	yes	no
			isb_sys_type	yes	no
	oid_isb_mstr	yes	oid_isb_mstr	yes	no