|
id
|
|
|
item_id
|
|
|
item_name
|
|
|
item_part_no
|
|
|
item_material
|
|
|
item_drawing
|
|
|
heat_spec
|
|
|
surface
|
|
|
net_weight
|
|
|
item_spec
|
|
|
item_model
|
|
|
item_brand
|
|
|
class_id
|
|
|
class_code
|
|
|
item_type
|
|
|
unit
|
|
|
unit_purchase
|
|
|
unit_sales
|
|
|
conversion_rate
|
|
|
cost_price
|
|
|
sales_price
|
|
|
last_purchase_price
|
|
|
current_stock
|
|
|
min_stock
|
|
|
max_stock
|
|
|
safe_stock
|
|
|
warehouse_location
|
|
|
shelf_no
|
|
|
main_vendor_id
|
|
|
main_vendor_name
|
|
|
quality_level
|
|
|
quality_status
|
|
|
item_sta
|
|
|
is_active
|
|
|
has_bom
|
|
|
parent_item_id
|
|
|
parent_item_name
|
|
|
bom_level
|
|
|
item_desc
|
|
|
remark
|
|
|
item_image
|
|
|
create_date
|
|
|
create_by
|
|
|
last_modify_date
|
|
|
last_modify_by
|
|
|
ext_field1
|
|
|
ext_field2
|
|
|
ext_field3
|
|
