Oscar Orderverwerking

E-mail Verwerkingsstatus

Vernieuwen
Terug naar overzicht

Whatsapp Message

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

Voltooid
Uitvoering ID: oscar_68fa7e00f2527
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": "The document clearly shows 'FACTUUR' at the top of the page",
                "certainty": 100
            },
            "reference": {
                "value": "251513471",
                "reasoning": "Factuurnummer 251513471 is clearly displayed on the invoice",
                "certainty": 100
            },
            "date": {
                "value": "2025-09-10",
                "reasoning": "Factuurdatum shown as 10-09-2025 09:35",
                "certainty": 100
            },
            "pickup_date": {
                "value": null,
                "reasoning": "No pickup date mentioned on invoice",
                "certainty": 0
            },
            "delivery_date": {
                "value": null,
                "reasoning": "No delivery date mentioned on invoice",
                "certainty": 0
            },
            "notes": {
                "value": "Speciaal voor U bestelde en gekleurde producten, kunnen niet retour genomen worden. Betalingsgegevens: svp vermelden bij betaling: klant 66906 - factuur 251513471. Verkoper: Dennis G",
                "reasoning": "Special notes at bottom of invoice regarding custom products and payment reference",
                "certainty": 95
            },
            "customer": {
                "name": {
                    "value": "Zeroplex BV",
                    "reasoning": "Company name listed in invoice recipient section",
                    "certainty": 100
                },
                "address": {
                    "value": "Huiskensstraat 72",
                    "reasoning": "Street address shown for Zeroplex BV",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5916 PN",
                    "reasoning": "Postal code listed for customer address",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City name VENLO shown on invoice",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Nederland listed as country, which is Netherlands (NL)",
                    "certainty": 100
                }
            },
            "supplier": {
                "name": {
                    "value": "De Verfzaak Venlo B.V. Filiaal Trefcenter",
                    "reasoning": "Company name shown at top of invoice",
                    "certainty": 100
                },
                "address": {
                    "value": "Nijmeegsweg 28c",
                    "reasoning": "Address shown in bottom section of invoice for supplier",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5916 PT",
                    "reasoning": "Postal code for supplier location",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City listed for supplier",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Netherlands location confirmed by Dutch address format",
                    "certainty": 100
                }
            },
            "pickup_location": {
                "name": {
                    "value": "De Verfzaak Venlo B.V. Filiaal Trefcenter",
                    "reasoning": "Supplier location would be pickup point for purchased items",
                    "certainty": 90
                },
                "address": {
                    "value": "Nijmeegsweg 28c",
                    "reasoning": "Supplier address",
                    "certainty": 90
                },
                "postal_code": {
                    "value": "5916 PT",
                    "reasoning": "Supplier postal code",
                    "certainty": 90
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "Supplier city",
                    "certainty": 90
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Netherlands location",
                    "certainty": 90
                }
            },
            "delivery_location": {
                "name": {
                    "value": "Zeroplex BV",
                    "reasoning": "Customer location is delivery destination",
                    "certainty": 90
                },
                "address": {
                    "value": "Huiskensstraat 72",
                    "reasoning": "Customer address",
                    "certainty": 90
                },
                "postal_code": {
                    "value": "5916 PN",
                    "reasoning": "Customer postal code",
                    "certainty": 90
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "Customer city",
                    "certainty": 90
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Customer country",
                    "certainty": 90
                }
            },
            "items": [
                {
                    "description": {
                        "value": "EINZA SUPERDEK EXTRAMAT WIT 10L+25% GRATIS",
                        "reasoning": "Product description from first line item with promotional offer",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Aantal (quantity) column shows 1,00 for this item",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Standard unit for paint products",
                        "certainty": 80
                    },
                    "unit_price": {
                        "value": 69.84,
                        "reasoning": "Bruto stuksprijs incl BTW shown as 69,84",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 46.3,
                        "reasoning": "Totaal incl BTW after 33,71% discount is 46,30",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "No dimensions provided",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "ANZA PRO MINI CIMEX 10CM",
                        "reasoning": "Product description from second line item",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 3,
                        "reasoning": "Aantal column shows 3,00 for this item",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Standard unit for paint accessories",
                        "certainty": 80
                    },
                    "unit_price": {
                        "value": 2.62,
                        "reasoning": "Bruto stuksprijs incl BTW shown as 2,62",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 7.07,
                        "reasoning": "Totaal incl BTW after 10,00% discount is 7,07",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "No dimensions provided",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "MASKING TAPE GOLD BUDGET 36MMX50M",
                        "reasoning": "Product description from third line item with dimensions",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 2,
                        "reasoning": "Aantal column shows 2,00 for this item",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "stuks",
                        "reasoning": "Standard unit for tape rolls",
                        "certainty": 80
                    },
                    "unit_price": {
                        "value": 9.95,
                        "reasoning": "Bruto stuksprijs incl BTW shown as 9,95",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 15.9,
                        "reasoning": "Totaal incl BTW after 20,10% discount is 15,90",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "No weight information provided",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": "36MMX50M",
                        "reasoning": "Dimensions included in product name: 36mm width x 50m length",
                        "certainty": 95
                    }
                }
            ],
            "financial": {
                "subtotal": {
                    "value": 57.25,
                    "reasoning": "Totaal excl btw shown as € 57,25",
                    "certainty": 100
                },
                "vat_amount": {
                    "value": 12.02,
                    "reasoning": "BTW bedrag shown as € 12,02",
                    "certainty": 100
                },
                "vat_percentage": {
                    "value": 21,
                    "reasoning": "% btw shown as 21,00%",
                    "certainty": 100
                },
                "total": {
                    "value": 69.27,
                    "reasoning": "Totaal incl btw shown as € 69,27",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Euro symbol € used throughout invoice, Dutch invoice format",
                    "certainty": 100
                }
            },
            "delivery_info": {
                "expected_date": {
                    "value": null,
                    "reasoning": "No expected delivery date mentioned",
                    "certainty": 0
                },
                "terms": {
                    "value": "Betalingsmethode: Pin",
                    "reasoning": "Payment method shown as Pin at bottom of invoice",
                    "certainty": 100
                }
            }
        }
    ]
}