| Name | Description | Type | Additional information |
|---|---|---|---|
| prodID | integer |
None. |
|
| prod_code | string |
None. |
|
| prod_desc | string |
None. |
|
| prod_descLong | string |
None. |
|
| prod_kind | string |
None. |
|
| UOM | string |
None. |
|
| UOM2 | string |
None. |
|
| UOM3 | string |
None. |
|
| UOM4 | string |
None. |
|
| UOM5 | string |
None. |
|
| packSize | integer |
None. |
|
| packSizeOneOver | byte |
None. |
|
| unitWeightUOM | string |
None. |
|
| unitWeight | decimal number |
None. |
|
| packWeight | decimal number |
None. |
|
| prod_category | string |
None. |
|
| prod_type | string |
None. |
|
| warehouseSeparation | string |
None. |
|
| prod_status | string |
None. |
|
| inventoryOnHand | decimal number |
None. |
|
| created | date |
None. |
|
| created_adminID | integer |
None. |
|
| updated | date |
None. |
|
| updated_adminID | integer |
None. |
|
| remark | string |
None. |
|
| deleted | date |
None. |
|
| deleted_adminID | integer |
None. |
|
| salesAccount | string |
None. |
|
| prod_make | string |
None. |
|
| production_group | string |
None. |
|
| production_dept | string |
None. |
|
| vendorID | integer |
None. |
|
| vendorNo | string |
None. |
|
| allowForSell | byte |
None. |
|
| prodID_parent | integer |
None. |
|
| willExpireDays | integer |
None. |
|
| UOM2_base | decimal number |
None. |
|
| UOM2_fact | decimal number |
None. |
|
| UOM3_base | decimal number |
None. |
|
| UOM3_fact | decimal number |
None. |
|
| UOM4_base | decimal number |
None. |
|
| UOM4_fact | decimal number |
None. |
|
| UOM5_base | decimal number |
None. |
|
| UOM5_fact | decimal number |
None. |
|
| UOM3b | string |
None. |
|
| UOM4b | string |
None. |
|
| UOM5b | string |
None. |
|
| allowWebOrder | byte |
None. |
|
| prod_code_old | string |
None. |
|
| qty_onhand | decimal number |
None. |
|
| qty_pending_close | decimal number |
None. |
|
| qty_onhand_tmp | decimal number |
None. |
|
| currency | string |
None. |
|
| cost | decimal number |
None. |
|
| leadDays | integer |
None. |
|
| isCatchWt | byte |
None. |
|
| isQty | byte |
None. |
|
| wt_onhand | decimal number |
None. |
|
| qty_min | decimal number |
None. |
|
| qty_min_order | decimal number |
None. |
|
| noShippingDay | string |
None. |
|
| brand | string |
None. |
|
| packSizeStr | string |
None. |
|
| UOM_toParent | decimal number |
None. |
|
| UOM2_toParent | decimal number |
None. |
|
| UOM3_toParent | decimal number |
None. |
|
| UOM4_toParent | decimal number |
None. |
|
| UOM5_toParent | decimal number |
None. |
|
| msgAlert | string |
None. |
|
| ingredients | string |
None. |
|
| nutritionImage | string |
None. |
|
| handlingInstruction | string |
None. |
|
| bakingInstruction | string |
None. |
|
| preheatInstruction | string |
None. |
|
| marketplace | string |
None. |
|
| isNatural | byte |
None. |
|
| isFlourless | byte |
None. |
|
| isSealedFresh | byte |
None. |
|
| isFrozen | byte |
None. |
|
| isGlutenFree | byte |
None. |
|
| isNoSugarAdded | byte |
None. |
|
| isTransFatFree | byte |
None. |
|
| isSugerFree | byte |
None. |
|
| qty_max | decimal number |
None. |
|
| qty_max_dist | decimal number |
None. |
|
| prod_descMobile | string |
None. |
|
| allowMobileOrder | byte |
None. |
|
| nonInventory | byte |
None. |
|
| qty_webStock | decimal number |
None. |
|
| labelIngredient | string |
None. |