project QadFinancials > class BClosingPostingsReport > business logic query BaseAllocation


Parameters


iiCompanyIdintegerCompany id
ilIsActivelogical


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

      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 tqBaseAllocation


field namedata typedb fielddescription
tiAllocation_IDintegerAllocation.Allocation_IDRecord ID
tcAllocationBatchCodecharacterAllocationBatch.AllocationBatchCodeAllocation Batch Code
tcAllocationCodecharacterAllocation.AllocationCodeAllocation Code
tcAllocationDenominAmountBycharacterAllocation.AllocationDenominAmountByAmt By
tcAllocationDenominAmountFrcharacterAllocation.AllocationDenominAmountFrFrom Amt
tcAllocationDescriptioncharacterAllocation.AllocationDescriptionDescription
tcAllocationSourceAmountBycharacterAllocation.AllocationSourceAmountByAmt By
tcAllocationSourceAmountFromcharacterAllocation.AllocationSourceAmountFromFrom Amt
tdAllocationSourceAmountLCdecimalAllocation.AllocationSourceAmountLCBC Amount
tcAllocationSourceLcQtycharacterAllocation.AllocationSourceLcQtyValue Of
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tcPostingTemplateCodecharacterPostingTemplate.PostingTemplateCodeTemplate Code
tiSourceBudgetWBS_IDintegerAllocation.SourceBudgetWBS_IDWBS Seq
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Allocation),rowid(AllocationBatchLine),rowid(AllocationBatch),rowid(Journal),rowid(PostingTemplate)


Internal usage


QadFinancials
method BClosingPostingsReport.AllocationCheckDet