Skip to content

app.change_order_totals

View

Change order totals: NULL while any line is unpriced, never zero, with the unpriced count (invariant 11).

Columns of app.change_order_totals
ColumnTypeNullableDescription
change_order_iduuidYesChange order.
project_iduuidYesProject.
line_countbigintYesLines on the change order.
unpriced_countbigintYesLines whose unit price is NULL.
total_minorbigintYesTotal in minor units; NULL while any line is unpriced or there are no lines.