| adjustment_id |
INT |
10 |
|
√ |
null |
|
|
primary key for adjustments |
| invoiceid |
INT |
10 |
|
|
null |
|
|
aqinvoices.invoiceid
|
aqinvoice_adjustments_fk_invoiceid C
|
|
foreign key to link an adjustment to an invoice |
| adjustment |
DECIMAL |
28,6 |
√ |
|
null |
|
|
amount of adjustment |
| reason |
VARCHAR |
80 |
√ |
|
null |
|
|
reason for adjustment defined by authorised values in ADJ_REASON category |
| note |
MEDIUMTEXT |
16777215 |
√ |
|
null |
|
|
text to explain adjustment |
| budget_id |
INT |
10 |
√ |
|
null |
|
|
aqbudgets.budget_id
|
aqinvoice_adjustments_fk_budget_id N
|
|
optional link to budget to apply adjustment to |
| encumber_open |
SMALLINT |
5 |
|
|
1 |
|
|
whether or not to encumber the funds when invoice is still open, 1 = yes, 0 = no |
| timestamp |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
timestamp of last adjustment to adjustment |
