CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: 22-11 DSV Air & Sea Germany GmbH (DE2) - Kรถln - Zollauftrag - SCGN0142708

Verwerkt: 21-11-2025 13:45:41

Voltooid
Uitvoering ID: csv_69205ef59682a
Agent: Oscar

๐Ÿ“Š Geรซxtraheerde Ordergegevens

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

0%

Template code not specified in the provided documents

100%

Zollauftrag shows 22 PLT (pallets) as package count

100%

Zollauftrag and all shipping documents consistently show 21,439 KG gross weight

100%

Packing list shows total net weight of 20,036.5KG for the goods

100%

Commercial invoice shows total amount invoiced as 87,158.78 EUR

100%

Commercial invoice clearly states amounts in EUR currency

30%

Representative code not explicitly provided in documents, though DSV is mentioned for customs deferment

80%

DSV is mentioned in Zollauftrag as handling customs deferment (Aufschub-Zoll: DSV, Aufschub-Eust: DSV)

100%

Zollauftrag shows Vishay Electronic GmbH with EOR: DE2368293 as the consignee and importer

100%

Zollauftrag identifies Vishay Electronic GmbH as the consignee with EORI number

100%

Zollauftrag shows this as the street address for Vishay Electronic GmbH

100%

Germany is specified as the country for the importer address

100%

Zollauftrag shows 57339 as the postal code for Vishay Electronic GmbH

100%

Zollauftrag shows ERNDTEBRUCK as the city for Vishay Electronic GmbH

0%

Declarant identification number not provided in the documents

100%

CSV is the customs broker handling the declaration as shown in Zollauftrag header

100%

Zollauftrag header shows CSV address as ANKERKADE 20

100%

CSV is located in NETHERLANDS as shown in the Zollauftrag

100%

Zollauftrag shows 5928 PL as CSV's postal code

100%

Zollauftrag shows VENLO as CSV's city

90%

Shipper ID shown in Zollauftrag for Sam Young Chemical Co. Ltd.

100%

Shipper name shown consistently across all documents (BL, invoice, packing list)

100%

Address shown on Bill of Lading, invoice and packing list for Sam Young Chemical Co. Ltd.

100%

Korea, Republic of, specified as shipper country across all documents

100%

Postal code shown for Seoul address on BL, invoice and packing list

100%

Seoul specified as the city for Sam Young Chemical Co. Ltd. on all documents

90%

Same as exporter based on invoice structure showing Sam Young as seller

100%

Invoice issued by Sam Young Chemical Co. Ltd. indicating seller role

100%

Seller address same as exporter on commercial invoice

100%

Korea, Republic of, as specified on invoice

100%

Seoul postal code shown on invoice

100%

Seoul specified as seller city on invoice

40%

Buyer identification not clearly specified; invoice shows 'For Account' as Birkelbach but email indicates company was acquired by Vishay

85%

Invoice and packing list show 'For Account & Risk of Messrs.' as Birkelbach Kondensatortechnik GmbH, indicating buyer role despite company acquisition

100%

Address shown on invoice and packing list for Birkelbach

100%

Germany specified for buyer address

100%

Postal code D-57339 shown for Birkelbach address

100%

ERNDTEBRUCK specified as city for Birkelbach on invoice

100%

Zollauftrag specifies 'DAP - Delivered At Place' as incoterm, and invoice shows 'DAP ERNDTEBRUCK, GERMANY'

100%

Commercial invoice clearly shows all amounts in EUR currency

100%

Commercial invoice total shows 87,158.78 EUR as final invoiced amount

100%

Germany is the final destination as shown across all documents with delivery to Erndtebruck

100%

Port of loading Busan, Korea shown on all documents indicates Korea as country of dispatch

100%

Gross mass of 21,439 KG consistently shown across Zollauftrag, BL, packing list

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "",
            "reasoning": "Template code not specified in the provided documents",
            "certainty": 0
        },
        "control": {
            "packages": {
                "value": 22,
                "reasoning": "Zollauftrag shows 22 PLT (pallets) as package count",
                "certainty": 100
            },
            "grossmass": {
                "value": 21439,
                "reasoning": "Zollauftrag and all shipping documents consistently show 21,439 KG gross weight",
                "certainty": 100
            },
            "netmass": {
                "value": 20036.5,
                "reasoning": "Packing list shows total net weight of 20,036.5KG for the goods",
                "certainty": 100
            },
            "commodityValue": {
                "value": {
                    "value": 87158.78,
                    "reasoning": "Commercial invoice shows total amount invoiced as 87,158.78 EUR",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Commercial invoice clearly states amounts in EUR currency",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "",
                "reasoning": "Representative code not explicitly provided in documents, though DSV is mentioned for customs deferment",
                "certainty": 30
            },
            "representativeName": {
                "value": "DSV Air & Sea Germany GmbH",
                "reasoning": "DSV is mentioned in Zollauftrag as handling customs deferment (Aufschub-Zoll: DSV, Aufschub-Eust: DSV)",
                "certainty": 80
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE2368293",
                "reasoning": "Zollauftrag shows Vishay Electronic GmbH with EOR: DE2368293 as the consignee and importer",
                "certainty": 100
            },
            "name": {
                "value": "Vishay Electronic GmbH",
                "reasoning": "Zollauftrag identifies Vishay Electronic GmbH as the consignee with EORI number",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Im Grunewald 4",
                    "reasoning": "Zollauftrag shows this as the street address for Vishay Electronic GmbH",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany is specified as the country for the importer address",
                    "certainty": 100
                },
                "postcode": {
                    "value": "57339",
                    "reasoning": "Zollauftrag shows 57339 as the postal code for Vishay Electronic GmbH",
                    "certainty": 100
                },
                "city": {
                    "value": "ERNDTEBRUCK",
                    "reasoning": "Zollauftrag shows ERNDTEBRUCK as the city for Vishay Electronic GmbH",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "",
                "reasoning": "Declarant identification number not provided in the documents",
                "certainty": 0
            },
            "name": {
                "value": "CSV",
                "reasoning": "CSV is the customs broker handling the declaration as shown in Zollauftrag header",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "ANKERKADE 20",
                    "reasoning": "Zollauftrag header shows CSV address as ANKERKADE 20",
                    "certainty": 100
                },
                "country": {
                    "value": "NL",
                    "reasoning": "CSV is located in NETHERLANDS as shown in the Zollauftrag",
                    "certainty": 100
                },
                "postcode": {
                    "value": "5928 PL",
                    "reasoning": "Zollauftrag shows 5928 PL as CSV's postal code",
                    "certainty": 100
                },
                "city": {
                    "value": "VENLO",
                    "reasoning": "Zollauftrag shows VENLO as CSV's city",
                    "certainty": 100
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "TWSC25082101",
                        "reasoning": "House Bill of Lading number shown in Zollauftrag and on the actual Bill of Lading document",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "HDMUSELE08269301",
                        "reasoning": "Master Bill of Lading number provided by DSV in email correspondence",
                        "certainty": 100
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "SYCBB250825",
                        "reasoning": "Commercial invoice and packing list reference number dated 2025-08-25",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "SYCC250211-10",
                        "reasoning": "Sales contract reference number shown on invoice and packing list dated 2025-02-11",
                        "certainty": 100
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": "65628927",
                "reasoning": "Shipper ID shown in Zollauftrag for Sam Young Chemical Co. Ltd.",
                "certainty": 90
            },
            "name": {
                "value": "Sam Young Chemical Co. Ltd.",
                "reasoning": "Shipper name shown consistently across all documents (BL, invoice, packing list)",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "13th Floor Kwanjeong Bldg., 35 Cheng GYE Chun-Ro, Jongro-Gu",
                    "reasoning": "Address shown on Bill of Lading, invoice and packing list for Sam Young Chemical Co. Ltd.",
                    "certainty": 100
                },
                "country": {
                    "value": "KR",
                    "reasoning": "Korea, Republic of, specified as shipper country across all documents",
                    "certainty": 100
                },
                "postcode": {
                    "value": "03188",
                    "reasoning": "Postal code shown for Seoul address on BL, invoice and packing list",
                    "certainty": 100
                },
                "city": {
                    "value": "Seoul",
                    "reasoning": "Seoul specified as the city for Sam Young Chemical Co. Ltd. on all documents",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "65628927",
                "reasoning": "Same as exporter based on invoice structure showing Sam Young as seller",
                "certainty": 90
            },
            "name": {
                "value": "Sam Young Chemical Co. Ltd.",
                "reasoning": "Invoice issued by Sam Young Chemical Co. Ltd. indicating seller role",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "13th Floor Kwanjeong Bldg., 35 Cheng GYE Chun-Ro, Jongro-Gu",
                    "reasoning": "Seller address same as exporter on commercial invoice",
                    "certainty": 100
                },
                "country": {
                    "value": "KR",
                    "reasoning": "Korea, Republic of, as specified on invoice",
                    "certainty": 100
                },
                "postcode": {
                    "value": "03188",
                    "reasoning": "Seoul postal code shown on invoice",
                    "certainty": 100
                },
                "city": {
                    "value": "Seoul",
                    "reasoning": "Seoul specified as seller city on invoice",
                    "certainty": 100
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "",
                "reasoning": "Buyer identification not clearly specified; invoice shows 'For Account' as Birkelbach but email indicates company was acquired by Vishay",
                "certainty": 40
            },
            "name": {
                "value": "Birkelbach Kondensatortechnik GmbH",
                "reasoning": "Invoice and packing list show 'For Account & Risk of Messrs.' as Birkelbach Kondensatortechnik GmbH, indicating buyer role despite company acquisition",
                "certainty": 85
            },
            "address": {
                "streetAndNumber": {
                    "value": "Im Grunewald 4-Tor 1",
                    "reasoning": "Address shown on invoice and packing list for Birkelbach",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany specified for buyer address",
                    "certainty": 100
                },
                "postcode": {
                    "value": "57339",
                    "reasoning": "Postal code D-57339 shown for Birkelbach address",
                    "certainty": 100
                },
                "city": {
                    "value": "ERNDTEBRUCK",
                    "reasoning": "ERNDTEBRUCK specified as city for Birkelbach on invoice",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "DAP",
                "reasoning": "Zollauftrag specifies 'DAP - Delivered At Place' as incoterm, and invoice shows 'DAP ERNDTEBRUCK, GERMANY'",
                "certainty": 100
            }
        },
        "invoiceCurrency": {
            "value": "EUR",
            "reasoning": "Commercial invoice clearly shows all amounts in EUR currency",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 87158.78,
            "reasoning": "Commercial invoice total shows 87,158.78 EUR as final invoiced amount",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "DE",
            "reasoning": "Germany is the final destination as shown across all documents with delivery to Erndtebruck",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "KR",
            "reasoning": "Port of loading Busan, Korea shown on all documents indicates Korea as country of dispatch",
            "certainty": 100
        },
        "grossMass": {
            "value": 21439,
            "reasoning": "Gross mass of 21,439 KG consistently shown across Zollauftrag, BL, packing list",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "HMMU6172497",
                    "reasoning": "Container number shown in Zollauftrag, BL and packing list",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 4988.15,
                    "reasoning": "First line item on commercial invoice: 11.6mic thickness, 10 rolls, unit price 4.35 EUR, amount 4,988.15 EUR",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "KR",
                    "reasoning": "Commercial invoice declares products are of South Korea preferential origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 10,
                    "reasoning": "First item shows 10 rolls as quantity unit",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 1227,
                    "reasoning": "Packing list shows gross weight of 1,227.0 kg for first item (11.6mic, 14,000m, 10 rolls)",
                    "certainty": 100
                },
                "netMass": {
                    "value": 1146.7,
                    "reasoning": "Packing list shows net weight of 1,146.7 KG for first item",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Plain Polypropylene film for capacitors (PHCM) - Thickness 11.6mic, Width 760mm, Length 14,000m",
                    "reasoning": "Combined from goods description and specifications in packing list and invoice for first item",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 10,
                        "reasoning": "First item consists of 10 rolls on pallets",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "PLT",
                        "reasoning": "Pallets (PLT) specified as package type in Zollauftrag and documents",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3920202190",
                        "reasoning": "Zollauftrag specifies Warencode-ZTN: 3920 2021 90 0 for polypropylene films",
                        "certainty": 100
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "HMMU6172497",
                    "reasoning": "Same container for all goods",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 82170.63,
                    "reasoning": "Second line item on commercial invoice: 11.6mic thickness, 116 rolls, unit price 4.35 EUR, amount 82,170.63 EUR",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "KR",
                    "reasoning": "Commercial invoice declares products are of South Korea preferential origin",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 116,
                    "reasoning": "Second item shows 116 rolls as quantity unit",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 20212,
                    "reasoning": "Packing list shows gross weight of 20,212.0 kg for second item (11.6mic, 20,000m, 116 rolls)",
                    "certainty": 100
                },
                "netMass": {
                    "value": 18889.8,
                    "reasoning": "Packing list shows net weight of 18,889.8 KG for second item",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Plain Polypropylene film for capacitors (PHCM) - Thickness 11.6mic, Width 760mm, Length 20,000m",
                    "reasoning": "Combined from goods description and specifications in packing list and invoice for second item",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 116,
                        "reasoning": "Second item consists of 116 rolls on pallets",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "PLT",
                        "reasoning": "Pallets (PLT) specified as package type",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3920202190",
                        "reasoning": "Same commodity code applies to all polypropylene film items",
                        "certainty": 100
                    }
                }
            }
        ]
    }
}