Hello, is there any data verification in the columns?
We have a program that processes/parses invoices and inserts some data from them into a table. Such as amount /vendor etc .
But sometimes, because of changes, the process breaks down. And the data is parsed incorrectly. And as a result, it is written to the database incorrectly.
My idea is to automate the check, and for example, process some invoices and compare these data. Just for example, if the table contains a row with certain data (which I will first write down from the invoice), then compare it. If everything is fine, the data matched, then the test is successful; if not, then it is not successful.
Maybe there is some kind of guide that is approximately similar to my task?