{
    "orders": [
        {
            "document_type": {
                "value": "transport order",
                "reasoning": "The Excel document is titled '出口货物委托书' (Export Cargo Commission Form) which is a shipping/transport booking order. It contains shipping details from Qingdao port to Rotterdam port.",
                "certainty": 95
            },
            "reference": {
                "value": "70418N",
                "reasoning": "The reference number 70418N appears as the mark/identifier on the document and is also the filename prefix (70418N_.xls)",
                "certainty": 100
            },
            "date": {
                "value": "2026-03-18",
                "reasoning": "The email was sent on Wed, 18 Mar 2026 10:18:33 +0000, which is the document date",
                "certainty": 100
            },
            "pickup_date": {
                "value": "",
                "reasoning": "No specific pickup date is mentioned in the documents",
                "certainty": 0
            },
            "delivery_date": {
                "value": "",
                "reasoning": "No specific delivery date is mentioned in the documents",
                "certainty": 0
            },
            "notes": {
                "value": "Email subject: order Seacon. Message: Graag bijgevoegde order boeken (Please book the attached order). Transport by sea, 1x40HQ container. Notify party: SAME AS CONSIGNEE. Container type: 1*40HQ",
                "reasoning": "Combined relevant notes from email and shipping document including transport mode, container type, and notification instructions",
                "certainty": 100
            },
            "customer": {
                "name": {
                    "value": "VOSTERMANS VENTILATION B.V.",
                    "reasoning": "Listed as the consignee (收货人) in the shipping document, this is the receiving party",
                    "certainty": 100
                },
                "address": {
                    "value": "JACHTHAVENWEG 10",
                    "reasoning": "Address listed for the consignee in the shipping document",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5928NT",
                    "reasoning": "Postal code for the consignee address in Venlo",
                    "certainty": 100
                },
                "city": {
                    "value": "VENLO",
                    "reasoning": "City listed in consignee address",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "The consignee address explicitly states 'THE NETHERLANDS'",
                    "certainty": 100
                }
            },
            "supplier": {
                "name": {
                    "value": "MANUFACTURING NETWORK",
                    "reasoning": "Listed as the shipper (装船人) in the shipping document",
                    "certainty": 100
                },
                "address": {
                    "value": "31109 COUNTY ROAD 19",
                    "reasoning": "Street address of the shipper from the shipping document",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "55325",
                    "reasoning": "Postal code from shipper address 'DASSEL, MN 55325'",
                    "certainty": 100
                },
                "city": {
                    "value": "DASSEL",
                    "reasoning": "City from shipper address",
                    "certainty": 100
                },
                "country": {
                    "value": "US",
                    "reasoning": "The address format and state 'MN' (Minnesota) indicate United States",
                    "certainty": 100
                }
            },
            "pickup_location": {
                "name": {
                    "value": "QINGDAO PORT",
                    "reasoning": "The shipping document lists 'QINGDAO' as the port of loading (出运港), which is where the goods will be picked up for sea transport",
                    "certainty": 95
                },
                "address": {
                    "value": "",
                    "reasoning": "No specific address provided, only port name",
                    "certainty": 0
                },
                "postal_code": {
                    "value": "",
                    "reasoning": "No postal code provided for the port",
                    "certainty": 0
                },
                "city": {
                    "value": "QINGDAO",
                    "reasoning": "Listed as the port of loading in the shipping document",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "Qingdao is a major port city in China, and the document is a Chinese export form",
                    "certainty": 100
                }
            },
            "delivery_location": {
                "name": {
                    "value": "VOSTERMANS VENTILATION B.V.",
                    "reasoning": "The final delivery is to the consignee at their facility in Venlo",
                    "certainty": 100
                },
                "address": {
                    "value": "JACHTHAVENWEG 10",
                    "reasoning": "Delivery address from consignee details",
                    "certainty": 100
                },
                "postal_code": {
                    "value": "5928NT",
                    "reasoning": "Postal code from consignee address",
                    "certainty": 100
                },
                "city": {
                    "value": "VENLO",
                    "reasoning": "Delivery city from consignee address",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Netherlands is the consignee country",
                    "certainty": 100
                }
            },
            "items": [
                {
                    "description": {
                        "value": "Fan Parts - Guards (风扇护罩)",
                        "reasoning": "Product description from the shipping document includes both English and Chinese descriptions",
                        "certainty": 100
                    },
                    "quantity": {
                        "value": 36,
                        "reasoning": "Listed as '36PKGS' in the total row of the shipping document",
                        "certainty": 100
                    },
                    "unit": {
                        "value": "PKGS",
                        "reasoning": "Unit is specified as 'PKGS' (packages) in the document",
                        "certainty": 100
                    },
                    "unit_price": {
                        "value": 0,
                        "reasoning": "No pricing information provided in the shipping document",
                        "certainty": 0
                    },
                    "total_price": {
                        "value": 0,
                        "reasoning": "No pricing information provided in the shipping document",
                        "certainty": 0
                    },
                    "weight_kg": {
                        "value": 7800,
                        "reasoning": "Gross weight (毛重KG) listed as 7800 KG in the document",
                        "certainty": 100
                    },
                    "dimensions": {
                        "value": "44 m³",
                        "reasoning": "Volume (体积MEAS) listed as 44, which in shipping context typically means cubic meters",
                        "certainty": 90
                    }
                }
            ],
            "financial": {
                "subtotal": {
                    "value": 0,
                    "reasoning": "No financial information provided in the transport order",
                    "certainty": 0
                },
                "vat_amount": {
                    "value": 0,
                    "reasoning": "No VAT information in the transport order",
                    "certainty": 0
                },
                "vat_percentage": {
                    "value": 0,
                    "reasoning": "No VAT information in the transport order",
                    "certainty": 0
                },
                "total": {
                    "value": 0,
                    "reasoning": "No financial information provided in the transport order",
                    "certainty": 0
                },
                "currency": {
                    "value": "",
                    "reasoning": "No currency information in the transport order",
                    "certainty": 0
                }
            },
            "delivery_info": {
                "expected_date": {
                    "value": "",
                    "reasoning": "No expected delivery date specified in the documents",
                    "certainty": 0
                },
                "terms": {
                    "value": "Sea freight from Qingdao to Rotterdam port, destination port: Rotterdam. Contact: LEO DENESSEN, TEL: +31-(0)77-3893232. HS Code: 84149020",
                    "reasoning": "Delivery terms and contact information from the shipping document",
                    "certainty": 100
                }
            }
        }
    ]
}