FW: Fiscal customs clearance - 2x40'HC - IMP7-1125-0075
Verwerkt: 25-11-2025 08:37:11
📎 E-mail Bijlagen
📎 E-mail Bijlagen
📊 Geëxtraheerde Ordergegevens
Kleurcodering: Groen = Zeker (>80%), Geel = Mogelijk (>50%), Rood = Onzeker (<50%)
dms_import
Found in email subject line as the import reference number
Total number of cartons across both containers as stated in Bill of Lading and IFB invoice
Total gross weight in KG from Bill of Lading and IFB invoice (sum of both containers: 24120 + 25150)
Total net weight in KG from packing lists (22300 + 23272)
Sum of both invoices: €53,969.00 + €51,238.00
Both commercial invoices are denominated in EUR with € symbol
CSV Logistics is mentioned as the customs clearance handler in the email chain from customs@csv-logistics.com
CSV customs handling the fiscal customs clearance based on email metadata and signature
VAT ID stated on both commercial invoices for AICA SANITAER GMBH
Consignee name consistently stated across all documents
Street address from commercial invoices and packing lists
Germany - indicated by DE prefix in postal code and VAT ID
Postal code from importer address on all documents
City from importer address on commercial invoices and packing lists
VAT ID for IFB International Freightbridge (Deutschland) GmbH shown on Sea Waybill and IFB documents
Freight forwarder handling the import based on email communication and documents
Address from Sea Waybill and IFB documents
Germany - location of IFB Deutschland branch
Postal code for IFB Hamburg office from Sea Waybill
City from IFB Deutschland address on Sea Waybill
No identification number provided for the exporter in the documents
Shipper name from all commercial documents and Bill of Lading
Complete street address from commercial invoices and packing lists
China - explicitly stated in all exporter addresses
No postal code provided for the Chinese exporter address
City and province information from exporter address on all documents
Seller appears to be same as exporter, no separate ID provided
Same entity as exporter based on document structure
Same as exporter address
China - same as exporter
No postal code provided
Same as exporter address
Same as importer - VAT ID from commercial invoices
Same as importer, listed as buyer on commercial invoices
Same as importer address
Germany - same as importer
Same as importer postal code
Same as importer city
Stated in email from Fenja Beusse: 'Ocean freight: FOB'. Also mentioned in packing lists and invoices as 'FOB Yantian China'
Both commercial invoices denominated in EUR (€ symbol used)
Sum of invoice YYQ2509-01 (€53,969.00) and YYQ2509-02 (€51,238.00)
Rotterdam, Netherlands is the destination port stated on all shipping documents
China - shipped from Yantian/Shenzhen China according to all documents
Total gross mass in KG from Bill of Lading and IFB invoice
Toon ruwe JSON
{
"integration": {
"templateCode": {
"value": "IMP7-1125-0075",
"reasoning": "Found in email subject line as the import reference number",
"certainty": 100
},
"control": {
"packages": {
"value": 1563,
"reasoning": "Total number of cartons across both containers as stated in Bill of Lading and IFB invoice",
"certainty": 100
},
"grossmass": {
"value": 49270,
"reasoning": "Total gross weight in KG from Bill of Lading and IFB invoice (sum of both containers: 24120 + 25150)",
"certainty": 100
},
"netmass": {
"value": 45572,
"reasoning": "Total net weight in KG from packing lists (22300 + 23272)",
"certainty": 100
},
"commodityValue": {
"value": {
"value": 105207,
"reasoning": "Sum of both invoices: €53,969.00 + €51,238.00",
"certainty": 100
},
"currency": {
"value": "EUR",
"reasoning": "Both commercial invoices are denominated in EUR with € symbol",
"certainty": 100
}
}
},
"fiscal": {
"representativeCode": {
"value": "CSV",
"reasoning": "CSV Logistics is mentioned as the customs clearance handler in the email chain from customs@csv-logistics.com",
"certainty": 90
},
"representativeName": {
"value": "CSV Logistics",
"reasoning": "CSV customs handling the fiscal customs clearance based on email metadata and signature",
"certainty": 95
}
}
},
"declaration": {
"importer": {
"identificationNumber": {
"value": "DE287510221",
"reasoning": "VAT ID stated on both commercial invoices for AICA SANITAER GMBH",
"certainty": 100
},
"name": {
"value": "AICA SANITAER GMBH",
"reasoning": "Consignee name consistently stated across all documents",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Alleestraße 1",
"reasoning": "Street address from commercial invoices and packing lists",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany - indicated by DE prefix in postal code and VAT ID",
"certainty": 100
},
"postcode": {
"value": "53757",
"reasoning": "Postal code from importer address on all documents",
"certainty": 100
},
"city": {
"value": "Sankt Augustin",
"reasoning": "City from importer address on commercial invoices and packing lists",
"certainty": 100
}
}
},
"declarant": {
"identificationNumber": {
"value": "DE118666108",
"reasoning": "VAT ID for IFB International Freightbridge (Deutschland) GmbH shown on Sea Waybill and IFB documents",
"certainty": 95
},
"name": {
"value": "IFB International Freightbridge (Deutschland) GmbH",
"reasoning": "Freight forwarder handling the import based on email communication and documents",
"certainty": 95
},
"address": {
"streetAndNumber": {
"value": "Holzdamm 28-32",
"reasoning": "Address from Sea Waybill and IFB documents",
"certainty": 95
},
"country": {
"value": "DE",
"reasoning": "Germany - location of IFB Deutschland branch",
"certainty": 100
},
"postcode": {
"value": "20099",
"reasoning": "Postal code for IFB Hamburg office from Sea Waybill",
"certainty": 95
},
"city": {
"value": "Hamburg",
"reasoning": "City from IFB Deutschland address on Sea Waybill",
"certainty": 95
}
}
}
},
"goodsShipment": {
"previousDocuments": {
"previousDocument": [
{
"referenceNumber": {
"value": "OS25-0811D-1",
"reasoning": "Reference number from invoice YYQ2509-01",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "OS25-0811D-2",
"reasoning": "Reference number from invoice YYQ2509-02",
"certainty": 100
}
}
]
},
"supportingDocuments": {
"supportingDocument": [
{
"referenceNumber": {
"value": "YYQ2509-01",
"reasoning": "Commercial invoice number for first container",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "YYQ2509-02",
"reasoning": "Commercial invoice number for second container",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "SZX25SE08029",
"reasoning": "House Bill of Lading number from Bill of Lading and IFB invoice",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "COSU9504020550",
"reasoning": "Ocean Bill of Lading number from Bill of Lading and Sea Waybill",
"certainty": 100
}
}
]
},
"exporter": {
"identificationNumber": {
"value": "",
"reasoning": "No identification number provided for the exporter in the documents",
"certainty": 0
},
"name": {
"value": "CHANGSHU YIYINGQUAN FIRM",
"reasoning": "Shipper name from all commercial documents and Bill of Lading",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Store No.4219-543, 4th Floor, Garment City Hardware Market, No.9 Baixue Road",
"reasoning": "Complete street address from commercial invoices and packing lists",
"certainty": 100
},
"country": {
"value": "CN",
"reasoning": "China - explicitly stated in all exporter addresses",
"certainty": 100
},
"postcode": {
"value": "",
"reasoning": "No postal code provided for the Chinese exporter address",
"certainty": 0
},
"city": {
"value": "Changshu City, Suzhou City, Jiangsu Province",
"reasoning": "City and province information from exporter address on all documents",
"certainty": 100
}
}
},
"seller": {
"identificationNumber": {
"value": "",
"reasoning": "Seller appears to be same as exporter, no separate ID provided",
"certainty": 70
},
"name": {
"value": "CHANGSHU YIYINGQUAN FIRM",
"reasoning": "Same entity as exporter based on document structure",
"certainty": 90
},
"address": {
"streetAndNumber": {
"value": "Store No.4219-543, 4th Floor, Garment City Hardware Market, No.9 Baixue Road",
"reasoning": "Same as exporter address",
"certainty": 90
},
"country": {
"value": "CN",
"reasoning": "China - same as exporter",
"certainty": 90
},
"postcode": {
"value": "",
"reasoning": "No postal code provided",
"certainty": 0
},
"city": {
"value": "Changshu City, Suzhou City, Jiangsu Province",
"reasoning": "Same as exporter address",
"certainty": 90
}
}
},
"buyer": {
"identificationNumber": {
"value": "DE287510221",
"reasoning": "Same as importer - VAT ID from commercial invoices",
"certainty": 95
},
"name": {
"value": "AICA SANITAER GMBH",
"reasoning": "Same as importer, listed as buyer on commercial invoices",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Alleestraße 1",
"reasoning": "Same as importer address",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany - same as importer",
"certainty": 100
},
"postcode": {
"value": "53757",
"reasoning": "Same as importer postal code",
"certainty": 100
},
"city": {
"value": "Sankt Augustin",
"reasoning": "Same as importer city",
"certainty": 100
}
}
},
"deliveryTerms": {
"incotermCode": {
"value": "FOB",
"reasoning": "Stated in email from Fenja Beusse: 'Ocean freight: FOB'. Also mentioned in packing lists and invoices as 'FOB Yantian China'",
"certainty": 100
}
},
"invoiceCurrency": {
"value": "EUR",
"reasoning": "Both commercial invoices denominated in EUR (€ symbol used)",
"certainty": 100
},
"totalAmountInvoiced": {
"value": 105207,
"reasoning": "Sum of invoice YYQ2509-01 (€53,969.00) and YYQ2509-02 (€51,238.00)",
"certainty": 100
},
"countryOfDestination": {
"value": "NL",
"reasoning": "Rotterdam, Netherlands is the destination port stated on all shipping documents",
"certainty": 100
},
"countryOfDispatch": {
"value": "CN",
"reasoning": "China - shipped from Yantian/Shenzhen China according to all documents",
"certainty": 100
},
"grossMass": {
"value": 49270,
"reasoning": "Total gross mass in KG from Bill of Lading and IFB invoice",
"certainty": 100
}
},
"goodsItems": {
"goodsItem": [
{
"containerNumber": {
"value": "CSNU5732452",
"reasoning": "First container number from Bill of Lading and packing list",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 53969,
"reasoning": "Total amount from invoice YYQ2509-01 for this container",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "China - manufactured and shipped from China",
"certainty": 100
},
"supplementaryUnits": {
"value": 759,
"reasoning": "Number of cartons/sets in this container from invoice and packing list",
"certainty": 100
},
"grossMass": {
"value": 24120,
"reasoning": "Gross weight for container CSNU5732452 from Bill of Lading",
"certainty": 100
},
"netMass": {
"value": 22300,
"reasoning": "Net weight for container CSNU5732452 from packing list and invoice",
"certainty": 100
},
"descriptionOfGoods": {
"value": "SHOWER SCREENS, SHOWER DOORS, SPARE PARTS (Aluminum profiles)",
"reasoning": "Description from invoice YYQ2509-01 covering the goods in this container",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 759,
"reasoning": "Number of cartons stated in packing list and invoice for this container",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons as stated in Bill of Lading and packing lists",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "7020008000",
"reasoning": "Primary HS code for shower screens and doors from invoice YYQ2509-01",
"certainty": 90
}
}
},
{
"containerNumber": {
"value": "OOCU8301779",
"reasoning": "Second container number from Bill of Lading and packing list",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 51238,
"reasoning": "Total amount from invoice YYQ2509-02 for this container",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "China - manufactured and shipped from China",
"certainty": 100
},
"supplementaryUnits": {
"value": 804,
"reasoning": "Number of cartons/sets in this container from invoice and packing list",
"certainty": 100
},
"grossMass": {
"value": 25150,
"reasoning": "Gross weight for container OOCU8301779 from Bill of Lading",
"certainty": 100
},
"netMass": {
"value": 23272,
"reasoning": "Net weight for container OOCU8301779 from packing list and invoice",
"certainty": 100
},
"descriptionOfGoods": {
"value": "SHOWER SCREENS, SHOWER DOORS",
"reasoning": "Description from invoice YYQ2509-02 covering the goods in this container",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 804,
"reasoning": "Number of cartons stated in packing list and invoice for this container",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons as stated in Bill of Lading and packing lists",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "7020008000",
"reasoning": "HS code for shower screens and doors from invoice YYQ2509-02",
"certainty": 90
}
}
}
]
}
}