project QadFinancials > class BBudgetLinkAcc > business logic query BudgetLinkAccByPeriodWBS

Description

BudgetLinkAccByPeriodWBS; query that returns information about the AccPeriod for a budget.


Parameters


iiBudget_IDinteger
iiPeriod_IDinteger
iiBudgetWBS_IDinteger
iiLayer_IDintegerID of layer for which values are calculated


query condition


  each BudgetLinkAcc where
BudgetLinkAcc.Budget_ID = iiBudget_ID AND
BudgetLinkAcc.BudgetWBS_ID = iiBudgetWBS_ID AND
BudgetLinkAcc.Period_ID = iiPeriod_ID AND
BudgetLinkAcc.Layer_ID = iiLayer_ID


query resultset tqBudgetLinkAccByPeriodWBS


field namedata typedb fielddescription
tiBudget_IDintegerBudgetLinkAcc.Budget_IDLink to Budget
tiBudgetLinkAcc_IDintegerBudgetLinkAcc.BudgetLinkAcc_IDRecord ID
tdBudgetLinkAccCreditLCdecimalBudgetLinkAcc.BudgetLinkAccCreditLCBC Credit
tdBudgetLinkAccDebitLCdecimalBudgetLinkAcc.BudgetLinkAccDebitLCBC Debit
tdBudgetLinkAccQTYdecimalBudgetLinkAcc.BudgetLinkAccQTYQty
tiBudgetWBS_IDintegerBudgetLinkAcc.BudgetWBS_IDLink to BudgetWBS
tiLayer_IDintegerBudgetLinkAcc.Layer_IDLink to Layer
tiPeriod_IDintegerBudgetLinkAcc.Period_IDLink to Period
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BudgetLinkAcc)


Internal usage


QadFinancials
method BBudgetLinkAcc.ApiCreateOrUpdateBudgetLinkAcc