query
RESULTSET
query
  ADJAMOUNT ADJID ADJIMPACTDATE ADJNAME ADJREASON ADJTIMEFRAME ADJTYPE ADJUOM BGTCATEGORYID LINKID LINKTYPE OWNERID OWNERTYPE PRINCIPALID PRINCIPALTERRITORYID
CACHED false
EXECUTIONTIME 29
SQL select ownerId, ownerType, adjName, adjReason, adjType, adjAmount, adjImpactDate, adjUOM, adjTimeframe, principalId, principalTerritoryId, adjId, linkId, linkType, bgtCategoryId from tbl_BRO_PrincipalBudgetAdjustments pba where ownerId = ? and ownerType = ? and principalId = ? and principalTerritoryId in ( ? ) and bgtCategoryId in ( ? ) and adjImpactDate between ? and ?
SQLPARAMETERS
array
1 14
2 BRO
3 9234
4 5266
5 16764
6 2015-05-31
7 2016-05-28
lastActualsDate {ts '2015-11-22 00:00:00'} true
struct
CALCULATEALTIMPACT false
DATASOURCE fslibrary_rpc
DEBUG true
LASTACTUALSDATE {ts '2015-11-22 00:00:00'}
OWNERID 14
OWNERTYPE BRO
PLANENDDATE [empty string]
PLANSTARTDATE [empty string]
QUERY qmd_adjustments
ZEROPASTDUEIMPACT false
_overridePanDates NO
query
RESULTSET
query
  ADJAMOUNT ADJID ADJIMPACTDATE ADJNAME ADJREASON ADJTIMEFRAME ADJTYPE ADJUOM BGTCATEGORYID LINKID LINKTYPE OWNERID OWNERTYPE PRINCIPALID PRINCIPALTERRITORYID availableDate caseAmt caseImpact durationUnit impactDays impactRate incomeAmt mfrId planEndDate planStartDate quantityAmt residual stateCode statusCode totalDays typeCode valueImpact volumeImpact weeksRemaining weightAmt weightImpact
CACHED false
EXECUTIONTIME 29
SQL select ownerId, ownerType, adjName, adjReason, adjType, adjAmount, adjImpactDate, adjUOM, adjTimeframe, principalId, principalTerritoryId, adjId, linkId, linkType, bgtCategoryId from tbl_BRO_PrincipalBudgetAdjustments pba where ownerId = ? and ownerType = ? and principalId = ? and principalTerritoryId in ( ? ) and bgtCategoryId in ( ? ) and adjImpactDate between ? and ?
SQLPARAMETERS
array
1 14
2 BRO
3 9234
4 5266
5 16764
6 2015-05-31
7 2016-05-28