Oscar Orderverwerking

E-mail Verwerkingsstatus

Terug naar overzicht

Whatsapp Message

Verwerkt: 19-01-2026 15:30:31

Voltooid
Uitvoering ID: oscar_696e400705089
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 header clearly states 'Factuur' with invoice number 98936132",
                "certainty": 100
            },
            "reference": {
                "value": "98936132",
                "reasoning": "Invoice number clearly visible in the top right corner of the document",
                "certainty": 100
            },
            "date": {
                "value": "2025-07-29",
                "reasoning": "Document date shown as '29.07.2025' under the invoice number",
                "certainty": 100
            },
            "pickup_date": {
                "value": null,
                "reasoning": "No specific pickup date mentioned in the invoice",
                "certainty": 0
            },
            "delivery_date": {
                "value": null,
                "reasoning": "Afleverdatum field is mentioned but no specific date is visible in the document",
                "certainty": 30
            },
            "notes": {
                "value": "Project: Goldbeck - DHG Smartlog Heerenveen DC1. Contact: Gea Jacobs (+31 33 74401 06, Gea.Jacobs@trilux.com). Reference orders: 24110234/08.04.2025, 89715587/10.04.2025, 34450842/26.06.2025",
                "reasoning": "Compiled from project name, contact information, and multiple order reference numbers shown on the invoice",
                "certainty": 95
            },
            "customer": {
                "name": {
                    "value": "Maurice Buil",
                    "reasoning": "Listed as 'Uw contactpersoon' (your contact person) with debtor number 82072363",
                    "certainty": 90
                },
                "address": {
                    "value": null,
                    "reasoning": "Customer billing address not clearly specified in the visible document",
                    "certainty": 0
                },
                "postal_code": {
                    "value": null,
                    "reasoning": "Customer postal code not visible in document",
                    "certainty": 0
                },
                "city": {
                    "value": null,
                    "reasoning": "Customer city not specified separately from delivery address",
                    "certainty": 0
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Dutch BTW number (NL807061785B01) indicates Netherlands",
                    "certainty": 100
                }
            },
            "supplier": {
                "name": {
                    "value": "Op het Veld Elektrotechniek",
                    "reasoning": "Listed as 'Opdrachtgever' (client/orderer) in the document header",
                    "certainty": 100
                },
                "address": {
                    "value": "Blauweeler 9c",
                    "reasoning": "Address shown under Opdrachtgever section",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5951 DB",
                    "reasoning": "Postal code shown with supplier address",
                    "certainty": 100
                },
                "city": {
                    "value": "BELFELD",
                    "reasoning": "City shown with supplier address",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Dutch postal code format and location in Netherlands",
                    "certainty": 100
                }
            },
            "pickup_location": {
                "name": {
                    "value": "TRILUX",
                    "reasoning": "Invoice issuer and likely shipping origin",
                    "certainty": 70
                },
                "address": {
                    "value": "Databankweg 28",
                    "reasoning": "TRILUX company address from footer",
                    "certainty": 70
                },
                "postal_code": {
                    "value": "3821 AL",
                    "reasoning": "TRILUX postal code from footer",
                    "certainty": 70
                },
                "city": {
                    "value": "Amersfoort",
                    "reasoning": "TRILUX city from footer",
                    "certainty": 70
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Netherlands location indicated by NL in address",
                    "certainty": 100
                }
            },
            "delivery_location": {
                "name": {
                    "value": "Nieuwbouw Goldbeck/DHG",
                    "reasoning": "Delivery address name from 'Afleveradres' section",
                    "certainty": 100
                },
                "address": {
                    "value": "Mars 6",
                    "reasoning": "Street address from delivery section, contact: Luc Boonen 0647159108",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "8448 CP",
                    "reasoning": "Postal code from delivery address",
                    "certainty": 100
                },
                "city": {
                    "value": "HEERENVEEN",
                    "reasoning": "City from delivery address",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Dutch postal code format and context",
                    "certainty": 100
                }
            },
            "items": [
                {
                    "description": {
                        "value": "07650 L150 7LV E 150 01p4, EAN 4018242591602, Ref. E-Line",
                        "reasoning": "Material 7775700 with full product description from line item 10",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 16,
                        "reasoning": "Quantity shown as '16' in Aantal column for position 10",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "ST",
                        "reasoning": "Unit shown as 'ST' (stuks/pieces) in the Aantal column",
                        "certainty": 100
                    },
                    "unit_price": {
                        "value": 27.61,
                        "reasoning": "Unit price shown as '27,61' in Prijs column",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 441.76,
                        "reasoning": "Total shown as '441,76' in Totaal column",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not specified in invoice",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not specified in invoice",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "07650 BL L225 01, EAN 4018242430451",
                        "reasoning": "Material 7258700 with product description from line item 20",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1080,
                        "reasoning": "Quantity shown as '1.080' in Aantal column for position 20",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "ST",
                        "reasoning": "Unit shown as 'ST' (stuks/pieces) in the Aantal column",
                        "certainty": 100
                    },
                    "unit_price": {
                        "value": 4.47,
                        "reasoning": "Unit price shown as '4,47' in Prijs column",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 4827.6,
                        "reasoning": "Total shown as '4.827,60' in Totaal column",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not specified in invoice",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not specified in invoice",
                        "certainty": 0
                    }
                },
                {
                    "description": {
                        "value": "07650 L450 7LV 225 01, EAN 4018242432684",
                        "reasoning": "Material 7273900 with product description from line item 30",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 1,
                        "reasoning": "Quantity shown as '1' in Aantal column for position 30",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "ST",
                        "reasoning": "Unit shown as 'ST' (stuks/pieces) in the Aantal column",
                        "certainty": 100
                    },
                    "unit_price": {
                        "value": 36.9,
                        "reasoning": "Unit price shown as '36,90' in Prijs column",
                        "certainty": 100
                    },
                    "total_price": {
                        "value": 36.9,
                        "reasoning": "Total shown as '36,90' in Totaal column",
                        "certainty": 100
                    },
                    "weight_kg": {
                        "value": null,
                        "reasoning": "Weight not specified in invoice",
                        "certainty": 0
                    },
                    "dimensions": {
                        "value": null,
                        "reasoning": "Dimensions not specified in invoice",
                        "certainty": 0
                    }
                }
            ],
            "financial": {
                "subtotal": {
                    "value": 5306.26,
                    "reasoning": "Sum of all item totals: 441.76 + 4827.60 + 36.90 = 5306.26 (note: document shows page 1/4, so more items may exist)",
                    "certainty": 80
                },
                "vat_amount": {
                    "value": null,
                    "reasoning": "VAT amount not visible on this page, document indicates BTW-nr but no VAT calculation shown",
                    "certainty": 30
                },
                "vat_percentage": {
                    "value": 21,
                    "reasoning": "Standard Dutch VAT rate of 21% is typical for these products, though not explicitly stated on visible page",
                    "certainty": 50
                },
                "total": {
                    "value": null,
                    "reasoning": "Total with VAT not visible on this page (page 1/4)",
                    "certainty": 30
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Standard currency for Netherlands, implied by context and Dutch BTW numbers",
                    "certainty": 100
                }
            },
            "delivery_info": {
                "expected_date": {
                    "value": null,
                    "reasoning": "No expected delivery date clearly specified in visible portion",
                    "certainty": 0
                },
                "terms": {
                    "value": "Bestelling: BSE2501252/24044 / 08.04.2025",
                    "reasoning": "Order reference and date shown in document header",
                    "certainty": 90
                }
            }
        }
    ]
}