Parameters
| iiCompanyId | integer | Company id |
| iiPeriodYearPeriod | integer | |
| ilIsActive | logical | |
query condition
each Allocation where
Allocation.Company_Id = iiCompanyId AND
each AllocationBatchLine (inner-join) where
AllocationBatchLine.Allocation_ID = Allocation.Allocation_ID AND
first AllocationBatch (inner-join) where
AllocationBatch.Company_Id = iiCompanyId AND
AllocationBatch.AllocationBatch_ID = AllocationBatchLine.AllocationBatch_ID AND
AllocationBatch.AllocationBatchIsActive = ilIsActive
each AllocationPosting (inner-join) where
AllocationPosting.AllocationBatchLine_ID = AllocationBatchLine.AllocationBatchLine_ID AND
first Period (inner-join) where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = AllocationPosting.SourcePeriod_ID AND
Period.PeriodYearPeriod = iiPeriodYearPeriod
first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = AllocationPosting.Posting_ID AND
first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Allocation.Journal_ID AND
first PostingTemplate (inner-join) where
PostingTemplate.Company_Id = iiCompanyId AND
PostingTemplate.PostingTemplate_ID = Allocation.PostingTemplate_ID AND
query resultset tqPostedAllocation
| field name | data type | db field | description |
|---|
| tiAllocation_ID | integer | Allocation.Allocation_ID | Record ID |
| tcAllocationBatchCode | character | AllocationBatch.AllocationBatchCode | Allocation Batch Code |
| tcAllocationCode | character | Allocation.AllocationCode | Allocation Code |
| tcAllocationDenominAmountBy | character | Allocation.AllocationDenominAmountBy | Amt By |
| tcAllocationDenominAmountFr | character | Allocation.AllocationDenominAmountFr | From Amt |
| tcAllocationDescription | character | Allocation.AllocationDescription | Description |
| tcAllocationSourceAmountBy | character | Allocation.AllocationSourceAmountBy | Amt By |
| tdAllocationSourceAmountLC | decimal | Allocation.AllocationSourceAmountLC | BC Amount |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiPosting_ID | integer | AllocationPosting.Posting_ID | Link to Posting |
| tcPostingTemplateCode | character | PostingTemplate.PostingTemplateCode | Template Code |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Allocation),rowid(AllocationBatchLine),rowid(AllocationBatch),rowid(AllocationPosting),rowid(Period),rowid(Posting),rowid(Journal),rowid(PostingTemplate) |
Internal usage
QadFinancials