...
Approval Status, Approval User and Approval Date always refers to the “last approval”.
Approval Status can be blank (if invoice has not been approved yet by anyone) - or a numeric value (“1”, “2”, “3” etc.) - which refers to the number of approvals on the invoice) or “A” for the fully approved invoices (when we reach the required number of approvals for the invoice).
Approval Status 2, Approval User 2 and Approval Date 2 would be the “first approval”.
Approval Status 3, Approval User 3 and Approval Date 3 would be “second approval”.
We do not keep track of approvals beyond third - and any subsequent approval after third will just update Approval Status, Approval User and Approval Date as the “last approval”.
...