|
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.
|