Hi Malik, thank you for the reply.
Just so I understand the reply clearly in the case of single device/certificate.
The sample data can be treated as master table of document validation with an AutoIndex / ICV. Here, the Accounting Reference are being mix due to the document validation sequence; meaning a user can validate Invoice, followed by Credit Note, another Invoice, another Invoice and so on.
ICV, Device Id, Accounting Reference
1, 1,24/INV01
2,1, 24/CNV01
3, 1,24/INV02
4, 1,24/DNV01
5, 1,24/INV03
6, 1,24/INV04
7, 1,24/CN02
Appreciate your inputs.