ads_sales_n_inventory_monitor_pt_e
2025-07-02 15:17:38 0 举报AI智能生成
西铂金存货监控
作者其他创作
大纲/内容
差异：sales_difference
Actual_Summary_Table_sum（实际）
Group By：Actual_Summary_Table（实际汇总表）
inventory_transfer_detail（存货扫货调行实际）
dws_inventory_transfer_detail
Inner Join：dim_branch_order_type
Inner Join：dim_barcode_requirement_type_classify
Inner Join：dim_branch
Left Join：dim_mould_master
Left Join：dws_mould_master_label_df
Union：dws_inventory_distribution_branch_count_mi（分店家次信息）
Union：actual_sales_performance（销售实际）
sales_daily_detail_year_month（其实到天）
实际销售：Group By：sales_daily_detail
dws_sales_daily_detail
INNER JOIN dim_day
INNER JOIN dim_branch
Left Join：inventory_central_wh_qty_mi
Group By：dws_inventory_central_wh_qty_mi（dws存货中央真实可用数）
Left Join：dim_stock_type_rename_daily_coefficient（日系数）
Left Join：dim_mould_master
Left Join：dws_mould_master_label_df
Left Join :sales_target_qty_amount_sum（预计）
Group By：sales_target_qty_amount
dws_sales_stock_type_target_qty_mf（预计销售件数）
Union：dws_sales_stock_type_target_amount_mf（预计销售金额）
Union：dws_inventory_distribution_predicted_detail_mf（预计出货量）
Left Join：dim_stock_type_rename_daily_coefficient（日系数）
Union：dws_inventory_distribution_branch_count_mi（分店家次）
实际汇总：Actual_Summary_Table
inventory_transfer_detail（存货扫货调行实际）
dws_inventory_transfer_detail
INNER JOIN dim_branch_order_type
INNER JOIN dim_barcode_requirement_type_classify
INNER JOIN dim_branch
LEFT JOIN dim_mould_master
LEFT JOIN dws_mould_master_label_df
Union：dws_inventory_distribution_branch_count_mi（分店家次）
Union：actual_sales_performance（销售实际）
sales_daily_detail_year_month（其实到天）
实际销售：Group By：sales_daily_detail
dws_sales_daily_detail
INNER JOIN dim_day
INNER JOIN dim_branch
Left Join：inventory_central_wh_qty_mi
Group By：dws_inventory_central_wh_qty_mi（dws存货中央真实可用数）
Left Join：dim_stock_type_rename_daily_coefficient（日系数）
LEFT JOIN dim_mould_master
LEFT JOIN dws_mould_master_label_df
4.4需求测算：Demand_Estimation
dws_inventory_stock_type_demand_forecast_kpi_df（自定义货类需求测算）
LEFT JOIN dim_mould_master
LEFT JOIN dim_mould_define_mapping
LEFT JOIN dws_mould_master_label_df
UNION：dws_inventory_stock_type_supply_chain_kpi_df（自定义货类供应链情况）
LEFT JOIN dim_mould_master
LEFT JOIN dim_mould_define_mapping
LEFT JOIN dws_mould_master_label_df
4.3供应链情况：Supply_Chain_Status
dws_inventory_stock_type_supply_chain_kpi_df（自定义货类供应链情况）
LEFT JOIN dim_mould_master
LEFT JOIN dim_mould_define_mapping
LEFT JOIN dws_mould_master_label_df
UNION：dws_inventory_stock_type_sum_df（定义货类存货汇总数）
LEFT JOIN dim_mould_master
LEFT JOIN dim_mould_define_mapping
LEFT JOIN dws_mould_master_label_df
4.2铺货情况：Product_Distribution_Status
dws_inventory_stock_type_distribution_kpi_df（自定义货类铺货情况）
LEFT JOIN dim_mould_master
LEFT JOIN dim_mould_define_mapping
LEFT JOIN dws_mould_master_label_df
UNION：dws_inventory_sales_stock_type_kpi_df（自定义货类存销分析）
INNER JOIN dim_branch
LEFT JOIN dim_mould_master
LEFT JOIN dim_mould_define_mapping
LEFT JOIN dws_mould_master_label_df
4.1存销情况：inventory_sales_stock_type_kpi_df41
inventory_sales_stock_type_kpi_df
dws_inventory_sales_stock_type_kpi_df（自定义货类存销分析）
INNER JOIN dim_branch
LEFT JOIN dws_mould_master_label_df
LEFT JOIN dim_mould_master
LEFT JOIN dim_mould_define_mapping
LEFT JOIN dws_mould_master_label_df
0 条评论
下一页
