Fw: aanvraag Seacon Bayware
Verwerkt: 20-11-2025 13:49:41
Voltooid
Uitvoering ID:
oscar_691f0e6545c5b
Agent:
Oscar
📊 Geëxtraheerde Ordergegevens
Kleurcodering: Groen = Zeker (>80%), Geel = Mogelijk (>50%), Rood = Onzeker (<50%)
Document Data
Geëxtraheerde gegevens uit document (factuur, paklijst, pakbon, orderbevestiging)
Item
N/A
Type document: factuur, paklijst, pakbon, orderbevestiging, transport order
N/A
Document nummer, order nummer of booking reference
N/A
Datum van het document (YYYY-MM-DD)
N/A
Datum van ophalen (YYYY-MM-DD of YYYY-MM-DDTHH:MM:SS)
N/A
Datum van afleveren (YYYY-MM-DD of YYYY-MM-DDTHH:MM:SS)
N/A
Speciale instructies, afhandeling, of andere opmerkingen
N/A
Bedrijf of persoon naam
N/A
Straatnaam en huisnummer
N/A
Postcode
N/A
Stad of plaats
N/A
2-letter ISO landcode (NL, DE, BE, etc.)
N/A
Bedrijf of persoon naam
N/A
Straatnaam en huisnummer
N/A
Postcode
N/A
Stad of plaats
N/A
2-letter ISO landcode (NL, DE, BE, etc.)
N/A
Naam van het magazijn of bedrijf
N/A
Straatnaam en huisnummer
N/A
Postcode
N/A
Stad of plaats
N/A
2-letter ISO landcode (NL, DE, BE, etc.)
N/A
Naam van de locatie of klant
N/A
Straatnaam en huisnummer
N/A
Postcode
N/A
Stad of plaats
N/A
2-letter ISO landcode (NL, DE, BE, etc.)
Item
N/A
Gedetailleerde productbeschrijving
N/A
Aantal items/eenheden
N/A
Eenheid (stuks, kg, m³, dozen, etc.)
N/A
Prijs per eenheid (optioneel, voor facturen)
N/A
Totale prijs voor dit item (optioneel, voor facturen)
N/A
Totaal gewicht in kilogram (optioneel, voor transport)
N/A
Afmetingen als tekst (optioneel, voor transport)
N/A
Totaal exclusief BTW
N/A
Totaal BTW bedrag
N/A
BTW percentage (21, 9, 0, etc.)
N/A
Totaal inclusief BTW
N/A
Valuta code (EUR, USD, etc.)
N/A
Verwachte leverdatum (YYYY-MM-DD)
N/A
Bijzondere voorwaarden
Toon ruwe JSON
{
"orders": [
{
"document_type": {
"value": "transport order",
"reasoning": "This is a planning document for gas measurements of containers with solar modules, which is a transport/logistics related order",
"certainty": 85
},
"reference": {
"value": "5598060-MAEU247142554",
"reasoning": "Customer reference from the KLANT REF. column for the first group of containers",
"certainty": 90
},
"date": {
"value": "2025-02-20",
"reasoning": "Excel date 45686 converts to February 20, 2025",
"certainty": 95
},
"pickup_date": {
"value": "2025-02-20T10:00:00",
"reasoning": "Date 45686 with time 0.41666666666666669 (approximately 10:00 AM)",
"certainty": 90
},
"delivery_date": {
"value": "2025-02-21",
"reasoning": "SLOT TIJD column shows 45687 which is the next day",
"certainty": 80
},
"notes": {
"value": "Complete measurement B - Gas measurements for solar module containers. Multiple containers from China requiring measurement at TCT Venlo terminal.",
"reasoning": "Combined from MEASURING TYPE and OPMERKINGEN columns, plus context from manufacturer and origin",
"certainty": 85
},
"customer": {
"name": {
"value": "Seacon Bayware",
"reasoning": "Listed as CLIENT in the spreadsheet",
"certainty": 100
}
},
"pickup_location": {
"name": {
"value": "TCT Venlo (TERM-LB)",
"reasoning": "Listed in REGION column",
"certainty": 95
},
"address": {
"value": "Piri Reisweg 20",
"reasoning": "From STREET and HOUSE NR columns",
"certainty": 100
},
"postal_code": {
"value": "5928 LB",
"reasoning": "From ZIP CODE column",
"certainty": 100
},
"city": {
"value": "Venlo",
"reasoning": "From CITY column",
"certainty": 100
},
"country": {
"value": "NL",
"reasoning": "From COUNTRY column",
"certainty": 100
}
},
"items": [
{
"description": {
"value": "Solar Modules - Container TRLU8041003",
"reasoning": "Combined from CARGO and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules - Container TCKU7190979",
"reasoning": "Combined from CARGO and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules - Container HASU5027905",
"reasoning": "Combined from CARGO and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules - Container MRSU6396071",
"reasoning": "Combined from CARGO and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules - Container CAAU6207627",
"reasoning": "Combined from CARGO and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules - Container MSKU0664920",
"reasoning": "Combined from CARGO and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules - Container MSKU1093847",
"reasoning": "Combined from CARGO and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
}
]
},
{
"document_type": {
"value": "transport order",
"reasoning": "Planning document for container measurements",
"certainty": 85
},
"reference": {
"value": "5598060-MAEU247142554",
"reasoning": "Customer reference from KLANT REF. column",
"certainty": 90
},
"date": {
"value": "2025-02-21",
"reasoning": "Excel date 45687 converts to February 21, 2025",
"certainty": 95
},
"pickup_date": {
"value": "2025-02-21T10:00:00",
"reasoning": "Date 45687 with time approximately 10:00 AM",
"certainty": 90
},
"notes": {
"value": "Complete measurement B - Gas measurements for solar module containers at Cabooter Venlo terminal.",
"reasoning": "From MEASURING TYPE and location information",
"certainty": 85
},
"customer": {
"name": {
"value": "Seacon Bayware",
"reasoning": "Listed as CLIENT in the spreadsheet",
"certainty": 100
}
},
"pickup_location": {
"name": {
"value": "Cabooter Venlo (TERM-LB)",
"reasoning": "Listed in REGION column",
"certainty": 95
},
"address": {
"value": "Piri Reisweg 20",
"reasoning": "From STREET and HOUSE NR columns",
"certainty": 100
},
"postal_code": {
"value": "5928 LB",
"reasoning": "From ZIP CODE column",
"certainty": 100
},
"city": {
"value": "Venlo",
"reasoning": "From CITY column",
"certainty": 100
},
"country": {
"value": "NL",
"reasoning": "From COUNTRY column",
"certainty": 100
}
},
"items": [
{
"description": {
"value": "Solar Modules (Trina) - Container MRSU6180966",
"reasoning": "Combined from CARGO, MANUFACTURER and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules (Trina) - Container MRSU5052580",
"reasoning": "Combined from CARGO, MANUFACTURER and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules (Trina) - Container MRSU6492305",
"reasoning": "Combined from CARGO, MANUFACTURER and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules (Trina) - Container MRSU3885274",
"reasoning": "Combined from CARGO, MANUFACTURER and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
},
{
"description": {
"value": "Solar Modules (Trina) - Container TRHU6930934",
"reasoning": "Combined from CARGO, MANUFACTURER and OBJECT NR columns",
"certainty": 95
},
"quantity": {
"value": 1,
"reasoning": "One container",
"certainty": 90
},
"unit": {
"value": "container",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
}
]
},
{
"document_type": {
"value": "transport order",
"reasoning": "Planning document for container measurements",
"certainty": 85
},
"reference": {
"value": "5601057-NGP1939339",
"reasoning": "Customer reference from KLANT REF. column",
"certainty": 90
},
"date": {
"value": "2025-02-29",
"reasoning": "Excel date 45695 converts to February 29, 2025",
"certainty": 95
},
"pickup_date": {
"value": "2025-02-29T10:00:00",
"reasoning": "Date 45695 with time approximately 10:00 AM",
"certainty": 90
},
"notes": {
"value": "Complete measurement B - Gas measurements for solar module containers from Trina, China origin.",
"reasoning": "From MEASURING TYPE, MANUFACTURER and ORIGIN columns",
"certainty": 85
},
"customer": {
"name": {
"value": "Seacon Bayware",
"reasoning": "Listed as CLIENT in the spreadsheet",
"certainty": 100
}
},
"pickup_location": {
"name": {
"value": "TCT Venlo (TERM-LB)",
"reasoning": "Listed in REGION column",
"certainty": 95
},
"address": {
"value": "Celsiusweg 30",
"reasoning": "From STREET and HOUSE NR columns",
"certainty": 100
},
"postal_code": {
"value": "5928 PR",
"reasoning": "From ZIP CODE column",
"certainty": 100
},
"city": {
"value": "Venlo",
"reasoning": "From CITY column",
"certainty": 100
},
"country": {
"value": "NL",
"reasoning": "From COUNTRY column",
"certainty": 100
}
},
"items": [
{
"description": {
"value": "Solar Modules (Trina, China) - Multiple containers for measurement",
"reasoning": "Summary of cargo from multiple rows with same reference",
"certainty": 90
},
"quantity": {
"value": 12,
"reasoning": "Count of containers with this reference number",
"certainty": 85
},
"unit": {
"value": "containers",
"reasoning": "OBJECT column indicates Container",
"certainty": 100
}
}
]
}
]
}