Oscar Orderverwerking

E-mail Verwerkingsstatus

Vernieuwen
Terug naar overzicht

Whatsapp Message

Verwerkt: 26-11-2025 16:52:31

Voltooid
Uitvoering ID: oscar_6927223f6136f
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": "transport order",
                "reasoning": "The document header clearly states 'Frachtauftrag F2519-042532', which is German for transport order",
                "certainty": 95
            },
            "reference": {
                "value": "F2519-042532",
                "reasoning": "Prominently displayed reference number in the document header",
                "certainty": 100
            },
            "date": {
                "value": "2025-11-27",
                "reasoning": "Document date shown as '27.11.25' in the header",
                "certainty": 95
            },
            "pickup_date": {
                "value": "2025-11-26T14:00:00",
                "reasoning": "Loading section shows 'Mittwoch, 26.11.25' with time '14:00'",
                "certainty": 90
            },
            "delivery_date": {
                "value": "2025-12-04T08:00:00",
                "reasoning": "Delivery section shows printed date 'Donnerstag, 22.11.25' but has handwritten correction that appears to read '4.0-11-25' or similar, suggesting December 4, 2025. Time is 8:00 Uhr",
                "certainty": 70
            },
            "notes": {
                "value": "Transport temperature: 4-8°C. Handwritten note at bottom: 'Is dosier regel Referentie'. Anzahl Stellplätze: 10",
                "reasoning": "Temperature requirement clearly stated in product description, plus handwritten note at bottom of document and number of loading spaces",
                "certainty": 85
            },
            "customer": {
                "name": {
                    "value": "KÖLLA GmbH & Co. KG",
                    "reasoning": "Company name in top right header identified as the ordering party",
                    "certainty": 95
                },
                "address": {
                    "value": "An der Gumpelsbrücke 7",
                    "reasoning": "Address shown in header for KÖLLA GmbH & Co. KG",
                    "certainty": 95
                },
                "postal_code": {
                    "value": "41564",
                    "reasoning": "Postal code from KÖLLA address in header",
                    "certainty": 95
                },
                "city": {
                    "value": "Kaarst",
                    "reasoning": "City from KÖLLA address in header",
                    "certainty": 95
                },
                "country": {
                    "value": "DE",
                    "reasoning": "German company based on address format and German postal code",
                    "certainty": 95
                }
            },
            "supplier": {
                "name": {
                    "value": "OLYMPIC",
                    "reasoning": "Listed as 'Lieferant' (supplier) in the product details section",
                    "certainty": 90
                }
            },
            "pickup_location": {
                "name": {
                    "value": "Kempen Transport B.V.",
                    "reasoning": "Listed under '1. Loading' section as pickup location",
                    "certainty": 95
                },
                "address": {
                    "value": "Venrayseweg 148",
                    "reasoning": "Address shown for Kempen Transport B.V. in loading section",
                    "certainty": 95
                },
                "postal_code": {
                    "value": "5928 RH",
                    "reasoning": "Dutch postal code format shown for Kempen Transport location",
                    "certainty": 95
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City listed for pickup location",
                    "certainty": 95
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Document explicitly states 'Nederlandse' under the pickup address",
                    "certainty": 100
                }
            },
            "delivery_location": {
                "name": {
                    "value": "Kaffee Anders Handels GmbH",
                    "reasoning": "Listed under '1. Entladung' (unloading/delivery) section",
                    "certainty": 95
                },
                "address": {
                    "value": "Nürnberger Straße 85",
                    "reasoning": "Address shown for Kaffee Anders Handels GmbH in delivery section",
                    "certainty": 95
                },
                "postal_code": {
                    "value": "40599",
                    "reasoning": "Postal code for delivery location in Düsseldorf",
                    "certainty": 95
                },
                "city": {
                    "value": "Düsseldorf",
                    "reasoning": "City listed for delivery location",
                    "certainty": 95
                },
                "country": {
                    "value": "DE",
                    "reasoning": "German city and postal code format",
                    "certainty": 95
                }
            },
            "items": [
                {
                    "description": {
                        "value": "Saftoranqen, ZA, Valencia, lose, 15kg, 88, Cl.I, Teleskop-Karton, Industriepalette",
                        "reasoning": "Full product description from the 'Beschreibung' field showing oranges from South Africa, Valencia variety, Class I, in telescopic cartons on industrial pallets",
                        "certainty": 95
                    },
                    "quantity": {
                        "value": 800,
                        "reasoning": "Listed as '800 COLLI' in the 'Ges. Men. Einh.' column",
                        "certainty": 95
                    },
                    "unit": {
                        "value": "COLLI",
                        "reasoning": "Unit specified as 'COLLI' (boxes/packages) in the document",
                        "certainty": 95
                    },
                    "weight_kg": {
                        "value": 12000,
                        "reasoning": "800 units × 15kg per unit = 12,000 kg total. Individual unit weight is 15kg as stated in description",
                        "certainty": 85
                    },
                    "dimensions": {
                        "value": "10 pallets (INDU type), Temperature: 4-8°C",
                        "reasoning": "10.00 pallets of type INDU (Industrial pallets) with temperature requirement of 4-8°C",
                        "certainty": 90
                    }
                }
            ],
            "delivery_info": {
                "terms": {
                    "value": "LKW transport, Partie: 2519-022577, SO-25-10793, Auftrag: A2519-027614, Contact: Anna Fröhlich T +492131661203, anna.froehlich@koella.com",
                    "reasoning": "Various reference numbers and contact information for coordination shown throughout the document",
                    "certainty": 90
                }
            }
        }
    ]
}