Add transaction IDs to deal lookup for analytics before reporting

Your deal history rows often miss transaction IDs, causing reconciliation gaps and wrong analytics. Fill the lookup table so analytics and finance have complete records before the next reporting cycle.