/* FIX Document Lines */
UPDATE document_lines SET
unit_price = 0,
unit = 'Unit(s)',
tax_total = 0,
item_id = <pick one (ID)>,
discount = 0,
quantity = 0,
product_code = <pick one ('FT','NC', etc..)>
WHERE document_id IN (document_ids);
/* Search document Taxes */
/* Search FROM */
SELECT * FROM document_line_taxes WHERE document_line_id IN (SELECT id FROM document_lines WHERE document_id IN (document_ids));
/* Search TO */
SELECT * FROM document_line_taxes WHERE document_line_id IN (SELECT id FROM document_lines WHERE document_id IN (document_ids));
/* Insert document Taxes sample */
INSERT INTO document_line_taxes (document_line_id, tax_id, tax_code, tax_percentage, reason, reason_code) SELECT id, <tax_id>, <tax_code>, <tax_percentage> NULL, NULL FROM document_lines WHERE document_id IN (document_ids);
/* Check tax_id, tax_code, tax_percentage from table 'taxes' or similar line*/