project QadFinancials > class BBudgetLinkActual > business logic query BudgetLinkActualByBudgetIdDate

Parameters


iiCompanyIdintegerCompany id
iiBudgetIdinteger
itBudgetLinkActualDatedate

query condition


  each BudgetLinkActual where
BudgetLinkActual.Company_Id = iiCompanyId AND
BudgetLinkActual.Budget_ID = iiBudgetId AND
BudgetLinkActual.BudgetLinkActualDate <= itBudgetLinkActualDate

query resultset tqBudgetLinkActualByBudgetIdDate


field namedata typedb fielddescription
tiBudget_IDintegerBudgetLinkActual.Budget_IDBudget
ttBudgetLinkActualDatedateBudgetLinkActual.BudgetLinkActualDatePosting Date
tdBudgetLinkActualSalesTCdecimalBudgetLinkActual.BudgetLinkActualSalesTCSales Amount
tdBudgetLinkActualTCdecimalBudgetLinkActual.BudgetLinkActualTCAmount
tiBudgetWBS_IDintegerBudgetLinkActual.BudgetWBS_IDBudget WBS

Internal usage


QadFinancials
method BBudget.CalculateBudgetWBS