Lines 3154-3160
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3154 |
`gstrate` decimal(6,4) default NULL, -- the tax rate for this line item |
3154 |
`gstrate` decimal(6,4) default NULL, -- the tax rate for this line item |
3155 |
`discount` float(6,4) default NULL, -- the discount for this line item |
3155 |
`discount` float(6,4) default NULL, -- the discount for this line item |
3156 |
`budget_id` int(11) NOT NULL, -- the fund this order goes against (aqbudgets.budget_id) |
3156 |
`budget_id` int(11) NOT NULL, -- the fund this order goes against (aqbudgets.budget_id) |
3157 |
`budgetgroup_id` int(11) NOT NULL, -- not used? always zero |
|
|
3158 |
`budgetdate` date default NULL, -- not used? always NULL |
3157 |
`budgetdate` date default NULL, -- not used? always NULL |
3159 |
`sort1` varchar(80) default NULL, -- statistical field |
3158 |
`sort1` varchar(80) default NULL, -- statistical field |
3160 |
`sort2` varchar(80) default NULL, -- second statistical field |
3159 |
`sort2` varchar(80) default NULL, -- second statistical field |
3161 |
- |
|
|