| budget_id |
INT |
10 |
|
√ |
null |
|
|
primary key and unique number assigned to each fund by Koha |
| budget_parent_id |
INT |
10 |
√ |
|
null |
|
|
if this fund is a child of another this will include the parent id (aqbudgets.budget_id) |
| budget_code |
VARCHAR |
30 |
√ |
|
null |
|
|
code assigned to the fund by the user |
| budget_name |
VARCHAR |
80 |
√ |
|
null |
|
|
name assigned to the fund by the user |
| budget_branchcode |
VARCHAR |
10 |
√ |
|
null |
|
|
branch that this fund belongs to (branches.branchcode) |
| budget_amount |
DECIMAL |
28,6 |
√ |
|
0.000000 |
|
|
total amount for this fund |
| budget_encumb |
DECIMAL |
28,6 |
√ |
|
0.000000 |
|
|
budget warning at percentage |
| budget_expend |
DECIMAL |
28,6 |
√ |
|
0.000000 |
|
|
budget warning at amount |
| budget_notes |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
notes related to this fund |
| timestamp |
TIMESTAMP |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
date and time this fund was last touched (created or modified) |
