Песочница: ALLEGROMAILS1

Intent ID: 7

Назад
1) Загрузить файл и получить сырой OCR JSON
Сохраняем последний файл и сырой OCR, чтобы можно было повторно тестировать маппинг без перезагрузки.
Скачать последний файл (Blooming city - 2026-16592 - 2026-03-11.pdf)
2) Правила трансформации
Правила трансформации OCR-данных в целевую схему (включая валидацию).
Промпт LLM-подсказки
Используется кнопкой «Подсказать rules».
Сырой OCR JSON (Pass 1)
{
  "awb": "145-9981 7631",
  "items": [
    {
      "boxes": 1,
      "length": "50",
      "variety": "MONDIAL",
      "category": "ROSAS",
      "quantity": 350,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.33,
      "box_marking": "HBJ",
      "total_price": 115.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 350,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.4,
      "box_marking": "HBJ",
      "total_price": 140.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "PHOENIX",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "HERMOSA",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "MONDIAL",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "BRIGHTON",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "CANDLELIGHT",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "FRUTETTO",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "HIGH MAGIC",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "FREEDOM",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "BE SWEET",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "FULL MONTY",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "MONDIAL",
      "category": "ROSAS",
      "quantity": 300,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.37,
      "box_marking": "HBJ",
      "total_price": 111.0
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 350,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.33,
      "box_marking": "HBJ",
      "total_price": 115.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "BRIGHTON",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "CANDLELIGHT",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "NINA",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "PALOMA",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "MONDIAL",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 19.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "FRUTETTO",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "FULL MONTY",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "PINK MONDIAL",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "FREEDOM",
      "category": "ROSAS",
      "quantity": 25,
      "box_number": "20639",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.38,
      "box_marking": "HBJ",
      "total_price": 9.5
    }
  ],
  "country": "Ecuador",
  "summary": {
    "total_boxes": 6,
    "total_stems": 1950,
    "total_amount": 710.0
  },
  "supplier": "ALLEGRO FARMS CIA LTDA",
  "invoice_date": "3/11/2026",
  "invoice_number": "2026-16592",
  "processing_report": {
    "notes": "Тип инвойса: Групповые коробки без агрегата (В). Обнаружено физических коробок: 1. Раскрытие мультибокса (не применяется). Notice: 1. The Customer must pay this invoice according to the initial agreement. 2. Only written credits/claims for quality and/or quantity problems which are informed within the 48-hour period after shipment is received at your place would be accepted. (We consider a 12 day transportation period from the flight day out of Ecuador) 3. All claims must contain: invoice number, awb number, date shipment was received, variety, length of flowers, damaged stems count and claim amount 4. The Claim must include clear pictures or video of: 1. Box Label",
    "status": "ok",
    "sum_boxes": 1,
    "sum_stems": 1950,
    "sum_amount": 710.0,
    "items_count": 24,
    "discrepancies": [
      "Несовпадение количества коробок"
    ],
    "expected_boxes": 6,
    "expected_stems": 1950,
    "expected_amount": 710.0
  }
}
Результат (Pass 2)

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