Oscar Orderverwerking

E-mail Verwerkingsstatus

Vernieuwen
Terug naar overzicht

Whatsapp Message

Verwerkt: 18-11-2025 20:32:01

Voltooid
Uitvoering ID: oscar_691cc9b0e2e27
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": "factuur",
                "reasoning": "This is a restaurant receipt/bill showing itemized purchases with prices and VAT, which functions as an invoice for dining services",
                "certainty": 85
            },
            "reference": {
                "value": "G4",
                "reasoning": "Table number G4 is shown on the receipt, this is the only identifying reference number on the document",
                "certainty": 90
            },
            "date": {
                "value": "2025-11-18",
                "reasoning": "Receipt shows date '18.11.2025' at timestamp 20:29",
                "certainty": 100
            },
            "pickup_date": {
                "value": null,
                "reasoning": "Not applicable - this is a restaurant receipt, not a transport order",
                "certainty": 0
            },
            "delivery_date": {
                "value": null,
                "reasoning": "Not applicable - this is a restaurant receipt, not a transport order",
                "certainty": 0
            },
            "notes": {
                "value": "Restaurant receipt from Van der Valk Hotel Venlo. Served by MICHEL DEMEISY. This is a dining receipt, not a transport/logistics document.",
                "reasoning": "General context about the nature of this document to clarify it's a restaurant bill",
                "certainty": 100
            },
            "customer": {
                "name": {
                    "value": "Rick van Dijk",
                    "reasoning": "Name 'Rick van Dijk' appears on the receipt as the person being served",
                    "certainty": 95
                },
                "address": {
                    "value": null,
                    "reasoning": "No customer address provided on restaurant receipt",
                    "certainty": 0
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "No customer postal code provided",
                    "certainty": 0
                },
                "city": {
                    "value": null,
                    "reasoning": "No customer city provided",
                    "certainty": 0
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Receipt is from Van der Valk Hotel in Venlo, Netherlands, customer email is also .nl domain",
                    "certainty": 90
                }
            },
            "supplier": {
                "name": {
                    "value": "Van der Valk Hotel Venlo",
                    "reasoning": "Restaurant name shown at bottom of receipt",
                    "certainty": 100
                },
                "address": {
                    "value": "Nijmeegseweg 90",
                    "reasoning": "Address shown at bottom of receipt",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5916 PT",
                    "reasoning": "Postal code shown on receipt",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City name shown on receipt",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Venlo is in the Netherlands, Dutch VAT rates applied",
                    "certainty": 100
                }
            },
            "pickup_location": {
                "name": {
                    "value": null,
                    "reasoning": "Not applicable for restaurant receipt",
                    "certainty": 0
                },
                "address": {
                    "value": null,
                    "reasoning": "Not applicable",
                    "certainty": 0
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "Not applicable",
                    "certainty": 0
                },
                "city": {
                    "value": null,
                    "reasoning": "Not applicable",
                    "certainty": 0
                },
                "country": {
                    "value": null,
                    "reasoning": "Not applicable",
                    "certainty": 0
                }
            },
            "delivery_location": {
                "name": {
                    "value": null,
                    "reasoning": "Not applicable for restaurant receipt",
                    "certainty": 0
                },
                "address": {
                    "value": null,
                    "reasoning": "Not applicable",
                    "certainty": 0
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "Not applicable",
                    "certainty": 0
                },
                "city": {
                    "value": null,
                    "reasoning": "Not applicable",
                    "certainty": 0
                },
                "country": {
                    "value": null,
                    "reasoning": "Not applicable",
                    "certainty": 0
                }
            },
            "items": [
                {
                    "description": {
                        "value": "Swinkels 0,5L",
                        "reasoning": "First item on receipt",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual beverage item",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 7,
                        "reasoning": "Unit price shown as €7,00",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 7,
                        "reasoning": "Total price for 1 item at €7,00",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable for restaurant items",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Bavaria Radler 0,0%",
                        "reasoning": "Second item on receipt",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 2,
                        "reasoning": "Quantity column shows 2",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual beverage items",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 4,
                        "reasoning": "Unit price shown as €4,00",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 8,
                        "reasoning": "Total price for 2 items at €4,00 each",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Spa Rood",
                        "reasoning": "Third item on receipt",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual beverage item",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 3.3,
                        "reasoning": "Unit price shown as €3,30",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 3.3,
                        "reasoning": "Total price for 1 item at €3,30",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Coca Cola",
                        "reasoning": "Fourth item on receipt",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 3,
                        "reasoning": "Quantity column shows 3",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual beverage items",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 3.3,
                        "reasoning": "Unit price shown as €3,30",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 9.9,
                        "reasoning": "Total price for 3 items at €3,30 each",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Soep paddenstoel",
                        "reasoning": "Fifth item on receipt - mushroom soup",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual soup dish",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 8.5,
                        "reasoning": "Unit price shown as €8,50",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 8.5,
                        "reasoning": "Total price for 1 item at €8,50",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Tomatensoep",
                        "reasoning": "Sixth item on receipt - tomato soup",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 3,
                        "reasoning": "Quantity column shows 3",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual soup dishes",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 9.5,
                        "reasoning": "Unit price shown as €9,50",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 28.5,
                        "reasoning": "Total price for 3 items at €9,50 each",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Schnitzel",
                        "reasoning": "Seventh item on receipt - first schnitzel",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual main course dish",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 22.5,
                        "reasoning": "Unit price shown as €22,50",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 22.5,
                        "reasoning": "Total price for 1 item at €22,50",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Schnitzel",
                        "reasoning": "Eighth item on receipt - second schnitzel",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual main course dish",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 22.5,
                        "reasoning": "Unit price shown as €22,50",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 22.5,
                        "reasoning": "Total price for 1 item at €22,50",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Schnitzel",
                        "reasoning": "Ninth item on receipt - third schnitzel",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual main course dish",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 22.5,
                        "reasoning": "Unit price shown as €22,50",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 22.5,
                        "reasoning": "Total price for 1 item at €22,50",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Entrecote",
                        "reasoning": "Tenth item on receipt",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual main course dish",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 32.5,
                        "reasoning": "Unit price shown as €32,50",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 32.5,
                        "reasoning": "Total price for 1 item at €32,50",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Dubai by night",
                        "reasoning": "Eleventh item on receipt - likely a dessert",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual dessert dish",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 9.5,
                        "reasoning": "Unit price shown as €9,50",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 9.5,
                        "reasoning": "Total price for 1 item at €9,50",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Winter coupe",
                        "reasoning": "Twelfth item on receipt - dessert",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual dessert dish",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 9.5,
                        "reasoning": "Unit price shown as €9,50",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 9.5,
                        "reasoning": "Total price for 1 item at €9,50",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Dame Blanche",
                        "reasoning": "Thirteenth item on receipt - ice cream dessert",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 2,
                        "reasoning": "Quantity column shows 2",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual dessert dishes",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 9.5,
                        "reasoning": "Unit price shown as €9,50",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 19,
                        "reasoning": "Total price for 2 items at €9,50 each",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "Koffie",
                        "reasoning": "Last item on receipt - coffee",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity column shows 1",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Individual beverage",
                        "certainty": 90
                    },
                    "unit_price": {
                        "value": 3.4,
                        "reasoning": "Unit price shown as €3,40",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 3.4,
                        "reasoning": "Total price for 1 item at €3,40",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not applicable",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not applicable",
                        "certainty": 0
                    }
                }
            ],
            "financial": {
                "subtotal": {
                    "value": 188.91,
                    "reasoning": "Sum of excl. amounts from VAT breakdown: €183,12 + €5,79",
                    "certainty": 100
                },
                "vat_amount": {
                    "value": 17.69,
                    "reasoning": "Sum of VAT amounts: €16,48 + €1,21",
                    "certainty": 100
                },
                "vat_percentage": {
                    "value": null,
                    "reasoning": "Multiple VAT rates applied: 9.00% and 21.00%, cannot specify single rate",
                    "certainty": 0
                },
                "total": {
                    "value": 206.6,
                    "reasoning": "Total shown on receipt as 'Algemeen Totaal: 206,60'",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Prices shown with € symbol, location in Netherlands",
                    "certainty": 100
                }
            },
            "delivery_info": {
                "expected_date": {
                    "value": null,
                    "reasoning": "Not applicable for restaurant receipt",
                    "certainty": 0
                },
                "terms": {
                    "value": null,
                    "reasoning": "No special delivery terms for restaurant service",
                    "certainty": 0
                }
            }
        }
    ]
}