✏️ Explanatory Question

If VendTable stores OnHold, why does VendOnHoldHistory exist?

👁 6 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

VendOnHoldHistory exists to store historical audit records of:

  • When vendor was put on hold

  • When it was removed

  • Who did it

  • What reason was given

VendTable stores only the current OnHold value.
VendOnHoldHistory stores complete history.