Thanks for the suggestion but I am referring to checking user input. I want to know even if the transactions via the CSV file were to be duplicated for any reason, it does not result in an accounting problem.
Consider this possible scenario:
Amount “10.00” Particulars “ACME WIDGETS” Code “BNZ BILLPAY” Reference: “ACC12345”
Amount “10.00” Particulars “ACME WIDGETS” Code “BNZ BILLPAY” Reference “ACC12345”
What happened? Did the customer make a double payment on the same day (or import period) or was there a period overlap in the current and last CSV imports or did the CSV file get imported twice? How is the system to know?
If I have available a unique transaction identifier field, I can store this and use it to triage the payment records prior to loading them into the database payments table.