Песочница: Star Roses

Intent ID: 29

Назад
1) Загрузить файл и получить сырой OCR JSON
Сохраняем последний файл и сырой OCR, чтобы можно было повторно тестировать маппинг без перезагрузки.
Скачать последний файл (Invoice#0000213634-TDA CVGORODRU-.pdf)
2) Правила трансформации
Правила трансформации OCR-данных в целевую схему (включая валидацию).
Промпт LLM-подсказки
Используется кнопкой «Подсказать rules».
Сырой OCR JSON (Pass 1)
{
  "awb": "14599817690",
  "items": [
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "CANDLELIGHT",
      "category": "ROSES",
      "quantity": 350,
      "box_number": "1",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.65,
      "box_marking": "H",
      "total_price": 227.5
    },
    {
      "boxes": 2,
      "length": "50CM",
      "variety": "CHECK MATE",
      "category": "ROSES",
      "quantity": 50,
      "box_number": "2",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.35,
      "box_marking": "H",
      "total_price": 17.5
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "CHECK MATE",
      "category": "ROSES",
      "quantity": 50,
      "box_number": "2",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.45,
      "box_marking": "H",
      "total_price": 22.5
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "MAMMA MIA",
      "category": "ROSES",
      "quantity": 25,
      "box_number": "2",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.4,
      "box_marking": "H",
      "total_price": 10.0
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "MAMMA MIA",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "2",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.5,
      "box_marking": "H",
      "total_price": 62.5
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "RED PANTHER",
      "category": "ROSES",
      "quantity": 50,
      "box_number": "2",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.5,
      "box_marking": "H",
      "total_price": 25.0
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "RED PANTHER",
      "category": "ROSES",
      "quantity": 50,
      "box_number": "2",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.55,
      "box_marking": "H",
      "total_price": 27.5
    }
  ],
  "country": "ECUADOR",
  "summary": {
    "total_boxes": 2,
    "total_stems": 700,
    "total_amount": 392.5
  },
  "supplier": "EL CAMPANARIO DE SANTA ANITA SCC",
  "invoice_date": "02/04/2026",
  "invoice_number": "055-2026-40-00549266",
  "processing_report": {
    "notes": "Инвойс плоского типа, каждая строка таблицы описывает отдельную позицию (коробку). Обнаружено 7 позиций, соответствующих 8 физическим коробкам (согласно сумме boxes в позициях), но в итоговом блоке 'BOXES' указано 2 коробки типа 'H'. Раскрытие мультибокса не применялось, так как каждая строка считается отдельной позицией. В OCR-данных присутствуют строки таблицы со сдвигом колонок, где BOX N° (колонка 0) содержит TB (тип коробки), что потребовало применения логики для обработки сдвига и наследования номера коробки. Notice: Please, be aware that any claim must be notified to the farm by fax or e-mail upon receipt of this shipment.Otherwise, noadjustment will be accepted to this invoice.",
    "status": "warning",
    "sum_boxes": 8,
    "sum_stems": 700,
    "sum_amount": 392.5,
    "items_count": 7,
    "discrepancies": [
      "summary.total_boxes (2) does not match sum of items[].boxes (8). This may be due to 'boxes' column referring to 'BOX N°' instead of physical box count per item line, or actual total boxes being extracted from the 'BOXES' section (2 H-boxes) which is inconsistent with individual line items boxes count (where the first line item had 1 box and the second 2 boxes, and subsequent items were marked as H-type but had no explicit box number/count)."
    ],
    "expected_boxes": 2,
    "expected_stems": 700,
    "expected_amount": 392.5
  }
}
Результат (Pass 2)
Report: warning
items=4, boxes=2/14, stems=350/350, amount=135/135
discrepancies: Discrepancy in total boxes: Calculated 2, Expected 14.
notes: Invoice type: flat. 2 unique box identifiers ('1', 'TOTAL') found in items. No multi-box unfolding applied. Discrepancy between calculated unique item box numbers and summary total boxes.
{
  "awb": "50119717865",
  "items": [
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "CHECK MATE",
      "category": "ROSES",
      "quantity": 175,
      "box_number": "1",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.35,
      "box_marking": "H",
      "total_price": 61.25
    },
    {
      "boxes": 1,
      "length": "60CM",
      "variety": "CHECK MATE",
      "category": "ROSES",
      "quantity": 25,
      "box_number": "1",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.45,
      "box_marking": "H",
      "total_price": 11.25
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "MAMMA MIA",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "1",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.4,
      "box_marking": "H",
      "total_price": 50
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "RED PANTHER",
      "category": "ROSES",
      "quantity": 25,
      "box_number": "TOTAL",
      "plantation": "EL CAMPANARIO DE SANTA ANITA SCC",
      "unit_price": 0.5,
      "box_marking": "H",
      "total_price": 12.5
    }
  ],
  "country": "KIRGUISTAN",
  "summary": {
    "total_boxes": 14,
    "total_stems": 350,
    "total_amount": 135
  },
  "supplier": "EL CAMPANARIO DE SANTA ANITA SCC",
  "invoice_date": "19/02/2026",
  "invoice_number": "055-2026-40-00176632",
  "processing_report": {
    "notes": "Invoice type: flat. 2 unique box identifiers ('1', 'TOTAL') found in items. No multi-box unfolding applied. Discrepancy between calculated unique item box numbers and summary total boxes.",
    "status": "warning",
    "sum_boxes": 2,
    "sum_stems": 350,
    "sum_amount": 135,
    "items_count": 4,
    "discrepancies": [
      "Discrepancy in total boxes: Calculated 2, Expected 14."
    ],
    "expected_boxes": 14,
    "expected_stems": 350,
    "expected_amount": 135
  }
}
История (последние 20)
ID Файл Дата
26 Invoice#0000207143-TDA CVGORODRU-.pdf 2026-02-23 17:10:00.934082+00:00 Excel