// B2B Tiered Pricing with Volume Breaks and Customer Group Rules (b2b-tiered-pricing-with-volume-breaks-and-customer-group-rules) 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.coffees), 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.coffees.createMany({ data: [ { id: 1, sku: "CF-7320", name: "Costa Rica Tarrazu", roast: "dark", list_price: "23.50" }, { id: 2, sku: "CF-8373", name: "Nicaragua Jinotega", roast: "medium", list_price: "22.05" }, { id: 3, sku: "CF-5752", name: "Brazil Cerrado", roast: "light", list_price: "30.33" }, { id: 4, sku: "CF-8727", name: "Breakfast Blend", roast: "dark", list_price: "14.35" }, { id: 5, sku: "CF-4888", name: "Burundi Kayanza", roast: "medium", list_price: "14.17" }, { id: 6, sku: "CF-1891", name: "Single Estate Espresso", roast: "medium", list_price: "14.35" }, { id: 7, sku: "CF-2248", name: "Ethiopia Guji", roast: "medium", list_price: "26.72" }, { id: 8, sku: "CF-6195", name: "El Salvador Santa Ana", roast: "light", list_price: "32.43" }, { id: 9, sku: "CF-9034", name: "Bolivia Caranavi", roast: "light", list_price: "20.17" }, { id: 10, sku: "CF-9868", name: "Panama Boquete", roast: "medium", list_price: "30.58" }, { id: 11, sku: "CF-1228", name: "Colombia Huila", roast: "light", list_price: "14.13" }, { id: 12, sku: "CF-4029", name: "Decaf Swiss Water", roast: "dark", list_price: "14.14" }, { id: 13, sku: "CF-9334", name: "Rwanda Nyamasheke", roast: "medium", list_price: "17.60" }, { id: 14, sku: "CF-2685", name: "Dark Roast Blend", roast: "light", list_price: "14.02" }, { id: 15, sku: "CF-4253", name: "Tanzania Mbeya", roast: "medium", list_price: "14.16" }, { id: 16, sku: "CF-8531", name: "Office Filter Blend", roast: "medium", list_price: "14.43" }, { id: 17, sku: "CF-3370", name: "House Espresso Blend", roast: "light", list_price: "16.34" }, { id: 18, sku: "CF-3557", name: "Uganda Bugisu", roast: "medium", list_price: "18.13" }, { id: 19, sku: "CF-4346", name: "Honduras Marcala", roast: "light", list_price: "26.59" }, { id: 20, sku: "CF-1763", name: "Mexico Chiapas", roast: "medium", list_price: "37.02" }, { id: 21, sku: "CF-8469", name: "Sumatra Mandheling", roast: "medium", list_price: "34.56" }, { id: 22, sku: "CF-4567", name: "Ethiopia Yirgacheffe", roast: "medium", list_price: "21.46" }, { id: 23, sku: "CF-9418", name: "Yemen Haraz", roast: "light", list_price: "14.47" }, { id: 24, sku: "CF-2464", name: "Colombia Narino", roast: "light", list_price: "27.43" }, { id: 25, sku: "CF-5668", name: "Peru Cajamarca", roast: "medium", list_price: "15.43" }, { id: 26, sku: "CF-5586", name: "Guatemala Antigua", roast: "dark", list_price: "23.54" }, { id: 27, sku: "CF-5559", name: "Kenya Nyeri", roast: "medium", list_price: "36.40" }, { id: 28, sku: "CF-3440", name: "Papua New Guinea Waghi", roast: "light", list_price: "24.84" }, { id: 29, sku: "CF-6400", name: "India Monsooned Malabar", roast: "medium", list_price: "22.75" }, { id: 30, sku: "CF-9439", name: "Cold Brew Blend", roast: "light", list_price: "14.01" }, ], }); await prisma.customer_groups.createMany({ data: [ { id: 1, price_list: "trade_price_list_2024", group_name: "standard_trade", group_discount_pct: 0, payment_terms: "prepaid", min_order_value: 0 }, { id: 2, price_list: "trade_price_list_2024", group_name: "silver_trade", group_discount_pct: 4, payment_terms: "net_15", min_order_value: 250 }, { id: 3, price_list: "trade_price_list_2024", group_name: "gold_trade", group_discount_pct: 8, payment_terms: "net_30", min_order_value: 500 }, { id: 4, price_list: "trade_price_list_2024", group_name: "distributor", group_discount_pct: 12, payment_terms: "net_45", min_order_value: 750 }, { id: 5, price_list: "trade_price_list_2024", group_name: "strategic_account", group_discount_pct: 16, payment_terms: "net_60", min_order_value: 1000 }, ], }); await prisma.business_customers.createMany({ data: [ { id: 1, company_name: "Lakin Inc", business_type: "reseller", group_id: 1, group_discount_pct: 0, buyer_first_name: "Molly", buyer_last_name: "Stanton", buyer_email: "molly_stanton@example.com", credit_limit: "54666.24", account_opened_on: "2022-11-16" }, { id: 2, company_name: "Hagenes - Franey", business_type: "restaurant", group_id: 2, group_discount_pct: 4, buyer_first_name: "Jacinto", buyer_last_name: "Baumbach-Zboncak", buyer_email: "jacinto_baumbach-zboncak@example.net", credit_limit: "1573.01", account_opened_on: "2019-03-17" }, { id: 3, company_name: "Wehner - Koch", business_type: "cafe", group_id: 3, group_discount_pct: 8, buyer_first_name: "Maurice", buyer_last_name: "Lueilwitz", buyer_email: "maurice_lueilwitz88@example.org", credit_limit: "39956.29", account_opened_on: "2022-01-23" }, { id: 4, company_name: "Ankunding - Marvin", business_type: "reseller", group_id: 5, group_discount_pct: 16, buyer_first_name: "Maribel", buyer_last_name: "Hickle", buyer_email: "maribel.hickle44@example.org", credit_limit: "22821.52", account_opened_on: "2021-02-28" }, { id: 5, company_name: "Zieme - Hansen", business_type: "office", group_id: 2, group_discount_pct: 4, buyer_first_name: "Linnie", buyer_last_name: "Schultz", buyer_email: "linnie_schultz@example.net", credit_limit: "1135.01", account_opened_on: "2022-08-14" }, { id: 6, company_name: "Kreiger, Feeney-McCullough and Erdman", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Carole", buyer_last_name: "Feeney", buyer_email: "carole_feeney33@example.com", credit_limit: "10222.10", account_opened_on: "2020-12-16" }, { id: 7, company_name: "Russel and Sons", business_type: "office", group_id: 5, group_discount_pct: 16, buyer_first_name: "Garret", buyer_last_name: "Runte", buyer_email: "garret.runte@example.org", credit_limit: "54780.29", account_opened_on: "2020-02-16" }, { id: 8, company_name: "Larkin - Johns", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Nicolas", buyer_last_name: "Rath", buyer_email: "nicolas_rath56@example.net", credit_limit: "36919.97", account_opened_on: "2023-01-23" }, { id: 9, company_name: "Runte - Wehner", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Wm", buyer_last_name: "Thiel", buyer_email: "wm_thiel@example.com", credit_limit: "1113.78", account_opened_on: "2022-04-06" }, { id: 10, company_name: "Witting and Sons", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Selena", buyer_last_name: "Hudson", buyer_email: "selena_hudson57@example.net", credit_limit: "26964.88", account_opened_on: "2020-03-23" }, { id: 11, company_name: "Heller, Schneider and Johnson-Fahey", business_type: "reseller", group_id: 2, group_discount_pct: 4, buyer_first_name: "King", buyer_last_name: "Larson", buyer_email: "king.larson66@example.net", credit_limit: "10645.92", account_opened_on: "2022-10-13" }, { id: 12, company_name: "Grimes LLC", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Jared", buyer_last_name: "Marvin", buyer_email: "jared_marvin52@example.com", credit_limit: "2987.98", account_opened_on: "2020-10-18" }, { id: 13, company_name: "McClure - Hahn", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Norwood", buyer_last_name: "Rau-Dickens", buyer_email: "norwood.rau-dickens@example.com", credit_limit: "58272.08", account_opened_on: "2022-02-10" }, { id: 14, company_name: "Graham, Klein and Feeney", business_type: "office", group_id: 4, group_discount_pct: 12, buyer_first_name: "Karianne", buyer_last_name: "O'Connell", buyer_email: "karianne.oconnell@example.org", credit_limit: "1904.96", account_opened_on: "2021-11-26" }, { id: 15, company_name: "Oberbrunner and Sons", business_type: "reseller", group_id: 2, group_discount_pct: 4, buyer_first_name: "Keanu", buyer_last_name: "Russel", buyer_email: "keanu.russel94@example.com", credit_limit: "11747.13", account_opened_on: "2019-12-04" }, { id: 16, company_name: "Mosciski and Sons", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Gerda", buyer_last_name: "Cummerata", buyer_email: "gerda_cummerata@example.com", credit_limit: "57326.45", account_opened_on: "2022-12-18" }, { id: 17, company_name: "Romaguera - Erdman", business_type: "cafe", group_id: 4, group_discount_pct: 12, buyer_first_name: "Colleen", buyer_last_name: "Krajcik", buyer_email: "colleen_krajcik@example.org", credit_limit: "42874.84", account_opened_on: "2022-06-28" }, { id: 18, company_name: "Welch-Lemke, Robel and Green", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Sydnee", buyer_last_name: "Robel-Purdy", buyer_email: "sydnee.robel-purdy32@example.org", credit_limit: "19718.33", account_opened_on: "2019-03-23" }, { id: 19, company_name: "Wyman, Emmerich and Haley", business_type: "cafe", group_id: 4, group_discount_pct: 12, buyer_first_name: "Grayson", buyer_last_name: "Spinka", buyer_email: "grayson_spinka92@example.com", credit_limit: "32815.90", account_opened_on: "2023-12-19" }, { id: 20, company_name: "Maggio - Stark", business_type: "reseller", group_id: 4, group_discount_pct: 12, buyer_first_name: "Jammie", buyer_last_name: "Wilderman", buyer_email: "jammie.wilderman@example.net", credit_limit: "3076.42", account_opened_on: "2023-06-29" }, { id: 21, company_name: "Runte, Carroll and Crooks", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Julien", buyer_last_name: "Bosco", buyer_email: "julien.bosco86@example.com", credit_limit: "6261.27", account_opened_on: "2021-05-26" }, { id: 22, company_name: "Marquardt, Schaden and Spinka", business_type: "cafe", group_id: 5, group_discount_pct: 16, buyer_first_name: "Alejandra", buyer_last_name: "Kutch-Walsh", buyer_email: "alejandra_kutch-walsh@example.org", credit_limit: "44015.92", account_opened_on: "2023-11-23" }, { id: 23, company_name: "Wilderman, Parker and McKenzie", business_type: "reseller", group_id: 1, group_discount_pct: 0, buyer_first_name: "Dave", buyer_last_name: "Auer", buyer_email: "dave_auer@example.org", credit_limit: "23044.99", account_opened_on: "2023-06-07" }, { id: 24, company_name: "Waters - McDermott", business_type: "hotel", group_id: 2, group_discount_pct: 4, buyer_first_name: "Dashawn", buyer_last_name: "Steuber", buyer_email: "dashawn.steuber3@example.net", credit_limit: "16124.32", account_opened_on: "2022-08-14" }, { id: 25, company_name: "Kirlin, Mosciski and Mayer", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Wiley", buyer_last_name: "Abshire", buyer_email: "wiley_abshire57@example.org", credit_limit: "14908.26", account_opened_on: "2020-06-15" }, { id: 26, company_name: "Treutel Inc", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Magnolia", buyer_last_name: "Fisher", buyer_email: "magnolia_fisher@example.com", credit_limit: "7329.68", account_opened_on: "2020-09-14" }, { id: 27, company_name: "Kub LLC", business_type: "office", group_id: 2, group_discount_pct: 4, buyer_first_name: "Cordie", buyer_last_name: "Hoeger", buyer_email: "cordie_hoeger@example.com", credit_limit: "56445.62", account_opened_on: "2021-07-15" }, { id: 28, company_name: "Christiansen Inc", business_type: "restaurant", group_id: 3, group_discount_pct: 8, buyer_first_name: "Marisa", buyer_last_name: "Ritchie", buyer_email: "marisa_ritchie@example.org", credit_limit: "32564.63", account_opened_on: "2023-12-29" }, { id: 29, company_name: "Dach - Gorczany", business_type: "hotel", group_id: 5, group_discount_pct: 16, buyer_first_name: "Mervin", buyer_last_name: "Stamm-Funk", buyer_email: "mervin_stamm-funk@example.org", credit_limit: "48892.49", account_opened_on: "2023-12-10" }, { id: 30, company_name: "Graham - Mertz", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Ottis", buyer_last_name: "Rempel", buyer_email: "ottis_rempel@example.com", credit_limit: "2306.61", account_opened_on: "2021-02-18" }, { id: 31, company_name: "Volkman, Leannon and Sawayn", business_type: "restaurant", group_id: 2, group_discount_pct: 4, buyer_first_name: "Phil", buyer_last_name: "Klocko", buyer_email: "phil.klocko32@example.com", credit_limit: "39590.41", account_opened_on: "2023-12-02" }, { id: 32, company_name: "Larson - Larkin", business_type: "cafe", group_id: 2, group_discount_pct: 4, buyer_first_name: "Mayra", buyer_last_name: "Mayert", buyer_email: "mayra.mayert39@example.com", credit_limit: "25884.68", account_opened_on: "2020-01-24" }, { id: 33, company_name: "Kuphal-Hand - McDermott", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Jose", buyer_last_name: "Bosco", buyer_email: "jose.bosco@example.org", credit_limit: "19955.14", account_opened_on: "2022-12-07" }, { id: 34, company_name: "O'Reilly, Walker and Hodkiewicz", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Rowland", buyer_last_name: "Rath", buyer_email: "rowland_rath46@example.com", credit_limit: "30646.24", account_opened_on: "2023-05-15" }, { id: 35, company_name: "Kautzer Inc", business_type: "cafe", group_id: 3, group_discount_pct: 8, buyer_first_name: "Francisca", buyer_last_name: "Walker", buyer_email: "francisca.walker@example.com", credit_limit: "2767.89", account_opened_on: "2021-09-04" }, { id: 36, company_name: "Ortiz, Upton and Cremin", business_type: "restaurant", group_id: 5, group_discount_pct: 16, buyer_first_name: "Bertram", buyer_last_name: "Mertz", buyer_email: "bertram.mertz23@example.net", credit_limit: "47219.68", account_opened_on: "2021-02-16" }, { id: 37, company_name: "Reichert-Schmeler, Donnelly and Hermiston", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Charley", buyer_last_name: "O'Kon", buyer_email: "charley_okon@example.org", credit_limit: "13461.67", account_opened_on: "2020-11-27" }, { id: 38, company_name: "Yost, Bernier and Hayes", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Augusta", buyer_last_name: "Berge", buyer_email: "augusta.berge@example.org", credit_limit: "8296.33", account_opened_on: "2021-07-03" }, { id: 39, company_name: "Becker LLC", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Clovis", buyer_last_name: "Brakus", buyer_email: "clovis_brakus48@example.com", credit_limit: "15555.97", account_opened_on: "2023-07-02" }, { id: 40, company_name: "Torphy, Wisozk and Mann", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Vincenzo", buyer_last_name: "Lynch", buyer_email: "vincenzo.lynch@example.org", credit_limit: "5742.45", account_opened_on: "2023-03-20" }, { id: 41, company_name: "Rosenbaum, Williamson and Hickle", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Ricky", buyer_last_name: "Kunze", buyer_email: "ricky.kunze@example.org", credit_limit: "1133.07", account_opened_on: "2019-05-16" }, { id: 42, company_name: "Pouros, Erdman and Ryan", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Elvie", buyer_last_name: "Mante", buyer_email: "elvie_mante68@example.org", credit_limit: "51494.19", account_opened_on: "2023-05-17" }, { id: 43, company_name: "Wiza, Kertzmann and Bergnaum", business_type: "cafe", group_id: 2, group_discount_pct: 4, buyer_first_name: "Kiley", buyer_last_name: "Tromp", buyer_email: "kiley.tromp@example.net", credit_limit: "38520.04", account_opened_on: "2020-03-27" }, { id: 44, company_name: "Mayer-Dare - Corkery", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Simone", buyer_last_name: "Ward", buyer_email: "simone_ward83@example.net", credit_limit: "32061.85", account_opened_on: "2022-04-10" }, { id: 45, company_name: "Hackett Group", business_type: "reseller", group_id: 2, group_discount_pct: 4, buyer_first_name: "Anahi", buyer_last_name: "Connelly", buyer_email: "anahi.connelly41@example.net", credit_limit: "5764.66", account_opened_on: "2019-03-06" }, { id: 46, company_name: "Turcotte, Schinner and Pfannerstill", business_type: "restaurant", group_id: 3, group_discount_pct: 8, buyer_first_name: "Cary", buyer_last_name: "Abbott", buyer_email: "cary.abbott@example.net", credit_limit: "51503.62", account_opened_on: "2021-12-23" }, { id: 47, company_name: "O'Connell, Mraz and Spencer", business_type: "hotel", group_id: 1, group_discount_pct: 0, buyer_first_name: "Jennie", buyer_last_name: "King", buyer_email: "jennie_king@example.org", credit_limit: "8068.82", account_opened_on: "2020-06-17" }, { id: 48, company_name: "Sawayn, Kassulke and Shanahan", business_type: "reseller", group_id: 4, group_discount_pct: 12, buyer_first_name: "Christine", buyer_last_name: "Cummerata", buyer_email: "christine_cummerata@example.org", credit_limit: "1055.78", account_opened_on: "2020-04-02" }, { id: 49, company_name: "Jerde LLC", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Nikita", buyer_last_name: "Rath", buyer_email: "nikita_rath@example.net", credit_limit: "45746.38", account_opened_on: "2021-07-24" }, { id: 50, company_name: "Kulas, Friesen and Wiegand", business_type: "reseller", group_id: 2, group_discount_pct: 4, buyer_first_name: "Odell", buyer_last_name: "Hackett-Beahan", buyer_email: "odell_hackett-beahan@example.org", credit_limit: "10900.77", account_opened_on: "2020-12-09" }, { id: 51, company_name: "Bailey - Willms", business_type: "cafe", group_id: 3, group_discount_pct: 8, buyer_first_name: "Maximillian", buyer_last_name: "Crooks", buyer_email: "maximillian.crooks68@example.com", credit_limit: "7406.45", account_opened_on: "2022-11-26" }, { id: 52, company_name: "Schumm, Barrows and Corwin", business_type: "reseller", group_id: 1, group_discount_pct: 0, buyer_first_name: "Bryan", buyer_last_name: "Ryan", buyer_email: "bryan_ryan@example.net", credit_limit: "6461.00", account_opened_on: "2021-08-28" }, { id: 53, company_name: "Wiza, Borer and Corwin", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Heaven", buyer_last_name: "Davis", buyer_email: "heaven.davis@example.net", credit_limit: "46996.53", account_opened_on: "2021-08-15" }, { id: 54, company_name: "Jerde Group", business_type: "hotel", group_id: 1, group_discount_pct: 0, buyer_first_name: "Nikita", buyer_last_name: "Von", buyer_email: "nikita_von@example.com", credit_limit: "7190.55", account_opened_on: "2019-12-08" }, { id: 55, company_name: "Yundt, Hyatt and Koepp", business_type: "restaurant", group_id: 2, group_discount_pct: 4, buyer_first_name: "Aida", buyer_last_name: "Ullrich", buyer_email: "aida.ullrich92@example.org", credit_limit: "57516.60", account_opened_on: "2023-07-02" }, { id: 56, company_name: "Dickens - Renner", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Lizeth", buyer_last_name: "Smith", buyer_email: "lizeth_smith@example.com", credit_limit: "7875.21", account_opened_on: "2021-01-09" }, { id: 57, company_name: "Tillman Inc", business_type: "hotel", group_id: 1, group_discount_pct: 0, buyer_first_name: "Rafaela", buyer_last_name: "Lynch", buyer_email: "rafaela_lynch6@example.net", credit_limit: "9048.37", account_opened_on: "2019-02-04" }, { id: 58, company_name: "Haag, Crooks and Hagenes", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Icie", buyer_last_name: "Koch", buyer_email: "icie.koch72@example.net", credit_limit: "14741.49", account_opened_on: "2021-06-20" }, { id: 59, company_name: "Koepp, Leannon and Morar", business_type: "office", group_id: 4, group_discount_pct: 12, buyer_first_name: "Camille", buyer_last_name: "Lind", buyer_email: "camille.lind9@example.net", credit_limit: "45940.02", account_opened_on: "2023-06-17" }, { id: 60, company_name: "Stoltenberg and Sons", business_type: "restaurant", group_id: 2, group_discount_pct: 4, buyer_first_name: "Addison", buyer_last_name: "Stanton", buyer_email: "addison.stanton@example.net", credit_limit: "10287.65", account_opened_on: "2022-06-12" }, { id: 61, company_name: "Feil - Vandervort-Schulist", business_type: "restaurant", group_id: 5, group_discount_pct: 16, buyer_first_name: "Aisha", buyer_last_name: "King", buyer_email: "aisha.king@example.net", credit_limit: "4027.74", account_opened_on: "2023-05-19" }, { id: 62, company_name: "Roob, Hirthe and Feeney", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Cedrick", buyer_last_name: "Kuhlman", buyer_email: "cedrick.kuhlman@example.org", credit_limit: "42866.81", account_opened_on: "2019-09-09" }, { id: 63, company_name: "Nader-Wisoky - Waelchi", business_type: "cafe", group_id: 2, group_discount_pct: 4, buyer_first_name: "Eli", buyer_last_name: "Abernathy", buyer_email: "eli.abernathy@example.com", credit_limit: "20422.96", account_opened_on: "2020-06-27" }, { id: 64, company_name: "Sipes Inc", business_type: "restaurant", group_id: 2, group_discount_pct: 4, buyer_first_name: "Logan", buyer_last_name: "Hahn", buyer_email: "logan.hahn47@example.org", credit_limit: "14994.19", account_opened_on: "2021-11-24" }, { id: 65, company_name: "Ullrich, Dibbert and Pfannerstill", business_type: "reseller", group_id: 1, group_discount_pct: 0, buyer_first_name: "Buster", buyer_last_name: "O'Hara", buyer_email: "buster.ohara@example.net", credit_limit: "1943.99", account_opened_on: "2023-05-28" }, { id: 66, company_name: "Schneider - Treutel", business_type: "reseller", group_id: 3, group_discount_pct: 8, buyer_first_name: "Adeline", buyer_last_name: "Wolf", buyer_email: "adeline.wolf@example.com", credit_limit: "5298.13", account_opened_on: "2021-11-05" }, { id: 67, company_name: "Paucek-Wyman - Haley-Stroman", business_type: "cafe", group_id: 2, group_discount_pct: 4, buyer_first_name: "Cullen", buyer_last_name: "Stroman-Treutel", buyer_email: "cullen.stroman-treutel98@example.com", credit_limit: "16526.96", account_opened_on: "2022-03-22" }, { id: 68, company_name: "Shanahan and Sons", business_type: "reseller", group_id: 1, group_discount_pct: 0, buyer_first_name: "Sydney", buyer_last_name: "Pouros", buyer_email: "sydney_pouros73@example.org", credit_limit: "4848.46", account_opened_on: "2019-02-06" }, { id: 69, company_name: "Morar Inc", business_type: "restaurant", group_id: 2, group_discount_pct: 4, buyer_first_name: "Lizeth", buyer_last_name: "Gibson", buyer_email: "lizeth_gibson64@example.org", credit_limit: "55128.88", account_opened_on: "2019-09-27" }, { id: 70, company_name: "Kub LLC", business_type: "office", group_id: 2, group_discount_pct: 4, buyer_first_name: "Janae", buyer_last_name: "Dicki", buyer_email: "janae.dicki@example.org", credit_limit: "24110.27", account_opened_on: "2022-05-21" }, { id: 71, company_name: "Cormier, Lynch and Sanford", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Philip", buyer_last_name: "Kub-Anderson", buyer_email: "philip_kub-anderson6@example.org", credit_limit: "21298.59", account_opened_on: "2020-07-21" }, { id: 72, company_name: "Sawayn, Schiller and Jacobson", business_type: "cafe", group_id: 4, group_discount_pct: 12, buyer_first_name: "Tobin", buyer_last_name: "Hagenes", buyer_email: "tobin.hagenes73@example.com", credit_limit: "5935.95", account_opened_on: "2021-11-21" }, { id: 73, company_name: "Schowalter and Sons", business_type: "cafe", group_id: 5, group_discount_pct: 16, buyer_first_name: "Kim", buyer_last_name: "Zboncak", buyer_email: "kim_zboncak@example.net", credit_limit: "6841.01", account_opened_on: "2020-07-29" }, { id: 74, company_name: "Krajcik - Hickle", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Triston", buyer_last_name: "Maggio", buyer_email: "triston_maggio@example.com", credit_limit: "34458.74", account_opened_on: "2021-09-18" }, { id: 75, company_name: "Hills, Murray and Cassin", business_type: "office", group_id: 2, group_discount_pct: 4, buyer_first_name: "Pam", buyer_last_name: "Barrows", buyer_email: "pam.barrows17@example.org", credit_limit: "2756.60", account_opened_on: "2022-09-12" }, { id: 76, company_name: "Marks Group", business_type: "reseller", group_id: 1, group_discount_pct: 0, buyer_first_name: "Beaulah", buyer_last_name: "MacGyver", buyer_email: "beaulah_macgyver@example.com", credit_limit: "22871.15", account_opened_on: "2020-10-23" }, { id: 77, company_name: "Walker, Block and Lubowitz", business_type: "hotel", group_id: 4, group_discount_pct: 12, buyer_first_name: "Efren", buyer_last_name: "Kris", buyer_email: "efren_kris@example.com", credit_limit: "12270.23", account_opened_on: "2020-10-12" }, { id: 78, company_name: "Shanahan, Weimann and Kuhn", business_type: "cafe", group_id: 2, group_discount_pct: 4, buyer_first_name: "Kristofer", buyer_last_name: "Collier", buyer_email: "kristofer_collier5@example.com", credit_limit: "13307.72", account_opened_on: "2021-10-28" }, { id: 79, company_name: "Baumbach, Gerlach and Beer", business_type: "cafe", group_id: 3, group_discount_pct: 8, buyer_first_name: "Franklin", buyer_last_name: "Thiel", buyer_email: "franklin_thiel@example.net", credit_limit: "30146.10", account_opened_on: "2020-08-31" }, { id: 80, company_name: "Bauch - Gulgowski", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Reagan", buyer_last_name: "Corwin", buyer_email: "reagan_corwin@example.net", credit_limit: "46565.60", account_opened_on: "2023-03-09" }, { id: 81, company_name: "Greenholt Group", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Liliana", buyer_last_name: "Bradtke", buyer_email: "liliana_bradtke@example.net", credit_limit: "46243.22", account_opened_on: "2020-06-25" }, { id: 82, company_name: "Brown - Watsica", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Jaeden", buyer_last_name: "Upton", buyer_email: "jaeden.upton33@example.net", credit_limit: "5996.68", account_opened_on: "2020-11-05" }, { id: 83, company_name: "Rath - Greenholt", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Shelley", buyer_last_name: "Gerhold", buyer_email: "shelley_gerhold50@example.org", credit_limit: "7165.09", account_opened_on: "2021-01-03" }, { id: 84, company_name: "Prohaska - Runte", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Aliza", buyer_last_name: "Hackett", buyer_email: "aliza_hackett@example.com", credit_limit: "43654.41", account_opened_on: "2021-03-17" }, { id: 85, company_name: "Ratke Group", business_type: "restaurant", group_id: 5, group_discount_pct: 16, buyer_first_name: "Weldon", buyer_last_name: "Funk", buyer_email: "weldon_funk@example.com", credit_limit: "1722.68", account_opened_on: "2022-09-28" }, { id: 86, company_name: "Stark-Waters - Abernathy", business_type: "hotel", group_id: 2, group_discount_pct: 4, buyer_first_name: "Kristian", buyer_last_name: "Keebler", buyer_email: "kristian.keebler15@example.net", credit_limit: "18334.46", account_opened_on: "2019-04-23" }, { id: 87, company_name: "Baumbach, Price and Boyle", business_type: "hotel", group_id: 1, group_discount_pct: 0, buyer_first_name: "Kathryne", buyer_last_name: "Doyle", buyer_email: "kathryne_doyle5@example.com", credit_limit: "1001.31", account_opened_on: "2020-11-21" }, { id: 88, company_name: "Hoeger and Sons", business_type: "office", group_id: 2, group_discount_pct: 4, buyer_first_name: "Essie", buyer_last_name: "Aufderhar", buyer_email: "essie.aufderhar@example.org", credit_limit: "9667.24", account_opened_on: "2022-03-08" }, { id: 89, company_name: "Nienow - Haag", business_type: "restaurant", group_id: 4, group_discount_pct: 12, buyer_first_name: "Nicklaus", buyer_last_name: "Rath", buyer_email: "nicklaus_rath57@example.com", credit_limit: "48834.37", account_opened_on: "2020-04-21" }, { id: 90, company_name: "Balistreri LLC", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Burnice", buyer_last_name: "Dicki", buyer_email: "burnice_dicki@example.net", credit_limit: "20179.84", account_opened_on: "2019-07-13" }, { id: 91, company_name: "Pouros Group", business_type: "office", group_id: 3, group_discount_pct: 8, buyer_first_name: "Armani", buyer_last_name: "Wolff", buyer_email: "armani_wolff44@example.net", credit_limit: "38878.55", account_opened_on: "2021-12-15" }, { id: 92, company_name: "Glover - Mann", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Harry", buyer_last_name: "Beatty", buyer_email: "harry.beatty@example.net", credit_limit: "4791.85", account_opened_on: "2020-07-25" }, { id: 93, company_name: "Hahn, Smitham and Luettgen", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Haleigh", buyer_last_name: "Brakus", buyer_email: "haleigh.brakus88@example.org", credit_limit: "4137.06", account_opened_on: "2023-10-01" }, { id: 94, company_name: "Nader, Parker and Harvey", business_type: "office", group_id: 2, group_discount_pct: 4, buyer_first_name: "Gustavo", buyer_last_name: "Schmeler", buyer_email: "gustavo.schmeler@example.net", credit_limit: "1338.04", account_opened_on: "2020-09-20" }, { id: 95, company_name: "Schultz Group", business_type: "restaurant", group_id: 5, group_discount_pct: 16, buyer_first_name: "Maida", buyer_last_name: "Wintheiser", buyer_email: "maida.wintheiser88@example.org", credit_limit: "52532.30", account_opened_on: "2019-02-20" }, { id: 96, company_name: "Torphy-Bauch, Metz and Collins", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Jon", buyer_last_name: "Dooley", buyer_email: "jon_dooley@example.com", credit_limit: "50913.85", account_opened_on: "2023-05-06" }, { id: 97, company_name: "Nienow, Mraz and Ward", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Murphy", buyer_last_name: "Cronin", buyer_email: "murphy_cronin@example.org", credit_limit: "31673.48", account_opened_on: "2022-04-02" }, { id: 98, company_name: "Lind - Kovacek", business_type: "reseller", group_id: 4, group_discount_pct: 12, buyer_first_name: "Patti", buyer_last_name: "Dickens", buyer_email: "patti_dickens@example.com", credit_limit: "43152.15", account_opened_on: "2023-05-25" }, { id: 99, company_name: "Walter Group", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Uriel", buyer_last_name: "Mertz", buyer_email: "uriel_mertz9@example.com", credit_limit: "5070.77", account_opened_on: "2023-10-06" }, { id: 100, company_name: "Homenick Inc", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Kay", buyer_last_name: "Howell", buyer_email: "kay_howell@example.net", credit_limit: "20725.91", account_opened_on: "2019-09-13" }, { id: 101, company_name: "Conn and Sons", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Ariane", buyer_last_name: "Dibbert", buyer_email: "ariane.dibbert54@example.net", credit_limit: "36617.31", account_opened_on: "2019-08-03" }, { id: 102, company_name: "Boyer, Hudson and Kozey", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Antonina", buyer_last_name: "Fay", buyer_email: "antonina.fay72@example.net", credit_limit: "12453.01", account_opened_on: "2021-11-02" }, { id: 103, company_name: "Sporer, MacGyver and Robel", business_type: "hotel", group_id: 2, group_discount_pct: 4, buyer_first_name: "Caesar", buyer_last_name: "Erdman", buyer_email: "caesar.erdman39@example.net", credit_limit: "9389.47", account_opened_on: "2023-08-05" }, { id: 104, company_name: "Franey, Wisozk and Hartmann", business_type: "reseller", group_id: 1, group_discount_pct: 0, buyer_first_name: "Trevion", buyer_last_name: "Herzog", buyer_email: "trevion_herzog@example.org", credit_limit: "29825.15", account_opened_on: "2020-09-10" }, { id: 105, company_name: "Mertz Group", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Devyn", buyer_last_name: "Thiel", buyer_email: "devyn.thiel99@example.org", credit_limit: "25221.49", account_opened_on: "2023-05-06" }, { id: 106, company_name: "Kreiger, Mann and Stokes", business_type: "reseller", group_id: 3, group_discount_pct: 8, buyer_first_name: "Jerome", buyer_last_name: "Moen", buyer_email: "jerome_moen@example.com", credit_limit: "28066.48", account_opened_on: "2022-06-01" }, { id: 107, company_name: "Schiller, Strosin and Lemke", business_type: "cafe", group_id: 1, group_discount_pct: 0, buyer_first_name: "Stanton", buyer_last_name: "Rice", buyer_email: "stanton.rice76@example.com", credit_limit: "2392.93", account_opened_on: "2022-10-20" }, { id: 108, company_name: "Bode - Harber", business_type: "reseller", group_id: 2, group_discount_pct: 4, buyer_first_name: "Asa", buyer_last_name: "McCullough", buyer_email: "asa_mccullough@example.org", credit_limit: "24165.13", account_opened_on: "2019-02-27" }, { id: 109, company_name: "Moen and Sons", business_type: "restaurant", group_id: 4, group_discount_pct: 12, buyer_first_name: "Althea", buyer_last_name: "Stehr", buyer_email: "althea.stehr4@example.com", credit_limit: "1293.18", account_opened_on: "2022-08-04" }, { id: 110, company_name: "Price Inc", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Graciela", buyer_last_name: "Treutel", buyer_email: "graciela.treutel2@example.org", credit_limit: "27251.51", account_opened_on: "2021-08-12" }, { id: 111, company_name: "Ward and Sons", business_type: "hotel", group_id: 1, group_discount_pct: 0, buyer_first_name: "Richard", buyer_last_name: "Jacobson", buyer_email: "richard_jacobson@example.org", credit_limit: "36806.50", account_opened_on: "2023-08-31" }, { id: 112, company_name: "Quigley - Anderson", business_type: "restaurant", group_id: 1, group_discount_pct: 0, buyer_first_name: "Clemmie", buyer_last_name: "Hettinger", buyer_email: "clemmie.hettinger@example.com", credit_limit: "13888.34", account_opened_on: "2021-03-02" }, { id: 113, company_name: "Cronin Group", business_type: "office", group_id: 1, group_discount_pct: 0, buyer_first_name: "Danyka", buyer_last_name: "Beer", buyer_email: "danyka_beer@example.org", credit_limit: "9047.34", account_opened_on: "2023-03-02" }, { id: 114, company_name: "O'Keefe - McDermott", business_type: "restaurant", group_id: 2, group_discount_pct: 4, buyer_first_name: "Leanna", buyer_last_name: "Cassin", buyer_email: "leanna.cassin@example.net", credit_limit: "1555.31", account_opened_on: "2019-11-01" }, { id: 115, company_name: "Casper Inc", business_type: "reseller", group_id: 2, group_discount_pct: 4, buyer_first_name: "Della", buyer_last_name: "Pouros", buyer_email: "della_pouros66@example.org", credit_limit: "2507.53", account_opened_on: "2022-11-28" }, { id: 116, company_name: "VonRueden, Leffler and Kuhic", business_type: "hotel", group_id: 1, group_discount_pct: 0, buyer_first_name: "Boyd", buyer_last_name: "Connelly", buyer_email: "boyd.connelly83@example.net", credit_limit: "35007.78", account_opened_on: "2021-05-17" }, { id: 117, company_name: "Stoltenberg - Swift", business_type: "office", group_id: 4, group_discount_pct: 12, buyer_first_name: "Price", buyer_last_name: "Koss", buyer_email: "price.koss34@example.org", credit_limit: "5102.04", account_opened_on: "2020-12-28" }, { id: 118, company_name: "Rodriguez Inc", business_type: "reseller", group_id: 1, group_discount_pct: 0, buyer_first_name: "Deven", buyer_last_name: "Schinner", buyer_email: "deven.schinner@example.org", credit_limit: "5718.16", account_opened_on: "2019-11-09" }, { id: 119, company_name: "D'Amore, Hoeger and Lockman", business_type: "hotel", group_id: 1, group_discount_pct: 0, buyer_first_name: "Belinda", buyer_last_name: "Hegmann", buyer_email: "belinda_hegmann@example.net", credit_limit: "7217.78", account_opened_on: "2021-05-28" }, { id: 120, company_name: "Kerluke and Sons", business_type: "cafe", group_id: 5, group_discount_pct: 16, buyer_first_name: "Rowland", buyer_last_name: "Schneider", buyer_email: "rowland.schneider78@example.net", credit_limit: "7201.63", account_opened_on: "2023-05-06" }, ], }); await prisma.price_breaks.createMany({ data: [ { id: 1, coffee_id: 3, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "30.33", break_price: "30.33" }, { id: 2, coffee_id: 20, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "37.02", break_price: "37.02" }, { id: 3, coffee_id: 15, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.16", break_price: "14.16" }, { id: 4, coffee_id: 30, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.01", break_price: "14.01" }, { id: 5, coffee_id: 28, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "24.84", break_price: "24.84" }, { id: 6, coffee_id: 21, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "34.56", break_price: "34.56" }, { id: 7, coffee_id: 7, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "26.72", break_price: "26.72" }, { id: 8, coffee_id: 26, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "23.54", break_price: "23.54" }, { id: 9, coffee_id: 12, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.14", break_price: "14.14" }, { id: 10, coffee_id: 28, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "24.84", break_price: "23.85" }, { id: 11, coffee_id: 12, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.14", break_price: "13.57" }, { id: 12, coffee_id: 8, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "32.43", break_price: "32.43" }, { id: 13, coffee_id: 7, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "26.72", break_price: "25.65" }, { id: 14, coffee_id: 14, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.02", break_price: "14.02" }, { id: 15, coffee_id: 22, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "21.46", break_price: "21.46" }, { id: 16, coffee_id: 23, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.47", break_price: "14.47" }, { id: 17, coffee_id: 11, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.13", break_price: "14.13" }, { id: 18, coffee_id: 4, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.35", break_price: "14.35" }, { id: 19, coffee_id: 15, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.16", break_price: "13.59" }, { id: 20, coffee_id: 24, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "27.43", break_price: "27.43" }, { id: 21, coffee_id: 10, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "30.58", break_price: "30.58" }, { id: 22, coffee_id: 23, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.47", break_price: "13.89" }, { id: 23, coffee_id: 23, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "14.47", break_price: "13.31" }, { id: 24, coffee_id: 9, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "20.17", break_price: "20.17" }, { id: 25, coffee_id: 16, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.43", break_price: "14.43" }, { id: 26, coffee_id: 2, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "22.05", break_price: "22.05" }, { id: 27, coffee_id: 25, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "15.43", break_price: "15.43" }, { id: 28, coffee_id: 4, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.35", break_price: "13.78" }, { id: 29, coffee_id: 18, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "18.13", break_price: "18.13" }, { id: 30, coffee_id: 17, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "16.34", break_price: "16.34" }, { id: 31, coffee_id: 14, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.02", break_price: "13.46" }, { id: 32, coffee_id: 8, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "32.43", break_price: "31.13" }, { id: 33, coffee_id: 1, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "23.50", break_price: "23.50" }, { id: 34, coffee_id: 10, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "30.58", break_price: "29.36" }, { id: 35, coffee_id: 9, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "20.17", break_price: "19.36" }, { id: 36, coffee_id: 5, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.17", break_price: "14.17" }, { id: 37, coffee_id: 12, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "14.14", break_price: "13.01" }, { id: 38, coffee_id: 29, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "22.75", break_price: "22.75" }, { id: 39, coffee_id: 1, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "23.50", break_price: "22.56" }, { id: 40, coffee_id: 4, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "14.35", break_price: "13.20" }, { id: 41, coffee_id: 17, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "16.34", break_price: "15.69" }, { id: 42, coffee_id: 13, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "17.60", break_price: "17.60" }, { id: 43, coffee_id: 14, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "14.02", break_price: "12.90" }, { id: 44, coffee_id: 27, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "36.40", break_price: "36.40" }, { id: 45, coffee_id: 29, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "22.75", break_price: "21.84" }, { id: 46, coffee_id: 16, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.43", break_price: "13.85" }, { id: 47, coffee_id: 21, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "34.56", break_price: "33.18" }, { id: 48, coffee_id: 17, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "16.34", break_price: "15.03" }, { id: 49, coffee_id: 24, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "27.43", break_price: "26.33" }, { id: 50, coffee_id: 30, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.01", break_price: "13.45" }, { id: 51, coffee_id: 11, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.13", break_price: "13.56" }, { id: 52, coffee_id: 6, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "14.35", break_price: "14.35" }, { id: 53, coffee_id: 14, break_no: 4, applies_above_kg: 150, price_multiplier: "0.88", list_price: "14.02", break_price: "12.34" }, { id: 54, coffee_id: 27, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "36.40", break_price: "34.94" }, { id: 55, coffee_id: 4, break_no: 4, applies_above_kg: 150, price_multiplier: "0.88", list_price: "14.35", break_price: "12.63" }, { id: 56, coffee_id: 5, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.17", break_price: "13.60" }, { id: 57, coffee_id: 2, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "22.05", break_price: "21.17" }, { id: 58, coffee_id: 26, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "23.54", break_price: "22.60" }, { id: 59, coffee_id: 13, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "17.60", break_price: "16.90" }, { id: 60, coffee_id: 2, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "22.05", break_price: "20.29" }, { id: 61, coffee_id: 21, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "34.56", break_price: "31.80" }, { id: 62, coffee_id: 20, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "37.02", break_price: "35.54" }, { id: 63, coffee_id: 6, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "14.35", break_price: "13.78" }, { id: 64, coffee_id: 10, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "30.58", break_price: "28.13" }, { id: 65, coffee_id: 6, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "14.35", break_price: "13.20" }, { id: 66, coffee_id: 2, break_no: 4, applies_above_kg: 150, price_multiplier: "0.88", list_price: "22.05", break_price: "19.40" }, { id: 67, coffee_id: 21, break_no: 4, applies_above_kg: 150, price_multiplier: "0.88", list_price: "34.56", break_price: "30.41" }, { id: 68, coffee_id: 1, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "23.50", break_price: "21.62" }, { id: 69, coffee_id: 26, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "23.54", break_price: "21.66" }, { id: 70, coffee_id: 19, break_no: 1, applies_above_kg: 0, price_multiplier: "1.00", list_price: "26.59", break_price: "26.59" }, { id: 71, coffee_id: 19, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "26.59", break_price: "25.53" }, { id: 72, coffee_id: 3, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "30.33", break_price: "29.12" }, { id: 73, coffee_id: 5, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "14.17", break_price: "13.04" }, { id: 74, coffee_id: 18, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "18.13", break_price: "17.40" }, { id: 75, coffee_id: 13, break_no: 3, applies_above_kg: 100, price_multiplier: "0.92", list_price: "17.60", break_price: "16.19" }, { id: 76, coffee_id: 22, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "21.46", break_price: "20.60" }, { id: 77, coffee_id: 25, break_no: 2, applies_above_kg: 50, price_multiplier: "0.96", list_price: "15.43", break_price: "14.81" }, { id: 78, coffee_id: 5, break_no: 4, applies_above_kg: 150, price_multiplier: "0.88", list_price: "14.17", break_price: "12.47" }, ], }); await prisma.quotes.createMany({ data: [ { id: 1, customer_id: 70, quote_number: "Q-499370", group_discount_pct: 4, issued_at: new Date("2024-03-16T15:25:20Z"), valid_until: "2024-03-27", status: "accepted" }, { id: 2, customer_id: 23, quote_number: "Q-555176", group_discount_pct: 0, issued_at: new Date("2024-04-18T11:12:16Z"), valid_until: "2024-05-11", status: "accepted" }, { id: 3, customer_id: 109, quote_number: "Q-483561", group_discount_pct: 12, issued_at: new Date("2024-03-08T06:21:13Z"), valid_until: "2024-03-17", status: "declined" }, { id: 4, customer_id: 20, quote_number: "Q-760889", group_discount_pct: 12, issued_at: new Date("2024-06-05T09:38:03Z"), valid_until: "2024-07-03", status: "accepted" }, { id: 5, customer_id: 91, quote_number: "Q-044157", group_discount_pct: 8, issued_at: new Date("2024-06-09T13:50:49Z"), valid_until: "2024-07-05", status: "expired" }, { id: 6, customer_id: 101, quote_number: "Q-304321", group_discount_pct: 0, issued_at: new Date("2024-08-08T13:00:59Z"), valid_until: "2024-08-19", status: "accepted" }, { id: 7, customer_id: 72, quote_number: "Q-330457", group_discount_pct: 12, issued_at: new Date("2024-06-24T21:03:51Z"), valid_until: "2024-07-02", status: "accepted" }, { id: 8, customer_id: 112, quote_number: "Q-755476", group_discount_pct: 0, issued_at: new Date("2024-07-08T12:38:05Z"), valid_until: "2024-08-03", status: "accepted" }, { id: 9, customer_id: 102, quote_number: "Q-349527", group_discount_pct: 0, issued_at: new Date("2024-09-29T16:07:57Z"), valid_until: "2024-09-30", status: "declined" }, { id: 10, customer_id: 100, quote_number: "Q-254788", group_discount_pct: 0, issued_at: new Date("2024-05-03T10:53:30Z"), valid_until: "2024-05-26", status: "expired" }, { id: 11, customer_id: 92, quote_number: "Q-940355", group_discount_pct: 0, issued_at: new Date("2024-06-03T14:47:27Z"), valid_until: "2024-06-21", status: "sent" }, { id: 12, customer_id: 59, quote_number: "Q-870265", group_discount_pct: 12, issued_at: new Date("2024-09-19T11:18:52Z"), valid_until: "2024-10-18", status: "declined" }, { id: 13, customer_id: 111, quote_number: "Q-077395", group_discount_pct: 0, issued_at: new Date("2024-08-24T12:09:14Z"), valid_until: "2024-09-03", status: "draft" }, { id: 14, customer_id: 90, quote_number: "Q-654155", group_discount_pct: 0, issued_at: new Date("2024-08-31T09:33:57Z"), valid_until: "2024-09-12", status: "expired" }, { id: 15, customer_id: 110, quote_number: "Q-190183", group_discount_pct: 0, issued_at: new Date("2024-03-12T09:01:24Z"), valid_until: "2024-03-17", status: "sent" }, { id: 16, customer_id: 105, quote_number: "Q-895482", group_discount_pct: 0, issued_at: new Date("2024-03-26T11:07:50Z"), valid_until: "2024-04-03", status: "expired" }, { id: 17, customer_id: 21, quote_number: "Q-561906", group_discount_pct: 0, issued_at: new Date("2024-04-30T10:30:45Z"), valid_until: "2024-05-30", status: "declined" }, { id: 18, customer_id: 68, quote_number: "Q-575513", group_discount_pct: 0, issued_at: new Date("2024-06-14T13:57:49Z"), valid_until: "2024-07-08", status: "sent" }, { id: 19, customer_id: 29, quote_number: "Q-411526", group_discount_pct: 16, issued_at: new Date("2024-07-27T15:55:57Z"), valid_until: "2024-08-07", status: "draft" }, { id: 20, customer_id: 40, quote_number: "Q-041192", group_discount_pct: 0, issued_at: new Date("2024-05-17T13:22:32Z"), valid_until: "2024-05-23", status: "sent" }, { id: 21, customer_id: 97, quote_number: "Q-106536", group_discount_pct: 0, issued_at: new Date("2024-09-25T13:57:48Z"), valid_until: "2024-09-29", status: "draft" }, { id: 22, customer_id: 36, quote_number: "Q-809163", group_discount_pct: 16, issued_at: new Date("2024-03-22T14:47:07Z"), valid_until: "2024-04-16", status: "expired" }, { id: 23, customer_id: 43, quote_number: "Q-607720", group_discount_pct: 4, issued_at: new Date("2024-04-10T15:30:13Z"), valid_until: "2024-05-04", status: "accepted" }, { id: 24, customer_id: 24, quote_number: "Q-938986", group_discount_pct: 4, issued_at: new Date("2024-09-28T14:42:07Z"), valid_until: "2024-10-13", status: "declined" }, { id: 25, customer_id: 55, quote_number: "Q-054872", group_discount_pct: 4, issued_at: new Date("2024-07-23T15:36:29Z"), valid_until: "2024-07-24", status: "draft" }, { id: 26, customer_id: 116, quote_number: "Q-664570", group_discount_pct: 0, issued_at: new Date("2024-09-15T13:30:57Z"), valid_until: "2024-10-10", status: "accepted" }, { id: 27, customer_id: 114, quote_number: "Q-042140", group_discount_pct: 4, issued_at: new Date("2024-07-16T16:00:03Z"), valid_until: "2024-08-02", status: "sent" }, { id: 28, customer_id: 10, quote_number: "Q-576376", group_discount_pct: 0, issued_at: new Date("2024-03-26T11:40:40Z"), valid_until: "2024-03-28", status: "sent" }, { id: 29, customer_id: 12, quote_number: "Q-603549", group_discount_pct: 0, issued_at: new Date("2024-06-05T09:57:35Z"), valid_until: "2024-06-09", status: "accepted" }, { id: 30, customer_id: 32, quote_number: "Q-333068", group_discount_pct: 4, issued_at: new Date("2024-07-28T10:48:52Z"), valid_until: "2024-08-18", status: "expired" }, { id: 31, customer_id: 119, quote_number: "Q-954073", group_discount_pct: 0, issued_at: new Date("2024-07-25T13:15:43Z"), valid_until: "2024-08-03", status: "declined" }, { id: 32, customer_id: 17, quote_number: "Q-797691", group_discount_pct: 12, issued_at: new Date("2024-08-04T09:53:01Z"), valid_until: "2024-08-16", status: "sent" }, { id: 33, customer_id: 106, quote_number: "Q-011052", group_discount_pct: 8, issued_at: new Date("2024-06-23T12:37:00Z"), valid_until: "2024-07-22", status: "expired" }, { id: 34, customer_id: 6, quote_number: "Q-737112", group_discount_pct: 0, issued_at: new Date("2024-08-30T12:16:34Z"), valid_until: "2024-09-15", status: "accepted" }, { id: 35, customer_id: 59, quote_number: "Q-562424", group_discount_pct: 12, issued_at: new Date("2024-09-01T08:41:11Z"), valid_until: "2024-09-21", status: "declined" }, { id: 36, customer_id: 50, quote_number: "Q-667986", group_discount_pct: 4, issued_at: new Date("2024-08-22T17:40:50Z"), valid_until: "2024-08-24", status: "expired" }, { id: 37, customer_id: 27, quote_number: "Q-471389", group_discount_pct: 4, issued_at: new Date("2024-07-26T15:22:09Z"), valid_until: "2024-08-17", status: "accepted" }, { id: 38, customer_id: 22, quote_number: "Q-221546", group_discount_pct: 16, issued_at: new Date("2024-05-19T13:51:54Z"), valid_until: "2024-06-09", status: "accepted" }, { id: 39, customer_id: 78, quote_number: "Q-273820", group_discount_pct: 4, issued_at: new Date("2024-05-01T21:31:01Z"), valid_until: "2024-05-16", status: "declined" }, { id: 40, customer_id: 13, quote_number: "Q-678309", group_discount_pct: 0, issued_at: new Date("2024-06-01T13:32:51Z"), valid_until: "2024-06-06", status: "accepted" }, { id: 41, customer_id: 58, quote_number: "Q-003224", group_discount_pct: 0, issued_at: new Date("2024-05-20T15:01:04Z"), valid_until: "2024-06-11", status: "sent" }, { id: 42, customer_id: 92, quote_number: "Q-354002", group_discount_pct: 0, issued_at: new Date("2024-07-23T08:03:43Z"), valid_until: "2024-07-26", status: "accepted" }, { id: 43, customer_id: 98, quote_number: "Q-005982", group_discount_pct: 12, issued_at: new Date("2024-09-28T08:38:36Z"), valid_until: "2024-10-21", status: "accepted" }, { id: 44, customer_id: 84, quote_number: "Q-439081", group_discount_pct: 0, issued_at: new Date("2024-03-17T14:19:35Z"), valid_until: "2024-04-15", status: "accepted" }, { id: 45, customer_id: 4, quote_number: "Q-761842", group_discount_pct: 16, issued_at: new Date("2024-08-22T19:25:06Z"), valid_until: "2024-09-21", status: "draft" }, { id: 46, customer_id: 48, quote_number: "Q-866820", group_discount_pct: 12, issued_at: new Date("2024-03-27T10:53:27Z"), valid_until: "2024-04-25", status: "expired" }, { id: 47, customer_id: 104, quote_number: "Q-848992", group_discount_pct: 0, issued_at: new Date("2024-03-25T13:30:08Z"), valid_until: "2024-04-08", status: "declined" }, { id: 48, customer_id: 63, quote_number: "Q-850683", group_discount_pct: 4, issued_at: new Date("2024-05-14T10:53:53Z"), valid_until: "2024-06-12", status: "sent" }, { id: 49, customer_id: 15, quote_number: "Q-386869", group_discount_pct: 4, issued_at: new Date("2024-07-29T10:25:27Z"), valid_until: "2024-08-14", status: "accepted" }, { id: 50, customer_id: 59, quote_number: "Q-503635", group_discount_pct: 12, issued_at: new Date("2024-05-25T11:03:56Z"), valid_until: "2024-06-19", status: "sent" }, { id: 51, customer_id: 53, quote_number: "Q-917151", group_discount_pct: 0, issued_at: new Date("2024-05-13T15:02:44Z"), valid_until: "2024-05-22", status: "expired" }, { id: 52, customer_id: 55, quote_number: "Q-888989", group_discount_pct: 4, issued_at: new Date("2024-04-03T20:49:00Z"), valid_until: "2024-04-20", status: "expired" }, { id: 53, customer_id: 61, quote_number: "Q-755381", group_discount_pct: 16, issued_at: new Date("2024-05-12T17:50:17Z"), valid_until: "2024-05-15", status: "sent" }, { id: 54, customer_id: 115, quote_number: "Q-496465", group_discount_pct: 4, issued_at: new Date("2024-04-13T10:53:41Z"), valid_until: "2024-05-01", status: "expired" }, { id: 55, customer_id: 45, quote_number: "Q-050644", group_discount_pct: 4, issued_at: new Date("2024-04-06T13:10:57Z"), valid_until: "2024-05-01", status: "draft" }, { id: 56, customer_id: 69, quote_number: "Q-523964", group_discount_pct: 4, issued_at: new Date("2024-09-26T11:04:39Z"), valid_until: "2024-10-17", status: "accepted" }, { id: 57, customer_id: 89, quote_number: "Q-526055", group_discount_pct: 12, issued_at: new Date("2024-03-07T09:34:07Z"), valid_until: "2024-03-16", status: "accepted" }, { id: 58, customer_id: 47, quote_number: "Q-137548", group_discount_pct: 0, issued_at: new Date("2024-08-21T15:18:02Z"), valid_until: "2024-09-13", status: "sent" }, { id: 59, customer_id: 91, quote_number: "Q-969010", group_discount_pct: 8, issued_at: new Date("2024-05-02T09:19:35Z"), valid_until: "2024-05-12", status: "declined" }, { id: 60, customer_id: 30, quote_number: "Q-425420", group_discount_pct: 0, issued_at: new Date("2024-05-28T19:20:37Z"), valid_until: "2024-06-01", status: "accepted" }, { id: 61, customer_id: 8, quote_number: "Q-386582", group_discount_pct: 0, issued_at: new Date("2024-03-02T16:47:43Z"), valid_until: "2024-03-15", status: "accepted" }, { id: 62, customer_id: 31, quote_number: "Q-607301", group_discount_pct: 4, issued_at: new Date("2024-03-13T22:05:46Z"), valid_until: "2024-04-12", status: "sent" }, { id: 63, customer_id: 106, quote_number: "Q-274437", group_discount_pct: 8, issued_at: new Date("2024-04-25T13:37:10Z"), valid_until: "2024-05-21", status: "accepted" }, { id: 64, customer_id: 25, quote_number: "Q-488269", group_discount_pct: 0, issued_at: new Date("2024-03-30T15:49:11Z"), valid_until: "2024-04-17", status: "expired" }, { id: 65, customer_id: 6, quote_number: "Q-151681", group_discount_pct: 0, issued_at: new Date("2024-03-10T11:24:18Z"), valid_until: "2024-03-11", status: "accepted" }, { id: 66, customer_id: 69, quote_number: "Q-164116", group_discount_pct: 4, issued_at: new Date("2024-06-15T13:40:54Z"), valid_until: "2024-06-30", status: "sent" }, { id: 67, customer_id: 54, quote_number: "Q-711869", group_discount_pct: 0, issued_at: new Date("2024-05-19T14:43:01Z"), valid_until: "2024-06-03", status: "declined" }, { id: 68, customer_id: 82, quote_number: "Q-850129", group_discount_pct: 0, issued_at: new Date("2024-03-26T18:24:56Z"), valid_until: "2024-04-15", status: "sent" }, { id: 69, customer_id: 88, quote_number: "Q-083208", group_discount_pct: 4, issued_at: new Date("2024-03-03T11:20:50Z"), valid_until: "2024-03-12", status: "accepted" }, { id: 70, customer_id: 24, quote_number: "Q-848402", group_discount_pct: 4, issued_at: new Date("2024-08-20T18:03:42Z"), valid_until: "2024-09-10", status: "draft" }, { id: 71, customer_id: 50, quote_number: "Q-607469", group_discount_pct: 4, issued_at: new Date("2024-06-23T14:05:18Z"), valid_until: "2024-06-30", status: "declined" }, { id: 72, customer_id: 40, quote_number: "Q-843282", group_discount_pct: 0, issued_at: new Date("2024-09-29T15:56:52Z"), valid_until: "2024-10-27", status: "accepted" }, { id: 73, customer_id: 74, quote_number: "Q-014139", group_discount_pct: 0, issued_at: new Date("2024-07-18T13:44:03Z"), valid_until: "2024-07-18", status: "expired" }, { id: 74, customer_id: 34, quote_number: "Q-707621", group_discount_pct: 0, issued_at: new Date("2024-03-01T10:57:15Z"), valid_until: "2024-03-18", status: "draft" }, { id: 75, customer_id: 93, quote_number: "Q-445653", group_discount_pct: 0, issued_at: new Date("2024-09-20T12:59:25Z"), valid_until: "2024-10-11", status: "accepted" }, { id: 76, customer_id: 39, quote_number: "Q-482712", group_discount_pct: 0, issued_at: new Date("2024-05-29T19:53:22Z"), valid_until: "2024-06-26", status: "expired" }, { id: 77, customer_id: 46, quote_number: "Q-763882", group_discount_pct: 8, issued_at: new Date("2024-06-09T17:57:05Z"), valid_until: "2024-06-21", status: "accepted" }, { id: 78, customer_id: 103, quote_number: "Q-115541", group_discount_pct: 4, issued_at: new Date("2024-05-20T12:46:56Z"), valid_until: "2024-06-15", status: "accepted" }, { id: 79, customer_id: 74, quote_number: "Q-853400", group_discount_pct: 0, issued_at: new Date("2024-05-30T11:14:28Z"), valid_until: "2024-06-04", status: "accepted" }, { id: 80, customer_id: 101, quote_number: "Q-301674", group_discount_pct: 0, issued_at: new Date("2024-07-04T16:00:18Z"), valid_until: "2024-07-31", status: "accepted" }, { id: 81, customer_id: 3, quote_number: "Q-978347", group_discount_pct: 8, issued_at: new Date("2024-05-20T04:26:32Z"), valid_until: "2024-05-29", status: "accepted" }, { id: 82, customer_id: 39, quote_number: "Q-568067", group_discount_pct: 0, issued_at: new Date("2024-05-26T09:42:09Z"), valid_until: "2024-05-27", status: "expired" }, { id: 83, customer_id: 20, quote_number: "Q-788398", group_discount_pct: 12, issued_at: new Date("2024-03-03T10:51:20Z"), valid_until: "2024-03-31", status: "expired" }, { id: 84, customer_id: 33, quote_number: "Q-991179", group_discount_pct: 0, issued_at: new Date("2024-05-06T09:39:18Z"), valid_until: "2024-05-10", status: "sent" }, { id: 85, customer_id: 45, quote_number: "Q-424076", group_discount_pct: 4, issued_at: new Date("2024-05-18T13:32:15Z"), valid_until: "2024-05-27", status: "sent" }, { id: 86, customer_id: 74, quote_number: "Q-051463", group_discount_pct: 0, issued_at: new Date("2024-08-16T19:34:22Z"), valid_until: "2024-09-11", status: "declined" }, { id: 87, customer_id: 83, quote_number: "Q-478227", group_discount_pct: 0, issued_at: new Date("2024-03-02T17:38:40Z"), valid_until: "2024-03-11", status: "sent" }, { id: 88, customer_id: 4, quote_number: "Q-441152", group_discount_pct: 16, issued_at: new Date("2024-04-16T15:57:05Z"), valid_until: "2024-05-04", status: "sent" }, { id: 89, customer_id: 57, quote_number: "Q-511043", group_discount_pct: 0, issued_at: new Date("2024-06-08T10:50:48Z"), valid_until: "2024-07-01", status: "declined" }, { id: 90, customer_id: 57, quote_number: "Q-179760", group_discount_pct: 0, issued_at: new Date("2024-09-11T00:28:44Z"), valid_until: "2024-09-12", status: "draft" }, { id: 91, customer_id: 42, quote_number: "Q-593691", group_discount_pct: 0, issued_at: new Date("2024-06-09T13:52:19Z"), valid_until: "2024-07-08", status: "accepted" }, { id: 92, customer_id: 89, quote_number: "Q-746796", group_discount_pct: 12, issued_at: new Date("2024-05-19T10:21:12Z"), valid_until: "2024-05-19", status: "expired" }, { id: 93, customer_id: 35, quote_number: "Q-123676", group_discount_pct: 8, issued_at: new Date("2024-03-14T20:26:06Z"), valid_until: "2024-03-25", status: "sent" }, { id: 94, customer_id: 77, quote_number: "Q-042067", group_discount_pct: 12, issued_at: new Date("2024-05-08T13:19:56Z"), valid_until: "2024-05-14", status: "expired" }, { id: 95, customer_id: 119, quote_number: "Q-602700", group_discount_pct: 0, issued_at: new Date("2024-08-09T09:23:24Z"), valid_until: "2024-08-22", status: "sent" }, { id: 96, customer_id: 113, quote_number: "Q-458814", group_discount_pct: 0, issued_at: new Date("2024-03-22T10:07:14Z"), valid_until: "2024-04-15", status: "sent" }, { id: 97, customer_id: 51, quote_number: "Q-550239", group_discount_pct: 8, issued_at: new Date("2024-06-22T15:06:20Z"), valid_until: "2024-07-06", status: "accepted" }, { id: 98, customer_id: 42, quote_number: "Q-665154", group_discount_pct: 0, issued_at: new Date("2024-05-07T14:38:02Z"), valid_until: "2024-06-01", status: "declined" }, { id: 99, customer_id: 110, quote_number: "Q-200094", group_discount_pct: 0, issued_at: new Date("2024-09-21T08:45:25Z"), valid_until: "2024-10-03", status: "sent" }, { id: 100, customer_id: 41, quote_number: "Q-346907", group_discount_pct: 0, issued_at: new Date("2024-07-20T23:03:17Z"), valid_until: "2024-08-17", status: "accepted" }, { id: 101, customer_id: 66, quote_number: "Q-437693", group_discount_pct: 8, issued_at: new Date("2024-03-22T17:29:55Z"), valid_until: "2024-04-08", status: "declined" }, { id: 102, customer_id: 61, quote_number: "Q-555998", group_discount_pct: 16, issued_at: new Date("2024-05-12T14:03:26Z"), valid_until: "2024-05-29", status: "sent" }, { id: 103, customer_id: 103, quote_number: "Q-290686", group_discount_pct: 4, issued_at: new Date("2024-06-17T10:36:51Z"), valid_until: "2024-06-27", status: "accepted" }, { id: 104, customer_id: 76, quote_number: "Q-177411", group_discount_pct: 0, issued_at: new Date("2024-07-14T13:19:11Z"), valid_until: "2024-08-09", status: "expired" }, { id: 105, customer_id: 84, quote_number: "Q-862553", group_discount_pct: 0, issued_at: new Date("2024-04-11T13:12:39Z"), valid_until: "2024-04-19", status: "accepted" }, { id: 106, customer_id: 65, quote_number: "Q-317509", group_discount_pct: 0, issued_at: new Date("2024-05-31T15:07:14Z"), valid_until: "2024-06-10", status: "declined" }, { id: 107, customer_id: 120, quote_number: "Q-042505", group_discount_pct: 16, issued_at: new Date("2024-03-12T12:18:51Z"), valid_until: "2024-04-04", status: "sent" }, { id: 108, customer_id: 28, quote_number: "Q-765235", group_discount_pct: 8, issued_at: new Date("2024-06-30T13:03:16Z"), valid_until: "2024-07-06", status: "accepted" }, { id: 109, customer_id: 56, quote_number: "Q-408455", group_discount_pct: 0, issued_at: new Date("2024-05-17T11:37:52Z"), valid_until: "2024-06-11", status: "declined" }, { id: 110, customer_id: 106, quote_number: "Q-198119", group_discount_pct: 8, issued_at: new Date("2024-07-24T15:23:52Z"), valid_until: "2024-08-23", status: "sent" }, { id: 111, customer_id: 77, quote_number: "Q-126979", group_discount_pct: 12, issued_at: new Date("2024-04-01T17:30:35Z"), valid_until: "2024-04-04", status: "accepted" }, { id: 112, customer_id: 53, quote_number: "Q-437598", group_discount_pct: 0, issued_at: new Date("2024-04-10T08:31:06Z"), valid_until: "2024-04-26", status: "accepted" }, { id: 113, customer_id: 72, quote_number: "Q-941418", group_discount_pct: 12, issued_at: new Date("2024-04-17T11:37:02Z"), valid_until: "2024-04-29", status: "accepted" }, { id: 114, customer_id: 52, quote_number: "Q-527611", group_discount_pct: 0, issued_at: new Date("2024-04-12T11:12:14Z"), valid_until: "2024-05-09", status: "accepted" }, { id: 115, customer_id: 6, quote_number: "Q-405583", group_discount_pct: 0, issued_at: new Date("2024-04-27T13:45:20Z"), valid_until: "2024-05-20", status: "expired" }, { id: 116, customer_id: 86, quote_number: "Q-185826", group_discount_pct: 4, issued_at: new Date("2024-09-04T17:45:09Z"), valid_until: "2024-09-11", status: "sent" }, { id: 117, customer_id: 107, quote_number: "Q-150918", group_discount_pct: 0, issued_at: new Date("2024-07-13T09:50:34Z"), valid_until: "2024-08-10", status: "accepted" }, { id: 118, customer_id: 101, quote_number: "Q-947668", group_discount_pct: 0, issued_at: new Date("2024-03-06T14:08:06Z"), valid_until: "2024-04-01", status: "expired" }, { id: 119, customer_id: 92, quote_number: "Q-816160", group_discount_pct: 0, issued_at: new Date("2024-05-03T18:32:23Z"), valid_until: "2024-05-24", status: "accepted" }, { id: 120, customer_id: 81, quote_number: "Q-167486", group_discount_pct: 0, issued_at: new Date("2024-07-29T14:31:00Z"), valid_until: "2024-07-31", status: "accepted" }, { id: 121, customer_id: 79, quote_number: "Q-089657", group_discount_pct: 8, issued_at: new Date("2024-04-29T11:48:47Z"), valid_until: "2024-05-13", status: "expired" }, { id: 122, customer_id: 98, quote_number: "Q-082394", group_discount_pct: 12, issued_at: new Date("2024-09-15T15:47:26Z"), valid_until: "2024-10-05", status: "sent" }, { id: 123, customer_id: 15, quote_number: "Q-742220", group_discount_pct: 4, issued_at: new Date("2024-06-13T02:05:43Z"), valid_until: "2024-06-28", status: "draft" }, { id: 124, customer_id: 113, quote_number: "Q-824612", group_discount_pct: 0, issued_at: new Date("2024-07-11T11:12:05Z"), valid_until: "2024-07-22", status: "accepted" }, { id: 125, customer_id: 9, quote_number: "Q-426242", group_discount_pct: 0, issued_at: new Date("2024-04-28T11:28:47Z"), valid_until: "2024-04-30", status: "sent" }, { id: 126, customer_id: 95, quote_number: "Q-133513", group_discount_pct: 16, issued_at: new Date("2024-08-19T13:26:17Z"), valid_until: "2024-08-31", status: "sent" }, { id: 127, customer_id: 11, quote_number: "Q-517413", group_discount_pct: 4, issued_at: new Date("2024-04-05T13:50:25Z"), valid_until: "2024-04-09", status: "accepted" }, { id: 128, customer_id: 13, quote_number: "Q-216698", group_discount_pct: 0, issued_at: new Date("2024-08-22T10:07:07Z"), valid_until: "2024-09-10", status: "draft" }, { id: 129, customer_id: 75, quote_number: "Q-862479", group_discount_pct: 4, issued_at: new Date("2024-05-05T08:37:51Z"), valid_until: "2024-05-16", status: "sent" }, { id: 130, customer_id: 44, quote_number: "Q-121289", group_discount_pct: 0, issued_at: new Date("2024-08-15T16:20:31Z"), valid_until: "2024-08-29", status: "accepted" }, { id: 131, customer_id: 117, quote_number: "Q-474816", group_discount_pct: 12, issued_at: new Date("2024-06-14T16:19:05Z"), valid_until: "2024-06-29", status: "accepted" }, { id: 132, customer_id: 52, quote_number: "Q-981485", group_discount_pct: 0, issued_at: new Date("2024-07-11T15:51:51Z"), valid_until: "2024-07-30", status: "expired" }, { id: 133, customer_id: 96, quote_number: "Q-074201", group_discount_pct: 0, issued_at: new Date("2024-04-22T10:16:55Z"), valid_until: "2024-05-18", status: "accepted" }, { id: 134, customer_id: 87, quote_number: "Q-874140", group_discount_pct: 0, issued_at: new Date("2024-05-29T14:40:12Z"), valid_until: "2024-06-15", status: "draft" }, { id: 135, customer_id: 38, quote_number: "Q-664508", group_discount_pct: 0, issued_at: new Date("2024-08-11T14:49:51Z"), valid_until: "2024-08-22", status: "sent" }, { id: 136, customer_id: 37, quote_number: "Q-120839", group_discount_pct: 0, issued_at: new Date("2024-09-21T09:03:47Z"), valid_until: "2024-09-21", status: "accepted" }, { id: 137, customer_id: 108, quote_number: "Q-470952", group_discount_pct: 4, issued_at: new Date("2024-04-01T10:02:50Z"), valid_until: "2024-05-01", status: "accepted" }, { id: 138, customer_id: 67, quote_number: "Q-427522", group_discount_pct: 4, issued_at: new Date("2024-08-06T10:41:04Z"), valid_until: "2024-09-01", status: "draft" }, { id: 139, customer_id: 47, quote_number: "Q-997313", group_discount_pct: 0, issued_at: new Date("2024-07-17T09:16:33Z"), valid_until: "2024-07-19", status: "declined" }, { id: 140, customer_id: 16, quote_number: "Q-114839", group_discount_pct: 0, issued_at: new Date("2024-05-08T13:28:35Z"), valid_until: "2024-05-17", status: "accepted" }, { id: 141, customer_id: 93, quote_number: "Q-283889", group_discount_pct: 0, issued_at: new Date("2024-08-30T09:40:38Z"), valid_until: "2024-09-10", status: "sent" }, { id: 142, customer_id: 120, quote_number: "Q-061403", group_discount_pct: 16, issued_at: new Date("2024-09-20T13:50:14Z"), valid_until: "2024-10-06", status: "accepted" }, { id: 143, customer_id: 40, quote_number: "Q-341070", group_discount_pct: 0, issued_at: new Date("2024-04-28T09:02:46Z"), valid_until: "2024-05-09", status: "sent" }, { id: 144, customer_id: 5, quote_number: "Q-147817", group_discount_pct: 4, issued_at: new Date("2024-08-22T21:26:59Z"), valid_until: "2024-09-09", status: "draft" }, { id: 145, customer_id: 26, quote_number: "Q-669742", group_discount_pct: 0, issued_at: new Date("2024-08-27T14:20:48Z"), valid_until: "2024-09-15", status: "expired" }, { id: 146, customer_id: 18, quote_number: "Q-977864", group_discount_pct: 0, issued_at: new Date("2024-09-14T14:58:34Z"), valid_until: "2024-09-23", status: "accepted" }, { id: 147, customer_id: 3, quote_number: "Q-168064", group_discount_pct: 8, issued_at: new Date("2024-06-28T11:37:48Z"), valid_until: "2024-07-02", status: "accepted" }, { id: 148, customer_id: 39, quote_number: "Q-700457", group_discount_pct: 0, issued_at: new Date("2024-04-20T07:05:20Z"), valid_until: "2024-04-25", status: "sent" }, { id: 149, customer_id: 27, quote_number: "Q-860227", group_discount_pct: 4, issued_at: new Date("2024-07-01T19:04:07Z"), valid_until: "2024-07-19", status: "accepted" }, { id: 150, customer_id: 64, quote_number: "Q-511584", group_discount_pct: 4, issued_at: new Date("2024-04-02T08:42:31Z"), valid_until: "2024-04-06", status: "sent" }, { id: 151, customer_id: 4, quote_number: "Q-468979", group_discount_pct: 16, issued_at: new Date("2024-08-28T13:32:01Z"), valid_until: "2024-09-05", status: "sent" }, { id: 152, customer_id: 89, quote_number: "Q-608611", group_discount_pct: 12, issued_at: new Date("2024-03-14T14:44:20Z"), valid_until: "2024-03-28", status: "accepted" }, { id: 153, customer_id: 62, quote_number: "Q-574775", group_discount_pct: 0, issued_at: new Date("2024-09-29T14:00:55Z"), valid_until: "2024-10-19", status: "expired" }, { id: 154, customer_id: 60, quote_number: "Q-946982", group_discount_pct: 4, issued_at: new Date("2024-07-08T13:25:33Z"), valid_until: "2024-07-21", status: "expired" }, { id: 155, customer_id: 12, quote_number: "Q-904587", group_discount_pct: 0, issued_at: new Date("2024-07-13T16:26:49Z"), valid_until: "2024-07-15", status: "expired" }, { id: 156, customer_id: 19, quote_number: "Q-036545", group_discount_pct: 12, issued_at: new Date("2024-03-13T07:18:09Z"), valid_until: "2024-04-01", status: "draft" }, { id: 157, customer_id: 73, quote_number: "Q-110254", group_discount_pct: 16, issued_at: new Date("2024-07-25T15:08:07Z"), valid_until: "2024-08-17", status: "accepted" }, { id: 158, customer_id: 68, quote_number: "Q-704251", group_discount_pct: 0, issued_at: new Date("2024-09-13T09:29:40Z"), valid_until: "2024-10-11", status: "sent" }, { id: 159, customer_id: 102, quote_number: "Q-350985", group_discount_pct: 0, issued_at: new Date("2024-05-04T09:04:24Z"), valid_until: "2024-05-29", status: "accepted" }, { id: 160, customer_id: 34, quote_number: "Q-789488", group_discount_pct: 0, issued_at: new Date("2024-09-26T04:39:15Z"), valid_until: "2024-09-29", status: "accepted" }, { id: 161, customer_id: 73, quote_number: "Q-309420", group_discount_pct: 16, issued_at: new Date("2024-08-04T14:27:45Z"), valid_until: "2024-08-30", status: "accepted" }, { id: 162, customer_id: 7, quote_number: "Q-066223", group_discount_pct: 16, issued_at: new Date("2024-03-10T16:29:24Z"), valid_until: "2024-03-29", status: "expired" }, { id: 163, customer_id: 85, quote_number: "Q-121317", group_discount_pct: 16, issued_at: new Date("2024-06-13T13:52:38Z"), valid_until: "2024-06-21", status: "accepted" }, { id: 164, customer_id: 72, quote_number: "Q-055145", group_discount_pct: 12, issued_at: new Date("2024-06-03T15:44:58Z"), valid_until: "2024-07-01", status: "draft" }, { id: 165, customer_id: 80, quote_number: "Q-985700", group_discount_pct: 0, issued_at: new Date("2024-05-28T09:59:27Z"), valid_until: "2024-06-12", status: "accepted" }, { id: 166, customer_id: 3, quote_number: "Q-538429", group_discount_pct: 8, issued_at: new Date("2024-06-16T09:37:39Z"), valid_until: "2024-06-28", status: "accepted" }, { id: 167, customer_id: 71, quote_number: "Q-743772", group_discount_pct: 0, issued_at: new Date("2024-04-20T07:43:11Z"), valid_until: "2024-04-25", status: "declined" }, { id: 168, customer_id: 1, quote_number: "Q-579026", group_discount_pct: 0, issued_at: new Date("2024-04-13T09:44:34Z"), valid_until: "2024-04-20", status: "declined" }, { id: 169, customer_id: 120, quote_number: "Q-437154", group_discount_pct: 16, issued_at: new Date("2024-03-31T12:44:36Z"), valid_until: "2024-04-01", status: "accepted" }, { id: 170, customer_id: 91, quote_number: "Q-799507", group_discount_pct: 8, issued_at: new Date("2024-07-27T13:19:07Z"), valid_until: "2024-08-02", status: "expired" }, { id: 171, customer_id: 84, quote_number: "Q-723927", group_discount_pct: 0, issued_at: new Date("2024-04-26T13:35:45Z"), valid_until: "2024-05-02", status: "sent" }, { id: 172, customer_id: 18, quote_number: "Q-157585", group_discount_pct: 0, issued_at: new Date("2024-06-10T14:43:22Z"), valid_until: "2024-06-25", status: "draft" }, { id: 173, customer_id: 14, quote_number: "Q-161973", group_discount_pct: 12, issued_at: new Date("2024-07-12T10:45:03Z"), valid_until: "2024-08-11", status: "accepted" }, { id: 174, customer_id: 68, quote_number: "Q-655314", group_discount_pct: 0, issued_at: new Date("2024-07-06T13:20:18Z"), valid_until: "2024-07-17", status: "accepted" }, { id: 175, customer_id: 2, quote_number: "Q-331981", group_discount_pct: 4, issued_at: new Date("2024-05-01T13:34:20Z"), valid_until: "2024-05-11", status: "declined" }, { id: 176, customer_id: 11, quote_number: "Q-061494", group_discount_pct: 4, issued_at: new Date("2024-07-07T09:49:49Z"), valid_until: "2024-07-18", status: "accepted" }, { id: 177, customer_id: 98, quote_number: "Q-514523", group_discount_pct: 12, issued_at: new Date("2024-04-21T09:36:05Z"), valid_until: "2024-05-12", status: "accepted" }, { id: 178, customer_id: 49, quote_number: "Q-830396", group_discount_pct: 0, issued_at: new Date("2024-06-12T08:42:39Z"), valid_until: "2024-06-17", status: "accepted" }, { id: 179, customer_id: 94, quote_number: "Q-223909", group_discount_pct: 4, issued_at: new Date("2024-06-29T12:46:42Z"), valid_until: "2024-07-04", status: "expired" }, { id: 180, customer_id: 118, quote_number: "Q-656088", group_discount_pct: 0, issued_at: new Date("2024-08-15T07:10:49Z"), valid_until: "2024-08-17", status: "expired" }, { id: 181, customer_id: 34, quote_number: "Q-527201", group_discount_pct: 0, issued_at: new Date("2024-08-12T16:36:23Z"), valid_until: "2024-08-26", status: "accepted" }, { id: 182, customer_id: 99, quote_number: "Q-346366", group_discount_pct: 0, issued_at: new Date("2024-04-12T16:07:10Z"), valid_until: "2024-05-07", status: "accepted" }, { id: 183, customer_id: 15, quote_number: "Q-990587", group_discount_pct: 4, issued_at: new Date("2024-04-17T11:48:45Z"), valid_until: "2024-05-04", status: "sent" }, { id: 184, customer_id: 73, quote_number: "Q-028927", group_discount_pct: 16, issued_at: new Date("2024-05-23T15:42:48Z"), valid_until: "2024-06-04", status: "accepted" }, { id: 185, customer_id: 85, quote_number: "Q-567424", group_discount_pct: 16, issued_at: new Date("2024-03-12T14:55:36Z"), valid_until: "2024-03-31", status: "accepted" }, { id: 186, customer_id: 104, quote_number: "Q-807867", group_discount_pct: 0, issued_at: new Date("2024-07-13T10:20:38Z"), valid_until: "2024-07-18", status: "expired" }, { id: 187, customer_id: 93, quote_number: "Q-542112", group_discount_pct: 0, issued_at: new Date("2024-05-16T15:09:35Z"), valid_until: "2024-05-23", status: "expired" }, { id: 188, customer_id: 94, quote_number: "Q-761265", group_discount_pct: 4, issued_at: new Date("2024-05-16T20:43:20Z"), valid_until: "2024-06-12", status: "declined" }, { id: 189, customer_id: 111, quote_number: "Q-501311", group_discount_pct: 0, issued_at: new Date("2024-06-28T15:06:07Z"), valid_until: "2024-07-10", status: "expired" }, ], }); await prisma.quote_lines.createMany({ data: [ { id: 1, quote_id: 144, line_no: 1, coffee_id: 19, quantity_kg: 28, list_price: "26.59", list_value: "744.52", group_discount_pct: 4 }, { id: 2, quote_id: 155, line_no: 1, coffee_id: 13, quantity_kg: 164, list_price: "17.60", list_value: "2886.40", group_discount_pct: 0 }, { id: 3, quote_id: 18, line_no: 1, coffee_id: 2, quantity_kg: 7, list_price: "22.05", list_value: "154.35", group_discount_pct: 0 }, { id: 4, quote_id: 5, line_no: 1, coffee_id: 8, quantity_kg: 11, list_price: "32.43", list_value: "356.73", group_discount_pct: 8 }, { id: 5, quote_id: 26, line_no: 1, coffee_id: 9, quantity_kg: 298, list_price: "20.17", list_value: "6010.66", group_discount_pct: 0 }, { id: 6, quote_id: 14, line_no: 1, coffee_id: 5, quantity_kg: 230, list_price: "14.17", list_value: "3259.10", group_discount_pct: 0 }, { id: 7, quote_id: 96, line_no: 1, coffee_id: 6, quantity_kg: 5, list_price: "14.35", list_value: "71.75", group_discount_pct: 0 }, { id: 8, quote_id: 189, line_no: 1, coffee_id: 25, quantity_kg: 133, list_price: "15.43", list_value: "2052.19", group_discount_pct: 0 }, { id: 9, quote_id: 17, line_no: 1, coffee_id: 2, quantity_kg: 21, list_price: "22.05", list_value: "463.05", group_discount_pct: 0 }, { id: 10, quote_id: 124, line_no: 1, coffee_id: 2, quantity_kg: 26, list_price: "22.05", list_value: "573.30", group_discount_pct: 0 }, { id: 11, quote_id: 177, line_no: 1, coffee_id: 20, quantity_kg: 97, list_price: "37.02", list_value: "3590.94", group_discount_pct: 12 }, { id: 12, quote_id: 140, line_no: 1, coffee_id: 17, quantity_kg: 40, list_price: "16.34", list_value: "653.60", group_discount_pct: 0 }, { id: 13, quote_id: 179, line_no: 1, coffee_id: 16, quantity_kg: 96, list_price: "14.43", list_value: "1385.28", group_discount_pct: 4 }, { id: 14, quote_id: 15, line_no: 1, coffee_id: 5, quantity_kg: 142, list_price: "14.17", list_value: "2012.14", group_discount_pct: 0 }, { id: 15, quote_id: 187, line_no: 1, coffee_id: 24, quantity_kg: 54, list_price: "27.43", list_value: "1481.22", group_discount_pct: 0 }, { id: 16, quote_id: 162, line_no: 1, coffee_id: 28, quantity_kg: 132, list_price: "24.84", list_value: "3278.88", group_discount_pct: 16 }, { id: 17, quote_id: 176, line_no: 1, coffee_id: 3, quantity_kg: 238, list_price: "30.33", list_value: "7218.54", group_discount_pct: 4 }, { id: 18, quote_id: 145, line_no: 1, coffee_id: 24, quantity_kg: 194, list_price: "27.43", list_value: "5321.42", group_discount_pct: 0 }, { id: 19, quote_id: 57, line_no: 1, coffee_id: 23, quantity_kg: 5, list_price: "14.47", list_value: "72.35", group_discount_pct: 12 }, { id: 20, quote_id: 107, line_no: 1, coffee_id: 5, quantity_kg: 98, list_price: "14.17", list_value: "1388.66", group_discount_pct: 16 }, { id: 21, quote_id: 9, line_no: 1, coffee_id: 13, quantity_kg: 84, list_price: "17.60", list_value: "1478.40", group_discount_pct: 0 }, { id: 22, quote_id: 132, line_no: 1, coffee_id: 8, quantity_kg: 48, list_price: "32.43", list_value: "1556.64", group_discount_pct: 0 }, { id: 23, quote_id: 43, line_no: 1, coffee_id: 8, quantity_kg: 195, list_price: "32.43", list_value: "6323.85", group_discount_pct: 12 }, { id: 24, quote_id: 32, line_no: 1, coffee_id: 17, quantity_kg: 202, list_price: "16.34", list_value: "3300.68", group_discount_pct: 12 }, { id: 25, quote_id: 91, line_no: 1, coffee_id: 14, quantity_kg: 73, list_price: "14.02", list_value: "1023.46", group_discount_pct: 0 }, { id: 26, quote_id: 151, line_no: 1, coffee_id: 27, quantity_kg: 6, list_price: "36.40", list_value: "218.40", group_discount_pct: 16 }, { id: 27, quote_id: 81, line_no: 1, coffee_id: 22, quantity_kg: 107, list_price: "21.46", list_value: "2296.22", group_discount_pct: 8 }, { id: 28, quote_id: 152, line_no: 1, coffee_id: 25, quantity_kg: 76, list_price: "15.43", list_value: "1172.68", group_discount_pct: 12 }, { id: 29, quote_id: 184, line_no: 1, coffee_id: 27, quantity_kg: 57, list_price: "36.40", list_value: "2074.80", group_discount_pct: 16 }, { id: 30, quote_id: 92, line_no: 1, coffee_id: 10, quantity_kg: 88, list_price: "30.58", list_value: "2691.04", group_discount_pct: 12 }, { id: 31, quote_id: 133, line_no: 1, coffee_id: 11, quantity_kg: 54, list_price: "14.13", list_value: "763.02", group_discount_pct: 0 }, { id: 32, quote_id: 62, line_no: 1, coffee_id: 11, quantity_kg: 181, list_price: "14.13", list_value: "2557.53", group_discount_pct: 4 }, { id: 33, quote_id: 66, line_no: 1, coffee_id: 17, quantity_kg: 35, list_price: "16.34", list_value: "571.90", group_discount_pct: 4 }, { id: 34, quote_id: 189, line_no: 2, coffee_id: 27, quantity_kg: 197, list_price: "36.40", list_value: "7170.80", group_discount_pct: 0 }, { id: 35, quote_id: 24, line_no: 1, coffee_id: 24, quantity_kg: 39, list_price: "27.43", list_value: "1069.77", group_discount_pct: 4 }, { id: 36, quote_id: 114, line_no: 1, coffee_id: 12, quantity_kg: 5, list_price: "14.14", list_value: "70.70", group_discount_pct: 0 }, { id: 37, quote_id: 178, line_no: 1, coffee_id: 23, quantity_kg: 56, list_price: "14.47", list_value: "810.32", group_discount_pct: 0 }, { id: 38, quote_id: 30, line_no: 1, coffee_id: 21, quantity_kg: 28, list_price: "34.56", list_value: "967.68", group_discount_pct: 4 }, { id: 39, quote_id: 126, line_no: 1, coffee_id: 23, quantity_kg: 184, list_price: "14.47", list_value: "2662.48", group_discount_pct: 16 }, { id: 40, quote_id: 33, line_no: 1, coffee_id: 15, quantity_kg: 12, list_price: "14.16", list_value: "169.92", group_discount_pct: 8 }, { id: 41, quote_id: 139, line_no: 1, coffee_id: 18, quantity_kg: 59, list_price: "18.13", list_value: "1069.67", group_discount_pct: 0 }, { id: 42, quote_id: 100, line_no: 1, coffee_id: 11, quantity_kg: 234, list_price: "14.13", list_value: "3306.42", group_discount_pct: 0 }, { id: 43, quote_id: 49, line_no: 1, coffee_id: 26, quantity_kg: 212, list_price: "23.54", list_value: "4990.48", group_discount_pct: 4 }, { id: 44, quote_id: 121, line_no: 1, coffee_id: 13, quantity_kg: 19, list_price: "17.60", list_value: "334.40", group_discount_pct: 8 }, { id: 45, quote_id: 41, line_no: 1, coffee_id: 15, quantity_kg: 82, list_price: "14.16", list_value: "1161.12", group_discount_pct: 0 }, { id: 46, quote_id: 90, line_no: 1, coffee_id: 24, quantity_kg: 9, list_price: "27.43", list_value: "246.87", group_discount_pct: 0 }, { id: 47, quote_id: 79, line_no: 1, coffee_id: 1, quantity_kg: 122, list_price: "23.50", list_value: "2867.00", group_discount_pct: 0 }, { id: 48, quote_id: 33, line_no: 2, coffee_id: 29, quantity_kg: 24, list_price: "22.75", list_value: "546.00", group_discount_pct: 8 }, { id: 49, quote_id: 162, line_no: 2, coffee_id: 20, quantity_kg: 66, list_price: "37.02", list_value: "2443.32", group_discount_pct: 16 }, { id: 50, quote_id: 164, line_no: 1, coffee_id: 28, quantity_kg: 28, list_price: "24.84", list_value: "695.52", group_discount_pct: 12 }, { id: 51, quote_id: 173, line_no: 1, coffee_id: 26, quantity_kg: 49, list_price: "23.54", list_value: "1153.46", group_discount_pct: 12 }, { id: 52, quote_id: 65, line_no: 1, coffee_id: 19, quantity_kg: 9, list_price: "26.59", list_value: "239.31", group_discount_pct: 0 }, { id: 53, quote_id: 77, line_no: 1, coffee_id: 22, quantity_kg: 68, list_price: "21.46", list_value: "1459.28", group_discount_pct: 8 }, { id: 54, quote_id: 34, line_no: 1, coffee_id: 13, quantity_kg: 6, list_price: "17.60", list_value: "105.60", group_discount_pct: 0 }, { id: 55, quote_id: 157, line_no: 1, coffee_id: 11, quantity_kg: 256, list_price: "14.13", list_value: "3617.28", group_discount_pct: 16 }, { id: 56, quote_id: 120, line_no: 1, coffee_id: 3, quantity_kg: 15, list_price: "30.33", list_value: "454.95", group_discount_pct: 0 }, { id: 57, quote_id: 84, line_no: 1, coffee_id: 12, quantity_kg: 64, list_price: "14.14", list_value: "904.96", group_discount_pct: 0 }, { id: 58, quote_id: 141, line_no: 1, coffee_id: 17, quantity_kg: 6, list_price: "16.34", list_value: "98.04", group_discount_pct: 0 }, { id: 59, quote_id: 122, line_no: 1, coffee_id: 3, quantity_kg: 282, list_price: "30.33", list_value: "8553.06", group_discount_pct: 12 }, { id: 60, quote_id: 179, line_no: 2, coffee_id: 12, quantity_kg: 118, list_price: "14.14", list_value: "1668.52", group_discount_pct: 4 }, { id: 61, quote_id: 186, line_no: 1, coffee_id: 16, quantity_kg: 180, list_price: "14.43", list_value: "2597.40", group_discount_pct: 0 }, { id: 62, quote_id: 26, line_no: 2, coffee_id: 22, quantity_kg: 11, list_price: "21.46", list_value: "236.06", group_discount_pct: 0 }, { id: 63, quote_id: 85, line_no: 1, coffee_id: 13, quantity_kg: 233, list_price: "17.60", list_value: "4100.80", group_discount_pct: 4 }, { id: 64, quote_id: 9, line_no: 2, coffee_id: 22, quantity_kg: 17, list_price: "21.46", list_value: "364.82", group_discount_pct: 0 }, { id: 65, quote_id: 156, line_no: 1, coffee_id: 26, quantity_kg: 82, list_price: "23.54", list_value: "1930.28", group_discount_pct: 12 }, { id: 66, quote_id: 110, line_no: 1, coffee_id: 11, quantity_kg: 5, list_price: "14.13", list_value: "70.65", group_discount_pct: 8 }, { id: 67, quote_id: 147, line_no: 1, coffee_id: 27, quantity_kg: 6, list_price: "36.40", list_value: "218.40", group_discount_pct: 8 }, { id: 68, quote_id: 186, line_no: 2, coffee_id: 5, quantity_kg: 40, list_price: "14.17", list_value: "566.80", group_discount_pct: 0 }, { id: 69, quote_id: 55, line_no: 1, coffee_id: 2, quantity_kg: 13, list_price: "22.05", list_value: "286.65", group_discount_pct: 4 }, { id: 70, quote_id: 48, line_no: 1, coffee_id: 16, quantity_kg: 6, list_price: "14.43", list_value: "86.58", group_discount_pct: 4 }, { id: 71, quote_id: 136, line_no: 1, coffee_id: 7, quantity_kg: 256, list_price: "26.72", list_value: "6840.32", group_discount_pct: 0 }, { id: 72, quote_id: 179, line_no: 3, coffee_id: 16, quantity_kg: 5, list_price: "14.43", list_value: "72.15", group_discount_pct: 4 }, { id: 73, quote_id: 129, line_no: 1, coffee_id: 4, quantity_kg: 114, list_price: "14.35", list_value: "1635.90", group_discount_pct: 4 }, { id: 74, quote_id: 20, line_no: 1, coffee_id: 8, quantity_kg: 113, list_price: "32.43", list_value: "3664.59", group_discount_pct: 0 }, { id: 75, quote_id: 58, line_no: 1, coffee_id: 25, quantity_kg: 184, list_price: "15.43", list_value: "2839.12", group_discount_pct: 0 }, { id: 76, quote_id: 51, line_no: 1, coffee_id: 28, quantity_kg: 77, list_price: "24.84", list_value: "1912.68", group_discount_pct: 0 }, { id: 77, quote_id: 15, line_no: 2, coffee_id: 9, quantity_kg: 255, list_price: "20.17", list_value: "5143.35", group_discount_pct: 0 }, { id: 78, quote_id: 155, line_no: 2, coffee_id: 29, quantity_kg: 5, list_price: "22.75", list_value: "113.75", group_discount_pct: 0 }, { id: 79, quote_id: 60, line_no: 1, coffee_id: 12, quantity_kg: 193, list_price: "14.14", list_value: "2729.02", group_discount_pct: 0 }, { id: 80, quote_id: 132, line_no: 2, coffee_id: 19, quantity_kg: 216, list_price: "26.59", list_value: "5743.44", group_discount_pct: 0 }, { id: 81, quote_id: 98, line_no: 1, coffee_id: 3, quantity_kg: 86, list_price: "30.33", list_value: "2608.38", group_discount_pct: 0 }, { id: 82, quote_id: 127, line_no: 1, coffee_id: 9, quantity_kg: 28, list_price: "20.17", list_value: "564.76", group_discount_pct: 4 }, { id: 83, quote_id: 88, line_no: 1, coffee_id: 24, quantity_kg: 5, list_price: "27.43", list_value: "137.15", group_discount_pct: 16 }, { id: 84, quote_id: 103, line_no: 1, coffee_id: 27, quantity_kg: 32, list_price: "36.40", list_value: "1164.80", group_discount_pct: 4 }, { id: 85, quote_id: 139, line_no: 2, coffee_id: 23, quantity_kg: 60, list_price: "14.47", list_value: "868.20", group_discount_pct: 0 }, { id: 86, quote_id: 23, line_no: 1, coffee_id: 10, quantity_kg: 125, list_price: "30.58", list_value: "3822.50", group_discount_pct: 4 }, { id: 87, quote_id: 7, line_no: 1, coffee_id: 22, quantity_kg: 81, list_price: "21.46", list_value: "1738.26", group_discount_pct: 12 }, { id: 88, quote_id: 130, line_no: 1, coffee_id: 21, quantity_kg: 15, list_price: "34.56", list_value: "518.40", group_discount_pct: 0 }, { id: 89, quote_id: 89, line_no: 1, coffee_id: 23, quantity_kg: 45, list_price: "14.47", list_value: "651.15", group_discount_pct: 0 }, { id: 90, quote_id: 21, line_no: 1, coffee_id: 11, quantity_kg: 253, list_price: "14.13", list_value: "3574.89", group_discount_pct: 0 }, { id: 91, quote_id: 158, line_no: 1, coffee_id: 16, quantity_kg: 6, list_price: "14.43", list_value: "86.58", group_discount_pct: 0 }, { id: 92, quote_id: 138, line_no: 1, coffee_id: 8, quantity_kg: 162, list_price: "32.43", list_value: "5253.66", group_discount_pct: 4 }, { id: 93, quote_id: 125, line_no: 1, coffee_id: 24, quantity_kg: 116, list_price: "27.43", list_value: "3181.88", group_discount_pct: 0 }, { id: 94, quote_id: 139, line_no: 3, coffee_id: 5, quantity_kg: 47, list_price: "14.17", list_value: "665.99", group_discount_pct: 0 }, { id: 95, quote_id: 111, line_no: 1, coffee_id: 4, quantity_kg: 31, list_price: "14.35", list_value: "444.85", group_discount_pct: 12 }, { id: 96, quote_id: 30, line_no: 2, coffee_id: 30, quantity_kg: 11, list_price: "14.01", list_value: "154.11", group_discount_pct: 4 }, { id: 97, quote_id: 130, line_no: 2, coffee_id: 30, quantity_kg: 164, list_price: "14.01", list_value: "2297.64", group_discount_pct: 0 }, { id: 98, quote_id: 124, line_no: 2, coffee_id: 29, quantity_kg: 9, list_price: "22.75", list_value: "204.75", group_discount_pct: 0 }, { id: 99, quote_id: 56, line_no: 1, coffee_id: 9, quantity_kg: 186, list_price: "20.17", list_value: "3751.62", group_discount_pct: 4 }, { id: 100, quote_id: 87, line_no: 1, coffee_id: 16, quantity_kg: 247, list_price: "14.43", list_value: "3564.21", group_discount_pct: 0 }, { id: 101, quote_id: 186, line_no: 3, coffee_id: 30, quantity_kg: 280, list_price: "14.01", list_value: "3922.80", group_discount_pct: 0 }, { id: 102, quote_id: 9, line_no: 3, coffee_id: 2, quantity_kg: 38, list_price: "22.05", list_value: "837.90", group_discount_pct: 0 }, { id: 103, quote_id: 106, line_no: 1, coffee_id: 2, quantity_kg: 107, list_price: "22.05", list_value: "2359.35", group_discount_pct: 0 }, { id: 104, quote_id: 1, line_no: 1, coffee_id: 7, quantity_kg: 9, list_price: "26.72", list_value: "240.48", group_discount_pct: 4 }, { id: 105, quote_id: 176, line_no: 2, coffee_id: 18, quantity_kg: 5, list_price: "18.13", list_value: "90.65", group_discount_pct: 4 }, { id: 106, quote_id: 85, line_no: 2, coffee_id: 12, quantity_kg: 102, list_price: "14.14", list_value: "1442.28", group_discount_pct: 4 }, { id: 107, quote_id: 27, line_no: 1, coffee_id: 13, quantity_kg: 243, list_price: "17.60", list_value: "4276.80", group_discount_pct: 4 }, { id: 108, quote_id: 172, line_no: 1, coffee_id: 2, quantity_kg: 101, list_price: "22.05", list_value: "2227.05", group_discount_pct: 0 }, { id: 109, quote_id: 80, line_no: 1, coffee_id: 4, quantity_kg: 55, list_price: "14.35", list_value: "789.25", group_discount_pct: 0 }, { id: 110, quote_id: 177, line_no: 2, coffee_id: 14, quantity_kg: 224, list_price: "14.02", list_value: "3140.48", group_discount_pct: 12 }, { id: 111, quote_id: 46, line_no: 1, coffee_id: 16, quantity_kg: 8, list_price: "14.43", list_value: "115.44", group_discount_pct: 12 }, { id: 112, quote_id: 142, line_no: 1, coffee_id: 1, quantity_kg: 23, list_price: "23.50", list_value: "540.50", group_discount_pct: 16 }, { id: 113, quote_id: 3, line_no: 1, coffee_id: 8, quantity_kg: 5, list_price: "32.43", list_value: "162.15", group_discount_pct: 12 }, { id: 114, quote_id: 130, line_no: 3, coffee_id: 27, quantity_kg: 55, list_price: "36.40", list_value: "2002.00", group_discount_pct: 0 }, { id: 115, quote_id: 169, line_no: 1, coffee_id: 26, quantity_kg: 75, list_price: "23.54", list_value: "1765.50", group_discount_pct: 16 }, { id: 116, quote_id: 40, line_no: 1, coffee_id: 6, quantity_kg: 132, list_price: "14.35", list_value: "1894.20", group_discount_pct: 0 }, { id: 117, quote_id: 184, line_no: 2, coffee_id: 26, quantity_kg: 183, list_price: "23.54", list_value: "4307.82", group_discount_pct: 16 }, { id: 118, quote_id: 45, line_no: 1, coffee_id: 27, quantity_kg: 119, list_price: "36.40", list_value: "4331.60", group_discount_pct: 16 }, { id: 119, quote_id: 80, line_no: 2, coffee_id: 20, quantity_kg: 240, list_price: "37.02", list_value: "8884.80", group_discount_pct: 0 }, { id: 120, quote_id: 28, line_no: 1, coffee_id: 15, quantity_kg: 85, list_price: "14.16", list_value: "1203.60", group_discount_pct: 0 }, { id: 121, quote_id: 160, line_no: 1, coffee_id: 15, quantity_kg: 77, list_price: "14.16", list_value: "1090.32", group_discount_pct: 0 }, { id: 122, quote_id: 117, line_no: 1, coffee_id: 11, quantity_kg: 79, list_price: "14.13", list_value: "1116.27", group_discount_pct: 0 }, { id: 123, quote_id: 55, line_no: 2, coffee_id: 7, quantity_kg: 5, list_price: "26.72", list_value: "133.60", group_discount_pct: 4 }, { id: 124, quote_id: 115, line_no: 1, coffee_id: 24, quantity_kg: 27, list_price: "27.43", list_value: "740.61", group_discount_pct: 0 }, { id: 125, quote_id: 181, line_no: 1, coffee_id: 23, quantity_kg: 66, list_price: "14.47", list_value: "955.02", group_discount_pct: 0 }, { id: 126, quote_id: 156, line_no: 2, coffee_id: 24, quantity_kg: 47, list_price: "27.43", list_value: "1289.21", group_discount_pct: 12 }, { id: 127, quote_id: 76, line_no: 1, coffee_id: 26, quantity_kg: 64, list_price: "23.54", list_value: "1506.56", group_discount_pct: 0 }, { id: 128, quote_id: 175, line_no: 1, coffee_id: 17, quantity_kg: 239, list_price: "16.34", list_value: "3905.26", group_discount_pct: 4 }, { id: 129, quote_id: 170, line_no: 1, coffee_id: 10, quantity_kg: 40, list_price: "30.58", list_value: "1223.20", group_discount_pct: 8 }, { id: 130, quote_id: 136, line_no: 2, coffee_id: 28, quantity_kg: 7, list_price: "24.84", list_value: "173.88", group_discount_pct: 0 }, { id: 131, quote_id: 79, line_no: 2, coffee_id: 11, quantity_kg: 129, list_price: "14.13", list_value: "1822.77", group_discount_pct: 0 }, { id: 132, quote_id: 87, line_no: 2, coffee_id: 18, quantity_kg: 222, list_price: "18.13", list_value: "4024.86", group_discount_pct: 0 }, { id: 133, quote_id: 171, line_no: 1, coffee_id: 1, quantity_kg: 156, list_price: "23.50", list_value: "3666.00", group_discount_pct: 0 }, { id: 134, quote_id: 179, line_no: 4, coffee_id: 6, quantity_kg: 157, list_price: "14.35", list_value: "2252.95", group_discount_pct: 4 }, { id: 135, quote_id: 168, line_no: 1, coffee_id: 19, quantity_kg: 57, list_price: "26.59", list_value: "1515.63", group_discount_pct: 0 }, { id: 136, quote_id: 147, line_no: 2, coffee_id: 30, quantity_kg: 7, list_price: "14.01", list_value: "98.07", group_discount_pct: 8 }, { id: 137, quote_id: 85, line_no: 3, coffee_id: 11, quantity_kg: 106, list_price: "14.13", list_value: "1497.78", group_discount_pct: 4 }, { id: 138, quote_id: 68, line_no: 1, coffee_id: 1, quantity_kg: 225, list_price: "23.50", list_value: "5287.50", group_discount_pct: 0 }, { id: 139, quote_id: 182, line_no: 1, coffee_id: 5, quantity_kg: 168, list_price: "14.17", list_value: "2380.56", group_discount_pct: 0 }, { id: 140, quote_id: 94, line_no: 1, coffee_id: 8, quantity_kg: 70, list_price: "32.43", list_value: "2270.10", group_discount_pct: 12 }, { id: 141, quote_id: 52, line_no: 1, coffee_id: 3, quantity_kg: 196, list_price: "30.33", list_value: "5944.68", group_discount_pct: 4 }, { id: 142, quote_id: 177, line_no: 3, coffee_id: 27, quantity_kg: 5, list_price: "36.40", list_value: "182.00", group_discount_pct: 12 }, { id: 143, quote_id: 59, line_no: 1, coffee_id: 6, quantity_kg: 109, list_price: "14.35", list_value: "1564.15", group_discount_pct: 8 }, { id: 144, quote_id: 41, line_no: 2, coffee_id: 6, quantity_kg: 36, list_price: "14.35", list_value: "516.60", group_discount_pct: 0 }, { id: 145, quote_id: 10, line_no: 1, coffee_id: 17, quantity_kg: 239, list_price: "16.34", list_value: "3905.26", group_discount_pct: 0 }, { id: 146, quote_id: 44, line_no: 1, coffee_id: 17, quantity_kg: 109, list_price: "16.34", list_value: "1781.06", group_discount_pct: 0 }, { id: 147, quote_id: 61, line_no: 1, coffee_id: 9, quantity_kg: 291, list_price: "20.17", list_value: "5869.47", group_discount_pct: 0 }, { id: 148, quote_id: 183, line_no: 1, coffee_id: 11, quantity_kg: 152, list_price: "14.13", list_value: "2147.76", group_discount_pct: 4 }, { id: 149, quote_id: 41, line_no: 3, coffee_id: 1, quantity_kg: 5, list_price: "23.50", list_value: "117.50", group_discount_pct: 0 }, { id: 150, quote_id: 59, line_no: 2, coffee_id: 12, quantity_kg: 6, list_price: "14.14", list_value: "84.84", group_discount_pct: 8 }, { id: 151, quote_id: 101, line_no: 1, coffee_id: 3, quantity_kg: 80, list_price: "30.33", list_value: "2426.40", group_discount_pct: 8 }, { id: 152, quote_id: 72, line_no: 1, coffee_id: 30, quantity_kg: 5, list_price: "14.01", list_value: "70.05", group_discount_pct: 0 }, { id: 153, quote_id: 147, line_no: 3, coffee_id: 25, quantity_kg: 115, list_price: "15.43", list_value: "1774.45", group_discount_pct: 8 }, { id: 154, quote_id: 92, line_no: 2, coffee_id: 6, quantity_kg: 33, list_price: "14.35", list_value: "473.55", group_discount_pct: 12 }, { id: 155, quote_id: 19, line_no: 1, coffee_id: 25, quantity_kg: 128, list_price: "15.43", list_value: "1975.04", group_discount_pct: 16 }, { id: 156, quote_id: 177, line_no: 4, coffee_id: 27, quantity_kg: 6, list_price: "36.40", list_value: "218.40", group_discount_pct: 12 }, { id: 157, quote_id: 5, line_no: 2, coffee_id: 3, quantity_kg: 145, list_price: "30.33", list_value: "4397.85", group_discount_pct: 8 }, { id: 158, quote_id: 74, line_no: 1, coffee_id: 13, quantity_kg: 12, list_price: "17.60", list_value: "211.20", group_discount_pct: 0 }, { id: 159, quote_id: 85, line_no: 4, coffee_id: 21, quantity_kg: 31, list_price: "34.56", list_value: "1071.36", group_discount_pct: 4 }, { id: 160, quote_id: 71, line_no: 1, coffee_id: 22, quantity_kg: 20, list_price: "21.46", list_value: "429.20", group_discount_pct: 4 }, { id: 161, quote_id: 102, line_no: 1, coffee_id: 25, quantity_kg: 32, list_price: "15.43", list_value: "493.76", group_discount_pct: 16 }, { id: 162, quote_id: 112, line_no: 1, coffee_id: 6, quantity_kg: 5, list_price: "14.35", list_value: "71.75", group_discount_pct: 0 }, { id: 163, quote_id: 99, line_no: 1, coffee_id: 3, quantity_kg: 88, list_price: "30.33", list_value: "2669.04", group_discount_pct: 0 }, { id: 164, quote_id: 94, line_no: 2, coffee_id: 7, quantity_kg: 6, list_price: "26.72", list_value: "160.32", group_discount_pct: 12 }, { id: 165, quote_id: 166, line_no: 1, coffee_id: 9, quantity_kg: 17, list_price: "20.17", list_value: "342.89", group_discount_pct: 8 }, { id: 166, quote_id: 159, line_no: 1, coffee_id: 23, quantity_kg: 221, list_price: "14.47", list_value: "3197.87", group_discount_pct: 0 }, { id: 167, quote_id: 83, line_no: 1, coffee_id: 2, quantity_kg: 48, list_price: "22.05", list_value: "1058.40", group_discount_pct: 12 }, { id: 168, quote_id: 171, line_no: 2, coffee_id: 21, quantity_kg: 296, list_price: "34.56", list_value: "10229.76", group_discount_pct: 0 }, { id: 169, quote_id: 76, line_no: 2, coffee_id: 28, quantity_kg: 58, list_price: "24.84", list_value: "1440.72", group_discount_pct: 0 }, { id: 170, quote_id: 78, line_no: 1, coffee_id: 15, quantity_kg: 174, list_price: "14.16", list_value: "2463.84", group_discount_pct: 4 }, { id: 171, quote_id: 155, line_no: 3, coffee_id: 14, quantity_kg: 9, list_price: "14.02", list_value: "126.18", group_discount_pct: 0 }, { id: 172, quote_id: 61, line_no: 2, coffee_id: 24, quantity_kg: 56, list_price: "27.43", list_value: "1536.08", group_discount_pct: 0 }, { id: 173, quote_id: 57, line_no: 2, coffee_id: 12, quantity_kg: 20, list_price: "14.14", list_value: "282.80", group_discount_pct: 12 }, { id: 174, quote_id: 15, line_no: 3, coffee_id: 19, quantity_kg: 65, list_price: "26.59", list_value: "1728.35", group_discount_pct: 0 }, { id: 175, quote_id: 34, line_no: 2, coffee_id: 6, quantity_kg: 129, list_price: "14.35", list_value: "1851.15", group_discount_pct: 0 }, { id: 176, quote_id: 47, line_no: 1, coffee_id: 24, quantity_kg: 87, list_price: "27.43", list_value: "2386.41", group_discount_pct: 0 }, { id: 177, quote_id: 116, line_no: 1, coffee_id: 7, quantity_kg: 247, list_price: "26.72", list_value: "6599.84", group_discount_pct: 4 }, { id: 178, quote_id: 120, line_no: 2, coffee_id: 27, quantity_kg: 298, list_price: "36.40", list_value: "10847.20", group_discount_pct: 0 }, { id: 179, quote_id: 41, line_no: 4, coffee_id: 27, quantity_kg: 66, list_price: "36.40", list_value: "2402.40", group_discount_pct: 0 }, { id: 180, quote_id: 167, line_no: 1, coffee_id: 27, quantity_kg: 14, list_price: "36.40", list_value: "509.60", group_discount_pct: 0 }, { id: 181, quote_id: 50, line_no: 1, coffee_id: 16, quantity_kg: 6, list_price: "14.43", list_value: "86.58", group_discount_pct: 12 }, { id: 182, quote_id: 144, line_no: 2, coffee_id: 3, quantity_kg: 6, list_price: "30.33", list_value: "181.98", group_discount_pct: 4 }, { id: 183, quote_id: 29, line_no: 1, coffee_id: 12, quantity_kg: 269, list_price: "14.14", list_value: "3803.66", group_discount_pct: 0 }, { id: 184, quote_id: 103, line_no: 2, coffee_id: 10, quantity_kg: 26, list_price: "30.58", list_value: "795.08", group_discount_pct: 4 }, { id: 185, quote_id: 33, line_no: 3, coffee_id: 6, quantity_kg: 13, list_price: "14.35", list_value: "186.55", group_discount_pct: 8 }, { id: 186, quote_id: 112, line_no: 2, coffee_id: 21, quantity_kg: 260, list_price: "34.56", list_value: "8985.60", group_discount_pct: 0 }, { id: 187, quote_id: 139, line_no: 4, coffee_id: 7, quantity_kg: 223, list_price: "26.72", list_value: "5958.56", group_discount_pct: 0 }, { id: 188, quote_id: 60, line_no: 2, coffee_id: 6, quantity_kg: 150, list_price: "14.35", list_value: "2152.50", group_discount_pct: 0 }, { id: 189, quote_id: 41, line_no: 5, coffee_id: 28, quantity_kg: 17, list_price: "24.84", list_value: "422.28", group_discount_pct: 0 }, { id: 190, quote_id: 27, line_no: 2, coffee_id: 28, quantity_kg: 30, list_price: "24.84", list_value: "745.20", group_discount_pct: 4 }, { id: 191, quote_id: 29, line_no: 2, coffee_id: 16, quantity_kg: 42, list_price: "14.43", list_value: "606.06", group_discount_pct: 0 }, { id: 192, quote_id: 150, line_no: 1, coffee_id: 2, quantity_kg: 72, list_price: "22.05", list_value: "1587.60", group_discount_pct: 4 }, { id: 193, quote_id: 146, line_no: 1, coffee_id: 1, quantity_kg: 25, list_price: "23.50", list_value: "587.50", group_discount_pct: 0 }, { id: 194, quote_id: 160, line_no: 2, coffee_id: 5, quantity_kg: 146, list_price: "14.17", list_value: "2068.82", group_discount_pct: 0 }, { id: 195, quote_id: 74, line_no: 2, coffee_id: 7, quantity_kg: 120, list_price: "26.72", list_value: "3206.40", group_discount_pct: 0 }, { id: 196, quote_id: 145, line_no: 2, coffee_id: 11, quantity_kg: 38, list_price: "14.13", list_value: "536.94", group_discount_pct: 0 }, { id: 197, quote_id: 105, line_no: 1, coffee_id: 15, quantity_kg: 253, list_price: "14.16", list_value: "3582.48", group_discount_pct: 0 }, { id: 198, quote_id: 84, line_no: 2, coffee_id: 24, quantity_kg: 35, list_price: "27.43", list_value: "960.05", group_discount_pct: 0 }, { id: 199, quote_id: 160, line_no: 3, coffee_id: 27, quantity_kg: 12, list_price: "36.40", list_value: "436.80", group_discount_pct: 0 }, { id: 200, quote_id: 12, line_no: 1, coffee_id: 5, quantity_kg: 52, list_price: "14.17", list_value: "736.84", group_discount_pct: 12 }, { id: 201, quote_id: 87, line_no: 3, coffee_id: 13, quantity_kg: 264, list_price: "17.60", list_value: "4646.40", group_discount_pct: 0 }, { id: 202, quote_id: 128, line_no: 1, coffee_id: 5, quantity_kg: 15, list_price: "14.17", list_value: "212.55", group_discount_pct: 0 }, { id: 203, quote_id: 42, line_no: 1, coffee_id: 17, quantity_kg: 115, list_price: "16.34", list_value: "1879.10", group_discount_pct: 0 }, { id: 204, quote_id: 95, line_no: 1, coffee_id: 15, quantity_kg: 140, list_price: "14.16", list_value: "1982.40", group_discount_pct: 0 }, { id: 205, quote_id: 59, line_no: 3, coffee_id: 18, quantity_kg: 7, list_price: "18.13", list_value: "126.91", group_discount_pct: 8 }, { id: 206, quote_id: 136, line_no: 3, coffee_id: 22, quantity_kg: 284, list_price: "21.46", list_value: "6094.64", group_discount_pct: 0 }, { id: 207, quote_id: 30, line_no: 3, coffee_id: 29, quantity_kg: 43, list_price: "22.75", list_value: "978.25", group_discount_pct: 4 }, { id: 208, quote_id: 12, line_no: 2, coffee_id: 17, quantity_kg: 22, list_price: "16.34", list_value: "359.48", group_discount_pct: 12 }, { id: 209, quote_id: 184, line_no: 3, coffee_id: 11, quantity_kg: 5, list_price: "14.13", list_value: "70.65", group_discount_pct: 16 }, { id: 210, quote_id: 69, line_no: 1, coffee_id: 30, quantity_kg: 91, list_price: "14.01", list_value: "1274.91", group_discount_pct: 4 }, { id: 211, quote_id: 112, line_no: 3, coffee_id: 4, quantity_kg: 273, list_price: "14.35", list_value: "3917.55", group_discount_pct: 0 }, { id: 212, quote_id: 15, line_no: 4, coffee_id: 22, quantity_kg: 189, list_price: "21.46", list_value: "4055.94", group_discount_pct: 0 }, { id: 213, quote_id: 33, line_no: 4, coffee_id: 17, quantity_kg: 156, list_price: "16.34", list_value: "2549.04", group_discount_pct: 8 }, { id: 214, quote_id: 82, line_no: 1, coffee_id: 10, quantity_kg: 55, list_price: "30.58", list_value: "1681.90", group_discount_pct: 0 }, { id: 215, quote_id: 67, line_no: 1, coffee_id: 17, quantity_kg: 14, list_price: "16.34", list_value: "228.76", group_discount_pct: 0 }, { id: 216, quote_id: 107, line_no: 2, coffee_id: 8, quantity_kg: 18, list_price: "32.43", list_value: "583.74", group_discount_pct: 16 }, { id: 217, quote_id: 111, line_no: 2, coffee_id: 23, quantity_kg: 281, list_price: "14.47", list_value: "4066.07", group_discount_pct: 12 }, { id: 218, quote_id: 154, line_no: 1, coffee_id: 29, quantity_kg: 5, list_price: "22.75", list_value: "113.75", group_discount_pct: 4 }, { id: 219, quote_id: 166, line_no: 2, coffee_id: 21, quantity_kg: 191, list_price: "34.56", list_value: "6600.96", group_discount_pct: 8 }, { id: 220, quote_id: 156, line_no: 3, coffee_id: 30, quantity_kg: 205, list_price: "14.01", list_value: "2872.05", group_discount_pct: 12 }, { id: 221, quote_id: 97, line_no: 1, coffee_id: 16, quantity_kg: 8, list_price: "14.43", list_value: "115.44", group_discount_pct: 8 }, { id: 222, quote_id: 87, line_no: 4, coffee_id: 1, quantity_kg: 71, list_price: "23.50", list_value: "1668.50", group_discount_pct: 0 }, { id: 223, quote_id: 70, line_no: 1, coffee_id: 16, quantity_kg: 225, list_price: "14.43", list_value: "3246.75", group_discount_pct: 4 }, { id: 224, quote_id: 49, line_no: 2, coffee_id: 19, quantity_kg: 136, list_price: "26.59", list_value: "3616.24", group_discount_pct: 4 }, { id: 225, quote_id: 22, line_no: 1, coffee_id: 6, quantity_kg: 76, list_price: "14.35", list_value: "1090.60", group_discount_pct: 16 }, { id: 226, quote_id: 108, line_no: 1, coffee_id: 30, quantity_kg: 6, list_price: "14.01", list_value: "84.06", group_discount_pct: 8 }, { id: 227, quote_id: 27, line_no: 3, coffee_id: 15, quantity_kg: 117, list_price: "14.16", list_value: "1656.72", group_discount_pct: 4 }, { id: 228, quote_id: 47, line_no: 2, coffee_id: 14, quantity_kg: 236, list_price: "14.02", list_value: "3308.72", group_discount_pct: 0 }, { id: 229, quote_id: 60, line_no: 3, coffee_id: 18, quantity_kg: 133, list_price: "18.13", list_value: "2411.29", group_discount_pct: 0 }, { id: 230, quote_id: 89, line_no: 2, coffee_id: 17, quantity_kg: 126, list_price: "16.34", list_value: "2058.84", group_discount_pct: 0 }, { id: 231, quote_id: 150, line_no: 2, coffee_id: 26, quantity_kg: 114, list_price: "23.54", list_value: "2683.56", group_discount_pct: 4 }, { id: 232, quote_id: 5, line_no: 3, coffee_id: 28, quantity_kg: 14, list_price: "24.84", list_value: "347.76", group_discount_pct: 8 }, { id: 233, quote_id: 27, line_no: 4, coffee_id: 19, quantity_kg: 297, list_price: "26.59", list_value: "7897.23", group_discount_pct: 4 }, { id: 234, quote_id: 77, line_no: 2, coffee_id: 28, quantity_kg: 127, list_price: "24.84", list_value: "3154.68", group_discount_pct: 8 }, { id: 235, quote_id: 68, line_no: 2, coffee_id: 14, quantity_kg: 19, list_price: "14.02", list_value: "266.38", group_discount_pct: 0 }, { id: 236, quote_id: 162, line_no: 3, coffee_id: 23, quantity_kg: 20, list_price: "14.47", list_value: "289.40", group_discount_pct: 16 }, { id: 237, quote_id: 161, line_no: 1, coffee_id: 15, quantity_kg: 14, list_price: "14.16", list_value: "198.24", group_discount_pct: 16 }, { id: 238, quote_id: 109, line_no: 1, coffee_id: 11, quantity_kg: 10, list_price: "14.13", list_value: "141.30", group_discount_pct: 0 }, { id: 239, quote_id: 121, line_no: 2, coffee_id: 8, quantity_kg: 238, list_price: "32.43", list_value: "7718.34", group_discount_pct: 8 }, { id: 240, quote_id: 75, line_no: 1, coffee_id: 12, quantity_kg: 82, list_price: "14.14", list_value: "1159.48", group_discount_pct: 0 }, { id: 241, quote_id: 175, line_no: 2, coffee_id: 2, quantity_kg: 80, list_price: "22.05", list_value: "1764.00", group_discount_pct: 4 }, { id: 242, quote_id: 164, line_no: 2, coffee_id: 12, quantity_kg: 19, list_price: "14.14", list_value: "268.66", group_discount_pct: 12 }, { id: 243, quote_id: 189, line_no: 3, coffee_id: 27, quantity_kg: 103, list_price: "36.40", list_value: "3749.20", group_discount_pct: 0 }, { id: 244, quote_id: 182, line_no: 2, coffee_id: 24, quantity_kg: 61, list_price: "27.43", list_value: "1673.23", group_discount_pct: 0 }, { id: 245, quote_id: 33, line_no: 5, coffee_id: 17, quantity_kg: 60, list_price: "16.34", list_value: "980.40", group_discount_pct: 8 }, { id: 246, quote_id: 114, line_no: 2, coffee_id: 26, quantity_kg: 5, list_price: "23.54", list_value: "117.70", group_discount_pct: 0 }, { id: 247, quote_id: 93, line_no: 1, coffee_id: 12, quantity_kg: 162, list_price: "14.14", list_value: "2290.68", group_discount_pct: 8 }, { id: 248, quote_id: 37, line_no: 1, coffee_id: 22, quantity_kg: 5, list_price: "21.46", list_value: "107.30", group_discount_pct: 4 }, { id: 249, quote_id: 118, line_no: 1, coffee_id: 17, quantity_kg: 262, list_price: "16.34", list_value: "4281.08", group_discount_pct: 0 }, { id: 250, quote_id: 72, line_no: 2, coffee_id: 20, quantity_kg: 137, list_price: "37.02", list_value: "5071.74", group_discount_pct: 0 }, { id: 251, quote_id: 116, line_no: 2, coffee_id: 8, quantity_kg: 20, list_price: "32.43", list_value: "648.60", group_discount_pct: 4 }, { id: 252, quote_id: 189, line_no: 4, coffee_id: 26, quantity_kg: 208, list_price: "23.54", list_value: "4896.32", group_discount_pct: 0 }, { id: 253, quote_id: 35, line_no: 1, coffee_id: 24, quantity_kg: 99, list_price: "27.43", list_value: "2715.57", group_discount_pct: 12 }, { id: 254, quote_id: 180, line_no: 1, coffee_id: 25, quantity_kg: 7, list_price: "15.43", list_value: "108.01", group_discount_pct: 0 }, { id: 255, quote_id: 59, line_no: 4, coffee_id: 6, quantity_kg: 30, list_price: "14.35", list_value: "430.50", group_discount_pct: 8 }, { id: 256, quote_id: 31, line_no: 1, coffee_id: 28, quantity_kg: 15, list_price: "24.84", list_value: "372.60", group_discount_pct: 0 }, { id: 257, quote_id: 5, line_no: 4, coffee_id: 21, quantity_kg: 295, list_price: "34.56", list_value: "10195.20", group_discount_pct: 8 }, { id: 258, quote_id: 53, line_no: 1, coffee_id: 11, quantity_kg: 5, list_price: "14.13", list_value: "70.65", group_discount_pct: 16 }, { id: 259, quote_id: 188, line_no: 1, coffee_id: 17, quantity_kg: 8, list_price: "16.34", list_value: "130.72", group_discount_pct: 4 }, { id: 260, quote_id: 80, line_no: 3, coffee_id: 21, quantity_kg: 80, list_price: "34.56", list_value: "2764.80", group_discount_pct: 0 }, { id: 261, quote_id: 68, line_no: 3, coffee_id: 1, quantity_kg: 10, list_price: "23.50", list_value: "235.00", group_discount_pct: 0 }, { id: 262, quote_id: 44, line_no: 2, coffee_id: 2, quantity_kg: 8, list_price: "22.05", list_value: "176.40", group_discount_pct: 0 }, { id: 263, quote_id: 145, line_no: 3, coffee_id: 23, quantity_kg: 128, list_price: "14.47", list_value: "1852.16", group_discount_pct: 0 }, { id: 264, quote_id: 154, line_no: 2, coffee_id: 2, quantity_kg: 110, list_price: "22.05", list_value: "2425.50", group_discount_pct: 4 }, { id: 265, quote_id: 135, line_no: 1, coffee_id: 1, quantity_kg: 52, list_price: "23.50", list_value: "1222.00", group_discount_pct: 0 }, { id: 266, quote_id: 38, line_no: 1, coffee_id: 12, quantity_kg: 35, list_price: "14.14", list_value: "494.90", group_discount_pct: 16 }, { id: 267, quote_id: 8, line_no: 1, coffee_id: 2, quantity_kg: 139, list_price: "22.05", list_value: "3064.95", group_discount_pct: 0 }, { id: 268, quote_id: 12, line_no: 3, coffee_id: 2, quantity_kg: 23, list_price: "22.05", list_value: "507.15", group_discount_pct: 12 }, { id: 269, quote_id: 150, line_no: 3, coffee_id: 12, quantity_kg: 21, list_price: "14.14", list_value: "296.94", group_discount_pct: 4 }, { id: 270, quote_id: 36, line_no: 1, coffee_id: 24, quantity_kg: 127, list_price: "27.43", list_value: "3483.61", group_discount_pct: 4 }, { id: 271, quote_id: 86, line_no: 1, coffee_id: 8, quantity_kg: 287, list_price: "32.43", list_value: "9307.41", group_discount_pct: 0 }, { id: 272, quote_id: 109, line_no: 2, coffee_id: 11, quantity_kg: 14, list_price: "14.13", list_value: "197.82", group_discount_pct: 0 }, { id: 273, quote_id: 16, line_no: 1, coffee_id: 6, quantity_kg: 16, list_price: "14.35", list_value: "229.60", group_discount_pct: 0 }, { id: 274, quote_id: 6, line_no: 1, coffee_id: 28, quantity_kg: 212, list_price: "24.84", list_value: "5266.08", group_discount_pct: 0 }, { id: 275, quote_id: 158, line_no: 2, coffee_id: 12, quantity_kg: 35, list_price: "14.14", list_value: "494.90", group_discount_pct: 0 }, { id: 276, quote_id: 153, line_no: 1, coffee_id: 2, quantity_kg: 12, list_price: "22.05", list_value: "264.60", group_discount_pct: 0 }, { id: 277, quote_id: 123, line_no: 1, coffee_id: 22, quantity_kg: 26, list_price: "21.46", list_value: "557.96", group_discount_pct: 4 }, { id: 278, quote_id: 52, line_no: 2, coffee_id: 18, quantity_kg: 159, list_price: "18.13", list_value: "2882.67", group_discount_pct: 4 }, { id: 279, quote_id: 174, line_no: 1, coffee_id: 30, quantity_kg: 231, list_price: "14.01", list_value: "3236.31", group_discount_pct: 0 }, { id: 280, quote_id: 44, line_no: 3, coffee_id: 11, quantity_kg: 259, list_price: "14.13", list_value: "3659.67", group_discount_pct: 0 }, { id: 281, quote_id: 92, line_no: 3, coffee_id: 28, quantity_kg: 57, list_price: "24.84", list_value: "1415.88", group_discount_pct: 12 }, { id: 282, quote_id: 25, line_no: 1, coffee_id: 1, quantity_kg: 8, list_price: "23.50", list_value: "188.00", group_discount_pct: 4 }, { id: 283, quote_id: 30, line_no: 4, coffee_id: 24, quantity_kg: 292, list_price: "27.43", list_value: "8009.56", group_discount_pct: 4 }, { id: 284, quote_id: 183, line_no: 2, coffee_id: 26, quantity_kg: 6, list_price: "23.54", list_value: "141.24", group_discount_pct: 4 }, { id: 285, quote_id: 183, line_no: 3, coffee_id: 23, quantity_kg: 46, list_price: "14.47", list_value: "665.62", group_discount_pct: 4 }, { id: 286, quote_id: 68, line_no: 4, coffee_id: 25, quantity_kg: 12, list_price: "15.43", list_value: "185.16", group_discount_pct: 0 }, { id: 287, quote_id: 24, line_no: 2, coffee_id: 19, quantity_kg: 88, list_price: "26.59", list_value: "2339.92", group_discount_pct: 4 }, { id: 288, quote_id: 77, line_no: 3, coffee_id: 22, quantity_kg: 7, list_price: "21.46", list_value: "150.22", group_discount_pct: 8 }, { id: 289, quote_id: 158, line_no: 3, coffee_id: 3, quantity_kg: 173, list_price: "30.33", list_value: "5247.09", group_discount_pct: 0 }, { id: 290, quote_id: 122, line_no: 2, coffee_id: 2, quantity_kg: 30, list_price: "22.05", list_value: "661.50", group_discount_pct: 12 }, { id: 291, quote_id: 184, line_no: 4, coffee_id: 14, quantity_kg: 9, list_price: "14.02", list_value: "126.18", group_discount_pct: 16 }, { id: 292, quote_id: 146, line_no: 2, coffee_id: 23, quantity_kg: 20, list_price: "14.47", list_value: "289.40", group_discount_pct: 0 }, { id: 293, quote_id: 64, line_no: 1, coffee_id: 9, quantity_kg: 30, list_price: "20.17", list_value: "605.10", group_discount_pct: 0 }, { id: 294, quote_id: 104, line_no: 1, coffee_id: 28, quantity_kg: 105, list_price: "24.84", list_value: "2608.20", group_discount_pct: 0 }, { id: 295, quote_id: 156, line_no: 4, coffee_id: 11, quantity_kg: 61, list_price: "14.13", list_value: "861.93", group_discount_pct: 12 }, { id: 296, quote_id: 116, line_no: 3, coffee_id: 22, quantity_kg: 151, list_price: "21.46", list_value: "3240.46", group_discount_pct: 4 }, { id: 297, quote_id: 9, line_no: 4, coffee_id: 2, quantity_kg: 85, list_price: "22.05", list_value: "1874.25", group_discount_pct: 0 }, { id: 298, quote_id: 65, line_no: 2, coffee_id: 30, quantity_kg: 41, list_price: "14.01", list_value: "574.41", group_discount_pct: 0 }, { id: 299, quote_id: 122, line_no: 3, coffee_id: 16, quantity_kg: 249, list_price: "14.43", list_value: "3593.07", group_discount_pct: 12 }, { id: 300, quote_id: 20, line_no: 2, coffee_id: 24, quantity_kg: 281, list_price: "27.43", list_value: "7707.83", group_discount_pct: 0 }, { id: 301, quote_id: 13, line_no: 1, coffee_id: 27, quantity_kg: 291, list_price: "36.40", list_value: "10592.40", group_discount_pct: 0 }, { id: 302, quote_id: 146, line_no: 3, coffee_id: 1, quantity_kg: 6, list_price: "23.50", list_value: "141.00", group_discount_pct: 0 }, { id: 303, quote_id: 105, line_no: 2, coffee_id: 29, quantity_kg: 250, list_price: "22.75", list_value: "5687.50", group_discount_pct: 0 }, { id: 304, quote_id: 114, line_no: 3, coffee_id: 30, quantity_kg: 33, list_price: "14.01", list_value: "462.33", group_discount_pct: 0 }, { id: 305, quote_id: 179, line_no: 5, coffee_id: 13, quantity_kg: 240, list_price: "17.60", list_value: "4224.00", group_discount_pct: 4 }, { id: 306, quote_id: 150, line_no: 4, coffee_id: 6, quantity_kg: 20, list_price: "14.35", list_value: "287.00", group_discount_pct: 4 }, { id: 307, quote_id: 13, line_no: 2, coffee_id: 10, quantity_kg: 70, list_price: "30.58", list_value: "2140.60", group_discount_pct: 0 }, { id: 308, quote_id: 180, line_no: 2, coffee_id: 12, quantity_kg: 242, list_price: "14.14", list_value: "3421.88", group_discount_pct: 0 }, { id: 309, quote_id: 125, line_no: 2, coffee_id: 30, quantity_kg: 229, list_price: "14.01", list_value: "3208.29", group_discount_pct: 0 }, { id: 310, quote_id: 131, line_no: 1, coffee_id: 18, quantity_kg: 55, list_price: "18.13", list_value: "997.15", group_discount_pct: 12 }, { id: 311, quote_id: 79, line_no: 3, coffee_id: 8, quantity_kg: 30, list_price: "32.43", list_value: "972.90", group_discount_pct: 0 }, { id: 312, quote_id: 177, line_no: 5, coffee_id: 26, quantity_kg: 106, list_price: "23.54", list_value: "2495.24", group_discount_pct: 12 }, { id: 313, quote_id: 87, line_no: 5, coffee_id: 23, quantity_kg: 107, list_price: "14.47", list_value: "1548.29", group_discount_pct: 0 }, { id: 314, quote_id: 63, line_no: 1, coffee_id: 7, quantity_kg: 233, list_price: "26.72", list_value: "6225.76", group_discount_pct: 8 }, { id: 315, quote_id: 95, line_no: 2, coffee_id: 10, quantity_kg: 73, list_price: "30.58", list_value: "2232.34", group_discount_pct: 0 }, { id: 316, quote_id: 145, line_no: 4, coffee_id: 15, quantity_kg: 26, list_price: "14.16", list_value: "368.16", group_discount_pct: 0 }, { id: 317, quote_id: 106, line_no: 2, coffee_id: 25, quantity_kg: 242, list_price: "15.43", list_value: "3734.06", group_discount_pct: 0 }, { id: 318, quote_id: 61, line_no: 3, coffee_id: 27, quantity_kg: 251, list_price: "36.40", list_value: "9136.40", group_discount_pct: 0 }, { id: 319, quote_id: 9, line_no: 5, coffee_id: 18, quantity_kg: 8, list_price: "18.13", list_value: "145.04", group_discount_pct: 0 }, { id: 320, quote_id: 149, line_no: 1, coffee_id: 16, quantity_kg: 57, list_price: "14.43", list_value: "822.51", group_discount_pct: 4 }, { id: 321, quote_id: 51, line_no: 2, coffee_id: 18, quantity_kg: 94, list_price: "18.13", list_value: "1704.22", group_discount_pct: 0 }, { id: 322, quote_id: 188, line_no: 2, coffee_id: 10, quantity_kg: 260, list_price: "30.58", list_value: "7950.80", group_discount_pct: 4 }, { id: 323, quote_id: 19, line_no: 2, coffee_id: 29, quantity_kg: 138, list_price: "22.75", list_value: "3139.50", group_discount_pct: 16 }, { id: 324, quote_id: 155, line_no: 4, coffee_id: 28, quantity_kg: 29, list_price: "24.84", list_value: "720.36", group_discount_pct: 0 }, { id: 325, quote_id: 119, line_no: 1, coffee_id: 23, quantity_kg: 265, list_price: "14.47", list_value: "3834.55", group_discount_pct: 0 }, { id: 326, quote_id: 40, line_no: 2, coffee_id: 15, quantity_kg: 276, list_price: "14.16", list_value: "3908.16", group_discount_pct: 0 }, { id: 327, quote_id: 72, line_no: 3, coffee_id: 24, quantity_kg: 180, list_price: "27.43", list_value: "4937.40", group_discount_pct: 0 }, { id: 328, quote_id: 39, line_no: 1, coffee_id: 11, quantity_kg: 276, list_price: "14.13", list_value: "3899.88", group_discount_pct: 4 }, { id: 329, quote_id: 148, line_no: 1, coffee_id: 17, quantity_kg: 5, list_price: "16.34", list_value: "81.70", group_discount_pct: 0 }, { id: 330, quote_id: 27, line_no: 5, coffee_id: 14, quantity_kg: 11, list_price: "14.02", list_value: "154.22", group_discount_pct: 4 }, { id: 331, quote_id: 185, line_no: 1, coffee_id: 24, quantity_kg: 94, list_price: "27.43", list_value: "2578.42", group_discount_pct: 16 }, { id: 332, quote_id: 180, line_no: 3, coffee_id: 11, quantity_kg: 11, list_price: "14.13", list_value: "155.43", group_discount_pct: 0 }, { id: 333, quote_id: 150, line_no: 5, coffee_id: 23, quantity_kg: 13, list_price: "14.47", list_value: "188.11", group_discount_pct: 4 }, { id: 334, quote_id: 56, line_no: 2, coffee_id: 7, quantity_kg: 54, list_price: "26.72", list_value: "1442.88", group_discount_pct: 4 }, { id: 335, quote_id: 136, line_no: 4, coffee_id: 8, quantity_kg: 27, list_price: "32.43", list_value: "875.61", group_discount_pct: 0 }, { id: 336, quote_id: 74, line_no: 3, coffee_id: 30, quantity_kg: 8, list_price: "14.01", list_value: "112.08", group_discount_pct: 0 }, { id: 337, quote_id: 165, line_no: 1, coffee_id: 1, quantity_kg: 39, list_price: "23.50", list_value: "916.50", group_discount_pct: 0 }, { id: 338, quote_id: 110, line_no: 2, coffee_id: 26, quantity_kg: 5, list_price: "23.54", list_value: "117.70", group_discount_pct: 8 }, { id: 339, quote_id: 118, line_no: 2, coffee_id: 13, quantity_kg: 64, list_price: "17.60", list_value: "1126.40", group_discount_pct: 0 }, { id: 340, quote_id: 77, line_no: 4, coffee_id: 30, quantity_kg: 47, list_price: "14.01", list_value: "658.47", group_discount_pct: 8 }, { id: 341, quote_id: 47, line_no: 3, coffee_id: 19, quantity_kg: 194, list_price: "26.59", list_value: "5158.46", group_discount_pct: 0 }, { id: 342, quote_id: 52, line_no: 3, coffee_id: 21, quantity_kg: 273, list_price: "34.56", list_value: "9434.88", group_discount_pct: 4 }, { id: 343, quote_id: 139, line_no: 5, coffee_id: 5, quantity_kg: 10, list_price: "14.17", list_value: "141.70", group_discount_pct: 0 }, { id: 344, quote_id: 143, line_no: 1, coffee_id: 20, quantity_kg: 41, list_price: "37.02", list_value: "1517.82", group_discount_pct: 0 }, { id: 345, quote_id: 136, line_no: 5, coffee_id: 27, quantity_kg: 5, list_price: "36.40", list_value: "182.00", group_discount_pct: 0 }, { id: 346, quote_id: 76, line_no: 3, coffee_id: 27, quantity_kg: 11, list_price: "36.40", list_value: "400.40", group_discount_pct: 0 }, { id: 347, quote_id: 11, line_no: 1, coffee_id: 7, quantity_kg: 26, list_price: "26.72", list_value: "694.72", group_discount_pct: 0 }, { id: 348, quote_id: 120, line_no: 3, coffee_id: 11, quantity_kg: 282, list_price: "14.13", list_value: "3984.66", group_discount_pct: 0 }, { id: 349, quote_id: 77, line_no: 5, coffee_id: 27, quantity_kg: 6, list_price: "36.40", list_value: "218.40", group_discount_pct: 8 }, { id: 350, quote_id: 1, line_no: 2, coffee_id: 5, quantity_kg: 5, list_price: "14.17", list_value: "70.85", group_discount_pct: 4 }, { id: 351, quote_id: 73, line_no: 1, coffee_id: 21, quantity_kg: 5, list_price: "34.56", list_value: "172.80", group_discount_pct: 0 }, { id: 352, quote_id: 40, line_no: 3, coffee_id: 17, quantity_kg: 191, list_price: "16.34", list_value: "3120.94", group_discount_pct: 0 }, { id: 353, quote_id: 2, line_no: 1, coffee_id: 10, quantity_kg: 162, list_price: "30.58", list_value: "4953.96", group_discount_pct: 0 }, { id: 354, quote_id: 134, line_no: 1, coffee_id: 16, quantity_kg: 64, list_price: "14.43", list_value: "923.52", group_discount_pct: 0 }, { id: 355, quote_id: 61, line_no: 4, coffee_id: 8, quantity_kg: 186, list_price: "32.43", list_value: "6031.98", group_discount_pct: 0 }, { id: 356, quote_id: 157, line_no: 2, coffee_id: 8, quantity_kg: 193, list_price: "32.43", list_value: "6258.99", group_discount_pct: 16 }, { id: 357, quote_id: 59, line_no: 5, coffee_id: 7, quantity_kg: 6, list_price: "26.72", list_value: "160.32", group_discount_pct: 8 }, { id: 358, quote_id: 71, line_no: 2, coffee_id: 27, quantity_kg: 181, list_price: "36.40", list_value: "6588.40", group_discount_pct: 4 }, { id: 359, quote_id: 86, line_no: 2, coffee_id: 12, quantity_kg: 9, list_price: "14.14", list_value: "127.26", group_discount_pct: 0 }, { id: 360, quote_id: 125, line_no: 3, coffee_id: 4, quantity_kg: 8, list_price: "14.35", list_value: "114.80", group_discount_pct: 0 }, { id: 361, quote_id: 22, line_no: 2, coffee_id: 9, quantity_kg: 181, list_price: "20.17", list_value: "3650.77", group_discount_pct: 16 }, { id: 362, quote_id: 4, line_no: 1, coffee_id: 14, quantity_kg: 60, list_price: "14.02", list_value: "841.20", group_discount_pct: 12 }, { id: 363, quote_id: 105, line_no: 3, coffee_id: 8, quantity_kg: 5, list_price: "32.43", list_value: "162.15", group_discount_pct: 0 }, { id: 364, quote_id: 51, line_no: 3, coffee_id: 25, quantity_kg: 26, list_price: "15.43", list_value: "401.18", group_discount_pct: 0 }, { id: 365, quote_id: 137, line_no: 1, coffee_id: 22, quantity_kg: 151, list_price: "21.46", list_value: "3240.46", group_discount_pct: 4 }, { id: 366, quote_id: 113, line_no: 1, coffee_id: 22, quantity_kg: 68, list_price: "21.46", list_value: "1459.28", group_discount_pct: 12 }, { id: 367, quote_id: 15, line_no: 5, coffee_id: 30, quantity_kg: 15, list_price: "14.01", list_value: "210.15", group_discount_pct: 0 }, { id: 368, quote_id: 10, line_no: 2, coffee_id: 12, quantity_kg: 6, list_price: "14.14", list_value: "84.84", group_discount_pct: 0 }, { id: 369, quote_id: 175, line_no: 3, coffee_id: 12, quantity_kg: 57, list_price: "14.14", list_value: "805.98", group_discount_pct: 4 }, { id: 370, quote_id: 146, line_no: 4, coffee_id: 28, quantity_kg: 57, list_price: "24.84", list_value: "1415.88", group_discount_pct: 0 }, { id: 371, quote_id: 115, line_no: 2, coffee_id: 26, quantity_kg: 117, list_price: "23.54", list_value: "2754.18", group_discount_pct: 0 }, { id: 372, quote_id: 71, line_no: 3, coffee_id: 27, quantity_kg: 198, list_price: "36.40", list_value: "7207.20", group_discount_pct: 4 }, { id: 373, quote_id: 56, line_no: 3, coffee_id: 1, quantity_kg: 10, list_price: "23.50", list_value: "235.00", group_discount_pct: 4 }, { id: 374, quote_id: 30, line_no: 5, coffee_id: 3, quantity_kg: 45, list_price: "30.33", list_value: "1364.85", group_discount_pct: 4 }, { id: 375, quote_id: 54, line_no: 1, coffee_id: 22, quantity_kg: 24, list_price: "21.46", list_value: "515.04", group_discount_pct: 4 }, { id: 376, quote_id: 109, line_no: 3, coffee_id: 10, quantity_kg: 285, list_price: "30.58", list_value: "8715.30", group_discount_pct: 0 }, { id: 377, quote_id: 73, line_no: 2, coffee_id: 6, quantity_kg: 190, list_price: "14.35", list_value: "2726.50", group_discount_pct: 0 }, { id: 378, quote_id: 163, line_no: 1, coffee_id: 9, quantity_kg: 17, list_price: "20.17", list_value: "342.89", group_discount_pct: 16 }, ], }); } main() .then(() => prisma.$disconnect()) .catch(async error => { console.error(error); await prisma.$disconnect(); process.exit(1); });