project QadFinancials > class BFixedAssetDepreciation > business logic query FADepreciationByPostingID


Parameters


iiPostingIDinteger
iiCompanyIdintegerCompany id


query condition


  each FADepreciationPosting where
FADepreciationPosting.FADepreciationPosting_ID = iiPostingID

      first FADepreciation (inner-join) where
FADepreciation.Company_Id = iiCompanyId AND
FADepreciation.FADepreciation_ID = FADepreciationPosting.FADepreciation_ID AND

          first FAAssetBook (inner-join) where
FAAssetBook.FAAssetBook_ID = FADepreciation.FAAssetBook_ID AND

              first FAAsset (inner-join) where
FAAsset.Company_Id = iiCompanyId AND
FAAsset.FAAsset_ID = FAAssetBook.FAAsset_ID AND

                  first FAAssetType (inner-join) where
FAAssetType.Company_Id = iiCompanyId AND
FAAssetType.FAAssetType_ID = FAAsset.FAAssetType_ID AND


query resultset tqFADepreciationByPostingID


field namedata typedb fielddescription
tiFAAsset_IDintegerFAAsset.FAAsset_IDRecord ID
tcFAAssetBookDeprTypecharacterFAAssetBook.FAAssetBookDeprTypeDepreciation Type
tcFAAssetCatalogueValue2characterFAAsset.FAAssetCatalogueValue2Catalog Value 2
tcFAAssetCatalogueValue3characterFAAsset.FAAssetCatalogueValue3Catalog Value 3
tcFAAssetCatalogueValue4characterFAAsset.FAAssetCatalogueValue4Catalog Value 4
tcFAAssetCatalogueValue5characterFAAsset.FAAssetCatalogueValue5Catalog Value 5
tcFAAssetCatalogueValue6characterFAAsset.FAAssetCatalogueValue6Catalog Value 6
tcFAAssetCodecharacterFAAsset.FAAssetCodeCode
tcFAAssetDescriptioncharacterFAAsset.FAAssetDescriptionDescription
tcFAAssetTypeCodecharacterFAAssetType.FAAssetTypeCodeCode
tiFADepreciationPosting_IDintegerFADepreciationPosting.FADepreciationPosting_IDRecord ID


Internal usage


QadFinancials
method BJournalEntry.DumpJEForConsolid