Правила трансформации OCR-данных в целевую схему (включая валидацию).
Доступные справочники для shortcode
varities{{ref:varities}}
test{{ref:test}}
Последний сырой OCR (из песочницы)
{
"notes": [],
"table": {
"rows": [
[
"Description",
"Grade",
"Boxes",
"F.B.E.",
"T. Units",
"Stems",
"P.FOB",
"Total"
],
[
"Description",
"Grade",
"Boxes",
"F.B.E.",
"T. Units",
"Stems",
"P.FOB",
"Total"
],
[
"Description",
"Grade",
"Boxes",
"F.B.E.",
"T. Units",
"Stems",
"P.FOB",
"Total"
]
],
"columns": []
},
"metadata": {},
"sections": [],
"totals_raw": "",
"header_text": " Invoice\n UTOPIA FARMS UTF S.A.S\n Number Ship Date\n De Los Robles N6 S/N y Los Laureles\n 159907 2/13/2026\n RUC: 1793074472001\n LAURELES Country Code: EC\n phone: 022-387-915\nShip To: Sold To:\nTOO QAZAQ IMEX TH AZALIA\nSTR. GUDERMESSKAYA 127 Air Waybill: 369-9832 3934\nKARAGANDA, KAZAKHSTAN Airline: ATLAS AIR INC\nPhone: Agent: PACIFIC ICEBERG CENTER\n--------------------------------------------------------------------- D.A.E: 05520264000164190 AIRLINE\nPrepared: JBENAVIDES 2026/02/12 09:59:45\n El Chivan HAWB: PC602013461\n SP. ROSE ASSORTED 10S/B 60CM 200ST (ST 2164635-12) 60 CM 1 H 0.5 200 ST 200 0.700 140.00\n SPRAY ROSE G FIBONACCI AUREUS 60 CM 50 ST 50 0.700 35.00\n SPRAY ROSE G FIBONACCI GIOCONDA 60 CM 40 ST 40 0.700 28.00\n SPRAY ROSE G FIBONACCI NAUTILUS 60 CM 50 ST 50 0.700 35.00\n SPRAY ROSE G FIBONACCI YANTRA 60 CM 60 ST 60 0.700 42.00\n **Box Marking: KOLIBRI\n Subtotal Stems : 200 140.00\n -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n SUBTOTAL FULL: 0 HALF: 1 QUARTER: 0 EIGHTH: 0\n Flor y Campo HAWB: PC602013351\n ROSE ASSORTED 25ST 50CM 350ST (ST 2164635-2) 50 CM 2 H 1 700 ST 700 0.280 196.00\n ROSE ABSOLUT IN PINK 50 CM 50 ST 50 0.280 14.00\n ROSE FREEDOM 50 CM 100 ST 100 0.280 28.00\n ROSE FULL MONTY 50 CM 100 ST 100 0.280 28.00\n ROSE HIGH & MAGIC 50 CM 50 ST 50 0.280 14.00\n ROSE JESSIKA 50 CM 100 ST 100 0.280 28.00\n ROSE MIA 50 CM 50 ST 50 0.280 14.00\n ROSE PINK MONDIAL 50 CM 50 ST 50 0.280 14.00\n ROSE REDIANT 50 CM 50 ST 50 0.280 14.00\n ROSE SWEET MEMORY 50 CM 50 ST 50 0.280 14.00\n ROSE V.I.PINK 50 CM 50 ST 50 0.280 14.00\n ROSE(G) COUNTRY SECRET 50 ST 50 0.280 14.00\n ROSE ASSORTED 25ST 50CM 350ST (ST 2164635-3) 50 CM 2 H 1 700 ST 700 0.280 196.00\n ROSE ABSOLUT IN PINK 50 CM 50 ST 50 0.280 14.00\n ROSE FREEDOM 50 CM 100 ST 100 0.280 28.00\n ROSE FULL MONTY 50 CM 100 ST 100 0.280 28.00\n ROSE HIGH & MAGIC 50 CM 50 ST 50 0.280 14.00\n ROSE JESSIKA 50 CM 100 ST 100 0.280 28.00\n ROSE MIA 50 CM 50 ST 50 0.280 14.00\n ROSE PINK MONDIAL 50 CM 50 ST 50 0.280 14.00\n ROSE REDIANT 50 CM 50 ST 50 0.280 14.00\n ROSE SWEET MEMORY 50 CM 50 ST 50 0.280 14.00\n ROSE V.I.PINK 50 CM 50 ST 50 0.280 14.00\n ROSE(G) COUNTRY SECRET 50 ST 50 0.280 14.00\n ROSE PINK FLOYD 25ST 60CM 400ST (ST 2164635-6) 60 CM 1 H 0.5 200 ST 400 0.360 144.00\n ROSE PINK FLOYD 60 CM 200 ST 400 0.360 144.00\n ROSE ASSORTED 25ST 40CM 500ST (ST 2164635-9) 40 CM 1 H 0.5 500 ST 500 0.220 110.00\n ROSE ABSOLUT IN PINK 40 CM 25 ST 25 0.220 5.50\n ROSE FORTUNE 40 CM 25 ST 25 0.220 5.50\n ROSE FREEDOM 40 CM 25 ST 25 0.220 5.50\n ROSE FULL MONTY 50 ST 50 0.220 11.00\n ROSE FULL MONTY 40 CM 25 ST 25 0.220 5.50\nTHE EXPORTER OF THE PRODUCTS COVERED BY THIS DOCUMENT DECLARES THAT, EXCEPT WHERE OTHERWISE CLEARLY INIDCATED, THESE PRODUCTS ARE OF ECUADOR PREFERENTIAL\n TOTALS FULL: 0 HALF: 14 QUARTER: 0 EIGHTH: 3 Pieces=17 F.B.E= 7.375 Total Stems: 5,670 USD: 1,876.60\n Page 1 of 3 V. 1.0"
}