|
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" |