CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: DSV Air & Sea Germany GmbH (DE2) - Köln - Zollauftrag - SCGN0144062

Verwerkt: 28-11-2025 12:56:51

Voltooid
Uitvoering ID: csv_69298e03462bf
Agent: Oscar

📊 Geëxtraheerde Ordergegevens

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

70%

This is an import shipment into Germany/Netherlands from Korea, requiring fiscal clearance at Rotterdam

100%

Document states '19 PLT (OUTER)' consistently across all documents

100%

Gross mass stated as 22,296 KG in packing list, BL, and customs order

100%

Net mass stated as 20,837.8KG in packing list and commercial invoice

100%

Total amount invoiced in commercial invoice is €90,644.45

100%

Currency specified in commercial invoice is EUR

85%

EORI number mentioned in customs notes for the declarant/representative

80%

DSV is mentioned as handling customs suspension (Aufschub-Zoll: DSV, Aufschub-Eust: DSV)

100%

EOR number for Vishay Electronic GmbH as stated in customs order

100%

Listed as consignee and importer (Anmelder) in customs notes

100%

Street address from customs order for Vishay Electronic GmbH

100%

Germany, as stated in multiple documents

100%

Postcode from customs order for Vishay Electronic GmbH

100%

City from customs order for Vishay Electronic GmbH

90%

EORI mentioned in customs notes for the declarant

95%

CSV is the customs clearance agent receiving the customs order

100%

CSV address from customs order header

100%

Netherlands, as stated in customs order

100%

Postcode from customs order for CSV

100%

City from customs order for CSV

100%

Shipper identification number from customs order

95%

Shipper name from customs order (note: packing list and invoice show 'SAM YOUNG CO., LTD.' without 'CHEMICAL')

90%

Shipper address from customs order

100%

Korea, Republic of, as stated in customs order

75%

Postcode from customs order for shipper (note: different addresses in BL/invoice show 03188)

80%

City district from customs order for shipper

95%

Same as exporter based on documents

100%

Seller name from commercial invoice and packing list

100%

Seller address from commercial invoice and packing list

100%

Korea, as stated in commercial invoice

100%

Postcode from commercial invoice and packing list

100%

City from commercial invoice and packing list

0%

No specific identification number provided for buyer in documents

100%

Buyer name from Bill of Lading consignee and commercial invoice 'For Account'

100%

Buyer address from Bill of Lading and commercial invoice

100%

Germany, as stated in Bill of Lading and commercial invoice

100%

Postcode from Bill of Lading and commercial invoice

100%

City from Bill of Lading and commercial invoice

100%

Incoterm stated as 'DAP - Delivered At Place' in customs order and commercial invoice unit price indicates 'DAP ERNDTEBRUCK, GERMANY'

100%

Currency stated as EUR in commercial invoice

100%

Total amount from commercial invoice is €90,644.45

100%

Final destination is ERNDTEBRUCK, GERMANY as stated in multiple documents

100%

Port of loading is BUSAN, KOREA as stated in Bill of Lading and packing list

100%

Gross mass of 22,296 KG stated consistently across all documents

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "IM",
            "reasoning": "This is an import shipment into Germany/Netherlands from Korea, requiring fiscal clearance at Rotterdam",
            "certainty": 70
        },
        "control": {
            "packages": {
                "value": 19,
                "reasoning": "Document states '19 PLT (OUTER)' consistently across all documents",
                "certainty": 100
            },
            "grossmass": {
                "value": 22296,
                "reasoning": "Gross mass stated as 22,296 KG in packing list, BL, and customs order",
                "certainty": 100
            },
            "netmass": {
                "value": 20837.8,
                "reasoning": "Net mass stated as 20,837.8KG in packing list and commercial invoice",
                "certainty": 100
            },
            "commodityValue": {
                "value": {
                    "value": 90644.45,
                    "reasoning": "Total amount invoiced in commercial invoice is €90,644.45",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Currency specified in commercial invoice is EUR",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "DE4447077",
                "reasoning": "EORI number mentioned in customs notes for the declarant/representative",
                "certainty": 85
            },
            "representativeName": {
                "value": "DSV",
                "reasoning": "DSV is mentioned as handling customs suspension (Aufschub-Zoll: DSV, Aufschub-Eust: DSV)",
                "certainty": 80
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE2368293",
                "reasoning": "EOR number for Vishay Electronic GmbH as stated in customs order",
                "certainty": 100
            },
            "name": {
                "value": "Vishay Electronic GmbH",
                "reasoning": "Listed as consignee and importer (Anmelder) in customs notes",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Im Grunewald 4",
                    "reasoning": "Street address from customs order for Vishay Electronic GmbH",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany, as stated in multiple documents",
                    "certainty": 100
                },
                "postcode": {
                    "value": "57339",
                    "reasoning": "Postcode from customs order for Vishay Electronic GmbH",
                    "certainty": 100
                },
                "city": {
                    "value": "ERNDTEBRUCK",
                    "reasoning": "City from customs order for Vishay Electronic GmbH",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "DE4447077",
                "reasoning": "EORI mentioned in customs notes for the declarant",
                "certainty": 90
            },
            "name": {
                "value": "CSV",
                "reasoning": "CSV is the customs clearance agent receiving the customs order",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "ANKERKADE 20",
                    "reasoning": "CSV address from customs order header",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Netherlands, as stated in customs order",
                    "certainty": 100
                },
                "postcode": {
                    "value": "5928 PL",
                    "reasoning": "Postcode from customs order for CSV",
                    "certainty": 100
                },
                "city": {
                    "value": "VENLO",
                    "reasoning": "City from customs order for CSV",
                    "certainty": 100
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "TWSC25091911",
                        "reasoning": "Ocean Bill of Lading number from customs order and BL document",
                        "certainty": 100
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "010-10-200094",
                        "reasoning": "Customs authorization number mentioned in commercial invoice remarks",
                        "certainty": 90
                    }
                },
                {
                    "referenceNumber": {
                        "value": "SYCBB250924",
                        "reasoning": "Commercial invoice number from invoice and packing list",
                        "certainty": 100
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": "6404011950",
                "reasoning": "Shipper identification number from customs order",
                "certainty": 100
            },
            "name": {
                "value": "SAM YOUNG CHEMICAL CO. LTD.",
                "reasoning": "Shipper name from customs order (note: packing list and invoice show 'SAM YOUNG CO., LTD.' without 'CHEMICAL')",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "6F, SAMYOUNG B/D.NO70, SOGONG-DONG",
                    "reasoning": "Shipper address from customs order",
                    "certainty": 90
                },
                "country": {
                    "value": "KR",
                    "reasoning": "Korea, Republic of, as stated in customs order",
                    "certainty": 100
                },
                "postcode": {
                    "value": "100-070",
                    "reasoning": "Postcode from customs order for shipper (note: different addresses in BL/invoice show 03188)",
                    "certainty": 75
                },
                "city": {
                    "value": "CHUNG KU",
                    "reasoning": "City district from customs order for shipper",
                    "certainty": 80
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "6404011950",
                "reasoning": "Same as exporter based on documents",
                "certainty": 95
            },
            "name": {
                "value": "SAM YOUNG CO., LTD.",
                "reasoning": "Seller name from commercial invoice and packing list",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "13TH FLOOR KWANJEONG BLDG, 35 CHEONGGYECHEON-RO, JONGNO-GU",
                    "reasoning": "Seller address from commercial invoice and packing list",
                    "certainty": 100
                },
                "country": {
                    "value": "KR",
                    "reasoning": "Korea, as stated in commercial invoice",
                    "certainty": 100
                },
                "postcode": {
                    "value": "03188",
                    "reasoning": "Postcode from commercial invoice and packing list",
                    "certainty": 100
                },
                "city": {
                    "value": "SEOUL",
                    "reasoning": "City from commercial invoice and packing list",
                    "certainty": 100
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "",
                "reasoning": "No specific identification number provided for buyer in documents",
                "certainty": 0
            },
            "name": {
                "value": "BIRKELBACH KONDENSATORTECHNIK GMBH",
                "reasoning": "Buyer name from Bill of Lading consignee and commercial invoice 'For Account'",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "IM GRUNEWALD 4-TOR 1",
                    "reasoning": "Buyer address from Bill of Lading and commercial invoice",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany, as stated in Bill of Lading and commercial invoice",
                    "certainty": 100
                },
                "postcode": {
                    "value": "57339",
                    "reasoning": "Postcode from Bill of Lading and commercial invoice",
                    "certainty": 100
                },
                "city": {
                    "value": "ERNDTEBRUCK",
                    "reasoning": "City from Bill of Lading and commercial invoice",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "DAP",
                "reasoning": "Incoterm stated as 'DAP - Delivered At Place' in customs order and commercial invoice unit price indicates 'DAP ERNDTEBRUCK, GERMANY'",
                "certainty": 100
            }
        },
        "invoiceCurrency": {
            "value": "EUR",
            "reasoning": "Currency stated as EUR in commercial invoice",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 90644.45,
            "reasoning": "Total amount from commercial invoice is €90,644.45",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "DE",
            "reasoning": "Final destination is ERNDTEBRUCK, GERMANY as stated in multiple documents",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "KR",
            "reasoning": "Port of loading is BUSAN, KOREA as stated in Bill of Lading and packing list",
            "certainty": 100
        },
        "grossMass": {
            "value": 22296,
            "reasoning": "Gross mass of 22,296 KG stated consistently across all documents",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "SEGU6018900",
                    "reasoning": "Container number from customs order, Bill of Lading, and packing list",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 90644.45,
                    "reasoning": "Total invoiced amount for all goods in this single container shipment",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "KR",
                    "reasoning": "Commercial invoice remarks state products are of South Korea preferential origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 114,
                    "reasoning": "Total of 114 rolls as stated in packing list",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 22296,
                    "reasoning": "Gross mass of 22,296 KG for the entire shipment",
                    "certainty": 100
                },
                "netMass": {
                    "value": 20837.8,
                    "reasoning": "Net mass of 20,837.8 KG as stated in packing list and commercial invoice",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Plain Polypropylene Film for Capacitors (PHCM)",
                    "reasoning": "Description from customs order and repeated in all documents",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 19,
                        "reasoning": "19 PLT (pallets) as stated in customs order and packing list",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "PLT",
                        "reasoning": "Package type is PLT (pallet) as stated in customs order",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3920202190",
                        "reasoning": "HS code stated as '3920 2021 90 0' in customs instruction notes, formatted without spaces",
                        "certainty": 100
                    }
                }
            }
        ]
    }
}