Lines 3112-3119
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3112 |
`listprice` decimal(28,6) default NULL, -- the vendor price for this line item |
3112 |
`listprice` decimal(28,6) default NULL, -- the vendor price for this line item |
3113 |
`datereceived` date default NULL, -- the date this order was received |
3113 |
`datereceived` date default NULL, -- the date this order was received |
3114 |
invoiceid int(11) default NULL, -- id of invoice |
3114 |
invoiceid int(11) default NULL, -- id of invoice |
3115 |
`freight` decimal(28,6) default NULL, -- shipping costs (not used) |
3115 |
`freight` decimal(28,6) DEFAULT NULL, -- shipping costs (not used) |
3116 |
`unitprice` decimal(28,6) default NULL, -- the actual cost entered when receiving this line item |
3116 |
`unitprice` decimal(28,6) DEFAULT NULL, -- the actual cost entered when receiving this line item |
|
|
3117 |
`unitprice_tax_excluded` decimal(28,6) default NULL, -- the unit price excluding tax (on receiving) |
3118 |
`unitprice_tax_included` decimal(28,6) default NULL, -- the unit price including tax (on receiving) |
3117 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3119 |
`quantityreceived` smallint(6) NOT NULL default 0, -- the quantity that have been received so far |
3118 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3120 |
`datecancellationprinted` date default NULL, -- the date the line item was deleted |
3119 |
`cancellationreason` text default NULL, -- reason of cancellation |
3121 |
`cancellationreason` text default NULL, -- reason of cancellation |
Lines 3122-3131
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3122 |
`purchaseordernumber` mediumtext, -- not used? always NULL |
3124 |
`purchaseordernumber` mediumtext, -- not used? always NULL |
3123 |
`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) |
3125 |
`basketno` int(11) default NULL, -- links this order line to a specific basket (aqbasket.basketno) |
3124 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified |
3126 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this order line was last modified |
3125 |
`rrp` decimal(13,2) default NULL, -- the replacement cost for this line item |
3127 |
`rrp` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item |
3126 |
`ecost` decimal(13,2) default NULL, -- the estimated cost for this line item |
3128 |
`rrp_tax_excluded` decimal(28,6) default NULL, -- the replacement cost excluding tax |
3127 |
`gstrate` decimal(6,4) default NULL, -- the tax rate for this line item |
3129 |
`rrp_tax_included` decimal(28,6) default NULL, -- the replacement cost including tax |
3128 |
`discount` float(6,4) default NULL, -- the discount for this line item |
3130 |
`ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item |
|
|
3131 |
`ecost_tax_excluded` decimal(28,6) default NULL, -- the estimated cost excluding tax |
3132 |
`ecost_tax_included` decimal(28,6) default NULL, -- the estimated cost including tax |
3133 |
`tax_rate` decimal(6,4) DEFAULT NULL, -- the tax rate for this line item (%) |
3134 |
`tax_value` decimal(28,6) default NULL, -- the tax value for this line item |
3135 |
`discount` float(6,4) default NULL, -- the discount for this line item (%) |
3129 |
`budget_id` int(11) NOT NULL, -- the fund this order goes against (aqbudgets.budget_id) |
3136 |
`budget_id` int(11) NOT NULL, -- the fund this order goes against (aqbudgets.budget_id) |
3130 |
`budgetdate` date default NULL, -- not used? always NULL |
3137 |
`budgetdate` date default NULL, -- not used? always NULL |
3131 |
`sort1` varchar(80) default NULL, -- statistical field |
3138 |
`sort1` varchar(80) default NULL, -- statistical field |
3132 |
- |
|
|