When tickets were purchased using the pre bought redeemable items, a layer of logic adds to the above: When a bundle/Redeemable items were purchased, a transaction is created. To recon this we will need redeemable items created minus the transaction; When a redeemable item is redeemed, there is no new transaction is created, but a ticket will be generated, to recon this the ticket minus the redeemable item redeemed, it will give us 0.
When tickets were purchased using the pre bought redeemable items, a layer of logic adds to the above: When a bundle/Redeemable items were purchased, a transaction is created. To recon this we will need redeemable items created minus the transaction; When a redeemable item is redeemed, there is no new transaction is created, but a ticket will be generated, to recon this the ticket minus the redeemable item redeemed, it will give us 0.