Lines 3102-3109
CREATE TABLE `aqorders` ( -- information related to the basket line items
Link Here
|
3102 |
`ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item |
3102 |
`ecost` decimal(13,2) DEFAULT NULL, -- the replacement cost for this line item |
3103 |
`ecost_tax_excluded` decimal(28,6) default NULL, -- the estimated cost excluding tax |
3103 |
`ecost_tax_excluded` decimal(28,6) default NULL, -- the estimated cost excluding tax |
3104 |
`ecost_tax_included` decimal(28,6) default NULL, -- the estimated cost including tax |
3104 |
`ecost_tax_included` decimal(28,6) default NULL, -- the estimated cost including tax |
3105 |
`tax_rate` decimal(6,4) DEFAULT NULL, -- the tax rate for this line item (%) |
3105 |
`tax_rate_bak` decimal(6,4) DEFAULT NULL, -- the tax rate for this line item (%) |
3106 |
`tax_value` decimal(28,6) default NULL, -- the tax value for this line item |
3106 |
`tax_rate_on_ordering` decimal(6,4) DEFAULT NULL, -- the tax rate on ordering for this line item (%) |
|
|
3107 |
`tax_rate_on_receiving` decimal(6,4) DEFAULT NULL, -- the tax rate on receiving for this line item (%) |
3108 |
`tax_value_bak` decimal(28,6) default NULL, -- the tax value for this line item |
3109 |
`tax_value_on_ordering` decimal(28,6) DEFAULT NULL, -- the tax value on ordering for this line item |
3110 |
`tax_value_on_receiving` decimal(28,6) DEFAULT NULL, -- the tax value on receiving for this line item |
3107 |
`discount` float(6,4) default NULL, -- the discount for this line item (%) |
3111 |
`discount` float(6,4) default NULL, -- the discount for this line item (%) |
3108 |
`budget_id` int(11) NOT NULL, -- the fund this order goes against (aqbudgets.budget_id) |
3112 |
`budget_id` int(11) NOT NULL, -- the fund this order goes against (aqbudgets.budget_id) |
3109 |
`budgetgroup_id` int(11) NOT NULL, -- not used? always zero |
3113 |
`budgetgroup_id` int(11) NOT NULL, -- not used? always zero |
3110 |
- |
|
|