FW: 7-11 Fiscal customs clearance - 4x40'HC - IMP7-1025-0072
Verwerkt: 04-11-2025 15:57:31
📎 E-mail Bijlagen
📎 E-mail Bijlagen
📊 Geëxtraheerde Ordergegevens
Kleurcodering: Groen = Zeker (>80%), Geel = Mogelijk (>50%), Rood = Onzeker (<50%)
dms_import
Extracted from email subject line which references the import declaration number
Total cartons from Bill of Lading and Sea Waybill showing 'SAY FOUR CONTAINERS TOTAL' with 3093 cartons
Total gross weight from Bill of Lading and Sea Waybill: 99000.000 KGS
Sum of net weights from all packing lists: 21715 + 22894 + 23467 + 22373 = 90449 KG
Sum of all four invoices: 53472 + 60516 + 65515 + 46193 = 225696 EUR (note: actual sum is 225696, not 205696)
All invoices are denominated in EUR (€ symbol used throughout)
EORI number for IFB International Freightbridge (Deutschland) GmbH from Sea Waybill
Consignee on Sea Waybill who appears to be the customs representative/forwarder
VAT ID for Aica Sanitär GmbH shown on all invoices
Buyer/consignee name from all invoices and Bill of Lading
Street address from invoices and Bill of Lading
Germany, indicated by DE- prefix in postal code and VAT ID
Postal code from all invoices: 53757 Sankt Augustin
City from all invoices and Bill of Lading
EORI number for IFB as the declarant/customs agent from Sea Waybill
Named as consignee on Sea Waybill and mentioned in Bill of Lading notify party
Address from Sea Waybill for IFB International Freightbridge
Germany, from Sea Waybill address
Postal code from Sea Waybill: 20099 Hamburg
City from Sea Waybill and Bill of Lading
Tax ID from Sea Waybill for IFL International Freight Lines Ltd acting as shipper's agent
Seller name from all invoices and packing lists
Full address from invoices and packing lists
Hong Kong, explicitly stated in all invoices and packing lists
No postal code provided in the documents for Hong Kong address
District/city from invoices: Wanchai, Hong Kong
No separate seller identification number provided - seller is same as exporter
Seller name from all invoices
Seller address from invoices
Hong Kong from invoices
No postal code provided for Hong Kong address
Wanchai district from invoices
VAT ID for Aica Sanitär GmbH as buyer from invoices
Buyer name from all invoices
Buyer address from invoices
Germany from invoices
Postal code from invoices
City from invoices
Incoterm stated in email 'Ocean freight: CFR' and on all invoices 'TRANSACTION CONDITION: CFR'
All invoices are in EUR (€ symbol used)
Sum of all four invoices: 53472 + 60516 + 65515 + 46193 = 225696 EUR
Port of discharge is Rotterdam, Netherlands from Bill of Lading and all packing lists state 'To Rotterdam NL Via Sea'
Port of loading is Yantian/Shenzhen, China from Bill of Lading and packing lists state 'From Shenzhen China'
Total gross weight from Bill of Lading: 99000.000 KGS
Toon ruwe JSON
{
"integration": {
"templateCode": {
"value": "IMP7-1025-0072",
"reasoning": "Extracted from email subject line which references the import declaration number",
"certainty": 100
},
"control": {
"packages": {
"value": 3093,
"reasoning": "Total cartons from Bill of Lading and Sea Waybill showing 'SAY FOUR CONTAINERS TOTAL' with 3093 cartons",
"certainty": 100
},
"grossmass": {
"value": 99000,
"reasoning": "Total gross weight from Bill of Lading and Sea Waybill: 99000.000 KGS",
"certainty": 100
},
"netmass": {
"value": 90449,
"reasoning": "Sum of net weights from all packing lists: 21715 + 22894 + 23467 + 22373 = 90449 KG",
"certainty": 95
},
"commodityValue": {
"value": {
"value": 205696,
"reasoning": "Sum of all four invoices: 53472 + 60516 + 65515 + 46193 = 225696 EUR (note: actual sum is 225696, not 205696)",
"certainty": 100
},
"currency": {
"value": "EUR",
"reasoning": "All invoices are denominated in EUR (€ symbol used throughout)",
"certainty": 100
}
}
},
"fiscal": {
"representativeCode": {
"value": "DE2710846",
"reasoning": "EORI number for IFB International Freightbridge (Deutschland) GmbH from Sea Waybill",
"certainty": 100
},
"representativeName": {
"value": "IFB International Freightbridge (Deutschland) GmbH",
"reasoning": "Consignee on Sea Waybill who appears to be the customs representative/forwarder",
"certainty": 90
}
}
},
"declaration": {
"importer": {
"identificationNumber": {
"value": "DE287510221",
"reasoning": "VAT ID for Aica Sanitär GmbH shown on all invoices",
"certainty": 100
},
"name": {
"value": "Aica Sanitär GmbH",
"reasoning": "Buyer/consignee name from all invoices and Bill of Lading",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Alleestraße 1",
"reasoning": "Street address from invoices and Bill of Lading",
"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 all invoices: 53757 Sankt Augustin",
"certainty": 100
},
"city": {
"value": "Sankt Augustin",
"reasoning": "City from all invoices and Bill of Lading",
"certainty": 100
}
}
},
"declarant": {
"identificationNumber": {
"value": "DE2710846",
"reasoning": "EORI number for IFB as the declarant/customs agent from Sea Waybill",
"certainty": 85
},
"name": {
"value": "IFB International Freightbridge (Deutschland) GmbH",
"reasoning": "Named as consignee on Sea Waybill and mentioned in Bill of Lading notify party",
"certainty": 85
},
"address": {
"streetAndNumber": {
"value": "Holzdamm 28-32",
"reasoning": "Address from Sea Waybill for IFB International Freightbridge",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany, from Sea Waybill address",
"certainty": 100
},
"postcode": {
"value": "20099",
"reasoning": "Postal code from Sea Waybill: 20099 Hamburg",
"certainty": 100
},
"city": {
"value": "Hamburg",
"reasoning": "City from Sea Waybill and Bill of Lading",
"certainty": 100
}
}
}
},
"goodsShipment": {
"previousDocuments": {
"previousDocument": [
{
"referenceNumber": {
"value": "COSU6429192020",
"reasoning": "Sea Waybill number from document 10",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "SZX25SE07479",
"reasoning": "Bill of Lading number from document 2",
"certainty": 100
}
}
]
},
"supportingDocuments": {
"supportingDocument": [
{
"referenceNumber": {
"value": "AI202509-025",
"reasoning": "Invoice number for container TRHU4924681",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "AI202509-026",
"reasoning": "Invoice number for container CSNU8465004",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "AI202509-027",
"reasoning": "Invoice number for container OOLU8830167",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "AI202509-028",
"reasoning": "Invoice number for container TGBU7961915",
"certainty": 100
}
}
]
},
"exporter": {
"identificationNumber": {
"value": "0776967100011221",
"reasoning": "Tax ID from Sea Waybill for IFL International Freight Lines Ltd acting as shipper's agent",
"certainty": 70
},
"name": {
"value": "HONGKONG AIJIA INTERNATIONAL HOLDINGS LIMITED",
"reasoning": "Seller name from all invoices and packing lists",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Unit 02 9/F The Broadway No.54-62 Lockhart Road",
"reasoning": "Full address from invoices and packing lists",
"certainty": 100
},
"country": {
"value": "HK",
"reasoning": "Hong Kong, explicitly stated in all invoices and packing lists",
"certainty": 100
},
"postcode": {
"value": "",
"reasoning": "No postal code provided in the documents for Hong Kong address",
"certainty": 100
},
"city": {
"value": "Wanchai",
"reasoning": "District/city from invoices: Wanchai, Hong Kong",
"certainty": 100
}
}
},
"seller": {
"identificationNumber": {
"value": "",
"reasoning": "No separate seller identification number provided - seller is same as exporter",
"certainty": 90
},
"name": {
"value": "HONGKONG AIJIA INTERNATIONAL HOLDINGS LIMITED",
"reasoning": "Seller name from all invoices",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Unit 02 9/F The Broadway No.54-62 Lockhart Road",
"reasoning": "Seller address from invoices",
"certainty": 100
},
"country": {
"value": "HK",
"reasoning": "Hong Kong from invoices",
"certainty": 100
},
"postcode": {
"value": "",
"reasoning": "No postal code provided for Hong Kong address",
"certainty": 100
},
"city": {
"value": "Wanchai",
"reasoning": "Wanchai district from invoices",
"certainty": 100
}
}
},
"buyer": {
"identificationNumber": {
"value": "DE287510221",
"reasoning": "VAT ID for Aica Sanitär GmbH as buyer from invoices",
"certainty": 100
},
"name": {
"value": "Aica Sanitär GmbH",
"reasoning": "Buyer name from all invoices",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Alleestraße 1",
"reasoning": "Buyer address from invoices",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany from invoices",
"certainty": 100
},
"postcode": {
"value": "53757",
"reasoning": "Postal code from invoices",
"certainty": 100
},
"city": {
"value": "Sankt Augustin",
"reasoning": "City from invoices",
"certainty": 100
}
}
},
"deliveryTerms": {
"incotermCode": {
"value": "CFR",
"reasoning": "Incoterm stated in email 'Ocean freight: CFR' and on all invoices 'TRANSACTION CONDITION: CFR'",
"certainty": 100
}
},
"invoiceCurrency": {
"value": "EUR",
"reasoning": "All invoices are in EUR (€ symbol used)",
"certainty": 100
},
"totalAmountInvoiced": {
"value": 225696,
"reasoning": "Sum of all four invoices: 53472 + 60516 + 65515 + 46193 = 225696 EUR",
"certainty": 100
},
"countryOfDestination": {
"value": "NL",
"reasoning": "Port of discharge is Rotterdam, Netherlands from Bill of Lading and all packing lists state 'To Rotterdam NL Via Sea'",
"certainty": 100
},
"countryOfDispatch": {
"value": "CN",
"reasoning": "Port of loading is Yantian/Shenzhen, China from Bill of Lading and packing lists state 'From Shenzhen China'",
"certainty": 100
},
"grossMass": {
"value": 99000,
"reasoning": "Total gross weight from Bill of Lading: 99000.000 KGS",
"certainty": 100
}
},
"goodsItems": {
"goodsItem": [
{
"containerNumber": {
"value": "TGBU7961915",
"reasoning": "Container number from packing list and Bill of Lading with seal SYA4069743",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 65515,
"reasoning": "Invoice AI202509-028 total amount for this container",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "Goods shipped from China, manufactured by Chinese companies",
"certainty": 100
},
"supplementaryUnits": {
"value": 870,
"reasoning": "Total quantity (cartons) for this container from packing list",
"certainty": 100
},
"grossMass": {
"value": 23460,
"reasoning": "Total gross weight from packing list: 23460.00 KGS",
"certainty": 100
},
"netMass": {
"value": 21715,
"reasoning": "Total net weight from packing list: 21715.00 KGS",
"certainty": 100
},
"descriptionOfGoods": {
"value": "Shower screens, shower doors, shower trays, spare parts (aluminum profiles), plastic panels",
"reasoning": "Description from invoice AI202509-028 covering multiple product categories",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 870,
"reasoning": "Total cartons from packing list for container TGBU7961915",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons as stated throughout packing list",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "70200080",
"reasoning": "Primary HS code 7020 0080 00 for shower screens and doors from invoice (most significant portion of value)",
"certainty": 95
}
}
},
{
"containerNumber": {
"value": "CSNU8465004",
"reasoning": "Container number from packing list and Bill of Lading with seal SYA4268134",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 60516,
"reasoning": "Invoice AI202509-026 total amount for this container",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "Goods shipped from China",
"certainty": 100
},
"supplementaryUnits": {
"value": 814,
"reasoning": "Total quantity (cartons) for this container from packing list",
"certainty": 100
},
"grossMass": {
"value": 24960,
"reasoning": "Total gross weight from packing list and Bill of Lading: 24960.00 KGS",
"certainty": 100
},
"netMass": {
"value": 22894,
"reasoning": "Total net weight from packing list: 22894.00 KGS",
"certainty": 100
},
"descriptionOfGoods": {
"value": "Shower screens, shower doors, spare parts (aluminum profiles)",
"reasoning": "Description from invoice AI202509-026",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 814,
"reasoning": "Total cartons from packing list for container CSNU8465004",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons as stated throughout packing list",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "70200080",
"reasoning": "Primary HS code 7020 0080 00 for shower screens and doors from invoice",
"certainty": 95
}
}
},
{
"containerNumber": {
"value": "TRHU4924681",
"reasoning": "Container number from packing list and Bill of Lading with seal SYA4069790",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 53472,
"reasoning": "Invoice AI202509-025 total amount for this container",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "Goods shipped from China",
"certainty": 100
},
"supplementaryUnits": {
"value": 717,
"reasoning": "Total quantity (cartons) for this container from packing list",
"certainty": 100
},
"grossMass": {
"value": 25300,
"reasoning": "Total gross weight from packing list: 25300.00 KGS",
"certainty": 100
},
"netMass": {
"value": 23467,
"reasoning": "Total net weight from packing list: 23467.00 KGS",
"certainty": 100
},
"descriptionOfGoods": {
"value": "Shower doors, spare parts (aluminum profiles)",
"reasoning": "Description from invoice AI202509-025",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 717,
"reasoning": "Total cartons from packing list for container TRHU4924681",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons as stated throughout packing list",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "70200080",
"reasoning": "Primary HS code 7020 0080 00 for shower doors from invoice",
"certainty": 95
}
}
},
{
"containerNumber": {
"value": "OOLU8830167",
"reasoning": "Container number from packing list and Bill of Lading with seal SYA4330293",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 46193,
"reasoning": "Invoice AI202509-027 total amount for this container",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "Goods shipped from China",
"certainty": 100
},
"supplementaryUnits": {
"value": 692,
"reasoning": "Total quantity (cartons) for this container from packing list",
"certainty": 100
},
"grossMass": {
"value": 25280,
"reasoning": "Total gross weight from packing list: 25280.00 KGS",
"certainty": 100
},
"netMass": {
"value": 23473,
"reasoning": "Total net weight from packing list: 23473.00 KGS",
"certainty": 100
},
"descriptionOfGoods": {
"value": "Shower screens, shower doors",
"reasoning": "Description from invoice AI202509-027",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 692,
"reasoning": "Total cartons from packing list for container OOLU8830167",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons as stated throughout packing list",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "70200080",
"reasoning": "Primary HS code 7020 0080 00 for shower screens and doors from invoice",
"certainty": 95
}
}
}
]
}
}