About This Guide > dpt_mstr
  
dpt_mstr
Department Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dpt__chr01
 
 
x(8)
 
 
dpt__chr02
 
 
x(8)
 
 
dpt__chr03
 
 
x(8)
 
 
dpt__chr04
 
 
x(8)
 
 
dpt__chr05
 
 
x(8)
 
 
dpt__dec01
 
 
>>>,>>>,>>9.99
10
 
dpt__dec02
 
 
>>>,>>>,>>9.99
10
 
dpt__dte01
 
 
99/99/99
 
 
dpt__dte02
 
 
99/99/99
 
 
dpt__log01
 
 
yes/no
 
 
dpt__qadc01
 
 
x(8)
 
 
dpt__qadc02
 
 
x(4)
 
 
dpt__qadc03
 
 
x(8)
 
 
dpt__qadc04
 
 
x(4)
 
 
dpt__qadc05
 
 
x(8)
 
 
dpt__qadc06
 
 
x(4)
 
 
dpt__qadc07
 
 
x(8)
 
 
dpt__qadc08
 
 
x(4)
 
 
dpt_bdn_acct
Burden
 
x(8)
 
 
dpt_bdn_cc
Burden Cost Ctr
CC
x(4)
 
 
dpt_bdn_sub
Burden Sub-Acct
Sub-Acct
x(8)
 
 
dpt_bvar_acc
Burden Usage Variance
Bdn Use
x(8)
 
 
dpt_bvar_cc
Burden Usage Variance CC
CC
x(4)
 
 
dpt_bvar_sub
Burden Usage Var Sub
Sub-Acct
x(8)
 
 
dpt_bvrr_acc
Burden Rate Variance
Bdn Rate
x(8)
 
 
dpt_bvrr_cc
Burden Rate Variance CC
CC
x(4)
 
 
dpt_bvrr_sub
Burden Rate Var Sub
Sub-Acct
x(8)
 
 
dpt_cop_acct
Cost of Production
COP
x(8)
 
 
dpt_cop_cc
Cost of Production Cost Ctr
CC
x(4)
 
 
dpt_cop_sub
Cost of Production Sub
Sub-Acct
x(8)
 
 
dpt_dept
Department
Dept
x(8)
 
 
dpt_desc
Description
 
x(24)
 
 
dpt_domain
Domain
 
x(8)
 
 
dpt_lbr_acct
Labor
 
x(8)
 
 
dpt_lbr_cap
Labor capacity
 
->,>>>,>>9
 
 
dpt_lbr_cc
Labor Cost Ctr
CC
x(4)
 
 
dpt_lbr_sub
Labor Sub-Acct
Sub-Acct
x(8)
 
 
dpt_lvar_acc
Labor Usage Variance
Lbr Use
x(8)
 
 
dpt_lvar_cc
Labor Usage Variance CC
CC
x(4)
 
 
dpt_lvar_sub
Labor Usage Var Sub
Sub-Acct
x(8)
 
 
dpt_lvrr_acc
Labor Rate Variance
Lbr Rate
x(8)
 
 
dpt_lvrr_cc
Labor Rate Variance CC
CC
x(4)
 
 
dpt_lvrr_sub
Labor Rate Var Sub
Sub-Acct
x(8)
 
 
dpt_mod_date
Modified Date
Mod Date
99/99/99
 
 
dpt_user1
Ufld1
 
x(8)
 
 
dpt_user2
Ufld2
 
x(8)
 
 
dpt_userid
User ID
 
x(8)
 
 
oid_dpt_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
dpt_dept
yes
dpt_domain
yes
no
 
 
 
dpt_dept
yes
no
 
dpt_desc
yes
dpt_domain
yes
no
 
 
 
dpt_desc
yes
no
 
 
 
dpt_dept
yes
no
 
oid_dpt_mstr
yes
oid_dpt_mstr
yes
no