CSV Dataverwerking

Data Verwerkingsstatus

Vernieuwen
Terug naar overzicht

FW: Uren inschatting API koppeling Custo

Verwerkt: 14-11-2025 22:25:25

Voltooid
Uitvoering ID: simulate_69179e455caad
Agent: Oscar

📊 Geëxtraheerde Ordergegevens

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

100%

This is an import customs declaration as indicated by the document title 'Sea Freight FCL Arrival Customs Instructions Import'

100%

From the customs instruction document: '618 CTN (OUTER), 0 PCE (INNER)'

100%

From container details in customs instruction document: 'GROSS: 11056 KG'

100%

From the packages weight section: '7,226.200 KG' and container details 'NET WT: 7226.2 KG'

90%

From invoice Z20250906353 total amount in EUR: '17,003.90 €'

100%

Invoice shows amounts in EUR (€) and mentions 'FOB SHANGHAI' pricing in euros

0%

Fiscal Representative section is mentioned in the document but no code or name is provided

0%

Fiscal Representative section is mentioned but no name is provided in the documents

100%

VAT number for HALTERNER TECHNOLOGIE GMBH shown as 'UST: DE343695821' in consignee details

100%

Consignee name from customs instruction document

100%

Street address from consignee details in customs instruction document

100%

Country is GERMANY as stated in consignee address

100%

Postal code from consignee address '40880 RATINGEN'

100%

City from consignee address '40880 RATINGEN'

0%

No declarant identification number is provided in the documents. The customs solutions company (CSV) is mentioned but without a specific ID

85%

The T1 document header shows 'CUSTOMS SOLUTIONS VENLO B.V.' as the handling party

85%

Address from T1 customs document header

85%

NETHERLANDS as stated in T1 document

85%

Postal code from T1 document address

85%

City from T1 document address

0%

No identification number provided for the shipper/exporter in the documents

100%

Shipper name from customs instruction document and all supporting documents

100%

Complete street address from shipper details in customs instruction document

100%

Country is CHINA as stated in shipper address

100%

Postal code from shipper address in customs instruction document

100%

City from shipper address

50%

No separate seller identification provided; seller appears to be same as exporter

90%

Invoice shows shipper as seller (same as exporter)

90%

Address from invoice document (slight variation in formatting from customs doc)

100%

CHINA as stated in seller address

80%

Same postal code as exporter

100%

City from seller address

100%

VAT number for buyer (same as importer/consignee) from invoice: 'VAT:DE343695821'

100%

Buyer name from invoice (same as consignee)

95%

Street address from invoice (note: different from warehouse delivery address HARKORTSTRASSE 12-32)

100%

GERMANY as stated in buyer address

95%

Postal code from invoice buyer address (note: different from delivery address 40880)

100%

City from buyer address on invoice

100%

Incoterm stated in customs instruction document as 'Incoterm: CFR Rotterdam'

100%

Invoice Z20250906353 shows all amounts in EUR (€)

100%

Total amount from invoice: '17,003.90 €'

100%

Port of discharge and place of delivery is 'ROTTERDAM, NETHERLANDS'

100%

Port of loading is 'SHANGHAI, CHINA' from both customs instruction and sea waybill

100%

Gross weight from container details: 'GROSS: 11056 KG'

Toon ruwe JSON
{
    "integration": {
        "templateCode": {
            "value": "IM",
            "reasoning": "This is an import customs declaration as indicated by the document title 'Sea Freight FCL Arrival Customs Instructions Import'",
            "certainty": 100
        },
        "control": {
            "packages": {
                "value": 618,
                "reasoning": "From the customs instruction document: '618 CTN (OUTER), 0 PCE (INNER)'",
                "certainty": 100
            },
            "grossmass": {
                "value": 11056,
                "reasoning": "From container details in customs instruction document: 'GROSS: 11056 KG'",
                "certainty": 100
            },
            "netmass": {
                "value": 7226.2,
                "reasoning": "From the packages weight section: '7,226.200 KG' and container details 'NET WT: 7226.2 KG'",
                "certainty": 100
            },
            "commodityValue": {
                "value": {
                    "value": 17003.9,
                    "reasoning": "From invoice Z20250906353 total amount in EUR: '17,003.90 €'",
                    "certainty": 90
                },
                "currency": {
                    "value": "EUR",
                    "reasoning": "Invoice shows amounts in EUR (€) and mentions 'FOB SHANGHAI' pricing in euros",
                    "certainty": 100
                }
            }
        },
        "fiscal": {
            "representativeCode": {
                "value": "",
                "reasoning": "Fiscal Representative section is mentioned in the document but no code or name is provided",
                "certainty": 0
            },
            "representativeName": {
                "value": "",
                "reasoning": "Fiscal Representative section is mentioned but no name is provided in the documents",
                "certainty": 0
            }
        }
    },
    "declaration": {
        "importer": {
            "identificationNumber": {
                "value": "DE343695821",
                "reasoning": "VAT number for HALTERNER TECHNOLOGIE GMBH shown as 'UST: DE343695821' in consignee details",
                "certainty": 100
            },
            "name": {
                "value": "HALTERNER TECHNOLOGIE GMBH",
                "reasoning": "Consignee name from customs instruction document",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "HARKORTSTRASSE 12-32",
                    "reasoning": "Street address from consignee details in customs instruction document",
                    "certainty": 100
                },
                "country": {
                    "value": "DE",
                    "reasoning": "Country is GERMANY as stated in consignee address",
                    "certainty": 100
                },
                "postcode": {
                    "value": "40880",
                    "reasoning": "Postal code from consignee address '40880 RATINGEN'",
                    "certainty": 100
                },
                "city": {
                    "value": "RATINGEN",
                    "reasoning": "City from consignee address '40880 RATINGEN'",
                    "certainty": 100
                }
            }
        },
        "declarant": {
            "identificationNumber": {
                "value": "",
                "reasoning": "No declarant identification number is provided in the documents. The customs solutions company (CSV) is mentioned but without a specific ID",
                "certainty": 0
            },
            "name": {
                "value": "CUSTOMS SOLUTIONS VENLO B.V.",
                "reasoning": "The T1 document header shows 'CUSTOMS SOLUTIONS VENLO B.V.' as the handling party",
                "certainty": 85
            },
            "address": {
                "streetAndNumber": {
                    "value": "ANKERKADE 20",
                    "reasoning": "Address from T1 customs document header",
                    "certainty": 85
                },
                "country": {
                    "value": "NL",
                    "reasoning": "NETHERLANDS as stated in T1 document",
                    "certainty": 85
                },
                "postcode": {
                    "value": "5928 PL",
                    "reasoning": "Postal code from T1 document address",
                    "certainty": 85
                },
                "city": {
                    "value": "VENLO",
                    "reasoning": "City from T1 document address",
                    "certainty": 85
                }
            }
        }
    },
    "goodsShipment": {
        "previousDocuments": {
            "previousDocument": [
                {
                    "referenceNumber": {
                        "value": "CHN2590508",
                        "reasoning": "Ocean Bill of Lading number from customs instruction document",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "CGOA73271",
                        "reasoning": "House Bill of Lading number from customs instruction document",
                        "certainty": 100
                    }
                }
            ]
        },
        "supportingDocuments": {
            "supportingDocument": [
                {
                    "referenceNumber": {
                        "value": "Z20250906353",
                        "reasoning": "Invoice number from the commercial invoice document",
                        "certainty": 100
                    }
                },
                {
                    "referenceNumber": {
                        "value": "DATA12433553",
                        "reasoning": "Reference number from ORDER NUMBERS / REFERENCE section marked as 'OTH: DATA12433553'",
                        "certainty": 90
                    }
                }
            ]
        },
        "exporter": {
            "identificationNumber": {
                "value": "",
                "reasoning": "No identification number provided for the shipper/exporter in the documents",
                "certainty": 0
            },
            "name": {
                "value": "SHENZHEN IVY INNOVATION DEVELOPMENT CO. LTD",
                "reasoning": "Shipper name from customs instruction document and all supporting documents",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "120612/F, JINLUANG INTERNATIONAL BUSINESS BUILDING, NO.98 HEPING EASTROAD, SANLIAN COMMUNITY LONGHUA ST",
                    "reasoning": "Complete street address from shipper details in customs instruction document",
                    "certainty": 100
                },
                "country": {
                    "value": "CN",
                    "reasoning": "Country is CHINA as stated in shipper address",
                    "certainty": 100
                },
                "postcode": {
                    "value": "518110",
                    "reasoning": "Postal code from shipper address in customs instruction document",
                    "certainty": 100
                },
                "city": {
                    "value": "SHENZHEN",
                    "reasoning": "City from shipper address",
                    "certainty": 100
                }
            }
        },
        "seller": {
            "identificationNumber": {
                "value": "",
                "reasoning": "No separate seller identification provided; seller appears to be same as exporter",
                "certainty": 50
            },
            "name": {
                "value": "SHENZHEN IVY INNOVATION DEVELOPMENT CO. LTD",
                "reasoning": "Invoice shows shipper as seller (same as exporter)",
                "certainty": 90
            },
            "address": {
                "streetAndNumber": {
                    "value": "1206,12/F, JINLUANG INTERNATIONAL BUSINESS BUILDING, NO.98 HEPING EAST ROAD, SANLIAN COMMUNITY, LONGHUA STREET, LONGHUA DISTRICT",
                    "reasoning": "Address from invoice document (slight variation in formatting from customs doc)",
                    "certainty": 90
                },
                "country": {
                    "value": "CN",
                    "reasoning": "CHINA as stated in seller address",
                    "certainty": 100
                },
                "postcode": {
                    "value": "518110",
                    "reasoning": "Same postal code as exporter",
                    "certainty": 80
                },
                "city": {
                    "value": "SHENZHEN",
                    "reasoning": "City from seller address",
                    "certainty": 100
                }
            }
        },
        "buyer": {
            "identificationNumber": {
                "value": "DE343695821",
                "reasoning": "VAT number for buyer (same as importer/consignee) from invoice: 'VAT:DE343695821'",
                "certainty": 100
            },
            "name": {
                "value": "HALTERNER TECHNOLOGIE GMBH",
                "reasoning": "Buyer name from invoice (same as consignee)",
                "certainty": 100
            },
            "address": {
                "streetAndNumber": {
                    "value": "Breitscheider Weg 117A",
                    "reasoning": "Street address from invoice (note: different from warehouse delivery address HARKORTSTRASSE 12-32)",
                    "certainty": 95
                },
                "country": {
                    "value": "DE",
                    "reasoning": "GERMANY as stated in buyer address",
                    "certainty": 100
                },
                "postcode": {
                    "value": "40885",
                    "reasoning": "Postal code from invoice buyer address (note: different from delivery address 40880)",
                    "certainty": 95
                },
                "city": {
                    "value": "Ratingen",
                    "reasoning": "City from buyer address on invoice",
                    "certainty": 100
                }
            }
        },
        "deliveryTerms": {
            "incotermCode": {
                "value": "CFR",
                "reasoning": "Incoterm stated in customs instruction document as 'Incoterm: CFR Rotterdam'",
                "certainty": 100
            }
        },
        "invoiceCurrency": {
            "value": "EUR",
            "reasoning": "Invoice Z20250906353 shows all amounts in EUR (€)",
            "certainty": 100
        },
        "totalAmountInvoiced": {
            "value": 17003.9,
            "reasoning": "Total amount from invoice: '17,003.90 €'",
            "certainty": 100
        },
        "countryOfDestination": {
            "value": "NL",
            "reasoning": "Port of discharge and place of delivery is 'ROTTERDAM, NETHERLANDS'",
            "certainty": 100
        },
        "countryOfDispatch": {
            "value": "CN",
            "reasoning": "Port of loading is 'SHANGHAI, CHINA' from both customs instruction and sea waybill",
            "certainty": 100
        },
        "grossMass": {
            "value": 11056,
            "reasoning": "Gross weight from container details: 'GROSS: 11056 KG'",
            "certainty": 100
        }
    },
    "goodsItems": {
        "goodsItem": [
            {
                "containerNumber": {
                    "value": "FSCU8100807",
                    "reasoning": "Container number from customs instruction document container details",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 10818,
                    "reasoning": "First line item from invoice for 900 suitcases at 12.02€ each = 10,818.00€",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Goods shipped from China (SHANGHAI, CHINA) by Chinese exporter",
                    "certainty": 95
                },
                "supplementaryUnits": {
                    "value": 900,
                    "reasoning": "Quantity of first item from invoice: 900 suitcases",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 3300,
                    "reasoning": "From packing list: 300 cartons with G.W: 3300.00 kg for the first suitcase item",
                    "certainty": 95
                },
                "netMass": {
                    "value": 3000,
                    "reasoning": "From packing list: 300 cartons with N.W: 3000.00 kg for the first suitcase item",
                    "certainty": 95
                },
                "descriptionOfGoods": {
                    "value": "SUITCASE",
                    "reasoning": "Goods description from all documents consistently shows 'SUITCASE'",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 300,
                        "reasoning": "First item from invoice/packing list shows 300 cartons",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Package type shown as 'CTN' (carton) throughout documents",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "4202125000",
                        "reasoning": "HS Code from invoice and packing list (more detailed than 420212 from customs doc)",
                        "certainty": 95
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "FSCU8100807",
                    "reasoning": "Same container as first item",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 4908,
                    "reasoning": "Second line item from invoice for 400 suitcases at 12.27€ each = 4,908.00€",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Same origin as other items in shipment",
                    "certainty": 95
                },
                "supplementaryUnits": {
                    "value": 400,
                    "reasoning": "Quantity of second item from invoice: 400 suitcases",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 1540,
                    "reasoning": "From packing list: 200 cartons with G.W: 1540.00 kg for the second suitcase item",
                    "certainty": 95
                },
                "netMass": {
                    "value": 1340,
                    "reasoning": "From packing list: 200 cartons with N.W: 1340.00 kg for the second suitcase item",
                    "certainty": 95
                },
                "descriptionOfGoods": {
                    "value": "SUITCASE",
                    "reasoning": "Goods description from invoice line item 2",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 200,
                        "reasoning": "Second item from invoice/packing list shows 200 cartons",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Package type shown as 'CTN' (carton)",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "4202125000",
                        "reasoning": "HS Code from invoice line item 2",
                        "certainty": 100
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "FSCU8100807",
                    "reasoning": "Same container as other items",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 414,
                    "reasoning": "Third line item from invoice for 30 suitcases at 13.80€ each = 414.00€",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Same origin as other items in shipment",
                    "certainty": 95
                },
                "supplementaryUnits": {
                    "value": 30,
                    "reasoning": "Quantity of third item from invoice: 30 suitcases",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 259.5,
                    "reasoning": "From packing list: 30 cartons with G.W: 259.50 kg for the third suitcase item",
                    "certainty": 95
                },
                "netMass": {
                    "value": 229.5,
                    "reasoning": "From packing list: 30 cartons with N.W: 229.50 kg for the third suitcase item",
                    "certainty": 95
                },
                "descriptionOfGoods": {
                    "value": "SUITCASE",
                    "reasoning": "Goods description from invoice line item 3",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 30,
                        "reasoning": "Third item from invoice/packing list shows 30 cartons",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Package type shown as 'CTN' (carton)",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "4202125000",
                        "reasoning": "HS Code from invoice line item 3",
                        "certainty": 100
                    }
                }
            },
            {
                "containerNumber": {
                    "value": "FSCU8100807",
                    "reasoning": "Same container as other items",
                    "certainty": 100
                },
                "itemAmountInvoiced": {
                    "value": 863.9,
                    "reasoning": "Fourth line item from invoice for 106 suitcases at 8.15€ each = 863.90€",
                    "certainty": 100
                },
                "countryOfOrigin": {
                    "value": "CN",
                    "reasoning": "Same origin as other items in shipment",
                    "certainty": 95
                },
                "supplementaryUnits": {
                    "value": 106,
                    "reasoning": "Quantity of fourth item from invoice: 106 suitcases",
                    "certainty": 100
                },
                "grossMass": {
                    "value": 333.9,
                    "reasoning": "From packing list: 106 cartons with G.W: 333.90 kg for the fourth suitcase item",
                    "certainty": 95
                },
                "netMass": {
                    "value": 259.7,
                    "reasoning": "From packing list: 106 cartons with N.W: 259.70 kg for the fourth suitcase item",
                    "certainty": 95
                },
                "descriptionOfGoods": {
                    "value": "SUITCASE",
                    "reasoning": "Goods description from invoice line item 4",
                    "certainty": 100
                },
                "packaging": {
                    "numberOfPackages": {
                        "value": 106,
                        "reasoning": "Fourth item from invoice/packing list shows 106 cartons",
                        "certainty": 100
                    },
                    "typeOfPackages": {
                        "value": "CTN",
                        "reasoning": "Package type shown as 'CTN' (carton)",
                        "certainty": 100
                    }
                },
                "commodityCode": {
                    "hsCode": {
                        "value": "4202125000",
                        "reasoning": "HS Code from invoice line item 4",
                        "certainty": 100
                    }
                }
            }
        ]
    }
}