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 |