| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| PERCENT |
decimal(7, 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 |
yes |
|
XML Data for Sales Order Item |
| PRICINGSTRUCTURE |
nvarchar(13) (Computed) |
yes |
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 |
yes |
|
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 |
yes |
|
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) |
yes |
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 |
money (Computed) |
yes |
convert(money, case PRICINGSTRUCTURECODE when 0 then QUANTITY * PRICE else FLATRATEPRICE end ) |
|