Lines 2859-2866
CREATE TABLE `aqbudgets` ( -- information related to Funds
Link Here
|
2859 |
`budget_name` varchar(80) default NULL, -- name assigned to the fund by the user |
2859 |
`budget_name` varchar(80) default NULL, -- name assigned to the fund by the user |
2860 |
`budget_branchcode` varchar(10) default NULL, -- branch that this fund belongs to (branches.branchcode) |
2860 |
`budget_branchcode` varchar(10) default NULL, -- branch that this fund belongs to (branches.branchcode) |
2861 |
`budget_amount` decimal(28,6) NULL default '0.00', -- total amount for this fund |
2861 |
`budget_amount` decimal(28,6) NULL default '0.00', -- total amount for this fund |
2862 |
`budget_encumb` decimal(28,6) NULL default '0.00', -- not used in the code |
2862 |
`budget_encumb` decimal(28,6) NULL default '0.00', -- budget warning at percentage |
2863 |
`budget_expend` decimal(28,6) NULL default '0.00', -- not used in the code |
2863 |
`budget_expend` decimal(28,6) NULL default '0.00', -- budget warning at amount |
2864 |
`budget_notes` LONGTEXT, -- notes related to this fund |
2864 |
`budget_notes` LONGTEXT, -- notes related to this fund |
2865 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this fund was last touched (created or modified) |
2865 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this fund was last touched (created or modified) |
2866 |
`budget_period_id` int(11) default NULL, -- id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) |
2866 |
`budget_period_id` int(11) default NULL, -- id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) |
2867 |
- |
|
|