Oscar Orderverwerking

E-mail Verwerkingsstatus

Vernieuwen
Terug naar overzicht

Whatsapp Message

Verwerkt: 29-11-2025 11:59:21

Voltooid
Uitvoering ID: oscar_692ad2090c564
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 'Kassabon' (cash register receipt/invoice) from a retail store, which serves as proof of purchase and invoice",
                "certainty": 95
            },
            "reference": {
                "value": "40514078",
                "reasoning": "The 'Bonnummer' (receipt number) clearly shown on the document",
                "certainty": 100
            },
            "date": {
                "value": "2025-11-28",
                "reasoning": "The 'Datum' field on the receipt shows 28-11-2025",
                "certainty": 100
            },
            "pickup_date": {
                "value": null,
                "reasoning": "This is a retail receipt, not a transport order, so no pickup date is applicable",
                "certainty": 100
            },
            "delivery_date": {
                "value": null,
                "reasoning": "This appears to be an in-store purchase receipt, no delivery date specified",
                "certainty": 100
            },
            "notes": {
                "value": "Geholpen door: Peter. Betaald met Pin - V Pay kaart. Ruilen of retourneren binnen 14 dagen.",
                "reasoning": "Receipt shows it was handled by Peter, paid with V Pay card, and includes 14-day return policy",
                "certainty": 95
            },
            "customer": {
                "name": {
                    "value": "Rick van Dijk",
                    "reasoning": "Email sender's name from the metadata",
                    "certainty": 80
                },
                "address": {
                    "value": null,
                    "reasoning": "No customer address provided on the receipt",
                    "certainty": 100
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "No customer postal code provided on the receipt",
                    "certainty": 100
                },
                "city": {
                    "value": null,
                    "reasoning": "No customer city provided on the receipt",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Email domain and context suggest Netherlands, store is in Venlo, NL",
                    "certainty": 90
                }
            },
            "supplier": {
                "name": {
                    "value": "Tummers Venlo BV",
                    "reasoning": "Company name clearly shown at the top of the receipt",
                    "certainty": 100
                },
                "address": {
                    "value": "Nijmeegseweg 2-C",
                    "reasoning": "Address shown on the receipt header",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5916 PT",
                    "reasoning": "Postal code shown on the receipt header",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City shown on the receipt header",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Dutch postal code format, IBAN starting with NL, and BTW number starting with NL",
                    "certainty": 100
                }
            },
            "pickup_location": {
                "name": {
                    "value": "EP:Tummers Venlo",
                    "reasoning": "Store location where the purchase was made",
                    "certainty": 90
                },
                "address": {
                    "value": "Nijmeegseweg 2-C",
                    "reasoning": "Store address from receipt header",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5916 PT",
                    "reasoning": "Store postal code from receipt header",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "Store city from receipt header",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Store is in the Netherlands",
                    "certainty": 100
                }
            },
            "delivery_location": {
                "name": {
                    "value": null,
                    "reasoning": "No delivery location specified, appears to be in-store purchase",
                    "certainty": 100
                },
                "address": {
                    "value": null,
                    "reasoning": "No delivery address on receipt",
                    "certainty": 100
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "No delivery postal code on receipt",
                    "certainty": 100
                },
                "city": {
                    "value": null,
                    "reasoning": "No delivery city on receipt",
                    "certainty": 100
                },
                "country": {
                    "value": null,
                    "reasoning": "No delivery country on receipt",
                    "certainty": 100
                }
            },
            "items": [
                {
                    "description": {
                        "value": "Jura Claris Smart+ filter 3-pack",
                        "reasoning": "Product description shown in the 'Omschrijving' column",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity shown in the 'Aantal' column",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Standard unit for product items, one 3-pack purchased",
                        "certainty": 95
                    },
                    "unit_price": {
                        "value": 42.99,
                        "reasoning": "Price incl. BTW shown as 42,99 for single item",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 42.99,
                        "reasoning": "Total incl. BTW shown as 42,99 in the 'Totaal incl. BTW' column",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided on the receipt",
                        "certainty": 100
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "No dimensions provided on the receipt",
                        "certainty": 100
                    }
                }
            ],
            "financial": {
                "subtotal": {
                    "value": 35.53,
                    "reasoning": "BTW Basis shown as 35,53 - this is the amount excluding VAT",
                    "certainty": 100
                },
                "vat_amount": {
                    "value": 7.46,
                    "reasoning": "Bedrag BTW shown as 7,46",
                    "certainty": 100
                },
                "vat_percentage": {
                    "value": 21,
                    "reasoning": "Receipt shows 'BTW 21%' rate applied",
                    "certainty": 100
                },
                "total": {
                    "value": 42.99,
                    "reasoning": "Totaal geleverd incl. BTW shown as 42,99",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Amounts shown with € symbol, Dutch company with Euro as currency",
                    "certainty": 100
                }
            },
            "delivery_info": {
                "expected_date": {
                    "value": null,
                    "reasoning": "No delivery date specified, appears to be immediate in-store purchase",
                    "certainty": 100
                },
                "terms": {
                    "value": "Ruilen of retourneren binnen 14 dagen",
                    "reasoning": "Return/exchange policy stated at bottom of receipt: returns within 14 days",
                    "certainty": 100
                }
            }
        }
    ]
}