Песочница: TESSACORPORATION

Intent ID: 17

Назад
1) Загрузить файл и получить сырой OCR JSON
Сохраняем последний файл и сырой OCR, чтобы можно было повторно тестировать маппинг без перезагрузки.
Скачать последний файл (90718558.pdf)
2) Правила трансформации
Правила трансформации OCR-данных в целевую схему (включая валидацию).
Промпт LLM-подсказки
Используется кнопкой «Подсказать rules».
Сырой OCR JSON (Pass 1)
{
  "awb": "145-99817594",
  "items": [
    {
      "boxes": 1,
      "length": "40",
      "variety": "BIKINI",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "CABARET",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "CORAL REEF",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "DEEP PURPLE",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "FREEDOM",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "FRUTTETO",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "FULL MONTY",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "HOTSPOT",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "LOLA",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "MONDIAL",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "NENA",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "PINK FLOYD",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "PINK MONDIAL",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "PINK X- PRESSION",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "TIBET",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "TIFFANY",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- 1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "CREAM X- PRESSION",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "ESPERANCE",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "FULL MONTY",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "KAHALA",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "LOLA",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "NENA",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "PALOMA",
      "category": "Flowers",
      "quantity": 50,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 14.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "SILANTOI",
      "category": "Flowers",
      "quantity": 50,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 14.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "SWEET ESCIMO",
      "category": "Flowers",
      "quantity": 50,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 14.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "SWEETNESS",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "TIBET",
      "category": "Flowers",
      "quantity": 25,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 7.0
    },
    {
      "boxes": 1,
      "length": "40",
      "variety": "VENDELA",
      "category": "Flowers",
      "quantity": 50,
      "box_number": "1",
      "plantation": "TESSA- E1",
      "unit_price": 0.28,
      "box_marking": "HB XL 2",
      "total_price": 14.0
    }
  ],
  "country": "Kyrgyz Republic (Kyrgyzstan)",
  "summary": {
    "total_boxes": 2,
    "total_stems": 800,
    "total_amount": 224.0
  },
  "supplier": "TOO QAZAQ IMEX /SOCIEDAD DE RESPONSABILIDAD LIMITADA",
  "invoice_date": "",
  "invoice_number": "",
  "processing_report": {
    "notes": "Инвойс составного типа (каждая физическая коробка содержит смешанные сорта). Обнаружено 2 физические коробки. Раскрытие мультибокса не применялось. Некоторые ключевые поля (invoice_number, invoice_date) не были извлечены согласно строгим правилам локализации, хотя данные присутствовали в других частях OCR.",
    "status": "warning",
    "sum_boxes": 2,
    "sum_stems": 800,
    "sum_amount": 224.0,
    "items_count": 28,
    "discrepancies": [
      "Calculated total stems (800) does not match expected stems (700).",
      "Calculated total amount (224.00) does not match expected amount (320.00)."
    ],
    "expected_boxes": 2,
    "expected_stems": 700,
    "expected_amount": 320.0
  }
}
Результат (Pass 2)

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