project QadFinancials > class BBudgetLinkCommitment > business logic query BudgetLinkCommitByBudgetIdDate

Parameters


iiCompanyIdintegerCompany id
iiBudgetIdinteger
itBudgetLinkCommitDatedate

query condition


  each BudgetLinkCommit where
BudgetLinkCommit.Company_Id = iiCompanyId AND
BudgetLinkCommit.Budget_ID = iiBudgetId AND
BudgetLinkCommit.BudgetLinkCommitDate <= itBudgetLinkCommitDate

query resultset tqBudgetLinkCommitByBudgetIdDate


field namedata typedb fielddescription
tiBudget_IDintegerBudgetLinkCommit.Budget_IDBudget
ttBudgetLinkCommitDatedateBudgetLinkCommit.BudgetLinkCommitDateCommitment Date
tdBudgetLinkCommitTCdecimalBudgetLinkCommit.BudgetLinkCommitTCTC Amount
tiBudgetWBS_IDintegerBudgetLinkCommit.BudgetWBS_IDBudgetWBS

Internal usage


QadFinancials
method BBudget.CalculateBudgetWBS