Lines 3167-3173
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3167 |
`purchaseordernumber` LONGTEXT, -- not used? always NULL |
3167 |
`purchaseordernumber` LONGTEXT, -- not used? always NULL |
3168 |
`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) |
3168 |
`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) |
3169 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified |
3169 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified |
3170 |
`rrp` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item |
3170 |
`rrp` decimal(13,2) DEFAULT NULL, -- the retail cost for this line item |
|
|
3171 |
`replacementprice` decimal(28,6) DEFAULT NULL, -- the replacement cost for this line item |
3171 |
`rrp_tax_excluded` decimal(28,6) default NULL, -- the replacement cost excluding tax |
3172 |
`rrp_tax_excluded` decimal(28,6) default NULL, -- the replacement cost excluding tax |
3172 |
`rrp_tax_included` decimal(28,6) default NULL, -- the replacement cost including tax |
3173 |
`rrp_tax_included` decimal(28,6) default NULL, -- the replacement cost including tax |
3173 |
`ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item |
3174 |
`ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item |
3174 |
- |
|
|