budget_period_id |
INT |
10 |
|
√ |
null |
|
|
primary key and unique number assigned by Koha |
budget_period_startdate |
DATE |
10 |
|
|
null |
|
|
date when the budget starts |
budget_period_enddate |
DATE |
10 |
|
|
null |
|
|
date when the budget ends |
budget_period_active |
BIT |
0 |
√ |
|
0 |
|
|
whether this budget is active or not (1 for yes, 0 for no) |
budget_period_description |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
description assigned to this budget |
budget_period_total |
DECIMAL |
28,6 |
√ |
|
null |
|
|
total amount available in this budget |
budget_period_locked |
BIT |
0 |
√ |
|
null |
|
|
whether this budget is locked or not (1 for yes, 0 for no) |
sort1_authcat |
VARCHAR |
10 |
√ |
|
null |
|
|
statistical category for this budget |
sort2_authcat |
VARCHAR |
10 |
√ |
|
null |
|
|
second statistical category for this budget |