business logic query BudgetLinkActualByReportPeriod

Description

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

Parameters

iiCompanyId	integer	Company id
ilBudgetLinkActualIsAfterRep	logical	BudgetLinkActualIsAfterRep
iiReportPeriodID	integer	ReportPeriodID; in case you want to test on zero then you should pass value -9999999
iiPostingLineID	integer	PostingLineId

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 name	data type	db field	description
tcBudgetLinkActualInfo	character	BudgetLinkActual.BudgetLinkActualInfo	Info
tlBudgetLinkActualIsAfterRep	logical	BudgetLinkActual.BudgetLinkActualIsAfterRep	After Reporting
tiBudgetLinkActual_ID	integer	BudgetLinkActual.BudgetLinkActual_ID	Record ID
tiBudget_ID	integer	BudgetLinkActual.Budget_ID	Budget
tiCompany_ID	integer	BudgetLinkActual.Company_ID	Link to Company
tiPostingLine_ID	integer	BudgetLinkActual.PostingLine_ID	Link to PostingLine
tiReportPeriod_ID	integer	BudgetLinkActual.ReportPeriod_ID	Link to ReportPeriod

Internal usage

QadFinancials

method BBudgetLinkActual.ApiCreateBudgetLinkActual