project QadFinancials > class BFixedAssetRevaluation > business logic query FARevalPostingByPostingID


Parameters


iiPostingIDinteger
iiCompanyIdintegerCompany id


query condition


  each FARevalPosting where
FARevalPosting.Posting_ID = iiPostingID

      first FAReval (inner-join) where
FAReval.FAReval_ID = FARevalPosting.FAReval_ID AND

          first FAAssetBook (inner-join) where
FAAssetBook.FAAssetBook_ID = FAReval.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 tqFARevalPostingByPostingID


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
tiFARevalPosting_IDintegerFARevalPosting.FARevalPosting_IDRecord ID


Internal usage


QadFinancials
method BJournalEntry.DumpJEForConsolid