Песочница: FERNANDO RODRIGUEZ / ALCOFLOWER - BOTANIC

Intent ID: 34

Назад
1) Загрузить файл и получить сырой OCR JSON
Сохраняем последний файл и сырой OCR, чтобы можно было повторно тестировать маппинг без перезагрузки.
Скачать последний файл (FACTURA 2327.pdf)
2) Правила трансформации
Правила трансформации OCR-данных в целевую схему (включая валидацию).
Промпт LLM-подсказки
Используется кнопкой «Подсказать rules».
Сырой OCR JSON (Pass 1)
{
  "notes": [],
  "table": {
    "rows": [
      [
        "INVOICE DATE BOTANIC FARMS lunes, 16 de febrero de 2026 CODE INVOICE Nº EC 001-002-00002327 Pichincha - Ecuador FREIGHT FORWARDER PACIFIC CARGO Custormer Name and Address : M.A.W.B.: 145-9981-7572 Customer: TDA Address: KIRGUISTAN H.A.W.B.: Destination: KIRGUISTAN DAE: 055-2025-40-0242141",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        ""
      ],
      [
        "Pieces",
        "Total",
        "Total",
        "FARM",
        "VARIETY",
        "Lenght cm",
        "Bounches per Box",
        "Stems per Bounch",
        "Total",
        "Unit Price",
        "Total"
      ],
      [
        "Type",
        "Pieces",
        "BOX",
        "",
        "",
        "",
        "",
        "",
        "Units",
        "Per Stems",
        "Value USD"
      ],
      [
        "HB HB HB HB HB HB HB QB HB HB HB QB HB HB QB",
        "1 1 4 2 1 1 1 2 1 1 1 1 1 1 1",
        "0,50 0,50 2,00 1,00 0,50 0,50 0,50 0,50 0,50 0,50 0,50 0,25 0,50 0,50 0,25",
        "NARANJO ROSES PC602017194 AGRIVALDANI PC602018562 FLORAROMA PC602016960 EFANDINA PC602018318 ROYALTY FLOWERS PC602018224 BEAUTY BLOOMS/ ANGEL GUACHAMIN PC602018496 SANIMA GARDEN PC602016850 R&M /RODRIGO PINANGO PC602017228 UNIQUE FLOWERS PC602017936 VERISAR FLOWERS / SARA TANEZ PC602018476",
        "ESPERANCE VENDELA ESPERANCE ESPERANCE NINA NINA NINA NINA VENDELA ESPERANCE ESPERANCE ESPERANCE EXPLORER EXPLORER VI PINK VENDELA CANDELIGHT FULL MONTY",
        "60 40 40 50 50 50 60 70 40 50 50 60 50 60 50 50 40 40",
        "16 16 56 24 16 1 15 4 14 8 9 3 12 12 4 12 12 5",
        "25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25",
        "400 400 1400 600 400 25 375 100 350 200 225 75 300 300 100 300 300 125",
        "0 ,85 0 ,40 0 ,65 0 ,75 0 ,75 0 ,75 0 ,85 0 ,95 0 ,40 0 ,70 0 ,75 0 ,85 1 ,00 1 ,10 0 ,40 0 ,35 0 ,45 0 ,45",
        "340,00 160,00 910,00 450,00 300,00 18,75 318,75 95,00 140,00 140,00 168,75 63,75 300,00 330,00 40,00 105,00 135,00 56,25"
      ],
      [
        "TOTAL",
        "20",
        "9,00",
        "",
        "",
        "",
        "239",
        "",
        "5975",
        "",
        "4071,25"
      ],
      [
        "SUMMARY: Terms of sale FOB",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        ""
      ],
      [
        "Name and Title of Person Preparing Invoice/",
        "",
        "",
        "",
        "",
        "VARIETY",
        "",
        "PIECES",
        "FB",
        "STEMS",
        "USD"
      ],
      [
        "FERNANDO RODRIGUEZ",
        "",
        "",
        "",
        "",
        "ROSAS",
        "",
        "20",
        "9,00",
        "5975",
        "$ 4 .071,25"
      ],
      [
        "CLAIMS POLICY",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        ""
      ],
      [
        "To process a posible claim we must be notified within 24 hours of receip the flowers and we request the following information:",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        "",
        ""
      ],
      [
        "INVOICE DATE"
      ],
      [
        "lunes, 16 de febrero de 2026"
      ],
      [
        "CODE",
        "INVOICE Nº"
      ],
      [
        "EC",
        "001-002-00002327"
      ],
      [
        "FREIGHT FORWARDER"
      ],
      [
        "PACIFIC CARGO"
      ],
      [
        "M.A.W.B.:",
        "145-9981-7572"
      ],
      [
        "H.A.W.B.:",
        ""
      ],
      [
        "DAE:",
        "055-2025-40-0242141"
      ]
    ],
    "columns": []
  },
  "metadata": {},
  "sections": [],
  "totals_raw": "",
  "header_text": ""
}
Результат (Pass 2)
Report: ok
items=18, boxes=20/20, stems=5975/5975, amount=4071.25/4071.25
notes: Тип инвойса: плоский. Обнаружено 20 физических коробок. Данные успешно извлечены, применена трансформация мультибоксов согласно правилам. Плантации для items 16-18 отсутствуют в OCR и установлены в null.
{
  "awb": "145-9981-7572",
  "items": [
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "ESPERANCE",
      "category": "ROSES",
      "quantity": 400,
      "box_number": "NAR1",
      "plantation": "NARANJO ROSES",
      "unit_price": 0.85,
      "box_marking": "HB",
      "total_price": 340.0
    },
    {
      "boxes": 1,
      "length": "40CM",
      "variety": "VENDELA",
      "category": "ROSES",
      "quantity": 400,
      "box_number": "AGR2",
      "plantation": "AGRIVALDANI",
      "unit_price": 0.4,
      "box_marking": "HB",
      "total_price": 160.0
    },
    {
      "boxes": 3,
      "length": "40CM",
      "variety": "ESPERANCE",
      "category": "ROSES",
      "quantity": 1400,
      "box_number": "FLO3",
      "plantation": "FLORAROMA",
      "unit_price": 0.65,
      "box_marking": "HB",
      "total_price": 910.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "ESPERANCE",
      "category": "ROSES",
      "quantity": 600,
      "box_number": "FLO4",
      "plantation": "FLORAROMA",
      "unit_price": 0.75,
      "box_marking": "HB",
      "total_price": 450.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "NINA",
      "category": "ROSES",
      "quantity": 400,
      "box_number": "FLO5",
      "plantation": "FLORAROMA",
      "unit_price": 0.75,
      "box_marking": "HB",
      "total_price": 300.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "NINA",
      "category": "ROSES",
      "quantity": 25,
      "box_number": "FLO6",
      "plantation": "FLORAROMA",
      "unit_price": 0.75,
      "box_marking": "HB",
      "total_price": 18.75
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "NINA",
      "category": "ROSES",
      "quantity": 375,
      "box_number": "EFA7",
      "plantation": "EFANDINA",
      "unit_price": 0.85,
      "box_marking": "HB",
      "total_price": 318.75
    },
    {
      "boxes": 1,
      "length": "70CM",
      "variety": "NINA",
      "category": "ROSES",
      "quantity": 100,
      "box_number": "EFA8",
      "plantation": "EFANDINA",
      "unit_price": 0.95,
      "box_marking": "QB",
      "total_price": 95.0
    },
    {
      "boxes": 1,
      "length": "40CM",
      "variety": "VENDELA",
      "category": "ROSES",
      "quantity": 350,
      "box_number": "ROY9",
      "plantation": "ROYALTY FLOWERS",
      "unit_price": 0.4,
      "box_marking": "HB",
      "total_price": 140.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "ESPERANCE",
      "category": "ROSES",
      "quantity": 200,
      "box_number": "BEA10",
      "plantation": "BEAUTY BLOOMS/ ANGEL GUACHAMIN",
      "unit_price": 0.7,
      "box_marking": "HB",
      "total_price": 140.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "ESPERANCE",
      "category": "ROSES",
      "quantity": 225,
      "box_number": "SAN11",
      "plantation": "SANIMA GARDEN",
      "unit_price": 0.75,
      "box_marking": "HB",
      "total_price": 168.75
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "ESPERANCE",
      "category": "ROSES",
      "quantity": 75,
      "box_number": "R&M12",
      "plantation": "R&M /RODRIGO PINANGO",
      "unit_price": 0.85,
      "box_marking": "QB",
      "total_price": 63.75
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "EXPLORER",
      "category": "ROSES",
      "quantity": 300,
      "box_number": "R&M13",
      "plantation": "R&M /RODRIGO PINANGO",
      "unit_price": 1.0,
      "box_marking": "HB",
      "total_price": 300.0
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "EXPLORER",
      "category": "ROSES",
      "quantity": 300,
      "box_number": "UNI14",
      "plantation": "UNIQUE FLOWERS",
      "unit_price": 1.1,
      "box_marking": "HB",
      "total_price": 330.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "VI PINK",
      "category": "ROSES",
      "quantity": 100,
      "box_number": "VER15",
      "plantation": "VERISAR FLOWERS / SARA TANEZ",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 40.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "VENDELA",
      "category": "ROSES",
      "quantity": 300,
      "box_number": "VER16",
      "plantation": null,
      "unit_price": 0.35,
      "box_marking": "QB",
      "total_price": 105.0
    },
    {
      "boxes": 1,
      "length": "40CM",
      "variety": "CANDELIGHT",
      "category": "ROSES",
      "quantity": 300,
      "box_number": "VER17",
      "plantation": null,
      "unit_price": 0.45,
      "box_marking": "QB",
      "total_price": 135.0
    },
    {
      "boxes": 1,
      "length": "40CM",
      "variety": "FULL MONTY",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "VER18",
      "plantation": null,
      "unit_price": 0.45,
      "box_marking": "QB",
      "total_price": 56.25
    }
  ],
  "country": "Ecuador",
  "summary": {
    "total_boxes": 20,
    "total_stems": 5975,
    "total_amount": 4071.25
  },
  "supplier": "BOTANIC FARMS",
  "invoice_date": "lunes, 16 de febrero de 2026",
  "invoice_number": "001-002-00002327",
  "processing_report": {
    "notes": "Тип инвойса: плоский. Обнаружено 20 физических коробок. Данные успешно извлечены, применена трансформация мультибоксов согласно правилам. Плантации для items 16-18 отсутствуют в OCR и установлены в null.",
    "status": "ok",
    "sum_boxes": 20,
    "sum_stems": 5975,
    "sum_amount": 4071.25,
    "items_count": 18,
    "discrepancies": [],
    "expected_boxes": 20,
    "expected_stems": 5975,
    "expected_amount": 4071.25
  }
}
История (последние 20)
ID Файл Дата
117 FACTURA 2327.pdf 2026-03-05 07:48:42.625170+00:00 Excel
116 FACTURA 2327.pdf 2026-03-05 07:38:20.893362+00:00 Excel
115 FACTURA 2327.pdf 2026-03-05 06:54:37.486087+00:00 Excel
114 FACTURA 2327.pdf 2026-03-05 05:00:27.364617+00:00 Excel
113 FACTURA 2327.pdf 2026-03-05 03:36:09.054726+00:00 Excel
112 FACTURA 2327 (1).pdf 2026-03-04 11:02:02.421749+00:00 Excel
111 FACTURA 2327 (1).pdf 2026-03-04 11:01:59.254591+00:00 Excel
110 FACTURA 2327 (1).pdf 2026-03-04 10:43:40.523353+00:00 Excel
109 FACTURA 2327.pdf 2026-03-04 07:10:57.454021+00:00 Excel
108 FACTURA 2327.pdf 2026-03-04 07:05:01.620748+00:00 Excel
107 FACTURA 2327.pdf 2026-03-04 06:56:58.931637+00:00 Excel
106 FACTURA 2327.pdf 2026-03-04 06:51:14.228455+00:00 Excel
105 FACTURA 2327.pdf 2026-03-04 04:58:19.112805+00:00 Excel
104 FACTURA 2327.pdf 2026-03-04 04:50:02.463147+00:00 Excel
103 FACTURA 2327.pdf 2026-03-04 04:41:39.474439+00:00 Excel
102 FACTURA 2327.pdf 2026-03-04 04:37:33.781354+00:00 Excel
101 FACTURA 2327.pdf 2026-03-04 04:26:41.820192+00:00 Excel
100 FACTURA 2327.pdf 2026-03-04 04:13:54.983395+00:00 Excel
98 FACTURA 2327.pdf 2026-03-04 03:58:08.897665+00:00 Excel
97 FACTURA 2327.pdf 2026-03-04 03:52:12.865801+00:00 Excel