This article outlines the database structure for the MMv4 dec_order_item database table.
Note: This database table is used to store information about declined orders.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- order_id
Reference to the order.id that this item is associated with.
int(10) | unsigned | indexed
- pid
Reference to the product.id that this item is associated with.
int(10) | unsigned | indexed
- qty
The number of this product contained in the order.
int(10) | unsigned | indexed
- price
The price actually paid for the product.
double(16,2)
- create_date
The date that this database item was created.
int(10) | unsigned | indexed
- ship_date
The date that the item was shipped.
int(10) | unsigned | indexed
- ship_method_id
The system ID of the shipping method associated with this order.
int(10) | unsigned | indexed
- gift_wrap
The item's gift-wrap status. 0 = not gift-wrapped; other value = gift-wrapped
int(10) | unsigned | Value: 0/timestamp | indexed
- event_id
The system ID of the store event this item is associated with.
int(10) | unsigned | indexed
- cogs
The COGS of a single unit of this product.
double(16,2)
- msrp
The MSRP of the product.
double(16,2)
- price_adj
The difference between the product's price in the store and the amount the customer paid for this item.
double(16,2) | indexed
|