Lines 3052-3058
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3052 |
`freight` decimal(28,6) default NULL, -- shipping costs (not used) |
3052 |
`freight` decimal(28,6) default NULL, -- shipping costs (not used) |
3053 |
`unitprice` decimal(28,6) default NULL, -- the actual cost entered when receiving this line item |
3053 |
`unitprice` decimal(28,6) default NULL, -- the actual cost entered when receiving this line item |
3054 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3054 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3055 |
createdby int(11) NULL DEFAULT NULL, -- the borrowernumber of order line's creator |
3055 |
created_by int(11) NULL DEFAULT NULL, -- the borrowernumber of order line's creator |
3056 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3056 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3057 |
`cancellationreason` text default NULL, -- reason of cancellation |
3057 |
`cancellationreason` text default NULL, -- reason of cancellation |
3058 |
`order_internalnote` mediumtext, -- notes related to this order line, made for staff |
3058 |
`order_internalnote` mediumtext, -- notes related to this order line, made for staff |