Fiskalverzollung DUS525004362
Verwerkt: 28-11-2025 15:36:51
Uitvoering ID:
csv_6929b38367ba1
Agent:
Oscar
📎 E-mail Bijlagen
📎 E-mail Bijlagen
📊 Geëxtraheerde Ordergegevens
Kleurcodering: Groen = Zeker (>80%), Geel = Mogelijk (>50%), Rood = Onzeker (<50%)
dms_import
85%
Based on the context of import customs clearance request for container goods arriving in Rotterdam port with fiscal representation requirements
100%
Total packages for container YMLU8877279 as specified in the packing list and container summary documentation
100%
Gross weight in KGS for container YMLU8877279 from the container summary table: 5250.100 KGS
95%
Net weight calculated from the packing list for container YMLU8877279 showing TTL N.W. across all items
80%
Sum of all invoice values for container YMLU8877279: KT35279 ($10,814.20) + KT35276 (€6,500.00 ~$6,500) + KT35273 ($17,161.92) + KT35278-YMLU ($9,693.09) = approximately $44,169.21 total, need to convert EUR to USD
90%
Majority of invoices are in USD, with FOB pricing in USD specified in the email (USD 1990 freight)
100%
HPI customs number/EORI number consistently referenced across all customs documents as DE 4562526
100%
The importer company name appearing as consignee on all documents and requesting customs clearance
100%
VAT ID number (Ust-ID-Nr.) from HOME PRODUCT IMPORT GmbH letterhead on all documents
100%
Company name from all shipping documents and letterheads as consignee
100%
Street address from company letterhead and B/L consignee information
100%
Germany - indicated by postal code, city, and D- prefix in address
100%
Postal code from company letterhead and B/L consignee address
100%
City from company letterhead and B/L consignee address
95%
VAT ID from MBS Logistics GmbH (the customs broker handling the clearance) from email footer
100%
Company requested to handle customs clearance as stated in the documents and email
100%
Address from B/L delivery instructions and email contact information for Sebastian Wild at MBS Logistics
100%
Germany - from the full address in B/L and email
100%
Postal code from MBS Logistics address in B/L and correspondence
100%
City from MBS Logistics address in B/L and correspondence
Item
N/A
Item
N/A
60%
Chinese exporter without specific tax ID visible in documents, using country code
100%
Shipper name from Bill of Lading and Certificate of Origin documents
100%
Street address from Bill of Lading shipper information
100%
China - from shipper address on B/L and Certificate of Origin
100%
Postal code from shipper address on B/L
100%
City and province from shipper address on B/L
70%
Hong Kong company J&R Electronics appears on invoices as supplier
100%
Seller/supplier name from commercial invoices
100%
Address from commercial invoices
100%
Hong Kong - from invoice address N.T., HK, CHINA
50%
No postal code visible in Hong Kong address on invoices
100%
City from invoice address (HK, CHINA)
100%
Same as importer - HOME PRODUCT IMPORT GmbH VAT ID
100%
Buyer on all commercial invoices
100%
Address from invoices and company documents
100%
Germany - from invoice address
100%
Postal code from invoice address
100%
City from invoice address
100%
Delivery terms FOB Yantian as stated in the email: 'Die Lieferbedingung ist FOB Yantian'
95%
Primary currency used in invoices for container YMLU8877279, with freight costs also in USD
85%
Sum of USD invoice values for YMLU8877279: $10,814.20 (KT35279) + $17,161.92 (KT35273) + $9,693.09 (KT35278) + EUR 6,500 needs conversion (KT35276)
100%
Netherlands - Rotterdam (RTM) is the destination port for customs clearance as stated in email
100%
China - port of loading is Yantian (YTN) and shipper is in China
100%
Total gross mass for container YMLU8877279 from container summary: 5250.100 KGS
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 context of import customs clearance request for container goods arriving in Rotterdam port with fiscal representation requirements",
"certainty": 85
},
"control": {
"packages": {
"value": 1000,
"reasoning": "Total packages for container YMLU8877279 as specified in the packing list and container summary documentation",
"certainty": 100
},
"grossmass": {
"value": 5250.1,
"reasoning": "Gross weight in KGS for container YMLU8877279 from the container summary table: 5250.100 KGS",
"certainty": 100
},
"netmass": {
"value": 4031.54,
"reasoning": "Net weight calculated from the packing list for container YMLU8877279 showing TTL N.W. across all items",
"certainty": 95
},
"commodityValue": {
"value": {
"value": 39483.21,
"reasoning": "Sum of all invoice values for container YMLU8877279: KT35279 ($10,814.20) + KT35276 (€6,500.00 ~$6,500) + KT35273 ($17,161.92) + KT35278-YMLU ($9,693.09) = approximately $44,169.21 total, need to convert EUR to USD",
"certainty": 80
},
"currency": {
"value": "USD",
"reasoning": "Majority of invoices are in USD, with FOB pricing in USD specified in the email (USD 1990 freight)",
"certainty": 90
}
}
},
"fiscal": {
"representativeCode": {
"value": "DE4562526",
"reasoning": "HPI customs number/EORI number consistently referenced across all customs documents as DE 4562526",
"certainty": 100
},
"representativeName": {
"value": "HOME PRODUCT IMPORT GmbH",
"reasoning": "The importer company name appearing as consignee on all documents and requesting customs clearance",
"certainty": 100
}
}
},
"declaration": {
"importer": {
"identificationNumber": {
"value": "DE813007000",
"reasoning": "VAT ID number (Ust-ID-Nr.) from HOME PRODUCT IMPORT GmbH letterhead on all documents",
"certainty": 100
},
"name": {
"value": "HOME PRODUCT IMPORT GmbH",
"reasoning": "Company name from all shipping documents and letterheads as consignee",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Graf-Zeppelin-Str. 5",
"reasoning": "Street address from company letterhead and B/L consignee information",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany - indicated by postal code, city, and D- prefix in address",
"certainty": 100
},
"postcode": {
"value": "46149",
"reasoning": "Postal code from company letterhead and B/L consignee address",
"certainty": 100
},
"city": {
"value": "Oberhausen",
"reasoning": "City from company letterhead and B/L consignee address",
"certainty": 100
}
}
},
"declarant": {
"identificationNumber": {
"value": "DE811420285",
"reasoning": "VAT ID from MBS Logistics GmbH (the customs broker handling the clearance) from email footer",
"certainty": 95
},
"name": {
"value": "MBS Logistics GmbH",
"reasoning": "Company requested to handle customs clearance as stated in the documents and email",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Hansestr. 57",
"reasoning": "Address from B/L delivery instructions and email contact information for Sebastian Wild at MBS Logistics",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany - from the full address in B/L and email",
"certainty": 100
},
"postcode": {
"value": "51149",
"reasoning": "Postal code from MBS Logistics address in B/L and correspondence",
"certainty": 100
},
"city": {
"value": "Köln",
"reasoning": "City from MBS Logistics address in B/L and correspondence",
"certainty": 100
}
}
}
},
"goodsShipment": {
"previousDocuments": {
"previousDocument": [
{
"referenceNumber": {
"value": "JRH2090625",
"reasoning": "Invoice number from KT35279 customs clearance request for goods in container YMLU8877279",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "JRH2010625",
"reasoning": "Invoice number from KT35276 customs clearance request for goods in container YMLU8877279",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "JRH2080625",
"reasoning": "Invoice number from KT35273 customs clearance request for goods in container YMLU8877279",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "JRH2070625",
"reasoning": "Invoice number from KT35278 customs clearance request for goods in container YMLU8877279",
"certainty": 100
}
}
]
},
"supportingDocuments": {
"supportingDocument": [
{
"referenceNumber": {
"value": "MSZOE25019161",
"reasoning": "Bill of Lading number referenced in KT35279 document for this container",
"certainty": 100
}
},
{
"referenceNumber": {
"value": "MSZOE2509161",
"reasoning": "Bill of Lading number referenced in KT35276, KT35273, and KT35278 documents (slightly different format but same B/L)",
"certainty": 100
}
}
]
},
"exporter": {
"identificationNumber": {
"value": "CN",
"reasoning": "Chinese exporter without specific tax ID visible in documents, using country code",
"certainty": 60
},
"name": {
"value": "ZHONGSHAN DISON LIGHTING CO.,LTD",
"reasoning": "Shipper name from Bill of Lading and Certificate of Origin documents",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Building 1, Xianglong Optoelectronics Industrial Park, No.7 Lefeng 2nd Road, Henglan Town",
"reasoning": "Street address from Bill of Lading shipper information",
"certainty": 100
},
"country": {
"value": "CN",
"reasoning": "China - from shipper address on B/L and Certificate of Origin",
"certainty": 100
},
"postcode": {
"value": "528478",
"reasoning": "Postal code from shipper address on B/L",
"certainty": 100
},
"city": {
"value": "Zhongshan City, Guangdong Province",
"reasoning": "City and province from shipper address on B/L",
"certainty": 100
}
}
},
"seller": {
"identificationNumber": {
"value": "HK",
"reasoning": "Hong Kong company J&R Electronics appears on invoices as supplier",
"certainty": 70
},
"name": {
"value": "J&R ELECTRONICS (H.K.) CO., LTD",
"reasoning": "Seller/supplier name from commercial invoices",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "RM 706, 7/F., Seapower Centre, 73-77 Lemuk Road, Kwai Chung",
"reasoning": "Address from commercial invoices",
"certainty": 100
},
"country": {
"value": "HK",
"reasoning": "Hong Kong - from invoice address N.T., HK, CHINA",
"certainty": 100
},
"postcode": {
"value": "",
"reasoning": "No postal code visible in Hong Kong address on invoices",
"certainty": 50
},
"city": {
"value": "Hong Kong",
"reasoning": "City from invoice address (HK, CHINA)",
"certainty": 100
}
}
},
"buyer": {
"identificationNumber": {
"value": "DE813007000",
"reasoning": "Same as importer - HOME PRODUCT IMPORT GmbH VAT ID",
"certainty": 100
},
"name": {
"value": "HOME PRODUCT IMPORT GmbH",
"reasoning": "Buyer on all commercial invoices",
"certainty": 100
},
"address": {
"streetAndNumber": {
"value": "Graf-Zeppelin-Str. 5",
"reasoning": "Address from invoices and company documents",
"certainty": 100
},
"country": {
"value": "DE",
"reasoning": "Germany - from invoice address",
"certainty": 100
},
"postcode": {
"value": "46149",
"reasoning": "Postal code from invoice address",
"certainty": 100
},
"city": {
"value": "Oberhausen",
"reasoning": "City from invoice address",
"certainty": 100
}
}
},
"deliveryTerms": {
"incotermCode": {
"value": "FOB",
"reasoning": "Delivery terms FOB Yantian as stated in the email: 'Die Lieferbedingung ist FOB Yantian'",
"certainty": 100
}
},
"invoiceCurrency": {
"value": "USD",
"reasoning": "Primary currency used in invoices for container YMLU8877279, with freight costs also in USD",
"certainty": 95
},
"totalAmountInvoiced": {
"value": 38169.21,
"reasoning": "Sum of USD invoice values for YMLU8877279: $10,814.20 (KT35279) + $17,161.92 (KT35273) + $9,693.09 (KT35278) + EUR 6,500 needs conversion (KT35276)",
"certainty": 85
},
"countryOfDestination": {
"value": "NL",
"reasoning": "Netherlands - Rotterdam (RTM) is the destination port for customs clearance as stated in email",
"certainty": 100
},
"countryOfDispatch": {
"value": "CN",
"reasoning": "China - port of loading is Yantian (YTN) and shipper is in China",
"certainty": 100
},
"grossMass": {
"value": 5250.1,
"reasoning": "Total gross mass for container YMLU8877279 from container summary: 5250.100 KGS",
"certainty": 100
}
},
"goodsItems": {
"goodsItem": [
{
"containerNumber": {
"value": "YMLU8877279",
"reasoning": "Container number specified in email and all documents as the container to be cleared",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 9329.5,
"reasoning": "Invoice amount for floor lamps from document KT35279",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "Country of origin China from Certificate of Origin documents",
"certainty": 100
},
"supplementaryUnits": {
"value": 470,
"reasoning": "Number of pieces for floor lamps (item 180.004537) from invoice",
"certainty": 100
},
"grossMass": {
"value": 1739,
"reasoning": "Total gross weight for floor lamps from invoice: 1739.00 KGS",
"certainty": 100
},
"netMass": {
"value": 1363,
"reasoning": "Total net weight for floor lamps from invoice: 1363.00 KGS",
"certainty": 100
},
"descriptionOfGoods": {
"value": "INDOOR FLOOR LAMP, E27/230V, METAL, FOR INDOOR LIGHTING",
"reasoning": "Description from packing list and commercial invoice for floor lamps",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 470,
"reasoning": "470 cartons for floor lamps as per invoice and packing list",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons (CTN) as indicated in all packing lists",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "9405299090",
"reasoning": "HS code for floor lamps (Stehleuchte aus Metall) from customs clearance instructions in KT35279",
"certainty": 100
}
}
},
{
"containerNumber": {
"value": "YMLU8877279",
"reasoning": "Container number specified in email and all documents",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 1484.7,
"reasoning": "Invoice amount for pendant lamps from document KT35279",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "Country of origin China from Certificate of Origin",
"certainty": 100
},
"supplementaryUnits": {
"value": 70,
"reasoning": "Number of pieces for pendant lamps (item 180.004663) from invoice",
"certainty": 100
},
"grossMass": {
"value": 280,
"reasoning": "Total gross weight for pendant lamps from invoice: 280.00 KGS",
"certainty": 100
},
"netMass": {
"value": 203,
"reasoning": "Total net weight for pendant lamps from invoice: 203.00 KGS",
"certainty": 100
},
"descriptionOfGoods": {
"value": "INDOOR HANGING LAMP, E27/230V, METAL, FOR INDOOR LIGHTING",
"reasoning": "Description from packing list for pendant/hanging lamps",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 70,
"reasoning": "70 cartons for pendant lamps as per invoice and packing list",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons (CTN) as indicated in packing lists",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "9405199090",
"reasoning": "HS code for pendant/hanging lamps (Pendelleuchte aus Metall) from customs clearance instructions in KT35279",
"certainty": 100
}
}
},
{
"containerNumber": {
"value": "YMLU8877279",
"reasoning": "Container number from documents",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 6500,
"reasoning": "Invoice amount in EUR for LED ceiling lamps from document KT35276",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "Country of origin China from Certificate of Origin",
"certainty": 100
},
"supplementaryUnits": {
"value": 200,
"reasoning": "Number of pieces for LED ceiling lamps (item MXC2056) from invoice KT35276",
"certainty": 100
},
"grossMass": {
"value": 1160,
"reasoning": "Total gross weight for LED ceiling lamps from invoice KT35276: 1160.00 KGS",
"certainty": 100
},
"netMass": {
"value": 1020,
"reasoning": "Total net weight for LED ceiling lamps from invoice KT35276: 1020.00 KGS",
"certainty": 100
},
"descriptionOfGoods": {
"value": "INDOOR LED CEILING LAMP, LED/230V, METAL+ACYLIC, FOR INDOOR LIGHTING",
"reasoning": "Description from packing list and customs clearance documents for LED ceiling lamps",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 200,
"reasoning": "200 cartons as per invoice and packing list KT35276",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons (CTN) as indicated in packing lists",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "9405119090",
"reasoning": "HS code for LED ceiling lamps from customs clearance instructions",
"certainty": 100
}
}
},
{
"containerNumber": {
"value": "YMLU8877279",
"reasoning": "Container number from documents",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 17161.92,
"reasoning": "Total invoice amount for LED lamps from document KT35273",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "Country of origin China from Certificate of Origin",
"certainty": 100
},
"supplementaryUnits": {
"value": 161,
"reasoning": "Total number of pieces from invoice KT35273 (sum of all items: 124+144+162+174+140+108 visible items)",
"certainty": 90
},
"grossMass": {
"value": 990,
"reasoning": "Total gross weight from packing list KT35273: 990.00 KGS (approximately from 7422.04 shown)",
"certainty": 85
},
"netMass": {
"value": 757.4,
"reasoning": "Total net weight from packing list KT35273: 757.40 KGS (approximately from 4988.54 shown)",
"certainty": 85
},
"descriptionOfGoods": {
"value": "LED CEILING LAMPS AND LED SPOT LIGHTS, LED/230V, METAL+ACYLIC, FOR INDOOR LIGHTING",
"reasoning": "Description from customs clearance documents KT35273 covering multiple LED ceiling lamp and spotlight items",
"certainty": 95
},
"packaging": {
"numberOfPackages": {
"value": 161,
"reasoning": "Total cartons from packing list KT35273 for LED ceiling lamps and spotlights (58 CTN ceiling + 103 CTN spotlights)",
"certainty": 90
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons (CTN) as indicated in packing lists",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "9405119090",
"reasoning": "HS code 9405 1190 900 for LED ceiling lamps and spotlights from customs clearance instructions KT35273",
"certainty": 100
}
}
},
{
"containerNumber": {
"value": "YMLU8877279",
"reasoning": "Container number from documents KT35278",
"certainty": 100
},
"itemAmountInvoiced": {
"value": 9693.09,
"reasoning": "Invoice amount for LED ceiling lamps from document KT35278 for container YMLU8877279",
"certainty": 100
},
"countryOfOrigin": {
"value": "CN",
"reasoning": "Country of origin China from Certificate of Origin",
"certainty": 100
},
"supplementaryUnits": {
"value": 99,
"reasoning": "Total number of cartons/pieces for container YMLU8877279 from KT35278 (99 CTN)",
"certainty": 100
},
"grossMass": {
"value": 1112.1,
"reasoning": "Gross weight for LED ceiling lamps in YMLU8877279 from packing list: 1112.1 KGS",
"certainty": 100
},
"netMass": {
"value": 957,
"reasoning": "Net weight for LED ceiling lamps in YMLU8877279 from packing list: approximately 957 KGS",
"certainty": 90
},
"descriptionOfGoods": {
"value": "INDOOR LED CEILING LAMPS, LED/230V, METAL+ACYLIC, FOR INDOOR LIGHTING",
"reasoning": "Description from packing list KT35278 for LED ceiling lamps in container YMLU8877279",
"certainty": 100
},
"packaging": {
"numberOfPackages": {
"value": 99,
"reasoning": "99 cartons for LED ceiling lamps in container YMLU8877279 as per packing list KT35278",
"certainty": 100
},
"typeOfPackages": {
"value": "CTN",
"reasoning": "Cartons (CTN) as indicated in packing lists",
"certainty": 100
}
},
"commodityCode": {
"hsCode": {
"value": "9405119090",
"reasoning": "HS code 9405 1190 900 for LED ceiling lamps from customs clearance instructions KT35278",
"certainty": 100
}
}
}
]
}
}