R76VIR01B - Withholding Integrity - Erases Historical and R76VIR02C - Withholding Integrity - Create Historical

You run the Withholding Integrity - Create Historical (R76VIR02C) and the Withholding Integrity - Erases Historical (R76VIR01B) programs to maintain data consistency between the F0411 table and the Withholding Historical File - VEN (F76V4581) table.

When you run Withholding Integrity - Erase Historical program, the system deletes records from the F76V4581 table when no record exists in the F0411 table for a transaction which includes:

  • A document type of PV (paid voucher).

  • A document type of PW (paid national withholding).

The Withholding Integrity- Erase Historical program produces a report that lists the records deleted from the F76V4581 table.

You run the Withholding Integrity - Create Historical program to update table F76V4581 with data about the municipal taxes withheld.