|
id
|
|
|
item_id
|
|
|
item_name
|
|
|
unit
|
|
|
department
|
|
|
category
|
|
|
sub_category
|
|
|
brand
|
|
|
buyer
|
|
|
supplier_id
|
|
|
supplier_name
|
|
|
last_grn_date
|
|
|
last_intercompany_date
|
|
|
avg_cost
|
|
|
selling_price
|
|
|
loc_retail_plastic
|
|
|
loc_showroom
|
|
|
loc_wholesale_plastic
|
|
|
loc_warehouse_1
|
|
|
loc_warehouse_2
|
|
|
loc_warehouse_3
|
|
|
loc_central_warehouse
|
|
|
loc_shaharzad_warehouse
|
|
|
loc_global_star
|
|
|
loc_meena_port
|
|
|
loc_delivery_warehouse_bounty
|
|
|
loc_tr_in_progress
|
|
|
stock_qty
|
|
|
stock_value
|
|
|
dmg_loc_s_plastic
|
|
|
dmg_loc_shop
|
|
|
dmg_loc_w1
|
|
|
dmg_loc_w2
|
|
|
dmg_loc_w3
|
|
|
dmg_loc_w4
|
|
|
dmg_stock_qty
|
|
|
avg_sale_day
|
|
|
opening_qty_3m
|
|
|
three_month_sales
|
|
|
intercompany_issue_3m
|
|
|
adj_prctn_phycnt_3m
|
|
|
purchase_3m
|
|
|
opening_qty_2m
|
|
|
two_month_sales
|
|
|
intercompany_issue_2m
|
|
|
adj_prctn_phycnt_2m
|
|
|
purchase_2m
|
|
|
lead_time
|
|
|
lead_time_avg
|
|
|
balance_stock
|
|
|
excess_short_qty
|
|
|
excess_short_value
|
|
|
slow_qty_3m
|
|
|
slow_val_3m
|
|
|
slow_qty_2m
|
|
|
slow_val_2m
|
|
|
is_zero_sale
|
|
|
recent_30
|
|
|
is_oos
|
|
|
is_excess
|
|
|
is_shortage
|
|
|
is_damage
|
|
|
is_slow_3m
|
|
|
is_slow_2m
|
|
|
wh_total_qty
|
|
|
dmg_calc_total_qty
|
|
|
movement_status
|
|
|
overstock_qty
|
|
|
overstock_value
|
|
|
shortage_qty
|
|
|
shortage_value
|
|
|
damage_qty
|
|
|
damage_value
|
|
|
is_transfer_showroom
|
|
|
is_transfer_w2
|
|
