Start>order_prices
Amounts charged for order.
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Description |
|---|---|---|---|---|---|---|---|
  |
order_id | bigint | 8 | 19 | 0 | True | Order ID for charges |
 |
processed_at | datetime | 8 | 23 | 3 | True | Datetime order was processed |
| updated_at | datetime | 8 | 23 | 3 | True | Order last updated datetime | |
| current_total_discounts | money | 8 | 19 | 4 | True | Total discount including refunds, adjustments and returns | |
| current_total_price | money | 8 | 19 | 4 | True | Total price of order including refunds, adjustments and returns | |
| current_subtotal_price | money | 8 | 19 | 4 | True | Price after discounts with refunds, adjustments and returns | |
| current_total_tax | money | 8 | 19 | 4 | True | Total tax including refunds, adjustments and returns | |
| subtotal_price | money | 8 | 19 | 4 | True | Price after discounts, not including tax, shipping, duties, tips | |
| total_discounts | money | 8 | 19 | 4 | True | Total discounts applied | |
| total_line_items_price | money | 8 | 19 | 4 | True | Sum of all line item prices | |
| total_price | money | 8 | 19 | 4 | True | Sum of line item pricing, discounts, shipping, taxes and tips | |
| total_tax | money | 8 | 19 | 4 | True | Total amount of tax charged | |
| total_shipping_price | money | 8 | 19 | 4 | True | Price charged for shipping, excluding discounts & returns | |
| taxes_included | bit | 1 | 1 | 0 | True | If taxes are included in subtotal |
| Key | Name | Columns | Unique |
|---|---|---|---|
|
PK_OrderPrices_order_id | order_id | True |
| UK_OrderPrices | processed_at | False |