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