business logic query BaseAllocation

Parameters

iiCompanyId	integer	Company id
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

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 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
tcAllocationSourceAmountFrom	character	Allocation.AllocationSourceAmountFrom	From Amt
tdAllocationSourceAmountLC	decimal	Allocation.AllocationSourceAmountLC	BC Amount
tcAllocationSourceLcQty	character	Allocation.AllocationSourceLcQty	Value Of
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tcPostingTemplateCode	character	PostingTemplate.PostingTemplateCode	Template Code
tiSourceBudgetWBS_ID	integer	Allocation.SourceBudgetWBS_ID	WBS Seq
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Allocation),rowid(AllocationBatchLine),rowid(AllocationBatch),rowid(Journal),rowid(PostingTemplate)

Internal usage

QadFinancials

method BClosingPostingsReport.AllocationCheckDet