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