Песочница: LESIA KORZ / LAILA FLOWERS

Intent ID: 36

Назад
1) Загрузить файл и получить сырой OCR JSON
Сохраняем последний файл и сырой OCR, чтобы можно было повторно тестировать маппинг без перезагрузки.
Скачать последний файл (12497 tda.PDF)
2) Правила трансформации
Правила трансформации OCR-данных в целевую схему (включая валидацию).
Промпт LLM-подсказки
Используется кнопкой «Подсказать rules».
Сырой OCR JSON (Pass 1)
{
  "awb": null,
  "items": [
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "CANDLELIGHT",
      "category": null,
      "quantity": 100,
      "box_number": "1",
      "plantation": null,
      "unit_price": 0.45,
      "box_marking": "HB",
      "total_price": 45.0
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "CANDLELIGHT",
      "category": null,
      "quantity": 275,
      "box_number": "1",
      "plantation": null,
      "unit_price": 0.45,
      "box_marking": "HB",
      "total_price": 123.75
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "CANDLELIGHT",
      "category": null,
      "quantity": 25,
      "box_number": "1",
      "plantation": null,
      "unit_price": 0.45,
      "box_marking": "HB",
      "total_price": 11.25
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "BE SWEET",
      "category": null,
      "quantity": 25,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.35,
      "box_marking": "HB",
      "total_price": 8.75
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "CARROUSEL",
      "category": null,
      "quantity": 50,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.35,
      "box_marking": "HB",
      "total_price": 17.5
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "CANDY X-PRESSION",
      "category": null,
      "quantity": 100,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.45,
      "box_marking": "HB",
      "total_price": 45.0
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "PINK FLOYD",
      "category": null,
      "quantity": 50,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.45,
      "box_marking": "HB",
      "total_price": 22.5
    },
    {
      "boxes": 1,
      "length": "40CM",
      "variety": "COUNTRY BLUES",
      "category": null,
      "quantity": 25,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.25,
      "box_marking": "HB",
      "total_price": 6.25
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "CANDLELIGHT",
      "category": null,
      "quantity": 75,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.35,
      "box_marking": "HB",
      "total_price": 26.25
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "MELON X-PRESSION",
      "category": null,
      "quantity": 50,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.35,
      "box_marking": "HB",
      "total_price": 17.5
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "PINK FLOYD",
      "category": null,
      "quantity": 25,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.45,
      "box_marking": "HB",
      "total_price": 11.25
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "COUNTRY BLUES",
      "category": null,
      "quantity": 25,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.35,
      "box_marking": "HB",
      "total_price": 8.75
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "COUNTRY BLUES",
      "category": null,
      "quantity": 25,
      "box_number": "2",
      "plantation": null,
      "unit_price": 0.45,
      "box_marking": "HB",
      "total_price": 11.25
    }
  ],
  "country": "Ecuador",
  "summary": {
    "total_boxes": 13,
    "total_stems": 850,
    "total_amount": 355.0
  },
  "supplier": "LAILA FLOWERS",
  "invoice_date": "13/03/2026",
  "invoice_number": "00012497",
  "processing_report": {
    "notes": "Invoice type B (flat) interpreted: each row describes one physical box. 13 physical boxes detected based on 13 item lines. No multi-box unrolling applied. Total stems and amount match the invoice's own summary totals. Discrepancy noted for total boxes due to differing interpretations.",
    "status": "warning",
    "sum_boxes": 13,
    "sum_stems": 850,
    "sum_amount": 355.0,
    "items_count": 13,
    "discrepancies": [
      "Calculated total_boxes (13) does not match stated total (1.00) in OCR. The rule 'каждая строка таблицы описывает одну позицию (одну физическую коробку)' was applied, leading to each of the 13 item rows being counted as one physical box, while the invoice summary states 1 box. This might indicate that the 'TOT.BOX' line refers to something else or is erroneous, or the invoice structure is not strictly 'flat' as per the rule's assumption.",
      "All item quantities (stems) are multiples of 25, which is consistent with common bunch sizes."
    ],
    "expected_boxes": 1,
    "expected_stems": 850,
    "expected_amount": 355.0
  }
}
Результат (Pass 2)

  
История (последние 20)
ID Файл Дата