dataset BMfgEngineer

class dataset

object identification

primary key
eng_domain
eng_addr

table teng_mstr

field name	data type	mnd.	description
eng_addr	character(80)	no	Engineer
eng_status	character(80)	no	Status
eng_location	character(80)	no	Current Location
eng_skills	character(80)	no	Skills
eng_area	character(30)	no	Service Area
eng_pager	character(30)	no	Pager
eng_group	character(80)	no	Group
eng_labor	character(80)	no	Labor Part
eng_cplt_dt	date	no	Completion Date
eng_cplt_tm	integer	no	Completion Time
eng_sort	character(80)	no	Name
eng__chr01	character(80)	no
eng__chr02	character(80)	no
eng__chr03	character(80)	no
eng__chr04	character(80)	no
eng__chr05	character(80)	no
eng_site	character(80)	no	Site
eng_loc	character(80)	no	Location
eng__chr06	character(80)	no
eng__chr07	character(80)	no
eng__chr08	character(80)	no
eng__chr09	character(80)	no
eng__chr10	character(80)	no
eng__dec01	decimal(10)	no
eng__dec02	decimal(10)	no
eng__dec03	decimal(10)	no
eng__dte01	date	no
eng__dte02	date	no
eng__dte03	date	no
eng__dte04	date	no
eng__log01	logical	no
eng__log02	logical	no
eng__log03	logical	no
eng__log04	logical	no
eng__log05	logical	no
eng_site_rtn	character(80)	no	Return Site
eng_loc_rtn	character(80)	no	Return Location
eng_sub	logical	no	Subcontractor
eng_user1	character(80)	no	Ufld1
eng_user2	character(80)	no	Ufld2
eng_code	character(80)	no	Engineer Code
eng_esh_schedule	character(80)	no	Schedule
eng_field	logical	no	Field Engineer
eng_call_load	integer	no	Calls per Day
eng_3rd_party	logical	no	Third Party Engineer
eng_avail_ot	logical	no	Available for Overtime
eng__qadc01	character(80)	no	Engineer Address
eng__qadc02	character(80)	no	QAD Character Field 2
eng__qadd01	date	no	QAD Date Field 1
eng__qadd02	date	no	QAD Date Field 2
eng__qadde01	decimal(10)	no	QAD Decimal Field 1
eng__qadi01	integer	no	QAD Integer Field 1
eng__qadi02	integer	no	QAD Integer Field 2
eng__qadl01	logical	no	QAD Logical Field 1
eng__qadl02	logical	no	QAD Logical Field 2
eng_mod_userid	character(80)	no	User ID
eng_mod_date	date	no	Modified Date
eng_address	character(80)	no	Engineer Address
eng_domain	character(8)	yes	Domain
oid_eng_mstr	decimal(10)	no
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	no	empty string
tc_Status	character	no	update status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character