| Name | Description | Type | Additional information |
|---|---|---|---|
| CatalogID |
database reference = oitems.catalogid |
integer |
None. |
| ItemIndexID |
database reference = oitems.orderitemid |
integer |
None. |
| ItemID |
database reference = oitems.itemid |
string |
String length: inclusive between 0 and 150 |
| ItemShipmentID |
database reference = oitems.shipment_id |
integer |
None. |
| ItemQuantity |
database reference = oitems.numitems |
decimal number |
None. |
| ItemWarehouseID |
database reference = oitems.warehouseID |
integer |
None. |
| ItemDescription |
database reference = oitems.itemname |
string |
String length: inclusive between 0 and 65535 |
| ItemUnitPrice |
database reference = oitems.unitprice |
decimal number |
None. |
| ItemWeight |
database reference = oitems.weight |
decimal number |
None. |
| ItemOptionPrice |
database reference = oitems.optionprice |
decimal number |
None. |
| ItemAdditionalField1 |
database reference = oitems.additional_field1 |
string |
String length: inclusive between 0 and 255 |
| ItemAdditionalField2 |
database reference = oitems.additional_field2 |
string |
String length: inclusive between 0 and 255 |
| ItemAdditionalField3 |
database reference = oitems.additional_field3 |
string |
String length: inclusive between 0 and 255 |
| ItemPageAdded |
database reference = oitems.page_added |
string |
String length: inclusive between 0 and 255 |
| ItemAvailability |
database reference = oitems.itemdescription |
string |
String length: inclusive between 0 and 150 |
| ItemDateAdded |
database reference = oitems.date_added |
date |
None. |
| ItemUnitCost |
database reference = oitems.unitcost |
decimal number |
None. |
| ItemUnitStock |
database reference = oitems.unitstock |
decimal number |
None. |
| ItemOptions |
database reference = oitems.options |
string |
String length: inclusive between 0 and 65535 |
| ItemCatalogIDOptions |
database reference = oitems.catalogidoptions |
string |
String length: inclusive between 0 and 255 |
| ItemSerial |
database reference = serials_used.catalogidoptions |
string |
String length: inclusive between 0 and 255 |
| ItemImage1 |
database reference = products.image1 |
string |
String length: inclusive between 0 and 255 |
| ItemImage2 |
database reference = products.image2 |
string |
String length: inclusive between 0 and 255 |
| ItemImage3 |
database reference = products.image3 |
string |
String length: inclusive between 0 and 255 |
| ItemImage4 |
database reference = products.image4 |
string |
String length: inclusive between 0 and 255 |
| ItemWarehouseLocation |
database reference = products.warehouse_location |
string |
String length: inclusive between 0 and 150 |
| ItemWarehouseBin |
database reference = products.warehouse_bin |
string |
String length: inclusive between 0 and 150 |
| ItemWarehouseAisle |
database reference = products.warehouse_aisle |
string |
String length: inclusive between 0 and 150 |
| ItemWarehouseCustom |
database reference = products.warehouse_custom |
string |
String length: inclusive between 0 and 150 |
| RecurringOrderFrequency |
database reference = oitems.recurring_order_frequency |
integer |
None. |