CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: 19-12 aangepaste rekening bijgevoegd // Customs Instructions Import, S2504308995 Dest Rotterdam, HBL# CGOA75717, ETA: 19-12-25, SEA, ZHENGZHOU HUANERXIAN NETWORK TECHNOLOGY CO LTD

Verwerkt: 15-12-2025 08:18:01

Voltooid
Uitvoering ID: csv_693fb629a4736
Agent: Oscar

πŸ“Š GeΓ«xtraheerde Ordergegevens

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

90%

This is an import declaration for goods arriving by sea into Rotterdam, Netherlands, which requires an H1 (EU import) declaration template

100%

Total number of cartons stated consistently across all documents: 601 CTN (130 + 471)

100%

Gross weight stated in kg across multiple documents including the bill of lading and commercial invoice

100%

Net weight total from invoice (12835 + 1430 = 14265 kg)

100%

Total invoice value from commercial invoice (14128.587 + 1442.61 = 15571.197)

100%

Currency explicitly stated as EUR in the commercial invoice

70%

Based on CSV Logistics being the customs representative handling the fiscal clearance as requested in the email

95%

Company name from DHL customs instructions and email correspondence handling the customs clearance

100%

EORI number for Exsamind GmbH stated in the updated commercial invoice

100%

Consignee name from Sea Waybill and updated commercial invoice, confirmed as the importer after buyer correction

100%

Street address from the updated commercial invoice and Sea Waybill

100%

Germany - from the consignee address in all documents

100%

Postal code from consignee address in updated invoice and Sea Waybill

100%

City from consignee address in all relevant documents

70%

CSV Logistics EORI/identification number as the declarant preparing the fiscal clearance

100%

Declarant name from the customs instructions cover sheet

100%

Street address of CSV from the DHL customs instructions and email footer

100%

Netherlands - location of CSV Customs Solutions Venlo

100%

Postal code from CSV address in customs instructions

100%

City from CSV address in all correspondence

85%

EORI number stated in the commercial invoice for the exporter

100%

Shipper name from Sea Waybill, customs instructions, and commercial invoice

100%

Full street address from commercial invoice and Sea Waybill

100%

China - explicitly stated in all shipping documents

100%

Postal code from the shipper address in Sea Waybill and customs instructions

100%

City from shipper address, Henan Province

85%

Same as exporter - the shipper is also the seller in this DDP/CIF transaction

95%

Seller is the same entity as the shipper/exporter

100%

Same address as exporter

100%

China - same as exporter

100%

Same postal code as exporter

100%

Same city as exporter

100%

EORI of Exsamind GmbH from the corrected commercial invoice - email thread indicates buyer was corrected from Chinese entity to Exsamind

100%

Buyer name from the updated commercial invoice after correction requested in email

100%

Buyer address from corrected commercial invoice

100%

Germany - buyer location

100%

Postal code from buyer address

100%

City from buyer address

100%

Incoterm stated as CIF in the email from Carmelo Vitale and in the commercial invoice

100%

Currency explicitly stated in the commercial invoice

100%

Total invoice value from commercial invoice (sum of both items: 14128.587 + 1442.61)

100%

Netherlands - Port of discharge Rotterdam stated in all shipping documents

100%

China - Port of loading Qingdao stated in all shipping documents, origin stated as China in invoice

100%

Total gross mass from bill of lading and commercial invoice

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "H1",
            "reasoning": "This is an import declaration for goods arriving by sea into Rotterdam, Netherlands, which requires an H1 (EU import) declaration template",
            "certainty": 90
        },
        "control": {
            "packages": {
                "value": 601,
                "reasoning": "Total number of cartons stated consistently across all documents: 601 CTN (130 + 471)",
                "certainty": 100
            },
            "grossmass": {
                "value": 15837.9,
                "reasoning": "Gross weight stated in kg across multiple documents including the bill of lading and commercial invoice",
                "certainty": 100
            },
            "netmass": {
                "value": 14265,
                "reasoning": "Net weight total from invoice (12835 + 1430 = 14265 kg)",
                "certainty": 100
            },
            "commodityValue": {
                "value": {
                    "value": 15571.197,
                    "reasoning": "Total invoice value from commercial invoice (14128.587 + 1442.61 = 15571.197)",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Currency explicitly stated as EUR in the commercial invoice",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "NL007408179",
                "reasoning": "Based on CSV Logistics being the customs representative handling the fiscal clearance as requested in the email",
                "certainty": 70
            },
            "representativeName": {
                "value": "CSV CUSTOMS SOLUTIONS VENLO B.V.",
                "reasoning": "Company name from DHL customs instructions and email correspondence handling the customs clearance",
                "certainty": 95
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE724078573280054",
                "reasoning": "EORI number for Exsamind GmbH stated in the updated commercial invoice",
                "certainty": 100
            },
            "name": {
                "value": "EXSAMIND GMBH",
                "reasoning": "Consignee name from Sea Waybill and updated commercial invoice, confirmed as the importer after buyer correction",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Adolfstrasse 1",
                    "reasoning": "Street address from the updated commercial invoice and Sea Waybill",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany - from the consignee address in all documents",
                    "certainty": 100
                },
                "postcode": {
                    "value": "65185",
                    "reasoning": "Postal code from consignee address in updated invoice and Sea Waybill",
                    "certainty": 100
                },
                "city": {
                    "value": "Wiesbaden",
                    "reasoning": "City from consignee address in all relevant documents",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "NL007408179",
                "reasoning": "CSV Logistics EORI/identification number as the declarant preparing the fiscal clearance",
                "certainty": 70
            },
            "name": {
                "value": "CSV CUSTOMS SOLUTIONS VENLO B.V.",
                "reasoning": "Declarant name from the customs instructions cover sheet",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Ankerkade 20",
                    "reasoning": "Street address of CSV from the DHL customs instructions and email footer",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Netherlands - location of CSV Customs Solutions Venlo",
                    "certainty": 100
                },
                "postcode": {
                    "value": "5928 PL",
                    "reasoning": "Postal code from CSV address in customs instructions",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City from CSV address in all correspondence",
                    "certainty": 100
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "S2504308995",
                        "reasoning": "DHL shipment reference number from customs instructions and Sea Waybill",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "C2502022508",
                        "reasoning": "Consol reference number from customs instructions and Sea Waybill",
                        "certainty": 100
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "CGOA75717",
                        "reasoning": "House Bill of Lading number from Sea Waybill and customs instructions",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "QGD2257828",
                        "reasoning": "Ocean Bill of Lading number from CMA CGM Waybill and customs instructions",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "FBMEU202510410GC7",
                        "reasoning": "Commercial invoice number from the invoice document",
                        "certainty": 100
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": "FRCN951533553",
                "reasoning": "EORI number stated in the commercial invoice for the exporter",
                "certainty": 85
            },
            "name": {
                "value": "ZHENGZHOU HUANERXIAN NETWORK TECHNOLOGY CO., LTD",
                "reasoning": "Shipper name from Sea Waybill, customs instructions, and commercial invoice",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "1416, Building 8, Shenglong International Zone C, No. 68, Zhengtong Road, Erqi District",
                    "reasoning": "Full street address from commercial invoice and Sea Waybill",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "China - explicitly stated in all shipping documents",
                    "certainty": 100
                },
                "postcode": {
                    "value": "450062",
                    "reasoning": "Postal code from the shipper address in Sea Waybill and customs instructions",
                    "certainty": 100
                },
                "city": {
                    "value": "Zhengzhou",
                    "reasoning": "City from shipper address, Henan Province",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "FRCN951533553",
                "reasoning": "Same as exporter - the shipper is also the seller in this DDP/CIF transaction",
                "certainty": 85
            },
            "name": {
                "value": "ZHENGZHOU HUANERXIAN NETWORK TECHNOLOGY CO., LTD",
                "reasoning": "Seller is the same entity as the shipper/exporter",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "1416, Building 8, Shenglong International Zone C, No. 68, Zhengtong Road, Erqi District",
                    "reasoning": "Same address as exporter",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "China - same as exporter",
                    "certainty": 100
                },
                "postcode": {
                    "value": "450062",
                    "reasoning": "Same postal code as exporter",
                    "certainty": 100
                },
                "city": {
                    "value": "Zhengzhou",
                    "reasoning": "Same city as exporter",
                    "certainty": 100
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "DE724078573280054",
                "reasoning": "EORI of Exsamind GmbH from the corrected commercial invoice - email thread indicates buyer was corrected from Chinese entity to Exsamind",
                "certainty": 100
            },
            "name": {
                "value": "EXSAMIND GMBH",
                "reasoning": "Buyer name from the updated commercial invoice after correction requested in email",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Adolfstrasse 1",
                    "reasoning": "Buyer address from corrected commercial invoice",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany - buyer location",
                    "certainty": 100
                },
                "postcode": {
                    "value": "65185",
                    "reasoning": "Postal code from buyer address",
                    "certainty": 100
                },
                "city": {
                    "value": "Wiesbaden",
                    "reasoning": "City from buyer address",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "CIF",
                "reasoning": "Incoterm stated as CIF in the email from Carmelo Vitale and in the commercial invoice",
                "certainty": 100
            }
        },
        "invoiceCurrency": {
            "value": "EUR",
            "reasoning": "Currency explicitly stated in the commercial invoice",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 15571.197,
            "reasoning": "Total invoice value from commercial invoice (sum of both items: 14128.587 + 1442.61)",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "NL",
            "reasoning": "Netherlands - Port of discharge Rotterdam stated in all shipping documents",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "CN",
            "reasoning": "China - Port of loading Qingdao stated in all shipping documents, origin stated as China in invoice",
            "certainty": 100
        },
        "grossMass": {
            "value": 15837.9,
            "reasoning": "Total gross mass from bill of lading and commercial invoice",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "SEKU5725483",
                    "reasoning": "Container number stated in all shipping documents - 40HC container",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 14128.587,
                    "reasoning": "Invoice value for dressing table item from commercial invoice (471 units Γ— 29.997 EUR)",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Origin stated as China (Chine) in the commercial invoice",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 471,
                    "reasoning": "Quantity of dressing tables from commercial invoice",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 14083,
                    "reasoning": "Gross weight for dressing table from commercial invoice",
                    "certainty": 100
                },
                "netMass": {
                    "value": 12835,
                    "reasoning": "Net weight for dressing table from commercial invoice",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "DRESSING TABLE",
                    "reasoning": "Description from commercial invoice and bill of lading",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 471,
                        "reasoning": "Number of cartons for dressing table from commercial invoice",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Packaging type cartons (CTN) stated in bill of lading and packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9403500000",
                        "reasoning": "HS code for dressing table from commercial invoice (bedroom furniture - wooden)",
                        "certainty": 100
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "SEKU5725483",
                    "reasoning": "Same container for mixed shipment",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 1442.61,
                    "reasoning": "Invoice value for bookcase item from commercial invoice (130 units Γ— 11.097 EUR)",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Origin stated as China in the commercial invoice",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 130,
                    "reasoning": "Quantity of bookcases from commercial invoice",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 1754.9,
                    "reasoning": "Gross weight for bookcase from commercial invoice",
                    "certainty": 100
                },
                "netMass": {
                    "value": 1430,
                    "reasoning": "Net weight for bookcase from commercial invoice",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "BOOKCASE",
                    "reasoning": "Description from commercial invoice and bill of lading",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 130,
                        "reasoning": "Number of cartons for bookcase from commercial invoice",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Packaging type cartons (CTN) stated in bill of lading",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9403609000",
                        "reasoning": "HS code for bookcase from commercial invoice (other wooden furniture)",
                        "certainty": 100
                    }
                }
            }
        ]
    }
}