Parameters
| iiCompanyId | integer | Company id |
| iiFAAssetID | integer | |
| icBookType | character | |
| iiPeriodFrom | integer | |
| iiPeriodTo | integer | |
query condition
each FAAsset where
FAAsset.Company_Id = iiCompanyId AND
FAAsset.FAAsset_ID = iiFAAssetID
each FAAssetBook (conditional-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 = icBookType
each FADisposal (conditional-join) where
FADisposal.FAAssetBook_ID = FAAssetBook.FAAssetBook_ID AND
first Posting (conditional-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = FADisposal.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 (conditional-join) where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND
Period.PeriodYearPeriod >= iiPeriodFrom AND
Period.PeriodYearPeriod <= iiPeriodTo
query resultset tqDisposalTrans
| field name | data type | db field | description |
|---|
| tcFAAssetBookCode | character | FAAssetBook.FAAssetBookCode | Code |
| tcFABookCode | character | FABook.FABookCode | Code |
| tdFADisposalAmountCC | decimal | FADisposal.FADisposalAmountCC | SC Disposal Amount |
| tdFADisposalAmountLC | decimal | FADisposal.FADisposalAmountLC | BC Disposal Amount |
| 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(FADisposal),rowid(Posting),rowid(Journal),rowid(Period) |
Internal usage
QadFinancials