CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: Verzollungsauftrag // Republic Floor // 2 x 20'Cont. / IMP1-1225-0049

Verwerkt: 10-12-2025 15:03:01

Voltooid
Uitvoering ID: csv_69397d954dd4f
Agent: Oscar

📊 Geëxtraheerde Ordergegevens

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

95%

Reference number found in email subject line and identified as integration reference

100%

Explicitly stated as '37 PACKAGES' in both sea waybill and bill of lading documents

100%

Stated as 'GROSS WEIGHT: 28245.000KGS' in sea waybill page 2 and bill of lading

95%

Found in packing list (invoice page 5) showing total N.W. as 27700.00

100%

Total amount from commercial invoice showing $32,182.85 as final sum

100%

All amounts in commercial invoice are denominated in USD with $ symbol

85%

CSV Logistics identified as customs representative forwarding the declaration

90%

Email sender and signature block identify CSV as customs representative at Ankerkade 20, 5928 PL Venlo

100%

EORI number for UMT United Logistics GmbH shown on sea waybill

100%

Named as consignee on bill of lading and notify party on waybill

100%

Complete street address from bill of lading consignee section

100%

Located in Germany (Deutschland) as stated in bill of lading

100%

Postal code from consignee address on bill of lading

100%

City name from consignee address on bill of lading

90%

VAT-ID for UMT United Logistics GmbH shown as handling agent

95%

Forwarding agent named in bill of lading and email chain

100%

Street address from forwarding agent references in bill of lading

100%

Located in Hamburg, Germany

100%

Postal code from forwarding agent address in bill of lading

100%

City from forwarding agent address in bill of lading

85%

Identification number shown for shipper on sea waybill

100%

Named as shipper/exporter on bill of lading

100%

Street address from shipper section on bill of lading

100%

Located in Changzhou, Jiangsu, China as stated on bill of lading

0%

Postal code not provided in shipper address

100%

City and province from shipper address on bill of lading

85%

Same as exporter identification

100%

Seller is the same entity as exporter per commercial invoice

100%

Same as exporter address

100%

Same as exporter country

0%

Not provided in documents

100%

Same as exporter city

90%

Same as importer EORI number

100%

Buyer is the same entity as importer/consignee

100%

Same as importer address

100%

Same as importer country

100%

Same as importer postcode

100%

Same as importer city

85%

Type of movement stated as 'CY-CY' on sea waybill indicating container yard to container yard delivery

100%

All invoice amounts denominated in USD as shown in commercial invoice

100%

Total amount from commercial invoice summing all line items

100%

Port of discharge is Rotterdam, Netherlands as stated on waybill and bill of lading

100%

Port of loading is Shanghai, China as stated on waybill and bill of lading

100%

Total gross mass stated on sea waybill page 2

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "IMP1-1225-0049",
            "reasoning": "Reference number found in email subject line and identified as integration reference",
            "certainty": 95
        },
        "control": {
            "packages": {
                "value": 37,
                "reasoning": "Explicitly stated as '37 PACKAGES' in both sea waybill and bill of lading documents",
                "certainty": 100
            },
            "grossmass": {
                "value": 28245,
                "reasoning": "Stated as 'GROSS WEIGHT: 28245.000KGS' in sea waybill page 2 and bill of lading",
                "certainty": 100
            },
            "netmass": {
                "value": 27700,
                "reasoning": "Found in packing list (invoice page 5) showing total N.W. as 27700.00",
                "certainty": 95
            },
            "commodityValue": {
                "value": {
                    "value": 32182.85,
                    "reasoning": "Total amount from commercial invoice showing $32,182.85 as final sum",
                    "certainty": 100
                },
                "currency": {
                    "value": "USD",
                    "reasoning": "All amounts in commercial invoice are denominated in USD with $ symbol",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "CSV",
                "reasoning": "CSV Logistics identified as customs representative forwarding the declaration",
                "certainty": 85
            },
            "representativeName": {
                "value": "CSV Customs Solutions Venlo",
                "reasoning": "Email sender and signature block identify CSV as customs representative at Ankerkade 20, 5928 PL Venlo",
                "certainty": 90
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE6932444",
                "reasoning": "EORI number for UMT United Logistics GmbH shown on sea waybill",
                "certainty": 100
            },
            "name": {
                "value": "REPUBLIC FLOOR GMBH",
                "reasoning": "Named as consignee on bill of lading and notify party on waybill",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "FERDINAND-GABRIEL-WEG 4-8",
                    "reasoning": "Complete street address from bill of lading consignee section",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Located in Germany (Deutschland) as stated in bill of lading",
                    "certainty": 100
                },
                "postcode": {
                    "value": "59494",
                    "reasoning": "Postal code from consignee address on bill of lading",
                    "certainty": 100
                },
                "city": {
                    "value": "SOEST",
                    "reasoning": "City name from consignee address on bill of lading",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "DE203769852",
                "reasoning": "VAT-ID for UMT United Logistics GmbH shown as handling agent",
                "certainty": 90
            },
            "name": {
                "value": "UMT UNITED LOGISTICS GMBH",
                "reasoning": "Forwarding agent named in bill of lading and email chain",
                "certainty": 95
            },
            "address": {
                "streetAndNumber": {
                    "value": "HOLZDAMM 28-32",
                    "reasoning": "Street address from forwarding agent references in bill of lading",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Located in Hamburg, Germany",
                    "certainty": 100
                },
                "postcode": {
                    "value": "20099",
                    "reasoning": "Postal code from forwarding agent address in bill of lading",
                    "certainty": 100
                },
                "city": {
                    "value": "HAMBURG",
                    "reasoning": "City from forwarding agent address in bill of lading",
                    "certainty": 100
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "COSU6435897040",
                        "reasoning": "Sea waybill number and booking number from transport documents",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "SZHZ25111433",
                        "reasoning": "Bill of lading number from combined transport B/L",
                        "certainty": 100
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "JMZ C25092",
                        "reasoning": "Invoice number from commercial invoice for laminated display rack",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "DKST251112",
                        "reasoning": "Invoice number from commercial invoice for display board",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "RELX251113",
                        "reasoning": "Invoice number from commercial invoice for vinyl flooring",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "DKST251114",
                        "reasoning": "Invoice number from commercial invoice for display board",
                        "certainty": 100
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": "6435897040",
                "reasoning": "Identification number shown for shipper on sea waybill",
                "certainty": 85
            },
            "name": {
                "value": "CHANGZHOU DECOR STAR DECORATIVE MATERIALS CO.,LTD",
                "reasoning": "Named as shipper/exporter on bill of lading",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "BUILDING 2, WANDA PLAZA, XINBEI DISTRICT",
                    "reasoning": "Street address from shipper section on bill of lading",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "Located in Changzhou, Jiangsu, China as stated on bill of lading",
                    "certainty": 100
                },
                "postcode": {
                    "value": "",
                    "reasoning": "Postal code not provided in shipper address",
                    "certainty": 0
                },
                "city": {
                    "value": "CHANGZHOU, JIANGSU",
                    "reasoning": "City and province from shipper address on bill of lading",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "6435897040",
                "reasoning": "Same as exporter identification",
                "certainty": 85
            },
            "name": {
                "value": "CHANGZHOU DECOR STAR DECORATIVE MATERIALS CO.,LTD",
                "reasoning": "Seller is the same entity as exporter per commercial invoice",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "BUILDING 2, WANDA PLAZA, XINBEI DISTRICT",
                    "reasoning": "Same as exporter address",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "Same as exporter country",
                    "certainty": 100
                },
                "postcode": {
                    "value": "",
                    "reasoning": "Not provided in documents",
                    "certainty": 0
                },
                "city": {
                    "value": "CHANGZHOU, JIANGSU",
                    "reasoning": "Same as exporter city",
                    "certainty": 100
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "DE6932444",
                "reasoning": "Same as importer EORI number",
                "certainty": 90
            },
            "name": {
                "value": "REPUBLIC FLOOR GMBH",
                "reasoning": "Buyer is the same entity as importer/consignee",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "FERDINAND-GABRIEL-WEG 4-8",
                    "reasoning": "Same as importer address",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Same as importer country",
                    "certainty": 100
                },
                "postcode": {
                    "value": "59494",
                    "reasoning": "Same as importer postcode",
                    "certainty": 100
                },
                "city": {
                    "value": "SOEST",
                    "reasoning": "Same as importer city",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "CY-CY",
                "reasoning": "Type of movement stated as 'CY-CY' on sea waybill indicating container yard to container yard delivery",
                "certainty": 85
            }
        },
        "invoiceCurrency": {
            "value": "USD",
            "reasoning": "All invoice amounts denominated in USD as shown in commercial invoice",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 32182.85,
            "reasoning": "Total amount from commercial invoice summing all line items",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "NL",
            "reasoning": "Port of discharge is Rotterdam, Netherlands as stated on waybill and bill of lading",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "CN",
            "reasoning": "Port of loading is Shanghai, China as stated on waybill and bill of lading",
            "certainty": 100
        },
        "grossMass": {
            "value": 28245,
            "reasoning": "Total gross mass stated on sea waybill page 2",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "GAOU2618112",
                    "reasoning": "First container number from bill of lading details",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 11464,
                    "reasoning": "Portion of goods in first container based on weight distribution from B/L",
                    "certainty": 75
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods manufactured and shipped from China by Chinese company",
                    "certainty": 95
                },
                "supplementaryUnits": {
                    "value": 0,
                    "reasoning": "Not specified in documents",
                    "certainty": 0
                },
                "grossMass": {
                    "value": 11464,
                    "reasoning": "Gross mass for first container stated in bill of lading",
                    "certainty": 100
                },
                "netMass": {
                    "value": 11200,
                    "reasoning": "Estimated based on proportion of total net mass",
                    "certainty": 70
                },
                "descriptionOfGoods": {
                    "value": "LAMINATED DISPLAY RACK, DISPLAY BOARD, VINYL FLOORING",
                    "reasoning": "Description from bill of lading and invoice combining all product types",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 16,
                        "reasoning": "16 packages stated for first container GAOU2618112 in bill of lading",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "GP",
                        "reasoning": "20GP container type indicating general purpose packages",
                        "certainty": 85
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3918109090",
                        "reasoning": "Customs tariff number (Zolltarifnummer) provided in email for vinyl flooring floor coverings",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "GAOU2618339",
                    "reasoning": "Second container number from bill of lading details",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 16781,
                    "reasoning": "Portion of goods in second container based on weight distribution from B/L",
                    "certainty": 75
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods manufactured and shipped from China by Chinese company",
                    "certainty": 95
                },
                "supplementaryUnits": {
                    "value": 0,
                    "reasoning": "Not specified in documents",
                    "certainty": 0
                },
                "grossMass": {
                    "value": 16781,
                    "reasoning": "Gross mass for second container stated in bill of lading",
                    "certainty": 100
                },
                "netMass": {
                    "value": 16500,
                    "reasoning": "Estimated based on proportion of total net mass",
                    "certainty": 70
                },
                "descriptionOfGoods": {
                    "value": "LAMINATED DISPLAY RACK, DISPLAY BOARD, VINYL FLOORING",
                    "reasoning": "Description from bill of lading and invoice combining all product types",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 21,
                        "reasoning": "21 packages stated for second container GAOU2618339 in bill of lading",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "GP",
                        "reasoning": "20GP container type indicating general purpose packages",
                        "certainty": 85
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "3918109090",
                        "reasoning": "Customs tariff number (Zolltarifnummer) provided in email for vinyl flooring floor coverings",
                        "certainty": 95
                    }
                }
            }
        ]
    }
}