// Procurement purchase orders and receipts dataset (procurement-purchase-orders-and-receipts-dataset) 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.buyers), 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.buyers.createMany({
        data: [
            { id: 1, first_name: "Alyson", last_name: "Will", email: "alyson.will64@example.net", team: "it_and_office" },
            { id: 2, first_name: "Kendra", last_name: "Cronin", email: "kendra.cronin27@example.org", team: "facilities" },
            { id: 3, first_name: "Cleta", last_name: "Johnson", email: "cleta.johnson52@example.com", team: "it_and_office" },
            { id: 4, first_name: "King", last_name: "Kutch", email: "king_kutch14@example.org", team: "production_supplies" },
            { id: 5, first_name: "Gerard", last_name: "West", email: "gerard.west@example.org", team: "production_supplies" },
        ],
    });
    await prisma.items.createMany({
        data: [
            { id: 1, sku: "SK-04353", catalogue: "stores_catalogue", item_label: "Safety gloves, pair", unit: "pair", list_price: "3.20" },
            { id: 2, sku: "SK-02192", catalogue: "stores_catalogue", item_label: "Nitrile gloves, box of 100", unit: "box", list_price: "9.50" },
            { id: 3, sku: "SK-33357", catalogue: "stores_catalogue", item_label: "Safety goggles", unit: "each", list_price: "6.40" },
            { id: 4, sku: "SK-88154", catalogue: "stores_catalogue", item_label: "Cable ties, pack of 100", unit: "pack", list_price: "4.80" },
            { id: 5, sku: "SK-39839", catalogue: "stores_catalogue", item_label: "Hex bolt M10, box of 50", unit: "box", list_price: "18.50" },
            { id: 6, sku: "SK-25513", catalogue: "stores_catalogue", item_label: "Cutting disc 125 mm, box of 25", unit: "box", list_price: "21.00" },
            { id: 7, sku: "SK-90147", catalogue: "stores_catalogue", item_label: "Pallet wrap roll", unit: "roll", list_price: "9.90" },
            { id: 8, sku: "SK-96050", catalogue: "stores_catalogue", item_label: "Packing tape roll", unit: "roll", list_price: "2.10" },
            { id: 9, sku: "SK-71382", catalogue: "stores_catalogue", item_label: "Label roll, 500", unit: "roll", list_price: "14.30" },
            { id: 10, sku: "SK-70002", catalogue: "stores_catalogue", item_label: "A4 copy paper, ream", unit: "ream", list_price: "4.60" },
            { id: 11, sku: "SK-55401", catalogue: "stores_catalogue", item_label: "Toner cartridge", unit: "each", list_price: "58.00" },
            { id: 12, sku: "SK-15697", catalogue: "stores_catalogue", item_label: "LED tube light", unit: "each", list_price: "7.80" },
            { id: 13, sku: "SK-20446", catalogue: "stores_catalogue", item_label: "Hydraulic oil, 20 L", unit: "drum", list_price: "64.00" },
            { id: 14, sku: "SK-58822", catalogue: "stores_catalogue", item_label: "Degreaser, 5 L", unit: "can", list_price: "17.50" },
            { id: 15, sku: "SK-61947", catalogue: "stores_catalogue", item_label: "Welding wire, 15 kg", unit: "spool", list_price: "76.00" },
            { id: 16, sku: "SK-13131", catalogue: "stores_catalogue", item_label: "Bearing 6204", unit: "each", list_price: "8.90" },
            { id: 17, sku: "SK-61366", catalogue: "stores_catalogue", item_label: "V-belt, A section", unit: "each", list_price: "11.40" },
            { id: 18, sku: "SK-52780", catalogue: "stores_catalogue", item_label: "Wooden pallet", unit: "each", list_price: "12.00" },
            { id: 19, sku: "SK-35032", catalogue: "stores_catalogue", item_label: "Forklift battery water, 5 L", unit: "can", list_price: "6.20" },
            { id: 20, sku: "SK-66909", catalogue: "stores_catalogue", item_label: "Fire extinguisher refill", unit: "each", list_price: "29.00" },
        ],
    });
    await prisma.requisitions.createMany({
        data: [
            { id: 1, requester_dept: "maintenance", item_id: 2, quantity_requested: 73, list_price: "9.50", requested_on: "2026-01-27" },
            { id: 2, requester_dept: "office", item_id: 1, quantity_requested: 99, list_price: "3.20", requested_on: "2026-01-15" },
            { id: 3, requester_dept: "office", item_id: 4, quantity_requested: 146, list_price: "4.80", requested_on: "2026-01-30" },
            { id: 4, requester_dept: "quality", item_id: 10, quantity_requested: 69, list_price: "4.60", requested_on: "2026-02-13" },
            { id: 5, requester_dept: "production", item_id: 9, quantity_requested: 118, list_price: "14.30", requested_on: "2026-01-29" },
            { id: 6, requester_dept: "quality", item_id: 4, quantity_requested: 103, list_price: "4.80", requested_on: "2026-02-19" },
            { id: 7, requester_dept: "warehouse", item_id: 5, quantity_requested: 32, list_price: "18.50", requested_on: "2026-01-09" },
            { id: 8, requester_dept: "warehouse", item_id: 13, quantity_requested: 74, list_price: "64.00", requested_on: "2026-02-06" },
            { id: 9, requester_dept: "warehouse", item_id: 1, quantity_requested: 11, list_price: "3.20", requested_on: "2026-01-09" },
            { id: 10, requester_dept: "maintenance", item_id: 3, quantity_requested: 169, list_price: "6.40", requested_on: "2026-02-27" },
            { id: 11, requester_dept: "warehouse", item_id: 1, quantity_requested: 5, list_price: "3.20", requested_on: "2026-01-16" },
            { id: 12, requester_dept: "warehouse", item_id: 1, quantity_requested: 73, list_price: "3.20", requested_on: "2026-02-07" },
            { id: 13, requester_dept: "production", item_id: 18, quantity_requested: 20, list_price: "12.00", requested_on: "2026-01-17" },
            { id: 14, requester_dept: "office", item_id: 1, quantity_requested: 41, list_price: "3.20", requested_on: "2026-01-20" },
            { id: 15, requester_dept: "quality", item_id: 1, quantity_requested: 6, list_price: "3.20", requested_on: "2026-01-10" },
            { id: 16, requester_dept: "warehouse", item_id: 1, quantity_requested: 105, list_price: "3.20", requested_on: "2026-01-12" },
            { id: 17, requester_dept: "production", item_id: 1, quantity_requested: 64, list_price: "3.20", requested_on: "2026-02-03" },
            { id: 18, requester_dept: "warehouse", item_id: 9, quantity_requested: 97, list_price: "14.30", requested_on: "2026-01-22" },
            { id: 19, requester_dept: "quality", item_id: 20, quantity_requested: 185, list_price: "29.00", requested_on: "2026-01-05" },
            { id: 20, requester_dept: "maintenance", item_id: 16, quantity_requested: 53, list_price: "8.90", requested_on: "2026-01-15" },
            { id: 21, requester_dept: "warehouse", item_id: 2, quantity_requested: 131, list_price: "9.50", requested_on: "2026-01-14" },
            { id: 22, requester_dept: "warehouse", item_id: 18, quantity_requested: 69, list_price: "12.00", requested_on: "2026-02-21" },
            { id: 23, requester_dept: "quality", item_id: 4, quantity_requested: 159, list_price: "4.80", requested_on: "2026-01-08" },
            { id: 24, requester_dept: "office", item_id: 1, quantity_requested: 21, list_price: "3.20", requested_on: "2026-02-21" },
            { id: 25, requester_dept: "production", item_id: 1, quantity_requested: 5, list_price: "3.20", requested_on: "2026-01-29" },
            { id: 26, requester_dept: "production", item_id: 3, quantity_requested: 9, list_price: "6.40", requested_on: "2026-01-06" },
            { id: 27, requester_dept: "production", item_id: 5, quantity_requested: 180, list_price: "18.50", requested_on: "2026-01-07" },
            { id: 28, requester_dept: "production", item_id: 1, quantity_requested: 199, list_price: "3.20", requested_on: "2026-01-16" },
            { id: 29, requester_dept: "warehouse", item_id: 7, quantity_requested: 52, list_price: "9.90", requested_on: "2026-02-16" },
            { id: 30, requester_dept: "production", item_id: 5, quantity_requested: 26, list_price: "18.50", requested_on: "2026-02-08" },
            { id: 31, requester_dept: "production", item_id: 16, quantity_requested: 136, list_price: "8.90", requested_on: "2026-01-28" },
            { id: 32, requester_dept: "office", item_id: 1, quantity_requested: 191, list_price: "3.20", requested_on: "2026-01-28" },
            { id: 33, requester_dept: "production", item_id: 16, quantity_requested: 20, list_price: "8.90", requested_on: "2026-01-21" },
            { id: 34, requester_dept: "production", item_id: 7, quantity_requested: 147, list_price: "9.90", requested_on: "2026-02-22" },
            { id: 35, requester_dept: "production", item_id: 9, quantity_requested: 5, list_price: "14.30", requested_on: "2026-02-27" },
            { id: 36, requester_dept: "warehouse", item_id: 12, quantity_requested: 83, list_price: "7.80", requested_on: "2026-02-18" },
            { id: 37, requester_dept: "production", item_id: 1, quantity_requested: 88, list_price: "3.20", requested_on: "2026-02-17" },
            { id: 38, requester_dept: "warehouse", item_id: 12, quantity_requested: 165, list_price: "7.80", requested_on: "2026-02-18" },
            { id: 39, requester_dept: "warehouse", item_id: 2, quantity_requested: 11, list_price: "9.50", requested_on: "2026-02-18" },
            { id: 40, requester_dept: "production", item_id: 1, quantity_requested: 75, list_price: "3.20", requested_on: "2026-02-18" },
            { id: 41, requester_dept: "maintenance", item_id: 3, quantity_requested: 190, list_price: "6.40", requested_on: "2026-02-16" },
            { id: 42, requester_dept: "maintenance", item_id: 20, quantity_requested: 143, list_price: "29.00", requested_on: "2026-01-24" },
            { id: 43, requester_dept: "production", item_id: 17, quantity_requested: 5, list_price: "11.40", requested_on: "2026-01-17" },
            { id: 44, requester_dept: "warehouse", item_id: 4, quantity_requested: 66, list_price: "4.80", requested_on: "2026-01-13" },
            { id: 45, requester_dept: "maintenance", item_id: 20, quantity_requested: 21, list_price: "29.00", requested_on: "2026-02-15" },
            { id: 46, requester_dept: "maintenance", item_id: 12, quantity_requested: 67, list_price: "7.80", requested_on: "2026-02-17" },
            { id: 47, requester_dept: "warehouse", item_id: 1, quantity_requested: 5, list_price: "3.20", requested_on: "2026-01-12" },
            { id: 48, requester_dept: "warehouse", item_id: 5, quantity_requested: 100, list_price: "18.50", requested_on: "2026-01-23" },
            { id: 49, requester_dept: "warehouse", item_id: 11, quantity_requested: 93, list_price: "58.00", requested_on: "2026-02-05" },
            { id: 50, requester_dept: "production", item_id: 4, quantity_requested: 67, list_price: "4.80", requested_on: "2026-02-03" },
            { id: 51, requester_dept: "production", item_id: 2, quantity_requested: 53, list_price: "9.50", requested_on: "2026-01-27" },
            { id: 52, requester_dept: "warehouse", item_id: 2, quantity_requested: 93, list_price: "9.50", requested_on: "2026-02-23" },
            { id: 53, requester_dept: "maintenance", item_id: 10, quantity_requested: 8, list_price: "4.60", requested_on: "2026-02-09" },
            { id: 54, requester_dept: "production", item_id: 4, quantity_requested: 147, list_price: "4.80", requested_on: "2026-02-01" },
            { id: 55, requester_dept: "production", item_id: 9, quantity_requested: 158, list_price: "14.30", requested_on: "2026-02-10" },
            { id: 56, requester_dept: "maintenance", item_id: 3, quantity_requested: 85, list_price: "6.40", requested_on: "2026-01-22" },
            { id: 57, requester_dept: "maintenance", item_id: 10, quantity_requested: 70, list_price: "4.60", requested_on: "2026-01-12" },
            { id: 58, requester_dept: "warehouse", item_id: 14, quantity_requested: 76, list_price: "17.50", requested_on: "2026-01-29" },
            { id: 59, requester_dept: "maintenance", item_id: 4, quantity_requested: 194, list_price: "4.80", requested_on: "2026-01-18" },
            { id: 60, requester_dept: "production", item_id: 10, quantity_requested: 98, list_price: "4.60", requested_on: "2026-01-31" },
            { id: 61, requester_dept: "maintenance", item_id: 2, quantity_requested: 36, list_price: "9.50", requested_on: "2026-02-11" },
            { id: 62, requester_dept: "quality", item_id: 2, quantity_requested: 127, list_price: "9.50", requested_on: "2026-01-11" },
            { id: 63, requester_dept: "production", item_id: 1, quantity_requested: 191, list_price: "3.20", requested_on: "2026-02-15" },
            { id: 64, requester_dept: "quality", item_id: 1, quantity_requested: 34, list_price: "3.20", requested_on: "2026-02-03" },
            { id: 65, requester_dept: "warehouse", item_id: 8, quantity_requested: 5, list_price: "2.10", requested_on: "2026-01-10" },
            { id: 66, requester_dept: "quality", item_id: 18, quantity_requested: 11, list_price: "12.00", requested_on: "2026-02-03" },
            { id: 67, requester_dept: "production", item_id: 1, quantity_requested: 176, list_price: "3.20", requested_on: "2026-02-17" },
            { id: 68, requester_dept: "warehouse", item_id: 10, quantity_requested: 120, list_price: "4.60", requested_on: "2026-01-14" },
            { id: 69, requester_dept: "production", item_id: 11, quantity_requested: 160, list_price: "58.00", requested_on: "2026-02-09" },
            { id: 70, requester_dept: "maintenance", item_id: 1, quantity_requested: 25, list_price: "3.20", requested_on: "2026-02-11" },
            { id: 71, requester_dept: "quality", item_id: 7, quantity_requested: 13, list_price: "9.90", requested_on: "2026-01-22" },
            { id: 72, requester_dept: "production", item_id: 1, quantity_requested: 8, list_price: "3.20", requested_on: "2026-02-15" },
            { id: 73, requester_dept: "maintenance", item_id: 6, quantity_requested: 8, list_price: "21.00", requested_on: "2026-02-19" },
            { id: 74, requester_dept: "warehouse", item_id: 3, quantity_requested: 179, list_price: "6.40", requested_on: "2026-02-18" },
            { id: 75, requester_dept: "maintenance", item_id: 3, quantity_requested: 82, list_price: "6.40", requested_on: "2026-01-07" },
            { id: 76, requester_dept: "quality", item_id: 1, quantity_requested: 6, list_price: "3.20", requested_on: "2026-01-19" },
            { id: 77, requester_dept: "office", item_id: 2, quantity_requested: 6, list_price: "9.50", requested_on: "2026-02-07" },
            { id: 78, requester_dept: "maintenance", item_id: 3, quantity_requested: 113, list_price: "6.40", requested_on: "2026-02-03" },
            { id: 79, requester_dept: "production", item_id: 5, quantity_requested: 5, list_price: "18.50", requested_on: "2026-02-20" },
            { id: 80, requester_dept: "maintenance", item_id: 9, quantity_requested: 75, list_price: "14.30", requested_on: "2026-02-06" },
            { id: 81, requester_dept: "office", item_id: 3, quantity_requested: 195, list_price: "6.40", requested_on: "2026-02-11" },
            { id: 82, requester_dept: "quality", item_id: 1, quantity_requested: 11, list_price: "3.20", requested_on: "2026-02-08" },
            { id: 83, requester_dept: "maintenance", item_id: 19, quantity_requested: 36, list_price: "6.20", requested_on: "2026-01-29" },
            { id: 84, requester_dept: "maintenance", item_id: 1, quantity_requested: 97, list_price: "3.20", requested_on: "2026-01-31" },
            { id: 85, requester_dept: "production", item_id: 1, quantity_requested: 119, list_price: "3.20", requested_on: "2026-02-02" },
            { id: 86, requester_dept: "office", item_id: 13, quantity_requested: 28, list_price: "64.00", requested_on: "2026-02-02" },
            { id: 87, requester_dept: "quality", item_id: 9, quantity_requested: 69, list_price: "14.30", requested_on: "2026-02-19" },
            { id: 88, requester_dept: "maintenance", item_id: 4, quantity_requested: 39, list_price: "4.80", requested_on: "2026-02-22" },
            { id: 89, requester_dept: "quality", item_id: 1, quantity_requested: 85, list_price: "3.20", requested_on: "2026-02-01" },
            { id: 90, requester_dept: "production", item_id: 4, quantity_requested: 50, list_price: "4.80", requested_on: "2026-02-09" },
            { id: 91, requester_dept: "warehouse", item_id: 17, quantity_requested: 42, list_price: "11.40", requested_on: "2026-02-13" },
            { id: 92, requester_dept: "production", item_id: 9, quantity_requested: 187, list_price: "14.30", requested_on: "2026-01-28" },
            { id: 93, requester_dept: "warehouse", item_id: 18, quantity_requested: 175, list_price: "12.00", requested_on: "2026-02-04" },
            { id: 94, requester_dept: "office", item_id: 13, quantity_requested: 17, list_price: "64.00", requested_on: "2026-02-19" },
            { id: 95, requester_dept: "warehouse", item_id: 2, quantity_requested: 77, list_price: "9.50", requested_on: "2026-02-27" },
            { id: 96, requester_dept: "warehouse", item_id: 10, quantity_requested: 67, list_price: "4.60", requested_on: "2026-01-29" },
            { id: 97, requester_dept: "maintenance", item_id: 2, quantity_requested: 5, list_price: "9.50", requested_on: "2026-02-26" },
            { id: 98, requester_dept: "maintenance", item_id: 2, quantity_requested: 25, list_price: "9.50", requested_on: "2026-02-23" },
            { id: 99, requester_dept: "warehouse", item_id: 9, quantity_requested: 42, list_price: "14.30", requested_on: "2026-01-21" },
            { id: 100, requester_dept: "maintenance", item_id: 9, quantity_requested: 6, list_price: "14.30", requested_on: "2026-01-14" },
            { id: 101, requester_dept: "warehouse", item_id: 5, quantity_requested: 190, list_price: "18.50", requested_on: "2026-02-19" },
            { id: 102, requester_dept: "maintenance", item_id: 1, quantity_requested: 23, list_price: "3.20", requested_on: "2026-02-18" },
            { id: 103, requester_dept: "production", item_id: 13, quantity_requested: 131, list_price: "64.00", requested_on: "2026-01-13" },
            { id: 104, requester_dept: "maintenance", item_id: 2, quantity_requested: 8, list_price: "9.50", requested_on: "2026-01-27" },
            { id: 105, requester_dept: "maintenance", item_id: 3, quantity_requested: 158, list_price: "6.40", requested_on: "2026-02-05" },
            { id: 106, requester_dept: "quality", item_id: 6, quantity_requested: 56, list_price: "21.00", requested_on: "2026-01-05" },
            { id: 107, requester_dept: "maintenance", item_id: 1, quantity_requested: 11, list_price: "3.20", requested_on: "2026-01-17" },
            { id: 108, requester_dept: "warehouse", item_id: 2, quantity_requested: 137, list_price: "9.50", requested_on: "2026-02-05" },
            { id: 109, requester_dept: "office", item_id: 1, quantity_requested: 148, list_price: "3.20", requested_on: "2026-01-12" },
            { id: 110, requester_dept: "quality", item_id: 1, quantity_requested: 29, list_price: "3.20", requested_on: "2026-02-04" },
            { id: 111, requester_dept: "quality", item_id: 3, quantity_requested: 18, list_price: "6.40", requested_on: "2026-02-11" },
            { id: 112, requester_dept: "production", item_id: 8, quantity_requested: 79, list_price: "2.10", requested_on: "2026-02-11" },
            { id: 113, requester_dept: "warehouse", item_id: 13, quantity_requested: 41, list_price: "64.00", requested_on: "2026-02-14" },
            { id: 114, requester_dept: "warehouse", item_id: 12, quantity_requested: 10, list_price: "7.80", requested_on: "2026-02-08" },
            { id: 115, requester_dept: "maintenance", item_id: 1, quantity_requested: 145, list_price: "3.20", requested_on: "2026-01-24" },
            { id: 116, requester_dept: "production", item_id: 4, quantity_requested: 43, list_price: "4.80", requested_on: "2026-01-22" },
            { id: 117, requester_dept: "maintenance", item_id: 1, quantity_requested: 7, list_price: "3.20", requested_on: "2026-01-31" },
            { id: 118, requester_dept: "production", item_id: 7, quantity_requested: 184, list_price: "9.90", requested_on: "2026-02-04" },
            { id: 119, requester_dept: "maintenance", item_id: 1, quantity_requested: 9, list_price: "3.20", requested_on: "2026-02-16" },
            { id: 120, requester_dept: "warehouse", item_id: 6, quantity_requested: 18, list_price: "21.00", requested_on: "2026-01-07" },
            { id: 121, requester_dept: "production", item_id: 4, quantity_requested: 7, list_price: "4.80", requested_on: "2026-02-18" },
            { id: 122, requester_dept: "warehouse", item_id: 15, quantity_requested: 139, list_price: "76.00", requested_on: "2026-02-25" },
            { id: 123, requester_dept: "maintenance", item_id: 3, quantity_requested: 7, list_price: "6.40", requested_on: "2026-02-08" },
            { id: 124, requester_dept: "warehouse", item_id: 5, quantity_requested: 97, list_price: "18.50", requested_on: "2026-01-14" },
            { id: 125, requester_dept: "quality", item_id: 1, quantity_requested: 56, list_price: "3.20", requested_on: "2026-02-10" },
            { id: 126, requester_dept: "maintenance", item_id: 1, quantity_requested: 125, list_price: "3.20", requested_on: "2026-01-30" },
            { id: 127, requester_dept: "production", item_id: 1, quantity_requested: 18, list_price: "3.20", requested_on: "2026-02-12" },
            { id: 128, requester_dept: "production", item_id: 1, quantity_requested: 194, list_price: "3.20", requested_on: "2026-02-12" },
            { id: 129, requester_dept: "maintenance", item_id: 6, quantity_requested: 7, list_price: "21.00", requested_on: "2026-01-06" },
            { id: 130, requester_dept: "maintenance", item_id: 7, quantity_requested: 197, list_price: "9.90", requested_on: "2026-01-22" },
            { id: 131, requester_dept: "maintenance", item_id: 6, quantity_requested: 6, list_price: "21.00", requested_on: "2026-01-30" },
            { id: 132, requester_dept: "warehouse", item_id: 5, quantity_requested: 98, list_price: "18.50", requested_on: "2026-02-04" },
            { id: 133, requester_dept: "production", item_id: 3, quantity_requested: 46, list_price: "6.40", requested_on: "2026-01-06" },
            { id: 134, requester_dept: "warehouse", item_id: 3, quantity_requested: 64, list_price: "6.40", requested_on: "2026-01-26" },
            { id: 135, requester_dept: "maintenance", item_id: 1, quantity_requested: 39, list_price: "3.20", requested_on: "2026-01-18" },
            { id: 136, requester_dept: "maintenance", item_id: 2, quantity_requested: 133, list_price: "9.50", requested_on: "2026-01-15" },
            { id: 137, requester_dept: "production", item_id: 5, quantity_requested: 162, list_price: "18.50", requested_on: "2026-02-11" },
            { id: 138, requester_dept: "maintenance", item_id: 2, quantity_requested: 5, list_price: "9.50", requested_on: "2026-02-05" },
            { id: 139, requester_dept: "production", item_id: 6, quantity_requested: 9, list_price: "21.00", requested_on: "2026-01-14" },
            { id: 140, requester_dept: "warehouse", item_id: 1, quantity_requested: 59, list_price: "3.20", requested_on: "2026-02-24" },
            { id: 141, requester_dept: "maintenance", item_id: 7, quantity_requested: 15, list_price: "9.90", requested_on: "2026-01-16" },
            { id: 142, requester_dept: "maintenance", item_id: 2, quantity_requested: 153, list_price: "9.50", requested_on: "2026-02-22" },
            { id: 143, requester_dept: "maintenance", item_id: 1, quantity_requested: 39, list_price: "3.20", requested_on: "2026-01-29" },
            { id: 144, requester_dept: "maintenance", item_id: 9, quantity_requested: 9, list_price: "14.30", requested_on: "2026-01-30" },
            { id: 145, requester_dept: "production", item_id: 20, quantity_requested: 184, list_price: "29.00", requested_on: "2026-01-21" },
            { id: 146, requester_dept: "production", item_id: 2, quantity_requested: 35, list_price: "9.50", requested_on: "2026-02-10" },
            { id: 147, requester_dept: "maintenance", item_id: 3, quantity_requested: 16, list_price: "6.40", requested_on: "2026-02-26" },
            { id: 148, requester_dept: "production", item_id: 2, quantity_requested: 113, list_price: "9.50", requested_on: "2026-01-29" },
            { id: 149, requester_dept: "warehouse", item_id: 8, quantity_requested: 135, list_price: "2.10", requested_on: "2026-02-08" },
            { id: 150, requester_dept: "maintenance", item_id: 10, quantity_requested: 160, list_price: "4.60", requested_on: "2026-01-24" },
        ],
    });
    await prisma.suppliers.createMany({
        data: [
            { id: 1, supplier_name: "Koch and Sons", country: "Poland", payment_terms: "net_30" },
            { id: 2, supplier_name: "Sauer Inc", country: "Poland", payment_terms: "net_14" },
            { id: 3, supplier_name: "Weimann Group", country: "Netherlands", payment_terms: "net_30" },
            { id: 4, supplier_name: "West - Hettinger", country: "Germany", payment_terms: "net_45" },
            { id: 5, supplier_name: "Boehm and Sons", country: "Poland", payment_terms: "net_45" },
            { id: 6, supplier_name: "Runolfsson LLC", country: "Portugal", payment_terms: "net_14" },
            { id: 7, supplier_name: "Waters Inc", country: "Germany", payment_terms: "net_60" },
            { id: 8, supplier_name: "Bauch - McKenzie", country: "Germany", payment_terms: "net_45" },
            { id: 9, supplier_name: "Lehner Group", country: "Italy", payment_terms: "net_30" },
            { id: 10, supplier_name: "Beer, Franecki and Daugherty", country: "Germany", payment_terms: "net_30" },
            { id: 11, supplier_name: "Schmidt, Zemlak and Prosacco-Fisher", country: "Italy", payment_terms: "net_30" },
            { id: 12, supplier_name: "Rohan - Klein", country: "Poland", payment_terms: "net_45" },
            { id: 13, supplier_name: "Mraz - Turcotte", country: "Italy", payment_terms: "net_14" },
            { id: 14, supplier_name: "Predovic LLC", country: "Poland", payment_terms: "net_30" },
        ],
    });
    await prisma.purchase_orders.createMany({
        data: [
            { id: 1, po_number: "PO-80372", supplier_id: 1, buyer_id: 4, ordered_on: "2026-03-11", payment_terms: "net_30" },
            { id: 2, po_number: "PO-43365", supplier_id: 3, buyer_id: 5, ordered_on: "2026-03-13", payment_terms: "net_30" },
            { id: 3, po_number: "PO-11181", supplier_id: 1, buyer_id: 3, ordered_on: "2026-03-31", payment_terms: "net_30" },
            { id: 4, po_number: "PO-55579", supplier_id: 14, buyer_id: 4, ordered_on: "2026-04-27", payment_terms: "net_30" },
            { id: 5, po_number: "PO-71799", supplier_id: 1, buyer_id: 5, ordered_on: "2026-04-01", payment_terms: "net_30" },
            { id: 6, po_number: "PO-19750", supplier_id: 1, buyer_id: 4, ordered_on: "2026-04-16", payment_terms: "net_30" },
            { id: 7, po_number: "PO-58264", supplier_id: 3, buyer_id: 3, ordered_on: "2026-03-19", payment_terms: "net_30" },
            { id: 8, po_number: "PO-82344", supplier_id: 1, buyer_id: 3, ordered_on: "2026-03-27", payment_terms: "net_30" },
            { id: 9, po_number: "PO-74786", supplier_id: 8, buyer_id: 2, ordered_on: "2026-03-06", payment_terms: "net_45" },
            { id: 10, po_number: "PO-26917", supplier_id: 1, buyer_id: 5, ordered_on: "2026-03-26", payment_terms: "net_30" },
            { id: 11, po_number: "PO-68676", supplier_id: 2, buyer_id: 4, ordered_on: "2026-04-25", payment_terms: "net_14" },
            { id: 12, po_number: "PO-78123", supplier_id: 1, buyer_id: 5, ordered_on: "2026-04-26", payment_terms: "net_30" },
            { id: 13, po_number: "PO-67625", supplier_id: 12, buyer_id: 4, ordered_on: "2026-04-09", payment_terms: "net_45" },
            { id: 14, po_number: "PO-30041", supplier_id: 5, buyer_id: 2, ordered_on: "2026-04-09", payment_terms: "net_45" },
            { id: 15, po_number: "PO-02657", supplier_id: 5, buyer_id: 4, ordered_on: "2026-03-28", payment_terms: "net_45" },
            { id: 16, po_number: "PO-51506", supplier_id: 4, buyer_id: 1, ordered_on: "2026-04-16", payment_terms: "net_45" },
            { id: 17, po_number: "PO-40586", supplier_id: 12, buyer_id: 1, ordered_on: "2026-03-23", payment_terms: "net_45" },
            { id: 18, po_number: "PO-63180", supplier_id: 5, buyer_id: 5, ordered_on: "2026-03-30", payment_terms: "net_45" },
            { id: 19, po_number: "PO-17361", supplier_id: 12, buyer_id: 4, ordered_on: "2026-04-21", payment_terms: "net_45" },
            { id: 20, po_number: "PO-39008", supplier_id: 3, buyer_id: 2, ordered_on: "2026-04-15", payment_terms: "net_30" },
            { id: 21, po_number: "PO-78126", supplier_id: 4, buyer_id: 3, ordered_on: "2026-03-26", payment_terms: "net_45" },
            { id: 22, po_number: "PO-84848", supplier_id: 2, buyer_id: 4, ordered_on: "2026-04-19", payment_terms: "net_14" },
            { id: 23, po_number: "PO-97806", supplier_id: 1, buyer_id: 5, ordered_on: "2026-04-08", payment_terms: "net_30" },
            { id: 24, po_number: "PO-32235", supplier_id: 1, buyer_id: 1, ordered_on: "2026-03-19", payment_terms: "net_30" },
            { id: 25, po_number: "PO-60875", supplier_id: 6, buyer_id: 3, ordered_on: "2026-03-13", payment_terms: "net_14" },
            { id: 26, po_number: "PO-85688", supplier_id: 3, buyer_id: 3, ordered_on: "2026-04-06", payment_terms: "net_30" },
            { id: 27, po_number: "PO-57140", supplier_id: 6, buyer_id: 3, ordered_on: "2026-04-24", payment_terms: "net_14" },
            { id: 28, po_number: "PO-99138", supplier_id: 10, buyer_id: 3, ordered_on: "2026-03-31", payment_terms: "net_30" },
            { id: 29, po_number: "PO-58902", supplier_id: 11, buyer_id: 5, ordered_on: "2026-04-18", payment_terms: "net_30" },
            { id: 30, po_number: "PO-91947", supplier_id: 6, buyer_id: 2, ordered_on: "2026-04-06", payment_terms: "net_14" },
            { id: 31, po_number: "PO-76984", supplier_id: 1, buyer_id: 1, ordered_on: "2026-03-03", payment_terms: "net_30" },
            { id: 32, po_number: "PO-63046", supplier_id: 1, buyer_id: 4, ordered_on: "2026-03-08", payment_terms: "net_30" },
            { id: 33, po_number: "PO-64380", supplier_id: 1, buyer_id: 3, ordered_on: "2026-03-15", payment_terms: "net_30" },
            { id: 34, po_number: "PO-21409", supplier_id: 1, buyer_id: 4, ordered_on: "2026-03-08", payment_terms: "net_30" },
            { id: 35, po_number: "PO-10040", supplier_id: 1, buyer_id: 2, ordered_on: "2026-04-12", payment_terms: "net_30" },
            { id: 36, po_number: "PO-58820", supplier_id: 1, buyer_id: 4, ordered_on: "2026-04-06", payment_terms: "net_30" },
        ],
    });
    await prisma.po_lines.createMany({
        data: [
            { id: 1, purchase_order_id: 23, requisition_id: 48, item_id: 5, quantity: 100, ordered_on: "2026-04-08", negotiated_factor: "1.019", unit_price: "18.85" },
            { id: 2, purchase_order_id: 36, requisition_id: 68, item_id: 10, quantity: 120, ordered_on: "2026-04-06", negotiated_factor: "0.975", unit_price: "4.48" },
            { id: 3, purchase_order_id: 35, requisition_id: 12, item_id: 1, quantity: 73, ordered_on: "2026-04-12", negotiated_factor: "0.975", unit_price: "3.12" },
            { id: 4, purchase_order_id: 33, requisition_id: 3, item_id: 4, quantity: 146, ordered_on: "2026-03-15", negotiated_factor: "0.946", unit_price: "4.54" },
            { id: 5, purchase_order_id: 12, requisition_id: 51, item_id: 2, quantity: 53, ordered_on: "2026-04-26", negotiated_factor: "0.952", unit_price: "9.04" },
            { id: 6, purchase_order_id: 15, requisition_id: 6, item_id: 4, quantity: 103, ordered_on: "2026-03-28", negotiated_factor: "0.970", unit_price: "4.66" },
            { id: 7, purchase_order_id: 1, requisition_id: 23, item_id: 4, quantity: 159, ordered_on: "2026-03-11", negotiated_factor: "0.949", unit_price: "4.56" },
            { id: 8, purchase_order_id: 13, requisition_id: 126, item_id: 1, quantity: 125, ordered_on: "2026-04-09", negotiated_factor: "0.982", unit_price: "3.14" },
            { id: 9, purchase_order_id: 3, requisition_id: 46, item_id: 12, quantity: 67, ordered_on: "2026-03-31", negotiated_factor: "0.987", unit_price: "7.70" },
            { id: 10, purchase_order_id: 16, requisition_id: 119, item_id: 1, quantity: 9, ordered_on: "2026-04-16", negotiated_factor: "0.998", unit_price: "3.19" },
            { id: 11, purchase_order_id: 5, requisition_id: 87, item_id: 9, quantity: 69, ordered_on: "2026-04-01", negotiated_factor: "0.992", unit_price: "14.19" },
            { id: 12, purchase_order_id: 5, requisition_id: 89, item_id: 1, quantity: 85, ordered_on: "2026-04-01", negotiated_factor: "0.989", unit_price: "3.16" },
            { id: 13, purchase_order_id: 33, requisition_id: 143, item_id: 1, quantity: 39, ordered_on: "2026-03-15", negotiated_factor: "0.971", unit_price: "3.11" },
            { id: 14, purchase_order_id: 16, requisition_id: 91, item_id: 17, quantity: 42, ordered_on: "2026-04-16", negotiated_factor: "0.981", unit_price: "11.18" },
            { id: 15, purchase_order_id: 34, requisition_id: 103, item_id: 13, quantity: 131, ordered_on: "2026-03-08", negotiated_factor: "0.957", unit_price: "61.25" },
            { id: 16, purchase_order_id: 10, requisition_id: 116, item_id: 4, quantity: 43, ordered_on: "2026-03-26", negotiated_factor: "0.954", unit_price: "4.58" },
            { id: 17, purchase_order_id: 4, requisition_id: 90, item_id: 4, quantity: 50, ordered_on: "2026-04-27", negotiated_factor: "1.053", unit_price: "5.05" },
            { id: 18, purchase_order_id: 33, requisition_id: 55, item_id: 9, quantity: 158, ordered_on: "2026-03-15", negotiated_factor: "1.036", unit_price: "14.81" },
            { id: 19, purchase_order_id: 5, requisition_id: 44, item_id: 4, quantity: 66, ordered_on: "2026-04-01", negotiated_factor: "0.966", unit_price: "4.64" },
            { id: 20, purchase_order_id: 21, requisition_id: 118, item_id: 7, quantity: 184, ordered_on: "2026-03-26", negotiated_factor: "0.940", unit_price: "9.31" },
            { id: 21, purchase_order_id: 35, requisition_id: 122, item_id: 15, quantity: 139, ordered_on: "2026-04-12", negotiated_factor: "0.986", unit_price: "74.94" },
            { id: 22, purchase_order_id: 21, requisition_id: 38, item_id: 12, quantity: 165, ordered_on: "2026-03-26", negotiated_factor: "0.933", unit_price: "7.28" },
            { id: 23, purchase_order_id: 15, requisition_id: 57, item_id: 10, quantity: 70, ordered_on: "2026-03-28", negotiated_factor: "0.951", unit_price: "4.37" },
            { id: 24, purchase_order_id: 28, requisition_id: 73, item_id: 6, quantity: 8, ordered_on: "2026-03-31", negotiated_factor: "0.956", unit_price: "20.08" },
            { id: 25, purchase_order_id: 6, requisition_id: 115, item_id: 1, quantity: 145, ordered_on: "2026-04-16", negotiated_factor: "0.998", unit_price: "3.19" },
            { id: 26, purchase_order_id: 11, requisition_id: 101, item_id: 5, quantity: 190, ordered_on: "2026-04-25", negotiated_factor: "0.997", unit_price: "18.44" },
            { id: 27, purchase_order_id: 6, requisition_id: 65, item_id: 8, quantity: 5, ordered_on: "2026-04-16", negotiated_factor: "0.928", unit_price: "1.95" },
            { id: 28, purchase_order_id: 14, requisition_id: 129, item_id: 6, quantity: 7, ordered_on: "2026-04-09", negotiated_factor: "0.934", unit_price: "19.61" },
            { id: 29, purchase_order_id: 35, requisition_id: 78, item_id: 3, quantity: 113, ordered_on: "2026-04-12", negotiated_factor: "0.978", unit_price: "6.26" },
            { id: 30, purchase_order_id: 13, requisition_id: 121, item_id: 4, quantity: 7, ordered_on: "2026-04-09", negotiated_factor: "0.940", unit_price: "4.51" },
            { id: 31, purchase_order_id: 22, requisition_id: 132, item_id: 5, quantity: 98, ordered_on: "2026-04-19", negotiated_factor: "0.964", unit_price: "17.83" },
            { id: 32, purchase_order_id: 22, requisition_id: 16, item_id: 1, quantity: 105, ordered_on: "2026-04-19", negotiated_factor: "0.929", unit_price: "2.97" },
            { id: 33, purchase_order_id: 17, requisition_id: 74, item_id: 3, quantity: 179, ordered_on: "2026-03-23", negotiated_factor: "1.001", unit_price: "6.41" },
            { id: 34, purchase_order_id: 25, requisition_id: 25, item_id: 1, quantity: 5, ordered_on: "2026-03-13", negotiated_factor: "0.899", unit_price: "2.88" },
            { id: 35, purchase_order_id: 19, requisition_id: 28, item_id: 1, quantity: 199, ordered_on: "2026-04-21", negotiated_factor: "0.955", unit_price: "3.06" },
            { id: 36, purchase_order_id: 8, requisition_id: 15, item_id: 1, quantity: 6, ordered_on: "2026-03-27", negotiated_factor: "0.940", unit_price: "3.01" },
            { id: 37, purchase_order_id: 9, requisition_id: 145, item_id: 20, quantity: 184, ordered_on: "2026-03-06", negotiated_factor: "0.957", unit_price: "27.75" },
            { id: 38, purchase_order_id: 14, requisition_id: 99, item_id: 9, quantity: 42, ordered_on: "2026-04-09", negotiated_factor: "0.946", unit_price: "13.53" },
            { id: 39, purchase_order_id: 21, requisition_id: 131, item_id: 6, quantity: 6, ordered_on: "2026-03-26", negotiated_factor: "0.948", unit_price: "19.91" },
            { id: 40, purchase_order_id: 26, requisition_id: 36, item_id: 12, quantity: 83, ordered_on: "2026-04-06", negotiated_factor: "0.982", unit_price: "7.66" },
            { id: 41, purchase_order_id: 30, requisition_id: 111, item_id: 3, quantity: 18, ordered_on: "2026-04-06", negotiated_factor: "0.981", unit_price: "6.28" },
            { id: 42, purchase_order_id: 29, requisition_id: 97, item_id: 2, quantity: 5, ordered_on: "2026-04-18", negotiated_factor: "0.919", unit_price: "8.73" },
            { id: 43, purchase_order_id: 32, requisition_id: 56, item_id: 3, quantity: 85, ordered_on: "2026-03-08", negotiated_factor: "0.982", unit_price: "6.28" },
            { id: 44, purchase_order_id: 15, requisition_id: 83, item_id: 19, quantity: 36, ordered_on: "2026-03-28", negotiated_factor: "0.966", unit_price: "5.99" },
            { id: 45, purchase_order_id: 27, requisition_id: 62, item_id: 2, quantity: 127, ordered_on: "2026-04-24", negotiated_factor: "0.949", unit_price: "9.02" },
            { id: 46, purchase_order_id: 22, requisition_id: 80, item_id: 9, quantity: 75, ordered_on: "2026-04-19", negotiated_factor: "1.014", unit_price: "14.50" },
            { id: 47, purchase_order_id: 22, requisition_id: 61, item_id: 2, quantity: 36, ordered_on: "2026-04-19", negotiated_factor: "0.985", unit_price: "9.36" },
            { id: 48, purchase_order_id: 34, requisition_id: 140, item_id: 1, quantity: 59, ordered_on: "2026-03-08", negotiated_factor: "0.970", unit_price: "3.10" },
            { id: 49, purchase_order_id: 24, requisition_id: 34, item_id: 7, quantity: 147, ordered_on: "2026-03-19", negotiated_factor: "0.949", unit_price: "9.40" },
            { id: 50, purchase_order_id: 14, requisition_id: 150, item_id: 10, quantity: 160, ordered_on: "2026-04-09", negotiated_factor: "0.954", unit_price: "4.39" },
            { id: 51, purchase_order_id: 7, requisition_id: 85, item_id: 1, quantity: 119, ordered_on: "2026-03-19", negotiated_factor: "0.947", unit_price: "3.03" },
            { id: 52, purchase_order_id: 18, requisition_id: 88, item_id: 4, quantity: 39, ordered_on: "2026-03-30", negotiated_factor: "0.991", unit_price: "4.76" },
            { id: 53, purchase_order_id: 23, requisition_id: 77, item_id: 2, quantity: 6, ordered_on: "2026-04-08", negotiated_factor: "0.979", unit_price: "9.30" },
            { id: 54, purchase_order_id: 29, requisition_id: 32, item_id: 1, quantity: 191, ordered_on: "2026-04-18", negotiated_factor: "0.993", unit_price: "3.18" },
            { id: 55, purchase_order_id: 24, requisition_id: 58, item_id: 14, quantity: 76, ordered_on: "2026-03-19", negotiated_factor: "0.975", unit_price: "17.06" },
            { id: 56, purchase_order_id: 23, requisition_id: 142, item_id: 2, quantity: 153, ordered_on: "2026-04-08", negotiated_factor: "0.981", unit_price: "9.32" },
            { id: 57, purchase_order_id: 32, requisition_id: 47, item_id: 1, quantity: 5, ordered_on: "2026-03-08", negotiated_factor: "0.937", unit_price: "3.00" },
            { id: 58, purchase_order_id: 35, requisition_id: 4, item_id: 10, quantity: 69, ordered_on: "2026-04-12", negotiated_factor: "0.967", unit_price: "4.45" },
            { id: 59, purchase_order_id: 11, requisition_id: 141, item_id: 7, quantity: 15, ordered_on: "2026-04-25", negotiated_factor: "0.984", unit_price: "9.74" },
            { id: 60, purchase_order_id: 33, requisition_id: 43, item_id: 17, quantity: 5, ordered_on: "2026-03-15", negotiated_factor: "0.978", unit_price: "11.15" },
            { id: 61, purchase_order_id: 14, requisition_id: 18, item_id: 9, quantity: 97, ordered_on: "2026-04-09", negotiated_factor: "0.997", unit_price: "14.26" },
            { id: 62, purchase_order_id: 2, requisition_id: 1, item_id: 2, quantity: 73, ordered_on: "2026-03-13", negotiated_factor: "0.978", unit_price: "9.29" },
            { id: 63, purchase_order_id: 20, requisition_id: 109, item_id: 1, quantity: 148, ordered_on: "2026-04-15", negotiated_factor: "0.988", unit_price: "3.16" },
            { id: 64, purchase_order_id: 10, requisition_id: 125, item_id: 1, quantity: 56, ordered_on: "2026-03-26", negotiated_factor: "0.941", unit_price: "3.01" },
            { id: 65, purchase_order_id: 28, requisition_id: 21, item_id: 2, quantity: 131, ordered_on: "2026-03-31", negotiated_factor: "0.961", unit_price: "9.13" },
            { id: 66, purchase_order_id: 30, requisition_id: 71, item_id: 7, quantity: 13, ordered_on: "2026-04-06", negotiated_factor: "0.975", unit_price: "9.65" },
            { id: 67, purchase_order_id: 3, requisition_id: 130, item_id: 7, quantity: 197, ordered_on: "2026-03-31", negotiated_factor: "0.989", unit_price: "9.79" },
            { id: 68, purchase_order_id: 32, requisition_id: 54, item_id: 4, quantity: 147, ordered_on: "2026-03-08", negotiated_factor: "0.995", unit_price: "4.78" },
            { id: 69, purchase_order_id: 27, requisition_id: 76, item_id: 1, quantity: 6, ordered_on: "2026-04-24", negotiated_factor: "1.012", unit_price: "3.24" },
            { id: 70, purchase_order_id: 8, requisition_id: 98, item_id: 2, quantity: 25, ordered_on: "2026-03-27", negotiated_factor: "0.912", unit_price: "8.66" },
            { id: 71, purchase_order_id: 3, requisition_id: 67, item_id: 1, quantity: 176, ordered_on: "2026-03-31", negotiated_factor: "0.961", unit_price: "3.08" },
            { id: 72, purchase_order_id: 6, requisition_id: 40, item_id: 1, quantity: 75, ordered_on: "2026-04-16", negotiated_factor: "1.000", unit_price: "3.20" },
            { id: 73, purchase_order_id: 13, requisition_id: 27, item_id: 5, quantity: 180, ordered_on: "2026-04-09", negotiated_factor: "0.928", unit_price: "17.17" },
            { id: 74, purchase_order_id: 31, requisition_id: 22, item_id: 18, quantity: 69, ordered_on: "2026-03-03", negotiated_factor: "0.912", unit_price: "10.94" },
            { id: 75, purchase_order_id: 7, requisition_id: 24, item_id: 1, quantity: 21, ordered_on: "2026-03-19", negotiated_factor: "0.968", unit_price: "3.10" },
            { id: 76, purchase_order_id: 11, requisition_id: 138, item_id: 2, quantity: 5, ordered_on: "2026-04-25", negotiated_factor: "0.994", unit_price: "9.44" },
            { id: 77, purchase_order_id: 27, requisition_id: 50, item_id: 4, quantity: 67, ordered_on: "2026-04-24", negotiated_factor: "0.968", unit_price: "4.65" },
            { id: 78, purchase_order_id: 23, requisition_id: 93, item_id: 18, quantity: 175, ordered_on: "2026-04-08", negotiated_factor: "1.000", unit_price: "12.00" },
            { id: 79, purchase_order_id: 3, requisition_id: 107, item_id: 1, quantity: 11, ordered_on: "2026-03-31", negotiated_factor: "0.950", unit_price: "3.04" },
            { id: 80, purchase_order_id: 10, requisition_id: 5, item_id: 9, quantity: 118, ordered_on: "2026-03-26", negotiated_factor: "0.974", unit_price: "13.93" },
            { id: 81, purchase_order_id: 24, requisition_id: 136, item_id: 2, quantity: 133, ordered_on: "2026-03-19", negotiated_factor: "0.952", unit_price: "9.04" },
            { id: 82, purchase_order_id: 31, requisition_id: 112, item_id: 8, quantity: 79, ordered_on: "2026-03-03", negotiated_factor: "0.941", unit_price: "1.98" },
            { id: 83, purchase_order_id: 29, requisition_id: 106, item_id: 6, quantity: 56, ordered_on: "2026-04-18", negotiated_factor: "0.969", unit_price: "20.35" },
            { id: 84, purchase_order_id: 16, requisition_id: 123, item_id: 3, quantity: 7, ordered_on: "2026-04-16", negotiated_factor: "0.950", unit_price: "6.08" },
            { id: 85, purchase_order_id: 20, requisition_id: 79, item_id: 5, quantity: 5, ordered_on: "2026-04-15", negotiated_factor: "0.969", unit_price: "17.93" },
            { id: 86, purchase_order_id: 12, requisition_id: 144, item_id: 9, quantity: 9, ordered_on: "2026-04-26", negotiated_factor: "0.959", unit_price: "13.71" },
            { id: 87, purchase_order_id: 28, requisition_id: 127, item_id: 1, quantity: 18, ordered_on: "2026-03-31", negotiated_factor: "0.962", unit_price: "3.08" },
            { id: 88, purchase_order_id: 4, requisition_id: 124, item_id: 5, quantity: 97, ordered_on: "2026-04-27", negotiated_factor: "1.018", unit_price: "18.83" },
            { id: 89, purchase_order_id: 6, requisition_id: 84, item_id: 1, quantity: 97, ordered_on: "2026-04-16", negotiated_factor: "0.988", unit_price: "3.16" },
            { id: 90, purchase_order_id: 13, requisition_id: 100, item_id: 9, quantity: 6, ordered_on: "2026-04-09", negotiated_factor: "0.905", unit_price: "12.94" },
            { id: 91, purchase_order_id: 30, requisition_id: 149, item_id: 8, quantity: 135, ordered_on: "2026-04-06", negotiated_factor: "0.999", unit_price: "2.10" },
        ],
    });
    await prisma.goods_receipts.createMany({
        data: [
            { id: 1, po_line_id: 44, received_on: "2026-04-02", received_share: "0.84", received_qty: "30", condition: "good" },
            { id: 2, po_line_id: 91, received_on: "2026-04-25", received_share: "0.98", received_qty: "132", condition: "damaged" },
            { id: 3, po_line_id: 7, received_on: "2026-04-04", received_share: "0.87", received_qty: "138", condition: "good" },
            { id: 4, po_line_id: 43, received_on: "2026-03-31", received_share: "0.68", received_qty: "58", condition: "good" },
            { id: 5, po_line_id: 11, received_on: "2026-04-13", received_share: "0.88", received_qty: "61", condition: "good" },
            { id: 6, po_line_id: 27, received_on: "2026-04-28", received_share: "0.98", received_qty: "5", condition: "good" },
            { id: 7, po_line_id: 80, received_on: "2026-03-26", received_share: "0.97", received_qty: "114", condition: "good" },
            { id: 8, po_line_id: 42, received_on: "2026-05-10", received_share: "0.84", received_qty: "4", condition: "good" },
            { id: 9, po_line_id: 15, received_on: "2026-03-15", received_share: "0.72", received_qty: "94", condition: "good" },
            { id: 10, po_line_id: 16, received_on: "2026-04-16", received_share: "0.96", received_qty: "41", condition: "good" },
            { id: 11, po_line_id: 3, received_on: "2026-04-18", received_share: "0.54", received_qty: "39", condition: "good" },
            { id: 12, po_line_id: 33, received_on: "2026-04-11", received_share: "0.95", received_qty: "170", condition: "good" },
            { id: 13, po_line_id: 64, received_on: "2026-03-31", received_share: "0.36", received_qty: "20", condition: "good" },
            { id: 14, po_line_id: 20, received_on: "2026-04-02", received_share: "0.92", received_qty: "169", condition: "good" },
            { id: 15, po_line_id: 91, received_on: "2026-04-08", received_share: "0.32", received_qty: "43", condition: "good" },
            { id: 16, po_line_id: 41, received_on: "2026-04-11", received_share: "0.95", received_qty: "17", condition: "good" },
            { id: 17, po_line_id: 72, received_on: "2026-05-18", received_share: "0.99", received_qty: "74", condition: "good" },
            { id: 18, po_line_id: 12, received_on: "2026-04-03", received_share: "0.51", received_qty: "43", condition: "good" },
            { id: 19, po_line_id: 53, received_on: "2026-05-13", received_share: "0.96", received_qty: "6", condition: "good" },
            { id: 20, po_line_id: 48, received_on: "2026-03-13", received_share: "0.65", received_qty: "38", condition: "good" },
            { id: 21, po_line_id: 83, received_on: "2026-05-16", received_share: "0.59", received_qty: "33", condition: "good" },
            { id: 22, po_line_id: 42, received_on: "2026-05-03", received_share: "0.75", received_qty: "4", condition: "good" },
            { id: 23, po_line_id: 33, received_on: "2026-04-03", received_share: "0.37", received_qty: "66", condition: "good" },
            { id: 24, po_line_id: 47, received_on: "2026-04-25", received_share: "0.80", received_qty: "29", condition: "good" },
            { id: 25, po_line_id: 77, received_on: "2026-05-04", received_share: "0.80", received_qty: "54", condition: "good" },
            { id: 26, po_line_id: 65, received_on: "2026-04-11", received_share: "0.74", received_qty: "97", condition: "good" },
            { id: 27, po_line_id: 45, received_on: "2026-05-05", received_share: "1.00", received_qty: "127", condition: "good" },
            { id: 28, po_line_id: 67, received_on: "2026-05-06", received_share: "0.62", received_qty: "122", condition: "good" },
            { id: 29, po_line_id: 34, received_on: "2026-04-04", received_share: "0.98", received_qty: "5", condition: "good" },
            { id: 30, po_line_id: 29, received_on: "2026-05-07", received_share: "1.00", received_qty: "113", condition: "good" },
            { id: 31, po_line_id: 4, received_on: "2026-04-24", received_share: "0.44", received_qty: "64", condition: "good" },
            { id: 32, po_line_id: 76, received_on: "2026-06-03", received_share: "1.00", received_qty: "5", condition: "good" },
            { id: 33, po_line_id: 45, received_on: "2026-05-16", received_share: "0.92", received_qty: "117", condition: "damaged" },
            { id: 34, po_line_id: 62, received_on: "2026-03-18", received_share: "0.45", received_qty: "33", condition: "good" },
            { id: 35, po_line_id: 59, received_on: "2026-05-05", received_share: "0.98", received_qty: "15", condition: "good" },
            { id: 36, po_line_id: 81, received_on: "2026-03-23", received_share: "0.32", received_qty: "43", condition: "good" },
            { id: 37, po_line_id: 30, received_on: "2026-04-14", received_share: "0.96", received_qty: "7", condition: "good" },
            { id: 38, po_line_id: 19, received_on: "2026-04-10", received_share: "0.77", received_qty: "51", condition: "good" },
            { id: 39, po_line_id: 59, received_on: "2026-05-27", received_share: "0.56", received_qty: "8", condition: "good" },
            { id: 40, po_line_id: 57, received_on: "2026-03-08", received_share: "1.00", received_qty: "5", condition: "good" },
            { id: 41, po_line_id: 44, received_on: "2026-04-08", received_share: "0.82", received_qty: "30", condition: "good" },
            { id: 42, po_line_id: 58, received_on: "2026-05-10", received_share: "0.66", received_qty: "46", condition: "damaged" },
            { id: 43, po_line_id: 50, received_on: "2026-04-14", received_share: "0.94", received_qty: "150", condition: "good" },
            { id: 44, po_line_id: 9, received_on: "2026-04-02", received_share: "0.42", received_qty: "28", condition: "good" },
            { id: 45, po_line_id: 65, received_on: "2026-04-18", received_share: "0.97", received_qty: "127", condition: "good" },
            { id: 46, po_line_id: 71, received_on: "2026-04-12", received_share: "0.67", received_qty: "118", condition: "good" },
            { id: 47, po_line_id: 81, received_on: "2026-03-30", received_share: "0.52", received_qty: "69", condition: "good" },
            { id: 48, po_line_id: 88, received_on: "2026-05-24", received_share: "0.99", received_qty: "96", condition: "good" },
            { id: 49, po_line_id: 4, received_on: "2026-03-15", received_share: "0.98", received_qty: "143", condition: "good" },
            { id: 50, po_line_id: 82, received_on: "2026-03-19", received_share: "0.69", received_qty: "55", condition: "good" },
            { id: 51, po_line_id: 63, received_on: "2026-05-08", received_share: "0.97", received_qty: "144", condition: "good" },
            { id: 52, po_line_id: 38, received_on: "2026-05-06", received_share: "0.51", received_qty: "21", condition: "good" },
            { id: 53, po_line_id: 24, received_on: "2026-04-30", received_share: "0.43", received_qty: "3", condition: "good" },
            { id: 54, po_line_id: 54, received_on: "2026-05-10", received_share: "0.42", received_qty: "80", condition: "good" },
            { id: 55, po_line_id: 76, received_on: "2026-05-15", received_share: "0.99", received_qty: "5", condition: "good" },
            { id: 56, po_line_id: 17, received_on: "2026-06-04", received_share: "1.00", received_qty: "50", condition: "good" },
            { id: 57, po_line_id: 61, received_on: "2026-05-06", received_share: "1.00", received_qty: "97", condition: "good" },
            { id: 58, po_line_id: 90, received_on: "2026-04-25", received_share: "0.65", received_qty: "4", condition: "good" },
            { id: 59, po_line_id: 35, received_on: "2026-04-24", received_share: "0.32", received_qty: "64", condition: "good" },
            { id: 60, po_line_id: 88, received_on: "2026-05-27", received_share: "1.00", received_qty: "97", condition: "good" },
            { id: 61, po_line_id: 72, received_on: "2026-05-15", received_share: "0.41", received_qty: "31", condition: "good" },
            { id: 62, po_line_id: 86, received_on: "2026-05-04", received_share: "0.90", received_qty: "8", condition: "good" },
            { id: 63, po_line_id: 40, received_on: "2026-05-04", received_share: "0.54", received_qty: "45", condition: "damaged" },
            { id: 64, po_line_id: 7, received_on: "2026-03-12", received_share: "0.67", received_qty: "107", condition: "good" },
            { id: 65, po_line_id: 29, received_on: "2026-05-22", received_share: "0.50", received_qty: "57", condition: "good" },
            { id: 66, po_line_id: 82, received_on: "2026-03-31", received_share: "0.88", received_qty: "70", condition: "good" },
            { id: 67, po_line_id: 16, received_on: "2026-04-26", received_share: "0.91", received_qty: "39", condition: "good" },
            { id: 68, po_line_id: 58, received_on: "2026-05-12", received_share: "0.36", received_qty: "25", condition: "good" },
            { id: 69, po_line_id: 67, received_on: "2026-04-28", received_share: "0.55", received_qty: "108", condition: "good" },
            { id: 70, po_line_id: 83, received_on: "2026-05-21", received_share: "0.97", received_qty: "54", condition: "good" },
            { id: 71, po_line_id: 46, received_on: "2026-05-28", received_share: "0.63", received_qty: "47", condition: "good" },
            { id: 72, po_line_id: 43, received_on: "2026-04-15", received_share: "1.00", received_qty: "85", condition: "good" },
            { id: 73, po_line_id: 89, received_on: "2026-04-18", received_share: "0.90", received_qty: "87", condition: "good" },
            { id: 74, po_line_id: 47, received_on: "2026-04-30", received_share: "0.98", received_qty: "35", condition: "good" },
            { id: 75, po_line_id: 46, received_on: "2026-04-20", received_share: "0.45", received_qty: "34", condition: "good" },
            { id: 76, po_line_id: 63, received_on: "2026-04-21", received_share: "0.31", received_qty: "46", condition: "good" },
            { id: 77, po_line_id: 41, received_on: "2026-04-15", received_share: "0.45", received_qty: "8", condition: "good" },
            { id: 78, po_line_id: 39, received_on: "2026-04-26", received_share: "0.88", received_qty: "5", condition: "good" },
            { id: 79, po_line_id: 51, received_on: "2026-04-28", received_share: "0.94", received_qty: "112", condition: "damaged" },
            { id: 80, po_line_id: 64, received_on: "2026-04-08", received_share: "0.99", received_qty: "55", condition: "good" },
            { id: 81, po_line_id: 14, received_on: "2026-05-26", received_share: "0.72", received_qty: "30", condition: "good" },
            { id: 82, po_line_id: 73, received_on: "2026-04-25", received_share: "0.75", received_qty: "135", condition: "wrong_item" },
            { id: 83, po_line_id: 31, received_on: "2026-05-02", received_share: "0.96", received_qty: "94", condition: "good" },
            { id: 84, po_line_id: 11, received_on: "2026-04-03", received_share: "0.89", received_qty: "61", condition: "good" },
            { id: 85, po_line_id: 80, received_on: "2026-04-27", received_share: "0.91", received_qty: "107", condition: "good" },
            { id: 86, po_line_id: 10, received_on: "2026-04-27", received_share: "0.49", received_qty: "4", condition: "good" },
            { id: 87, po_line_id: 89, received_on: "2026-05-26", received_share: "0.97", received_qty: "94", condition: "good" },
            { id: 88, po_line_id: 5, received_on: "2026-05-21", received_share: "1.00", received_qty: "53", condition: "good" },
            { id: 89, po_line_id: 28, received_on: "2026-05-09", received_share: "0.91", received_qty: "6", condition: "good" },
        ],
    });
    await prisma.supplier_invoices.createMany({
        data: [
            { id: 1, po_line_id: 39, invoice_no: "INV4201575", invoice_date: "2026-04-06", qty_ratio: "1.002", invoiced_qty: "6", billing_drift: "0.987", billed_unit_price: "19.65", status: "approved", paid_on: null },
            { id: 2, po_line_id: 21, invoice_no: "INV8332870", invoice_date: "2026-06-04", qty_ratio: "1.026", invoiced_qty: "143", billing_drift: "1.008", billed_unit_price: "75.54", status: "approved", paid_on: null },
            { id: 3, po_line_id: 38, invoice_no: "INV1498300", invoice_date: "2026-06-12", qty_ratio: "0.991", invoiced_qty: "42", billing_drift: "0.984", billed_unit_price: "13.31", status: "paid", paid_on: "2026-07-19" },
            { id: 4, po_line_id: 64, invoice_no: "INV6165198", invoice_date: "2026-04-22", qty_ratio: "0.974", invoiced_qty: "55", billing_drift: "1.010", billed_unit_price: "3.04", status: "paid", paid_on: "2026-05-23" },
            { id: 5, po_line_id: 66, invoice_no: "INV6080537", invoice_date: "2026-05-30", qty_ratio: "0.967", invoiced_qty: "13", billing_drift: "1.012", billed_unit_price: "9.77", status: "paid", paid_on: "2026-08-07" },
            { id: 6, po_line_id: 61, invoice_no: "INV3181750", invoice_date: "2026-05-13", qty_ratio: "1.015", invoiced_qty: "98", billing_drift: "1.015", billed_unit_price: "14.47", status: "disputed", paid_on: null },
            { id: 7, po_line_id: 44, invoice_no: "INV9686031", invoice_date: "2026-06-05", qty_ratio: "1.047", invoiced_qty: "38", billing_drift: "1.027", billed_unit_price: "6.15", status: "paid", paid_on: "2026-06-28" },
            { id: 8, po_line_id: 2, invoice_no: "INV4824748", invoice_date: "2026-05-31", qty_ratio: "0.999", invoiced_qty: "120", billing_drift: "1.015", billed_unit_price: "4.55", status: "paid", paid_on: "2026-06-20" },
            { id: 9, po_line_id: 76, invoice_no: "INV0243210", invoice_date: "2026-06-28", qty_ratio: "0.968", invoiced_qty: "5", billing_drift: "1.035", billed_unit_price: "9.77", status: "approved", paid_on: null },
            { id: 10, po_line_id: 31, invoice_no: "INV0325607", invoice_date: "2026-06-07", qty_ratio: "1.050", invoiced_qty: "103", billing_drift: "0.995", billed_unit_price: "17.74", status: "on_hold", paid_on: null },
            { id: 11, po_line_id: 39, invoice_no: "INV7332493", invoice_date: "2026-06-08", qty_ratio: "1.026", invoiced_qty: "6", billing_drift: "1.026", billed_unit_price: "20.43", status: "paid", paid_on: "2026-08-16" },
            { id: 12, po_line_id: 73, invoice_no: "INV8993397", invoice_date: "2026-06-05", qty_ratio: "1.017", invoiced_qty: "183", billing_drift: "1.026", billed_unit_price: "17.62", status: "paid", paid_on: "2026-06-10" },
            { id: 13, po_line_id: 45, invoice_no: "INV4233700", invoice_date: "2026-04-28", qty_ratio: "0.987", invoiced_qty: "125", billing_drift: "1.000", billed_unit_price: "9.02", status: "paid", paid_on: "2026-06-02" },
            { id: 14, po_line_id: 30, invoice_no: "INV5750505", invoice_date: "2026-05-24", qty_ratio: "1.037", invoiced_qty: "7", billing_drift: "1.022", billed_unit_price: "4.61", status: "paid", paid_on: "2026-07-15" },
            { id: 15, po_line_id: 80, invoice_no: "INV4076671", invoice_date: "2026-06-02", qty_ratio: "1.007", invoiced_qty: "119", billing_drift: "0.991", billed_unit_price: "13.80", status: "paid", paid_on: "2026-07-14" },
            { id: 16, po_line_id: 32, invoice_no: "INV0078626", invoice_date: "2026-06-13", qty_ratio: "0.998", invoiced_qty: "105", billing_drift: "1.016", billed_unit_price: "3.02", status: "paid", paid_on: "2026-06-22" },
            { id: 17, po_line_id: 54, invoice_no: "INV2768376", invoice_date: "2026-05-17", qty_ratio: "0.934", invoiced_qty: "178", billing_drift: "0.995", billed_unit_price: "3.16", status: "paid", paid_on: "2026-06-16" },
            { id: 18, po_line_id: 90, invoice_no: "INV9869544", invoice_date: "2026-04-30", qty_ratio: "1.019", invoiced_qty: "6", billing_drift: "1.001", billed_unit_price: "12.95", status: "paid", paid_on: "2026-05-25" },
            { id: 19, po_line_id: 18, invoice_no: "INV1245143", invoice_date: "2026-04-10", qty_ratio: "1.011", invoiced_qty: "160", billing_drift: "0.992", billed_unit_price: "14.69", status: "disputed", paid_on: null },
            { id: 20, po_line_id: 31, invoice_no: "INV2347984", invoice_date: "2026-04-30", qty_ratio: "0.999", invoiced_qty: "98", billing_drift: "1.023", billed_unit_price: "18.24", status: "paid", paid_on: "2026-05-05" },
            { id: 21, po_line_id: 88, invoice_no: "INV3384882", invoice_date: "2026-06-28", qty_ratio: "0.959", invoiced_qty: "93", billing_drift: "1.021", billed_unit_price: "19.23", status: "approved", paid_on: null },
            { id: 22, po_line_id: 37, invoice_no: "INV1622846", invoice_date: "2026-03-18", qty_ratio: "0.964", invoiced_qty: "177", billing_drift: "1.025", billed_unit_price: "28.44", status: "approved", paid_on: null },
            { id: 23, po_line_id: 20, invoice_no: "INV3291644", invoice_date: "2026-04-16", qty_ratio: "1.040", invoiced_qty: "191", billing_drift: "1.005", billed_unit_price: "9.36", status: "paid", paid_on: "2026-05-18" },
            { id: 24, po_line_id: 80, invoice_no: "INV9198205", invoice_date: "2026-05-30", qty_ratio: "1.031", invoiced_qty: "122", billing_drift: "0.996", billed_unit_price: "13.87", status: "approved", paid_on: null },
            { id: 25, po_line_id: 70, invoice_no: "INV3860893", invoice_date: "2026-06-01", qty_ratio: "1.044", invoiced_qty: "26", billing_drift: "0.993", billed_unit_price: "8.60", status: "disputed", paid_on: null },
            { id: 26, po_line_id: 30, invoice_no: "INV2436983", invoice_date: "2026-04-17", qty_ratio: "1.045", invoiced_qty: "7", billing_drift: "1.004", billed_unit_price: "4.53", status: "on_hold", paid_on: null },
            { id: 27, po_line_id: 40, invoice_no: "INV2669610", invoice_date: "2026-05-27", qty_ratio: "1.009", invoiced_qty: "84", billing_drift: "1.003", billed_unit_price: "7.68", status: "paid", paid_on: "2026-06-04" },
            { id: 28, po_line_id: 52, invoice_no: "INV9548505", invoice_date: "2026-04-09", qty_ratio: "0.965", invoiced_qty: "38", billing_drift: "0.984", billed_unit_price: "4.68", status: "paid", paid_on: "2026-06-15" },
            { id: 29, po_line_id: 9, invoice_no: "INV0007584", invoice_date: "2026-04-16", qty_ratio: "0.941", invoiced_qty: "63", billing_drift: "1.004", billed_unit_price: "7.73", status: "paid", paid_on: "2026-06-12" },
            { id: 30, po_line_id: 27, invoice_no: "INV3587351", invoice_date: "2026-06-13", qty_ratio: "0.963", invoiced_qty: "5", billing_drift: "0.993", billed_unit_price: "1.94", status: "on_hold", paid_on: null },
            { id: 31, po_line_id: 38, invoice_no: "INV8794481", invoice_date: "2026-05-19", qty_ratio: "1.016", invoiced_qty: "43", billing_drift: "1.011", billed_unit_price: "13.68", status: "approved", paid_on: null },
            { id: 32, po_line_id: 24, invoice_no: "INV2663139", invoice_date: "2026-04-30", qty_ratio: "0.993", invoiced_qty: "8", billing_drift: "1.017", billed_unit_price: "20.42", status: "paid", paid_on: "2026-06-27" },
            { id: 33, po_line_id: 25, invoice_no: "INV7562775", invoice_date: "2026-06-13", qty_ratio: "0.998", invoiced_qty: "145", billing_drift: "0.989", billed_unit_price: "3.15", status: "approved", paid_on: null },
            { id: 34, po_line_id: 72, invoice_no: "INV3284247", invoice_date: "2026-04-20", qty_ratio: "0.954", invoiced_qty: "72", billing_drift: "1.011", billed_unit_price: "3.24", status: "approved", paid_on: null },
            { id: 35, po_line_id: 66, invoice_no: "INV6133213", invoice_date: "2026-04-18", qty_ratio: "0.945", invoiced_qty: "12", billing_drift: "1.001", billed_unit_price: "9.66", status: "paid", paid_on: "2026-06-22" },
            { id: 36, po_line_id: 13, invoice_no: "INV6811316", invoice_date: "2026-04-10", qty_ratio: "1.037", invoiced_qty: "40", billing_drift: "1.020", billed_unit_price: "3.17", status: "paid", paid_on: "2026-06-10" },
            { id: 37, po_line_id: 25, invoice_no: "INV1182616", invoice_date: "2026-04-19", qty_ratio: "1.017", invoiced_qty: "147", billing_drift: "1.009", billed_unit_price: "3.22", status: "paid", paid_on: "2026-05-19" },
            { id: 38, po_line_id: 56, invoice_no: "INV9369073", invoice_date: "2026-05-27", qty_ratio: "0.962", invoiced_qty: "147", billing_drift: "1.028", billed_unit_price: "9.58", status: "approved", paid_on: null },
            { id: 39, po_line_id: 81, invoice_no: "INV9886092", invoice_date: "2026-03-30", qty_ratio: "1.074", invoiced_qty: "143", billing_drift: "1.009", billed_unit_price: "9.12", status: "paid", paid_on: "2026-04-13" },
            { id: 40, po_line_id: 67, invoice_no: "INV9097633", invoice_date: "2026-04-13", qty_ratio: "1.022", invoiced_qty: "201", billing_drift: "1.013", billed_unit_price: "9.92", status: "disputed", paid_on: null },
            { id: 41, po_line_id: 69, invoice_no: "INV3577141", invoice_date: "2026-06-05", qty_ratio: "1.024", invoiced_qty: "6", billing_drift: "1.022", billed_unit_price: "3.31", status: "paid", paid_on: "2026-08-05" },
            { id: 42, po_line_id: 76, invoice_no: "INV1187946", invoice_date: "2026-06-13", qty_ratio: "0.959", invoiced_qty: "5", billing_drift: "0.992", billed_unit_price: "9.36", status: "disputed", paid_on: null },
            { id: 43, po_line_id: 61, invoice_no: "INV4251883", invoice_date: "2026-06-08", qty_ratio: "1.010", invoiced_qty: "98", billing_drift: "1.017", billed_unit_price: "14.50", status: "approved", paid_on: null },
            { id: 44, po_line_id: 41, invoice_no: "INV1360136", invoice_date: "2026-06-16", qty_ratio: "0.976", invoiced_qty: "18", billing_drift: "0.994", billed_unit_price: "6.24", status: "disputed", paid_on: null },
            { id: 45, po_line_id: 74, invoice_no: "INV8246519", invoice_date: "2026-03-08", qty_ratio: "1.030", invoiced_qty: "71", billing_drift: "1.017", billed_unit_price: "11.13", status: "paid", paid_on: "2026-03-12" },
            { id: 46, po_line_id: 16, invoice_no: "INV4216362", invoice_date: "2026-05-10", qty_ratio: "0.996", invoiced_qty: "43", billing_drift: "1.012", billed_unit_price: "4.63", status: "approved", paid_on: null },
            { id: 47, po_line_id: 73, invoice_no: "INV0945719", invoice_date: "2026-06-20", qty_ratio: "1.060", invoiced_qty: "191", billing_drift: "1.024", billed_unit_price: "17.58", status: "paid", paid_on: "2026-07-17" },
            { id: 48, po_line_id: 4, invoice_no: "INV1786380", invoice_date: "2026-04-07", qty_ratio: "1.044", invoiced_qty: "152", billing_drift: "0.996", billed_unit_price: "4.52", status: "on_hold", paid_on: null },
            { id: 49, po_line_id: 58, invoice_no: "INV2315345", invoice_date: "2026-06-16", qty_ratio: "1.017", invoiced_qty: "70", billing_drift: "0.994", billed_unit_price: "4.42", status: "paid", paid_on: "2026-06-17" },
            { id: 50, po_line_id: 83, invoice_no: "INV1509299", invoice_date: "2026-06-23", qty_ratio: "0.995", invoiced_qty: "56", billing_drift: "0.999", billed_unit_price: "20.33", status: "paid", paid_on: "2026-08-22" },
            { id: 51, po_line_id: 9, invoice_no: "INV0123408", invoice_date: "2026-04-12", qty_ratio: "1.022", invoiced_qty: "68", billing_drift: "1.023", billed_unit_price: "7.88", status: "paid", paid_on: "2026-04-30" },
            { id: 52, po_line_id: 42, invoice_no: "INV8143702", invoice_date: "2026-05-01", qty_ratio: "1.032", invoiced_qty: "5", billing_drift: "1.003", billed_unit_price: "8.76", status: "paid", paid_on: "2026-05-28" },
            { id: 53, po_line_id: 14, invoice_no: "INV2283109", invoice_date: "2026-06-17", qty_ratio: "0.975", invoiced_qty: "41", billing_drift: "0.987", billed_unit_price: "11.03", status: "approved", paid_on: null },
            { id: 54, po_line_id: 79, invoice_no: "INV9061939", invoice_date: "2026-06-13", qty_ratio: "0.962", invoiced_qty: "11", billing_drift: "1.022", billed_unit_price: "3.11", status: "paid", paid_on: "2026-06-27" },
            { id: 55, po_line_id: 65, invoice_no: "INV3801127", invoice_date: "2026-05-29", qty_ratio: "1.001", invoiced_qty: "131", billing_drift: "1.009", billed_unit_price: "9.21", status: "paid", paid_on: "2026-06-15" },
            { id: 56, po_line_id: 89, invoice_no: "INV4180817", invoice_date: "2026-05-13", qty_ratio: "0.992", invoiced_qty: "96", billing_drift: "1.004", billed_unit_price: "3.17", status: "paid", paid_on: "2026-06-24" },
            { id: 57, po_line_id: 27, invoice_no: "INV6572815", invoice_date: "2026-06-26", qty_ratio: "1.030", invoiced_qty: "5", billing_drift: "1.009", billed_unit_price: "1.97", status: "disputed", paid_on: null },
            { id: 58, po_line_id: 51, invoice_no: "INV6727641", invoice_date: "2026-03-25", qty_ratio: "1.033", invoiced_qty: "123", billing_drift: "0.993", billed_unit_price: "3.01", status: "disputed", paid_on: null },
            { id: 59, po_line_id: 55, invoice_no: "INV4913482", invoice_date: "2026-04-05", qty_ratio: "1.025", invoiced_qty: "78", billing_drift: "1.015", billed_unit_price: "17.32", status: "paid", paid_on: "2026-04-12" },
            { id: 60, po_line_id: 12, invoice_no: "INV0510218", invoice_date: "2026-05-16", qty_ratio: "0.967", invoiced_qty: "82", billing_drift: "0.993", billed_unit_price: "3.14", status: "disputed", paid_on: null },
            { id: 61, po_line_id: 87, invoice_no: "INV0766184", invoice_date: "2026-05-04", qty_ratio: "1.046", invoiced_qty: "19", billing_drift: "1.007", billed_unit_price: "3.10", status: "paid", paid_on: "2026-07-09" },
            { id: 62, po_line_id: 5, invoice_no: "INV9568371", invoice_date: "2026-06-25", qty_ratio: "0.995", invoiced_qty: "53", billing_drift: "1.016", billed_unit_price: "9.18", status: "disputed", paid_on: null },
            { id: 63, po_line_id: 84, invoice_no: "INV8781039", invoice_date: "2026-04-27", qty_ratio: "1.025", invoiced_qty: "7", billing_drift: "1.013", billed_unit_price: "6.16", status: "disputed", paid_on: null },
            { id: 64, po_line_id: 43, invoice_no: "INV5285391", invoice_date: "2026-03-18", qty_ratio: "1.034", invoiced_qty: "88", billing_drift: "0.993", billed_unit_price: "6.24", status: "approved", paid_on: null },
            { id: 65, po_line_id: 32, invoice_no: "INV8323513", invoice_date: "2026-06-12", qty_ratio: "1.030", invoiced_qty: "108", billing_drift: "1.030", billed_unit_price: "3.06", status: "paid", paid_on: "2026-06-22" },
            { id: 66, po_line_id: 86, invoice_no: "INV2414605", invoice_date: "2026-05-20", qty_ratio: "0.992", invoiced_qty: "9", billing_drift: "1.020", billed_unit_price: "13.98", status: "paid", paid_on: "2026-06-21" },
            { id: 67, po_line_id: 52, invoice_no: "INV0868176", invoice_date: "2026-05-23", qty_ratio: "1.012", invoiced_qty: "39", billing_drift: "1.001", billed_unit_price: "4.76", status: "paid", paid_on: "2026-05-27" },
            { id: 68, po_line_id: 50, invoice_no: "INV1546704", invoice_date: "2026-06-18", qty_ratio: "0.982", invoiced_qty: "157", billing_drift: "1.017", billed_unit_price: "4.46", status: "paid", paid_on: "2026-08-17" },
            { id: 69, po_line_id: 40, invoice_no: "INV6445710", invoice_date: "2026-06-13", qty_ratio: "1.041", invoiced_qty: "86", billing_drift: "1.015", billed_unit_price: "7.77", status: "paid", paid_on: "2026-07-23" },
            { id: 70, po_line_id: 16, invoice_no: "INV3858917", invoice_date: "2026-04-16", qty_ratio: "0.992", invoiced_qty: "43", billing_drift: "1.007", billed_unit_price: "4.61", status: "paid", paid_on: "2026-05-01" },
            { id: 71, po_line_id: 88, invoice_no: "INV9820402", invoice_date: "2026-06-12", qty_ratio: "1.026", invoiced_qty: "100", billing_drift: "1.003", billed_unit_price: "18.89", status: "approved", paid_on: null },
            { id: 72, po_line_id: 71, invoice_no: "INV8116890", invoice_date: "2026-06-11", qty_ratio: "1.009", invoiced_qty: "178", billing_drift: "1.000", billed_unit_price: "3.08", status: "approved", paid_on: null },
            { id: 73, po_line_id: 53, invoice_no: "INV1767008", invoice_date: "2026-04-28", qty_ratio: "0.999", invoiced_qty: "6", billing_drift: "0.997", billed_unit_price: "9.27", status: "paid", paid_on: "2026-06-21" },
            { id: 74, po_line_id: 50, invoice_no: "INV1113858", invoice_date: "2026-04-27", qty_ratio: "0.986", invoiced_qty: "158", billing_drift: "1.015", billed_unit_price: "4.46", status: "paid", paid_on: "2026-05-25" },
            { id: 75, po_line_id: 62, invoice_no: "INV5566818", invoice_date: "2026-03-25", qty_ratio: "1.035", invoiced_qty: "76", billing_drift: "1.000", billed_unit_price: "9.29", status: "approved", paid_on: null },
            { id: 76, po_line_id: 87, invoice_no: "INV4499058", invoice_date: "2026-05-22", qty_ratio: "0.979", invoiced_qty: "18", billing_drift: "1.037", billed_unit_price: "3.19", status: "approved", paid_on: null },
            { id: 77, po_line_id: 37, invoice_no: "INV9393459", invoice_date: "2026-04-05", qty_ratio: "0.958", invoiced_qty: "176", billing_drift: "1.022", billed_unit_price: "28.36", status: "paid", paid_on: "2026-05-09" },
            { id: 78, po_line_id: 35, invoice_no: "INV1221391", invoice_date: "2026-05-31", qty_ratio: "1.003", invoiced_qty: "200", billing_drift: "1.007", billed_unit_price: "3.08", status: "paid", paid_on: "2026-07-08" },
            { id: 79, po_line_id: 74, invoice_no: "INV1090841", invoice_date: "2026-03-25", qty_ratio: "1.056", invoiced_qty: "73", billing_drift: "1.037", billed_unit_price: "11.34", status: "on_hold", paid_on: null },
            { id: 80, po_line_id: 62, invoice_no: "INV3109145", invoice_date: "2026-03-15", qty_ratio: "1.023", invoiced_qty: "75", billing_drift: "1.008", billed_unit_price: "9.36", status: "approved", paid_on: null },
            { id: 81, po_line_id: 69, invoice_no: "INV0932497", invoice_date: "2026-06-02", qty_ratio: "0.970", invoiced_qty: "6", billing_drift: "1.022", billed_unit_price: "3.31", status: "disputed", paid_on: null },
            { id: 82, po_line_id: 14, invoice_no: "INV4008136", invoice_date: "2026-06-08", qty_ratio: "0.997", invoiced_qty: "42", billing_drift: "1.013", billed_unit_price: "11.33", status: "paid", paid_on: "2026-07-07" },
            { id: 83, po_line_id: 67, invoice_no: "INV6142334", invoice_date: "2026-04-10", qty_ratio: "0.979", invoiced_qty: "193", billing_drift: "1.011", billed_unit_price: "9.90", status: "paid", paid_on: "2026-06-10" },
            { id: 84, po_line_id: 83, invoice_no: "INV9367518", invoice_date: "2026-04-19", qty_ratio: "0.984", invoiced_qty: "55", billing_drift: "0.969", billed_unit_price: "19.72", status: "paid", paid_on: "2026-05-24" },
            { id: 85, po_line_id: 81, invoice_no: "INV7688050", invoice_date: "2026-03-24", qty_ratio: "0.973", invoiced_qty: "129", billing_drift: "0.993", billed_unit_price: "8.98", status: "paid", paid_on: "2026-03-31" },
            { id: 86, po_line_id: 43, invoice_no: "INV2331933", invoice_date: "2026-03-24", qty_ratio: "1.022", invoiced_qty: "87", billing_drift: "1.017", billed_unit_price: "6.39", status: "approved", paid_on: null },
            { id: 87, po_line_id: 26, invoice_no: "INV9846783", invoice_date: "2026-04-27", qty_ratio: "0.999", invoiced_qty: "190", billing_drift: "1.006", billed_unit_price: "18.55", status: "paid", paid_on: "2026-05-07" },
        ],
    });
}

main()
    .then(() => prisma.$disconnect())
    .catch(async error => {
        console.error(error);
        await prisma.$disconnect();
        process.exit(1);
    });