Песочница: ALLEGROMAILS1

Intent ID: 7

Назад
1) Загрузить файл и получить сырой OCR JSON
Сохраняем последний файл и сырой OCR, чтобы можно было повторно тестировать маппинг без перезагрузки.
Скачать последний файл (Blooming city - 2026-16608 - 2026-03-12.pdf)
2) Правила трансформации
Правила трансформации OCR-данных в целевую схему (включая валидацию).
Промпт LLM-подсказки
Используется кнопкой «Подсказать rules».
Сырой OCR JSON (Pass 1)
{
  "awb": "145-9981 7631",
  "items": [
    {
      "boxes": 1,
      "length": "50",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 75,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.33,
      "box_marking": "HBJ",
      "total_price": 24.75
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 225,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.37,
      "box_marking": "HBJ",
      "total_price": 83.25
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "CANDLELIGHT",
      "category": "ROSAS",
      "quantity": 300,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.47,
      "box_marking": "HBJ",
      "total_price": 141.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 250,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.37,
      "box_marking": "HBJ",
      "total_price": 92.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "CANDLELIGHT",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.47,
      "box_marking": "HBJ",
      "total_price": 23.5
    },
    {
      "boxes": 1,
      "length": "50",
      "variety": "NINA",
      "category": "ROSAS",
      "quantity": 100,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.33,
      "box_marking": "HBJ",
      "total_price": 33.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "MONDIAL",
      "category": "ROSAS",
      "quantity": 100,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.37,
      "box_marking": "HBJ",
      "total_price": 37.0
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "EXPLORER",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.37,
      "box_marking": "HBJ",
      "total_price": 18.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "CANDLELIGHT",
      "category": "ROSAS",
      "quantity": 50,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.47,
      "box_marking": "HBJ",
      "total_price": 23.5
    },
    {
      "boxes": 1,
      "length": "60",
      "variety": "PINK MONDIAL",
      "category": "ROSAS",
      "quantity": 300,
      "box_number": "20671",
      "plantation": "ALLEGRO FARMS CIA LTDA",
      "unit_price": 0.37,
      "box_marking": "HBJ",
      "total_price": 111.0
    }
  ],
  "country": "Ecuador",
  "summary": {
    "total_boxes": 5,
    "total_stems": 1500,
    "total_amount": 588.0
  },
  "supplier": "ALLEGRO FARMS CIA LTDA",
  "invoice_date": "3/12/2026",
  "invoice_number": "2026-16608",
  "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 2. Bunch with barcode label 3. Photos of all stems with phytosanitary problems 5. We will accept claims of flower with phytosanitary damage 6. ALLEGRO FARMS does not pay transportation costs, freight costs, related fees and/or other customer expenses 7. ALLEGRO FARMS is not responsible for transportation and logistics after the boxes are delivered at the terminal of Quito, procedure for which Cargo Agencies are responsible, except in CIF prices 8. The flight delay because of the technical problems during 48 hours cannot be considered for the claim if the required temperature is maintained within the normal standards 9. In case a \"force majeur\"; situation takes place (such as temperature breach, aircraft breakage, etc) ALLEGRO FARMS is not responsible for the quality. The responsibility will be taken by the airline company 10. We do not accept claims for mishandling of boxes in cargo or related to transportation after of delivery in cargo agency 11. The claim will be answered within 72 working hours after receipt with your approval or disclamation Email for claims: claims@allegroec.com copy to the email of your sales executive: sales1@allegroec.com and coordinacion@allegroec.com",
    "status": "ok",
    "sum_boxes": 1,
    "sum_stems": 1500,
    "sum_amount": 588.0,
    "items_count": 10,
    "discrepancies": [
      "Несовпадение количества коробок"
    ],
    "expected_boxes": 5,
    "expected_stems": 1500,
    "expected_amount": 588.0
  }
}
Результат (Pass 2)

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