Песочница: BELLAROSA

Intent ID: 15

Назад
1) Загрузить файл и получить сырой OCR JSON
Сохраняем последний файл и сырой OCR, чтобы можно было повторно тестировать маппинг без перезагрузки.
Скачать последний файл (5175962.pdf)
2) Правила трансформации
Правила трансформации OCR-данных в целевую схему (включая валидацию).
Промпт LLM-подсказки
Используется кнопкой «Подсказать rules».
Сырой OCR JSON (Pass 1)
{
  "awb": "145-9981 7642 PC603008087",
  "items": [
    {
      "boxes": 1,
      "length": null,
      "variety": "MIXED BOX",
      "category": "MIXED BOX",
      "quantity": 350,
      "box_number": "BEL001",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.31,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 108.5
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "BRIGHTON",
      "category": "ROSES",
      "quantity": 50,
      "box_number": "BEL001",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.22,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 11.0
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "FORTUNE",
      "category": "ROSES",
      "quantity": 100,
      "box_number": "BEL001",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.3,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 30.0
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "LOLA",
      "category": "ROSES",
      "quantity": 150,
      "box_number": "BEL001",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.35,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 52.5
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "NINA",
      "category": "ROSES",
      "quantity": 50,
      "box_number": "BEL001",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.3,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 15.0
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "CANDLELIGHT",
      "category": "ROSES",
      "quantity": 250,
      "box_number": "BEL002",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.45,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 112.5
    },
    {
      "boxes": 2,
      "length": "50",
      "variety": "FORTUNE",
      "category": "ROSES",
      "quantity": 800,
      "box_number": "BEL003",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.3,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 240.0
    },
    {
      "boxes": 2,
      "length": "40",
      "variety": "FULL",
      "category": "ROSES",
      "quantity": 800,
      "box_number": "BEL004",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.25,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 200.0
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "MAGNOLIA",
      "category": "ROSES",
      "quantity": 250,
      "box_number": "BEL005",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.6,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 150.0
    },
    {
      "boxes": 1,
      "length": null,
      "variety": "MIXED BOX",
      "category": "MIXED BOX",
      "quantity": 400,
      "box_number": "BEL006",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.3575,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 143.0
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "NINA",
      "category": "ROSES",
      "quantity": 150,
      "box_number": "BEL006",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.32,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 48.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "NINA",
      "category": "ROSES",
      "quantity": 250,
      "box_number": "BEL006",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.38,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 95.0
    }
  ],
  "country": "Kyrgyz Republic (Kyrgyzstan)",
  "summary": {
    "total_boxes": 8,
    "total_stems": 2850,
    "total_amount": 954.0
  },
  "supplier": "BELLARO S.A.S.",
  "invoice_date": "2026-11-03",
  "invoice_number": "5175962",
  "processing_report": {
    "notes": "Invoice type: Hybrid (Mixed Box and Individual Boxes). Detected 8 physical boxes. No major extraction issues. Multi-box unfolding applied for Mixed Boxes. Box numbers generated based on supplier prefix and sequential numbering for lines without explicit LABEL. Note on sum_boxes vs expected_boxes: sum_boxes counts unique items[].box_number, which results in 6 unique logical boxes (BEL001-BEL006). expected_boxes from OCR totals line (# column) indicates 8 boxes. This discrepancy might be due to how 'boxes' are counted in the summary vs how unique box_numbers are generated and counted in items.",
    "status": "ok",
    "sum_boxes": 6,
    "sum_stems": 2850,
    "sum_amount": 954.0,
    "items_count": 12,
    "discrepancies": [
      "sum_boxes (6) does not match expected_boxes (8)"
    ],
    "expected_boxes": 8,
    "expected_stems": 2850,
    "expected_amount": 954.0
  }
}
Результат (Pass 2)
Report: ok
items=8, boxes=3/3.0, stems=1350.0/1350.0, amount=328.5/328.5
notes: Invoice type: Hybrid (grouped + individual). Detected 3 physical boxes. No issues detected. Multiboxes successfully expanded.
{
  "awb": "145-9981 7605 PC603000453",
  "items": [
    {
      "boxes": 1,
      "length": "40CM",
      "variety": "BRIGHTON",
      "category": "ROSES",
      "quantity": 100.0,
      "box_number": "2925349",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.22,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 22.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "BRIGHTON",
      "category": "ROSES",
      "quantity": 400.0,
      "box_number": "2925349",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.22,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 88.0
    },
    {
      "boxes": 1,
      "length": "40CM",
      "variety": "BRIGHTON",
      "category": "ROSES",
      "quantity": 125.0,
      "box_number": "2925351",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.22,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 27.5
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "BRIGHTON",
      "category": "ROSES",
      "quantity": 375.0,
      "box_number": "2925351",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.22,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 82.5
    },
    {
      "boxes": 1,
      "length": "40CM",
      "variety": "BRIGHTON",
      "category": "ROSES",
      "quantity": 50.0,
      "box_number": "2923500",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.22,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 11.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FORTUNE",
      "category": "ROSES",
      "quantity": 100.0,
      "box_number": "2923500",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.3,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 30.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "LOLA",
      "category": "ROSES",
      "quantity": 150.0,
      "box_number": "2923500",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.35,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 52.5
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "NINA",
      "category": "ROSES",
      "quantity": 50.0,
      "box_number": "2923500",
      "plantation": "BELLARO S.A.S.",
      "unit_price": 0.3,
      "box_marking": "HB 2 (120*35*35)",
      "total_price": 15.0
    }
  ],
  "country": "Kyrgyz Republic (Kyrgyzstan)",
  "summary": {
    "total_boxes": 3.0,
    "total_stems": 1350.0,
    "total_amount": 328.5
  },
  "supplier": "BELLARO S.A.S.",
  "invoice_date": "2026-02-27",
  "invoice_number": "5174921",
  "processing_report": {
    "notes": "Invoice type: Hybrid (grouped + individual). Detected 3 physical boxes. No issues detected. Multiboxes successfully expanded.",
    "status": "ok",
    "sum_boxes": 3,
    "sum_stems": 1350.0,
    "sum_amount": 328.5,
    "items_count": 8,
    "discrepancies": [],
    "expected_boxes": 3.0,
    "expected_stems": 1350.0,
    "expected_amount": 328.5
  }
}
История (последние 20)
ID Файл Дата
70 5174921.pdf 2026-03-02 09:24:44.222614+00:00 Excel
68 5174921.pdf 2026-03-02 07:59:32.827994+00:00 Excel
67 5174921.pdf 2026-03-02 07:56:32.692509+00:00 Excel
38 5173995.pdf 2026-02-24 05:36:26.755550+00:00 Excel
17 5173995.pdf 2026-02-23 16:45:59.742777+00:00 Excel