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. |