project QadFinancials > class BFixedAssetReport > business logic query DepriciationTrans


Parameters


iiCompanyIdintegerCompany id
iiFromBreakOffPeriodinteger
iiToBreakOffPeriodinteger
iiFAAssetIDinteger
icBookCodecharacter


query condition


  each FAAsset where
FAAsset.Company_Id = iiCompanyId AND
FAAsset.FAAsset_ID = iiFAAssetID

      each FAAssetBook (inner-join) where
FAAssetBook.FAAsset_ID = FAAsset.FAAsset_ID AND

          first FABookType (conditional-join) where
FABookType.Company_Id = iiCompanyId AND
FABookType.FABookType_ID = FAAssetBook.FABookType_ID AND

              each FABook (conditional-join) where
FABook.Company_Id = iiCompanyId AND
FABook.FABookType_ID = FABookType.FABookType_ID AND
FABook.FABookCode = icBookCode

          each FADepreciation (inner-join) where
FADepreciation.Company_Id = iiCompanyId AND
FADepreciation.FAAssetBook_ID = FAAssetBook.FAAssetBook_ID AND

              each FADepreciationPosting (inner-join) where
FADepreciationPosting.FADepreciation_ID = FADepreciation.FADepreciation_ID AND

                  first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = FADepreciationPosting.Posting_ID AND

                      first Journal (conditional-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

                      first Period (inner-join) where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND
Period.PeriodYearPeriod >= iiFromBreakOffPeriod AND
Period.PeriodYearPeriod <= iiToBreakOffPeriod


query resultset tqDepriciationTrans


field namedata typedb fielddescription
tcFAAssetBookCodecharacterFAAssetBook.FAAssetBookCodeCode
tcFABookCodecharacterFABook.FABookCodeCode
tdFADepreciationAmountCCdecimalFADepreciation.FADepreciationAmountCCSC Depreciation Amount
tdFADepreciationAmountLCdecimalFADepreciation.FADepreciationAmountLCBC Depreciation Amount
tcFADepreciationDescriptioncharacterFADepreciation.FADepreciationDescriptionDepreciation Description
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
tiPeriodYearPeriodintegerPeriod.PeriodYearPeriodGL Calendar Year/GL Period
ttPostingDatedatePosting.PostingDateThe accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
tcPostingTextcharacterPosting.PostingTextFree text describing the posting.
api annotation:Value for this field defaults to blank
tiPostingVoucherintegerPosting.PostingVoucherVoucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
api annotation:In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(FAAsset),rowid(FAAssetBook),rowid(FABookType),rowid(FABook),rowid(FADepreciation),rowid(FADepreciationPosting),rowid(Posting),rowid(Journal),rowid(Period)


Internal usage


QadFinancials
method BFixedAssetReport.MovementsByAssetCode
method BFixedAssetReport.MutationsByGL
method BFixedAssetReport.TransactionsByAssetCode