Skip to content

app.settlement_totals

View

Settlement totals, NULL-aware: the net is NULL while any line is unpriced, with the unpriced count beside it.

Columns of app.settlement_totals
ColumnTypeNullableDescription
settlement_iduuidYesSettlement.
project_iduuidYesProject.
engagement_iduuidYesEngagement.
currency_codecharacter(3)YesCurrency.
line_countbigintYesLines on the settlement.
unpriced_countbigintYesLines whose amount is NULL.
net_minorbigintYesAdditions less deductions and withholding; NULL while any line is unpriced.