| Name | Description | Type | Additional information |
|---|---|---|---|
| CatalogID |
database reference = oitems.catalogid |
integer |
None. |
| CartItemID |
database reference = oitems.orderitemid |
integer |
None. |
| ItemID |
database reference = oitems.itemid |
string |
String length: inclusive between 0 and 150 |
| ItemQuantity |
database reference = oitems.numitems |
decimal number |
None. |
| ItemDescription |
database reference = oitems.itemname |
string |
String length: inclusive between 0 and 65535 |
| ItemUnitPrice |
database reference = oitems.unitprice |
decimal number |
None. |
| ItemOptionPrice |
database reference = oitems.optionprice |
decimal number |
None. |
| ItemDateAdded |
database reference = oitems.date_added |
date |
None. |
| ItemImage1 |
database reference = products.image1 |
string |
String length: inclusive between 0 and 255 |