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