project QadFinancials > class BBudgetLinkActual > business logic query BudgetLinkActualByReportPeriod

Description

BudgetLinkActualByReportPeriod; query that allows filtering on the BudgetReportPeriod (also test on zero) and on BudgetLinkActualIsAfterRep


Parameters


iiCompanyIdintegerCompany id
ilBudgetLinkActualIsAfterReplogicalBudgetLinkActualIsAfterRep
iiReportPeriodIDintegerReportPeriodID; in case you want to test on zero then you should pass value -9999999
iiPostingLineIDintegerPostingLineId


query condition


  each BudgetLinkActual where
BudgetLinkActual.Company_Id = iiCompanyId AND
BudgetLinkActual.ReportPeriod_ID = (if iiReportPeriodID = -9999999 then 0 else iiReportPeriodID) AND
BudgetLinkActual.BudgetLinkActualIsAfterRep = ilBudgetLinkActualIsAfterRep AND
BudgetLinkActual.PostingLine_ID = iiPostingLineID


query resultset tqBudgetLinkActualByReportPeriod


field namedata typedb fielddescription
tcBudgetLinkActualInfocharacterBudgetLinkActual.BudgetLinkActualInfoInfo
tlBudgetLinkActualIsAfterReplogicalBudgetLinkActual.BudgetLinkActualIsAfterRepAfter Reporting
tiBudgetLinkActual_IDintegerBudgetLinkActual.BudgetLinkActual_IDRecord ID
tiBudget_IDintegerBudgetLinkActual.Budget_IDBudget
tiCompany_IDintegerBudgetLinkActual.Company_IDLink to Company
tiPostingLine_IDintegerBudgetLinkActual.PostingLine_IDLink to PostingLine
tiReportPeriod_IDintegerBudgetLinkActual.ReportPeriod_IDLink to ReportPeriod


Internal usage


QadFinancials
method BBudgetLinkActual.ApiCreateBudgetLinkActual