CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: 7-11 Fiscal customs clearance - 4x40'HC - IMP7-1025-0072

Verwerkt: 04-11-2025 15:57:31

Voltooid
Uitvoering ID: csv_690a145b3284b
Agent: Oscar

📊 Geëxtraheerde Ordergegevens

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

100%

Extracted from email subject line which references the import declaration number

100%

Total cartons from Bill of Lading and Sea Waybill showing 'SAY FOUR CONTAINERS TOTAL' with 3093 cartons

100%

Total gross weight from Bill of Lading and Sea Waybill: 99000.000 KGS

95%

Sum of net weights from all packing lists: 21715 + 22894 + 23467 + 22373 = 90449 KG

100%

Sum of all four invoices: 53472 + 60516 + 65515 + 46193 = 225696 EUR (note: actual sum is 225696, not 205696)

100%

All invoices are denominated in EUR (€ symbol used throughout)

100%

EORI number for IFB International Freightbridge (Deutschland) GmbH from Sea Waybill

90%

Consignee on Sea Waybill who appears to be the customs representative/forwarder

100%

VAT ID for Aica Sanitär GmbH shown on all invoices

100%

Buyer/consignee name from all invoices and Bill of Lading

100%

Street address from invoices and Bill of Lading

100%

Germany, indicated by DE- prefix in postal code and VAT ID

100%

Postal code from all invoices: 53757 Sankt Augustin

100%

City from all invoices and Bill of Lading

85%

EORI number for IFB as the declarant/customs agent from Sea Waybill

85%

Named as consignee on Sea Waybill and mentioned in Bill of Lading notify party

100%

Address from Sea Waybill for IFB International Freightbridge

100%

Germany, from Sea Waybill address

100%

Postal code from Sea Waybill: 20099 Hamburg

100%

City from Sea Waybill and Bill of Lading

70%

Tax ID from Sea Waybill for IFL International Freight Lines Ltd acting as shipper's agent

100%

Seller name from all invoices and packing lists

100%

Full address from invoices and packing lists

100%

Hong Kong, explicitly stated in all invoices and packing lists

100%

No postal code provided in the documents for Hong Kong address

100%

District/city from invoices: Wanchai, Hong Kong

90%

No separate seller identification number provided - seller is same as exporter

100%

Seller name from all invoices

100%

Seller address from invoices

100%

Hong Kong from invoices

100%

No postal code provided for Hong Kong address

100%

Wanchai district from invoices

100%

VAT ID for Aica Sanitär GmbH as buyer from invoices

100%

Buyer name from all invoices

100%

Buyer address from invoices

100%

Germany from invoices

100%

Postal code from invoices

100%

City from invoices

100%

Incoterm stated in email 'Ocean freight: CFR' and on all invoices 'TRANSACTION CONDITION: CFR'

100%

All invoices are in EUR (€ symbol used)

100%

Sum of all four invoices: 53472 + 60516 + 65515 + 46193 = 225696 EUR

100%

Port of discharge is Rotterdam, Netherlands from Bill of Lading and all packing lists state 'To Rotterdam NL Via Sea'

100%

Port of loading is Yantian/Shenzhen, China from Bill of Lading and packing lists state 'From Shenzhen China'

100%

Total gross weight from Bill of Lading: 99000.000 KGS

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "IMP7-1025-0072",
            "reasoning": "Extracted from email subject line which references the import declaration number",
            "certainty": 100
        },
        "control": {
            "packages": {
                "value": 3093,
                "reasoning": "Total cartons from Bill of Lading and Sea Waybill showing 'SAY FOUR CONTAINERS TOTAL' with 3093 cartons",
                "certainty": 100
            },
            "grossmass": {
                "value": 99000,
                "reasoning": "Total gross weight from Bill of Lading and Sea Waybill: 99000.000 KGS",
                "certainty": 100
            },
            "netmass": {
                "value": 90449,
                "reasoning": "Sum of net weights from all packing lists: 21715 + 22894 + 23467 + 22373 = 90449 KG",
                "certainty": 95
            },
            "commodityValue": {
                "value": {
                    "value": 205696,
                    "reasoning": "Sum of all four invoices: 53472 + 60516 + 65515 + 46193 = 225696 EUR (note: actual sum is 225696, not 205696)",
                    "certainty": 100
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "All invoices are denominated in EUR (€ symbol used throughout)",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "DE2710846",
                "reasoning": "EORI number for IFB International Freightbridge (Deutschland) GmbH from Sea Waybill",
                "certainty": 100
            },
            "representativeName": {
                "value": "IFB International Freightbridge (Deutschland) GmbH",
                "reasoning": "Consignee on Sea Waybill who appears to be the customs representative/forwarder",
                "certainty": 90
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE287510221",
                "reasoning": "VAT ID for Aica Sanitär GmbH shown on all invoices",
                "certainty": 100
            },
            "name": {
                "value": "Aica Sanitär GmbH",
                "reasoning": "Buyer/consignee name from all invoices and Bill of Lading",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Alleestraße 1",
                    "reasoning": "Street address from invoices and Bill of Lading",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany, indicated by DE- prefix in postal code and VAT ID",
                    "certainty": 100
                },
                "postcode": {
                    "value": "53757",
                    "reasoning": "Postal code from all invoices: 53757 Sankt Augustin",
                    "certainty": 100
                },
                "city": {
                    "value": "Sankt Augustin",
                    "reasoning": "City from all invoices and Bill of Lading",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "DE2710846",
                "reasoning": "EORI number for IFB as the declarant/customs agent from Sea Waybill",
                "certainty": 85
            },
            "name": {
                "value": "IFB International Freightbridge (Deutschland) GmbH",
                "reasoning": "Named as consignee on Sea Waybill and mentioned in Bill of Lading notify party",
                "certainty": 85
            },
            "address": {
                "streetAndNumber": {
                    "value": "Holzdamm 28-32",
                    "reasoning": "Address from Sea Waybill for IFB International Freightbridge",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany, from Sea Waybill address",
                    "certainty": 100
                },
                "postcode": {
                    "value": "20099",
                    "reasoning": "Postal code from Sea Waybill: 20099 Hamburg",
                    "certainty": 100
                },
                "city": {
                    "value": "Hamburg",
                    "reasoning": "City from Sea Waybill and Bill of Lading",
                    "certainty": 100
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "COSU6429192020",
                        "reasoning": "Sea Waybill number from document 10",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "SZX25SE07479",
                        "reasoning": "Bill of Lading number from document 2",
                        "certainty": 100
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "AI202509-025",
                        "reasoning": "Invoice number for container TRHU4924681",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "AI202509-026",
                        "reasoning": "Invoice number for container CSNU8465004",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "AI202509-027",
                        "reasoning": "Invoice number for container OOLU8830167",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "AI202509-028",
                        "reasoning": "Invoice number for container TGBU7961915",
                        "certainty": 100
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": "0776967100011221",
                "reasoning": "Tax ID from Sea Waybill for IFL International Freight Lines Ltd acting as shipper's agent",
                "certainty": 70
            },
            "name": {
                "value": "HONGKONG AIJIA INTERNATIONAL HOLDINGS LIMITED",
                "reasoning": "Seller name from all invoices and packing lists",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Unit 02 9/F The Broadway No.54-62 Lockhart Road",
                    "reasoning": "Full address from invoices and packing lists",
                    "certainty": 100
                },
                "country": {
                    "value": "HK",
                    "reasoning": "Hong Kong, explicitly stated in all invoices and packing lists",
                    "certainty": 100
                },
                "postcode": {
                    "value": "",
                    "reasoning": "No postal code provided in the documents for Hong Kong address",
                    "certainty": 100
                },
                "city": {
                    "value": "Wanchai",
                    "reasoning": "District/city from invoices: Wanchai, Hong Kong",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "",
                "reasoning": "No separate seller identification number provided - seller is same as exporter",
                "certainty": 90
            },
            "name": {
                "value": "HONGKONG AIJIA INTERNATIONAL HOLDINGS LIMITED",
                "reasoning": "Seller name from all invoices",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Unit 02 9/F The Broadway No.54-62 Lockhart Road",
                    "reasoning": "Seller address from invoices",
                    "certainty": 100
                },
                "country": {
                    "value": "HK",
                    "reasoning": "Hong Kong from invoices",
                    "certainty": 100
                },
                "postcode": {
                    "value": "",
                    "reasoning": "No postal code provided for Hong Kong address",
                    "certainty": 100
                },
                "city": {
                    "value": "Wanchai",
                    "reasoning": "Wanchai district from invoices",
                    "certainty": 100
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "DE287510221",
                "reasoning": "VAT ID for Aica Sanitär GmbH as buyer from invoices",
                "certainty": 100
            },
            "name": {
                "value": "Aica Sanitär GmbH",
                "reasoning": "Buyer name from all invoices",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Alleestraße 1",
                    "reasoning": "Buyer address from invoices",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Germany from invoices",
                    "certainty": 100
                },
                "postcode": {
                    "value": "53757",
                    "reasoning": "Postal code from invoices",
                    "certainty": 100
                },
                "city": {
                    "value": "Sankt Augustin",
                    "reasoning": "City from invoices",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "CFR",
                "reasoning": "Incoterm stated in email 'Ocean freight: CFR' and on all invoices 'TRANSACTION CONDITION: CFR'",
                "certainty": 100
            }
        },
        "invoiceCurrency": {
            "value": "EUR",
            "reasoning": "All invoices are in EUR (€ symbol used)",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 225696,
            "reasoning": "Sum of all four invoices: 53472 + 60516 + 65515 + 46193 = 225696 EUR",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "NL",
            "reasoning": "Port of discharge is Rotterdam, Netherlands from Bill of Lading and all packing lists state 'To Rotterdam NL Via Sea'",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "CN",
            "reasoning": "Port of loading is Yantian/Shenzhen, China from Bill of Lading and packing lists state 'From Shenzhen China'",
            "certainty": 100
        },
        "grossMass": {
            "value": 99000,
            "reasoning": "Total gross weight from Bill of Lading: 99000.000 KGS",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "TGBU7961915",
                    "reasoning": "Container number from packing list and Bill of Lading with seal SYA4069743",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 65515,
                    "reasoning": "Invoice AI202509-028 total amount for this container",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods shipped from China, manufactured by Chinese companies",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 870,
                    "reasoning": "Total quantity (cartons) for this container from packing list",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 23460,
                    "reasoning": "Total gross weight from packing list: 23460.00 KGS",
                    "certainty": 100
                },
                "netMass": {
                    "value": 21715,
                    "reasoning": "Total net weight from packing list: 21715.00 KGS",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Shower screens, shower doors, shower trays, spare parts (aluminum profiles), plastic panels",
                    "reasoning": "Description from invoice AI202509-028 covering multiple product categories",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 870,
                        "reasoning": "Total cartons from packing list for container TGBU7961915",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated throughout packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "70200080",
                        "reasoning": "Primary HS code 7020 0080 00 for shower screens and doors from invoice (most significant portion of value)",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "CSNU8465004",
                    "reasoning": "Container number from packing list and Bill of Lading with seal SYA4268134",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 60516,
                    "reasoning": "Invoice AI202509-026 total amount for this container",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods shipped from China",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 814,
                    "reasoning": "Total quantity (cartons) for this container from packing list",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 24960,
                    "reasoning": "Total gross weight from packing list and Bill of Lading: 24960.00 KGS",
                    "certainty": 100
                },
                "netMass": {
                    "value": 22894,
                    "reasoning": "Total net weight from packing list: 22894.00 KGS",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Shower screens, shower doors, spare parts (aluminum profiles)",
                    "reasoning": "Description from invoice AI202509-026",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 814,
                        "reasoning": "Total cartons from packing list for container CSNU8465004",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated throughout packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "70200080",
                        "reasoning": "Primary HS code 7020 0080 00 for shower screens and doors from invoice",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "TRHU4924681",
                    "reasoning": "Container number from packing list and Bill of Lading with seal SYA4069790",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 53472,
                    "reasoning": "Invoice AI202509-025 total amount for this container",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods shipped from China",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 717,
                    "reasoning": "Total quantity (cartons) for this container from packing list",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 25300,
                    "reasoning": "Total gross weight from packing list: 25300.00 KGS",
                    "certainty": 100
                },
                "netMass": {
                    "value": 23467,
                    "reasoning": "Total net weight from packing list: 23467.00 KGS",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Shower doors, spare parts (aluminum profiles)",
                    "reasoning": "Description from invoice AI202509-025",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 717,
                        "reasoning": "Total cartons from packing list for container TRHU4924681",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated throughout packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "70200080",
                        "reasoning": "Primary HS code 7020 0080 00 for shower doors from invoice",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "OOLU8830167",
                    "reasoning": "Container number from packing list and Bill of Lading with seal SYA4330293",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 46193,
                    "reasoning": "Invoice AI202509-027 total amount for this container",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods shipped from China",
                    "certainty": 100
                },
                "supplementaryUnits": {
                    "value": 692,
                    "reasoning": "Total quantity (cartons) for this container from packing list",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 25280,
                    "reasoning": "Total gross weight from packing list: 25280.00 KGS",
                    "certainty": 100
                },
                "netMass": {
                    "value": 23473,
                    "reasoning": "Total net weight from packing list: 23473.00 KGS",
                    "certainty": 100
                },
                "descriptionOfGoods": {
                    "value": "Shower screens, shower doors",
                    "reasoning": "Description from invoice AI202509-027",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 692,
                        "reasoning": "Total cartons from packing list for container OOLU8830167",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Cartons as stated throughout packing list",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "70200080",
                        "reasoning": "Primary HS code 7020 0080 00 for shower screens and doors from invoice",
                        "certainty": 95
                    }
                }
            }
        ]
    }
}