Oscar Orderverwerking

E-mail Verwerkingsstatus

Vernieuwen
Terug naar overzicht

Whatsapp Message

Verwerkt: 23-10-2025 21:12:21

Voltooid
Uitvoering ID: oscar_68fa7e1576fec
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": "Document is clearly labeled 'FACTUUR' at the top and contains invoice details including payment information",
                "certainty": 100
            },
            "reference": {
                "value": "250906061610",
                "reasoning": "This is the 'factuurnummer' (invoice number) shown on the document. Document number 577709 appears to be a customer-specific reference",
                "certainty": 95
            },
            "date": {
                "value": "2025-09-05",
                "reasoning": "Invoice date shown as 'factuurdatum: 5-09-2025' in Dutch DD-MM-YYYY format",
                "certainty": 100
            },
            "pickup_date": {
                "value": null,
                "reasoning": "No pickup date specified - this is a retail purchase invoice",
                "certainty": 100
            },
            "delivery_date": {
                "value": null,
                "reasoning": "No delivery date specified - appears to be an in-store purchase based on payment terminal information",
                "certainty": 100
            },
            "notes": {
                "value": "Betaling via Maestro op 05/09/2025 12:18. POI: 50247222, Terminal: HXJ741, Transactie: 02203540. Inclusief 2 spaarzegels voor SPA REINE PET en 2 spaarzegels voor Sligro Folder ZB-en. Exclusief Merk van Sligro. Emballage van 10.75 voor 7.99.",
                "reasoning": "Payment details, loyalty stamps (spaarzegels), and packaging discount information from the receipt",
                "certainty": 90
            },
            "customer": {
                "name": {
                    "value": "ZEROPLEX B.V.",
                    "reasoning": "Customer name clearly shown on invoice with company reference 577709",
                    "certainty": 100
                },
                "address": {
                    "value": "HUISKENSSTR 72",
                    "reasoning": "Street address shown on invoice for the customer",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5916 PN",
                    "reasoning": "Postal code shown on invoice",
                    "certainty": 100
                },
                "city": {
                    "value": "VENLO",
                    "reasoning": "City shown on invoice",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Dutch address format and postal code indicate Netherlands",
                    "certainty": 100
                }
            },
            "supplier": {
                "name": {
                    "value": "Sligro Food Group Nederland B.V.",
                    "reasoning": "Company name shown in header of invoice",
                    "certainty": 100
                },
                "address": {
                    "value": "Corridor 11",
                    "reasoning": "Address shown in invoice header",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5466 RB",
                    "reasoning": "Postal code shown in invoice header",
                    "certainty": 100
                },
                "city": {
                    "value": "Veghel",
                    "reasoning": "City shown in invoice header",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Dutch company with NL VAT number (btw nr NL 0011 59 094 B 01)",
                    "certainty": 100
                }
            },
            "pickup_location": {
                "name": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                },
                "address": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                },
                "city": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                },
                "country": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                }
            },
            "delivery_location": {
                "name": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                },
                "address": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                },
                "city": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                },
                "country": {
                    "value": null,
                    "reasoning": "Not applicable for this retail invoice",
                    "certainty": 100
                }
            },
            "items": [
                {
                    "description": {
                        "value": "SMIKKELB.TUM TUM 1KG",
                        "reasoning": "Product description from article 128723",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 2,
                        "reasoning": "Quantity shown in 'besteld' column",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "ZK",
                        "reasoning": "Unit shown as '1 ZK' (zak = bag in Dutch)",
                        "certainty": 100
                    },
                    "unit_price": {
                        "value": 5.25,
                        "reasoning": "Price per unit shown in 'prijs' column",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 10.5,
                        "reasoning": "Total shown in 'bedrag' column (2 x 5.25)",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": 2,
                        "reasoning": "Product is 1KG per unit, quantity is 2, so total weight is 2kg",
                        "certainty": 90
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "No dimensions specified on invoice",
                        "certainty": 100
                    }
                },
                {
                    "description": {
                        "value": "SPA REINE PET 33 CL",
                        "reasoning": "Product description from article 158159",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 4,
                        "reasoning": "Quantity shown in 'besteld' column, representing 4 packs of 24",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "PF",
                        "reasoning": "Unit shown as '24 PF' (pack/fles = pack/bottle)",
                        "certainty": 95
                    },
                    "unit_price": {
                        "value": 7.99,
                        "reasoning": "Price per unit (24-pack) shown in 'prijs' column",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 31.96,
                        "reasoning": "Total shown in 'bedrag' column (4 x 7.99)",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not specified on invoice",
                        "certainty": 100
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "No dimensions specified on invoice",
                        "certainty": 100
                    }
                },
                {
                    "description": {
                        "value": "Emballage - Van 10.75 voor 7.99",
                        "reasoning": "Packaging charge with discount applied",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Single packaging charge line item",
                        "certainty": 95
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Standard unit for service/fee items",
                        "certainty": 80
                    },
                    "unit_price": {
                        "value": 3.6,
                        "reasoning": "Discounted packaging price shown in 'prijs' column",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 14.4,
                        "reasoning": "Total packaging charge shown in 'bedrag' column",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Not applicable for packaging charge",
                        "certainty": 100
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Not applicable for packaging charge",
                        "certainty": 100
                    }
                }
            ],
            "financial": {
                "subtotal": {
                    "value": 42.46,
                    "reasoning": "Subtotal shown as 'goederen laag % btw' (goods with low VAT rate)",
                    "certainty": 100
                },
                "vat_amount": {
                    "value": 3.82,
                    "reasoning": "VAT amount shown as 'btw laag %'",
                    "certainty": 100
                },
                "vat_percentage": {
                    "value": 9,
                    "reasoning": "Dutch low VAT rate (laag btw) is 9%. Calculation: 3.82/42.46 ≈ 0.09",
                    "certainty": 95
                },
                "total": {
                    "value": 60.68,
                    "reasoning": "Total amount shown as 'TOTAAL TE BETALEN' and confirmed in payment section",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Amount shown as '60.68 EUR' in payment section",
                    "certainty": 100
                }
            },
            "delivery_info": {
                "expected_date": {
                    "value": null,
                    "reasoning": "Not applicable - this is a completed retail purchase",
                    "certainty": 100
                },
                "terms": {
                    "value": null,
                    "reasoning": "No special delivery terms specified on retail invoice",
                    "certainty": 100
                }
            }
        }
    ]
}