|
Lines 3030-3036
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
| 3030 |
`quantity` smallint(6) default NULL, -- the quantity ordered |
3030 |
`quantity` smallint(6) default NULL, -- the quantity ordered |
| 3031 |
`currency` varchar(3) default NULL, -- the currency used for the purchase |
3031 |
`currency` varchar(3) default NULL, -- the currency used for the purchase |
| 3032 |
`listprice` decimal(28,6) default NULL, -- the vendor price for this line item |
3032 |
`listprice` decimal(28,6) default NULL, -- the vendor price for this line item |
| 3033 |
`totalamount` decimal(28,6) default NULL, -- not used? always NULL |
|
|
| 3034 |
`datereceived` date default NULL, -- the date this order was received |
3033 |
`datereceived` date default NULL, -- the date this order was received |
| 3035 |
invoiceid int(11) default NULL, -- id of invoice |
3034 |
invoiceid int(11) default NULL, -- id of invoice |
| 3036 |
`freight` decimal(28,6) default NULL, -- shipping costs (not used) |
3035 |
`freight` decimal(28,6) default NULL, -- shipping costs (not used) |