business logic query BudgetLinkAccDetByWBSPeriod

Parameters

iiPeriod_ID	integer
iiBudgetWBS_ID	integer
iiCostCentre_ID	integer
iiDivision_ID	integer
iiProject_ID	integer
iiSafConcept_ID	integer
iiSaf_ID	integer
iiBudget_ID	integer
iiCompanyId	integer	Company id
iiPeriodYearPeriodFrom	integer
iiPeriodYearPeriodTill	integer
icLayer_ID_List	character

query condition

each BudgetLinkAccDet where

BudgetLinkAccDet.Budget_ID = iiBudget_ID AND
BudgetLinkAccDet.BudgetWBS_ID = iiBudgetWBS_ID AND
BudgetLinkAccDet.CostCentre_ID = iiCostCentre_ID AND
BudgetLinkAccDet.Division_ID = iiDivision_ID AND
BudgetLinkAccDet.Period_ID = iiPeriod_ID AND
BudgetLinkAccDet.Project_ID = iiProject_ID AND
BudgetLinkAccDet.Saf_ID = iiSaf_ID AND
BudgetLinkAccDet.SafConcept_ID = iiSafConcept_ID AND
string(BudgetLinkAccDet.Layer_ID) can-do icLayer_ID_List

first BudgetWBS (inner-join) where

BudgetWBS.BudgetWBS_ID = BudgetLinkAccDet.BudgetWBS_ID AND

first BudgetFDS (inner-join) where

BudgetFDS.BudgetFDS_ID = BudgetWBS.BudgetFDS_ID AND

first Period (inner-join) where

Period.Company_Id = iiCompanyId AND
Period.Period_ID = BudgetLinkAccDet.Period_ID AND
Period.PeriodYearPeriod >= iiPeriodYearPeriodFrom AND
Period.PeriodYearPeriod <= iiPeriodYearPeriodTill

query resultset tqBudgetLinkAccDetByWBSPeriod

field name	data type	db field	description
tiBudget_ID	integer	BudgetLinkAccDet.Budget_ID	Link to Budget
tcBudgetFDSType	character	BudgetFDS.BudgetFDSType	COA Element
tiBudgetLinkAccDet_ID	integer	BudgetLinkAccDet.BudgetLinkAccDet_ID	Record ID
tdBudgetLinkAccDetCreditLC	decimal	BudgetLinkAccDet.BudgetLinkAccDetCreditLC	BC Credit
tdBudgetLinkAccDetDebitLC	decimal	BudgetLinkAccDet.BudgetLinkAccDetDebitLC	BC Debit
tdBudgetLinkAccDetQTY	decimal	BudgetLinkAccDet.BudgetLinkAccDetQTY	Qty
tiBudgetWBS_ID	integer	BudgetLinkAccDet.BudgetWBS_ID	Link to BudgetWBS
tiCostCentre_ID	integer	BudgetLinkAccDet.CostCentre_ID	Link to CostCentre
tiDivision_ID	integer	BudgetLinkAccDet.Division_ID	Link to Division
tiLayer_ID	integer	BudgetLinkAccDet.Layer_ID	Link to Layer
tiPeriod_ID	integer	BudgetLinkAccDet.Period_ID	Link to Period
tiPeriodYearPeriod	integer	Period.PeriodYearPeriod	GL Calendar Year/GL Period
tiProject_ID	integer	BudgetLinkAccDet.Project_ID	Link to Project
tiSaf_ID	integer	BudgetLinkAccDet.Saf_ID	Link to Saf
tiSafConcept_ID	integer	BudgetLinkAccDet.SafConcept_ID	Link to SafConcept
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BudgetLinkAccDet),rowid(BudgetWBS),rowid(BudgetFDS),rowid(Period)

Internal usage

QadFinancials

method BAllocationBatch.GetProposedAllocationsProportional
method BBudgetLinkAccDet.ApiCreateOrUpdateBudgetLinkAccDet