CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: 22-12 Verzollungsauftrag // Republic Floor // 4 x 20'Cont. / IMP1-1225-0031

Verwerkt: 17-12-2025 09:30:11

Voltooid
Uitvoering ID: csv_69426a134bf5a
Agent: Oscar

📊 Geëxtraheerde Ordergegevens

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

85%

This is an import declaration for goods arriving by sea from China to the Netherlands (Rotterdam), requiring standard customs clearance procedure

100%

Total number of packages stated in Bill of Lading, Sea Waybill, and Packing List as '100 PACKAGES' representing total pallets

100%

Gross weight stated on Sea Waybill page 1 as '95000.000KGS' and confirmed on Bill of Lading as '95000.000KGS'

95%

Net weight from Packing List showing N.W. KGS total of 92800

100%

Total amount invoiced as shown on Commercial Invoice dated 04.Nov.25, stated as USD $71,648.51

100%

Currency clearly marked as 'USD' throughout the Commercial Invoice with all unit prices and total in USD

60%

CSV Logistics appears to be acting as customs representative/declarant based in Venlo, Netherlands, though exact EORI code not provided in documents

90%

CSV Logistics is shown as the handling party on the Sea Waybill with address in Venlo and customs department contact information

100%

EORI number stated for Republic Floor GmbH on Bill of Lading and invoice as 'EORI: DE35246365899195'

100%

Consignee name clearly stated on Bill of Lading, invoice, and packing list as 'REPUBLIC FLOOR GMBH'

100%

Street address provided on Bill of Lading and invoice as 'FERDINAND-GABRIEL-WEG,4-8'

100%

Country code for Germany, stated as 'GERMANY' on all documents and confirmed by EORI prefix 'DE'

100%

Postal code shown on Bill of Lading and invoice as '59494'

100%

City name stated on Bill of Lading and invoice as 'SOEST' following the postal code

50%

CSV Logistics Netherlands location suggests Dutch EORI, but exact number not provided in documentation

85%

CSV identified as the customs handling party based on email header and Sea Waybill footer

100%

CSV address shown in email signature and Sea Waybill as 'Ankerkade 20'

100%

Country stated as 'The Netherlands' in CSV contact information

100%

Postal code shown in CSV signature as '5928 PL'

100%

City stated as 'Venlo' in CSV contact details

40%

Chinese business registration likely, though not explicitly stated in documents - VAT-ID shown for importer but not exporter

100%

Shipper/Exporter name on Sea Waybill page 1 and shown as company header on Commercial Invoice and Packing List

100%

Full address provided on Commercial Invoice and Packing List header

100%

China as country of origin and dispatch, city Changzhou is in China

90%

No postal code provided in the documents for the Chinese exporter address

100%

City and district stated in invoice header as 'Wujin, Changzhou'

40%

Same as exporter - seller and exporter appear to be the same entity based on invoice

95%

Invoice is issued by Changzhou Lexuan, indicating they are the seller

100%

Same address as shown on invoice header for the manufacturing/selling company

100%

China - same as exporter

90%

No postal code provided for seller address

100%

Same city as exporter per invoice

100%

Same as importer - buyer shown on invoice as Republic Floor with same EORI

100%

Consignee on invoice matches importer name 'REPUBLIC FLOOR GMBH'

100%

Same address as importer shown on invoice

100%

Germany - same as importer

100%

Same postal code as importer

100%

Same city as importer per invoice

100%

Incoterm shown on Commercial Invoice as 'DAP' in the pricing section

100%

All amounts on invoice are in USD with clear currency marking throughout

100%

Invoice total clearly stated as '$71,648.51' at bottom of Commercial Invoice

100%

Port of discharge is Rotterdam, Netherlands as shown on Bill of Lading and Sea Waybill

100%

Port of loading is Shanghai, China as stated on Bill of Lading and Sea Waybill

100%

Total gross weight of shipment shown on Sea Waybill and Bill of Lading as 95000 KGS

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "H1",
            "reasoning": "This is an import declaration for goods arriving by sea from China to the Netherlands (Rotterdam), requiring standard customs clearance procedure",
            "certainty": 85
        },
        "control": {
            "packages": {
                "value": 100,
                "reasoning": "Total number of packages stated in Bill of Lading, Sea Waybill, and Packing List as '100 PACKAGES' representing total pallets",
                "certainty": 100
            },
            "grossmass": {
                "value": 95000,
                "reasoning": "Gross weight stated on Sea Waybill page 1 as '95000.000KGS' and confirmed on Bill of Lading as '95000.000KGS'",
                "certainty": 100
            },
            "netmass": {
                "value": 92800,
                "reasoning": "Net weight from Packing List showing N.W. KGS total of 92800",
                "certainty": 95
            },
            "commodityValue": {
                "value": {
                    "value": 71648.51,
                    "reasoning": "Total amount invoiced as shown on Commercial Invoice dated 04.Nov.25, stated as USD $71,648.51",
                    "certainty": 100
                },
                "currency": {
                    "value": "USD",
                    "reasoning": "Currency clearly marked as 'USD' throughout the Commercial Invoice with all unit prices and total in USD",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "NL00000000",
                "reasoning": "CSV Logistics appears to be acting as customs representative/declarant based in Venlo, Netherlands, though exact EORI code not provided in documents",
                "certainty": 60
            },
            "representativeName": {
                "value": "CSV LOGISTICS",
                "reasoning": "CSV Logistics is shown as the handling party on the Sea Waybill with address in Venlo and customs department contact information",
                "certainty": 90
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE35246365899195",
                "reasoning": "EORI number stated for Republic Floor GmbH on Bill of Lading and invoice as 'EORI: DE35246365899195'",
                "certainty": 100
            },
            "name": {
                "value": "REPUBLIC FLOOR GMBH",
                "reasoning": "Consignee name clearly stated on Bill of Lading, invoice, and packing list as 'REPUBLIC FLOOR GMBH'",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "FERDINAND-GABRIEL-WEG, 4-8",
                    "reasoning": "Street address provided on Bill of Lading and invoice as 'FERDINAND-GABRIEL-WEG,4-8'",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Country code for Germany, stated as 'GERMANY' on all documents and confirmed by EORI prefix 'DE'",
                    "certainty": 100
                },
                "postcode": {
                    "value": "59494",
                    "reasoning": "Postal code shown on Bill of Lading and invoice as '59494'",
                    "certainty": 100
                },
                "city": {
                    "value": "SOEST",
                    "reasoning": "City name stated on Bill of Lading and invoice as 'SOEST' following the postal code",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "NL000000000",
                "reasoning": "CSV Logistics Netherlands location suggests Dutch EORI, but exact number not provided in documentation",
                "certainty": 50
            },
            "name": {
                "value": "CSV LOGISTICS",
                "reasoning": "CSV identified as the customs handling party based on email header and Sea Waybill footer",
                "certainty": 85
            },
            "address": {
                "streetAndNumber": {
                    "value": "Ankerkade 20",
                    "reasoning": "CSV address shown in email signature and Sea Waybill as 'Ankerkade 20'",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Country stated as 'The Netherlands' in CSV contact information",
                    "certainty": 100
                },
                "postcode": {
                    "value": "5928 PL",
                    "reasoning": "Postal code shown in CSV signature as '5928 PL'",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City stated as 'Venlo' in CSV contact details",
                    "certainty": 100
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "COSU9504580390",
                        "reasoning": "Sea Waybill number prominently displayed on page 1 as 'Sea Waybill No.: COSU9504580390'",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "00084680",
                        "reasoning": "Agreement/reference number shown on Sea Waybill as 'CSO/AGREEMENT NUMBER 00084680'",
                        "certainty": 95
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "RELX251101",
                        "reasoning": "Commercial Invoice number stated as 'RELX251101' on the invoice document",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "SHZH25110547",
                        "reasoning": "Bill of Lading number shown on BL document as 'B/L NO. SHZH25110547'",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "IMP1-1225-0031",
                        "reasoning": "Import reference number from email subject line 'IMP1-1225-0031'",
                        "certainty": 90
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": "91320412MA1NFHU06",
                "reasoning": "Chinese business registration likely, though not explicitly stated in documents - VAT-ID shown for importer but not exporter",
                "certainty": 40
            },
            "name": {
                "value": "CHANGZHOU LEXUAN NEW MATERIAL TECHNOLOGY CO., LTD.",
                "reasoning": "Shipper/Exporter name on Sea Waybill page 1 and shown as company header on Commercial Invoice and Packing List",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "NO.1 HUANNONG EAST ROAD, SHUANGRONG INDUSTRIAL AREA, HENGLIN TOWN",
                    "reasoning": "Full address provided on Commercial Invoice and Packing List header",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "China as country of origin and dispatch, city Changzhou is in China",
                    "certainty": 100
                },
                "postcode": {
                    "value": "",
                    "reasoning": "No postal code provided in the documents for the Chinese exporter address",
                    "certainty": 90
                },
                "city": {
                    "value": "WUJIN, CHANGZHOU",
                    "reasoning": "City and district stated in invoice header as 'Wujin, Changzhou'",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "91320412MA1NFHU06",
                "reasoning": "Same as exporter - seller and exporter appear to be the same entity based on invoice",
                "certainty": 40
            },
            "name": {
                "value": "CHANGZHOU LEXUAN NEW MATERIAL TECHNOLOGY CO., LTD.",
                "reasoning": "Invoice is issued by Changzhou Lexuan, indicating they are the seller",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "NO.1 HUANNONG EAST ROAD, SHUANGRONG INDUSTRIAL AREA, HENGLIN TOWN",
                    "reasoning": "Same address as shown on invoice header for the manufacturing/selling company",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "China - same as exporter",
                    "certainty": 100
                },
                "postcode": {
                    "value": "",
                    "reasoning": "No postal code provided for seller address",
                    "certainty": 90
                },
                "city": {
                    "value": "WUJIN, CHANGZHOU",
                    "reasoning": "Same city as exporter per invoice",
                    "certainty": 100
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "DE35246365899195",
                "reasoning": "Same as importer - buyer shown on invoice as Republic Floor with same EORI",
                "certainty": 100
            },
            "name": {
                "value": "REPUBLIC FLOOR GMBH",
                "reasoning": "Consignee on invoice matches importer name 'REPUBLIC FLOOR GMBH'",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "FERDINAND-GABRIEL-WEG, 4-8",
                    "reasoning": "Same address as importer shown on invoice",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany - same as importer",
                    "certainty": 100
                },
                "postcode": {
                    "value": "59494",
                    "reasoning": "Same postal code as importer",
                    "certainty": 100
                },
                "city": {
                    "value": "SOEST",
                    "reasoning": "Same city as importer per invoice",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "DAP",
                "reasoning": "Incoterm shown on Commercial Invoice as 'DAP' in the pricing section",
                "certainty": 100
            }
        },
        "invoiceCurrency": {
            "value": "USD",
            "reasoning": "All amounts on invoice are in USD with clear currency marking throughout",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 71648.51,
            "reasoning": "Invoice total clearly stated as '$71,648.51' at bottom of Commercial Invoice",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "NL",
            "reasoning": "Port of discharge is Rotterdam, Netherlands as shown on Bill of Lading and Sea Waybill",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "CN",
            "reasoning": "Port of loading is Shanghai, China as stated on Bill of Lading and Sea Waybill",
            "certainty": 100
        },
        "grossMass": {
            "value": 95000,
            "reasoning": "Total gross weight of shipment shown on Sea Waybill and Bill of Lading as 95000 KGS",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "SLEU2488884",
                    "reasoning": "Container number from Sea Waybill page 2 and Packing List for item REELCQU05",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 8035.26,
                    "reasoning": "Amount for REELCQU05 from Commercial Invoice showing USD $8,035.26",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods manufactured and shipped from China by Chinese company",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 1040.56,
                    "reasoning": "Square meters (SQ.M) for REELCQU05 from Packing List showing 1040.56 SQ.M",
                    "certainty": 95
                },
                "grossMass": {
                    "value": 23750,
                    "reasoning": "Gross weight for container SLEU2488884 from Packing List showing G.W. 23750 KGS",
                    "certainty": 100
                },
                "netMass": {
                    "value": 23200,
                    "reasoning": "Net weight from Packing List for SLEU2488884 showing N.W. 23200 KGS",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "VINYL FLOORING",
                    "reasoning": "Goods description on Bill of Lading and throughout documents as 'VINYL FLOORING'",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 9,
                        "reasoning": "Number of pallets for REELCQU05 from Packing List showing 9 pallets containing 472 boxes",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "PX",
                        "reasoning": "Packaging type is pallets (PX code) as goods are shipped on pallets containing boxes",
                        "certainty": 85
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3918109090",
                        "reasoning": "HS code from email as '39181090900' which standardizes to 10-digit format 3918109090 for floor coverings of polymers of vinyl chloride",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "SLEU2489047",
                    "reasoning": "Container number from Sea Waybill page 2 and Packing List for item REELCEC06",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 17995.22,
                    "reasoning": "Amount for REELCEC06 from Commercial Invoice showing USD $17,995.22",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods manufactured and shipped from China",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 2665.96,
                    "reasoning": "Square meters for REELCEC06 from Packing List showing 2665.96 SQ.M",
                    "certainty": 95
                },
                "grossMass": {
                    "value": 23750,
                    "reasoning": "Gross weight for container SLEU2489047 from Packing List showing G.W. 23750 KGS",
                    "certainty": 100
                },
                "netMass": {
                    "value": 23200,
                    "reasoning": "Net weight from Packing List showing N.W. 23200 KGS",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "VINYL FLOORING",
                    "reasoning": "Goods description consistent across all documents as vinyl flooring",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 25,
                        "reasoning": "Number of pallets for REELCEC06 from Packing List showing 25 pallets containing 1200 boxes",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "PX",
                        "reasoning": "Packaging type is pallets containing boxes",
                        "certainty": 85
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3918109090",
                        "reasoning": "Same HS code applies to all vinyl flooring items in this shipment",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "SLEU2489509",
                    "reasoning": "Container number from Sea Waybill page 2 and Packing List for item REELCEC08",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 17995.22,
                    "reasoning": "Amount for REELCEC08 from Commercial Invoice showing USD $17,995.22",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods manufactured and shipped from China",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 2665.96,
                    "reasoning": "Square meters for REELCEC08 from Packing List showing 2665.96 SQ.M",
                    "certainty": 95
                },
                "grossMass": {
                    "value": 23750,
                    "reasoning": "Gross weight for container SLEU2489509 from Packing List showing G.W. 23750 KGS",
                    "certainty": 100
                },
                "netMass": {
                    "value": 23200,
                    "reasoning": "Net weight from Packing List showing N.W. 23200 KGS",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "VINYL FLOORING",
                    "reasoning": "Goods description consistent as vinyl flooring across documents",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 25,
                        "reasoning": "Number of pallets for REELCEC08 from Packing List showing 25 pallets containing 1200 boxes",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "PX",
                        "reasoning": "Packaging type is pallets containing boxes",
                        "certainty": 85
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3918109090",
                        "reasoning": "Same HS code for vinyl flooring products",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "SLEU2489052",
                    "reasoning": "Container number from Sea Waybill page 2 and Packing List for item RENACG013",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 674.82,
                    "reasoning": "Amount for RENACG013 from Commercial Invoice showing USD $674.82",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods manufactured and shipped from China",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 99.97,
                    "reasoning": "Square meters for RENACG013 from Packing List showing 99.97 SQ.M",
                    "certainty": 95
                },
                "grossMass": {
                    "value": 23750,
                    "reasoning": "Gross weight for container SLEU2489052 from Packing List showing G.W. 23750 KGS",
                    "certainty": 100
                },
                "netMass": {
                    "value": 23200,
                    "reasoning": "Net weight from Packing List showing N.W. 23200 KGS",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "VINYL FLOORING",
                    "reasoning": "Goods description consistent as vinyl flooring",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 1,
                        "reasoning": "Number of pallets for RENACG013 from Packing List showing 1 pallet containing 45 boxes",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "PX",
                        "reasoning": "Packaging type is pallets containing boxes",
                        "certainty": 85
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3918109090",
                        "reasoning": "Same HS code for vinyl flooring products",
                        "certainty": 95
                    }
                }
            }
        ]
    }
}