OrderItems

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	Numeric ID of this product within this order.
ProductId	Integer	False	Numeric ID of the product.
CustomSKU	String	False	User defined product code/stock keeping unit (SKU).
OrderId	Integer	False	Numeric ID of the associated order.
Name	String	False	The product name.
PriceExTax	Decimal	False	The price of the product, excluding tax.
PriceIncTax	Decimal	False	The price of the product, including tax.
QuantityOrdered	Integer	False	Quantity of the product ordered.
QuantityShipped	Integer	True	Quantity of the product shipped.
TotalExtax	Decimal	True	Total base price, excluding tax.
TotalIncTax	Decimal	True	Total base price, including tax.
IsRefunded	Boolean	True	Whether the product has been refunded.
ExternalId	Integer	False	ID of the order in another system.
AppliedDiscounts	String	False	Array of objects containing discounts applied to the product.

Pseudo-Columns

Pseudo column fields are used to enable the user to INSERT Fields that are non-readable but required during creation of new records.

Name	Type	Description
LinkedOrderOptions	String	Column for the aggregate table name holding option values.