Skip to content

app.budget_line_amounts

View

Budget line amounts, derived: extended amount (NULL when unpriced, never zero), contingency moved in and out, the GL account (the item's explicit default, else by class: decision D13 as owner decision 39 reads it) and approved spend.

Columns of app.budget_line_amounts
ColumnTypeNullableDescription
budget_line_iduuidYesBudget line.
budget_iduuidYesBudget.
line_typeapp.budget_line_typeYesLine type.
uridtextYesDimension 2.
account_codetextYesExpense account the line posts to: the priced item's explicit GL default, else the URID class's expense account.
extended_minorbigintYesQuantity times unit price in minor units; NULL when unpriced.
is_unpricedbooleanYesTrue when the unit price is NULL.
drawn_in_minornumericYesContingency drawn into the line.
drawn_out_minornumericYesContingency drawn out of the line.
actual_minornumericYesApproved and paid expenses posted to the line.