Oscar Orderverwerking

E-mail Verwerkingsstatus

Vernieuwen
Terug naar overzicht

Whatsapp Message

Verwerkt: 06-11-2025 08:41:11

Voltooid
Uitvoering ID: oscar_690c51170b3ca
Agent: Oscar

📎 E-mail Bijlagen

📊 Geëxtraheerde Ordergegevens

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

Toon ruwe JSON
{
    "orders": [
        {
            "document_type": {
                "value": "orderbevestiging",
                "reasoning": "The document is clearly titled 'Orderbevestiging' at the top of the form",
                "certainty": 100
            },
            "reference": {
                "value": "431601",
                "reasoning": "Order number found in the table under 'Orde-documentnummer'",
                "certainty": 100
            },
            "date": {
                "value": "2025-07-09",
                "reasoning": "Order date shown as '09-07-25' in the 'Orderdatum' field",
                "certainty": 100
            },
            "pickup_date": {
                "value": null,
                "reasoning": "No pickup date specified in this order confirmation",
                "certainty": 0
            },
            "delivery_date": {
                "value": "2025-07-21",
                "reasoning": "Latest delivery date shown as '21-07-25' in the 'Uiterste leverdatum' field",
                "certainty": 100
            },
            "notes": {
                "value": "ALLEEN FLESSEN MET HANDVAT LEVEREN! 2 Flessen omruilen voor Fles met Handvat. Leveren rechterzijde pand rolpoort. Route: Sprinter Venlo. Flessen zonder dop of defecte dop worden niet retour genomen. Aantal flessen retour met blauwe dop en witte dop. Besteld door: Twan van Dijk. Door Doris Segers.",
                "reasoning": "Multiple special instructions found throughout the document emphasizing delivery of bottles with handles, return conditions, delivery location, and route information",
                "certainty": 95
            },
            "customer": {
                "name": {
                    "value": "ZeroPlex",
                    "reasoning": "Customer name clearly shown in the left header section of the document",
                    "certainty": 100
                },
                "address": {
                    "value": "Huiskensstraat 72",
                    "reasoning": "Street address shown under ZeroPlex name",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5916 PN",
                    "reasoning": "Postal code shown on the same line as city",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City name shown after postal code",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Country specified as 'Nederland' in the address block",
                    "certainty": 100
                }
            },
            "supplier": {
                "name": {
                    "value": "Mister Aqua B.V.",
                    "reasoning": "Supplier name shown in the top right header with full company details",
                    "certainty": 100
                },
                "address": {
                    "value": "Schaapweg 30a",
                    "reasoning": "Address shown in supplier details section",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "6063 BA",
                    "reasoning": "Postal code shown before city name in supplier details",
                    "certainty": 100
                },
                "city": {
                    "value": "Vlodrop",
                    "reasoning": "City name shown in supplier address details",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Country specified as 'Netherlands' in the supplier address",
                    "certainty": 100
                }
            },
            "pickup_location": {
                "name": {
                    "value": null,
                    "reasoning": "No separate pickup location specified",
                    "certainty": 0
                },
                "address": {
                    "value": null,
                    "reasoning": "No pickup address specified",
                    "certainty": 0
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "No pickup postal code specified",
                    "certainty": 0
                },
                "city": {
                    "value": null,
                    "reasoning": "No pickup city specified",
                    "certainty": 0
                },
                "country": {
                    "value": null,
                    "reasoning": "No pickup country specified",
                    "certainty": 0
                }
            },
            "delivery_location": {
                "name": {
                    "value": "ZeroPlex",
                    "reasoning": "Delivery to customer location, with note about 'rechterzijde pand rolpoort' (right side building roll door)",
                    "certainty": 100
                },
                "address": {
                    "value": "Huiskensstraat 72",
                    "reasoning": "Same as customer address, delivery location specified",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5916 PN",
                    "reasoning": "Same as customer postal code",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "Same as customer city, confirmed by route 'Sprinter Venlo'",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Same as customer country",
                    "certainty": 100
                }
            },
            "items": [
                {
                    "description": {
                        "value": "Mister Aqua Drinkwater 18.9 liter",
                        "reasoning": "Product description from order line with code 000-01",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 10,
                        "reasoning": "Quantity shown in 'Besteld' column for this item",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Standard unit for water bottles/containers",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": null,
                        "reasoning": "No unit price shown on this order confirmation",
                        "certainty": 0
                    },
                    "total_price": {
                        "value": null,
                        "reasoning": "No total price shown on this order confirmation",
                        "certainty": 0
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "No dimension information provided",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Statiegeld 18.9 liter fles met witte dop",
                        "reasoning": "Deposit for 18.9 liter bottle with white cap, shown in order line with code 101-2",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 10,
                        "reasoning": "Quantity shown in 'Besteld' column for this item, matching the number of bottles",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Deposit per bottle unit",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": null,
                        "reasoning": "No unit price shown on this order confirmation",
                        "certainty": 0
                    },
                    "total_price": {
                        "value": null,
                        "reasoning": "No total price shown on this order confirmation",
                        "certainty": 0
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information for deposit item",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "No dimension information provided",
                        "certainty": 0
                    }
                }
            ],
            "financial": {
                "subtotal": {
                    "value": null,
                    "reasoning": "No financial information shown on this order confirmation",
                    "certainty": 0
                },
                "vat_amount": {
                    "value": null,
                    "reasoning": "No VAT amount shown",
                    "certainty": 0
                },
                "vat_percentage": {
                    "value": null,
                    "reasoning": "No VAT percentage shown",
                    "certainty": 0
                },
                "total": {
                    "value": null,
                    "reasoning": "No total amount shown",
                    "certainty": 0
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Netherlands-based transaction, EUR is standard currency",
                    "certainty": 95
                }
            },
            "delivery_info": {
                "expected_date": {
                    "value": "2025-07-21",
                    "reasoning": "Latest delivery date specified as '21-07-25'",
                    "certainty": 100
                },
                "terms": {
                    "value": "Deliver bottles with handles only. Exchange 2 bottles for bottles with handles. Deliver to right side building roll door. Bottles without caps or with defective caps will not be accepted for return.",
                    "reasoning": "Special delivery terms and conditions specified throughout the document",
                    "certainty": 95
                }
            }
        }
    ]
}