project QadFinancials > class BFixedAssetAssetType > business logic query FAAssetTypePrim

Description

Prim query for Fixed Asset Types

Parameters

iiCompanyId	integer	Company id
iiFAAssetTypeID	integer
icFAAssetTypeCode	character

query condition

each FAAssetType where

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

query resultset tqFAAssetTypePrim

field name	data type	db field	description
tiFAAssetType_ID	integer	FAAssetType.FAAssetType_ID	Record ID
tcFAAssetTypeCode	character	FAAssetType.FAAssetTypeCode	Code
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= 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