Bonus boxes: check against this week's deliveries
Anyone already getting a delivery this week shouldn't also get a bonus box. Give us both files and we'll take the overlap out of the bonus list — and tell you who we took out and why.
This week's shipment file
The consolidated weekly file that comes over SFTP, one tab per partner. We only read it — nothing in it changes.
checked against
The bonus box report
The file we clean. Rows come out of this one.