|
|
| Query name | Field name | Field type | Source table | Source field |
|---|---|---|---|---|
| query | ID | INTEGER | table (Table) | ID |
| price | DOUBLE | table (Table) | price | |
| price_without_tax | "price" / 1.19 | |||
| product | VARCHAR | table (Table) | product | |
| quantity | TINYINT | table (Table) | quantity | |
| tax_total | "quantity" * "price" - "quantity" * "price" / 1.19 | |||
| total | "quantity" * "price" |