CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: 19-12 Customs Instructions Import, S2504308972 Dest Rotterdam, HBL# CGOA75715, ETA: 19-12-25, SEA, ZHENGZHOU HUANERXIAN NETWORK TECHNOLOGY CO LTD

Verwerkt: 10-12-2025 14:11:51

Voltooid
Uitvoering ID: csv_69397197a09a9
Agent: Oscar

πŸ“Š GeΓ«xtraheerde Ordergegevens

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

95%

This is the main shipment reference number found consistently throughout all documents

100%

Clearly stated as '720 CTN' or '720 Carton(s)' in multiple documents including the bill of lading and customs instructions

100%

Consistently shown as 16020.000 KG or 16,020.000 KG across all shipping documents

95%

Found in the Excel invoice data as the net weight for the shipment

100%

Total value shown in the commercial invoice Excel file

100%

Currency specified in the invoice is EUR (Euro)

50%

Customs broker CSV Logistics Venlo - standard representative code needed but not explicitly provided in documents

100%

This is the customs clearance company handling the fiscal declaration as stated in the DHL cover sheet

100%

EORI number clearly stated for EXSAMIND GMBH in multiple documents

100%

Consignee name consistently shown across all shipping documents

100%

Street address shown in bill of lading and other documents

100%

Germany is the destination country

100%

Postcode clearly stated in consignee address

100%

City name shown in all consignee addresses

40%

CSV Logistics as declarant - identification number not explicitly provided in documents

95%

CSV Customs is handling the customs declaration as stated in the customs instructions

100%

Address from CSV Logistics email signature and customs instructions document

100%

Netherlands is the country where CSV Logistics Venlo is located

100%

Postcode shown in CSV address on customs instructions

100%

City shown in CSV Logistics address

30%

No Chinese company registration number provided in the documents

100%

Shipper name consistently shown across all documents

100%

Full street address from shipper details in bill of lading

100%

China is clearly the country of origin

100%

Postcode shown in shipper address

100%

City shown in shipper address, also ERQI DISTRICT, HENAN PROVINCE

30%

No separate seller identification provided - appears to be same as exporter

90%

Seller appears to be the same as shipper/exporter

90%

Using exporter address as seller address since they appear to be the same entity

90%

China as country of seller

90%

Using exporter postcode

90%

Using exporter city

95%

Using importer EORI as buyer is the same as consignee

100%

Buyer shown in invoice is EXSAMIND GMBH

100%

Buyer address from invoice matches consignee

100%

Germany is the buyer country

100%

Postcode from buyer address

100%

City from buyer address

85%

Email from Carmelo Vitale explicitly states 'Incoterm: CIF', though some documents also mention DDP

100%

Currency shown in the commercial invoice Excel file

100%

Total value from the commercial invoice for all 360 units

100%

Germany is the final destination as shown by port of discharge Rotterdam and final delivery to Wiesbaden

100%

China is the country of dispatch, specifically from Qingdao port

100%

Total gross weight shown consistently across all documents

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "S2504308972",
            "reasoning": "This is the main shipment reference number found consistently throughout all documents",
            "certainty": 95
        },
        "control": {
            "packages": {
                "value": 720,
                "reasoning": "Clearly stated as '720 CTN' or '720 Carton(s)' in multiple documents including the bill of lading and customs instructions",
                "certainty": 100
            },
            "grossmass": {
                "value": 16020,
                "reasoning": "Consistently shown as 16020.000 KG or 16,020.000 KG across all shipping documents",
                "certainty": 100
            },
            "netmass": {
                "value": 14868,
                "reasoning": "Found in the Excel invoice data as the net weight for the shipment",
                "certainty": 95
            },
            "commodityValue": {
                "value": {
                    "value": 19438.92,
                    "reasoning": "Total value shown in the commercial invoice Excel file",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Currency specified in the invoice is EUR (Euro)",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "NL001",
                "reasoning": "Customs broker CSV Logistics Venlo - standard representative code needed but not explicitly provided in documents",
                "certainty": 50
            },
            "representativeName": {
                "value": "CUSTOMS SOLUTIONS VENLO B.V.",
                "reasoning": "This is the customs clearance company handling the fiscal declaration as stated in the DHL cover sheet",
                "certainty": 100
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE724078573280054",
                "reasoning": "EORI number clearly stated for EXSAMIND GMBH in multiple documents",
                "certainty": 100
            },
            "name": {
                "value": "EXSAMIND GMBH",
                "reasoning": "Consignee name consistently shown across all shipping documents",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "ADOLFSTRASSE 1",
                    "reasoning": "Street address shown in bill of lading and other documents",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany is the destination country",
                    "certainty": 100
                },
                "postcode": {
                    "value": "65185",
                    "reasoning": "Postcode clearly stated in consignee address",
                    "certainty": 100
                },
                "city": {
                    "value": "WIESBADEN",
                    "reasoning": "City name shown in all consignee addresses",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "NL123456789",
                "reasoning": "CSV Logistics as declarant - identification number not explicitly provided in documents",
                "certainty": 40
            },
            "name": {
                "value": "CUSTOMS SOLUTIONS VENLO B.V.",
                "reasoning": "CSV Customs is handling the customs declaration as stated in the customs instructions",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "ANKERKADE 20",
                    "reasoning": "Address from CSV Logistics email signature and customs instructions document",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Netherlands is the country where CSV Logistics Venlo is located",
                    "certainty": 100
                },
                "postcode": {
                    "value": "5928 PL",
                    "reasoning": "Postcode shown in CSV address on customs instructions",
                    "certainty": 100
                },
                "city": {
                    "value": "VENLO",
                    "reasoning": "City shown in CSV Logistics address",
                    "certainty": 100
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "QGD2257830",
                        "reasoning": "Ocean Bill of Lading number shown in multiple documents",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "CGOA75715",
                        "reasoning": "House Bill of Lading number consistently referenced",
                        "certainty": 100
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "FBMEU202510440PJ6",
                        "reasoning": "Reference number from the invoice and email subject lines",
                        "certainty": 100
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": "CN-UNKNOWN",
                "reasoning": "No Chinese company registration number provided in the documents",
                "certainty": 30
            },
            "name": {
                "value": "ZHENGZHOU HUANERXIAN NETWORK TECHNOLOGY CO., LTD",
                "reasoning": "Shipper name consistently shown across all documents",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "1416, BUILDING 8, SHENGLONG INTERNATIONAL ZONE C, NO. 68, ZHENGTONG ROAD",
                    "reasoning": "Full street address from shipper details in bill of lading",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "China is clearly the country of origin",
                    "certainty": 100
                },
                "postcode": {
                    "value": "450062",
                    "reasoning": "Postcode shown in shipper address",
                    "certainty": 100
                },
                "city": {
                    "value": "ZHENGZHOU",
                    "reasoning": "City shown in shipper address, also ERQI DISTRICT, HENAN PROVINCE",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "CN-UNKNOWN",
                "reasoning": "No separate seller identification provided - appears to be same as exporter",
                "certainty": 30
            },
            "name": {
                "value": "ZHENGZHOU HUANERXIAN NETWORK TECHNOLOGY CO., LTD",
                "reasoning": "Seller appears to be the same as shipper/exporter",
                "certainty": 90
            },
            "address": {
                "streetAndNumber": {
                    "value": "1416, BUILDING 8, SHENGLONG INTERNATIONAL ZONE C, NO. 68, ZHENGTONG ROAD",
                    "reasoning": "Using exporter address as seller address since they appear to be the same entity",
                    "certainty": 90
                },
                "country": {
                    "value": "CN",
                    "reasoning": "China as country of seller",
                    "certainty": 90
                },
                "postcode": {
                    "value": "450062",
                    "reasoning": "Using exporter postcode",
                    "certainty": 90
                },
                "city": {
                    "value": "ZHENGZHOU",
                    "reasoning": "Using exporter city",
                    "certainty": 90
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "DE724078573280054",
                "reasoning": "Using importer EORI as buyer is the same as consignee",
                "certainty": 95
            },
            "name": {
                "value": "EXSAMIND GMBH",
                "reasoning": "Buyer shown in invoice is EXSAMIND GMBH",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "ADOLFSTRASSE 1",
                    "reasoning": "Buyer address from invoice matches consignee",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany is the buyer country",
                    "certainty": 100
                },
                "postcode": {
                    "value": "65185",
                    "reasoning": "Postcode from buyer address",
                    "certainty": 100
                },
                "city": {
                    "value": "WIESBADEN",
                    "reasoning": "City from buyer address",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "CIF",
                "reasoning": "Email from Carmelo Vitale explicitly states 'Incoterm: CIF', though some documents also mention DDP",
                "certainty": 85
            }
        },
        "invoiceCurrency": {
            "value": "EUR",
            "reasoning": "Currency shown in the commercial invoice Excel file",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 19438.92,
            "reasoning": "Total value from the commercial invoice for all 360 units",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "DE",
            "reasoning": "Germany is the final destination as shown by port of discharge Rotterdam and final delivery to Wiesbaden",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "CN",
            "reasoning": "China is the country of dispatch, specifically from Qingdao port",
            "certainty": 100
        },
        "grossMass": {
            "value": 16020,
            "reasoning": "Total gross weight shown consistently across all documents",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "FFAU3836553",
                    "reasoning": "Container number shown in all shipping documents",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 19438.92,
                    "reasoning": "Total invoiced amount for the dressing tables from commercial invoice",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "China specified as origin in invoice and shipping documents",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 360,
                    "reasoning": "Quantity shown in the Excel invoice as total number of dressing tables",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 16020,
                    "reasoning": "Gross weight for the entire shipment in the container",
                    "certainty": 100
                },
                "netMass": {
                    "value": 14868,
                    "reasoning": "Net weight from the Excel invoice data",
                    "certainty": 95
                },
                "descriptionOfGoods": {
                    "value": "DRESSING TABLE",
                    "reasoning": "Goods description consistently shown as 'DRESSING TABLE' across all documents",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 720,
                        "reasoning": "Total number of cartons as stated in all shipping documents",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Package type shown as CTN (cartons) in all documents",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9403500000",
                        "reasoning": "HS Code shown in Excel invoice, also referenced as 940350 in some documents",
                        "certainty": 100
                    }
                }
            }
        ]
    }
}