Lines 3019-3025
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3019 |
`freight` decimal(28,6) default NULL, -- shipping costs (not used) |
3019 |
`freight` decimal(28,6) default NULL, -- shipping costs (not used) |
3020 |
`unitprice` decimal(28,6) default NULL, -- the actual cost entered when receiving this line item |
3020 |
`unitprice` decimal(28,6) default NULL, -- the actual cost entered when receiving this line item |
3021 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3021 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3022 |
createdby int(11) NULL DEFAULT NULL, -- the borrowernumber of order line's creator |
3022 |
created_by int(11) NULL DEFAULT NULL, -- the borrowernumber of order line's creator |
3023 |
`cancelledby` varchar(10) default NULL, -- not used? always NULL |
3023 |
`cancelledby` varchar(10) default NULL, -- not used? always NULL |
3024 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3024 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3025 |
`order_internalnote` mediumtext, -- notes related to this order line, made for staff |
3025 |
`order_internalnote` mediumtext, -- notes related to this order line, made for staff |