transaction_items

+-------------------+-----------+----------+-----------------------------------------+
|    Field name     |   Type    |   Mode   |               Description               |
+-------------------+-----------+----------+-----------------------------------------+
| id                | INTEGER   | REQUIRED |                                         |
| shop_name         | STRING    | NULLABLE |                                         |
| transaction_id    | INTEGER   | NULLABLE | Transaction which this item belongs     |
| product_id        | INTEGER   | NULLABLE | Unique internal product ID              |
| barcode           | STRING    | NULLABLE | Universal product ID                    |
| category_code     | STRING    | NULLABLE | ID of the category                      |
| category_name     | STRING    | NULLABLE | Name of the category                    |
| qty               | INTEGER   | NULLABLE | Number of items sold in the transaction |
| product_name      | STRING    | NULLABLE | Name of the product                     |
| sales             | NUMERIC   | NULLABLE | Total net sales of the items sold       |
| tax               | NUMERIC   | NULLABLE | Total tax charged                       |
| discount          | NUMERIC   | NULLABLE | Total discount applied                  |
| cost              | NUMERIC   | NULLABLE | Total cost of the items                 |
| invoiced_at       | TIMESTAMP | NULLABLE | UTC of the transaction                  |
| local_invoiced_at | DATETIME  | NULLABLE | Local time of the transaction           |
+-------------------+-----------+----------+-----------------------------------------+