LineItems Table
The LineItems table in the transactions database contains information about line items that are associated with completed orders.
The following table describes the columns in the LineItems table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
LineItemId |
uniqueidentifier |
no |
The ID of the line item. This is the primary key. |
OrderFormId |
uniqueidentifier |
no |
The ID of the order form that is associated with the line item. This is a foreign key. |
OrderGroupId |
uniqueidentifier |
no |
The ID of the order group that is associated with the line item. |
ProductCatalog |
nvarchar(255) |
no |
The name of the product catalog that is associated with the line item. |
ProductCategory |
nvarchar(255) |
no |
The name of the product category that is associated with the line item. |
ProductId |
nvarchar(255) |
no |
The ID of the product. |
ProductVariantId |
nvarchar(255) |
yes |
The variant ID of the product. |
Quantity |
money |
no |
The quantity of the product. |
PlacedPrice |
money |
no |
The unit price of the line item at the time that it was added to the order group. |
ListPrice |
money |
no |
The list price of the line item. |
LineItemDiscountAmount |
money |
no |
The sum of all line item-based discounts for the line item. |
OrderLevelDiscountAmount |
money |
no |
The sum of all line order level discounts for the line item. |
ShippingAddressId |
nvarchar(50) |
no |
The ID of the shipping address that is associated with the line item. |
ShippingMethodName |
nvarchar(128) |
yes |
The name of the shipping method that will be used to ship this line item. |
ShippingMethodId |
uniqueidentifier |
no |
The ID of the shipping method that will be used to ship this line item. |
ExtendedPrice |
money |
no |
The price for the quantity of this line item minus line item discounts and order level discounts. |
Created |
datetime |
no |
The date the line item was created. |
LastModified |
datetime |
no |
The date the line item was last modified. |
Description |
nvarchar(255) |
yes |
A description of the line item. |
Status |
nvarchar(64) |
yes |
The status of the line item. |
DisplayName |
nvarchar(128) |
yes |
The text to display to the user for the line item. |
AllowBackordersAndPreorders |
bit |
no |
Whether the shopper permits backorders and preorders. |
InStockQuantity |
Money |
no |
The quantity of the line item that is in stock. |
PreorderQuantity |
Money |
no |
The quantity at which the line item should be pre-ordered. |
BackorderQuantity |
money |
no |
The number of the line item that have been backordered. |
InventoryCondition |
int |
no |
Whether the line item is back-ordered, in stock, out of stock, or pre-ordered. |
ModifiedBy |
nvarchar(64) |
no |
The user ID of the person who last modified the line item. |
LineItemOrdering |
timestamp |
yes |
The time at which the line item was added to the order. |
MarshalledData |
image |
yes |
A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties. |