item missing on item_t after exclude from bal_impacts entries with 0 amount
Good Morning,
I would like to understand how can i deal with the following scenario:
In order to reduce the amount of transactions on event_bal_impacts_t and increase the performance of searching on table we are excluding all entries with amount 0 from event_bal_impacts_t table, with following configuration:
if ( ( trxAmountbp == 0.000000 ) and ( edrLong(DETAIL.ASS_PIN.BP.PIN_IMPACT_TYPE, i, j ) != 4) )
{
logPipeline("OutGrammar : amount zero postponed! "+decimalToStr(trxAmountbp) ,0);
}
else
{
edrOutputMap( "V670_EVENT_LOADER.BALANCE_PACKET.STD_MAPPING", i, j );
}
But with that configuration we realize that event_t for certain (usage)transactions use the item_poid excluded from bal_impacts and item_t does not have the entry that was excluded as well.