Skip to content
Log in

OrderItem Object Reference

On this page

Overview

Property Value
API Name OrderItem
Label OrderItem
Plural Label OrderItems
Type Standard Object

Fields

Field Label API Name Type Required Description
Assisted By User s_c__Assisted_By_User_Id__c Lookup (User) No The User who assisted with adding this item to the order.
Bundle Lead Item s_c__Bundle_Lead_Item_Id__c Lookup (OrderItem) No For a v2 Product Bundle, the lead (anchor) OrderProduct this component item belongs to. Used to group bundle component order products under their lead item.
Cancelled At s_c__Cancelled_At__c DateTime No When this order item was cancelled.
Cancelled By User s_c__Cancelled_By_User_Id__c Lookup (User) No The User who cancelled this order item.
Delivery Day s_c__Delivery_Day__c Picklist No The selected delivery day of the week for this Order Item.
Delivery Start Date s_c__Delivery_Start_Date__c Date No The selected delivery start date for this Order Item.
Delivery Time s_c__Delivery_Time__c Text(255) No The selected delivery time slot for this Order Item.
Delivery Window Debug s_c__Delivery_Window_Debug__c Text(255) No Debugging information for the corresponding delivery window of this Order Item.
Delivery Window s_c__Delivery_Window_Id__c Lookup (s_c__Delivery_Window__c) No The selected Delivery Window for this Order Item.
Deposit Amount s_c__Deposit_Amount__c Currency(18,2) No The deposit charged during checkout (if any)
Deposit Payment Mode s_c__Deposit_Payment_Mode__c Picklist No The deposit payment mode for this Order Product.
Deposit Percentage s_c__Deposit_Percentage__c Number(18,2) No The deposit percentage for this Order Product.
Deposit Points s_c__Deposit_Points__c Number(18,0) No The deposit points amount charged during checkout (if any).
Earn Points Amount s_c__Earn_Points_Amount__c Number(18,0) No The number of points earned per quantity with this Order Item.
External Tax Detail s_c__External_Tax_Detail__c LongTextArea(32768) No Per-jurisdiction tax breakdown from an external tax provider (e.g. Avalara). Stored as a JSON array of objects with name, rate, and amount fields.
Is List Price Tax Inclusive? s_c__Is_List_Price_Tax_Inclusive__c Formula (Checkbox) No For System/Internal Use Only - sourced from associated PricebookEntry for price book tax pricing
Is Restricted Product? s_c__Is_Restricted_Product__c Formula (Checkbox) No For Internal system use
Is Store List Price Tax Inclusive? s_c__Is_Store_List_Price_Tax_Inclusive__c Formula (Checkbox) No For System/Internal Use Only - sourced from associated Order.Store__c for store tax pricing
Linked Order Product s_c__Linked_Order_Item_Id__c Lookup (OrderItem) No The related OrderProduct this item is linked to.
Linked Order Product Link Type s_c__Linked_Order_Item_Link_Type__c Picklist No The type of relationship between this item and its linked OrderProduct (if any).
Linked Order Product Reason s_c__Linked_Order_Item_Reason__c LongTextArea(1024) No The reason this item is linked to another OrderProduct (e.g. the reason the item was returned).
Notes s_c__Notes__c LongTextArea(10000) No Optional notes for this Order Item, copied from the Cart Item at the Point of Sale when the order is created.
Order Checkout Step s_c__Order_Checkout_Step__c Formula (Text) No For System/Internal Use Only
Points Amount s_c__Points_Amount__c Number(18,0) No The number of points used per quantity for purchasing this Order Item.
Price Manually Updated s_c__Price_Manually_Updated__c Checkbox No For System/Internal use only. Used in conjuntion with tax calculator and for product prices WITHOUT tax to avoid deducting the existing UnitPrice tax from the UnitPrice and simply amend the new calculated to the Unit Price. Via OrderItem trigger this is set to true if its a product price without tax and either UnitPrice or Quantity has changed. See OrderItemHelper.clearTaxAmount for further details.
Product Component s_c__Product_Component_Id__c Lookup (s_c__Product_Component__c) No The product component associated with this Order Product.
Shipment s_c__Shipment_Id__c Lookup (s_c__Shipment__c) No This represents the Shipment__c that this order item is part of
Stock Level s_c__Stock_Level_Id__c Lookup (s_c__Stock_Level__c) No This represents the Stock_Level__c that is linked to this OrderItem’s product
Subscription s_c__Subscription_Id__c Lookup (s_c__Subscription__c) No If the Order was created by a Subscription, this will be the source Subscription for this OrderItem
Subscription Term Count s_c__Subscription_Term_Count__c Number(18,0) No The subscription term count for the OrderItem.
Tax Amount s_c__Tax_Amount__c Currency(18,4) No This is the Total Tax calculated for this Order Item. If no Tax__c is configured for the store’s zone this value will be 0.
[Deprecated] Tax s_c__Tax__c Number(18,2) No [Deprecated] Use Tax_Amount__c instead
Total of Discounts s_c__Total_of_Discounts__c Currency(18,2) No This is the Total Discount calculated for this Order Item. This value will be 0 if there is no discount present.
Transaction Discount s_c__Transaction_Discount__c Number(18,2) No The order-level discount that was applied to this OrderItem (if any).
Unit Discount Points s_c__Unit_Discount_Points__c Number(18,0) No The points twin of Unit Discount: the per-unit discount expressed in points that was applied to this OrderItem (if any).
Unit Discount s_c__Unit_Discount__c Number(18,2) No The unit-level discount that was applied to this OrderItem (if any).
Unit Points Adjustment s_c__Unit_Points_Adjustment__c Number(18,2) No The unit-level points adjustment that was applied to this OrderItem (if any).
Unit Price Adjustment s_c__Unit_Price_Adjustment__c Number(18,2) No The unit-level price adjustment discount that was applied to this OrderItem (if any).
StoreConnect External ID s_c__sC_Id__c Text(36) No StoreConnect External ID, do not modify in Salesforce

Relationships

Field Type Related Object Relationship Name
s_c__Assisted_By_User_Id__c Lookup User Order_Item_Assisted_By_User
s_c__Bundle_Lead_Item_Id__c Lookup OrderItem Bundle_Component_Order_Products
s_c__Cancelled_By_User_Id__c Lookup User Order_Item_Cancelled_By_User
s_c__Delivery_Window_Id__c Lookup s_c__Delivery_Window__c Order_Products
s_c__Linked_Order_Item_Id__c Lookup OrderItem Linked_Order_Products
s_c__Product_Component_Id__c Lookup s_c__Product_Component__c Order_Product_Product_Component
s_c__Shipment_Id__c Lookup s_c__Shipment__c OrderItems
s_c__Stock_Level_Id__c Lookup s_c__Stock_Level__c Order_Items
s_c__Subscription_Id__c Lookup s_c__Subscription__c OrderItem_Subscription

Referenced by

These objects hold a lookup or master-detail relationship to OrderItem (OrderItem). Where the referring record exists to join things together, Also links to shows what it connects this object to.

Object Field Type Relationship Name Also links to
s_c__Account_Points_Ledger__c s_c__Order_Item_Id__c Lookup Account_Points_Ledger_Order_Items
Asset s_c__Order_Line_Item_Id__c Lookup OrderLineItem_Asset s_c__Stock_Level__c, s_c__Stock_Location__c
s_c__Booking__c s_c__Order_Item_Id__c Lookup Bookings
s_c__Form_Submission__c s_c__Order_Item_Id__c Lookup Form_Submission_Order_Item
s_c__Fulfillment_Item__c s_c__Order_Item_Id__c Lookup Fulfillment_Items Asset, s_c__Shipment__c
s_c__Order_Item_Reward__c s_c__Order_Item_Id__c Lookup Order_Item_Rewards_OrderItem s_c__Reward__c
s_c__Order_Items_Taxes__c s_c__Order_Item_Id__c Lookup Order_Items_Taxes_Order_Item s_c__Fulfillment_Item__c, s_c__Tax__c
OrderItem s_c__Bundle_Lead_Item_Id__c Lookup Bundle_Component_Order_Products
OrderItem s_c__Linked_Order_Item_Id__c Lookup Linked_Order_Products
s_c__Payment_Item__c s_c__Order_Item_Id__c Lookup Payment_Item_Order_Item s_c__Payment__c
s_c__Permitted_Restricted_Item__c s_c__Order_Item_Id__c Lookup PermittedRestrictedItems_OrderProducts s_c__Permitted_Restricted_Product__c
s_c__Voucher__c s_c__Order_Item_Id__c Lookup Voucher_OrderItem

Was this article helpful?

Was this article helpful?