Oscar Orderverwerking

E-mail Verwerkingsstatus

Terug naar overzicht

FW: Offerte

Verwerkt: 28-01-2026 11:16:31

Voltooid
Uitvoering ID: oscar_6979e1ff1d50b
Agent: Oscar

📊 Geëxtraheerde Ordergegevens

Kleurcodering: Groen = Zeker (>80%), Geel = Mogelijk (>50%), Rood = Onzeker (<50%)

Toon ruwe JSON
{
    "orders": [
        {
            "document_type": {
                "value": "inkooporder",
                "reasoning": "The PDF document is titled 'Inkooporder' with order number IOR004577-1, and the email explicitly states 'De inkooporder IOR004577 is toegevoegd'",
                "certainty": 100
            },
            "reference": {
                "value": "IOR004577-1",
                "reasoning": "Clearly stated as 'Inkoopordernummer IOR004577-1' at the top of the purchase order document",
                "certainty": 100
            },
            "date": {
                "value": "2026-01-27",
                "reasoning": "The purchase order document shows 'Datum: 27-1-2026'",
                "certainty": 100
            },
            "pickup_date": {
                "value": null,
                "reasoning": "No pickup date specified in the documents",
                "certainty": 0
            },
            "delivery_date": {
                "value": "2026-02-09",
                "reasoning": "The email states 'Uiterlijke levering op maandag 9 februari' (latest delivery Monday February 9) and most items in the order have delivery date 9-2-2026",
                "certainty": 95
            },
            "notes": {
                "value": "Order based on quote 26000609. Order confirmation requested ('Graag een opdrachtbevestiging retour'). Complaints must be submitted in writing within 6 working days. General purchase conditions BTE Nederland BV (1 March 2023) apply.",
                "reasoning": "Multiple notes from the email correspondence and purchase order terms",
                "certainty": 90
            },
            "customer": {
                "name": {
                    "value": "Lodewikus Beton B.V.",
                    "reasoning": "Stated as 'Factuuradres' in the purchase order and as sender in the email",
                    "certainty": 100
                },
                "address": {
                    "value": "Postbus 11",
                    "reasoning": "Address shown in the factuuradres section of the purchase order",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "6669 ZG",
                    "reasoning": "Postal code from factuuradres section",
                    "certainty": 100
                },
                "city": {
                    "value": "Dodewaard",
                    "reasoning": "City from factuuradres section",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Address clearly in Netherlands, confirmed by 'Nederland' in address",
                    "certainty": 100
                }
            },
            "supplier": {
                "name": {
                    "value": "Handelsonderneming Van der Blij B.V.",
                    "reasoning": "Company name shown at top of purchase order as the supplier",
                    "certainty": 100
                },
                "address": {
                    "value": "Paalgravenlaan 4",
                    "reasoning": "Supplier address from purchase order and email signatures",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5342 LR",
                    "reasoning": "Postal code from supplier address",
                    "certainty": 100
                },
                "city": {
                    "value": "Oss",
                    "reasoning": "City from supplier address",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Supplier located in Netherlands",
                    "certainty": 100
                }
            },
            "pickup_location": {
                "name": {
                    "value": null,
                    "reasoning": "No pickup location specified - items are being delivered",
                    "certainty": 0
                },
                "address": {
                    "value": null,
                    "reasoning": "No pickup location specified",
                    "certainty": 0
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "No pickup location specified",
                    "certainty": 0
                },
                "city": {
                    "value": null,
                    "reasoning": "No pickup location specified",
                    "certainty": 0
                },
                "country": {
                    "value": null,
                    "reasoning": "No pickup location specified",
                    "certainty": 0
                }
            },
            "delivery_location": {
                "name": {
                    "value": "Magazijn Oosterhout",
                    "reasoning": "Delivery address section 'Afleveradres' in the purchase order shows this warehouse name",
                    "certainty": 100
                },
                "address": {
                    "value": "Havenweg 41",
                    "reasoning": "Street address from afleveradres section",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "4905 AA",
                    "reasoning": "Postal code from afleveradres section",
                    "certainty": 100
                },
                "city": {
                    "value": "Oosterhout",
                    "reasoning": "City from afleveradres section",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Delivery location in Netherlands",
                    "certainty": 100
                }
            },
            "items": [
                {
                    "description": {
                        "value": "sparingsbuis ø63/68 mm, gezaagd op lengte 175 mm",
                        "reasoning": "Item 1 from purchase order: sparingbuis with inner diameter 63mm, outer diameter 68mm, cut to length 175mm",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 80,
                        "reasoning": "Order states '80 st' (80 pieces)",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Unit is 'st' (stuks/pieces), though priced per meter (14m total for 80 pieces)",
                        "certainty": 95
                    },
                    "unit_price": {
                        "value": 2.18,
                        "reasoning": "Price shown as 2.18 EUR per meter, total 14 meters",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 30.52,
                        "reasoning": "Total amount shown in purchase order for this line item",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": "ø63/68 mm x 175 mm length",
                        "reasoning": "Dimensions specified in item description",
                        "certainty": 100
                    }
                },
                {
                    "description": {
                        "value": "sparingsbuis ø63/68 mm, gezaagd op lengte 225 mm",
                        "reasoning": "Item 2 from purchase order: sparingbuis with inner diameter 63mm, outer diameter 68mm, cut to length 225mm",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 40,
                        "reasoning": "Order states '40 st' (40 pieces)",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Unit is 'st' (stuks/pieces), though priced per meter (9m total for 40 pieces)",
                        "certainty": 95
                    },
                    "unit_price": {
                        "value": 2.18,
                        "reasoning": "Price shown as 2.18 EUR per meter, total 9 meters",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 19.62,
                        "reasoning": "Total amount shown in purchase order for this line item",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": "ø63/68 mm x 225 mm length",
                        "reasoning": "Dimensions specified in item description",
                        "certainty": 100
                    }
                },
                {
                    "description": {
                        "value": "sparingsbuis ø100/105 mm, gezaagd op lengte 465 mm",
                        "reasoning": "Item 3 from purchase order: sparingbuis with inner diameter 100mm, outer diameter 105mm, cut to length 465mm",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 120,
                        "reasoning": "Order states '120 st' (120 pieces)",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Unit is 'st' (stuks/pieces), though priced per meter (56m total for 120 pieces)",
                        "certainty": 95
                    },
                    "unit_price": {
                        "value": 3.67,
                        "reasoning": "Price shown as 3.67 EUR per meter, total 56 meters",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 205.52,
                        "reasoning": "Total amount shown in purchase order for this line item",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": "ø100/105 mm x 465 mm length",
                        "reasoning": "Dimensions specified in item description",
                        "certainty": 100
                    }
                },
                {
                    "description": {
                        "value": "stekeind gestuikte versie M16, gezaagd op 170 mm",
                        "reasoning": "Item 4: threaded anchor M16, cut to 170mm length",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 80,
                        "reasoning": "Order states '80 st' (80 pieces)",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Unit is 'st' (stuks/pieces)",
                        "certainty": 100
                    },
                    "unit_price": {
                        "value": 1.55,
                        "reasoning": "Price shown as 1.55 EUR per piece",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 124,
                        "reasoning": "Total amount shown in purchase order for this line item",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": "M16 x 170 mm",
                        "reasoning": "Thread size and length specified in item description",
                        "certainty": 100
                    }
                },
                {
                    "description": {
                        "value": "stekeind gestuikte versie M16, gezaagd op 220 mm",
                        "reasoning": "Item 5: threaded anchor M16, cut to 220mm length",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 40,
                        "reasoning": "Order states '40 st' (40 pieces)",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Unit is 'st' (stuks/pieces)",
                        "certainty": 100
                    },
                    "unit_price": {
                        "value": 1.83,
                        "reasoning": "Price shown as 1.83 EUR per piece",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 73.2,
                        "reasoning": "Total amount shown in purchase order for this line item",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": "M16 x 220 mm",
                        "reasoning": "Thread size and length specified in item description",
                        "certainty": 100
                    }
                },
                {
                    "description": {
                        "value": "kogelkopanker 5 ton, lengte 180 mm",
                        "reasoning": "Item 6: ball head anchor 5 ton capacity, 180mm length",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 200,
                        "reasoning": "Order states '200 st' (200 pieces)",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Unit is 'st' (stuks/pieces)",
                        "certainty": 100
                    },
                    "unit_price": {
                        "value": 1.19,
                        "reasoning": "Price shown as 1.19 EUR per piece",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 238,
                        "reasoning": "Total amount shown in purchase order for this line item",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": "180 mm length, 5 ton capacity",
                        "reasoning": "Length and capacity specified in item description",
                        "certainty": 100
                    }
                },
                {
                    "description": {
                        "value": "schroefhuls M16, gebogen 45 graden, lengte 70 mm",
                        "reasoning": "Item 7: threaded sleeve M16, bent 45 degrees, 70mm length",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 120,
                        "reasoning": "Order states '120 st' (120 pieces)",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Unit is 'st' (stuks/pieces)",
                        "certainty": 100
                    },
                    "unit_price": {
                        "value": 0.44,
                        "reasoning": "Price shown as 0.44 EUR per piece",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 52.8,
                        "reasoning": "Total amount shown in purchase order for this line item",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": "M16 x 70 mm, bent 45°",
                        "reasoning": "Thread size, length and angle specified in item description",
                        "certainty": 100
                    }
                }
            ],
            "financial": {
                "subtotal": {
                    "value": 743.66,
                    "reasoning": "Subtotal shown in purchase order before VAT",
                    "certainty": 100
                },
                "vat_amount": {
                    "value": 156.17,
                    "reasoning": "VAT amount shown in purchase order as 'BTW'",
                    "certainty": 100
                },
                "vat_percentage": {
                    "value": 21,
                    "reasoning": "Standard Dutch VAT rate, calculated from subtotal and VAT amount (156.17/743.66 ≈ 0.21)",
                    "certainty": 95
                },
                "total": {
                    "value": 899.83,
                    "reasoning": "Total amount shown in purchase order including VAT",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "All prices shown in EUR in the purchase order",
                    "certainty": 100
                }
            },
            "delivery_info": {
                "expected_date": {
                    "value": "2026-02-09",
                    "reasoning": "Email states 'Uiterlijke levering op maandag 9 februari' (latest delivery Monday February 9)",
                    "certainty": 95
                },
                "terms": {
                    "value": "Order must be received by Tuesday January 27, 2026 to meet delivery deadline of February 9. Franco delivery for orders over €1,000 excl. VAT. General purchase conditions BTE Nederland BV apply.",
                    "reasoning": "Terms mentioned in email correspondence and purchase order conditions",
                    "certainty": 90
                }
            }
        }
    ]
}