app.invoice_totals
Vista
Invoice totals and settlement, NULL-aware: subtotal and tax are NULL while any line is unpriced.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| invoice_id | uuid | Sí | Invoice. |
| project_id | uuid | Sí | Project. |
| direction | app.money_direction | Sí | Receivable or Payable. |
| currency_code | character(3) | Sí | Currency of the invoice. |
| unpriced_count | bigint | Sí | Lines whose unit price is NULL. |
| subtotal_minor | bigint | Sí | Sum of line amounts before tax; NULL while any line is unpriced. |
| tax_minor | bigint | Sí | Tax on the lines; NULL while any line is unpriced. |
| applied_minor | bigint | Sí | Payments applied to the invoice. |