Parameters
| iiCompanyId | integer | Company id |
| iiFromBreakOffPeriod | integer | |
| iiToBreakOffPeriod | integer | |
| iiFAAssetID | integer | |
| icBookCode | character | |
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 name | data type | db field | description |
|---|
| tcFAAssetBookCode | character | FAAssetBook.FAAssetBookCode | Code |
| tcFABookCode | character | FABook.FABookCode | Code |
| tdFADepreciationAmountCC | decimal | FADepreciation.FADepreciationAmountCC | SC Depreciation Amount |
| tdFADepreciationAmountLC | decimal | FADepreciation.FADepreciationAmountLC | BC Depreciation Amount |
| tcFADepreciationDescription | character | FADepreciation.FADepreciationDescription | Depreciation Description |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiPeriodPeriod | integer | Period.PeriodPeriod | GL Period |
| tiPeriodYear | integer | Period.PeriodYear | GL Calendar Year |
| tiPeriodYearPeriod | integer | Period.PeriodYearPeriod | GL Calendar Year/GL Period |
| ttPostingDate | date | Posting.PostingDate | The 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). |
| tcPostingText | character | Posting.PostingText | Free text describing the posting. |
| api annotation: | | Value for this field defaults to blank |
| tiPostingVoucher | integer | Posting.PostingVoucher | Voucher 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_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(FAAsset),rowid(FAAssetBook),rowid(FABookType),rowid(FABook),rowid(FADepreciation),rowid(FADepreciationPosting),rowid(Posting),rowid(Journal),rowid(Period) |
Internal usage
QadFinancials