Песочница: EQR USA - GROWER

Intent ID: 26

Назад
1) Загрузить файл и получить сырой OCR JSON
Сохраняем последний файл и сырой OCR, чтобы можно было повторно тестировать маппинг без перезагрузки.
Скачать последний файл (Invoice 587587.pdf)
2) Правила трансформации
Правила трансформации OCR-данных в целевую схему (включая валидацию).
Промпт LLM-подсказки
Используется кнопкой «Подсказать rules».
Сырой OCR JSON (Pass 1)
{
  "awb": "145-9981-7594",
  "items": [
    {
      "boxes": 1,
      "length": "50/60",
      "variety": "Roses Red/Assorted",
      "category": "ROSES",
      "quantity": 300,
      "box_number": "BCO1",
      "plantation": "OLIBRI",
      "unit_price": 0.354,
      "box_marking": "1 HJB",
      "total_price": 106.25
    }
  ],
  "country": "USA",
  "summary": {
    "total_boxes": 1,
    "total_stems": 300,
    "total_amount": 106.25
  },
  "supplier": "BCO Int'l",
  "invoice_date": "02/26/2026",
  "invoice_number": "587587",
  "processing_report": {
    "notes": "Тип инвойса: плоский. Обнаружена 1 физическая коробка. При извлечении данных для полей 'invoice_number', 'awb' и 'summary' правила по индексам колонок не строго соответствовали OCR-структуре, но значения были успешно найдены и проверены. Описание позиции в колонке 'Description' было сложным и содержало несколько сортов, 'variety' упрощено до первого указанного. Раскрытие мультибокса не применялось.",
    "status": "ok",
    "sum_boxes": 1,
    "sum_stems": 300,
    "sum_amount": 106.25,
    "items_count": 1,
    "discrepancies": [
      "Rule for 'invoice_number' (col 2 contains 'Invoice #', value from col 3) did not strictly match OCR structure; 'Invoice #' found in col 6, value '587587' in col 7.",
      "Rule for 'awb' (col 2 contains 'Way Bill / Ref #', value from col 3) did not strictly match OCR structure; 'Way Bill / Ref #' found in col 6, value '145-9981-7594' in col 7.",
      "Rule for 'summary.total_boxes' (col 1 contains 'Totals', value from col 0) did not strictly match OCR structure; value '1' extracted from row 9, column 1, next to 'otal Boxes' in column 0.",
      "Rule for 'summary.total_stems' (col 1 contains 'Totals', value from col 2) did not strictly match OCR structure; value '300' extracted from header_text as 'Total stems'.",
      "Rule for 'summary.total_amount' (col 1 contains 'Totals', value from col 2) did not strictly match OCR structure; 'Totals' found in col 2, value '$106.25' extracted from col 3 of row 11."
    ],
    "expected_boxes": 1,
    "expected_stems": 300,
    "expected_amount": 106.25
  }
}
Результат (Pass 2)
{
  "notes": [],
  "table": {
    "rows": [
      [
        "INVOICE",
        "",
        "",
        "",
        "",
        ""
      ],
      [
        "Supplier:",
        "TestFlower LLC",
        "",
        "Invoice #:",
        "TF-2026-001",
        ""
      ],
      [
        "Date:",
        "2026-03-01",
        "",
        "",
        "",
        ""
      ],
      [
        "Box#",
        "Marking",
        "Description",
        "Stems",
        "Price",
        "Amount"
      ],
      [
        "1",
        "MARKTEST",
        "Rose Red Freedom 60cm",
        "250",
        "0.25",
        "62.50"
      ],
      [
        "2",
        "MARKTEST",
        "Rose White Mondial 50cm",
        "300",
        "0.20",
        "60.00"
      ],
      [
        "3",
        "BOXMARK2",
        "Chrysanthemum Yellow 70cm",
        "150",
        "0.35",
        "52.50"
      ],
      [
        "",
        "",
        "TOTAL",
        "700",
        "",
        "175.00"
      ]
    ],
    "columns": []
  },
  "metadata": {},
  "sections": [],
  "totals_raw": "",
  "header_text": ""
}
История (последние 20)
ID Файл Дата
99 test_invoice.xlsx 2026-03-04 04:05:22.649273+00:00 Excel
95 Invoice 585046.pdf 2026-03-03 09:16:36.535768+00:00 Excel
94 Invoice 585046.pdf 2026-03-03 08:24:50.569617+00:00 Excel
93 Invoice 585046.pdf 2026-03-03 08:13:17.892264+00:00 Excel
92 Invoice 585046.pdf 2026-03-03 08:04:28.855516+00:00 Excel
91 Invoice 585046.pdf 2026-03-03 08:02:01.264531+00:00 Excel
90 Invoice 585046.pdf 2026-03-03 08:00:35.091222+00:00 Excel
89 Invoice 585046.pdf 2026-03-03 07:57:49.334547+00:00 Excel
88 Invoice 585046.pdf 2026-03-03 07:56:10.328314+00:00 Excel
87 Invoice 585046.pdf 2026-03-03 07:51:21.167493+00:00 Excel
86 Invoice 585046.pdf 2026-03-03 07:45:06.322768+00:00 Excel
85 Invoice 585046.pdf 2026-03-03 07:31:10.524812+00:00 Excel
84 Invoice 585046.pdf 2026-03-03 07:27:08.736738+00:00 Excel
19 Invoice 586242.pdf 2026-02-23 16:53:42.073561+00:00 Excel