Lines 3002-3007
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3002 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3002 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3003 |
`cancelledby` varchar(10) default NULL, -- not used? always NULL |
3003 |
`cancelledby` varchar(10) default NULL, -- not used? always NULL |
3004 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3004 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
|
|
3005 |
`cancellationreason` text default NULL, -- reason of cancellation |
3005 |
`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 |
3006 |
`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 |
3007 |
`supplierreference` mediumtext, -- not used? always NULL |
3008 |
`supplierreference` mediumtext, -- not used? always NULL |