Lines 3002-3008
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3002 |
`freight` decimal(28,6) default NULL, -- shipping costs (not used) |
3002 |
`freight` decimal(28,6) default NULL, -- shipping costs (not used) |
3003 |
`unitprice` decimal(28,6) default NULL, -- the actual cost entered when receiving this line item |
3003 |
`unitprice` decimal(28,6) default NULL, -- the actual cost entered when receiving this line item |
3004 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3004 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3005 |
`cancelledby` varchar(10) default NULL, -- not used? always NULL |
|
|
3006 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3005 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3007 |
`order_internalnote` mediumtext, -- notes related to this order line, made for staff |
3006 |
`order_internalnote` mediumtext, -- notes related to this order line, made for staff |
3008 |
`order_vendornote` mediumtext, -- notes related to this order line, made for vendor |
3007 |
`order_vendornote` mediumtext, -- notes related to this order line, made for vendor |