// Multi-Currency Invoices with VAT Line Calculations (multi-currency-invoices-with-vat-line-calculations) v1 — Prisma seed // Synthetic sample data, CC0-1.0. Generated deterministically; re-running the // generator with the same spec and seed reproduces this file exactly. // // Delegates are named after the tables (prisma.customers), which assumes models // mapped to those table names. Rename the delegates if your models differ. import { PrismaClient } from '@prisma/client'; const prisma = new PrismaClient(); async function main() { await prisma.customers.createMany({ data: [ { id: 1, name: "Herman and Sons", billing_currency: "USD", tax_treatment: "reverse_charge", vat_number: "VAT2725231809", created_at: new Date("2023-01-13T12:11:33Z") }, { id: 2, name: "Hettinger, Renner and Grant", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT5329688138", created_at: new Date("2022-10-07T11:37:25Z") }, { id: 3, name: "Jacobs - Bartoletti", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT3572461622", created_at: new Date("2022-12-05T17:32:39Z") }, { id: 4, name: "Jones, Greenfelder and Kulas", billing_currency: "GBP", tax_treatment: "reverse_charge", vat_number: "VAT6253282651", created_at: new Date("2023-12-17T13:41:15Z") }, { id: 5, name: "Waters LLC", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT9126633791", created_at: new Date("2023-05-19T15:43:47Z") }, { id: 6, name: "Fisher, Gutmann and Koepp", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT2940761405", created_at: new Date("2022-04-27T23:05:38Z") }, { id: 7, name: "Huels and Sons", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT5514851745", created_at: new Date("2022-11-13T13:43:10Z") }, { id: 8, name: "Harber Group", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT5251496220", created_at: new Date("2023-07-12T18:28:30Z") }, { id: 9, name: "Marvin - Yundt", billing_currency: "GBP", tax_treatment: "reverse_charge", vat_number: "VAT8874840655", created_at: new Date("2023-05-04T11:16:14Z") }, { id: 10, name: "Hills, Sauer and Keebler", billing_currency: "EUR", tax_treatment: "reverse_charge", vat_number: "VAT2711051385", created_at: new Date("2023-03-19T08:02:47Z") }, { id: 11, name: "Moen Group", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT2107533319", created_at: new Date("2022-03-03T10:13:52Z") }, { id: 12, name: "Ortiz, West and Quigley", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT5176013541", created_at: new Date("2022-05-03T19:22:37Z") }, { id: 13, name: "Becker, Donnelly and Quitzon", billing_currency: "CAD", tax_treatment: "domestic", vat_number: "VAT1669360407", created_at: new Date("2022-08-26T15:52:04Z") }, { id: 14, name: "Kshlerin, Kuvalis and Greenfelder", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT6409442502", created_at: new Date("2023-06-08T08:26:35Z") }, { id: 15, name: "Watsica - Klein", billing_currency: "USD", tax_treatment: "reverse_charge", vat_number: "VAT5726546979", created_at: new Date("2022-08-05T16:18:33Z") }, { id: 16, name: "Kunde - Nikolaus", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT5020592192", created_at: new Date("2022-06-09T19:52:30Z") }, { id: 17, name: "Mayert - Yost", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT8600519930", created_at: new Date("2024-02-23T15:21:26Z") }, { id: 18, name: "Marks, Botsford and Hackett", billing_currency: "USD", tax_treatment: "reverse_charge", vat_number: "VAT8148139809", created_at: new Date("2023-09-04T13:27:34Z") }, { id: 19, name: "Purdy - Roberts", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT1528506785", created_at: new Date("2023-07-16T11:07:11Z") }, { id: 20, name: "Gleichner LLC", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT7948658744", created_at: new Date("2024-03-27T10:38:33Z") }, { id: 21, name: "Weissnat - Stehr", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT8927415845", created_at: new Date("2022-11-20T07:27:34Z") }, { id: 22, name: "Lynch LLC", billing_currency: "CHF", tax_treatment: "reverse_charge", vat_number: "VAT6459597833", created_at: new Date("2022-05-03T16:20:32Z") }, { id: 23, name: "Monahan-Murazik - Buckridge", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT0446140684", created_at: new Date("2022-11-06T10:35:26Z") }, { id: 24, name: "Rath and Sons", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT0653869444", created_at: new Date("2023-03-25T14:01:28Z") }, { id: 25, name: "Boyer Inc", billing_currency: "EUR", tax_treatment: "reverse_charge", vat_number: "VAT4271039032", created_at: new Date("2023-03-24T10:43:36Z") }, { id: 26, name: "Rosenbaum LLC", billing_currency: "GBP", tax_treatment: "export", vat_number: null, created_at: new Date("2022-11-21T11:31:41Z") }, { id: 27, name: "Walsh, Tremblay and Keebler", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT5468872295", created_at: new Date("2024-01-26T09:24:44Z") }, { id: 28, name: "Bergstrom, Cruickshank and Gerlach", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT5227209669", created_at: new Date("2022-08-16T10:40:39Z") }, { id: 29, name: "Kulas, Robel and Weissnat", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT2456244383", created_at: new Date("2023-05-23T10:10:45Z") }, { id: 30, name: "Boehm - Fahey", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT5016184180", created_at: new Date("2023-06-21T13:58:02Z") }, { id: 31, name: "Collins Inc", billing_currency: "USD", tax_treatment: "export", vat_number: null, created_at: new Date("2024-06-12T17:23:46Z") }, { id: 32, name: "Padberg - McKenzie", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT2474111449", created_at: new Date("2022-06-11T08:48:55Z") }, { id: 33, name: "Cummings Inc", billing_currency: "USD", tax_treatment: "reverse_charge", vat_number: "VAT3295023068", created_at: new Date("2023-01-26T07:21:25Z") }, { id: 34, name: "Smith and Sons", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT7023225874", created_at: new Date("2023-09-18T11:29:54Z") }, { id: 35, name: "Bashirian - Gottlieb", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT0902594583", created_at: new Date("2023-03-23T13:09:36Z") }, { id: 36, name: "Stracke - Stiedemann", billing_currency: "GBP", tax_treatment: "reverse_charge", vat_number: "VAT1204394263", created_at: new Date("2023-04-21T18:52:23Z") }, { id: 37, name: "Zboncak Group", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT7229850203", created_at: new Date("2024-06-02T12:52:36Z") }, { id: 38, name: "Wisozk LLC", billing_currency: "CAD", tax_treatment: "reverse_charge", vat_number: "VAT1908289806", created_at: new Date("2023-12-02T11:14:45Z") }, { id: 39, name: "Hahn and Sons", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT7940845356", created_at: new Date("2023-01-13T10:08:10Z") }, { id: 40, name: "Corkery-Bergnaum LLC", billing_currency: "CHF", tax_treatment: "reverse_charge", vat_number: "VAT1001613277", created_at: new Date("2022-03-18T11:44:03Z") }, { id: 41, name: "Cormier, Prosacco and Borer", billing_currency: "EUR", tax_treatment: "export", vat_number: null, created_at: new Date("2022-03-25T15:22:01Z") }, { id: 42, name: "Huel, Schowalter and Stanton", billing_currency: "EUR", tax_treatment: "reverse_charge", vat_number: "VAT4852493784", created_at: new Date("2022-12-04T11:19:51Z") }, { id: 43, name: "Rolfson Inc", billing_currency: "EUR", tax_treatment: "export", vat_number: null, created_at: new Date("2023-05-27T19:33:57Z") }, { id: 44, name: "Treutel-Heaney Inc", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT6195502528", created_at: new Date("2023-02-08T17:24:02Z") }, { id: 45, name: "Cassin, Daugherty and Schulist", billing_currency: "CHF", tax_treatment: "export", vat_number: null, created_at: new Date("2023-01-25T18:39:32Z") }, { id: 46, name: "Dibbert - Hilpert", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT0848410614", created_at: new Date("2023-04-26T14:53:52Z") }, { id: 47, name: "Weimann - Erdman", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT0154472620", created_at: new Date("2024-04-19T14:58:50Z") }, { id: 48, name: "Weber, Hauck and Fay", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT7485571041", created_at: new Date("2023-01-24T18:20:27Z") }, { id: 49, name: "Boyer and Sons", billing_currency: "GBP", tax_treatment: "reverse_charge", vat_number: "VAT1828029936", created_at: new Date("2024-02-05T08:27:48Z") }, { id: 50, name: "Fisher LLC", billing_currency: "USD", tax_treatment: "reverse_charge", vat_number: "VAT3386929422", created_at: new Date("2022-10-27T12:42:27Z") }, { id: 51, name: "Purdy, Wilderman and Hegmann", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT0274238505", created_at: new Date("2022-09-28T12:47:03Z") }, { id: 52, name: "Casper, Schmitt and O'Hara", billing_currency: "GBP", tax_treatment: "export", vat_number: null, created_at: new Date("2022-07-05T11:24:20Z") }, { id: 53, name: "Metz, Herman and Haley", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT8944121607", created_at: new Date("2024-05-19T11:19:17Z") }, { id: 54, name: "Auer, Medhurst and Rohan", billing_currency: "EUR", tax_treatment: "reverse_charge", vat_number: "VAT2376144219", created_at: new Date("2023-03-28T18:06:15Z") }, { id: 55, name: "Bergstrom - O'Connell", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT9594260796", created_at: new Date("2022-09-25T09:25:17Z") }, { id: 56, name: "Haag and Sons", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT4844753836", created_at: new Date("2023-07-24T11:53:26Z") }, { id: 57, name: "Quigley - Walsh", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT5685534664", created_at: new Date("2022-06-23T17:54:58Z") }, { id: 58, name: "Kreiger, Pagac and Leuschke", billing_currency: "GBP", tax_treatment: "reverse_charge", vat_number: "VAT7434092548", created_at: new Date("2024-02-09T11:59:23Z") }, { id: 59, name: "Carroll, Hoppe and Sipes", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT3485608661", created_at: new Date("2022-07-30T11:02:13Z") }, { id: 60, name: "Schuster Group", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT8063253625", created_at: new Date("2024-03-08T14:31:31Z") }, { id: 61, name: "Mraz Group", billing_currency: "CHF", tax_treatment: "export", vat_number: null, created_at: new Date("2022-12-03T16:17:42Z") }, { id: 62, name: "Hand Group", billing_currency: "GBP", tax_treatment: "reverse_charge", vat_number: "VAT8649509519", created_at: new Date("2023-05-09T12:52:20Z") }, { id: 63, name: "Wilkinson, Hayes-Borer and Balistreri", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT3990461508", created_at: new Date("2022-08-08T10:02:47Z") }, { id: 64, name: "Gerlach and Sons", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT2915516280", created_at: new Date("2022-08-14T09:26:52Z") }, { id: 65, name: "Larson, Lakin-Halvorson and Morissette", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT1502152347", created_at: new Date("2024-05-09T18:31:18Z") }, { id: 66, name: "Schiller and Sons", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT4369685044", created_at: new Date("2022-05-19T10:59:23Z") }, { id: 67, name: "Weimann-Bauch Inc", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT3392293189", created_at: new Date("2024-05-13T09:22:41Z") }, { id: 68, name: "O'Conner - Schuppe", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT3592710028", created_at: new Date("2023-02-08T16:42:05Z") }, { id: 69, name: "Kemmer and Sons", billing_currency: "EUR", tax_treatment: "reverse_charge", vat_number: "VAT9655823652", created_at: new Date("2022-11-26T10:59:09Z") }, { id: 70, name: "Kassulke, Schmidt and Leuschke", billing_currency: "CAD", tax_treatment: "domestic", vat_number: "VAT0702483096", created_at: new Date("2022-04-26T13:38:16Z") }, { id: 71, name: "Murphy, Barrows and Hirthe", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT3129664412", created_at: new Date("2022-08-09T00:20:45Z") }, { id: 72, name: "Thompson, Shields and Bernier", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT6086872553", created_at: new Date("2023-08-09T10:45:31Z") }, { id: 73, name: "Romaguera, Gottlieb and Hayes", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT7976142329", created_at: new Date("2023-09-12T10:46:41Z") }, { id: 74, name: "Streich - Torp", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT3973465713", created_at: new Date("2024-05-04T10:30:33Z") }, { id: 75, name: "Stehr and Sons", billing_currency: "GBP", tax_treatment: "export", vat_number: null, created_at: new Date("2022-03-16T20:05:44Z") }, { id: 76, name: "Wuckert LLC", billing_currency: "CHF", tax_treatment: "domestic", vat_number: "VAT9030159983", created_at: new Date("2024-02-24T14:50:15Z") }, { id: 77, name: "Kshlerin, Ritchie and Hauck", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT0778663637", created_at: new Date("2022-04-24T12:57:26Z") }, { id: 78, name: "Nikolaus, Ratke and Nader", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT8124251158", created_at: new Date("2022-01-24T14:30:07Z") }, { id: 79, name: "Bashirian, Skiles and Bosco", billing_currency: "EUR", tax_treatment: "reverse_charge", vat_number: "VAT2631121280", created_at: new Date("2024-05-09T09:24:39Z") }, { id: 80, name: "Konopelski and Sons", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT0915516781", created_at: new Date("2024-04-28T21:58:43Z") }, { id: 81, name: "Smitham, Metz and Welch", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT8318893934", created_at: new Date("2024-04-17T20:41:28Z") }, { id: 82, name: "Stehr and Sons", billing_currency: "GBP", tax_treatment: "reverse_charge", vat_number: "VAT7157154531", created_at: new Date("2022-07-20T14:10:59Z") }, { id: 83, name: "Gibson, Kuhlman and Hamill", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT9320365388", created_at: new Date("2024-04-05T08:47:14Z") }, { id: 84, name: "Kiehn LLC", billing_currency: "EUR", tax_treatment: "domestic", vat_number: "VAT2302529162", created_at: new Date("2024-06-02T15:12:59Z") }, { id: 85, name: "Swaniawski - Schinner", billing_currency: "USD", tax_treatment: "domestic", vat_number: "VAT8664507957", created_at: new Date("2023-08-11T11:25:12Z") }, { id: 86, name: "Padberg - Spencer", billing_currency: "GBP", tax_treatment: "export", vat_number: null, created_at: new Date("2022-02-23T07:34:21Z") }, { id: 87, name: "Christiansen - West", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT5761815279", created_at: new Date("2024-01-07T17:33:36Z") }, { id: 88, name: "Hills - Lang", billing_currency: "GBP", tax_treatment: "domestic", vat_number: "VAT3294536472", created_at: new Date("2022-06-27T09:45:18Z") }, { id: 89, name: "Graham - Towne", billing_currency: "GBP", tax_treatment: "reverse_charge", vat_number: "VAT2784166528", created_at: new Date("2022-03-17T10:51:41Z") }, { id: 90, name: "Jast and Sons", billing_currency: "CHF", tax_treatment: "domestic", vat_number: "VAT7995243721", created_at: new Date("2022-11-23T14:56:33Z") }, ], }); await prisma.invoices.createMany({ data: [ { id: 1, customer_id: 44, invoice_number: "INV-459398", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-07-10", due_on: "2024-08-09", status: "paid", paid_on: "2024-09-16" }, { id: 2, customer_id: 81, invoice_number: "INV-911671", currency: "USD", tax_treatment: "domestic", issued_on: "2025-09-15", due_on: "2025-10-07", status: "paid", paid_on: "2025-11-16" }, { id: 3, customer_id: 29, invoice_number: "INV-326818", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-04-21", due_on: "2024-06-13", status: "paid", paid_on: "2024-06-10" }, { id: 4, customer_id: 73, invoice_number: "INV-457655", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-12-12", due_on: "2024-01-12", status: "paid", paid_on: "2024-01-16" }, { id: 5, customer_id: 51, invoice_number: "INV-555586", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-03-15", due_on: "2024-05-03", status: "paid", paid_on: "2024-05-08" }, { id: 6, customer_id: 1, invoice_number: "INV-354867", currency: "USD", tax_treatment: "reverse_charge", issued_on: "2024-06-07", due_on: "2024-07-02", status: "paid", paid_on: "2024-07-10" }, { id: 7, customer_id: 59, invoice_number: "INV-028751", currency: "USD", tax_treatment: "domestic", issued_on: "2023-11-04", due_on: "2023-11-11", status: "issued", paid_on: null }, { id: 8, customer_id: 20, invoice_number: "INV-584728", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-09-24", due_on: "2024-10-12", status: "issued", paid_on: null }, { id: 9, customer_id: 56, invoice_number: "INV-398007", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-05-25", due_on: "2024-06-23", status: "issued", paid_on: null }, { id: 10, customer_id: 30, invoice_number: "INV-020260", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-08-11", due_on: "2024-09-30", status: "paid", paid_on: "2024-08-22" }, { id: 11, customer_id: 26, invoice_number: "INV-068765", currency: "GBP", tax_treatment: "export", issued_on: "2024-02-07", due_on: "2024-04-01", status: "paid", paid_on: "2024-02-11" }, { id: 12, customer_id: 60, invoice_number: "INV-000938", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-11-21", due_on: "2025-01-01", status: "paid", paid_on: "2024-12-02" }, { id: 13, customer_id: 63, invoice_number: "INV-775089", currency: "GBP", tax_treatment: "domestic", issued_on: "2022-09-20", due_on: "2022-10-14", status: "paid", paid_on: "2022-09-26" }, { id: 14, customer_id: 47, invoice_number: "INV-068157", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-03-07", due_on: "2025-05-01", status: "void", paid_on: null }, { id: 15, customer_id: 19, invoice_number: "INV-075509", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-07-27", due_on: "2023-08-25", status: "issued", paid_on: null }, { id: 16, customer_id: 14, invoice_number: "INV-986799", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-10-17", due_on: "2024-10-18", status: "paid", paid_on: "2024-12-29" }, { id: 17, customer_id: 39, invoice_number: "INV-369532", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-12-19", due_on: "2023-12-26", status: "paid", paid_on: "2024-02-20" }, { id: 18, customer_id: 4, invoice_number: "INV-955260", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-08-20", due_on: "2024-10-14", status: "paid", paid_on: "2024-10-11" }, { id: 19, customer_id: 87, invoice_number: "INV-377268", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-04-12", due_on: "2024-05-06", status: "paid", paid_on: "2024-06-21" }, { id: 20, customer_id: 66, invoice_number: "INV-691009", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-06-08", due_on: "2023-06-19", status: "issued", paid_on: null }, { id: 21, customer_id: 72, invoice_number: "INV-218915", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-08-18", due_on: "2024-09-15", status: "paid", paid_on: "2024-10-25" }, { id: 22, customer_id: 71, invoice_number: "INV-821619", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-12-27", due_on: "2024-02-24", status: "void", paid_on: null }, { id: 23, customer_id: 45, invoice_number: "INV-054331", currency: "CHF", tax_treatment: "export", issued_on: "2023-06-17", due_on: "2023-07-20", status: "paid", paid_on: "2023-08-31" }, { id: 24, customer_id: 32, invoice_number: "INV-025839", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-08-05", due_on: "2023-09-05", status: "paid", paid_on: "2023-08-26" }, { id: 25, customer_id: 88, invoice_number: "INV-663121", currency: "GBP", tax_treatment: "domestic", issued_on: "2022-12-31", due_on: "2023-01-22", status: "paid", paid_on: "2023-01-19" }, { id: 26, customer_id: 73, invoice_number: "INV-912364", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-06-19", due_on: "2024-07-22", status: "paid", paid_on: "2024-07-14" }, { id: 27, customer_id: 84, invoice_number: "INV-078144", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-09-05", due_on: "2024-10-23", status: "paid", paid_on: "2024-10-07" }, { id: 28, customer_id: 80, invoice_number: "INV-569241", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-03-15", due_on: "2025-03-28", status: "paid", paid_on: "2025-04-27" }, { id: 29, customer_id: 84, invoice_number: "INV-965429", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-03-20", due_on: "2025-03-31", status: "paid", paid_on: "2025-04-29" }, { id: 30, customer_id: 44, invoice_number: "INV-972272", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-07-16", due_on: "2024-08-04", status: "issued", paid_on: null }, { id: 31, customer_id: 85, invoice_number: "INV-637756", currency: "USD", tax_treatment: "domestic", issued_on: "2023-11-30", due_on: "2023-12-30", status: "paid", paid_on: "2023-12-24" }, { id: 32, customer_id: 52, invoice_number: "INV-900910", currency: "GBP", tax_treatment: "export", issued_on: "2022-11-17", due_on: "2023-01-05", status: "paid", paid_on: "2022-12-11" }, { id: 33, customer_id: 33, invoice_number: "INV-364403", currency: "USD", tax_treatment: "reverse_charge", issued_on: "2023-10-20", due_on: "2023-12-10", status: "void", paid_on: null }, { id: 34, customer_id: 44, invoice_number: "INV-661013", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-12-04", due_on: "2023-12-31", status: "issued", paid_on: null }, { id: 35, customer_id: 8, invoice_number: "INV-228347", currency: "USD", tax_treatment: "domestic", issued_on: "2024-05-30", due_on: "2024-07-28", status: "void", paid_on: null }, { id: 36, customer_id: 33, invoice_number: "INV-696434", currency: "USD", tax_treatment: "reverse_charge", issued_on: "2023-03-31", due_on: "2023-05-24", status: "paid", paid_on: "2023-05-23" }, { id: 37, customer_id: 19, invoice_number: "INV-263515", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-11-07", due_on: "2024-12-05", status: "issued", paid_on: null }, { id: 38, customer_id: 78, invoice_number: "INV-255328", currency: "GBP", tax_treatment: "domestic", issued_on: "2022-06-15", due_on: "2022-07-18", status: "paid", paid_on: "2022-07-29" }, { id: 39, customer_id: 19, invoice_number: "INV-442363", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-11-03", due_on: "2024-11-25", status: "paid", paid_on: "2024-11-07" }, { id: 40, customer_id: 31, invoice_number: "INV-773984", currency: "USD", tax_treatment: "export", issued_on: "2025-08-29", due_on: "2025-10-17", status: "paid", paid_on: "2025-10-20" }, { id: 41, customer_id: 88, invoice_number: "INV-778887", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-05-11", due_on: "2023-05-22", status: "paid", paid_on: "2023-06-30" }, { id: 42, customer_id: 58, invoice_number: "INV-216876", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-08-29", due_on: "2024-09-10", status: "paid", paid_on: "2024-09-23" }, { id: 43, customer_id: 31, invoice_number: "INV-833421", currency: "USD", tax_treatment: "export", issued_on: "2025-11-16", due_on: "2025-12-06", status: "paid", paid_on: "2025-12-05" }, { id: 44, customer_id: 38, invoice_number: "INV-744683", currency: "CAD", tax_treatment: "reverse_charge", issued_on: "2025-02-01", due_on: "2025-03-25", status: "issued", paid_on: null }, { id: 45, customer_id: 64, invoice_number: "INV-026063", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-12-22", due_on: "2024-01-04", status: "paid", paid_on: "2024-01-27" }, { id: 46, customer_id: 60, invoice_number: "INV-802458", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-02-12", due_on: "2025-04-06", status: "issued", paid_on: null }, { id: 47, customer_id: 27, invoice_number: "INV-826580", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-08-24", due_on: "2024-10-04", status: "void", paid_on: null }, { id: 48, customer_id: 4, invoice_number: "INV-475079", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-05-08", due_on: "2024-05-21", status: "paid", paid_on: "2024-05-17" }, { id: 49, customer_id: 25, invoice_number: "INV-147867", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2024-05-06", due_on: "2024-05-11", status: "issued", paid_on: null }, { id: 50, customer_id: 63, invoice_number: "INV-205901", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-10-03", due_on: "2023-10-13", status: "issued", paid_on: null }, { id: 51, customer_id: 30, invoice_number: "INV-659763", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-06-22", due_on: "2023-07-17", status: "paid", paid_on: "2023-08-08" }, { id: 52, customer_id: 5, invoice_number: "INV-270921", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-09-18", due_on: "2023-10-21", status: "paid", paid_on: "2023-11-19" }, { id: 53, customer_id: 7, invoice_number: "INV-954263", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-12-19", due_on: "2023-12-20", status: "issued", paid_on: null }, { id: 54, customer_id: 5, invoice_number: "INV-832627", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-12-06", due_on: "2024-01-25", status: "paid", paid_on: "2023-12-21" }, { id: 55, customer_id: 72, invoice_number: "INV-659410", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-04-01", due_on: "2024-05-31", status: "issued", paid_on: null }, { id: 56, customer_id: 84, invoice_number: "INV-149775", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-04-05", due_on: "2025-04-09", status: "issued", paid_on: null }, { id: 57, customer_id: 32, invoice_number: "INV-154369", currency: "EUR", tax_treatment: "domestic", issued_on: "2022-08-17", due_on: "2022-10-04", status: "void", paid_on: null }, { id: 58, customer_id: 59, invoice_number: "INV-491331", currency: "USD", tax_treatment: "domestic", issued_on: "2023-03-04", due_on: "2023-04-05", status: "paid", paid_on: "2023-03-31" }, { id: 59, customer_id: 4, invoice_number: "INV-238346", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-11-10", due_on: "2024-11-24", status: "paid", paid_on: "2024-12-20" }, { id: 60, customer_id: 60, invoice_number: "INV-922111", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-03-17", due_on: "2025-04-21", status: "paid", paid_on: "2025-03-23" }, { id: 61, customer_id: 90, invoice_number: "INV-950004", currency: "CHF", tax_treatment: "domestic", issued_on: "2023-02-01", due_on: "2023-03-14", status: "issued", paid_on: null }, { id: 62, customer_id: 66, invoice_number: "INV-793434", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-07-24", due_on: "2023-09-21", status: "paid", paid_on: "2023-10-05" }, { id: 63, customer_id: 39, invoice_number: "INV-163617", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-08-24", due_on: "2023-10-09", status: "paid", paid_on: "2023-09-28" }, { id: 64, customer_id: 4, invoice_number: "INV-266490", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-11-23", due_on: "2024-12-10", status: "paid", paid_on: "2024-12-06" }, { id: 65, customer_id: 55, invoice_number: "INV-677845", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-04-19", due_on: "2023-05-25", status: "paid", paid_on: "2023-05-20" }, { id: 66, customer_id: 20, invoice_number: "INV-097063", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-07-09", due_on: "2024-07-17", status: "paid", paid_on: "2024-07-27" }, { id: 67, customer_id: 57, invoice_number: "INV-084947", currency: "USD", tax_treatment: "domestic", issued_on: "2023-11-13", due_on: "2023-12-25", status: "issued", paid_on: null }, { id: 68, customer_id: 10, invoice_number: "INV-936717", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2024-04-15", due_on: "2024-04-20", status: "paid", paid_on: "2024-05-02" }, { id: 69, customer_id: 66, invoice_number: "INV-256298", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-08-07", due_on: "2023-08-23", status: "paid", paid_on: "2023-10-05" }, { id: 70, customer_id: 2, invoice_number: "INV-342172", currency: "USD", tax_treatment: "domestic", issued_on: "2022-12-11", due_on: "2023-01-14", status: "paid", paid_on: "2023-01-22" }, { id: 71, customer_id: 36, invoice_number: "INV-147443", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-10-11", due_on: "2024-11-05", status: "paid", paid_on: "2024-12-05" }, { id: 72, customer_id: 37, invoice_number: "INV-626060", currency: "USD", tax_treatment: "domestic", issued_on: "2025-01-21", due_on: "2025-01-28", status: "issued", paid_on: null }, { id: 73, customer_id: 4, invoice_number: "INV-511627", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2025-01-11", due_on: "2025-01-12", status: "issued", paid_on: null }, { id: 74, customer_id: 9, invoice_number: "INV-208283", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-03-21", due_on: "2024-05-12", status: "paid", paid_on: "2024-04-23" }, { id: 75, customer_id: 67, invoice_number: "INV-925380", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-07-08", due_on: "2025-07-19", status: "paid", paid_on: "2025-09-07" }, { id: 76, customer_id: 23, invoice_number: "INV-936168", currency: "USD", tax_treatment: "domestic", issued_on: "2023-12-07", due_on: "2023-12-24", status: "paid", paid_on: "2023-12-13" }, { id: 77, customer_id: 32, invoice_number: "INV-799267", currency: "EUR", tax_treatment: "domestic", issued_on: "2022-07-20", due_on: "2022-09-17", status: "paid", paid_on: "2022-08-23" }, { id: 78, customer_id: 65, invoice_number: "INV-388695", currency: "USD", tax_treatment: "domestic", issued_on: "2025-02-10", due_on: "2025-03-10", status: "paid", paid_on: "2025-04-14" }, { id: 79, customer_id: 30, invoice_number: "INV-424803", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-08-20", due_on: "2023-10-12", status: "paid", paid_on: "2023-10-29" }, { id: 80, customer_id: 60, invoice_number: "INV-351388", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-02-08", due_on: "2025-04-07", status: "paid", paid_on: "2025-03-04" }, { id: 81, customer_id: 27, invoice_number: "INV-297462", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-05-30", due_on: "2024-07-18", status: "paid", paid_on: "2024-08-02" }, { id: 82, customer_id: 37, invoice_number: "INV-269458", currency: "USD", tax_treatment: "domestic", issued_on: "2024-11-07", due_on: "2025-01-04", status: "paid", paid_on: "2024-12-17" }, { id: 83, customer_id: 61, invoice_number: "INV-605103", currency: "CHF", tax_treatment: "export", issued_on: "2024-03-02", due_on: "2024-04-25", status: "void", paid_on: null }, { id: 84, customer_id: 38, invoice_number: "INV-059733", currency: "CAD", tax_treatment: "reverse_charge", issued_on: "2025-01-29", due_on: "2025-02-11", status: "paid", paid_on: "2025-03-05" }, { id: 85, customer_id: 32, invoice_number: "INV-946857", currency: "EUR", tax_treatment: "domestic", issued_on: "2022-06-28", due_on: "2022-08-27", status: "paid", paid_on: "2022-09-07" }, { id: 86, customer_id: 81, invoice_number: "INV-033017", currency: "USD", tax_treatment: "domestic", issued_on: "2024-08-22", due_on: "2024-09-21", status: "issued", paid_on: null }, { id: 87, customer_id: 8, invoice_number: "INV-899967", currency: "USD", tax_treatment: "domestic", issued_on: "2024-10-18", due_on: "2024-12-17", status: "paid", paid_on: "2024-11-14" }, { id: 88, customer_id: 63, invoice_number: "INV-626073", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-02-05", due_on: "2023-02-06", status: "paid", paid_on: "2023-03-19" }, { id: 89, customer_id: 12, invoice_number: "INV-833844", currency: "GBP", tax_treatment: "domestic", issued_on: "2022-08-15", due_on: "2022-08-16", status: "issued", paid_on: null }, { id: 90, customer_id: 30, invoice_number: "INV-518370", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-12-11", due_on: "2024-01-27", status: "paid", paid_on: "2023-12-18" }, { id: 91, customer_id: 84, invoice_number: "INV-095140", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-06-09", due_on: "2025-07-29", status: "paid", paid_on: "2025-08-11" }, { id: 92, customer_id: 73, invoice_number: "INV-226683", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-07-27", due_on: "2024-07-28", status: "paid", paid_on: "2024-09-03" }, { id: 93, customer_id: 54, invoice_number: "INV-997492", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2024-07-10", due_on: "2024-08-29", status: "paid", paid_on: "2024-08-04" }, { id: 94, customer_id: 28, invoice_number: "INV-172056", currency: "USD", tax_treatment: "domestic", issued_on: "2023-08-13", due_on: "2023-09-09", status: "paid", paid_on: "2023-10-21" }, { id: 95, customer_id: 13, invoice_number: "INV-910338", currency: "CAD", tax_treatment: "domestic", issued_on: "2023-03-11", due_on: "2023-03-23", status: "paid", paid_on: "2023-04-06" }, { id: 96, customer_id: 54, invoice_number: "INV-256272", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2024-05-30", due_on: "2024-07-27", status: "paid", paid_on: "2024-05-30" }, { id: 97, customer_id: 56, invoice_number: "INV-674575", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-07-31", due_on: "2024-09-06", status: "issued", paid_on: null }, { id: 98, customer_id: 24, invoice_number: "INV-812900", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-02-06", due_on: "2024-04-06", status: "issued", paid_on: null }, { id: 99, customer_id: 80, invoice_number: "INV-259977", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-02-17", due_on: "2025-03-02", status: "paid", paid_on: "2025-02-27" }, { id: 100, customer_id: 16, invoice_number: "INV-237378", currency: "EUR", tax_treatment: "domestic", issued_on: "2022-08-22", due_on: "2022-10-09", status: "void", paid_on: null }, { id: 101, customer_id: 4, invoice_number: "INV-586247", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-03-17", due_on: "2024-05-14", status: "paid", paid_on: "2024-04-18" }, { id: 102, customer_id: 55, invoice_number: "INV-356085", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-04-16", due_on: "2023-06-15", status: "paid", paid_on: "2023-06-20" }, { id: 103, customer_id: 43, invoice_number: "INV-724755", currency: "EUR", tax_treatment: "export", issued_on: "2024-02-28", due_on: "2024-03-13", status: "paid", paid_on: "2024-03-24" }, { id: 104, customer_id: 15, invoice_number: "INV-547846", currency: "USD", tax_treatment: "reverse_charge", issued_on: "2023-11-05", due_on: "2023-12-30", status: "issued", paid_on: null }, { id: 105, customer_id: 82, invoice_number: "INV-835083", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2023-09-17", due_on: "2023-10-04", status: "paid", paid_on: "2023-11-19" }, { id: 106, customer_id: 34, invoice_number: "INV-581533", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-12-01", due_on: "2025-01-15", status: "issued", paid_on: null }, { id: 107, customer_id: 73, invoice_number: "INV-892337", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-12-28", due_on: "2024-02-09", status: "paid", paid_on: "2024-01-13" }, { id: 108, customer_id: 9, invoice_number: "INV-675861", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2023-10-12", due_on: "2023-10-27", status: "paid", paid_on: "2023-11-17" }, { id: 109, customer_id: 86, invoice_number: "INV-490350", currency: "GBP", tax_treatment: "export", issued_on: "2023-01-15", due_on: "2023-01-18", status: "paid", paid_on: "2023-03-04" }, { id: 110, customer_id: 11, invoice_number: "INV-723368", currency: "USD", tax_treatment: "domestic", issued_on: "2023-08-21", due_on: "2023-10-09", status: "paid", paid_on: "2023-10-01" }, { id: 111, customer_id: 50, invoice_number: "INV-570212", currency: "USD", tax_treatment: "reverse_charge", issued_on: "2022-11-30", due_on: "2022-12-17", status: "paid", paid_on: "2022-12-13" }, { id: 112, customer_id: 82, invoice_number: "INV-742772", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2023-02-28", due_on: "2023-03-18", status: "paid", paid_on: "2023-05-08" }, { id: 113, customer_id: 52, invoice_number: "INV-936117", currency: "GBP", tax_treatment: "export", issued_on: "2022-12-11", due_on: "2022-12-14", status: "paid", paid_on: "2023-02-10" }, { id: 114, customer_id: 27, invoice_number: "INV-428837", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-06-26", due_on: "2024-07-15", status: "paid", paid_on: "2024-07-10" }, { id: 115, customer_id: 20, invoice_number: "INV-352814", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-02-10", due_on: "2025-03-03", status: "issued", paid_on: null }, { id: 116, customer_id: 37, invoice_number: "INV-088049", currency: "USD", tax_treatment: "domestic", issued_on: "2025-04-19", due_on: "2025-05-28", status: "paid", paid_on: "2025-05-30" }, { id: 117, customer_id: 2, invoice_number: "INV-849449", currency: "USD", tax_treatment: "domestic", issued_on: "2023-07-18", due_on: "2023-09-12", status: "paid", paid_on: "2023-08-13" }, { id: 118, customer_id: 54, invoice_number: "INV-089204", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2023-07-20", due_on: "2023-09-05", status: "paid", paid_on: "2023-08-05" }, { id: 119, customer_id: 37, invoice_number: "INV-938969", currency: "USD", tax_treatment: "domestic", issued_on: "2025-04-20", due_on: "2025-04-22", status: "void", paid_on: null }, { id: 120, customer_id: 22, invoice_number: "INV-387024", currency: "CHF", tax_treatment: "reverse_charge", issued_on: "2023-10-05", due_on: "2023-10-25", status: "paid", paid_on: "2023-12-07" }, { id: 121, customer_id: 18, invoice_number: "INV-266960", currency: "USD", tax_treatment: "reverse_charge", issued_on: "2024-04-28", due_on: "2024-05-08", status: "paid", paid_on: "2024-05-01" }, { id: 122, customer_id: 42, invoice_number: "INV-622372", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2023-12-27", due_on: "2024-01-23", status: "issued", paid_on: null }, { id: 123, customer_id: 86, invoice_number: "INV-637871", currency: "GBP", tax_treatment: "export", issued_on: "2022-04-14", due_on: "2022-04-17", status: "issued", paid_on: null }, { id: 124, customer_id: 37, invoice_number: "INV-100755", currency: "USD", tax_treatment: "domestic", issued_on: "2025-02-14", due_on: "2025-03-23", status: "paid", paid_on: "2025-02-14" }, { id: 125, customer_id: 41, invoice_number: "INV-722374", currency: "EUR", tax_treatment: "export", issued_on: "2022-07-18", due_on: "2022-08-23", status: "paid", paid_on: "2022-09-14" }, { id: 126, customer_id: 2, invoice_number: "INV-642191", currency: "USD", tax_treatment: "domestic", issued_on: "2022-11-25", due_on: "2022-12-02", status: "paid", paid_on: "2023-01-28" }, { id: 127, customer_id: 60, invoice_number: "INV-615354", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-01-07", due_on: "2025-01-17", status: "paid", paid_on: "2025-02-13" }, { id: 128, customer_id: 26, invoice_number: "INV-986255", currency: "GBP", tax_treatment: "export", issued_on: "2023-04-16", due_on: "2023-05-14", status: "issued", paid_on: null }, { id: 129, customer_id: 8, invoice_number: "INV-858998", currency: "USD", tax_treatment: "domestic", issued_on: "2024-04-20", due_on: "2024-06-06", status: "paid", paid_on: "2024-05-16" }, { id: 130, customer_id: 85, invoice_number: "INV-407326", currency: "USD", tax_treatment: "domestic", issued_on: "2023-08-29", due_on: "2023-09-14", status: "paid", paid_on: "2023-09-22" }, { id: 131, customer_id: 39, invoice_number: "INV-793284", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-11-20", due_on: "2024-01-06", status: "paid", paid_on: "2024-01-13" }, { id: 132, customer_id: 73, invoice_number: "INV-241364", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-03-02", due_on: "2024-04-26", status: "issued", paid_on: null }, { id: 133, customer_id: 32, invoice_number: "INV-727469", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-03-01", due_on: "2023-04-10", status: "void", paid_on: null }, { id: 134, customer_id: 89, invoice_number: "INV-153627", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2023-02-22", due_on: "2023-03-19", status: "paid", paid_on: "2023-03-22" }, { id: 135, customer_id: 46, invoice_number: "INV-391722", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-07-20", due_on: "2023-09-09", status: "paid", paid_on: "2023-09-20" }, { id: 136, customer_id: 4, invoice_number: "INV-358304", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2023-12-17", due_on: "2024-01-19", status: "paid", paid_on: "2024-01-28" }, { id: 137, customer_id: 55, invoice_number: "INV-227595", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-10-18", due_on: "2023-11-15", status: "paid", paid_on: "2023-12-18" }, { id: 138, customer_id: 60, invoice_number: "INV-982902", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-08-27", due_on: "2025-09-05", status: "paid", paid_on: "2025-10-19" }, { id: 139, customer_id: 30, invoice_number: "INV-330904", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-05-26", due_on: "2024-07-01", status: "issued", paid_on: null }, { id: 140, customer_id: 52, invoice_number: "INV-256951", currency: "GBP", tax_treatment: "export", issued_on: "2023-04-02", due_on: "2023-04-05", status: "paid", paid_on: "2023-05-08" }, { id: 141, customer_id: 30, invoice_number: "INV-841095", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-04-21", due_on: "2024-05-28", status: "paid", paid_on: "2024-06-28" }, { id: 142, customer_id: 59, invoice_number: "INV-271841", currency: "USD", tax_treatment: "domestic", issued_on: "2022-09-09", due_on: "2022-10-06", status: "paid", paid_on: "2022-09-10" }, { id: 143, customer_id: 19, invoice_number: "INV-923326", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-07-27", due_on: "2023-09-20", status: "paid", paid_on: "2023-08-13" }, { id: 144, customer_id: 39, invoice_number: "INV-019329", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-06-12", due_on: "2023-06-28", status: "paid", paid_on: "2023-07-22" }, { id: 145, customer_id: 12, invoice_number: "INV-946741", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-05-07", due_on: "2023-05-16", status: "paid", paid_on: "2023-06-13" }, { id: 146, customer_id: 83, invoice_number: "INV-178470", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-07-01", due_on: "2025-07-19", status: "issued", paid_on: null }, { id: 147, customer_id: 8, invoice_number: "INV-568729", currency: "USD", tax_treatment: "domestic", issued_on: "2023-10-23", due_on: "2023-12-15", status: "paid", paid_on: "2023-12-27" }, { id: 148, customer_id: 78, invoice_number: "INV-667894", currency: "GBP", tax_treatment: "domestic", issued_on: "2022-03-14", due_on: "2022-05-07", status: "void", paid_on: null }, { id: 149, customer_id: 26, invoice_number: "INV-306999", currency: "GBP", tax_treatment: "export", issued_on: "2023-04-18", due_on: "2023-05-21", status: "paid", paid_on: "2023-05-16" }, { id: 150, customer_id: 17, invoice_number: "INV-962263", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-06-03", due_on: "2025-07-19", status: "paid", paid_on: "2025-07-01" }, { id: 151, customer_id: 51, invoice_number: "INV-633282", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-06-03", due_on: "2023-07-04", status: "paid", paid_on: "2023-08-08" }, { id: 152, customer_id: 35, invoice_number: "INV-664435", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-06-26", due_on: "2024-07-23", status: "issued", paid_on: null }, { id: 153, customer_id: 40, invoice_number: "INV-186930", currency: "CHF", tax_treatment: "reverse_charge", issued_on: "2022-03-24", due_on: "2022-05-19", status: "paid", paid_on: "2022-05-18" }, { id: 154, customer_id: 79, invoice_number: "INV-604804", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2025-04-27", due_on: "2025-06-19", status: "void", paid_on: null }, { id: 155, customer_id: 8, invoice_number: "INV-050368", currency: "USD", tax_treatment: "domestic", issued_on: "2023-11-17", due_on: "2023-12-27", status: "void", paid_on: null }, { id: 156, customer_id: 54, invoice_number: "INV-807120", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2024-05-14", due_on: "2024-06-09", status: "paid", paid_on: "2024-07-14" }, { id: 157, customer_id: 28, invoice_number: "INV-033153", currency: "USD", tax_treatment: "domestic", issued_on: "2022-10-25", due_on: "2022-10-25", status: "paid", paid_on: "2022-12-15" }, { id: 158, customer_id: 82, invoice_number: "INV-704572", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2022-10-07", due_on: "2022-11-30", status: "paid", paid_on: "2022-10-21" }, { id: 159, customer_id: 88, invoice_number: "INV-205195", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-07-13", due_on: "2023-09-08", status: "issued", paid_on: null }, { id: 160, customer_id: 38, invoice_number: "INV-095599", currency: "CAD", tax_treatment: "reverse_charge", issued_on: "2025-04-01", due_on: "2025-05-04", status: "issued", paid_on: null }, { id: 161, customer_id: 55, invoice_number: "INV-326376", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-02-23", due_on: "2024-04-04", status: "paid", paid_on: "2024-04-22" }, { id: 162, customer_id: 52, invoice_number: "INV-139002", currency: "GBP", tax_treatment: "export", issued_on: "2023-02-05", due_on: "2023-02-27", status: "paid", paid_on: "2023-03-05" }, { id: 163, customer_id: 28, invoice_number: "INV-973243", currency: "USD", tax_treatment: "domestic", issued_on: "2024-02-05", due_on: "2024-04-03", status: "paid", paid_on: "2024-04-01" }, { id: 164, customer_id: 67, invoice_number: "INV-287368", currency: "GBP", tax_treatment: "domestic", issued_on: "2025-02-22", due_on: "2025-03-19", status: "paid", paid_on: "2025-04-04" }, { id: 165, customer_id: 57, invoice_number: "INV-258375", currency: "USD", tax_treatment: "domestic", issued_on: "2023-02-01", due_on: "2023-03-28", status: "paid", paid_on: "2023-04-09" }, { id: 166, customer_id: 88, invoice_number: "INV-161737", currency: "GBP", tax_treatment: "domestic", issued_on: "2022-10-30", due_on: "2022-11-01", status: "paid", paid_on: "2022-12-28" }, { id: 167, customer_id: 51, invoice_number: "INV-186006", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-01-30", due_on: "2024-03-29", status: "paid", paid_on: "2024-02-26" }, { id: 168, customer_id: 84, invoice_number: "INV-772483", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-01-15", due_on: "2025-01-15", status: "paid", paid_on: "2025-02-03" }, { id: 169, customer_id: 8, invoice_number: "INV-164084", currency: "USD", tax_treatment: "domestic", issued_on: "2024-05-09", due_on: "2024-05-12", status: "issued", paid_on: null }, { id: 170, customer_id: 12, invoice_number: "INV-980809", currency: "GBP", tax_treatment: "domestic", issued_on: "2022-12-28", due_on: "2023-02-20", status: "paid", paid_on: "2023-03-02" }, { id: 171, customer_id: 59, invoice_number: "INV-628268", currency: "USD", tax_treatment: "domestic", issued_on: "2022-11-02", due_on: "2022-11-15", status: "issued", paid_on: null }, { id: 172, customer_id: 55, invoice_number: "INV-357815", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-03-14", due_on: "2024-04-29", status: "paid", paid_on: "2024-05-24" }, { id: 173, customer_id: 12, invoice_number: "INV-437674", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-10-15", due_on: "2023-11-26", status: "paid", paid_on: "2023-11-25" }, { id: 174, customer_id: 63, invoice_number: "INV-273802", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-01-18", due_on: "2023-02-18", status: "paid", paid_on: "2023-03-07" }, { id: 175, customer_id: 73, invoice_number: "INV-001387", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-09-12", due_on: "2024-09-29", status: "paid", paid_on: "2024-10-29" }, { id: 176, customer_id: 38, invoice_number: "INV-900264", currency: "CAD", tax_treatment: "reverse_charge", issued_on: "2024-02-05", due_on: "2024-03-13", status: "paid", paid_on: "2024-03-30" }, { id: 177, customer_id: 3, invoice_number: "INV-804305", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-05-19", due_on: "2024-05-24", status: "paid", paid_on: "2024-07-16" }, { id: 178, customer_id: 86, invoice_number: "INV-558661", currency: "GBP", tax_treatment: "export", issued_on: "2022-08-25", due_on: "2022-10-24", status: "paid", paid_on: "2022-10-03" }, { id: 179, customer_id: 82, invoice_number: "INV-251191", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-01-07", due_on: "2024-02-01", status: "issued", paid_on: null }, { id: 180, customer_id: 63, invoice_number: "INV-083951", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-02-10", due_on: "2023-04-04", status: "paid", paid_on: "2023-03-17" }, { id: 181, customer_id: 32, invoice_number: "INV-465000", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-10-05", due_on: "2023-10-18", status: "paid", paid_on: "2023-10-25" }, { id: 182, customer_id: 73, invoice_number: "INV-118430", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-02-28", due_on: "2025-04-10", status: "paid", paid_on: "2025-04-29" }, { id: 183, customer_id: 76, invoice_number: "INV-982932", currency: "CHF", tax_treatment: "domestic", issued_on: "2025-07-26", due_on: "2025-08-12", status: "paid", paid_on: "2025-07-31" }, { id: 184, customer_id: 75, invoice_number: "INV-612457", currency: "GBP", tax_treatment: "export", issued_on: "2022-07-16", due_on: "2022-08-17", status: "paid", paid_on: "2022-08-09" }, { id: 185, customer_id: 66, invoice_number: "INV-239452", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-09-20", due_on: "2023-09-20", status: "paid", paid_on: "2023-09-29" }, { id: 186, customer_id: 84, invoice_number: "INV-277854", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-05-01", due_on: "2025-05-02", status: "issued", paid_on: null }, { id: 187, customer_id: 74, invoice_number: "INV-520059", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-10-20", due_on: "2025-11-03", status: "issued", paid_on: null }, { id: 188, customer_id: 42, invoice_number: "INV-205995", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2023-02-10", due_on: "2023-03-11", status: "paid", paid_on: "2023-02-28" }, { id: 189, customer_id: 63, invoice_number: "INV-254520", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-11-09", due_on: "2023-11-16", status: "issued", paid_on: null }, { id: 190, customer_id: 9, invoice_number: "INV-345762", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-08-29", due_on: "2024-10-13", status: "paid", paid_on: "2024-11-02" }, { id: 191, customer_id: 48, invoice_number: "INV-904639", currency: "USD", tax_treatment: "domestic", issued_on: "2023-07-18", due_on: "2023-09-14", status: "paid", paid_on: "2023-09-12" }, { id: 192, customer_id: 38, invoice_number: "INV-018856", currency: "CAD", tax_treatment: "reverse_charge", issued_on: "2024-09-24", due_on: "2024-10-06", status: "paid", paid_on: "2024-10-16" }, { id: 193, customer_id: 54, invoice_number: "INV-097915", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2024-01-15", due_on: "2024-01-23", status: "issued", paid_on: null }, { id: 194, customer_id: 9, invoice_number: "INV-515429", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-07-06", due_on: "2024-08-21", status: "paid", paid_on: "2024-07-06" }, { id: 195, customer_id: 45, invoice_number: "INV-814277", currency: "CHF", tax_treatment: "export", issued_on: "2023-02-28", due_on: "2023-03-14", status: "paid", paid_on: "2023-03-02" }, { id: 196, customer_id: 10, invoice_number: "INV-450197", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2024-08-29", due_on: "2024-10-05", status: "issued", paid_on: null }, { id: 197, customer_id: 70, invoice_number: "INV-729930", currency: "CAD", tax_treatment: "domestic", issued_on: "2023-04-29", due_on: "2023-06-03", status: "paid", paid_on: "2023-06-28" }, { id: 198, customer_id: 77, invoice_number: "INV-887231", currency: "USD", tax_treatment: "domestic", issued_on: "2022-07-12", due_on: "2022-07-31", status: "paid", paid_on: "2022-07-26" }, { id: 199, customer_id: 2, invoice_number: "INV-569769", currency: "USD", tax_treatment: "domestic", issued_on: "2024-02-22", due_on: "2024-03-30", status: "paid", paid_on: "2024-04-05" }, { id: 200, customer_id: 20, invoice_number: "INV-787694", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-08-23", due_on: "2025-08-26", status: "paid", paid_on: "2025-09-11" }, { id: 201, customer_id: 75, invoice_number: "INV-624396", currency: "GBP", tax_treatment: "export", issued_on: "2023-01-27", due_on: "2023-02-09", status: "void", paid_on: null }, { id: 202, customer_id: 88, invoice_number: "INV-696106", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-09-25", due_on: "2023-11-12", status: "paid", paid_on: "2023-10-30" }, { id: 203, customer_id: 43, invoice_number: "INV-169704", currency: "EUR", tax_treatment: "export", issued_on: "2024-06-08", due_on: "2024-06-11", status: "paid", paid_on: "2024-06-10" }, { id: 204, customer_id: 35, invoice_number: "INV-923532", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-05-24", due_on: "2023-06-14", status: "paid", paid_on: "2023-06-07" }, { id: 205, customer_id: 78, invoice_number: "INV-879671", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-01-03", due_on: "2023-01-07", status: "paid", paid_on: "2023-01-18" }, { id: 206, customer_id: 53, invoice_number: "INV-720526", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-11-11", due_on: "2024-11-16", status: "issued", paid_on: null }, { id: 207, customer_id: 75, invoice_number: "INV-633237", currency: "GBP", tax_treatment: "export", issued_on: "2023-06-06", due_on: "2023-06-20", status: "paid", paid_on: "2023-06-07" }, { id: 208, customer_id: 63, invoice_number: "INV-191657", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-01-20", due_on: "2023-03-17", status: "void", paid_on: null }, { id: 209, customer_id: 54, invoice_number: "INV-876425", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2023-05-14", due_on: "2023-06-21", status: "issued", paid_on: null }, { id: 210, customer_id: 47, invoice_number: "INV-639305", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-05-18", due_on: "2025-07-11", status: "paid", paid_on: "2025-06-08" }, { id: 211, customer_id: 62, invoice_number: "INV-346602", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2023-09-16", due_on: "2023-11-04", status: "paid", paid_on: "2023-10-25" }, { id: 212, customer_id: 68, invoice_number: "INV-127924", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-02-15", due_on: "2024-03-26", status: "issued", paid_on: null }, { id: 213, customer_id: 69, invoice_number: "INV-301193", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2023-08-24", due_on: "2023-10-08", status: "paid", paid_on: "2023-10-28" }, { id: 214, customer_id: 27, invoice_number: "INV-341006", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-03-31", due_on: "2024-05-27", status: "paid", paid_on: "2024-05-26" }, { id: 215, customer_id: 35, invoice_number: "INV-685090", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-11-20", due_on: "2023-12-23", status: "issued", paid_on: null }, { id: 216, customer_id: 51, invoice_number: "INV-124200", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-09-25", due_on: "2023-11-02", status: "paid", paid_on: "2023-10-19" }, { id: 217, customer_id: 34, invoice_number: "INV-770345", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-04-20", due_on: "2024-04-29", status: "paid", paid_on: "2024-06-05" }, { id: 218, customer_id: 38, invoice_number: "INV-527948", currency: "CAD", tax_treatment: "reverse_charge", issued_on: "2023-12-30", due_on: "2024-02-28", status: "issued", paid_on: null }, { id: 219, customer_id: 84, invoice_number: "INV-922102", currency: "EUR", tax_treatment: "domestic", issued_on: "2025-07-12", due_on: "2025-09-04", status: "void", paid_on: null }, { id: 220, customer_id: 44, invoice_number: "INV-290149", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-08-13", due_on: "2023-08-22", status: "issued", paid_on: null }, { id: 221, customer_id: 88, invoice_number: "INV-064556", currency: "GBP", tax_treatment: "domestic", issued_on: "2022-08-03", due_on: "2022-09-10", status: "paid", paid_on: "2022-09-26" }, { id: 222, customer_id: 20, invoice_number: "INV-605503", currency: "EUR", tax_treatment: "domestic", issued_on: "2024-05-14", due_on: "2024-06-26", status: "void", paid_on: null }, { id: 223, customer_id: 49, invoice_number: "INV-823620", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2024-03-30", due_on: "2024-04-26", status: "paid", paid_on: "2024-05-06" }, { id: 224, customer_id: 50, invoice_number: "INV-444027", currency: "USD", tax_treatment: "reverse_charge", issued_on: "2023-04-08", due_on: "2023-05-13", status: "issued", paid_on: null }, { id: 225, customer_id: 44, invoice_number: "INV-136906", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-12-06", due_on: "2024-02-02", status: "paid", paid_on: "2024-01-31" }, { id: 226, customer_id: 38, invoice_number: "INV-858265", currency: "CAD", tax_treatment: "reverse_charge", issued_on: "2024-01-25", due_on: "2024-02-27", status: "paid", paid_on: "2024-02-29" }, { id: 227, customer_id: 44, invoice_number: "INV-271626", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-05-13", due_on: "2023-06-06", status: "paid", paid_on: "2023-05-27" }, { id: 228, customer_id: 86, invoice_number: "INV-611669", currency: "GBP", tax_treatment: "export", issued_on: "2023-07-04", due_on: "2023-07-23", status: "issued", paid_on: null }, { id: 229, customer_id: 19, invoice_number: "INV-540449", currency: "GBP", tax_treatment: "domestic", issued_on: "2024-12-25", due_on: "2024-12-27", status: "paid", paid_on: "2025-01-01" }, { id: 230, customer_id: 42, invoice_number: "INV-052446", currency: "EUR", tax_treatment: "reverse_charge", issued_on: "2023-07-27", due_on: "2023-08-27", status: "paid", paid_on: "2023-08-05" }, { id: 231, customer_id: 21, invoice_number: "INV-441132", currency: "EUR", tax_treatment: "domestic", issued_on: "2023-07-07", due_on: "2023-07-10", status: "issued", paid_on: null }, { id: 232, customer_id: 6, invoice_number: "INV-273911", currency: "GBP", tax_treatment: "domestic", issued_on: "2023-09-05", due_on: "2023-09-10", status: "paid", paid_on: "2023-09-09" }, { id: 233, customer_id: 82, invoice_number: "INV-904324", currency: "GBP", tax_treatment: "reverse_charge", issued_on: "2023-12-30", due_on: "2024-02-11", status: "issued", paid_on: null }, ], }); await prisma.products.createMany({ data: [ { id: 1, sku: "SKU-0094", name: "Licence Pro Onboarding", unit_price: "144.99", vat_category: "standard", vat_rate: 0.2 }, { id: 2, sku: "SKU-1431", name: "Cloud Data Archive", unit_price: "261.86", vat_category: "standard", vat_rate: 0.2 }, { id: 3, sku: "SKU-6914", name: "Backup Storage", unit_price: "295.81", vat_category: "standard", vat_rate: 0.2 }, { id: 4, sku: "SKU-8658", name: "Data Pro", unit_price: "147.40", vat_category: "zero_rated", vat_rate: null }, { id: 5, sku: "SKU-4915", name: "Archive Ebook Licence", unit_price: "320.63", vat_category: "standard", vat_rate: 0.2 }, { id: 6, sku: "SKU-1943", name: "Security Backup", unit_price: "329.37", vat_category: "standard", vat_rate: 0.2 }, { id: 7, sku: "SKU-0549", name: "Licence Ebook", unit_price: "60.82", vat_category: "standard", vat_rate: 0.2 }, { id: 8, sku: "SKU-7149", name: "Sync Reports", unit_price: "66.25", vat_category: "standard", vat_rate: 0.2 }, { id: 9, sku: "SKU-8688", name: "Ebook Workspace Reports", unit_price: "191.14", vat_category: "standard", vat_rate: 0.2 }, { id: 10, sku: "SKU-7369", name: "Archive Backup", unit_price: "288.31", vat_category: "standard", vat_rate: 0.2 }, { id: 11, sku: "SKU-0959", name: "Onboarding Ebook Archive", unit_price: "92.57", vat_category: "standard", vat_rate: 0.2 }, { id: 12, sku: "SKU-7887", name: "Cloud Data Pro", unit_price: "55.02", vat_category: "standard", vat_rate: 0.2 }, { id: 13, sku: "SKU-4635", name: "Training Team", unit_price: "451.47", vat_category: "standard", vat_rate: 0.2 }, { id: 14, sku: "SKU-2786", name: "Seats Storage", unit_price: "20.95", vat_category: "zero_rated", vat_rate: null }, { id: 15, sku: "SKU-1500", name: "Support Pro", unit_price: "159.71", vat_category: "standard", vat_rate: 0.2 }, { id: 16, sku: "SKU-5795", name: "Analytics Cloud", unit_price: "14.41", vat_category: "standard", vat_rate: 0.2 }, { id: 17, sku: "SKU-5713", name: "Sync Reports Storage", unit_price: "183.18", vat_category: "standard", vat_rate: 0.2 }, { id: 18, sku: "SKU-9365", name: "Workspace Training Backup", unit_price: "299.28", vat_category: "standard", vat_rate: 0.2 }, { id: 19, sku: "SKU-9575", name: "Archive Backup", unit_price: "369.92", vat_category: "zero_rated", vat_rate: null }, { id: 20, sku: "SKU-0673", name: "Storage Seats", unit_price: "154.29", vat_category: "standard", vat_rate: 0.2 }, { id: 21, sku: "SKU-2890", name: "Team Pro", unit_price: "188.00", vat_category: "standard", vat_rate: 0.2 }, { id: 22, sku: "SKU-7377", name: "Sync Backup", unit_price: "369.19", vat_category: "standard", vat_rate: 0.2 }, { id: 23, sku: "SKU-1781", name: "Reports Ebook", unit_price: "182.75", vat_category: "standard", vat_rate: 0.2 }, { id: 24, sku: "SKU-4530", name: "Archive Data", unit_price: "88.25", vat_category: "standard", vat_rate: 0.2 }, { id: 25, sku: "SKU-3590", name: "Backup Seats Data", unit_price: "394.69", vat_category: "standard", vat_rate: 0.2 }, { id: 26, sku: "SKU-4227", name: "Storage Cloud Archive", unit_price: "469.01", vat_category: "standard", vat_rate: 0.2 }, { id: 27, sku: "SKU-9241", name: "Reports Onboarding Seats", unit_price: "364.78", vat_category: "standard", vat_rate: 0.2 }, { id: 28, sku: "SKU-1605", name: "Storage Backup Sync", unit_price: "356.72", vat_category: "standard", vat_rate: 0.2 }, { id: 29, sku: "SKU-2667", name: "Training Pro Ebook", unit_price: "274.56", vat_category: "standard", vat_rate: 0.2 }, { id: 30, sku: "SKU-6214", name: "Onboarding Analytics", unit_price: "98.11", vat_category: "zero_rated", vat_rate: null }, { id: 31, sku: "SKU-0850", name: "Archive Onboarding", unit_price: "405.30", vat_category: "standard", vat_rate: 0.2 }, { id: 32, sku: "SKU-5801", name: "Archive Storage Data", unit_price: "8.27", vat_category: "standard", vat_rate: 0.2 }, { id: 33, sku: "SKU-3784", name: "Workspace Licence Support", unit_price: "5.66", vat_category: "standard", vat_rate: 0.2 }, { id: 34, sku: "SKU-1315", name: "Backup Licence Team", unit_price: "4.65", vat_category: "standard", vat_rate: 0.2 }, { id: 35, sku: "SKU-6736", name: "Seats Ebook", unit_price: "185.30", vat_category: "standard", vat_rate: 0.2 }, { id: 36, sku: "SKU-2507", name: "Training Storage Team", unit_price: "36.25", vat_category: "standard", vat_rate: 0.2 }, ], }); await prisma.invoice_lines.createMany({ data: [ { id: 1, invoice_id: 25, line_no: 1, product_id: 34, quantity: 2, unit_price: "4.65", line_net: "9.30", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1.86", line_gross: "11.16" }, { id: 2, invoice_id: 2, line_no: 1, product_id: 9, quantity: 2, unit_price: "191.14", line_net: "382.28", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "76.46", line_gross: "458.74" }, { id: 3, invoice_id: 178, line_no: 1, product_id: 1, quantity: 22, unit_price: "144.99", line_net: "3189.78", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3189.78" }, { id: 4, invoice_id: 215, line_no: 1, product_id: 32, quantity: 8, unit_price: "8.27", line_net: "66.16", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "13.23", line_gross: "79.39" }, { id: 5, invoice_id: 37, line_no: 1, product_id: 7, quantity: 12, unit_price: "60.82", line_net: "729.84", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "145.97", line_gross: "875.81" }, { id: 6, invoice_id: 74, line_no: 1, product_id: 20, quantity: 25, unit_price: "154.29", line_net: "3857.25", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3857.25" }, { id: 7, invoice_id: 43, line_no: 1, product_id: 3, quantity: 2, unit_price: "295.81", line_net: "591.62", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "591.62" }, { id: 8, invoice_id: 176, line_no: 1, product_id: 10, quantity: 1, unit_price: "288.31", line_net: "288.31", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "288.31" }, { id: 9, invoice_id: 220, line_no: 1, product_id: 15, quantity: 17, unit_price: "159.71", line_net: "2715.07", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "543.01", line_gross: "3258.08" }, { id: 10, invoice_id: 154, line_no: 1, product_id: 11, quantity: 1, unit_price: "92.57", line_net: "92.57", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "92.57" }, { id: 11, invoice_id: 76, line_no: 1, product_id: 34, quantity: 16, unit_price: "4.65", line_net: "74.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "14.88", line_gross: "89.28" }, { id: 12, invoice_id: 14, line_no: 1, product_id: 33, quantity: 21, unit_price: "5.66", line_net: "118.86", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "23.77", line_gross: "142.63" }, { id: 13, invoice_id: 197, line_no: 1, product_id: 18, quantity: 10, unit_price: "299.28", line_net: "2992.80", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "598.56", line_gross: "3591.36" }, { id: 14, invoice_id: 222, line_no: 1, product_id: 15, quantity: 3, unit_price: "159.71", line_net: "479.13", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "95.83", line_gross: "574.96" }, { id: 15, invoice_id: 20, line_no: 1, product_id: 33, quantity: 12, unit_price: "5.66", line_net: "67.92", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "13.58", line_gross: "81.50" }, { id: 16, invoice_id: 78, line_no: 1, product_id: 35, quantity: 22, unit_price: "185.30", line_net: "4076.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "815.32", line_gross: "4891.92" }, { id: 17, invoice_id: 120, line_no: 1, product_id: 9, quantity: 12, unit_price: "191.14", line_net: "2293.68", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2293.68" }, { id: 18, invoice_id: 23, line_no: 1, product_id: 26, quantity: 1, unit_price: "469.01", line_net: "469.01", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "469.01" }, { id: 19, invoice_id: 5, line_no: 1, product_id: 15, quantity: 16, unit_price: "159.71", line_net: "2555.36", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "511.07", line_gross: "3066.43" }, { id: 20, invoice_id: 26, line_no: 1, product_id: 29, quantity: 15, unit_price: "274.56", line_net: "4118.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "823.68", line_gross: "4942.08" }, { id: 21, invoice_id: 181, line_no: 1, product_id: 9, quantity: 2, unit_price: "191.14", line_net: "382.28", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "76.46", line_gross: "458.74" }, { id: 22, invoice_id: 161, line_no: 1, product_id: 31, quantity: 18, unit_price: "405.30", line_net: "7295.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1459.08", line_gross: "8754.48" }, { id: 23, invoice_id: 22, line_no: 1, product_id: 35, quantity: 9, unit_price: "185.30", line_net: "1667.70", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "333.54", line_gross: "2001.24" }, { id: 24, invoice_id: 122, line_no: 1, product_id: 17, quantity: 2, unit_price: "183.18", line_net: "366.36", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "366.36" }, { id: 25, invoice_id: 155, line_no: 1, product_id: 27, quantity: 2, unit_price: "364.78", line_net: "729.56", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "145.91", line_gross: "875.47" }, { id: 26, invoice_id: 208, line_no: 1, product_id: 11, quantity: 3, unit_price: "92.57", line_net: "277.71", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "55.54", line_gross: "333.25" }, { id: 27, invoice_id: 128, line_no: 1, product_id: 20, quantity: 1, unit_price: "154.29", line_net: "154.29", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "154.29" }, { id: 28, invoice_id: 9, line_no: 1, product_id: 29, quantity: 17, unit_price: "274.56", line_net: "4667.52", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "933.50", line_gross: "5601.02" }, { id: 29, invoice_id: 48, line_no: 1, product_id: 10, quantity: 10, unit_price: "288.31", line_net: "2883.10", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2883.10" }, { id: 30, invoice_id: 156, line_no: 1, product_id: 32, quantity: 9, unit_price: "8.27", line_net: "74.43", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "74.43" }, { id: 31, invoice_id: 148, line_no: 1, product_id: 14, quantity: 16, unit_price: "20.95", line_net: "335.20", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "335.20" }, { id: 32, invoice_id: 4, line_no: 1, product_id: 15, quantity: 4, unit_price: "159.71", line_net: "638.84", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "127.77", line_gross: "766.61" }, { id: 33, invoice_id: 43, line_no: 2, product_id: 32, quantity: 8, unit_price: "8.27", line_net: "66.16", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "66.16" }, { id: 34, invoice_id: 61, line_no: 1, product_id: 14, quantity: 11, unit_price: "20.95", line_net: "230.45", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "230.45" }, { id: 35, invoice_id: 139, line_no: 1, product_id: 16, quantity: 16, unit_price: "14.41", line_net: "230.56", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "46.11", line_gross: "276.67" }, { id: 36, invoice_id: 58, line_no: 1, product_id: 27, quantity: 1, unit_price: "364.78", line_net: "364.78", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "72.96", line_gross: "437.74" }, { id: 37, invoice_id: 189, line_no: 1, product_id: 5, quantity: 19, unit_price: "320.63", line_net: "6091.97", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1218.39", line_gross: "7310.36" }, { id: 38, invoice_id: 65, line_no: 1, product_id: 15, quantity: 23, unit_price: "159.71", line_net: "3673.33", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "734.67", line_gross: "4408.00" }, { id: 39, invoice_id: 145, line_no: 1, product_id: 10, quantity: 3, unit_price: "288.31", line_net: "864.93", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "172.99", line_gross: "1037.92" }, { id: 40, invoice_id: 193, line_no: 1, product_id: 21, quantity: 18, unit_price: "188.00", line_net: "3384.00", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3384.00" }, { id: 41, invoice_id: 160, line_no: 1, product_id: 30, quantity: 11, unit_price: "98.11", line_net: "1079.21", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1079.21" }, { id: 42, invoice_id: 79, line_no: 1, product_id: 21, quantity: 21, unit_price: "188.00", line_net: "3948.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "789.60", line_gross: "4737.60" }, { id: 43, invoice_id: 185, line_no: 1, product_id: 23, quantity: 11, unit_price: "182.75", line_net: "2010.25", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "402.05", line_gross: "2412.30" }, { id: 44, invoice_id: 113, line_no: 1, product_id: 19, quantity: 2, unit_price: "369.92", line_net: "739.84", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "739.84" }, { id: 45, invoice_id: 205, line_no: 1, product_id: 23, quantity: 8, unit_price: "182.75", line_net: "1462.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "292.40", line_gross: "1754.40" }, { id: 46, invoice_id: 95, line_no: 1, product_id: 21, quantity: 1, unit_price: "188.00", line_net: "188.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "37.60", line_gross: "225.60" }, { id: 47, invoice_id: 113, line_no: 2, product_id: 11, quantity: 22, unit_price: "92.57", line_net: "2036.54", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2036.54" }, { id: 48, invoice_id: 153, line_no: 1, product_id: 10, quantity: 2, unit_price: "288.31", line_net: "576.62", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "576.62" }, { id: 49, invoice_id: 16, line_no: 1, product_id: 22, quantity: 1, unit_price: "369.19", line_net: "369.19", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "73.84", line_gross: "443.03" }, { id: 50, invoice_id: 126, line_no: 1, product_id: 23, quantity: 10, unit_price: "182.75", line_net: "1827.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "365.50", line_gross: "2193.00" }, { id: 51, invoice_id: 83, line_no: 1, product_id: 11, quantity: 2, unit_price: "92.57", line_net: "185.14", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "185.14" }, { id: 52, invoice_id: 140, line_no: 1, product_id: 14, quantity: 2, unit_price: "20.95", line_net: "41.90", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "41.90" }, { id: 53, invoice_id: 79, line_no: 2, product_id: 5, quantity: 6, unit_price: "320.63", line_net: "1923.78", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "384.76", line_gross: "2308.54" }, { id: 54, invoice_id: 75, line_no: 1, product_id: 12, quantity: 6, unit_price: "55.02", line_net: "330.12", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "66.02", line_gross: "396.14" }, { id: 55, invoice_id: 124, line_no: 1, product_id: 13, quantity: 11, unit_price: "451.47", line_net: "4966.17", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "993.23", line_gross: "5959.40" }, { id: 56, invoice_id: 100, line_no: 1, product_id: 1, quantity: 22, unit_price: "144.99", line_net: "3189.78", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "637.96", line_gross: "3827.74" }, { id: 57, invoice_id: 53, line_no: 1, product_id: 35, quantity: 3, unit_price: "185.30", line_net: "555.90", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "111.18", line_gross: "667.08" }, { id: 58, invoice_id: 116, line_no: 1, product_id: 34, quantity: 3, unit_price: "4.65", line_net: "13.95", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "2.79", line_gross: "16.74" }, { id: 59, invoice_id: 131, line_no: 1, product_id: 2, quantity: 16, unit_price: "261.86", line_net: "4189.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "837.95", line_gross: "5027.71" }, { id: 60, invoice_id: 12, line_no: 1, product_id: 1, quantity: 12, unit_price: "144.99", line_net: "1739.88", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "347.98", line_gross: "2087.86" }, { id: 61, invoice_id: 18, line_no: 1, product_id: 27, quantity: 1, unit_price: "364.78", line_net: "364.78", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "364.78" }, { id: 62, invoice_id: 34, line_no: 1, product_id: 14, quantity: 1, unit_price: "20.95", line_net: "20.95", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "20.95" }, { id: 63, invoice_id: 28, line_no: 1, product_id: 9, quantity: 25, unit_price: "191.14", line_net: "4778.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "955.70", line_gross: "5734.20" }, { id: 64, invoice_id: 183, line_no: 1, product_id: 11, quantity: 19, unit_price: "92.57", line_net: "1758.83", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "351.77", line_gross: "2110.60" }, { id: 65, invoice_id: 51, line_no: 1, product_id: 9, quantity: 2, unit_price: "191.14", line_net: "382.28", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "76.46", line_gross: "458.74" }, { id: 66, invoice_id: 127, line_no: 1, product_id: 15, quantity: 17, unit_price: "159.71", line_net: "2715.07", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "543.01", line_gross: "3258.08" }, { id: 67, invoice_id: 72, line_no: 1, product_id: 2, quantity: 13, unit_price: "261.86", line_net: "3404.18", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "680.84", line_gross: "4085.02" }, { id: 68, invoice_id: 144, line_no: 1, product_id: 7, quantity: 6, unit_price: "60.82", line_net: "364.92", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "72.98", line_gross: "437.90" }, { id: 69, invoice_id: 25, line_no: 2, product_id: 20, quantity: 4, unit_price: "154.29", line_net: "617.16", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "123.43", line_gross: "740.59" }, { id: 70, invoice_id: 160, line_no: 2, product_id: 28, quantity: 11, unit_price: "356.72", line_net: "3923.92", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3923.92" }, { id: 71, invoice_id: 223, line_no: 1, product_id: 7, quantity: 25, unit_price: "60.82", line_net: "1520.50", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1520.50" }, { id: 72, invoice_id: 6, line_no: 1, product_id: 14, quantity: 22, unit_price: "20.95", line_net: "460.90", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "460.90" }, { id: 73, invoice_id: 54, line_no: 1, product_id: 21, quantity: 19, unit_price: "188.00", line_net: "3572.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "714.40", line_gross: "4286.40" }, { id: 74, invoice_id: 231, line_no: 1, product_id: 18, quantity: 21, unit_price: "299.28", line_net: "6284.88", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1256.98", line_gross: "7541.86" }, { id: 75, invoice_id: 148, line_no: 2, product_id: 19, quantity: 22, unit_price: "369.92", line_net: "8138.24", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "8138.24" }, { id: 76, invoice_id: 77, line_no: 1, product_id: 25, quantity: 10, unit_price: "394.69", line_net: "3946.90", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "789.38", line_gross: "4736.28" }, { id: 77, invoice_id: 217, line_no: 1, product_id: 26, quantity: 18, unit_price: "469.01", line_net: "8442.18", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1688.44", line_gross: "10130.62" }, { id: 78, invoice_id: 194, line_no: 1, product_id: 27, quantity: 1, unit_price: "364.78", line_net: "364.78", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "364.78" }, { id: 79, invoice_id: 113, line_no: 3, product_id: 22, quantity: 22, unit_price: "369.19", line_net: "8122.18", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "8122.18" }, { id: 80, invoice_id: 7, line_no: 1, product_id: 18, quantity: 13, unit_price: "299.28", line_net: "3890.64", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "778.13", line_gross: "4668.77" }, { id: 81, invoice_id: 118, line_no: 1, product_id: 23, quantity: 17, unit_price: "182.75", line_net: "3106.75", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3106.75" }, { id: 82, invoice_id: 133, line_no: 1, product_id: 13, quantity: 6, unit_price: "451.47", line_net: "2708.82", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "541.76", line_gross: "3250.58" }, { id: 83, invoice_id: 10, line_no: 1, product_id: 14, quantity: 1, unit_price: "20.95", line_net: "20.95", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "20.95" }, { id: 84, invoice_id: 233, line_no: 1, product_id: 35, quantity: 4, unit_price: "185.30", line_net: "741.20", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "741.20" }, { id: 85, invoice_id: 71, line_no: 1, product_id: 6, quantity: 14, unit_price: "329.37", line_net: "4611.18", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "4611.18" }, { id: 86, invoice_id: 150, line_no: 1, product_id: 12, quantity: 1, unit_price: "55.02", line_net: "55.02", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "11.00", line_gross: "66.02" }, { id: 87, invoice_id: 223, line_no: 2, product_id: 34, quantity: 1, unit_price: "4.65", line_net: "4.65", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "4.65" }, { id: 88, invoice_id: 173, line_no: 1, product_id: 5, quantity: 11, unit_price: "320.63", line_net: "3526.93", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "705.39", line_gross: "4232.32" }, { id: 89, invoice_id: 148, line_no: 3, product_id: 14, quantity: 1, unit_price: "20.95", line_net: "20.95", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "20.95" }, { id: 90, invoice_id: 97, line_no: 1, product_id: 4, quantity: 1, unit_price: "147.40", line_net: "147.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "147.40" }, { id: 91, invoice_id: 223, line_no: 3, product_id: 5, quantity: 14, unit_price: "320.63", line_net: "4488.82", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "4488.82" }, { id: 92, invoice_id: 148, line_no: 4, product_id: 6, quantity: 22, unit_price: "329.37", line_net: "7246.14", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1449.23", line_gross: "8695.37" }, { id: 93, invoice_id: 76, line_no: 2, product_id: 24, quantity: 7, unit_price: "88.25", line_net: "617.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "123.55", line_gross: "741.30" }, { id: 94, invoice_id: 90, line_no: 1, product_id: 25, quantity: 16, unit_price: "394.69", line_net: "6315.04", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1263.01", line_gross: "7578.05" }, { id: 95, invoice_id: 8, line_no: 1, product_id: 7, quantity: 9, unit_price: "60.82", line_net: "547.38", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "109.48", line_gross: "656.86" }, { id: 96, invoice_id: 63, line_no: 1, product_id: 30, quantity: 7, unit_price: "98.11", line_net: "686.77", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "686.77" }, { id: 97, invoice_id: 204, line_no: 1, product_id: 19, quantity: 2, unit_price: "369.92", line_net: "739.84", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "739.84" }, { id: 98, invoice_id: 190, line_no: 1, product_id: 28, quantity: 23, unit_price: "356.72", line_net: "8204.56", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "8204.56" }, { id: 99, invoice_id: 200, line_no: 1, product_id: 16, quantity: 12, unit_price: "14.41", line_net: "172.92", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "34.58", line_gross: "207.50" }, { id: 100, invoice_id: 99, line_no: 1, product_id: 30, quantity: 2, unit_price: "98.11", line_net: "196.22", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "196.22" }, { id: 101, invoice_id: 64, line_no: 1, product_id: 7, quantity: 3, unit_price: "60.82", line_net: "182.46", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "182.46" }, { id: 102, invoice_id: 177, line_no: 1, product_id: 22, quantity: 1, unit_price: "369.19", line_net: "369.19", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "73.84", line_gross: "443.03" }, { id: 103, invoice_id: 124, line_no: 2, product_id: 11, quantity: 1, unit_price: "92.57", line_net: "92.57", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "18.51", line_gross: "111.08" }, { id: 104, invoice_id: 78, line_no: 2, product_id: 36, quantity: 19, unit_price: "36.25", line_net: "688.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "137.75", line_gross: "826.50" }, { id: 105, invoice_id: 154, line_no: 2, product_id: 24, quantity: 1, unit_price: "88.25", line_net: "88.25", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "88.25" }, { id: 106, invoice_id: 29, line_no: 1, product_id: 33, quantity: 19, unit_price: "5.66", line_net: "107.54", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "21.51", line_gross: "129.05" }, { id: 107, invoice_id: 60, line_no: 1, product_id: 25, quantity: 2, unit_price: "394.69", line_net: "789.38", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "157.88", line_gross: "947.26" }, { id: 108, invoice_id: 132, line_no: 1, product_id: 21, quantity: 13, unit_price: "188.00", line_net: "2444.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "488.80", line_gross: "2932.80" }, { id: 109, invoice_id: 168, line_no: 1, product_id: 31, quantity: 7, unit_price: "405.30", line_net: "2837.10", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "567.42", line_gross: "3404.52" }, { id: 110, invoice_id: 175, line_no: 1, product_id: 13, quantity: 23, unit_price: "451.47", line_net: "10383.81", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "2076.76", line_gross: "12460.57" }, { id: 111, invoice_id: 167, line_no: 1, product_id: 4, quantity: 6, unit_price: "147.40", line_net: "884.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "884.40" }, { id: 112, invoice_id: 46, line_no: 1, product_id: 30, quantity: 20, unit_price: "98.11", line_net: "1962.20", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1962.20" }, { id: 113, invoice_id: 141, line_no: 1, product_id: 9, quantity: 2, unit_price: "191.14", line_net: "382.28", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "76.46", line_gross: "458.74" }, { id: 114, invoice_id: 231, line_no: 2, product_id: 5, quantity: 20, unit_price: "320.63", line_net: "6412.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1282.52", line_gross: "7695.12" }, { id: 115, invoice_id: 200, line_no: 2, product_id: 4, quantity: 6, unit_price: "147.40", line_net: "884.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "884.40" }, { id: 116, invoice_id: 167, line_no: 2, product_id: 12, quantity: 19, unit_price: "55.02", line_net: "1045.38", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "209.08", line_gross: "1254.46" }, { id: 117, invoice_id: 25, line_no: 3, product_id: 14, quantity: 5, unit_price: "20.95", line_net: "104.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "104.75" }, { id: 118, invoice_id: 219, line_no: 1, product_id: 7, quantity: 4, unit_price: "60.82", line_net: "243.28", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "48.66", line_gross: "291.94" }, { id: 119, invoice_id: 143, line_no: 1, product_id: 3, quantity: 2, unit_price: "295.81", line_net: "591.62", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "118.32", line_gross: "709.94" }, { id: 120, invoice_id: 115, line_no: 1, product_id: 22, quantity: 8, unit_price: "369.19", line_net: "2953.52", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "590.70", line_gross: "3544.22" }, { id: 121, invoice_id: 12, line_no: 2, product_id: 6, quantity: 4, unit_price: "329.37", line_net: "1317.48", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "263.50", line_gross: "1580.98" }, { id: 122, invoice_id: 151, line_no: 1, product_id: 21, quantity: 3, unit_price: "188.00", line_net: "564.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "112.80", line_gross: "676.80" }, { id: 123, invoice_id: 99, line_no: 2, product_id: 20, quantity: 4, unit_price: "154.29", line_net: "617.16", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "123.43", line_gross: "740.59" }, { id: 124, invoice_id: 54, line_no: 2, product_id: 11, quantity: 7, unit_price: "92.57", line_net: "647.99", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "129.60", line_gross: "777.59" }, { id: 125, invoice_id: 200, line_no: 3, product_id: 21, quantity: 2, unit_price: "188.00", line_net: "376.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "75.20", line_gross: "451.20" }, { id: 126, invoice_id: 114, line_no: 1, product_id: 16, quantity: 21, unit_price: "14.41", line_net: "302.61", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "60.52", line_gross: "363.13" }, { id: 127, invoice_id: 68, line_no: 1, product_id: 3, quantity: 1, unit_price: "295.81", line_net: "295.81", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "295.81" }, { id: 128, invoice_id: 105, line_no: 1, product_id: 32, quantity: 5, unit_price: "8.27", line_net: "41.35", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "41.35" }, { id: 129, invoice_id: 120, line_no: 2, product_id: 25, quantity: 11, unit_price: "394.69", line_net: "4341.59", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "4341.59" }, { id: 130, invoice_id: 214, line_no: 1, product_id: 17, quantity: 2, unit_price: "183.18", line_net: "366.36", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "73.27", line_gross: "439.63" }, { id: 131, invoice_id: 83, line_no: 2, product_id: 7, quantity: 4, unit_price: "60.82", line_net: "243.28", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "243.28" }, { id: 132, invoice_id: 136, line_no: 1, product_id: 32, quantity: 9, unit_price: "8.27", line_net: "74.43", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "74.43" }, { id: 133, invoice_id: 207, line_no: 1, product_id: 11, quantity: 17, unit_price: "92.57", line_net: "1573.69", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1573.69" }, { id: 134, invoice_id: 103, line_no: 1, product_id: 34, quantity: 22, unit_price: "4.65", line_net: "102.30", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "102.30" }, { id: 135, invoice_id: 217, line_no: 2, product_id: 25, quantity: 16, unit_price: "394.69", line_net: "6315.04", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1263.01", line_gross: "7578.05" }, { id: 136, invoice_id: 108, line_no: 1, product_id: 33, quantity: 6, unit_price: "5.66", line_net: "33.96", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "33.96" }, { id: 137, invoice_id: 53, line_no: 2, product_id: 5, quantity: 2, unit_price: "320.63", line_net: "641.26", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "128.25", line_gross: "769.51" }, { id: 138, invoice_id: 112, line_no: 1, product_id: 31, quantity: 9, unit_price: "405.30", line_net: "3647.70", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3647.70" }, { id: 139, invoice_id: 69, line_no: 1, product_id: 25, quantity: 1, unit_price: "394.69", line_net: "394.69", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "78.94", line_gross: "473.63" }, { id: 140, invoice_id: 105, line_no: 2, product_id: 8, quantity: 18, unit_price: "66.25", line_net: "1192.50", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1192.50" }, { id: 141, invoice_id: 70, line_no: 1, product_id: 19, quantity: 2, unit_price: "369.92", line_net: "739.84", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "739.84" }, { id: 142, invoice_id: 177, line_no: 2, product_id: 7, quantity: 8, unit_price: "60.82", line_net: "486.56", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "97.31", line_gross: "583.87" }, { id: 143, invoice_id: 100, line_no: 2, product_id: 12, quantity: 2, unit_price: "55.02", line_net: "110.04", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "22.01", line_gross: "132.05" }, { id: 144, invoice_id: 32, line_no: 1, product_id: 9, quantity: 8, unit_price: "191.14", line_net: "1529.12", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1529.12" }, { id: 145, invoice_id: 46, line_no: 2, product_id: 18, quantity: 4, unit_price: "299.28", line_net: "1197.12", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "239.42", line_gross: "1436.54" }, { id: 146, invoice_id: 109, line_no: 1, product_id: 23, quantity: 7, unit_price: "182.75", line_net: "1279.25", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1279.25" }, { id: 147, invoice_id: 219, line_no: 2, product_id: 5, quantity: 23, unit_price: "320.63", line_net: "7374.49", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1474.90", line_gross: "8849.39" }, { id: 148, invoice_id: 19, line_no: 1, product_id: 3, quantity: 4, unit_price: "295.81", line_net: "1183.24", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "236.65", line_gross: "1419.89" }, { id: 149, invoice_id: 103, line_no: 2, product_id: 14, quantity: 9, unit_price: "20.95", line_net: "188.55", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "188.55" }, { id: 150, invoice_id: 193, line_no: 2, product_id: 21, quantity: 15, unit_price: "188.00", line_net: "2820.00", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2820.00" }, { id: 151, invoice_id: 232, line_no: 1, product_id: 23, quantity: 7, unit_price: "182.75", line_net: "1279.25", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "255.85", line_gross: "1535.10" }, { id: 152, invoice_id: 198, line_no: 1, product_id: 17, quantity: 10, unit_price: "183.18", line_net: "1831.80", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "366.36", line_gross: "2198.16" }, { id: 153, invoice_id: 109, line_no: 2, product_id: 21, quantity: 6, unit_price: "188.00", line_net: "1128.00", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1128.00" }, { id: 154, invoice_id: 125, line_no: 1, product_id: 16, quantity: 1, unit_price: "14.41", line_net: "14.41", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "14.41" }, { id: 155, invoice_id: 50, line_no: 1, product_id: 24, quantity: 2, unit_price: "88.25", line_net: "176.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "35.30", line_gross: "211.80" }, { id: 156, invoice_id: 212, line_no: 1, product_id: 30, quantity: 18, unit_price: "98.11", line_net: "1765.98", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1765.98" }, { id: 157, invoice_id: 60, line_no: 2, product_id: 27, quantity: 2, unit_price: "364.78", line_net: "729.56", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "145.91", line_gross: "875.47" }, { id: 158, invoice_id: 41, line_no: 1, product_id: 17, quantity: 1, unit_price: "183.18", line_net: "183.18", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "36.64", line_gross: "219.82" }, { id: 159, invoice_id: 217, line_no: 3, product_id: 11, quantity: 6, unit_price: "92.57", line_net: "555.42", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "111.08", line_gross: "666.50" }, { id: 160, invoice_id: 75, line_no: 2, product_id: 35, quantity: 2, unit_price: "185.30", line_net: "370.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "74.12", line_gross: "444.72" }, { id: 161, invoice_id: 129, line_no: 1, product_id: 32, quantity: 4, unit_price: "8.27", line_net: "33.08", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "6.62", line_gross: "39.70" }, { id: 162, invoice_id: 180, line_no: 1, product_id: 22, quantity: 4, unit_price: "369.19", line_net: "1476.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "295.35", line_gross: "1772.11" }, { id: 163, invoice_id: 205, line_no: 2, product_id: 26, quantity: 6, unit_price: "469.01", line_net: "2814.06", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "562.81", line_gross: "3376.87" }, { id: 164, invoice_id: 231, line_no: 3, product_id: 30, quantity: 10, unit_price: "98.11", line_net: "981.10", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "981.10" }, { id: 165, invoice_id: 194, line_no: 2, product_id: 31, quantity: 2, unit_price: "405.30", line_net: "810.60", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "810.60" }, { id: 166, invoice_id: 42, line_no: 1, product_id: 19, quantity: 22, unit_price: "369.92", line_net: "8138.24", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "8138.24" }, { id: 167, invoice_id: 140, line_no: 2, product_id: 9, quantity: 2, unit_price: "191.14", line_net: "382.28", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "382.28" }, { id: 168, invoice_id: 88, line_no: 1, product_id: 29, quantity: 19, unit_price: "274.56", line_net: "5216.64", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1043.33", line_gross: "6259.97" }, { id: 169, invoice_id: 178, line_no: 2, product_id: 21, quantity: 22, unit_price: "188.00", line_net: "4136.00", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "4136.00" }, { id: 170, invoice_id: 149, line_no: 1, product_id: 4, quantity: 5, unit_price: "147.40", line_net: "737.00", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "737.00" }, { id: 171, invoice_id: 214, line_no: 2, product_id: 6, quantity: 16, unit_price: "329.37", line_net: "5269.92", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1053.98", line_gross: "6323.90" }, { id: 172, invoice_id: 45, line_no: 1, product_id: 15, quantity: 3, unit_price: "159.71", line_net: "479.13", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "95.83", line_gross: "574.96" }, { id: 173, invoice_id: 168, line_no: 2, product_id: 8, quantity: 16, unit_price: "66.25", line_net: "1060.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "212.00", line_gross: "1272.00" }, { id: 174, invoice_id: 179, line_no: 1, product_id: 1, quantity: 15, unit_price: "144.99", line_net: "2174.85", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2174.85" }, { id: 175, invoice_id: 180, line_no: 2, product_id: 2, quantity: 4, unit_price: "261.86", line_net: "1047.44", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "209.49", line_gross: "1256.93" }, { id: 176, invoice_id: 174, line_no: 1, product_id: 32, quantity: 3, unit_price: "8.27", line_net: "24.81", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "4.96", line_gross: "29.77" }, { id: 177, invoice_id: 159, line_no: 1, product_id: 8, quantity: 6, unit_price: "66.25", line_net: "397.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "79.50", line_gross: "477.00" }, { id: 178, invoice_id: 8, line_no: 2, product_id: 9, quantity: 9, unit_price: "191.14", line_net: "1720.26", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "344.05", line_gross: "2064.31" }, { id: 179, invoice_id: 150, line_no: 2, product_id: 11, quantity: 2, unit_price: "92.57", line_net: "185.14", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "37.03", line_gross: "222.17" }, { id: 180, invoice_id: 14, line_no: 2, product_id: 28, quantity: 2, unit_price: "356.72", line_net: "713.44", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "142.69", line_gross: "856.13" }, { id: 181, invoice_id: 6, line_no: 2, product_id: 9, quantity: 8, unit_price: "191.14", line_net: "1529.12", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1529.12" }, { id: 182, invoice_id: 4, line_no: 2, product_id: 2, quantity: 17, unit_price: "261.86", line_net: "4451.62", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "890.32", line_gross: "5341.94" }, { id: 183, invoice_id: 229, line_no: 1, product_id: 25, quantity: 6, unit_price: "394.69", line_net: "2368.14", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "473.63", line_gross: "2841.77" }, { id: 184, invoice_id: 3, line_no: 1, product_id: 27, quantity: 1, unit_price: "364.78", line_net: "364.78", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "72.96", line_gross: "437.74" }, { id: 185, invoice_id: 110, line_no: 1, product_id: 15, quantity: 9, unit_price: "159.71", line_net: "1437.39", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "287.48", line_gross: "1724.87" }, { id: 186, invoice_id: 194, line_no: 3, product_id: 17, quantity: 10, unit_price: "183.18", line_net: "1831.80", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1831.80" }, { id: 187, invoice_id: 22, line_no: 2, product_id: 31, quantity: 7, unit_price: "405.30", line_net: "2837.10", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "567.42", line_gross: "3404.52" }, { id: 188, invoice_id: 181, line_no: 2, product_id: 13, quantity: 10, unit_price: "451.47", line_net: "4514.70", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "902.94", line_gross: "5417.64" }, { id: 189, invoice_id: 16, line_no: 2, product_id: 4, quantity: 2, unit_price: "147.40", line_net: "294.80", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "294.80" }, { id: 190, invoice_id: 58, line_no: 2, product_id: 20, quantity: 24, unit_price: "154.29", line_net: "3702.96", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "740.59", line_gross: "4443.55" }, { id: 191, invoice_id: 9, line_no: 2, product_id: 32, quantity: 2, unit_price: "8.27", line_net: "16.54", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "3.31", line_gross: "19.85" }, { id: 192, invoice_id: 188, line_no: 1, product_id: 22, quantity: 3, unit_price: "369.19", line_net: "1107.57", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1107.57" }, { id: 193, invoice_id: 103, line_no: 3, product_id: 22, quantity: 1, unit_price: "369.19", line_net: "369.19", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "369.19" }, { id: 194, invoice_id: 60, line_no: 3, product_id: 29, quantity: 21, unit_price: "274.56", line_net: "5765.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1153.15", line_gross: "6918.91" }, { id: 195, invoice_id: 14, line_no: 3, product_id: 1, quantity: 2, unit_price: "144.99", line_net: "289.98", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "58.00", line_gross: "347.98" }, { id: 196, invoice_id: 61, line_no: 2, product_id: 1, quantity: 24, unit_price: "144.99", line_net: "3479.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "695.95", line_gross: "4175.71" }, { id: 197, invoice_id: 37, line_no: 2, product_id: 5, quantity: 10, unit_price: "320.63", line_net: "3206.30", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "641.26", line_gross: "3847.56" }, { id: 198, invoice_id: 219, line_no: 3, product_id: 19, quantity: 8, unit_price: "369.92", line_net: "2959.36", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2959.36" }, { id: 199, invoice_id: 50, line_no: 2, product_id: 29, quantity: 1, unit_price: "274.56", line_net: "274.56", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "54.91", line_gross: "329.47" }, { id: 200, invoice_id: 211, line_no: 1, product_id: 5, quantity: 1, unit_price: "320.63", line_net: "320.63", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "320.63" }, { id: 201, invoice_id: 187, line_no: 1, product_id: 15, quantity: 7, unit_price: "159.71", line_net: "1117.97", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "223.59", line_gross: "1341.56" }, { id: 202, invoice_id: 40, line_no: 1, product_id: 12, quantity: 12, unit_price: "55.02", line_net: "660.24", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "660.24" }, { id: 203, invoice_id: 227, line_no: 1, product_id: 13, quantity: 8, unit_price: "451.47", line_net: "3611.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "722.35", line_gross: "4334.11" }, { id: 204, invoice_id: 164, line_no: 1, product_id: 4, quantity: 4, unit_price: "147.40", line_net: "589.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "589.60" }, { id: 205, invoice_id: 154, line_no: 3, product_id: 2, quantity: 2, unit_price: "261.86", line_net: "523.72", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "523.72" }, { id: 206, invoice_id: 228, line_no: 1, product_id: 25, quantity: 1, unit_price: "394.69", line_net: "394.69", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "394.69" }, { id: 207, invoice_id: 38, line_no: 1, product_id: 8, quantity: 1, unit_price: "66.25", line_net: "66.25", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "13.25", line_gross: "79.50" }, { id: 208, invoice_id: 222, line_no: 2, product_id: 1, quantity: 4, unit_price: "144.99", line_net: "579.96", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "115.99", line_gross: "695.95" }, { id: 209, invoice_id: 211, line_no: 2, product_id: 21, quantity: 9, unit_price: "188.00", line_net: "1692.00", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1692.00" }, { id: 210, invoice_id: 123, line_no: 1, product_id: 36, quantity: 24, unit_price: "36.25", line_net: "870.00", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "870.00" }, { id: 211, invoice_id: 33, line_no: 1, product_id: 34, quantity: 4, unit_price: "4.65", line_net: "18.60", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "18.60" }, { id: 212, invoice_id: 154, line_no: 4, product_id: 1, quantity: 2, unit_price: "144.99", line_net: "289.98", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "289.98" }, { id: 213, invoice_id: 193, line_no: 3, product_id: 10, quantity: 4, unit_price: "288.31", line_net: "1153.24", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1153.24" }, { id: 214, invoice_id: 230, line_no: 1, product_id: 7, quantity: 22, unit_price: "60.82", line_net: "1338.04", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1338.04" }, { id: 215, invoice_id: 16, line_no: 3, product_id: 7, quantity: 2, unit_price: "60.82", line_net: "121.64", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "24.33", line_gross: "145.97" }, { id: 216, invoice_id: 220, line_no: 2, product_id: 7, quantity: 14, unit_price: "60.82", line_net: "851.48", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "170.30", line_gross: "1021.78" }, { id: 217, invoice_id: 210, line_no: 1, product_id: 29, quantity: 1, unit_price: "274.56", line_net: "274.56", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "54.91", line_gross: "329.47" }, { id: 218, invoice_id: 135, line_no: 1, product_id: 12, quantity: 13, unit_price: "55.02", line_net: "715.26", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "143.05", line_gross: "858.31" }, { id: 219, invoice_id: 160, line_no: 3, product_id: 7, quantity: 16, unit_price: "60.82", line_net: "973.12", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "973.12" }, { id: 220, invoice_id: 127, line_no: 2, product_id: 26, quantity: 21, unit_price: "469.01", line_net: "9849.21", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1969.84", line_gross: "11819.05" }, { id: 221, invoice_id: 221, line_no: 1, product_id: 33, quantity: 2, unit_price: "5.66", line_net: "11.32", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "2.26", line_gross: "13.58" }, { id: 222, invoice_id: 72, line_no: 2, product_id: 10, quantity: 1, unit_price: "288.31", line_net: "288.31", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "57.66", line_gross: "345.97" }, { id: 223, invoice_id: 151, line_no: 2, product_id: 21, quantity: 3, unit_price: "188.00", line_net: "564.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "112.80", line_gross: "676.80" }, { id: 224, invoice_id: 79, line_no: 3, product_id: 18, quantity: 18, unit_price: "299.28", line_net: "5387.04", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1077.41", line_gross: "6464.45" }, { id: 225, invoice_id: 107, line_no: 1, product_id: 17, quantity: 4, unit_price: "183.18", line_net: "732.72", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "146.54", line_gross: "879.26" }, { id: 226, invoice_id: 28, line_no: 2, product_id: 27, quantity: 1, unit_price: "364.78", line_net: "364.78", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "72.96", line_gross: "437.74" }, { id: 227, invoice_id: 33, line_no: 2, product_id: 3, quantity: 5, unit_price: "295.81", line_net: "1479.05", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1479.05" }, { id: 228, invoice_id: 55, line_no: 1, product_id: 25, quantity: 9, unit_price: "394.69", line_net: "3552.21", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "710.44", line_gross: "4262.65" }, { id: 229, invoice_id: 168, line_no: 3, product_id: 16, quantity: 25, unit_price: "14.41", line_net: "360.25", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "72.05", line_gross: "432.30" }, { id: 230, invoice_id: 208, line_no: 2, product_id: 12, quantity: 13, unit_price: "55.02", line_net: "715.26", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "143.05", line_gross: "858.31" }, { id: 231, invoice_id: 169, line_no: 1, product_id: 20, quantity: 7, unit_price: "154.29", line_net: "1080.03", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "216.01", line_gross: "1296.04" }, { id: 232, invoice_id: 41, line_no: 2, product_id: 10, quantity: 4, unit_price: "288.31", line_net: "1153.24", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "230.65", line_gross: "1383.89" }, { id: 233, invoice_id: 213, line_no: 1, product_id: 29, quantity: 1, unit_price: "274.56", line_net: "274.56", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "274.56" }, { id: 234, invoice_id: 59, line_no: 1, product_id: 26, quantity: 10, unit_price: "469.01", line_net: "4690.10", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "4690.10" }, { id: 235, invoice_id: 73, line_no: 1, product_id: 2, quantity: 20, unit_price: "261.86", line_net: "5237.20", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "5237.20" }, { id: 236, invoice_id: 57, line_no: 1, product_id: 10, quantity: 3, unit_price: "288.31", line_net: "864.93", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "172.99", line_gross: "1037.92" }, { id: 237, invoice_id: 232, line_no: 2, product_id: 24, quantity: 2, unit_price: "88.25", line_net: "176.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "35.30", line_gross: "211.80" }, { id: 238, invoice_id: 206, line_no: 1, product_id: 9, quantity: 8, unit_price: "191.14", line_net: "1529.12", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "305.82", line_gross: "1834.94" }, { id: 239, invoice_id: 78, line_no: 3, product_id: 19, quantity: 23, unit_price: "369.92", line_net: "8508.16", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "8508.16" }, { id: 240, invoice_id: 86, line_no: 1, product_id: 15, quantity: 1, unit_price: "159.71", line_net: "159.71", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "31.94", line_gross: "191.65" }, { id: 241, invoice_id: 18, line_no: 2, product_id: 16, quantity: 7, unit_price: "14.41", line_net: "100.87", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "100.87" }, { id: 242, invoice_id: 54, line_no: 3, product_id: 3, quantity: 3, unit_price: "295.81", line_net: "887.43", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "177.49", line_gross: "1064.92" }, { id: 243, invoice_id: 96, line_no: 1, product_id: 24, quantity: 6, unit_price: "88.25", line_net: "529.50", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "529.50" }, { id: 244, invoice_id: 99, line_no: 3, product_id: 10, quantity: 7, unit_price: "288.31", line_net: "2018.17", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "403.63", line_gross: "2421.80" }, { id: 245, invoice_id: 78, line_no: 4, product_id: 25, quantity: 1, unit_price: "394.69", line_net: "394.69", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "78.94", line_gross: "473.63" }, { id: 246, invoice_id: 56, line_no: 1, product_id: 1, quantity: 1, unit_price: "144.99", line_net: "144.99", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "29.00", line_gross: "173.99" }, { id: 247, invoice_id: 66, line_no: 1, product_id: 36, quantity: 3, unit_price: "36.25", line_net: "108.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "21.75", line_gross: "130.50" }, { id: 248, invoice_id: 105, line_no: 3, product_id: 27, quantity: 23, unit_price: "364.78", line_net: "8389.94", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "8389.94" }, { id: 249, invoice_id: 1, line_no: 1, product_id: 8, quantity: 15, unit_price: "66.25", line_net: "993.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "198.75", line_gross: "1192.50" }, { id: 250, invoice_id: 49, line_no: 1, product_id: 33, quantity: 2, unit_price: "5.66", line_net: "11.32", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "11.32" }, { id: 251, invoice_id: 211, line_no: 3, product_id: 15, quantity: 2, unit_price: "159.71", line_net: "319.42", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "319.42" }, { id: 252, invoice_id: 13, line_no: 1, product_id: 3, quantity: 1, unit_price: "295.81", line_net: "295.81", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "59.16", line_gross: "354.97" }, { id: 253, invoice_id: 117, line_no: 1, product_id: 34, quantity: 2, unit_price: "4.65", line_net: "9.30", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1.86", line_gross: "11.16" }, { id: 254, invoice_id: 6, line_no: 3, product_id: 14, quantity: 18, unit_price: "20.95", line_net: "377.10", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "377.10" }, { id: 255, invoice_id: 61, line_no: 3, product_id: 22, quantity: 4, unit_price: "369.19", line_net: "1476.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "295.35", line_gross: "1772.11" }, { id: 256, invoice_id: 10, line_no: 2, product_id: 15, quantity: 3, unit_price: "159.71", line_net: "479.13", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "95.83", line_gross: "574.96" }, { id: 257, invoice_id: 17, line_no: 1, product_id: 28, quantity: 20, unit_price: "356.72", line_net: "7134.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1426.88", line_gross: "8561.28" }, { id: 258, invoice_id: 221, line_no: 2, product_id: 19, quantity: 5, unit_price: "369.92", line_net: "1849.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1849.60" }, { id: 259, invoice_id: 209, line_no: 1, product_id: 18, quantity: 3, unit_price: "299.28", line_net: "897.84", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "897.84" }, { id: 260, invoice_id: 151, line_no: 3, product_id: 11, quantity: 1, unit_price: "92.57", line_net: "92.57", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "18.51", line_gross: "111.08" }, { id: 261, invoice_id: 126, line_no: 2, product_id: 15, quantity: 3, unit_price: "159.71", line_net: "479.13", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "95.83", line_gross: "574.96" }, { id: 262, invoice_id: 137, line_no: 1, product_id: 3, quantity: 14, unit_price: "295.81", line_net: "4141.34", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "828.27", line_gross: "4969.61" }, { id: 263, invoice_id: 217, line_no: 4, product_id: 5, quantity: 6, unit_price: "320.63", line_net: "1923.78", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "384.76", line_gross: "2308.54" }, { id: 264, invoice_id: 73, line_no: 2, product_id: 2, quantity: 24, unit_price: "261.86", line_net: "6284.64", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "6284.64" }, { id: 265, invoice_id: 178, line_no: 3, product_id: 19, quantity: 17, unit_price: "369.92", line_net: "6288.64", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "6288.64" }, { id: 266, invoice_id: 113, line_no: 4, product_id: 35, quantity: 5, unit_price: "185.30", line_net: "926.50", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "926.50" }, { id: 267, invoice_id: 61, line_no: 4, product_id: 27, quantity: 9, unit_price: "364.78", line_net: "3283.02", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "656.60", line_gross: "3939.62" }, { id: 268, invoice_id: 84, line_no: 1, product_id: 33, quantity: 24, unit_price: "5.66", line_net: "135.84", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "135.84" }, { id: 269, invoice_id: 33, line_no: 3, product_id: 16, quantity: 12, unit_price: "14.41", line_net: "172.92", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "172.92" }, { id: 270, invoice_id: 149, line_no: 2, product_id: 11, quantity: 11, unit_price: "92.57", line_net: "1018.27", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1018.27" }, { id: 271, invoice_id: 71, line_no: 2, product_id: 34, quantity: 16, unit_price: "4.65", line_net: "74.40", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "74.40" }, { id: 272, invoice_id: 202, line_no: 1, product_id: 35, quantity: 6, unit_price: "185.30", line_net: "1111.80", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "222.36", line_gross: "1334.16" }, { id: 273, invoice_id: 26, line_no: 2, product_id: 26, quantity: 21, unit_price: "469.01", line_net: "9849.21", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1969.84", line_gross: "11819.05" }, { id: 274, invoice_id: 151, line_no: 4, product_id: 28, quantity: 2, unit_price: "356.72", line_net: "713.44", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "142.69", line_gross: "856.13" }, { id: 275, invoice_id: 211, line_no: 4, product_id: 3, quantity: 1, unit_price: "295.81", line_net: "295.81", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "295.81" }, { id: 276, invoice_id: 54, line_no: 4, product_id: 36, quantity: 3, unit_price: "36.25", line_net: "108.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "21.75", line_gross: "130.50" }, { id: 277, invoice_id: 140, line_no: 3, product_id: 20, quantity: 2, unit_price: "154.29", line_net: "308.58", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "308.58" }, { id: 278, invoice_id: 171, line_no: 1, product_id: 8, quantity: 5, unit_price: "66.25", line_net: "331.25", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "66.25", line_gross: "397.50" }, { id: 279, invoice_id: 208, line_no: 3, product_id: 14, quantity: 5, unit_price: "20.95", line_net: "104.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "104.75" }, { id: 280, invoice_id: 102, line_no: 1, product_id: 17, quantity: 16, unit_price: "183.18", line_net: "2930.88", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "586.18", line_gross: "3517.06" }, { id: 281, invoice_id: 165, line_no: 1, product_id: 4, quantity: 1, unit_price: "147.40", line_net: "147.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "147.40" }, { id: 282, invoice_id: 221, line_no: 3, product_id: 12, quantity: 1, unit_price: "55.02", line_net: "55.02", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "11.00", line_gross: "66.02" }, { id: 283, invoice_id: 10, line_no: 3, product_id: 14, quantity: 4, unit_price: "20.95", line_net: "83.80", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "83.80" }, { id: 284, invoice_id: 67, line_no: 1, product_id: 24, quantity: 5, unit_price: "88.25", line_net: "441.25", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "88.25", line_gross: "529.50" }, { id: 285, invoice_id: 215, line_no: 2, product_id: 10, quantity: 3, unit_price: "288.31", line_net: "864.93", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "172.99", line_gross: "1037.92" }, { id: 286, invoice_id: 80, line_no: 1, product_id: 14, quantity: 5, unit_price: "20.95", line_net: "104.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "104.75" }, { id: 287, invoice_id: 195, line_no: 1, product_id: 18, quantity: 10, unit_price: "299.28", line_net: "2992.80", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2992.80" }, { id: 288, invoice_id: 222, line_no: 3, product_id: 6, quantity: 4, unit_price: "329.37", line_net: "1317.48", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "263.50", line_gross: "1580.98" }, { id: 289, invoice_id: 28, line_no: 3, product_id: 34, quantity: 1, unit_price: "4.65", line_net: "4.65", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "0.93", line_gross: "5.58" }, { id: 290, invoice_id: 74, line_no: 2, product_id: 35, quantity: 7, unit_price: "185.30", line_net: "1297.10", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1297.10" }, { id: 291, invoice_id: 167, line_no: 3, product_id: 7, quantity: 7, unit_price: "60.82", line_net: "425.74", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "85.15", line_gross: "510.89" }, { id: 292, invoice_id: 41, line_no: 3, product_id: 25, quantity: 4, unit_price: "394.69", line_net: "1578.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "315.75", line_gross: "1894.51" }, { id: 293, invoice_id: 43, line_no: 3, product_id: 3, quantity: 1, unit_price: "295.81", line_net: "295.81", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "295.81" }, { id: 294, invoice_id: 91, line_no: 1, product_id: 5, quantity: 12, unit_price: "320.63", line_net: "3847.56", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "769.51", line_gross: "4617.07" }, { id: 295, invoice_id: 71, line_no: 3, product_id: 22, quantity: 21, unit_price: "369.19", line_net: "7752.99", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "7752.99" }, { id: 296, invoice_id: 11, line_no: 1, product_id: 32, quantity: 2, unit_price: "8.27", line_net: "16.54", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "16.54" }, { id: 297, invoice_id: 173, line_no: 2, product_id: 33, quantity: 25, unit_price: "5.66", line_net: "141.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "28.30", line_gross: "169.80" }, { id: 298, invoice_id: 233, line_no: 2, product_id: 8, quantity: 5, unit_price: "66.25", line_net: "331.25", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "331.25" }, { id: 299, invoice_id: 165, line_no: 2, product_id: 17, quantity: 5, unit_price: "183.18", line_net: "915.90", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "183.18", line_gross: "1099.08" }, { id: 300, invoice_id: 229, line_no: 2, product_id: 27, quantity: 23, unit_price: "364.78", line_net: "8389.94", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1677.99", line_gross: "10067.93" }, { id: 301, invoice_id: 118, line_no: 2, product_id: 23, quantity: 5, unit_price: "182.75", line_net: "913.75", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "913.75" }, { id: 302, invoice_id: 53, line_no: 3, product_id: 13, quantity: 11, unit_price: "451.47", line_net: "4966.17", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "993.23", line_gross: "5959.40" }, { id: 303, invoice_id: 87, line_no: 1, product_id: 11, quantity: 12, unit_price: "92.57", line_net: "1110.84", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "222.17", line_gross: "1333.01" }, { id: 304, invoice_id: 168, line_no: 4, product_id: 1, quantity: 22, unit_price: "144.99", line_net: "3189.78", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "637.96", line_gross: "3827.74" }, { id: 305, invoice_id: 79, line_no: 4, product_id: 5, quantity: 22, unit_price: "320.63", line_net: "7053.86", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1410.77", line_gross: "8464.63" }, { id: 306, invoice_id: 120, line_no: 3, product_id: 36, quantity: 13, unit_price: "36.25", line_net: "471.25", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "471.25" }, { id: 307, invoice_id: 131, line_no: 2, product_id: 23, quantity: 2, unit_price: "182.75", line_net: "365.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "73.10", line_gross: "438.60" }, { id: 308, invoice_id: 118, line_no: 3, product_id: 5, quantity: 21, unit_price: "320.63", line_net: "6733.23", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "6733.23" }, { id: 309, invoice_id: 109, line_no: 3, product_id: 6, quantity: 5, unit_price: "329.37", line_net: "1646.85", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1646.85" }, { id: 310, invoice_id: 46, line_no: 3, product_id: 13, quantity: 4, unit_price: "451.47", line_net: "1805.88", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "361.18", line_gross: "2167.06" }, { id: 311, invoice_id: 199, line_no: 1, product_id: 33, quantity: 6, unit_price: "5.66", line_net: "33.96", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "6.79", line_gross: "40.75" }, { id: 312, invoice_id: 156, line_no: 2, product_id: 2, quantity: 4, unit_price: "261.86", line_net: "1047.44", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1047.44" }, { id: 313, invoice_id: 146, line_no: 1, product_id: 26, quantity: 15, unit_price: "469.01", line_net: "7035.15", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1407.03", line_gross: "8442.18" }, { id: 314, invoice_id: 39, line_no: 1, product_id: 32, quantity: 4, unit_price: "8.27", line_net: "33.08", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "6.62", line_gross: "39.70" }, { id: 315, invoice_id: 130, line_no: 1, product_id: 3, quantity: 2, unit_price: "295.81", line_net: "591.62", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "118.32", line_gross: "709.94" }, { id: 316, invoice_id: 192, line_no: 1, product_id: 4, quantity: 1, unit_price: "147.40", line_net: "147.40", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "147.40" }, { id: 317, invoice_id: 94, line_no: 1, product_id: 17, quantity: 18, unit_price: "183.18", line_net: "3297.24", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "659.45", line_gross: "3956.69" }, { id: 318, invoice_id: 22, line_no: 3, product_id: 32, quantity: 14, unit_price: "8.27", line_net: "115.78", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "23.16", line_gross: "138.94" }, { id: 319, invoice_id: 165, line_no: 3, product_id: 14, quantity: 8, unit_price: "20.95", line_net: "167.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "167.60" }, { id: 320, invoice_id: 110, line_no: 2, product_id: 23, quantity: 2, unit_price: "182.75", line_net: "365.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "73.10", line_gross: "438.60" }, { id: 321, invoice_id: 119, line_no: 1, product_id: 6, quantity: 7, unit_price: "329.37", line_net: "2305.59", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "461.12", line_gross: "2766.71" }, { id: 322, invoice_id: 218, line_no: 1, product_id: 18, quantity: 12, unit_price: "299.28", line_net: "3591.36", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3591.36" }, { id: 323, invoice_id: 194, line_no: 4, product_id: 27, quantity: 1, unit_price: "364.78", line_net: "364.78", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "364.78" }, { id: 324, invoice_id: 11, line_no: 2, product_id: 4, quantity: 1, unit_price: "147.40", line_net: "147.40", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "147.40" }, { id: 325, invoice_id: 34, line_no: 2, product_id: 22, quantity: 2, unit_price: "369.19", line_net: "738.38", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "147.68", line_gross: "886.06" }, { id: 326, invoice_id: 213, line_no: 2, product_id: 32, quantity: 20, unit_price: "8.27", line_net: "165.40", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "165.40" }, { id: 327, invoice_id: 16, line_no: 4, product_id: 29, quantity: 3, unit_price: "274.56", line_net: "823.68", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "164.74", line_gross: "988.42" }, { id: 328, invoice_id: 77, line_no: 2, product_id: 9, quantity: 24, unit_price: "191.14", line_net: "4587.36", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "917.47", line_gross: "5504.83" }, { id: 329, invoice_id: 22, line_no: 4, product_id: 33, quantity: 4, unit_price: "5.66", line_net: "22.64", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "4.53", line_gross: "27.17" }, { id: 330, invoice_id: 157, line_no: 1, product_id: 9, quantity: 14, unit_price: "191.14", line_net: "2675.96", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "535.19", line_gross: "3211.15" }, { id: 331, invoice_id: 142, line_no: 1, product_id: 6, quantity: 3, unit_price: "329.37", line_net: "988.11", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "197.62", line_gross: "1185.73" }, { id: 332, invoice_id: 127, line_no: 3, product_id: 13, quantity: 8, unit_price: "451.47", line_net: "3611.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "722.35", line_gross: "4334.11" }, { id: 333, invoice_id: 92, line_no: 1, product_id: 19, quantity: 20, unit_price: "369.92", line_net: "7398.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "7398.40" }, { id: 334, invoice_id: 145, line_no: 2, product_id: 7, quantity: 2, unit_price: "60.82", line_net: "121.64", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "24.33", line_gross: "145.97" }, { id: 335, invoice_id: 202, line_no: 2, product_id: 17, quantity: 1, unit_price: "183.18", line_net: "183.18", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "36.64", line_gross: "219.82" }, { id: 336, invoice_id: 107, line_no: 2, product_id: 26, quantity: 12, unit_price: "469.01", line_net: "5628.12", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1125.62", line_gross: "6753.74" }, { id: 337, invoice_id: 39, line_no: 2, product_id: 27, quantity: 12, unit_price: "364.78", line_net: "4377.36", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "875.47", line_gross: "5252.83" }, { id: 338, invoice_id: 93, line_no: 1, product_id: 22, quantity: 2, unit_price: "369.19", line_net: "738.38", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "738.38" }, { id: 339, invoice_id: 99, line_no: 4, product_id: 12, quantity: 4, unit_price: "55.02", line_net: "220.08", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "44.02", line_gross: "264.10" }, { id: 340, invoice_id: 140, line_no: 4, product_id: 2, quantity: 24, unit_price: "261.86", line_net: "6284.64", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "6284.64" }, { id: 341, invoice_id: 202, line_no: 3, product_id: 18, quantity: 8, unit_price: "299.28", line_net: "2394.24", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "478.85", line_gross: "2873.09" }, { id: 342, invoice_id: 216, line_no: 1, product_id: 11, quantity: 7, unit_price: "92.57", line_net: "647.99", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "129.60", line_gross: "777.59" }, { id: 343, invoice_id: 25, line_no: 4, product_id: 5, quantity: 14, unit_price: "320.63", line_net: "4488.82", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "897.76", line_gross: "5386.58" }, { id: 344, invoice_id: 41, line_no: 4, product_id: 4, quantity: 2, unit_price: "147.40", line_net: "294.80", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "294.80" }, { id: 345, invoice_id: 59, line_no: 2, product_id: 10, quantity: 1, unit_price: "288.31", line_net: "288.31", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "288.31" }, { id: 346, invoice_id: 35, line_no: 1, product_id: 6, quantity: 16, unit_price: "329.37", line_net: "5269.92", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1053.98", line_gross: "6323.90" }, { id: 347, invoice_id: 67, line_no: 2, product_id: 24, quantity: 23, unit_price: "88.25", line_net: "2029.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "405.95", line_gross: "2435.70" }, { id: 348, invoice_id: 73, line_no: 3, product_id: 34, quantity: 2, unit_price: "4.65", line_net: "9.30", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "9.30" }, { id: 349, invoice_id: 192, line_no: 2, product_id: 7, quantity: 13, unit_price: "60.82", line_net: "790.66", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "790.66" }, { id: 350, invoice_id: 202, line_no: 4, product_id: 21, quantity: 2, unit_price: "188.00", line_net: "376.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "75.20", line_gross: "451.20" }, { id: 351, invoice_id: 175, line_no: 2, product_id: 32, quantity: 4, unit_price: "8.27", line_net: "33.08", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "6.62", line_gross: "39.70" }, { id: 352, invoice_id: 106, line_no: 1, product_id: 4, quantity: 1, unit_price: "147.40", line_net: "147.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "147.40" }, { id: 353, invoice_id: 14, line_no: 4, product_id: 29, quantity: 14, unit_price: "274.56", line_net: "3843.84", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "768.77", line_gross: "4612.61" }, { id: 354, invoice_id: 121, line_no: 1, product_id: 36, quantity: 16, unit_price: "36.25", line_net: "580.00", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "580.00" }, { id: 355, invoice_id: 168, line_no: 5, product_id: 29, quantity: 2, unit_price: "274.56", line_net: "549.12", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "109.82", line_gross: "658.94" }, { id: 356, invoice_id: 143, line_no: 2, product_id: 1, quantity: 5, unit_price: "144.99", line_net: "724.95", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "144.99", line_gross: "869.94" }, { id: 357, invoice_id: 20, line_no: 2, product_id: 11, quantity: 15, unit_price: "92.57", line_net: "1388.55", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "277.71", line_gross: "1666.26" }, { id: 358, invoice_id: 97, line_no: 2, product_id: 28, quantity: 9, unit_price: "356.72", line_net: "3210.48", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "642.10", line_gross: "3852.58" }, { id: 359, invoice_id: 2, line_no: 2, product_id: 17, quantity: 5, unit_price: "183.18", line_net: "915.90", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "183.18", line_gross: "1099.08" }, { id: 360, invoice_id: 173, line_no: 3, product_id: 31, quantity: 7, unit_price: "405.30", line_net: "2837.10", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "567.42", line_gross: "3404.52" }, { id: 361, invoice_id: 20, line_no: 3, product_id: 14, quantity: 12, unit_price: "20.95", line_net: "251.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "251.40" }, { id: 362, invoice_id: 171, line_no: 2, product_id: 8, quantity: 6, unit_price: "66.25", line_net: "397.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "79.50", line_gross: "477.00" }, { id: 363, invoice_id: 175, line_no: 3, product_id: 27, quantity: 18, unit_price: "364.78", line_net: "6566.04", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1313.21", line_gross: "7879.25" }, { id: 364, invoice_id: 23, line_no: 2, product_id: 23, quantity: 9, unit_price: "182.75", line_net: "1644.75", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1644.75" }, { id: 365, invoice_id: 152, line_no: 1, product_id: 31, quantity: 1, unit_price: "405.30", line_net: "405.30", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "81.06", line_gross: "486.36" }, { id: 366, invoice_id: 130, line_no: 2, product_id: 25, quantity: 1, unit_price: "394.69", line_net: "394.69", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "78.94", line_gross: "473.63" }, { id: 367, invoice_id: 77, line_no: 3, product_id: 2, quantity: 25, unit_price: "261.86", line_net: "6546.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1309.30", line_gross: "7855.80" }, { id: 368, invoice_id: 214, line_no: 3, product_id: 24, quantity: 12, unit_price: "88.25", line_net: "1059.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "211.80", line_gross: "1270.80" }, { id: 369, invoice_id: 143, line_no: 3, product_id: 14, quantity: 21, unit_price: "20.95", line_net: "439.95", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "439.95" }, { id: 370, invoice_id: 232, line_no: 3, product_id: 25, quantity: 19, unit_price: "394.69", line_net: "7499.11", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1499.82", line_gross: "8998.93" }, { id: 371, invoice_id: 16, line_no: 5, product_id: 24, quantity: 10, unit_price: "88.25", line_net: "882.50", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "176.50", line_gross: "1059.00" }, { id: 372, invoice_id: 115, line_no: 2, product_id: 36, quantity: 1, unit_price: "36.25", line_net: "36.25", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "7.25", line_gross: "43.50" }, { id: 373, invoice_id: 160, line_no: 4, product_id: 20, quantity: 3, unit_price: "154.29", line_net: "462.87", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "462.87" }, { id: 374, invoice_id: 223, line_no: 4, product_id: 24, quantity: 4, unit_price: "88.25", line_net: "353.00", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "353.00" }, { id: 375, invoice_id: 129, line_no: 2, product_id: 8, quantity: 12, unit_price: "66.25", line_net: "795.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "159.00", line_gross: "954.00" }, { id: 376, invoice_id: 80, line_no: 2, product_id: 17, quantity: 1, unit_price: "183.18", line_net: "183.18", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "36.64", line_gross: "219.82" }, { id: 377, invoice_id: 146, line_no: 2, product_id: 21, quantity: 6, unit_price: "188.00", line_net: "1128.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "225.60", line_gross: "1353.60" }, { id: 378, invoice_id: 49, line_no: 2, product_id: 4, quantity: 8, unit_price: "147.40", line_net: "1179.20", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1179.20" }, { id: 379, invoice_id: 18, line_no: 3, product_id: 23, quantity: 11, unit_price: "182.75", line_net: "2010.25", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2010.25" }, { id: 380, invoice_id: 12, line_no: 3, product_id: 15, quantity: 20, unit_price: "159.71", line_net: "3194.20", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "638.84", line_gross: "3833.04" }, { id: 381, invoice_id: 28, line_no: 4, product_id: 15, quantity: 2, unit_price: "159.71", line_net: "319.42", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "63.88", line_gross: "383.30" }, { id: 382, invoice_id: 225, line_no: 1, product_id: 31, quantity: 1, unit_price: "405.30", line_net: "405.30", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "81.06", line_gross: "486.36" }, { id: 383, invoice_id: 192, line_no: 3, product_id: 14, quantity: 8, unit_price: "20.95", line_net: "167.60", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "167.60" }, { id: 384, invoice_id: 189, line_no: 2, product_id: 34, quantity: 13, unit_price: "4.65", line_net: "60.45", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "12.09", line_gross: "72.54" }, { id: 385, invoice_id: 81, line_no: 1, product_id: 15, quantity: 2, unit_price: "159.71", line_net: "319.42", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "63.88", line_gross: "383.30" }, { id: 386, invoice_id: 204, line_no: 2, product_id: 34, quantity: 22, unit_price: "4.65", line_net: "102.30", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "20.46", line_gross: "122.76" }, { id: 387, invoice_id: 78, line_no: 5, product_id: 24, quantity: 3, unit_price: "88.25", line_net: "264.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "52.95", line_gross: "317.70" }, { id: 388, invoice_id: 82, line_no: 1, product_id: 13, quantity: 11, unit_price: "451.47", line_net: "4966.17", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "993.23", line_gross: "5959.40" }, { id: 389, invoice_id: 162, line_no: 1, product_id: 19, quantity: 22, unit_price: "369.92", line_net: "8138.24", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "8138.24" }, { id: 390, invoice_id: 184, line_no: 1, product_id: 4, quantity: 2, unit_price: "147.40", line_net: "294.80", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "294.80" }, { id: 391, invoice_id: 101, line_no: 1, product_id: 23, quantity: 18, unit_price: "182.75", line_net: "3289.50", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3289.50" }, { id: 392, invoice_id: 74, line_no: 3, product_id: 6, quantity: 10, unit_price: "329.37", line_net: "3293.70", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3293.70" }, { id: 393, invoice_id: 226, line_no: 1, product_id: 7, quantity: 18, unit_price: "60.82", line_net: "1094.76", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1094.76" }, { id: 394, invoice_id: 226, line_no: 2, product_id: 33, quantity: 1, unit_price: "5.66", line_net: "5.66", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "5.66" }, { id: 395, invoice_id: 232, line_no: 4, product_id: 18, quantity: 5, unit_price: "299.28", line_net: "1496.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "299.28", line_gross: "1795.68" }, { id: 396, invoice_id: 80, line_no: 3, product_id: 23, quantity: 19, unit_price: "182.75", line_net: "3472.25", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "694.45", line_gross: "4166.70" }, { id: 397, invoice_id: 233, line_no: 3, product_id: 19, quantity: 2, unit_price: "369.92", line_net: "739.84", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "739.84" }, { id: 398, invoice_id: 211, line_no: 5, product_id: 24, quantity: 5, unit_price: "88.25", line_net: "441.25", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "441.25" }, { id: 399, invoice_id: 59, line_no: 3, product_id: 29, quantity: 1, unit_price: "274.56", line_net: "274.56", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "274.56" }, { id: 400, invoice_id: 46, line_no: 4, product_id: 30, quantity: 10, unit_price: "98.11", line_net: "981.10", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "981.10" }, { id: 401, invoice_id: 53, line_no: 4, product_id: 19, quantity: 4, unit_price: "369.92", line_net: "1479.68", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1479.68" }, { id: 402, invoice_id: 172, line_no: 1, product_id: 33, quantity: 5, unit_price: "5.66", line_net: "28.30", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "5.66", line_gross: "33.96" }, { id: 403, invoice_id: 80, line_no: 4, product_id: 5, quantity: 21, unit_price: "320.63", line_net: "6733.23", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1346.65", line_gross: "8079.88" }, { id: 404, invoice_id: 158, line_no: 1, product_id: 5, quantity: 17, unit_price: "320.63", line_net: "5450.71", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "5450.71" }, { id: 405, invoice_id: 217, line_no: 5, product_id: 33, quantity: 1, unit_price: "5.66", line_net: "5.66", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1.13", line_gross: "6.79" }, { id: 406, invoice_id: 44, line_no: 1, product_id: 13, quantity: 6, unit_price: "451.47", line_net: "2708.82", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2708.82" }, { id: 407, invoice_id: 53, line_no: 5, product_id: 1, quantity: 3, unit_price: "144.99", line_net: "434.97", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "86.99", line_gross: "521.96" }, { id: 408, invoice_id: 6, line_no: 4, product_id: 12, quantity: 2, unit_price: "55.02", line_net: "110.04", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "110.04" }, { id: 409, invoice_id: 180, line_no: 3, product_id: 28, quantity: 5, unit_price: "356.72", line_net: "1783.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "356.72", line_gross: "2140.32" }, { id: 410, invoice_id: 173, line_no: 4, product_id: 6, quantity: 2, unit_price: "329.37", line_net: "658.74", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "131.75", line_gross: "790.49" }, { id: 411, invoice_id: 56, line_no: 2, product_id: 9, quantity: 19, unit_price: "191.14", line_net: "3631.66", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "726.33", line_gross: "4357.99" }, { id: 412, invoice_id: 196, line_no: 1, product_id: 34, quantity: 8, unit_price: "4.65", line_net: "37.20", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "37.20" }, { id: 413, invoice_id: 185, line_no: 2, product_id: 16, quantity: 8, unit_price: "14.41", line_net: "115.28", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "23.06", line_gross: "138.34" }, { id: 414, invoice_id: 99, line_no: 5, product_id: 7, quantity: 3, unit_price: "60.82", line_net: "182.46", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "36.49", line_gross: "218.95" }, { id: 415, invoice_id: 56, line_no: 3, product_id: 20, quantity: 2, unit_price: "154.29", line_net: "308.58", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "61.72", line_gross: "370.30" }, { id: 416, invoice_id: 85, line_no: 1, product_id: 16, quantity: 12, unit_price: "14.41", line_net: "172.92", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "34.58", line_gross: "207.50" }, { id: 417, invoice_id: 9, line_no: 3, product_id: 11, quantity: 4, unit_price: "92.57", line_net: "370.28", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "74.06", line_gross: "444.34" }, { id: 418, invoice_id: 138, line_no: 1, product_id: 30, quantity: 14, unit_price: "98.11", line_net: "1373.54", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1373.54" }, { id: 419, invoice_id: 127, line_no: 4, product_id: 24, quantity: 8, unit_price: "88.25", line_net: "706.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "141.20", line_gross: "847.20" }, { id: 420, invoice_id: 100, line_no: 3, product_id: 29, quantity: 16, unit_price: "274.56", line_net: "4392.96", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "878.59", line_gross: "5271.55" }, { id: 421, invoice_id: 73, line_no: 4, product_id: 31, quantity: 4, unit_price: "405.30", line_net: "1621.20", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1621.20" }, { id: 422, invoice_id: 80, line_no: 5, product_id: 10, quantity: 10, unit_price: "288.31", line_net: "2883.10", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "576.62", line_gross: "3459.72" }, { id: 423, invoice_id: 47, line_no: 1, product_id: 1, quantity: 1, unit_price: "144.99", line_net: "144.99", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "29.00", line_gross: "173.99" }, { id: 424, invoice_id: 30, line_no: 1, product_id: 1, quantity: 14, unit_price: "144.99", line_net: "2029.86", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "405.97", line_gross: "2435.83" }, { id: 425, invoice_id: 182, line_no: 1, product_id: 33, quantity: 13, unit_price: "5.66", line_net: "73.58", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "14.72", line_gross: "88.30" }, { id: 426, invoice_id: 166, line_no: 1, product_id: 29, quantity: 4, unit_price: "274.56", line_net: "1098.24", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "219.65", line_gross: "1317.89" }, { id: 427, invoice_id: 142, line_no: 2, product_id: 27, quantity: 2, unit_price: "364.78", line_net: "729.56", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "145.91", line_gross: "875.47" }, { id: 428, invoice_id: 233, line_no: 4, product_id: 7, quantity: 5, unit_price: "60.82", line_net: "304.10", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "304.10" }, { id: 429, invoice_id: 21, line_no: 1, product_id: 28, quantity: 25, unit_price: "356.72", line_net: "8918.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1783.60", line_gross: "10701.60" }, { id: 430, invoice_id: 100, line_no: 4, product_id: 32, quantity: 19, unit_price: "8.27", line_net: "157.13", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "31.43", line_gross: "188.56" }, { id: 431, invoice_id: 206, line_no: 2, product_id: 36, quantity: 16, unit_price: "36.25", line_net: "580.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "116.00", line_gross: "696.00" }, { id: 432, invoice_id: 178, line_no: 4, product_id: 23, quantity: 21, unit_price: "182.75", line_net: "3837.75", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3837.75" }, { id: 433, invoice_id: 9, line_no: 4, product_id: 21, quantity: 7, unit_price: "188.00", line_net: "1316.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "263.20", line_gross: "1579.20" }, { id: 434, invoice_id: 9, line_no: 5, product_id: 25, quantity: 12, unit_price: "394.69", line_net: "4736.28", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "947.26", line_gross: "5683.54" }, { id: 435, invoice_id: 132, line_no: 2, product_id: 24, quantity: 7, unit_price: "88.25", line_net: "617.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "123.55", line_gross: "741.30" }, { id: 436, invoice_id: 103, line_no: 4, product_id: 23, quantity: 14, unit_price: "182.75", line_net: "2558.50", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2558.50" }, { id: 437, invoice_id: 109, line_no: 4, product_id: 15, quantity: 22, unit_price: "159.71", line_net: "3513.62", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3513.62" }, { id: 438, invoice_id: 117, line_no: 2, product_id: 34, quantity: 11, unit_price: "4.65", line_net: "51.15", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "10.23", line_gross: "61.38" }, { id: 439, invoice_id: 103, line_no: 5, product_id: 9, quantity: 1, unit_price: "191.14", line_net: "191.14", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "191.14" }, { id: 440, invoice_id: 28, line_no: 5, product_id: 9, quantity: 1, unit_price: "191.14", line_net: "191.14", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "38.23", line_gross: "229.37" }, { id: 441, invoice_id: 191, line_no: 1, product_id: 27, quantity: 1, unit_price: "364.78", line_net: "364.78", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "72.96", line_gross: "437.74" }, { id: 442, invoice_id: 186, line_no: 1, product_id: 28, quantity: 12, unit_price: "356.72", line_net: "4280.64", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "856.13", line_gross: "5136.77" }, { id: 443, invoice_id: 221, line_no: 4, product_id: 4, quantity: 6, unit_price: "147.40", line_net: "884.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "884.40" }, { id: 444, invoice_id: 104, line_no: 1, product_id: 13, quantity: 3, unit_price: "451.47", line_net: "1354.41", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1354.41" }, { id: 445, invoice_id: 201, line_no: 1, product_id: 22, quantity: 13, unit_price: "369.19", line_net: "4799.47", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "4799.47" }, { id: 446, invoice_id: 203, line_no: 1, product_id: 14, quantity: 20, unit_price: "20.95", line_net: "419.00", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "419.00" }, { id: 447, invoice_id: 202, line_no: 5, product_id: 26, quantity: 1, unit_price: "469.01", line_net: "469.01", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "93.80", line_gross: "562.81" }, { id: 448, invoice_id: 201, line_no: 2, product_id: 19, quantity: 1, unit_price: "369.92", line_net: "369.92", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "369.92" }, { id: 449, invoice_id: 208, line_no: 4, product_id: 12, quantity: 6, unit_price: "55.02", line_net: "330.12", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "66.02", line_gross: "396.14" }, { id: 450, invoice_id: 18, line_no: 4, product_id: 20, quantity: 19, unit_price: "154.29", line_net: "2931.51", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2931.51" }, { id: 451, invoice_id: 201, line_no: 3, product_id: 19, quantity: 3, unit_price: "369.92", line_net: "1109.76", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1109.76" }, { id: 452, invoice_id: 67, line_no: 3, product_id: 21, quantity: 12, unit_price: "188.00", line_net: "2256.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "451.20", line_gross: "2707.20" }, { id: 453, invoice_id: 11, line_no: 3, product_id: 7, quantity: 15, unit_price: "60.82", line_net: "912.30", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "912.30" }, { id: 454, invoice_id: 110, line_no: 3, product_id: 19, quantity: 11, unit_price: "369.92", line_net: "4069.12", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "4069.12" }, { id: 455, invoice_id: 216, line_no: 2, product_id: 24, quantity: 8, unit_price: "88.25", line_net: "706.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "141.20", line_gross: "847.20" }, { id: 456, invoice_id: 31, line_no: 1, product_id: 4, quantity: 20, unit_price: "147.40", line_net: "2948.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2948.00" }, { id: 457, invoice_id: 111, line_no: 1, product_id: 26, quantity: 8, unit_price: "469.01", line_net: "3752.08", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3752.08" }, { id: 458, invoice_id: 36, line_no: 1, product_id: 7, quantity: 5, unit_price: "60.82", line_net: "304.10", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "304.10" }, { id: 459, invoice_id: 15, line_no: 1, product_id: 14, quantity: 24, unit_price: "20.95", line_net: "502.80", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "502.80" }, { id: 460, invoice_id: 57, line_no: 2, product_id: 23, quantity: 12, unit_price: "182.75", line_net: "2193.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "438.60", line_gross: "2631.60" }, { id: 461, invoice_id: 147, line_no: 1, product_id: 30, quantity: 1, unit_price: "98.11", line_net: "98.11", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "98.11" }, { id: 462, invoice_id: 178, line_no: 5, product_id: 27, quantity: 9, unit_price: "364.78", line_net: "3283.02", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "3283.02" }, { id: 463, invoice_id: 140, line_no: 5, product_id: 23, quantity: 3, unit_price: "182.75", line_net: "548.25", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "548.25" }, { id: 464, invoice_id: 100, line_no: 5, product_id: 32, quantity: 18, unit_price: "8.27", line_net: "148.86", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "29.77", line_gross: "178.63" }, { id: 465, invoice_id: 231, line_no: 4, product_id: 35, quantity: 3, unit_price: "185.30", line_net: "555.90", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "111.18", line_gross: "667.08" }, { id: 466, invoice_id: 39, line_no: 3, product_id: 26, quantity: 3, unit_price: "469.01", line_net: "1407.03", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "281.41", line_gross: "1688.44" }, { id: 467, invoice_id: 12, line_no: 4, product_id: 32, quantity: 13, unit_price: "8.27", line_net: "107.51", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "21.50", line_gross: "129.01" }, { id: 468, invoice_id: 146, line_no: 3, product_id: 20, quantity: 1, unit_price: "154.29", line_net: "154.29", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "30.86", line_gross: "185.15" }, { id: 469, invoice_id: 212, line_no: 2, product_id: 25, quantity: 6, unit_price: "394.69", line_net: "2368.14", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "473.63", line_gross: "2841.77" }, { id: 470, invoice_id: 109, line_no: 5, product_id: 21, quantity: 2, unit_price: "188.00", line_net: "376.00", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "376.00" }, { id: 471, invoice_id: 232, line_no: 5, product_id: 23, quantity: 20, unit_price: "182.75", line_net: "3655.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "731.00", line_gross: "4386.00" }, { id: 472, invoice_id: 11, line_no: 4, product_id: 33, quantity: 12, unit_price: "5.66", line_net: "67.92", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "67.92" }, { id: 473, invoice_id: 151, line_no: 5, product_id: 18, quantity: 3, unit_price: "299.28", line_net: "897.84", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "179.57", line_gross: "1077.41" }, { id: 474, invoice_id: 163, line_no: 1, product_id: 22, quantity: 4, unit_price: "369.19", line_net: "1476.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "295.35", line_gross: "1772.11" }, { id: 475, invoice_id: 126, line_no: 3, product_id: 1, quantity: 4, unit_price: "144.99", line_net: "579.96", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "115.99", line_gross: "695.95" }, { id: 476, invoice_id: 170, line_no: 1, product_id: 35, quantity: 19, unit_price: "185.30", line_net: "3520.70", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "704.14", line_gross: "4224.84" }, { id: 477, invoice_id: 189, line_no: 3, product_id: 18, quantity: 17, unit_price: "299.28", line_net: "5087.76", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1017.55", line_gross: "6105.31" }, { id: 478, invoice_id: 174, line_no: 2, product_id: 29, quantity: 22, unit_price: "274.56", line_net: "6040.32", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1208.06", line_gross: "7248.38" }, { id: 479, invoice_id: 12, line_no: 5, product_id: 13, quantity: 19, unit_price: "451.47", line_net: "8577.93", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1715.59", line_gross: "10293.52" }, { id: 480, invoice_id: 98, line_no: 1, product_id: 10, quantity: 3, unit_price: "288.31", line_net: "864.93", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "172.99", line_gross: "1037.92" }, { id: 481, invoice_id: 154, line_no: 5, product_id: 29, quantity: 10, unit_price: "274.56", line_net: "2745.60", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2745.60" }, { id: 482, invoice_id: 24, line_no: 1, product_id: 11, quantity: 5, unit_price: "92.57", line_net: "462.85", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "92.57", line_gross: "555.42" }, { id: 483, invoice_id: 52, line_no: 1, product_id: 8, quantity: 4, unit_price: "66.25", line_net: "265.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "53.00", line_gross: "318.00" }, { id: 484, invoice_id: 220, line_no: 3, product_id: 12, quantity: 4, unit_price: "55.02", line_net: "220.08", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "44.02", line_gross: "264.10" }, { id: 485, invoice_id: 131, line_no: 3, product_id: 14, quantity: 8, unit_price: "20.95", line_net: "167.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "167.60" }, { id: 486, invoice_id: 22, line_no: 5, product_id: 24, quantity: 19, unit_price: "88.25", line_net: "1676.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "335.35", line_gross: "2012.10" }, { id: 487, invoice_id: 117, line_no: 3, product_id: 28, quantity: 3, unit_price: "356.72", line_net: "1070.16", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "214.03", line_gross: "1284.19" }, { id: 488, invoice_id: 182, line_no: 2, product_id: 23, quantity: 7, unit_price: "182.75", line_net: "1279.25", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "255.85", line_gross: "1535.10" }, { id: 489, invoice_id: 177, line_no: 3, product_id: 32, quantity: 21, unit_price: "8.27", line_net: "173.67", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "34.73", line_gross: "208.40" }, { id: 490, invoice_id: 231, line_no: 5, product_id: 19, quantity: 6, unit_price: "369.92", line_net: "2219.52", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2219.52" }, { id: 491, invoice_id: 117, line_no: 4, product_id: 15, quantity: 12, unit_price: "159.71", line_net: "1916.52", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "383.30", line_gross: "2299.82" }, { id: 492, invoice_id: 115, line_no: 3, product_id: 7, quantity: 22, unit_price: "60.82", line_net: "1338.04", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "267.61", line_gross: "1605.65" }, { id: 493, invoice_id: 233, line_no: 5, product_id: 6, quantity: 3, unit_price: "329.37", line_net: "988.11", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "988.11" }, { id: 494, invoice_id: 5, line_no: 2, product_id: 35, quantity: 8, unit_price: "185.30", line_net: "1482.40", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "296.48", line_gross: "1778.88" }, { id: 495, invoice_id: 112, line_no: 2, product_id: 14, quantity: 22, unit_price: "20.95", line_net: "460.90", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "460.90" }, { id: 496, invoice_id: 45, line_no: 2, product_id: 21, quantity: 1, unit_price: "188.00", line_net: "188.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "37.60", line_gross: "225.60" }, { id: 497, invoice_id: 146, line_no: 4, product_id: 3, quantity: 24, unit_price: "295.81", line_net: "7099.44", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1419.89", line_gross: "8519.33" }, { id: 498, invoice_id: 145, line_no: 3, product_id: 2, quantity: 1, unit_price: "261.86", line_net: "261.86", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "52.37", line_gross: "314.23" }, { id: 499, invoice_id: 131, line_no: 4, product_id: 35, quantity: 16, unit_price: "185.30", line_net: "2964.80", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "592.96", line_gross: "3557.76" }, { id: 500, invoice_id: 72, line_no: 3, product_id: 13, quantity: 2, unit_price: "451.47", line_net: "902.94", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "180.59", line_gross: "1083.53" }, ], }); await prisma.invoice_lines.createMany({ data: [ { id: 501, invoice_id: 163, line_no: 2, product_id: 11, quantity: 18, unit_price: "92.57", line_net: "1666.26", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "333.25", line_gross: "1999.51" }, { id: 502, invoice_id: 171, line_no: 3, product_id: 18, quantity: 10, unit_price: "299.28", line_net: "2992.80", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "598.56", line_gross: "3591.36" }, { id: 503, invoice_id: 222, line_no: 4, product_id: 16, quantity: 22, unit_price: "14.41", line_net: "317.02", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "63.40", line_gross: "380.42" }, { id: 504, invoice_id: 27, line_no: 1, product_id: 33, quantity: 6, unit_price: "5.66", line_net: "33.96", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "6.79", line_gross: "40.75" }, { id: 505, invoice_id: 32, line_no: 2, product_id: 12, quantity: 8, unit_price: "55.02", line_net: "440.16", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "440.16" }, { id: 506, invoice_id: 175, line_no: 4, product_id: 26, quantity: 2, unit_price: "469.01", line_net: "938.02", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "187.60", line_gross: "1125.62" }, { id: 507, invoice_id: 205, line_no: 3, product_id: 30, quantity: 10, unit_price: "98.11", line_net: "981.10", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "981.10" }, { id: 508, invoice_id: 113, line_no: 5, product_id: 5, quantity: 1, unit_price: "320.63", line_net: "320.63", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "320.63" }, { id: 509, invoice_id: 19, line_no: 2, product_id: 7, quantity: 16, unit_price: "60.82", line_net: "973.12", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "194.62", line_gross: "1167.74" }, { id: 510, invoice_id: 200, line_no: 4, product_id: 15, quantity: 3, unit_price: "159.71", line_net: "479.13", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "95.83", line_gross: "574.96" }, { id: 511, invoice_id: 119, line_no: 2, product_id: 18, quantity: 16, unit_price: "299.28", line_net: "4788.48", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "957.70", line_gross: "5746.18" }, { id: 512, invoice_id: 221, line_no: 5, product_id: 5, quantity: 2, unit_price: "320.63", line_net: "641.26", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "128.25", line_gross: "769.51" }, { id: 513, invoice_id: 124, line_no: 3, product_id: 33, quantity: 8, unit_price: "5.66", line_net: "45.28", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "9.06", line_gross: "54.34" }, { id: 514, invoice_id: 73, line_no: 5, product_id: 11, quantity: 2, unit_price: "92.57", line_net: "185.14", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "185.14" }, { id: 515, invoice_id: 64, line_no: 2, product_id: 29, quantity: 1, unit_price: "274.56", line_net: "274.56", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "274.56" }, { id: 516, invoice_id: 18, line_no: 5, product_id: 1, quantity: 14, unit_price: "144.99", line_net: "2029.86", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "2029.86" }, { id: 517, invoice_id: 35, line_no: 2, product_id: 19, quantity: 2, unit_price: "369.92", line_net: "739.84", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "739.84" }, { id: 518, invoice_id: 134, line_no: 1, product_id: 21, quantity: 6, unit_price: "188.00", line_net: "1128.00", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1128.00" }, { id: 519, invoice_id: 23, line_no: 3, product_id: 34, quantity: 18, unit_price: "4.65", line_net: "83.70", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "83.70" }, { id: 520, invoice_id: 205, line_no: 4, product_id: 29, quantity: 3, unit_price: "274.56", line_net: "823.68", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "164.74", line_gross: "988.42" }, { id: 521, invoice_id: 5, line_no: 3, product_id: 2, quantity: 13, unit_price: "261.86", line_net: "3404.18", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "680.84", line_gross: "4085.02" }, { id: 522, invoice_id: 14, line_no: 5, product_id: 36, quantity: 4, unit_price: "36.25", line_net: "145.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "29.00", line_gross: "174.00" }, { id: 523, invoice_id: 59, line_no: 4, product_id: 23, quantity: 23, unit_price: "182.75", line_net: "4203.25", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "4203.25" }, { id: 524, invoice_id: 208, line_no: 5, product_id: 23, quantity: 1, unit_price: "182.75", line_net: "182.75", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "36.55", line_gross: "219.30" }, { id: 525, invoice_id: 10, line_no: 4, product_id: 20, quantity: 13, unit_price: "154.29", line_net: "2005.77", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "401.15", line_gross: "2406.92" }, { id: 526, invoice_id: 224, line_no: 1, product_id: 36, quantity: 12, unit_price: "36.25", line_net: "435.00", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "435.00" }, { id: 527, invoice_id: 206, line_no: 3, product_id: 25, quantity: 2, unit_price: "394.69", line_net: "789.38", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "157.88", line_gross: "947.26" }, { id: 528, invoice_id: 43, line_no: 4, product_id: 2, quantity: 3, unit_price: "261.86", line_net: "785.58", tax_treatment: "export", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "785.58" }, { id: 529, invoice_id: 193, line_no: 4, product_id: 10, quantity: 3, unit_price: "288.31", line_net: "864.93", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "864.93" }, { id: 530, invoice_id: 39, line_no: 4, product_id: 19, quantity: 5, unit_price: "369.92", line_net: "1849.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.00", vat_amount: "0.00", line_gross: "1849.60" }, { id: 531, invoice_id: 58, line_no: 3, product_id: 21, quantity: 7, unit_price: "188.00", line_net: "1316.00", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "263.20", line_gross: "1579.20" }, { id: 532, invoice_id: 89, line_no: 1, product_id: 33, quantity: 6, unit_price: "5.66", line_net: "33.96", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "6.79", line_gross: "40.75" }, { id: 533, invoice_id: 172, line_no: 2, product_id: 33, quantity: 3, unit_price: "5.66", line_net: "16.98", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "3.40", line_gross: "20.38" }, { id: 534, invoice_id: 46, line_no: 5, product_id: 32, quantity: 1, unit_price: "8.27", line_net: "8.27", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1.65", line_gross: "9.92" }, { id: 535, invoice_id: 214, line_no: 4, product_id: 13, quantity: 18, unit_price: "451.47", line_net: "8126.46", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "1625.29", line_gross: "9751.75" }, { id: 536, invoice_id: 58, line_no: 4, product_id: 33, quantity: 10, unit_price: "5.66", line_net: "56.60", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "11.32", line_gross: "67.92" }, { id: 537, invoice_id: 4, line_no: 3, product_id: 7, quantity: 1, unit_price: "60.82", line_net: "60.82", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "12.16", line_gross: "72.98" }, { id: 538, invoice_id: 118, line_no: 4, product_id: 1, quantity: 3, unit_price: "144.99", line_net: "434.97", tax_treatment: "reverse_charge", vat_due: null, vat_rate: "0.00", vat_amount: "0.00", line_gross: "434.97" }, { id: 539, invoice_id: 62, line_no: 1, product_id: 9, quantity: 4, unit_price: "191.14", line_net: "764.56", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "152.91", line_gross: "917.47" }, { id: 540, invoice_id: 1, line_no: 2, product_id: 11, quantity: 22, unit_price: "92.57", line_net: "2036.54", tax_treatment: "domestic", vat_due: 1, vat_rate: "0.20", vat_amount: "407.31", line_gross: "2443.85" }, ], }); } main() .then(() => prisma.$disconnect()) .catch(async error => { console.error(error); await prisma.$disconnect(); process.exit(1); });