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