project QadFinancials > class BFixedAssetAssetType > business logic query FAAssetTypePrim

Description

Prim query for Fixed Asset Types


Parameters


iiCompanyIdintegerCompany id
iiFAAssetTypeIDinteger
icFAAssetTypeCodecharacter


query condition


  each FAAssetType where
FAAssetType.Company_Id = iiCompanyId AND
FAAssetType.FAAssetType_ID = iiFAAssetTypeID AND
FAAssetType.FAAssetTypeCode = icFAAssetTypeCode


query resultset tqFAAssetTypePrim


field namedata typedb fielddescription
tiFAAssetType_IDintegerFAAssetType.FAAssetType_IDRecord ID
tcFAAssetTypeCodecharacterFAAssetType.FAAssetTypeCodeCode
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(FAAssetType)


Internal usage


QadFinancials
method BCompany.ValidateComponentSSChange
method BDomain.ValidateComponentSharedSetChange
method BFixedAssetAsset.GetExistingCatalogueValues
method BFixedAssetDisposal.DisposalProposals
method BFixedAssetRevaluation.RevaluationCreateVal
read related business field(s) on tFAAsset.FAAssetType_ID
read related business field(s) on tFAAssetTypeFABook.FAAssetType_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tFAAsset.FAAssetType_ID
validate related business field(s) on tFAAssetTypeFABook.FAAssetType_ID