project QadFinancials > class BFixedAssetAssetType > business logic query FAAssetTypeByIDCodeActive


Parameters


iiCompanyIdintegerCompany id
icFAAssetTypeCodecharacterCode
iiFAAssetTypeIDinteger
ilFAAssetTypeIsActivelogical


query condition


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

      first GL1 (inner-join) where
GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = FAAssetType.CumulativeDeprGL_ID AND

      first GL2 (inner-join) where
GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = FAAssetType.CostDeprGL_ID AND

      first GL3 (conditional-join) where
GL3.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL3.GL_ID = FAAssetType.RevaluationGL_ID AND

      first GL4 (conditional-join) where
GL4.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL4.GL_ID = FAAssetType.RevaluationDeprGL_ID AND


query resultset tqFAAssetTypeByIDCodeActive


field namedata typedb fielddescription
tiCompany_IDintegerFAAssetType.Company_IDLink to Company
tiCostDeprGL_IDintegerFAAssetType.CostDeprGL_IDCost Depreciation GL Account
tcCostDeprGLCodecharacterGL2.GLCodeA code identifying the GL account.
tiCumulativeDeprGL_IDintegerFAAssetType.CumulativeDeprGL_IDCumulative Depreciation GL Account
tcCumulativeDeprGLCodecharacterGL1.GLCodeA code identifying the GL account.
tiFAAssetType_IDintegerFAAssetType.FAAssetType_IDRecord ID
tcFAAssetTypeCatalogueCode2characterFAAssetType.FAAssetTypeCatalogueCode2Catalog Code 2
tcFAAssetTypeCatalogueCode3characterFAAssetType.FAAssetTypeCatalogueCode3Catalog Code 3
tcFAAssetTypeCatalogueCode4characterFAAssetType.FAAssetTypeCatalogueCode4Catalog Code 4
tcFAAssetTypeCatalogueCode5characterFAAssetType.FAAssetTypeCatalogueCode5Catalog Code 5
tcFAAssetTypeCatalogueCode6characterFAAssetType.FAAssetTypeCatalogueCode6Catalog Code 6
tcFAAssetTypeCatalogueDescr2characterFAAssetType.FAAssetTypeCatalogueDescr2Catalog Description 2
tcFAAssetTypeCatalogueDescr3characterFAAssetType.FAAssetTypeCatalogueDescr3Catalog Description 3
tcFAAssetTypeCatalogueDescr4characterFAAssetType.FAAssetTypeCatalogueDescr4Catalog Description 4
tcFAAssetTypeCatalogueDescr5characterFAAssetType.FAAssetTypeCatalogueDescr5Catalog Description 5
tcFAAssetTypeCatalogueDescr6characterFAAssetType.FAAssetTypeCatalogueDescr6Catalog Description 6
tcFAAssetTypeCodecharacterFAAssetType.FAAssetTypeCodeCode
tcFAAssetTypeDescriptioncharacterFAAssetType.FAAssetTypeDescriptionDescription
tlFAAssetTypeIsActivelogicalFAAssetType.FAAssetTypeIsActiveActive
tiRevaluationDeprGL_IDintegerFAAssetType.RevaluationDeprGL_IDRevaluation Depreciation GL Account
tcRevaluationDeprGLCodecharacterGL4.GLCodeA code identifying the GL account.
tiRevaluationGL_IDintegerFAAssetType.RevaluationGL_IDRevaluation GL Account
tcRevaluationGLCodecharacterGL3.GLCodeA code identifying the GL account.
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(FAAssetType),rowid(GL1),rowid(GL2),rowid(GL3),rowid(GL4)


Internal usage


QadFinancials
method BFixedAssetAsset.ApiStdMaintainTTDetail
method BFixedAssetAsset.Calculate
method BFixedAssetAsset.DefaultValuesAssetType
method BFixedAssetAsset.ValidateComponentAsset
method BFixedAssetDepreciation.DepreciationApply