| Name | Description | Type | Additional information |
|---|---|---|---|
| abc_rating | string |
None. |
|
| alt_item | string |
None. |
|
| alt_item_active | byte |
None. |
|
| bom_capable | byte |
None. |
|
| bom_type | string |
None. |
|
| bar_code_ratio | integer |
None. |
|
| base_cost | decimal number |
None. |
|
| callback_time | integer |
None. |
|
| callback_unit | string |
None. |
|
| catalog_price | decimal number |
None. |
|
| prod_group | string |
None. |
|
| code39 | string |
None. |
|
| comm_code | string |
None. |
|
| comm_paid | byte |
None. |
|
| configurable | byte |
None. |
|
| cost_change_date | date |
None. |
|
| cost_override | byte |
None. |
|
| cube | decimal number |
None. |
|
| cube_uom | string |
None. |
|
| cust_nbr | integer |
None. |
|
| dang_goods | byte |
None. |
|
| fixed_pricing | byte |
None. |
|
| height | decimal number |
None. |
|
| inactive | byte |
None. |
|
| is_callback_item | byte |
None. |
|
| is_roy_pct | byte |
None. |
|
| item_code | string |
None. |
|
| item_desc1 | string |
None. |
|
| item_desc2 | string |
None. |
|
| item_desc3 | string |
None. |
|
| last_cost | decimal number |
None. |
|
| last_cost_date | date |
None. |
|
| last_mod_date | date |
None. |
|
| last_price | decimal number |
None. |
|
| last_recv_nbr | integer |
None. |
|
| last_so_nbr | integer |
None. |
|
| layer | integer |
None. |
|
| length | decimal number |
None. |
|
| length_uom | string |
None. |
|
| lowest_level | byte |
None. |
|
| msds | byte |
None. |
|
| mfr_id | integer |
None. |
|
| min_is_mult | byte |
None. |
|
| min_sell_qty | decimal number |
None. |
|
| case_pack | string |
None. |
|
| percent1 | decimal number |
None. |
|
| percent2 | decimal number |
None. |
|
| percent3 | decimal number |
None. |
|
| percent4 | decimal number |
None. |
|
| percent5 | decimal number |
None. |
|
| percent6 | decimal number |
None. |
|
| percent7 | decimal number |
None. |
|
| piece_unit | string |
None. |
|
| prev_cost | decimal number |
None. |
|
| base_price | decimal number |
None. |
|
| price1 | decimal number |
None. |
|
| price2 | decimal number |
None. |
|
| price3 | decimal number |
None. |
|
| price4 | decimal number |
None. |
|
| price5 | decimal number |
None. |
|
| price6 | decimal number |
None. |
|
| price7 | decimal number |
None. |
|
| price_by_vol | byte |
None. |
|
| price_unit | string |
None. |
|
| pricing_type | byte |
None. |
|
| prime_vendor | integer |
None. |
|
| prime_ware | integer |
None. |
|
| prod_cat | string |
None. |
|
| prod_type | integer |
None. |
|
| on_hand_qty | decimal number |
None. |
|
| routing_nbr | integer |
None. |
|
| roy_amt | decimal number |
None. |
|
| roy_pct | integer |
None. |
|
| roy_ven_nbr | integer |
None. |
|
| royalty_flag | byte |
None. |
|
| s_c_c_code | string |
None. |
|
| inv_tax_class1 | string |
None. |
|
| inv_tax_class2 | string |
None. |
|
| inv_tax_class3 | string |
None. |
|
| qty_unit | string |
None. |
|
| skid | decimal number |
None. |
|
| std_cost | decimal number |
None. |
|
| sugg_ret_price | decimal number |
None. |
|
| on_hand_value | decimal number |
None. |
|
| tracking | character |
None. |
|
| upc_code | string |
None. |
|
| upc_edi_code235 | string |
None. |
|
| use_alt_if_in_stock | byte |
None. |
|
| volume1 | decimal number |
None. |
|
| volume2 | decimal number |
None. |
|
| volume3 | decimal number |
None. |
|
| volume4 | decimal number |
None. |
|
| volume5 | decimal number |
None. |
|
| volume6 | decimal number |
None. |
|
| volume7 | decimal number |
None. |
|
| warranty_per1 | integer |
None. |
|
| warranty_per2 | integer |
None. |
|
| warr_unit | string |
None. |
|
| web_catalog | byte |
None. |
|
| weight | decimal number |
None. |
|
| weight_uom | string |
None. |
|
| width | decimal number |
None. |
|
| gl_cat | string |
None. |
|
| prod_class | integer |
None. |
|
| catch_weight | byte |
None. |
|
| is_style_code | byte |
None. |
|
| size_run_code | string |
None. |
|
| color_attr_code | string |
None. |
|
| create_date | date |
None. |
|
| last_mod_by | string |
None. |
|
| created_by | string |
None. |
|
| country_origin | string |
None. |
|
| notes | string |
None. |
|
| inv_id | integer |
None. |
|
| prod_clmbk | decimal number |
None. |
|
| apply_prod_clmbk | byte |
None. |
|
| hts_code | string |
None. |
|
| gl_cat_id | integer |
None. |
|
| inv_group_id | integer |
None. |
|
| features | string |
None. |
|
| rental | byte |
None. |
|
| disp_desc2_po | byte |
None. |
|
| disp_desc3_ps | byte |
None. |
|
| disp_desc2_ps | byte |
None. |
|
| disp_desc3_po | byte |
None. |
|
| disp_feature_po | byte |
None. |
|
| disp_feature_ps | byte |
None. |
|
| comment_item | byte |
None. |
|
| eco_code | string |
None. |
|
| mat_property | string |
None. |
|
| net_weight | decimal number |
None. |
|
| min_ord_qty | decimal number |
None. |
|
| temp_stock | byte |
None. |
|
| is_rental | byte |
None. |
|
| create_user | integer |
None. |
|
| deal_enable | byte |
None. |
|
| deal_price | decimal number |
None. |
|
| deal_start_date | date |
None. |
|
| deal_end_date | date |
None. |
|
| orig_vendor | integer |
None. |
|
| pre_def_note_nbr | integer |
None. |
|
| case_pack_qty | integer |
None. |
|
| purch_disable | byte |
None. |
|
| layer_disable | byte |
None. |
|
| zero_cost_ok | byte |
None. |
|
| is_labor_item | byte |
None. |
|
| ext_scc_code | string |
None. |
|
| aux_scc_code | string |
None. |
|
| ext_conv_qty | integer |
None. |
|
| bar_code_type | integer |
None. |
|
| unit | string |
None. |
|
| conv_factor | decimal number |
None. |