business logic query FADeprecByAssetBookDeprYear

Parameters

iiCompanyId	integer	Company id
iiFAAssetBookId	integer
iiDeprecYearUpperLimit	integer
iiDeprecYear	integer
iiDeprecMonth	integer

query condition

each FADepreciation where

FADepreciation.Company_Id = iiCompanyId AND
FADepreciation.FAAssetBook_ID = iiFAAssetBookId AND
FADepreciation.FADepreciationYear <= iiDeprecYearUpperLimit AND
(FADepreciation.FADepreciationYear = iiDeprecYear AND
FADepreciation.FADepreciationMonth = iiDeprecMonth )

query sort order

FADepreciation.FADepreciationYear (ascending)
FADepreciation.FADepreciationMonth (ascending)

query resultset tqFADeprecByAssetBookDeprYear

field name	data type	db field	description
tiFAAssetBook_ID	integer	FADepreciation.FAAssetBook_ID	Link to FAAssetBook
tdFADepreciationAmountCC	decimal	FADepreciation.FADepreciationAmountCC	SC Depreciation Amount
tdFADepreciationAmountLC	decimal	FADepreciation.FADepreciationAmountLC	BC Depreciation Amount
tiFADepreciationMonth	integer	FADepreciation.FADepreciationMonth	Depreciation Month
tiFADepreciationYear	integer	FADepreciation.FADepreciationYear	Depreciation Year
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(FADepreciation)

Internal usage

QadFinancials

method BFixedAssetDepreciation.GetCumulDBDeprAmountLC
method BFixedAssetDisposal.DisposalCalcDetAmounts