About This Guide > tbl_mstr
  
tbl_mstr
Service/Support Parent/Child Relationship Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tbl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tbl__chr01
User Character Field 1
 
x(8)
 
 
tbl__chr02
User Character Field 2
 
x(8)
 
 
tbl__chr03
User Character Field 3
 
x(8)
 
 
tbl__chr04
User Character Field 4
 
x(8)
 
 
tbl__chr05
User Character Field 5
 
x(8)
 
 
tbl__dec01
User Decimal Field 1
 
->>,>>9.99
10
 
tbl__dec02
User Decimal Field 2
 
->>,>>9.99
10
 
tbl__dte01
User Date Field 1
 
99/99/99
 
 
tbl__dte02
User Date Field 2
 
99/99/99
 
 
tbl__log01
User Logical Field 1
 
yes/no
 
 
tbl__log02
User Logical Field 2
 
yes/no
 
 
tbl__qadc01
QAD Character Field 1
 
x(8)
 
 
tbl__qadc02
QAD Character Field 2
 
x(8)
 
 
tbl__qadd01
QAD Date Field 1
 
99/99/99
 
 
tbl__qadd02
QAD Date Field 2
 
99/99/99
 
 
tbl__qadde01
QAD Decimal Field 1
 
->>,>>9.99
10
 
tbl__qadde02
QAD Decimal Field 2
 
->>,>>9.99
10
 
tbl__qadl01
QAD Logical Field 1
 
yes/no
 
 
tbl__qadl02
QAD Logical Field 2
 
yes/no
 
 
tbl_compcode
Component
 
x(18)
 
 
tbl_comptype
Component Type
Comp Type
x(12)
 
 
tbl_domain
Domain
 
x(8)
 
 
tbl_end
End Effective
End Eff
99/99/99
 
 
tbl_mod_date
Modified Date
Mod Date
99/99/99
 
 
tbl_mod_userid
User ID
 
X(8)
 
 
tbl_parcode
Parent
 
x(18)
 
 
tbl_partype
Parent Type
 
x(12)
 
 
tbl_ref
Reference
 
x(12)
 
 
tbl_rmks
Remarks
 
x(24)
 
 
tbl_start
Start Effective
Start Eff
99/99/99
 
 
tbl_user1
Ufld1
 
x(8)
 
 
tbl_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tbl_mstr
yes
oid_tbl_mstr
yes
no
 
tbl_comp
no
tbl_domain
yes
no
 
 
 
tbl_comptype
yes
no
 
 
 
tbl_compcode
yes
no
tbl_typecode
yes
tbl_domain
yes
no
 
 
 
tbl_partype
yes
no
 
 
 
tbl_parcode
yes
no
 
 
 
tbl_comptype
yes
no
 
 
 
tbl_compcode
yes
no