CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: 92560903 FILE 21 50112 25 - EGETRANS Customs Clearance Request - SHIPPER: SHANGHAI SPEED / CONSIGNEE: TOPREGAL FILDER / AL MURAYKH GCXU 591813 6

Verwerkt: 10-12-2025 14:12:11

Voltooid
Uitvoering ID: csv_693971ab2a10d
Agent: Oscar

๐Ÿ“Š Geรซxtraheerde Ordergegevens

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

0%

No template code mentioned in the provided email

0%

Number of packages not specified in email

0%

Gross mass not specified in email

0%

Net mass not specified in email

0%

Commodity value not directly stated, only freight charges mentioned (2200 USD + 1070 EUR)

50%

Multiple currencies used (USD and EUR), USD for main freight charge to Rotterdam

0%

Representative code not specified in email

85%

CSV Logistics is handling customs clearance as freight forwarder

0%

Importer identification number not provided in email

75%

Consignee name from subject line, possibly two names or compound name

0%

Importer street address not provided

80%

Destination is Rotterdam (RTM) in Netherlands, and CSV in Venlo handles clearance

0%

Importer postcode not provided

0%

Importer city not provided, only Rotterdam mentioned as destination port

0%

CSV identification number not provided in email

95%

CSV is the customs broker handling the clearance request

95%

Address from CSV email signature

100%

CSV is located in The Netherlands per email signature

95%

Postcode from CSV email signature

95%

City from CSV email signature

0%

Exporter identification number not provided

95%

Shipper name from subject line

0%

Exporter street address not provided

90%

Company name includes 'SHANGHAI' indicating China origin

0%

Exporter postcode not provided

85%

Shanghai mentioned in company name

0%

Seller information not separately identified from exporter

70%

Assuming seller is same as shipper/exporter

0%

Seller street address not provided

70%

Assuming seller is same as exporter in China

0%

Seller postcode not provided

70%

Assuming seller location matches exporter

0%

Buyer information not separately identified

70%

Assuming buyer is same as consignee/importer

0%

Buyer street address not provided

70%

Assuming buyer is same as importer in Netherlands

0%

Buyer postcode not provided

0%

Buyer city not specified

0%

Incoterm not specified in email, only freight charges mentioned

60%

Primary freight charge is in USD (2200 USD), though EUR also used for local delivery

40%

Only freight charges mentioned (2200 USD + 1070 EUR), not actual commodity invoice value

85%

Rotterdam (RTM) mentioned as destination, Netherlands

85%

Shipper is SHANGHAI SPEED indicating dispatch from China

0%

Gross mass not specified in email

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "",
            "reasoning": "No template code mentioned in the provided email",
            "certainty": 0
        },
        "control": {
            "packages": {
                "value": null,
                "reasoning": "Number of packages not specified in email",
                "certainty": 0
            },
            "grossmass": {
                "value": null,
                "reasoning": "Gross mass not specified in email",
                "certainty": 0
            },
            "netmass": {
                "value": null,
                "reasoning": "Net mass not specified in email",
                "certainty": 0
            },
            "commodityValue": {
                "value": {
                    "value": null,
                    "reasoning": "Commodity value not directly stated, only freight charges mentioned (2200 USD + 1070 EUR)",
                    "certainty": 0
                },
                "currency": {
                    "value": "USD",
                    "reasoning": "Multiple currencies used (USD and EUR), USD for main freight charge to Rotterdam",
                    "certainty": 50
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "",
                "reasoning": "Representative code not specified in email",
                "certainty": 0
            },
            "representativeName": {
                "value": "CSV",
                "reasoning": "CSV Logistics is handling customs clearance as freight forwarder",
                "certainty": 85
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "",
                "reasoning": "Importer identification number not provided in email",
                "certainty": 0
            },
            "name": {
                "value": "TOPREGAL FILDER AL MURAYKH",
                "reasoning": "Consignee name from subject line, possibly two names or compound name",
                "certainty": 75
            },
            "address": {
                "streetAndNumber": {
                    "value": "",
                    "reasoning": "Importer street address not provided",
                    "certainty": 0
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Destination is Rotterdam (RTM) in Netherlands, and CSV in Venlo handles clearance",
                    "certainty": 80
                },
                "postcode": {
                    "value": "",
                    "reasoning": "Importer postcode not provided",
                    "certainty": 0
                },
                "city": {
                    "value": "",
                    "reasoning": "Importer city not provided, only Rotterdam mentioned as destination port",
                    "certainty": 0
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "",
                "reasoning": "CSV identification number not provided in email",
                "certainty": 0
            },
            "name": {
                "value": "CSV",
                "reasoning": "CSV is the customs broker handling the clearance request",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "Ankerkade 20",
                    "reasoning": "Address from CSV email signature",
                    "certainty": 95
                },
                "country": {
                    "value": "NL",
                    "reasoning": "CSV is located in The Netherlands per email signature",
                    "certainty": 100
                },
                "postcode": {
                    "value": "5928 PL",
                    "reasoning": "Postcode from CSV email signature",
                    "certainty": 95
                },
                "city": {
                    "value": "Venlo",
                    "reasoning": "City from CSV email signature",
                    "certainty": 95
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "92560903",
                        "reasoning": "File reference number from subject line",
                        "certainty": 90
                    }
                },
                {
                    "referenceNumber": {
                        "value": "21 50112 25",
                        "reasoning": "Additional file reference from subject line",
                        "certainty": 85
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": []
        },
        "exporter": {
            "identificationNumber": {
                "value": "",
                "reasoning": "Exporter identification number not provided",
                "certainty": 0
            },
            "name": {
                "value": "SHANGHAI SPEED",
                "reasoning": "Shipper name from subject line",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "",
                    "reasoning": "Exporter street address not provided",
                    "certainty": 0
                },
                "country": {
                    "value": "CN",
                    "reasoning": "Company name includes 'SHANGHAI' indicating China origin",
                    "certainty": 90
                },
                "postcode": {
                    "value": "",
                    "reasoning": "Exporter postcode not provided",
                    "certainty": 0
                },
                "city": {
                    "value": "Shanghai",
                    "reasoning": "Shanghai mentioned in company name",
                    "certainty": 85
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "",
                "reasoning": "Seller information not separately identified from exporter",
                "certainty": 0
            },
            "name": {
                "value": "SHANGHAI SPEED",
                "reasoning": "Assuming seller is same as shipper/exporter",
                "certainty": 70
            },
            "address": {
                "streetAndNumber": {
                    "value": "",
                    "reasoning": "Seller street address not provided",
                    "certainty": 0
                },
                "country": {
                    "value": "CN",
                    "reasoning": "Assuming seller is same as exporter in China",
                    "certainty": 70
                },
                "postcode": {
                    "value": "",
                    "reasoning": "Seller postcode not provided",
                    "certainty": 0
                },
                "city": {
                    "value": "Shanghai",
                    "reasoning": "Assuming seller location matches exporter",
                    "certainty": 70
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "",
                "reasoning": "Buyer information not separately identified",
                "certainty": 0
            },
            "name": {
                "value": "TOPREGAL FILDER AL MURAYKH",
                "reasoning": "Assuming buyer is same as consignee/importer",
                "certainty": 70
            },
            "address": {
                "streetAndNumber": {
                    "value": "",
                    "reasoning": "Buyer street address not provided",
                    "certainty": 0
                },
                "country": {
                    "value": "NL",
                    "reasoning": "Assuming buyer is same as importer in Netherlands",
                    "certainty": 70
                },
                "postcode": {
                    "value": "",
                    "reasoning": "Buyer postcode not provided",
                    "certainty": 0
                },
                "city": {
                    "value": "",
                    "reasoning": "Buyer city not specified",
                    "certainty": 0
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "",
                "reasoning": "Incoterm not specified in email, only freight charges mentioned",
                "certainty": 0
            }
        },
        "invoiceCurrency": {
            "value": "USD",
            "reasoning": "Primary freight charge is in USD (2200 USD), though EUR also used for local delivery",
            "certainty": 60
        },
        "totalAmountInvoiced": {
            "value": 2200,
            "reasoning": "Only freight charges mentioned (2200 USD + 1070 EUR), not actual commodity invoice value",
            "certainty": 40
        },
        "countryOfDestination": {
            "value": "NL",
            "reasoning": "Rotterdam (RTM) mentioned as destination, Netherlands",
            "certainty": 85
        },
        "countryOfDispatch": {
            "value": "CN",
            "reasoning": "Shipper is SHANGHAI SPEED indicating dispatch from China",
            "certainty": 85
        },
        "grossMass": {
            "value": null,
            "reasoning": "Gross mass not specified in email",
            "certainty": 0
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "GCXU5918136",
                    "reasoning": "Container number from subject line 'GCXU 591813 6' - formatted without spaces",
                    "certainty": 90
                },
                "itemAmountInvoiced": {
                    "value": null,
                    "reasoning": "Item invoice amount not provided, only freight charges mentioned",
                    "certainty": 0
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Origin is China based on Shanghai shipper",
                    "certainty": 85
                },
                "supplementaryUnits": {
                    "value": null,
                    "reasoning": "Supplementary units not specified",
                    "certainty": 0
                },
                "grossMass": {
                    "value": null,
                    "reasoning": "Gross mass not specified for item",
                    "certainty": 0
                },
                "netMass": {
                    "value": null,
                    "reasoning": "Net mass not specified for item",
                    "certainty": 0
                },
                "descriptionOfGoods": {
                    "value": "Iron Rack",
                    "reasoning": "Description provided in email body alongside HS code",
                    "certainty": 95
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": null,
                        "reasoning": "Number of packages not specified",
                        "certainty": 0
                    },
                    "typeOfPackages": {
                        "value": "",
                        "reasoning": "Package type not specified",
                        "certainty": 0
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "9403208000",
                        "reasoning": "HS code explicitly stated in email: '9403208000 - Iron Rack'",
                        "certainty": 100
                    }
                }
            }
        ]
    }
}