business logic query FABookTypeByIDCodeActOff

Description

Query to select on Active and Official flags, as well as ID and Code.

Parameters

iiCompanyId	integer	Company id
iiFABookTypeID	integer
icFABookTypeCode	character
ilFABookTypeIsActive	logical
ilFABookTypeIsOfficial	logical

query condition

each FABookType where

FABookType.Company_Id = iiCompanyId AND
FABookType.FABookType_ID = iiFABookTypeID AND
FABookType.FABookTypeCode = icFABookTypeCode AND
FABookType.FABookTypeIsActive = ilFABookTypeIsActive AND
FABookType.FABookTypeIsOfficial = ilFABookTypeIsOfficial

query resultset tqFABookTypeByIDCodeActOff

field name	data type	db field	description
tiCompany_ID	integer	FABookType.Company_ID	Link to Company
tiDepreciationJournal_ID	integer	FABookType.DepreciationJournal_ID	Depreciation Daybook Code
tiDisposalJournal_ID	integer	FABookType.DisposalJournal_ID	Disposal Daybook Code
tiFABookType_ID	integer	FABookType.FABookType_ID	Record ID
tcFABookTypeCode	character	FABookType.FABookTypeCode	Code
tlFABookTypeIsActive	logical	FABookType.FABookTypeIsActive	Active
tlFABookTypeIsOfficial	logical	FABookType.FABookTypeIsOfficial	Official
tiRevaluationJournal_ID	integer	FABookType.RevaluationJournal_ID	Revaluation Daybook Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(FABookType)

Internal usage

QadFinancials

method BFixedAssetAsset.ValidateComponentAssetBook
method BFixedAssetBookType.ValidateComponent
method BFixedAssetDepreciation.DepreciationApply
method BFixedAssetDisposal.AdditionalUpdatesPosting