scx_ref


Field Name	Label	Col-Label	Format	Dec
oid_scx_ref			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
scx__qadc01			x(8)
scx_custpart	Customer Item		x(30)
scx_custref	Customer Ref		x(30)
scx_domain	Domain		x(8)
scx_line	Line		>>9
scx_master_line	Master		yes/no
scx_modelyr	Model Year		x(4)
scx_order	Order		x(8)
scx_part	Item Number		x(18)
scx_po	Purchase Order		x(22)
scx_qkey	Quick Key		x(8)
scx_shipfrom	Ship-From		x(8)
scx_shipto	Ship-To		x(8)
scx_type			9
scx_user1	Ufld1		x(8)
scx_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_scx_ref	yes	oid_scx_ref	yes	no
	scx_custpart	no	scx_domain	yes	no
			scx_type	yes	no
			scx_shipfrom	yes	no
			scx_shipto	yes	no
			scx_custpart	yes	no
			scx_custref	yes	no
			scx_po	yes	no
			scx_modelyr	yes	no
			scx_part	yes	no
	scx_order	yes	scx_domain	yes	no
			scx_type	yes	no
			scx_order	yes	no
			scx_line	yes	no
	scx_po	no	scx_domain	yes	no
			scx_type	yes	no
			scx_po	yes	no
			scx_part	yes	no
			scx_shipto	yes	no
			scx_shipfrom	yes	no
∗	scx_shipfrom	yes	scx_domain	yes	no
			scx_type	yes	no
			scx_shipfrom	yes	no
			scx_shipto	yes	no
			scx_part	yes	no
			scx_custref	yes	no
			scx_po	yes	no
			scx_modelyr	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sc_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sc__qadc01			x(8)
sc_category	Category		x(1)
sc_desc	Description		x(24)
sc_domain	Domain		x(8)
sc_element	Cost Element	Element	x(8)
sc_sim	Cost Set		x(18)
sc_user1	Ufld1		x(8)
sc_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sc_mstr	yes	oid_sc_mstr	yes	no
	sc_sim_cat	no	sc_domain	yes	no
			sc_sim	yes	no
			sc_category	yes	no
∗	sc_sim_elem	yes	sc_domain	yes	no
			sc_sim	yes	no
			sc_element	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sdtd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sdtd__chr01			x(8)
sdtd__chr02			x(8)
sdtd__dec01			->>>,>>>,>>9.99<	10
sdtd__dec02			->>>,>>>,>>9.99<	10
sdtd__dte01			99/99/99
sdtd__dte02			99/99/99
sdtd__log01			yes/no
sdtd__qadc01			x(8)
sdtd__qadc02			x(8)
sdtd__qadd01			->>>,>>>,>>9.99<	10
sdtd__qadd02			->>>,>>>,>>9.99<	10
sdtd__qadi01			>>>>>>9
sdtd__qadi02			>>>>>>9
sdtd__qadl01			yes/no
sdtd__qadl02			yes/no
sdtd__qadt01			99/99/99
sdtd__qadt02			99/99/99
sdtd__user1			x(8)
sdtd__user2			x(8)
sdtd_alloc_percent	Allocation Percent	Percent	>>9.9<	10
sdtd_code	SDT Code		x(3)
sdtd_domain	Domain		x(8)
sdtd_mod_date	Modified Date	Mod Date	99/99/99
sdtd_mod_userid	User ID		x(8)
sdtd_time	SDT Time		99:99


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sdtd_det	yes	oid_sdtd_det	yes	no
∗	sdtd_code	yes	sdtd_domain	yes	no
			sdtd_code	yes	no
			sdtd_time	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sdt_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sdt__chr01			x(8)
sdt__chr02			x(8)
sdt__dec01			->>>,>>>,>>9.99<	10
sdt__dec02			->>>,>>>,>>9.99<	10
sdt__dte01			99/99/99
sdt__dte02			99/99/99
sdt__log01			yes/no
sdt__log02			yes/no
sdt__qadc01			x(8)
sdt__qadc02			x(8)
sdt__qadd01			->>>,>>>,>>9.99<	10
sdt__qadd02			->>>,>>>,>>9.99<	10
sdt__qadi01			>>>>>>9
sdt__qadi02			>>>>>>9
sdt__qadl01			yes/no
sdt__qadl02			yes/no
sdt__qadt01			99/99/99
sdt__qadt02			99/99/99
sdt__user1			x(8)
sdt__user2			x(8)
sdt_code	SDT Code		X(3)
sdt_desc	SDT Description		x(40)
sdt_domain	Domain		x(8)
sdt_mod_date	Modified Date	Mod Date	99/99/99
sdt_mod_userid	User ID		x(8)
sdt_program	SDT Calculation Program		x(12)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sdt_mstr	yes	oid_sdt_mstr	yes	no
∗	sdt_code	yes	sdt_domain	yes	no
			sdt_code	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sd_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sd__chr01			x(8)
sd__chr02			x(8)
sd__qad01			x(8)
sd__qad02			x(8)
sd_acct	Account		x(8)
sd_amt	Amount		->,>>>,>>9.	0
sd_cc	Cost Ctr	CC	x(4)
sd_curr	Currency	Cur	x(3)
sd_cust	Customer		x(8)
sd_disc_pct	Disc Percent	Disc%	->>9.<<	10
sd_domain	Domain		x(8)
sd_expire	Expire		99/99/99
sd_ls_type	Customer Type	Cust Typ	x(8)
sd_prodline	Product Line	Line	x(4)
sd_start	Start		99/99/99
sd_sub	Sub-Account	Sub-Acct	x(8)
sd_type	Type		x(8)
sd_user1	Ufld1		x(8)
sd_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sd_mstr	yes	oid_sd_mstr	yes	no
	sd_cust	no	sd_domain	yes	no
			sd_ls_type	yes	no
			sd_cust	yes	no
			sd_type	yes	no
			sd_amt	yes	no
∗	sd_type	yes	sd_domain	yes	no
			sd_type	yes	no
			sd_amt	yes	no
			sd_start	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_seoc_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
seoc__chr01			x(8)
seoc__chr02			x(8)
seoc__chr03			x(8)
seoc__chr04			x(8)
seoc__chr05			x(8)
seoc__dec01			>>>,>>>,>>9.99	10
seoc__dec02			>>>,>>>,>>9.99	10
seoc__dte01			99/99/99
seoc__dte02			99/99/99
seoc__log01			yes/no
seoc__log02			yes/no
seoc__qadc02	QAD Character Field 2		X(8)
seoc__qadc03	QAD Character Field 3		x(8)
seoc__qadd01	QAD Decimal Field 1		->>>,>>>,>>9.99<<	10
seoc__qadd02	QAD Decimal Field 2		->>,>>9.99	10
seoc__qadi01	QAD Field		->,>>>,>>9
seoc__qadi02	QAD Integer Field 2		->,>>>,>>9
seoc__qadl01	QAD Logical Field		yes/no
seoc__qadl02	QAD Logical Field 2		yes/no
seoc__qadt01	QAD Date Field 1		99/99/99
seoc__qadt02	QAD Date Field 2		99/99/99
seoc_all_days	Allocate MO Lines Due in Days		>>>>>9
seoc_bo_advice	Next Back Order Advice		>>>>>>>>9
seoc_confirm	Confirmed Orders		yes/no
seoc_consume	Consume Forecast	Consume Fcst	yes/no
seoc_consume_shipped	Consume Shipped Lines		x(8)
seoc_det_all	Detail Allocations		yes/no
seoc_dnote	Next Delivery Note		>>>>>>>>9
seoc_domain	Domain		x(8)
seoc_ex_ratetype	Rate Type		x(8)
seoc_hcmmts	MO Header Comments		yes/no
seoc_immed_ship	Ship Immed		yes/no
seoc_index1	Index		>>>>>9
seoc_int_cust	Internal Customer		X(8)
seoc_kit_auto	Autonumbering for Kits		yes/no
seoc_kit_nbr	Next Kit Number		>>>>>>9
seoc_kit_pre	Kit Prefix		X(8)
seoc_lcmmts	MO Line Comments		yes/no
seoc_ln_fmt	Ln Format S/M		single/multi
seoc_mod_date	Modified Date	Mod Date	99/99/99
seoc_mod_userid	User ID		X(8)
seoc_req	Required Qty Reduces Qty Avail		yes/no
seoc_ship_to	Ship To		User/Engineer
seoc_shp_lead	Shipping Lead Time		>>>9
seoc_so	Next Material Order		>>>>>>>9
seoc_so_hist	Keep Booking History	Book!Hst	yes/no
seoc_so_pre	Material Order Prefix	Pre	x(3)
seoc_user1	Ufld1		X(8)
seoc_user2	Ufld2		X(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_seoc_ctrl	yes	oid_seoc_ctrl	yes	no
∗	seoc_index1	yes	seoc_domain	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_seq_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
seq__chr01			x(8)
seq__chr02			x(8)
seq__chr03			x(8)
seq__chr04			x(8)
seq__chr05			x(8)
seq__dec01			>>>,>>>,>>9.99	10
seq__dec02			>>>,>>>,>>9.99	10
seq__dec03			>>>,>>>,>>9.99	10
seq__log01			yes/no
seq_domain	Domain		x(8)
seq_due_date	Due Date		99/99/99
seq_line	Line		x(8)
seq_mode	Mode		yes/no
seq_mode_qty			->,>>>,>>9.99	10
seq_part	Item Number		x(18)
seq_priority	Sequence		>>9.99	10
seq_qty_req	Qty Req		->,>>>,>>9.99	10
seq_release	Release Date		99/99/99
seq_shift1	Shift1		>>>9.99
seq_shift2	Shift2		>>>9.99	10
seq_shift3	Shift3		>>>9.99	10
seq_shift4	Shift4		>>>9.99	10
seq_site	Site		x(8)
seq_start	Start Date		99/99/99
seq_type	Type		Forward/Backward
seq_user1	Ufld1		x(8)
seq_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_seq_mstr	yes	oid_seq_mstr	yes	no
	seq_sequence	yes	seq_domain	yes	no
			seq_site	yes	no
			seq_line	yes	no
			seq_priority	yes	no
∗	seq_site	yes	seq_domain	yes	no
			seq_site	yes	no
			seq_line	yes	no
			seq_part	yes	no
			seq_due_date	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_serc_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
serc__qadc01			x(24)
serc__qadc02			x(24)
serc_active	Serialization Active Flag		yes/no
serc_ccb_active			>>>,>>>,>>9
serc_domain	Domain		x(8)
serc_enf_lvl	Serial Number Enforcement Level		x(1)
serc_max_limit	Serial Number Maximum Limit		>>>,>>>,>>9
serc_mod_date	Modified Date	Mod Date	99/99/99
serc_mod_userid	User ID		x(8)
serc_user1	User Field Character 1		x(24)
serc_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_serc_ctrl	yes	oid_serc_ctrl	yes	no
∗	serc_domain	yes	serc_domain	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_ser_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_serd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_table_record	Record OID		>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
serd__qadc01			x(24)
serd__qadc02			x(24)
serd_mod_date	Modified Date	Mod Date	99/99/99
serd_mod_userid	User ID		x(8)
serd_net_wt	Net Weight		->>,>>9.99<<<<	10
serd_net_wt_um	Net Weight UM	UM	x(2)
serd_price	Price		->>>>,>>>,>>9.99<<<	10
serd_qty_pck	Pick Qty		->,>>>,>>9.9<<<<<<<<	10
serd_reference	Reference		x(20)
serd_status	Status		>>9
serd_table_name	Record Table Name		x(18)
serd_tax_env	Tax Environment	Tax Env	x(16)
serd_tax_in	Tax In		yes/no
serd_tax_usage	Tax Usage	Tax Use	x(8)
serd_taxable	Taxable		yes/no
serd_taxc	Tax Class	Tax!Class	x(3)
serd_type	Reserving/Booking type		x(18)
serd_user1	User Field Character 1		x(24)
serd_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_serd_det	yes	oid_serd_det	yes	no
	serd_oid_ser_mstr	no	oid_ser_mstr	yes	no
			serd_type	yes	no
			serd_table_name	yes	no
	serd_order	no	serd_table_name	yes	no
			oid_table_record	yes	no
	serd_status	no	serd_type	yes	no
			serd_table_name	yes	no
			oid_table_record	yes	no
			serd_status	yes	no
∗	serd_table_type	yes	oid_ser_mstr	yes	no
			oid_table_record	yes	no
			serd_table_name	yes	no
			serd_type	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_parent	Count Parent OID		>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_serh_hist			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_tr_hist	Identifier Transaction History		>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
serh__qadc01			x(24)
serh__qadc02			x(24)
serh_begin_qoh	Begin QOH		->,>>>,>>9.9<<<<<<<<	10
serh_cause	Cause		x(40)
serh_cnt_init	Initial		yes/no
serh_cnt_open	Cycle Count Batch Open		yes/no
serh_cnt_qty	Quantity Count		->,>>>,>>9.9<<<<<<<<	10
serh_content_um	Content UM		x(2)
serh_domain	Domain		x(8)
serh_loc	Location		x(8)
serh_lotser	Lot/Ser		x(18)
serh_master_id	Master Ser ID		x(40)
serh_master_stage	Master Ser Stage		x(10)
serh_mod_date	Modified Date	Mod Date	99/99/99
serh_mod_userid	User ID		x(8)
serh_pack_code	Pack Code		x(18)
serh_pack_um	Pack UM		x(2)
serh_parent_id	Parent Ser ID		x(40)
serh_parent_table	Count Table Name		x(18)
serh_part	Item		x(18)
serh_phantom	Phantom Pack		yes/no
serh_program	Program		x(12)
serh_qty_chg	Qty Chg		->,>>>,>>9.9<<<<<<<<	10
serh_ref	Reference		x(8)
serh_serial_id	Serial ID		x(40)
serh_site	Site		x(8)
serh_stage	Stage		x(10)
serh_trans_date	Serial Trans Date		99/99/99
serh_trans_nbr	Transaction Number		>>>>>>>>>>
serh_trans_time	Serial Trans Time		>>,>>>,>>9
serh_trans_type	Transaction Type		x(8)
serh_user1	User Field Character 1		x(24)
serh_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_count_parent	no	oid_parent	yes	no
	oid_serh_hist	yes	oid_serh_hist	yes	no
	oid_tr_hist	no	oid_tr_hist	yes	no
	serh_serial_id	no	serh_domain	yes	no
			serh_serial_id	yes	no
∗	serh_trans_nbr	yes	serh_domain	yes	no
			serh_trans_nbr	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_ld_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_loc_mstr	Location Master OID		>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_ser_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_ser_mstr_parent	Parent Serial Master OID		>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
ser__qadc01			x(24)
ser__qadc02			x(24)
ser_domain	Domain		x(8)
ser_gross_weight	Gross Weight		->>,>>9.99<<<<	10
ser_gross_weight_um	Gross Weight UM		x(2)
ser_loc	Location		x(8)
ser_lotser	Lot/Serial		x(18)
ser_mod_date	Modified Date	Mod Date	99/99/99
ser_mod_userid	User ID		x(8)
ser_pack_code	Pack Code		x(18)
ser_part	Item		x(18)
ser_phantom	Phantom Pack		yes/no
ser_prt_lbl	Serial ID Printed		yes/no
ser_qty_avail	Avail Pack Qty		->,>>>,>>9.9<<<<<<<<	10
ser_qty_pck	Std Pack Qty		->,>>>,>>9.9<<<<<<<<	10
ser_ref	Reference		x(8)
ser_serial_id	Serial ID		x(40)
ser_ship_wt	Ship Weight		->>,>>9.99<<<<	10
ser_ship_wt_um	Ship Weight UM	UM	x(2)
ser_site	Site		x(8)
ser_size	Volume		->>,>>9.99	10
ser_size_um	Volume UM	UM	x(2)
ser_stage	Stage		x(10)
ser_truck_loaded	Truck Loaded		yes/no
ser_um	UM		x(2)
ser_unloaded	Unloaded		yes/no
ser_user1	User Field Character 1		x(24)
ser_user2	User Field Character 2		x(24)
ser_vend_lot	Supplier Lot		x(18)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_ser_mstr	yes	oid_ser_mstr	yes	no
	oid_ser_mstr_ld	no	oid_ld_det	yes	no
	oid_ser_mstr_loc	no	oid_loc_mstr	yes	no
	oid_ser_mstr_parent	no	oid_ser_mstr_parent	yes	no
∗	ser_domain_serial	yes	ser_domain	yes	no
			ser_serial_id	yes	no
	ser_pt_loc_lot	no	ser_domain	yes	no
			ser_part	yes	no
			ser_site	yes	no
			ser_loc	yes	no
			ser_lotser	yes	no
			ser_ref	yes	no
	ser_pt_stg	no	ser_domain	yes	no
			ser_part	yes	no
			ser_stage	yes	no
	ser_serial_id	yes	ser_serial_id	yes	no
	ser_stg_site_loc	no	ser_domain	yes	no
			ser_stage	yes	no
			ser_site	yes	no
			ser_loc	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_lgdd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
oid_sfb_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sfb__chr01	User Field #1		x(8)
sfb__chr02	User Field #2		x(8)
sfb__chr03	User Field #3		x(8)
sfb__chr04	User Field #4		x(8)
sfb__dec01	User Decimal #1		->>>,>>>,>>9.99<<<<	10
sfb__dec02	User Decimal #2		->>>,>>>,>>9.99<<<<	10
sfb__dec03	User Decimal #3		->>>,>>>,>>9.99<<<<	10
sfb__dte01	User Date #1		99/99/99
sfb__dte02	User Date #2		99/99/99
sfb__dte03	User Date #3		99/99/99
sfb__log01	User Logical #1		yes/no
sfb__log02	User Logical #2		yes/no
sfb__log03	User Logical #3		yes/no
sfb__qadc01	QAD Character Field		x(8)	0
sfb__qadc02	Qad Field #2		x(8)
sfb__qadc03	Qad Field #3		x(8)
sfb__qadc04	QAD Character Field		x(8)	0
sfb__qadd01	Qad Date #1		99/99/99
sfb__qadd02	Qad Date #2		99/99/99
sfb__qadd03	Qad Date #3		99/99/99
sfb__qadde01	Qad Decimal #1		->>>,>>>,>>9.99<<<<	10
sfb__qadde02	Qad Decimal #2		->>>,>>>,>>9.99<<<<	10
sfb__qadde03	Qad Decimal #3		->>>,>>>,>>9.99<<<<	10
sfb__qadl01	QAD Logical Field		yes/no
sfb__qadl02	QAD Logical Field		yes/no
sfb__qadl03	QAD Logical Field		yes/no
sfb__qadl04	QAD Logical Field		yes/no
sfb_ca_opn_date			99/99/99
sfb_cmtindx	Comment Index	Comment	>>>>>>>9
sfb_covered_amt	Covered Amount		>>>>,>>>,>>9.99<<<	10
sfb_desc	Description		x(24)
sfb_detail			yes/no
sfb_domain	Domain		x(8)
sfb_exchange	Exchange		yes/no
sfb_exg_price	Exchange Price		->>>>,>>>,>>9.99<<<	10
sfb_fcg_code	Charge Code	Charge	x(8)
sfb_fis_column	Column	Col	>>9
sfb_fis_sort	Type		x(18)
sfb_fixed_cost			>>>>,>>>,>>9.99<<<	10
sfb_fixed_price			->>>,>>>,>>9.99<<<	10
sfb_fsc_code	Service Category	Svc Cat	x(8)
sfb_invoice_cost			>>>>,>>>,>>9.99<<<	10
sfb_line	Line		>>>9
sfb_mod_date	Modified Date	Mod Date	99/99/99
sfb_mod_userid	User ID		X(8)
sfb_nbr			x(8)
sfb_op	Operation	Op	>>>>>9
sfb_part	Item		x(18)
sfb_price	List Price		->>>,>>>,>>9.99<<<	10
sfb_price_on_inv	Price on Invoice		yes/no
sfb_pst	PST Taxable		yes/no
sfb_pt_type			>>9
sfb_qty_billed	Qty Billed		->>>,>>9.9<	10
sfb_qty_inv	Qty to Invoice	Qty to Inv	->>>,>>9.9<	10
sfb_qty_on_inv	Qty on Invoice		yes/no
sfb_qty_req	Qty Required		->>>,>>9.9<<	10
sfb_qty_ret	Qty Returned		->,>>>,>>9.9<<<	10
sfb_report	Report		X(8)
sfb_ret_serial	Returned Serial		X(18)
sfb_serial	Serial		x(18)
sfb_so_line	SO Line		>>>9
sfb_tax_env	Tax Environment		X(16)	0
sfb_tax_in	Tax In		yes/no
sfb_tax_usage	Tax Usage		x(8)	0
sfb_taxable	Taxable		yes/no
sfb_taxc	Tax Class		x(8)	0
sfb_total_std	Total Cost		->>>,>>>,>>9.99<<<	10
sfb_um	UM		x(2)
sfb_user1	Ufld1		X(8)
sfb_user2	Ufld2		X(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sfb_det	yes	oid_sfb_det	yes	no
∗	sfb_line	yes	sfb_domain	yes	no
			sfb_nbr	yes	no
			sfb_so_line	yes	no
			sfb_pt_type	yes	no
			sfb_fis_sort	yes	no
			sfb_line	yes	no
	sfb_report	no	sfb_domain	yes	no
			sfb_report	yes	no
			sfb_op	yes	no
			sfb_part	yes	no
			sfb_line	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sfh_hist			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sfh__chr01	User Character Field #1		x(8)	0
sfh__chr02	User Character Field #2		x(8)	0
sfh__chr03	User Character Field #3		x(8)	0
sfh__chr04	User Character Field #4		x(8)	0
sfh__dec01	User Decimal #1		->>>,>>>,>>9.99<<<<	10
sfh__dec02	User Decimal #2		->>>,>>>,>>9.99<<<<	10
sfh__dec03	User Decimal #3		->>>,>>>,>>9.99<<<<	10
sfh__dte01	User Date #1		99/99/99
sfh__dte02	User Date #2		99/99/99
sfh__dte03	User Date #3		99/99/99
sfh__log01	User Logical #1		yes/no
sfh__log02	User Logical #2		yes/no
sfh__log03	User Logical #3		yes/no
sfh__qadc01	QAD Character Field		x(8)	0
sfh__qadc02	Qad Field #2		x(8)
sfh__qadc03	Qad Field #3		x(8)
sfh__qadc04	QAD Character Field		x(8)	0
sfh__qadd01	Qad Date #1		99/99/99
sfh__qadd02	Qad Date #2		99/99/99
sfh__qadd03	Qad Date #3		99/99/99
sfh__qadde01	Qad Decimal #1		->>>,>>>,>>9.99<<<<	10
sfh__qadde02	Qad Decimal #2		->>>,>>>,>>9.99<<<<	10
sfh__qadde03	Qad Decimal #3		->>>,>>>,>>9.99<<<<	10
sfh__qadl01	QAD Logical Field		yes/no
sfh__qadl02	QAD Logical Field		yes/no
sfh__qadl03	QAD Logical Field		yes/no
sfh__qadl04	QAD Logical Field		yes/no
sfh_ca_opn_date			99/99/99
sfh_cmtindx	Comment Index	Comment	>>>>>>>9
sfh_covered_amt	Covered Amount		>>>>,>>>,>>9.99<<<	10
sfh_desc	Description		x(24)
sfh_detail			yes/no
sfh_domain	Domain		x(8)
sfh_exchange	Exchange		yes/no
sfh_exg_price	Exchange Price		->>>>,>>>,>>9.99<<<	10
sfh_fcg_code	Charge Code	Charge	x(8)
sfh_fis_column	Column	Col	>>9
sfh_fis_sort	Type		x(18)
sfh_fixed_cost			>>>>,>>>,>>9.99<<<	10
sfh_fixed_price			->>>,>>>,>>9.99<<<	10
sfh_fsc_code	Service Category	Svc Cat	x(8)
sfh_inv_nbr	Invoice		x(22)
sfh_invoice_cost			>>>>,>>>,>>9.99<<<	10
sfh_line	Line		>>>9
sfh_mod_date	Modified Date	Mod Date	99/99/99
sfh_mod_userid	User ID		X(8)
sfh_nbr			x(8)
sfh_op	Operation	Op	>>>>>9
sfh_part	Item		x(18)
sfh_price	List Price		->>>,>>>,>>9.99<<<	10
sfh_price_on_inv	Price on Invoice		yes/no
sfh_pst	PST Taxable		yes/no
sfh_pt_type			>>9
sfh_qty_billed	Qty Billed		->>>,>>9.9<	10
sfh_qty_inv	Qty to Invoice	Qty to Inv	->>>,>>9.9<	10
sfh_qty_on_inv	Qty on Invoice		yes/no
sfh_qty_req	Qty Required		->>>,>>9.9<<	10
sfh_qty_ret	Qty Returned		->,>>>,>>9.9<<<	10
sfh_report	Report		X(8)
sfh_ret_serial	Returned Serial		X(18)
sfh_serial	Serial		x(18)
sfh_so_line	SO Line		>>>9
sfh_tax_env	Tax Environment		X(16)	0
sfh_tax_in	Tax In		yes/no
sfh_tax_usage	Tax Usage		x(8)	0
sfh_taxable	Taxable		yes/no
sfh_taxc	Tax Class		x(8)	0
sfh_total_std	Total Cost		->>>,>>>,>>9.99<<<	10
sfh_trnbr	Transaction		>>>>>>>>>9
sfh_um	UM		x(2)
sfh_user1	Ufld1		X(8)
sfh_user2	Ufld2		X(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sfh_hist	yes	oid_sfh_hist	yes	no
	sfh_inv_nbr	no	sfh_domain	yes	no
			sfh_inv_nbr	yes	no
			sfh_so_line	yes	no
			sfh_pt_type	yes	no
			sfh_fis_sort	yes	no
			sfh_line	yes	no
	sfh_line	no	sfh_domain	yes	no
			sfh_nbr	yes	no
			sfh_so_line	yes	no
			sfh_pt_type	yes	no
			sfh_fis_sort	yes	no
			sfh_line	yes	no
∗	sfh_trnbr	yes	sfh_domain	yes	no
			sfh_trnbr	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sgad_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sgad__qadc01			x(8)
sgad_addr	Address		x(8)
sgad_cons_ship	Consolidate Ship		x(1)
sgad_domain	Domain		x(8)
sgad_grp	Shipping Group	Ship Grp	x(8)
sgad_is_src	Source/Dest		Source/Dest
sgad_user1	Ufld1		x(8)
sgad_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sgad_det	yes	oid_sgad_det	yes	no
	sgad_addr	yes	sgad_domain	yes	no
			sgad_addr	yes	no
			sgad_is_src	yes	no
			sgad_grp	yes	no
∗	sgad_grp	yes	sgad_domain	yes	no
			sgad_grp	yes	no
			sgad_is_src	yes	no
			sgad_addr	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sgcd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sgcd__qadc01			x(8)
sgcd_carrier	Carrier		x(8)
sgcd_domain	Domain		x(8)
sgcd_grp	Shipping Group	Ship Grp	x(8)
sgcd_inv_mov	Inventory Movement Code	Inv Mov	x(8)
sgcd_seq	Seq		>>9
sgcd_user1	Ufld1		x(8)
sgcd_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sgcd_det	yes	oid_sgcd_det	yes	no
	sgcd_carrier	no	sgcd_domain	yes	no
			sgcd_carrier	yes	no
∗	sgcd_grp	yes	sgcd_domain	yes	no
			sgcd_grp	yes	no
			sgcd_inv_mov	yes	no
			sgcd_seq	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sgid_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sgid__qadc01			x(8)
sgid__qadc02			x(8)
sgid_default	Default		yes/no
sgid_domain	Domain		x(8)
sgid_format	Document Format	Format	x(8)
sgid_grp	Shipping Group	Ship Grp	x(8)
sgid_inv_mov	Inventory Movement Code	Inv Mov	x(8)
sgid_preship_nr_id	Pre-Shipper Sequence ID	PS Seq	x(8)
sgid_ship_nr_id	Shipper Sequence ID	Ship Seq	x(8)
sgid_user1	Ufld1		x(8)
sgid_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sgid_det	yes	oid_sgid_det	yes	no
	sgid_default	yes	sgid_domain	yes	no
			sgid_grp	yes	no
			sgid_default	yes	no
			sgid_inv_mov	yes	no
	sgid_format	no	sgid_domain	yes	no
			sgid_format	yes	no
∗	sgid_grp	yes	sgid_domain	yes	no
			sgid_grp	yes	no
			sgid_inv_mov	yes	no
	sgid_inv_mov	no	sgid_domain	yes	no
			sgid_inv_mov	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_sg_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sg__qadc01			x(8)
sg_auto_tr	Auto Transfers	Auto Xfers	yes/no
sg_desc	Description		x(30)
sg_domain	Domain		x(8)
sg_grp	Shipping Group	Ship Grp	x(8)
sg_inv_mov	Inventory Movement Code	Inv Mov	x(8)
sg_master_nr_id	Master Bill Sequence ID	MBOL Seq	x(8)
sg_user1	Ufld1		x(8)
sg_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sg_mstr	yes	oid_sg_mstr	yes	no
∗	sg_grp	yes	sg_domain	yes	no
			sg_grp	yes	no
	sg_inv_mov	no	sg_domain	yes	no
			sg_inv_mov	yes	no


Field Name	Label	Col-Label	Format	Dec
CustomCombo0			x(20)
CustomCombo1			x(20)
CustomCombo2			x(20)
CustomCombo3			x(20)
CustomCombo4			x(20)
CustomCombo5			x(20)
CustomCombo6			x(20)
CustomCombo7			x(20)
CustomCombo8			x(20)
CustomCombo9			x(20)
CustomDate0			99/99/9999
CustomDate1			99/99/9999
CustomDate2			99/99/9999
CustomDate3			99/99/9999
CustomDate4			99/99/9999
CustomDecimal0			->,>>>,>>9.99	4
CustomDecimal1			->,>>>,>>9.99	4
CustomDecimal2			->,>>>,>>9.99	4
CustomDecimal3			->,>>>,>>9.99	4
CustomDecimal4			->,>>>,>>9.99	4
CustomInteger0			->,>>>,>>9
CustomInteger1			->,>>>,>>9
CustomInteger2			->,>>>,>>9
CustomInteger3			->,>>>,>>9
CustomInteger4			->,>>>,>>9
CustomLong0			x(255)
CustomLong1			x(255)
CustomNote			x(2000)
CustomShort0			x(20)
CustomShort1			x(20)
CustomShort2			x(20)
CustomShort3			x(20)
CustomShort4			x(20)
CustomShort5			x(20)
CustomShort6			x(20)
CustomShort7			x(20)
CustomShort8			x(20)
CustomShort9			x(20)
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SharedSet_ID	Record ID		-99999999999
SharedSetCode	Shared Set Code		x(20)
SharedSetDescription	Shared Set Description		x(40)
SharedSetIsActive	Active	Act	yes/no
SharedSetTypeCode	Shared Set Type		x(20)


	Index-Name	Uni	Field-Name	Asc	Abbr
	Code	yes	SharedSetCode	yes	no
∗	Prim	yes	SharedSet_ID	yes	no
	Type	no	SharedSetTypeCode	yes	no


Field Name	Label	Col-Label	Format	Dec
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SharedSetMergeLog_ID	Record ID		-99999999999
SharedSetMergeLogEndDate	End Date		99/99/9999
SharedSetMergeLogEndTime	End Time		99999
SharedSetMergeLogIsFinish	Is Finished		yes/no
SharedSetMergeLogMaster	Master Shared Set Code		x(20)
SharedSetMergeLogRedundant	Redundant Shared Set Code		x(20)
SharedSetMergeLogStartDate	Start Date		99/99/9999
SharedSetMergeLogStartTime	Start Time		99999


	Index-Name	Uni	Field-Name	Asc	Abbr
	Finished	no	SharedSetMergeLogIsFinish	yes	no
	Master	no	SharedSetMergeLogMaster	yes	no
∗	Prim	yes	SharedSetMergeLog_ID	yes	no
	Redundant	no	SharedSetMergeLogRedundant	yes	no


Field Name	Label	Col-Label	Format	Dec
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SharedSet_ID	Link to SharedSet		-99999999999
SharedSetProperty_ID	Record ID		-99999999999


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	Prim	yes	SharedSetProperty_ID	yes	no
	SharedSet	yes	SharedSet_ID	yes	no


Field Name	Label	Col-Label	Format	Dec
LastModifiedDate	Last Modified Date	Mod Date	99/99/9999
LastModifiedTime	Last Modified Time	Mod Time	99999
LastModifiedUser	Last Modified User	Mod User	x(20)
QADC01			x(40)
QADC02			x(255)
QADD01			->,>>>,>>9.9999	10
QADT01			99/99/9999
SharedSetTypeCode	Shared Set Type		x(20)
SharedSetTypeIsActive	Active		yes/no
SharedSetTypeTranslated	Translation		x(40)


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	Prim	yes	SharedSetTypeCode	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_shcd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
shcd__qadc01			x(24)
shcd__qadc02			x(24)
shcd_domain	Domain		x(8)
shcd_export_directory	Default Export Directory		x(60)
shcd_mod_date	Modified Date	Mod Date	99/99/99
shcd_mod_userid	User ID		x(8)
shcd_user1	User Field Character 1		x(24)
shcd_user2	User Field Character 2		x(24)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_shcd_det	yes	oid_shcd_det	yes	no
∗	shcd_export_dir	yes	shcd_domain	yes	no
			shcd_export_directory	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_shc_ctrl			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
shc__qadc01			x(8)
shc__qadi01			->>>>>>>9
shc_archive_directory	Default Archive Directory		x(60)
shc_check_ship_pending	Check Shipments Pending for Post		yes/no
shc_del_import_file	Delete Import Files After Archiving		yes/no
shc_domain	Domain		x(8)
shc_format	Document Format	Format	x(8)
shc_ic_ship	Create Shipper		x(1)
shc_import_directory	Default Import Directory		x(60)
shc_intrans_loc	In-Transit Location		x(8)
shc_master_nr_id	Master Bill Sequence ID		x(8)
shc_pod	Proof of Delivery Orders		yes/no
shc_preship_nr_id	Pre-Shipper Sequence ID		x(8)
shc_require_inv_mov	Require Inventory Movement Codes		yes/no
shc_rss_cal_option	RSS Calendar Option		>>9
shc_sep_shp_periods	Method of Checking Shipments Pending for Post		x(1)
shc_ship_nr_id	Shipper Sequence ID		x(8)
shc_ship_rcpt	Shipment Info For Receipts		yes/no
shc_shipper_print	Allow Printing With Errors		yes/no
shc_source_directory	Default Source Directory		x(60)
shc_trl_amts	Maintain Trailer Amounts		yes/no
shc_use_pod	Use Proof of Delivery		yes/no
shc_user1	Ufld1		x(8)
shc_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_shc_ctrl	yes	oid_shc_ctrl	yes	no
∗	shc_index1	yes	shc_domain	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_shd_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
shd__qadc01			x(8)
shd_code	Transport ID	Trans ID	x(8)
shd_departs	Ship Date		99/99/99
shd_domain	Domain		x(8)
shd_rec_site	Receiving Site	Rec Site	x(8)
shd_src_site	Source Site	Source	x(8)
shd_user1	Ufld1		x(8)
shd_user2	Ufld2		x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_shd_det	yes	oid_shd_det	yes	no
∗	shd_code	yes	shd_domain	yes	no
			shd_code	yes	no
			shd_src_site	yes	no
			shd_rec_site	yes	no
			shd_departs	yes	no


Field Name	Label	Col-Label	Format	Dec
oid_shft_det			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
shft__chr01			x(8)
shft__chr02			x(8)
shft__chr03			x(8)
shft__chr04			x(8)
shft__chr05			x(8)
shft__dec01			>>>,>>>,>>9.99	10
shft__dec02			>>>,>>>,>>9.99	10
shft__dec03			>>>,>>>,>>9.99	10
shft__dec04			>>>,>>>,>>9.99	10
shft__log01			yes/no
shft_day	Day of Week	Day	9
shft_domain	Domain		x(8)
shft_hour1	Hours		>,>>9.9<	10
shft_hour2	Hours		>,>>9.9<	10
shft_hour3	Hours		>,>>9.9<	10
shft_hour4	Hours		>,>>9.9<	10
shft_load1	Load		>>9.99%	10
shft_load2	Load		>>9.99%	10
shft_load3	Load		>>9.99%	10
shft_load4	Load		>>9.99%	10
shft_mch	Machine		x(8)
shft_pat1	Pattern		x(8)
shft_pat2	Pattern		x(8)
shft_pat3	Pattern		x(8)
shft_pat4	Pattern		x(8)
shft_site	Site		x(8)
shft_start1	Start Time	Start	>,>>9.9<<	10
shft_start2	Start Time	Start	>,>>9.9<<	10
shft_start3	Start Time	Start	>,>>9.9<<	10
shft_start4	Start Time	Start	>,>>9.9<<	10
shft_user1	Ufld1		x(8)
shft_user2	Ufld2		x(8)
shft_wkctr	Work Center	Work Ctr	x(8)


	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_shft_det	yes	oid_shft_det	yes	no
∗	shft_day	yes	shft_domain	yes	no
			shft_site	yes	no
			shft_wkctr	yes	no
			shft_mch	yes	no
			shft_day	yes	no