CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: 20-12 DSV Air & Sea Germany GmbH (DE2) - Kรถln - Zollauftrag - SCGN0145751

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

Voltooid
Uitvoering ID: csv_69426a093535e
Agent: Oscar

๐Ÿ“Š Geรซxtraheerde Ordergegevens

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

0%

No template code is specified in any of the provided documents

100%

The Zollauftrag document clearly states '21 PLT (OUTER), 0 CTN (INNER)' in the packages section

100%

The Zollauftrag and packing list both confirm gross weight as 21,296.000 KG

100%

The commercial invoice and packing list both specify net weight as 19,902.6KG

100%

The commercial invoice shows total amount of โ‚ฌ86,576.31

100%

The commercial invoice clearly shows all amounts in EUR currency with DAP ERNDTEBRUCK, GERMANY EUR notation

0%

While CSV is the customs broker and DSV handles duty/VAT deferment, no specific representative code is provided in the documents

85%

CSV acts as the customs broker as evidenced by the Zollauftrag being addressed to CSV customs at Ankerkade 20, Venlo

100%

The Zollauftrag customs notes specify 'Anmelder: Vishay Electronic GmbH EORI: DE2368293', and the email thread confirms clearance should be under Vishay after Birkelbach merged

100%

Email thread confirms that as of 27-10-2025, Birkelbach merged into Vishay, and customs instruction notes specify 'Anmelder: Vishay Electronic GmbH'

100%

Address is consistently shown across all documents for the consignee

100%

Germany is specified as the country across all documents

100%

Postcode D-57339 is shown consistently in all documents

100%

City is consistently shown as ERNDTEBRUCK (also spelled ERNDTEBRUECK) across documents

0%

No specific EORI or identification number is provided for CSV customs broker in the documents

90%

CSV is the customs broker as the Zollauftrag document is addressed to 'CUSTOMS CSV' at Ankerkade 20, Venlo

100%

CSV address is shown on the Zollauftrag header and email signatures

100%

Netherlands is specified for CSV's address

100%

Postcode is clearly shown in CSV's address on the Zollauftrag

100%

City is shown as Venlo in CSV's address

0%

No EORI or identification number is provided for the Korean exporter

95%

The shipper name on the Bill of Lading is 'SAM YOUNG CO., LTD.' while the Zollauftrag lists 'Sam Young Express Co., Ltd.' - both appear to be the same entity

100%

This address is shown on both the Bill of Lading and commercial documents for Sam Young

100%

Korea, Republic of is specified as the country for the shipper

100%

Postcode 03188 is shown in the shipper's address on the invoice and Bill of Lading

100%

Seoul is specified as the city for the shipper across all documents

0%

No identification number is provided for the seller

100%

The commercial invoice identifies SAM YOUNG CO., LTD. as the shipper/exporter

100%

This is the seller's address as shown on the commercial invoice

100%

Korea is the country specified for the seller on the invoice

100%

Postcode is shown on the invoice for the seller

100%

Seoul is the city shown for the seller on the invoice

95%

Although the invoice shows Birkelbach, the email thread clarifies that Birkelbach merged into Vishay, and both share the same EORI DE2368293

95%

Per the email thread, Birkelbach Kondensatortechnik GmbH merged completely into Vishay as of 27-10-2025, and clearance should be under Vishay

100%

This is the buyer's address shown on the commercial invoice

100%

Germany is specified as the buyer's country

100%

D-57339 is the postcode shown on the invoice

100%

ERNDTEBRUCK is the city shown for the buyer on the invoice

100%

The Zollauftrag clearly states 'DAP - Delivered At Place' as the Incoterm, and the invoice confirms 'DAP ERNDTEBRUCK, GERMANY'

100%

The commercial invoice shows all amounts in EUR currency

100%

The commercial invoice shows a total amount of โ‚ฌ86,576.31

100%

Germany is specified as the final destination (ERNDTEBRUCK, GERMANY) on all documents

100%

The port of loading is BUSAN, KOREA, and the invoice remarks state products are of South Korea preferential origin

100%

The Bill of Lading and packing list both specify 21,296.000KGS gross weight

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": null,
            "reasoning": "No template code is specified in any of the provided documents",
            "certainty": 0
        },
        "control": {
            "packages": {
                "value": 21,
                "reasoning": "The Zollauftrag document clearly states '21 PLT (OUTER), 0 CTN (INNER)' in the packages section",
                "certainty": 100
            },
            "grossmass": {
                "value": 21296,
                "reasoning": "The Zollauftrag and packing list both confirm gross weight as 21,296.000 KG",
                "certainty": 100
            },
            "netmass": {
                "value": 19902.6,
                "reasoning": "The commercial invoice and packing list both specify net weight as 19,902.6KG",
                "certainty": 100
            },
            "commodityValue": {
                "value": {
                    "value": 86576.31,
                    "reasoning": "The commercial invoice shows total amount of โ‚ฌ86,576.31",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "The commercial invoice clearly shows all amounts in EUR currency with DAP ERNDTEBRUCK, GERMANY EUR notation",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": null,
                "reasoning": "While CSV is the customs broker and DSV handles duty/VAT deferment, no specific representative code is provided in the documents",
                "certainty": 0
            },
            "representativeName": {
                "value": "CSV",
                "reasoning": "CSV acts as the customs broker as evidenced by the Zollauftrag being addressed to CSV customs at Ankerkade 20, Venlo",
                "certainty": 85
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE2368293",
                "reasoning": "The Zollauftrag customs notes specify 'Anmelder: Vishay Electronic GmbH EORI: DE2368293', and the email thread confirms clearance should be under Vishay after Birkelbach merged",
                "certainty": 100
            },
            "name": {
                "value": "Vishay Electronic GmbH",
                "reasoning": "Email thread confirms that as of 27-10-2025, Birkelbach merged into Vishay, and customs instruction notes specify 'Anmelder: Vishay Electronic GmbH'",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Im Grunewald 4",
                    "reasoning": "Address is consistently shown across all documents for the consignee",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany is specified as the country across all documents",
                    "certainty": 100
                },
                "postcode": {
                    "value": "57339",
                    "reasoning": "Postcode D-57339 is shown consistently in all documents",
                    "certainty": 100
                },
                "city": {
                    "value": "ERNDTEBRUCK",
                    "reasoning": "City is consistently shown as ERNDTEBRUCK (also spelled ERNDTEBRUECK) across documents",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": null,
                "reasoning": "No specific EORI or identification number is provided for CSV customs broker in the documents",
                "certainty": 0
            },
            "name": {
                "value": "CSV",
                "reasoning": "CSV is the customs broker as the Zollauftrag document is addressed to 'CUSTOMS CSV' at Ankerkade 20, Venlo",
                "certainty": 90
            },
            "address": {
                "streetAndNumber": {
                    "value": "Ankerkade 20",
                    "reasoning": "CSV address is shown on the Zollauftrag header and email signatures",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Netherlands is specified for CSV's address",
                    "certainty": 100
                },
                "postcode": {
                    "value": "5928 PL",
                    "reasoning": "Postcode is clearly shown in CSV's address on the Zollauftrag",
                    "certainty": 100
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City is shown as Venlo in CSV's address",
                    "certainty": 100
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "TWSC25110146",
                        "reasoning": "This is the House Bill of Lading number shown on both the Zollauftrag and the FBL document",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "MAEU261168956",
                        "reasoning": "This is the Master Bill of Lading (MBL) number mentioned in the customs instruction notes",
                        "certainty": 100
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "SYCBB251028",
                        "reasoning": "This is the commercial invoice number shown on both the invoice and packing list documents",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "SYCC250211-10",
                        "reasoning": "This is the sales contract number referenced on the invoice dated 2025-02-11",
                        "certainty": 100
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": null,
                "reasoning": "No EORI or identification number is provided for the Korean exporter",
                "certainty": 0
            },
            "name": {
                "value": "Sam Young Express Co., Ltd.",
                "reasoning": "The shipper name on the Bill of Lading is 'SAM YOUNG CO., LTD.' while the Zollauftrag lists 'Sam Young Express Co., Ltd.' - both appear to be the same entity",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "13TH FLOOR KWANJEONG BLDG, 35 CHEONGGYECHEON-RO, MAPO",
                    "reasoning": "This address is shown on both the Bill of Lading and commercial documents for Sam Young",
                    "certainty": 100
                },
                "country": {
                    "value": "KR",
                    "reasoning": "Korea, Republic of is specified as the country for the shipper",
                    "certainty": 100
                },
                "postcode": {
                    "value": "03188",
                    "reasoning": "Postcode 03188 is shown in the shipper's address on the invoice and Bill of Lading",
                    "certainty": 100
                },
                "city": {
                    "value": "Seoul",
                    "reasoning": "Seoul is specified as the city for the shipper across all documents",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": null,
                "reasoning": "No identification number is provided for the seller",
                "certainty": 0
            },
            "name": {
                "value": "SAM YOUNG CO., LTD.",
                "reasoning": "The commercial invoice identifies SAM YOUNG CO., LTD. as the shipper/exporter",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "13TH FLOOR KWANJEONG BLDG, 35 CHEONGGYECHEON-RO, JONGNO-GU",
                    "reasoning": "This is the seller's address as shown on the commercial invoice",
                    "certainty": 100
                },
                "country": {
                    "value": "KR",
                    "reasoning": "Korea is the country specified for the seller on the invoice",
                    "certainty": 100
                },
                "postcode": {
                    "value": "03188",
                    "reasoning": "Postcode is shown on the invoice for the seller",
                    "certainty": 100
                },
                "city": {
                    "value": "Seoul",
                    "reasoning": "Seoul is the city shown for the seller on the invoice",
                    "certainty": 100
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "DE2368293",
                "reasoning": "Although the invoice shows Birkelbach, the email thread clarifies that Birkelbach merged into Vishay, and both share the same EORI DE2368293",
                "certainty": 95
            },
            "name": {
                "value": "Vishay Electronic GmbH",
                "reasoning": "Per the email thread, Birkelbach Kondensatortechnik GmbH merged completely into Vishay as of 27-10-2025, and clearance should be under Vishay",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "Im Grunewald 4-Tor 1",
                    "reasoning": "This is the buyer's address shown on the commercial invoice",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany is specified as the buyer's country",
                    "certainty": 100
                },
                "postcode": {
                    "value": "57339",
                    "reasoning": "D-57339 is the postcode shown on the invoice",
                    "certainty": 100
                },
                "city": {
                    "value": "ERNDTEBRUCK",
                    "reasoning": "ERNDTEBRUCK is the city shown for the buyer on the invoice",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "DAP",
                "reasoning": "The Zollauftrag clearly states 'DAP - Delivered At Place' as the Incoterm, and the invoice confirms 'DAP ERNDTEBRUCK, GERMANY'",
                "certainty": 100
            }
        },
        "invoiceCurrency": {
            "value": "EUR",
            "reasoning": "The commercial invoice shows all amounts in EUR currency",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 86576.31,
            "reasoning": "The commercial invoice shows a total amount of โ‚ฌ86,576.31",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "DE",
            "reasoning": "Germany is specified as the final destination (ERNDTEBRUCK, GERMANY) on all documents",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "KR",
            "reasoning": "The port of loading is BUSAN, KOREA, and the invoice remarks state products are of South Korea preferential origin",
            "certainty": 100
        },
        "grossMass": {
            "value": 21296,
            "reasoning": "The Bill of Lading and packing list both specify 21,296.000KGS gross weight",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "MRKU5499679",
                    "reasoning": "This container number is consistently shown across the Zollauftrag, Bill of Lading, and packing list",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 86576.31,
                    "reasoning": "The commercial invoice shows this as the total amount for the single line item (Order No. 16964-2)",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "KR",
                    "reasoning": "The commercial invoice remarks state 'these products are of South Korea preferential origin'",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 122,
                    "reasoning": "The invoice and packing list show 122 rolls, which appears to be the relevant supplementary unit for this type of film product",
                    "certainty": 85
                },
                "grossMass": {
                    "value": 21296,
                    "reasoning": "The packing list shows gross weight of 21,296.0kg for the shipment",
                    "certainty": 100
                },
                "netMass": {
                    "value": 19902.6,
                    "reasoning": "The commercial invoice and packing list both show net weight of 19,902.6KG",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Plain Polypropylene Film for Capacitors (PHCM)",
                    "reasoning": "This description is consistently shown across the Bill of Lading, invoice, packing list, and customs instructions",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 21,
                        "reasoning": "All documents consistently show 21 packages/pallets",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "PLT",
                        "reasoning": "The Zollauftrag specifies '21 PLT (OUTER)' where PLT stands for pallets, confirmed by packing list showing '21 PLT'",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3920202190",
                        "reasoning": "The customs instruction notes specify 'hs-code: 3920 2021 90 0' which converts to 3920202190 in standard format",
                        "certainty": 100
                    }
                }
            }
        ]
    }
}