عرض عملي: مطابقة الطلبات مع مزوّد الدفع

خطوة بخطوة

1. Load the day's orders, payments, and the provider's settlement file into a staging area.
2. Join by provider reference and bucket: matched, orders without charge, charges without order, amount mismatch.
3. Inspect the planted discrepancies and decide an automatic repair for each type.
4. Planned mistake: compare totals only. Fix: compare per record, since offsetting errors hide in totals.
5. Apply repairs and write an audit row for each; re-run to show it is idempotent.
6. Produce the report with counts and open items.

اختبر فهمك