CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: HEIC files werken niet

Verwerkt: 28-10-2025 16:48:02

Voltooid
Uitvoering ID: csv_6900e5b1d1ef4
Agent: Oscar

📊 Geëxtraheerde Ordergegevens

Kleurcodering: Groen = Zeker (>80%), Geel = Mogelijk (>50%), Rood = Onzeker (<50%)

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

N/A

100%

EORI number not provided on sea waybill

100%

Consignee name from sea waybill

100%

Street address from consignee details on sea waybill

100%

Switzerland - country code from consignee address marked as SWITZERLAND on document

N/A

N/A

95%

City from consignee address on sea waybill

100%

EORI number for HHH Logistics not provided on document

75%

Notify party listed on sea waybill, likely customs broker handling the clearance

100%

Address from notify party details on sea waybill

100%

Netherlands - Rotterdam location

N/A

N/A

100%

City from notify party address

100%

No identification number provided for Chinese exporter

100%

Shipper name from sea waybill

100%

Street address from shipper details on sea waybill

100%

China - Yancheng City is in China

N/A

N/A

100%

City from shipper address, Dafeng District, Yancheng City

100%

No tax ID or EORI provided

90%

Seller is same as shipper/exporter based on document

90%

Same address as exporter

90%

China - same as exporter

N/A

N/A

90%

Same city as exporter

100%

No identification number provided

90%

Buyer is same as consignee/importer

90%

Same address as consignee

90%

Switzerland - same as consignee

N/A

N/A

90%

Same city as consignee

100%

Incoterms not specified on sea waybill, though freight is marked as prepaid

100%

Currency not specified on sea waybill document

100%

Invoice value not provided on sea waybill

95%

Netherlands - Port of discharge is Rotterdam, Netherlands

100%

China - goods shipped from Shanghai, China

100%

Total gross weight from sea waybill: 235800.000 Kgs

Toon ruwe JSON
{
    "integration": {
        "commercialReference": {
            "value": "17FJTJTS015230",
            "reasoning": "Booking reference number from the sea waybill",
            "certainty": 100
        },
        "externalReferences": {
            "seaWaybillNumber": "MEDUE3932385",
            "serviceContractNumber": "132720-889-ST"
        },
        "createDeclaration": {
            "value": false,
            "reasoning": "Insufficient commodity and valuation information to create complete declaration - document appears to be for review purposes only",
            "certainty": 90
        },
        "remarks": {
            "value": "Sea waybill for containerized shipment from Shanghai to Rotterdam. Freight prepaid. Container details and rider for full cargo description referenced but not provided.",
            "reasoning": "General remarks compiled from available document information",
            "certainty": 95
        }
    },
    "declaration": {
        "declarationType": {
            "value": "IM",
            "reasoning": "Import declaration - goods moving from China (Shanghai) to EU (Rotterdam, Netherlands)",
            "certainty": 95
        },
        "additionalDeclarationType": {
            "value": "A",
            "reasoning": "Standard import declaration type",
            "certainty": 70
        },
        "lrn": {
            "value": null,
            "reasoning": "Local Reference Number not provided in source documents",
            "certainty": 100
        },
        "importer": {
            "references": {
                "internal": {
                    "value": null,
                    "reasoning": "No internal reference code visible in documents",
                    "certainty": 100
                },
                "external": {
                    "value": "MEDUE3932385",
                    "reasoning": "Using sea waybill number as external reference",
                    "certainty": 80
                }
            },
            "name": {
                "value": "TRINA SOLAR BENELUX AG",
                "reasoning": "Consignee name from sea waybill",
                "certainty": 100
            },
            "identificationNumber": {
                "value": null,
                "reasoning": "EORI number not provided on sea waybill",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "BIRKENWEG 4",
                    "reasoning": "Street address from consignee details on sea waybill",
                    "certainty": 100
                },
                "city": {
                    "value": "WEHRLEN",
                    "reasoning": "City from consignee address on sea waybill",
                    "certainty": 95
                },
                "postCode": {
                    "value": "6343",
                    "reasoning": "Postal code from consignee address on sea waybill",
                    "certainty": 100
                },
                "country": {
                    "value": "CH",
                    "reasoning": "Switzerland - country code from consignee address marked as SWITZERLAND on document",
                    "certainty": 100
                }
            },
            "contactPerson": {
                "name": {
                    "value": "Logistics Department",
                    "reasoning": "Generic contact based on email address structure",
                    "certainty": 50
                },
                "phoneNumber": {
                    "value": "+41 55 173 25 88 450",
                    "reasoning": "Phone number from consignee details on sea waybill",
                    "certainty": 100
                },
                "emailAddress": {
                    "value": "MBU.LOGISTICS@TRINASOLAR.COM",
                    "reasoning": "Email address from consignee details on sea waybill",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "references": {
                "internal": {
                    "value": null,
                    "reasoning": "Declarant not specified in documents",
                    "certainty": 100
                },
                "external": {
                    "value": null,
                    "reasoning": "Declarant external reference not provided",
                    "certainty": 100
                }
            },
            "name": {
                "value": "HHH LOGISTICS B.V.",
                "reasoning": "Notify party listed on sea waybill, likely customs broker handling the clearance",
                "certainty": 75
            },
            "identificationNumber": {
                "value": null,
                "reasoning": "EORI number for HHH Logistics not provided on document",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "BEURSPLEIN 37, 4E ETAGE",
                    "reasoning": "Address from notify party details on sea waybill",
                    "certainty": 100
                },
                "city": {
                    "value": "ROTTERDAM",
                    "reasoning": "City from notify party address",
                    "certainty": 100
                },
                "postCode": {
                    "value": "3011AA",
                    "reasoning": "Postal code from notify party address on sea waybill",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Netherlands - Rotterdam location",
                    "certainty": 100
                }
            }
        },
        "representative": {
            "identificationNumber": {
                "value": null,
                "reasoning": "Representative EORI not provided",
                "certainty": 100
            },
            "status": {
                "value": 3,
                "reasoning": "Assuming indirect representation as logistics company is likely acting on behalf of importer",
                "certainty": 60
            }
        },
        "customsOfficeOfPresentation": {
            "referenceNumber": {
                "value": "NL003001",
                "reasoning": "Rotterdam port customs office - standard code for Port of Rotterdam",
                "certainty": 85
            }
        },
        "declarationOffice": {
            "referenceNumber": {
                "value": "NL003001",
                "reasoning": "Same as presentation office for port clearance",
                "certainty": 85
            }
        },
        "exchangeRate": {
            "value": null,
            "reasoning": "No currency information provided on sea waybill to determine exchange rate",
            "certainty": 100
        }
    },
    "goodsShipment": {
        "transportDocument": [
            {
                "referenceNumber": {
                    "value": "MEDUE3932385",
                    "reasoning": "Sea Waybill number from MSC document header",
                    "certainty": 100
                },
                "type": {
                    "value": "705",
                    "reasoning": "Document type code for House Bill of Lading / Sea Waybill",
                    "certainty": 90
                }
            }
        ],
        "additionalReference": [
            {
                "referenceNumber": {
                    "value": "17FJTJTS015230",
                    "reasoning": "Booking reference number from sea waybill",
                    "certainty": 100
                },
                "type": {
                    "value": "704",
                    "reasoning": "Booking confirmation reference document type",
                    "certainty": 80
                }
            }
        ],
        "exporter": {
            "references": {
                "internal": {
                    "value": null,
                    "reasoning": "No internal reference code provided for exporter",
                    "certainty": 100
                },
                "external": {
                    "value": null,
                    "reasoning": "No external reference code provided for exporter",
                    "certainty": 100
                }
            },
            "name": {
                "value": "TRINA SOLAR (YANCHENG DAFENG) CO., LTD.",
                "reasoning": "Shipper name from sea waybill",
                "certainty": 100
            },
            "identificationNumber": {
                "value": null,
                "reasoning": "No identification number provided for Chinese exporter",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "NO. 19, TONGGANG AVENUE, DAFENG PORT",
                    "reasoning": "Street address from shipper details on sea waybill",
                    "certainty": 100
                },
                "city": {
                    "value": "YANCHENG CITY",
                    "reasoning": "City from shipper address, Dafeng District, Yancheng City",
                    "certainty": 100
                },
                "postCode": {
                    "value": null,
                    "reasoning": "Postal code not provided for shipper address",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "China - Yancheng City is in China",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "name": {
                "value": "TRINA SOLAR (YANCHENG DAFENG) CO., LTD.",
                "reasoning": "Seller is same as shipper/exporter based on document",
                "certainty": 90
            },
            "identificationNumber": {
                "value": null,
                "reasoning": "No tax ID or EORI provided",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "NO. 19, TONGGANG AVENUE, DAFENG PORT",
                    "reasoning": "Same address as exporter",
                    "certainty": 90
                },
                "city": {
                    "value": "YANCHENG CITY",
                    "reasoning": "Same city as exporter",
                    "certainty": 90
                },
                "postCode": {
                    "value": null,
                    "reasoning": "Postal code not provided",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "China - same as exporter",
                    "certainty": 90
                }
            }
        },
        "buyer": {
            "name": {
                "value": "TRINA SOLAR BENELUX AG",
                "reasoning": "Buyer is same as consignee/importer",
                "certainty": 90
            },
            "identificationNumber": {
                "value": null,
                "reasoning": "No identification number provided",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "BIRKENWEG 4",
                    "reasoning": "Same address as consignee",
                    "certainty": 90
                },
                "city": {
                    "value": "WEHRLEN",
                    "reasoning": "Same city as consignee",
                    "certainty": 90
                },
                "postCode": {
                    "value": "6343",
                    "reasoning": "Same postal code as consignee",
                    "certainty": 90
                },
                "country": {
                    "value": "CH",
                    "reasoning": "Switzerland - same as consignee",
                    "certainty": 90
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": null,
                "reasoning": "Incoterms not specified on sea waybill, though freight is marked as prepaid",
                "certainty": 100
            },
            "location": {
                "value": "SHANGHAI",
                "reasoning": "Port of loading could be incoterms location if FOB/CFR/CIF terms apply",
                "certainty": 40
            }
        },
        "invoiceCurrency": {
            "value": null,
            "reasoning": "Currency not specified on sea waybill document",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": null,
            "reasoning": "Invoice value not provided on sea waybill",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "CN",
            "reasoning": "China - goods shipped from Shanghai, China",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "NL",
            "reasoning": "Netherlands - Port of discharge is Rotterdam, Netherlands",
            "certainty": 95
        },
        "grossMass": {
            "value": 235800,
            "reasoning": "Total gross weight from sea waybill: 235800.000 Kgs",
            "certainty": 100
        },
        "containerIndicator": {
            "value": 1,
            "reasoning": "Containerized shipment - 10 x 40' HIGH CUBE containers specified",
            "certainty": 100
        },
        "modeOfTransportAtTheBorder": {
            "value": 1,
            "reasoning": "Sea transport - vessel MSC ALLEGRA used for shipment",
            "certainty": 100
        },
        "arrivalTransportMeans": {
            "identificationNumber": {
                "value": "MSC ALLEGRA",
                "reasoning": "Vessel name from sea waybill",
                "certainty": 100
            },
            "typeOfIdentification": {
                "value": 11,
                "reasoning": "Type 11 indicates vessel name as identification method",
                "certainty": 95
            }
        },
        "transportEquipment": [
            {
                "containerIdentificationNumber": {
                    "value": null,
                    "reasoning": "Individual container numbers not provided - only quantity '10 x 40' HIGH CUBE' specified",
                    "certainty": 100
                },
                "goodsReferences": [
                    {
                        "referenceNumber": {
                            "value": 1,
                            "reasoning": "Reference to goods item 1 - only one goods item line visible on waybill",
                            "certainty": 80
                        }
                    }
                ],
                "numberOfSeals": {
                    "value": null,
                    "reasoning": "Seal information not provided on sea waybill",
                    "certainty": 100
                },
                "seals": []
            }
        ]
    },
    "goodsItems": [
        {
            "goodsItemNumber": {
                "value": 1,
                "reasoning": "First and only visible goods item line on the sea waybill",
                "certainty": 95
            },
            "descriptionOfGoods": {
                "value": "Please see attached RIDER for Container / Cargo Description(s). 10 x 40' HIGH CUBE. Freight Prepaid.",
                "reasoning": "Goods description from sea waybill references attached rider document for full details",
                "certainty": 100
            },
            "commodityCode": {
                "harmonizedSystemSubHeadingCode": {
                    "value": null,
                    "reasoning": "HS code not provided on sea waybill - rider document required for commodity classification",
                    "certainty": 100
                },
                "combinedNomenclatureCode": {
                    "value": null,
                    "reasoning": "CN code not provided - requires rider document",
                    "certainty": 100
                },
                "taricCode": {
                    "value": null,
                    "reasoning": "TARIC code not provided - requires rider document",
                    "certainty": 100
                }
            },
            "countryOfOrigin": {
                "value": "CN",
                "reasoning": "Country of origin likely China based on shipper location, but not explicitly stated",
                "certainty": 85
            },
            "countryOfDispatch": {
                "value": "CN",
                "reasoning": "China - goods dispatched from Shanghai",
                "certainty": 100
            },
            "grossMass": {
                "value": 235800,
                "reasoning": "Total gross weight for all goods: 235800.000 Kgs from sea waybill",
                "certainty": 100
            },
            "netMass": {
                "value": null,
                "reasoning": "Net weight not provided on sea waybill",
                "certainty": 100
            },
            "supplementaryUnits": {
                "value": 180,
                "reasoning": "Total items specified as 180 on sea waybill",
                "certainty": 100
            },
            "itemAmountInvoiced": {
                "value": null,
                "reasoning": "Item value not provided on sea waybill",
                "certainty": 100
            },
            "statisticalValue": {
                "value": null,
                "reasoning": "Statistical value cannot be determined without invoice value and currency",
                "certainty": 100
            },
            "packaging": [
                {
                    "numberOfPackages": {
                        "value": 180,
                        "reasoning": "Total items from sea waybill",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": null,
                        "reasoning": "Specific package type code not provided - only container type specified",
                        "certainty": 100
                    },
                    "shippingMarks": {
                        "value": null,
                        "reasoning": "Shipping marks not visible on this portion of sea waybill",
                        "certainty": 100
                    }
                }
            ],
            "procedure": {
                "requestedProcedure": {
                    "value": "40",
                    "reasoning": "Standard release for free circulation procedure for imports into EU",
                    "certainty": 75
                },
                "previousProcedure": {
                    "value": "00",
                    "reasoning": "No previous procedure - direct import from third country",
                    "certainty": 80
                }
            },
            "additionalProcedures": [],
            "preference": {
                "value": 100,
                "reasoning": "No preferential treatment indicated - standard duty treatment assumed",
                "certainty": 70
            },
            "valuationMethod": {
                "value": 1,
                "reasoning": "Method 1 (transaction value) is standard for commercial imports, but cannot be confirmed without invoice",
                "certainty": 60
            },
            "transportDocuments": [
                {
                    "referenceNumber": {
                        "value": "MEDUE3932385",
                        "reasoning": "Sea waybill number applicable to this goods item",
                        "certainty": 100
                    },
                    "type": {
                        "value": "705",
                        "reasoning": "House Bill of Lading / Sea Waybill document type",
                        "certainty": 90
                    }
                }
            ],
            "additionalInformation": [],
            "supportingDocuments": [],
            "dutiesAndTaxes": [],
            "dangerousGoods": []
        }
    ]
}