qbfdecn.asr-deprec-grp

Asset Depreciation Groups


Table details

Area FinData
Dumpname deprecgr
Label Asset Depreciation Groups
Val.exp ?
Val.msg

Triggers

Event Procedure Overr CRC
DELETE trigs/dedeprecgr.t
WRITE trigs/wrdeprecgr.t

Fields

Order Field Name x Label Datatype Format Initial Mand Description
10 acct-grp-cde X Account Group Code integer 99 0
43 accum-area-cde X Accum Deprec Area character x(3)
46 accum-cost-cde X Accum Deprec C/C character x(4)
50 accum-deprec-acct X Accum Deprec Account character x(4)
130 accum-deprec-bal X Accum Deprec Bal decimal-2 >>,>>>,>>>,>>9.99 0
140 book-val-bal X Book Value Balance decimal-2 >>,>>>,>>>,>>9.99 0
120 cost-val-bal X Cost Value Balance decimal-2 >>,>>>,>>>,>>9.99 0
40 costval-acct X Cost Acct Code character x(4)
220 ctrl-acct-cde X Control Acct character x(4)
200 ctrl-area-cde X Control Area character x(3)
210 ctrl-cost-cde X Control Cost Centre character x(4)
110 deprec X Depreciate logical Yes/No NO
30 deprec-meth X Depreciation Method character x(2)
20 grp-desc X Group Desc character x(40)
80 no-of-asset X No Of Assets integer >,>>>,>>9 0
70 prof-loss-acct X Profit&Loss Acct character x(4)
60 scrap-acct X Scrap Acct Code character x(4)
100 scrap-val X Scrap Value decimal-2 >>>,>>9.99 0
180 upd-date X Updated date 99/99/9999 ?
190 upd-user-id X By character x(12)
53 yr-area-cde X Yearly Deprec Area character x(3)
56 yr-cost-cde X Yearly Deprec C/C character x(4)
59 yr-deprec-acct X Yearly Deprec Acc character x(4)
150 yr-deprec-bal X Yearly Deprec Balance decimal-2 >>>,>>>,>>9.99 0

Indexes

Index name Flags Fields Datatype
acct-grp-cde P U acct-grp-cde (+) integer
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

Related tables

Parent tables
inv-comboitem  
Child tables
asr-asset   asr-deprec-std  


generated 18-9-2026 10:01