Create daily affiliate sale records for payout runs

Your affiliate transaction feed is unstructured and delays payout reconciliation. Capture and normalize transaction IDs and dates so finance posts reconciled payouts before the next payment run.