FW: 19-12 Customs Instructions Import, S2505197073 Dest Rotterdam, HBL# CGOA78199, ETA: 19-12-25, SEA, ZHENGZHOU HUANERXIAN NETWORK TECHNOLOGY CO LTD
Verwerkt: 15-12-2025 08:17:41
Uitvoering ID:
csv_693fb61585177
Agent:
Oscar
📎 E-mail Bijlagen
📎 E-mail Bijlagen
📊 Geëxtraheerde Ordergegevens
Kleurcodering: Groen = Zeker (>80%), Geel = Mogelijk (>50%), Rood = Onzeker (<50%)
dms_import
75%
Based on the shipment documents showing sea freight import to Rotterdam with fiscal customs clearance requirements
100%
Total number of cartons as stated in bill of lading and customs instruction document
100%
Gross mass in KG from bill of lading and shipment details
100%
Net weight in KG from Excel invoice data
100%
Total amount invoiced from Excel invoice FBMEU202510343GC7
100%
Currency specified in the Excel invoice
90%
VAT/USt.-Id.-Nr. of DHL Global Forwarding GmbH acting as fiscal representative
95%
Company handling customs clearance as mentioned in email and bill of lading
100%
EORI number of EXSAMIND GMBH from invoice and bill of lading
100%
Consignee name from all shipping documents
100%
Street address from consignee details in invoice and bill of lading
100%
Germany as destination country
100%
Postal code from consignee address
100%
City from consignee address
90%
VAT/USt.-Id.-Nr. of DHL Global Forwarding GmbH acting as declarant
95%
Company handling customs declaration based on email from Carmelo Vitale
100%
Address from DHL office details in customs instruction document
100%
Germany as country of declarant
100%
Postal code from declarant address
100%
City from declarant address
Item
N/A
Item
N/A
85%
Tax ID (USCI) mentioned in bill of lading for shipper
100%
Shipper name from all documents
100%
Full street address from shipper details
100%
China as country of origin
100%
Postal code from shipper address
100%
City from shipper address in Henan Province
85%
Tax ID of seller/shipper
100%
Seller is same as shipper based on invoice
100%
Full street address from seller details
100%
China as country of seller
100%
Postal code from seller address
100%
City from seller address
100%
EORI number of buyer EXSAMIND GMBH
100%
Buyer name from invoice, confirmed in email correspondence
100%
Street address of buyer
100%
Germany as buyer country
100%
Postal code of buyer
100%
City of buyer
100%
Incoterm specified in customs instruction email and invoice
100%
Currency specified in Excel invoice
100%
Total invoice amount from Excel invoice FBMEU202510343GC7
100%
Netherlands (Rotterdam) as port of discharge destination
100%
China (Yantian) as port of loading and origin
100%
Total gross weight in KG from bill of lading
Item
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Toon ruwe JSON
{
"integration": {
"templateCode": {
"value": "H7",
"reasoning": "Based on the shipment documents showing sea freight import to Rotterdam with fiscal customs clearance requirements",
"certainty": 75
},
"control": {
"packages": {
"value": 598,
"reasoning": "Total number of cartons as stated in bill of lading and customs instruction document",
"certainty": 100
},
"grossmass": {
"value": 16560,
"reasoning": "Gross mass in KG from bill of lading and shipment details",
"certainty": 100
},
"netmass": {
"value": 15718,
"reasoning": "Net weight in KG from Excel invoice data",
"certainty": 100
},
"commodityValue": {
"value": {
"value": 11546.103,
"reasoning": "Total amount invoiced from Excel invoice FBMEU202510343GC7",
"certainty": 100
},
"currency": {
"value": "EUR",
"reasoning": "Currency specified in the Excel invoice",
"certainty": 100
}
}
},
"fiscal": {
"representativeCode": {
"value": "DE812975416",
"reasoning": "VAT/USt.-Id.-Nr. of DHL Global Forwarding GmbH acting as fiscal representative",
"certainty": 90
},
"representativeName": {
"value": "DHL GLOBAL FORWARDING GMBH",
"reasoning": "Company handling customs clearance as mentioned in email and bill of lading",
"certainty": 95
}
}
},
"declaration": {
"importer": {
"identificationNumber": {
"value": "DE724078573280054",
"reasoning": "EORI number of EXSAMIND GMBH from invoice and bill of lading",
"certainty": 100
},
"name": {
"value": "EXSAMIND GMBH",
"reasoning": "Consignee name from all shipping documents",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "ADOLFSTR. 1",
"reasoning": "Street address from consignee details in invoice and bill of lading",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany as destination country",
"certainty": 100
},
"postcode": {
"value": "65185",
"reasoning": "Postal code from consignee address",
"certainty": 100
},
"city": {
"value": "WIESBADEN",
"reasoning": "City from consignee address",
"certainty": 100
}
}
},
"declarant": {
"identificationNumber": {
"value": "DE812975416",
"reasoning": "VAT/USt.-Id.-Nr. of DHL Global Forwarding GmbH acting as declarant",
"certainty": 90
},
"name": {
"value": "DHL GLOBAL FORWARDING GMBH",
"reasoning": "Company handling customs declaration based on email from Carmelo Vitale",
"certainty": 95
},
"address": {
"streetAndNumber": {
"value": "BRANDENBURGER STR. 2",
"reasoning": "Address from DHL office details in customs instruction document",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany as country of declarant",
"certainty": 100
},
"postcode": {
"value": "40880",
"reasoning": "Postal code from declarant address",
"certainty": 100
},
"city": {
"value": "RATINGEN",
"reasoning": "City from declarant address",
"certainty": 100
}
}
}
},
"goodsShipment": {
"previousDocuments": {
"previousDocument": [
{
"referenceNumber": {
"value": "SHZ7668976",
"reasoning": "Ocean Bill of Lading number from shipment documents",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "CGOA78199",
"reasoning": "House Bill of Lading number from all documents",
"certainty": 100
}
}
]
},
"supportingDocuments": {
"supportingDocument": [
{
"referenceNumber": {
"value": "FBMEU202510343GC7",
"reasoning": "Invoice number from Excel invoice document",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "S2505197073",
"reasoning": "Shipment document number from customs instruction",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "C2502440236",
"reasoning": "Consol number from shipment details",
"certainty": 100
}
}
]
},
"exporter": {
"identificationNumber": {
"value": "91440300723024476XQ",
"reasoning": "Tax ID (USCI) mentioned in bill of lading for shipper",
"certainty": 85
},
"name": {
"value": "ZHENGZHOU HUANERXIAN NETWORK TECHNOLOGY CO., LTD",
"reasoning": "Shipper name from all documents",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "NO.68 ZHENGTONG ROAD, 1416, BUILDING 8, SHENGLONG INTERNATIONAL ZONE C, ERQI DISTRICT",
"reasoning": "Full street address from shipper details",
"certainty": 100
},
"country": {
"value": "CN",
"reasoning": "China as country of origin",
"certainty": 100
},
"postcode": {
"value": "450062",
"reasoning": "Postal code from shipper address",
"certainty": 100
},
"city": {
"value": "ZHENGZHOU",
"reasoning": "City from shipper address in Henan Province",
"certainty": 100
}
}
},
"seller": {
"identificationNumber": {
"value": "91440300723024476XQ",
"reasoning": "Tax ID of seller/shipper",
"certainty": 85
},
"name": {
"value": "ZHENGZHOU HUANERXIAN NETWORK TECHNOLOGY CO., LTD",
"reasoning": "Seller is same as shipper based on invoice",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "NO.68 ZHENGTONG ROAD, 1416, BUILDING 8, SHENGLONG INTERNATIONAL ZONE C, ERQI DISTRICT",
"reasoning": "Full street address from seller details",
"certainty": 100
},
"country": {
"value": "CN",
"reasoning": "China as country of seller",
"certainty": 100
},
"postcode": {
"value": "450062",
"reasoning": "Postal code from seller address",
"certainty": 100
},
"city": {
"value": "ZHENGZHOU",
"reasoning": "City from seller address",
"certainty": 100
}
}
},
"buyer": {
"identificationNumber": {
"value": "DE724078573280054",
"reasoning": "EORI number of buyer EXSAMIND GMBH",
"certainty": 100
},
"name": {
"value": "EXSAMIND GMBH",
"reasoning": "Buyer name from invoice, confirmed in email correspondence",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "ADOLFSTR. 1",
"reasoning": "Street address of buyer",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany as buyer country",
"certainty": 100
},
"postcode": {
"value": "65185",
"reasoning": "Postal code of buyer",
"certainty": 100
},
"city": {
"value": "WIESBADEN",
"reasoning": "City of buyer",
"certainty": 100
}
}
},
"deliveryTerms": {
"incotermCode": {
"value": "CIF",
"reasoning": "Incoterm specified in customs instruction email and invoice",
"certainty": 100
}
},
"invoiceCurrency": {
"value": "EUR",
"reasoning": "Currency specified in Excel invoice",
"certainty": 100
},
"totalAmountInvoiced": {
"value": 11546.103,
"reasoning": "Total invoice amount from Excel invoice FBMEU202510343GC7",
"certainty": 100
},
"countryOfDestination": {
"value": "NL",
"reasoning": "Netherlands (Rotterdam) as port of discharge destination",
"certainty": 100
},
"countryOfDispatch": {
"value": "CN",
"reasoning": "China (Yantian) as port of loading and origin",
"certainty": 100
},
"grossMass": {
"value": 16560,
"reasoning": "Total gross weight in KG from bill of lading",
"certainty": 100
}
},
"goodsItems": {
"goodsItem": [
{
"containerNumber": {
"value": "CAIU9019842",
"reasoning": "Container number from bill of lading and shipment details",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 2861.682,
"reasoning": "Total value for first dressing table item (106 units x 26.997 EUR)",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "China as origin country stated in invoice",
"certainty": 100
},
"supplementaryUnits": {
"value": 106,
"reasoning": "Quantity of first dressing table item from invoice",
"certainty": 100
},
"grossMass": {
"value": 6207,
"reasoning": "Gross weight in KG for first item from invoice",
"certainty": 100
},
"netMass": {
"value": 5585,
"reasoning": "Net weight in KG for first item from invoice",
"certainty": 100
},
"descriptionOfGoods": {
"value": "DRESSING TABLE - PARTICLEBOARD, MDF, GLASS",
"reasoning": "Product description and material from invoice for item 135103XEUV1",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 106,
"reasoning": "Number of packages matching quantity for first item",
"certainty": 95
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons as packaging type from bill of lading",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "9403500000",
"reasoning": "HS code for dressing table from invoice",
"certainty": 100
}
}
},
{
"containerNumber": {
"value": "CAIU9019842",
"reasoning": "Same container for all items in this shipment",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 8684.421,
"reasoning": "Total value for second dressing table item (193 units x 44.997 EUR)",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "China as origin country stated in invoice",
"certainty": 100
},
"supplementaryUnits": {
"value": 193,
"reasoning": "Quantity of second dressing table item from invoice",
"certainty": 100
},
"grossMass": {
"value": 10353,
"reasoning": "Gross weight in KG for second item from invoice",
"certainty": 100
},
"netMass": {
"value": 10133,
"reasoning": "Net weight in KG for second item from invoice",
"certainty": 100
},
"descriptionOfGoods": {
"value": "DRESSING TABLE - PARTICLEBOARD, MDF, GLASS",
"reasoning": "Product description and material from invoice for item DT42003XEU",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 193,
"reasoning": "Number of packages matching quantity for second item",
"certainty": 95
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons as packaging type from bill of lading",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "9403500000",
"reasoning": "HS code for dressing table from invoice",
"certainty": 100
}
}
}
]
}
}