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