Lines 3006-3012
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3006 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3006 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3007 |
`order_internalnote` mediumtext, -- notes related to this order line, made for staff |
3007 |
`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 |
3008 |
`order_vendornote` mediumtext, -- notes related to this order line, made for vendor |
3009 |
`supplierreference` mediumtext, -- not used? always NULL |
|
|
3010 |
`purchaseordernumber` mediumtext, -- not used? always NULL |
3009 |
`purchaseordernumber` mediumtext, -- not used? always NULL |
3011 |
`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) |
3010 |
`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) |
3012 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified |
3011 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified |