app.invoice_totals
View
Invoice totals and settlement, NULL-aware: subtotal and tax are NULL while any line is unpriced.
| Column | Type | Nullable | Description |
|---|---|---|---|
| invoice_id | uuid | Yes | Invoice. |
| project_id | uuid | Yes | Project. |
| direction | app.money_direction | Yes | Receivable or Payable. |
| currency_code | character(3) | Yes | Currency of the invoice. |
| unpriced_count | bigint | Yes | Lines whose unit price is NULL. |
| subtotal_minor | bigint | Yes | Sum of line amounts before tax; NULL while any line is unpriced. |
| tax_minor | bigint | Yes | Tax on the lines; NULL while any line is unpriced. |
| applied_minor | bigint | Yes | Payments applied to the invoice. |