Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TYPECODE tinyint   Default = 0 The type of item the sales order item represents.
 DESCRIPTION nvarchar(255)   Default = '' The description of the sales order item.
 PRICE money   Default = 0 The price of a single item of the sales order item.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 PERCENT decimal(20, 4)   Default = 0 The percent of either a tax or fee.
 QUANTITY decimal(20, 4)   Default = 0 The number of items for the sales order item.
 PRICINGSTRUCTURECODE tinyint   Default = 0 Indicates the pricing structure for the sales order item.
 FLATRATEPRICE money   Default = 0 The flat rate price of the sales order item.
 DATA xml XML Data for Sales Order Item
 PRICINGSTRUCTURE nvarchar(13) (Computed) CASE [PRICINGSTRUCTURECODE] WHEN 0 THEN N'Per quantity' WHEN 1 THEN N'Flat rate' WHEN 2 THEN N'Override rate' END Provides a translation for the 'PRICINGSTRUCTURECODE' field.
 OPTIONS xml The set of options available in the cart for a particular item.
 CALLBACKURL nvarchar(255)   Default = '' The action URL of the sales order item.
 SYSTEMTYPENAME nvarchar(255)   Default = '' The namespaced type name of the sales order item.
 ASSEMBLYNAME nvarchar(255)   Default = '' The name of the assembly that handles the sales order item.
 ATTRIBUTES xml The set of attributes to display for a sales order item.
 CATEGORYNAME nvarchar(255)   Default = '' The category name of the item.
 EXPIREDCALLBACKURL nvarchar(255)   Default = '' The action URL of the sales order item once it has expired.
 ACKNOWLEDGEMENT nvarchar(max)   Default = '' Acknowledgement block's HTML
 TYPE nvarchar(40) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Ticket' WHEN 1 THEN N'Membership' WHEN 2 THEN N'Donation' WHEN 3 THEN N'Fee' WHEN 4 THEN N'Tax' WHEN 5 THEN N'Discount' WHEN 6 THEN N'Event Registration' WHEN 7 THEN N'Facility' WHEN 8 THEN N'Itinerary Supply/Equipment Resource' WHEN 9 THEN N'Itinerary Item Supply/Equipment Resource' WHEN 10 THEN N'Itinerary Staffing Resource' WHEN 11 THEN N'Itinerary Item Staffing Resource' WHEN 12 THEN N'Sponsorship' WHEN 13 THEN N'Membership Promotion' WHEN 14 THEN N'Merchandise' WHEN 15 THEN N'Student Payment (EE7)' WHEN 16 THEN N'Membership add-on' WHEN 17 THEN N'Custom Form' END
 TOTAL decimal(38, 6) (Computed) CASE PRICINGSTRUCTURECODE WHEN 0 THEN QUANTITY * PRICE ELSE FLATRATEPRICE END

Foreign Key Field Type Null Notes Description
 SALESORDERID uniqueidentifier   SALESORDER.ID The ID of the sales order the order item belongs to.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_SALESORDERITEM_DATEADDED DATEADDED    
 IX_SALESORDERITEM_DATECHANGED DATECHANGED      
 IX_SALESORDERITEM_SALESORDERID SALESORDERID      
 PK_SALESORDERITEM ID  

Trigger Name Description
 TR_SALESORDERITEM_AUDIT_UPDATE
 TR_SALESORDERITEM_AUDIT_DELETE

Referenced by Field
 CREDITITEM_EXT SALESORDERITEMID
 ITINERARYITEMLOCATION SALESORDERITEMID
 ORDERPAYMENTSPLIT SALESORDERITEMID
 SALESORDERITEMDONATION ID
 SALESORDERITEMEVENTREGISTRATION ID
 SALESORDERITEMFACILITY ID
 SALESORDERITEMFEE ID
 SALESORDERITEMFEE SALESORDERITEMID
 SALESORDERITEMGROUP ID
 SALESORDERITEMITEMDISCOUNT SALESORDERITEMID
 SALESORDERITEMITINERARYITEMRESOURCE SALESORDERITEMID
 SALESORDERITEMITINERARYITEMSTAFFRESOURCE SALESORDERITEMID
 SALESORDERITEMITINERARYRESOURCE SALESORDERITEMID
 SALESORDERITEMITINERARYSTAFFRESOURCE SALESORDERITEMID
 SALESORDERITEMMEMBERSHIP ID
 SALESORDERITEMMEMBERSHIPADDON ID
 SALESORDERITEMMEMBERSHIPITEMPROMOTION SALESORDERITEMID
 SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEM APPLIEDSALESORDERITEMID
 SALESORDERITEMMEMBERSHIPPROMO ID
 SALESORDERITEMMERCHANDISE ID
 SALESORDERITEMORDERDISCOUNT ID
 SALESORDERITEMORDERDISCOUNTDETAIL SALESORDERITEMID
 SALESORDERITEMRE7DONATION ID
 SALESORDERITEMREVENUESCHEDULE ID
 SALESORDERITEMSPONSORSHIP ID
 SALESORDERITEMTAX SALESORDERITEMID
 SALESORDERITEMTAX TAXITEMID
 SALESORDERITEMTICKET ID
 SALESORDERNOTE SALESORDERITEMID
 SALESORDERRESERVEDITEM ID

Entity-Relationship diagram of this table (CREDITITEM-SALESORDERITEMMEMBERSHIPITEMPROMOTIONAPPLIEDITEM)
Entity-Relationship diagram of this table (SALESORDERITEMMEMBERSHIPPROMO-SALESORDERRESERVEDITEM)