经销商customer
人员employee
费效排名-业代ads_fico_direct_fee_ratio_by_manager_m
勤策月销量上报dwd_report_monthly_sales
全部区域综合费比(战区)ads_fico_work_report_07_org_fee_ratio
数据源
销售sale
当前经销商 dim_customer_table
销售费比-客户ads_fico_sales_fee_ratio_by_cust_m
蜂创开瓶费dwd_terminal_corkage_fee_d
全区域-动销异常客户ads_fico_work_report_01_cust_sales_abnormal
当前产品dim_sku_table_finance_new
费效排名-战区ads_fico_sales_fee_ratio_by_province_org_m
经销商费用月表dws_cust_fee_m
终端terminal
用友BIP销售订单dwd_bip_province_monthly
勤策铺货上报/品牌资产dwd_terminal_assets_report_d
经销、联建、特约商目标达成(精简版)ads_fico_work_report_02_cust_sales_achievement
当前终端dwd_system_waiqin365_store
历史产品dim_product
商效/销售费比
市场/费用mkt
直营费效-终端ads_fico_direct_fee_ratio_by_store_m
直营区域市场费用(干部 )ads_fico_work_report_06_salesman_sales_fee_ratio
直营区域进销存核查ads_fico_work_report_11_cust_sales_stock
直营区域开瓶费异常终端ads_fico_work_report_10_term_corkage_abnormal
DLC 数据仓库
费用expense
勤策窜拍明细dwd_inspect_cuanpai_photo
直营区域综合费比(业代)ads_fico_work_report_09_agent_fee_ratio
费效排名-客户ads_fico_sales_fee_ratio_by_cust_m
全部区域综合费比(干部)ads_fico_work_report_08_cadre_fee_ratio
费效排名-干部ads_fico_sales_fee_ratio_by_salesman_team_m
战区province_org
勤策费用类型dim_qince_expense_type
主数据dim
直营费效-客户ads_fico_direct_fee_ratio_by_customer_m
勤策费用池dwd_metadata_qince_expense_pool_amount_m
终端费用月表dws_terminal_fee_m
勤策活动上报(省区业代联建活动)ads_pr_agent_market_activity_list
经销商销售订单绑赠/买赠/POP产品dwd_province_monthly
费效排名
管理费用dws_fico_manage_fee_person
业代agent
历史终端dwd_terminal_multi_analysis
直营区域市场费用(业代 )ads_fico_work_report_05_agent_sales_fee_ratio
经销商销售订单dwd_province_monthly
干部cadre
勤策拜访记录dwd_system_cusvisit_detail
销售费比-战区ads_fico_sales_fee_ratio_by_province_org_m
直营区域市场费用(战区)ads_fico_work_report_04_org_sales_fee_ratio
销量价格dim_qince_product_price_per_unit_for_sales_v2
费效排名-终端ads_fico_direct_fee_ratio_by_store_m
产品product
价格price
历史经销商dim_customer_table_month
直营费效-战区ads_fico_direct_fee_ratio_by_province_org_m
勤策预实分析dwd_metadata_qince_budget_summary_mf
勤策翻拍明细dwd_inspect_fake_photo
终端销量月表dws_terminal_sales_m
市场/费用域的所有项目,基于这4个月度汇总表构建
YXG-数仓架构-费用现状梳理
直营费效-干部ads_fico_direct_fee_ratio_by_salesman_team_m
财务述职
经销、联建、特约商目标达成(同环比汇总)
U8销售订单dwd_u8_province_monthly
直营区域市场费用(客户 )ads_fico_work_report_03_cust_sales_fee_ratio
活动价格dim_qince_product_price_per_box_for_activity_v2
勤策日销量上报+分销订单dwd_report_day_sales
店效/直营费效
分销dist
勤策活动评价dws_inspect_activity_comment_d
直营费效-业代ads_fico_direct_fee_ratio_by_manager_m
执行execution
勤策直营订单dwd_metadata_direct_order
勤策核销单dwd_metadata_reconciliation_order
销售费比-干部ads_fico_sales_fee_ratio_by_salesman_team_m
BIP退货订单表dwd_bip_sales_return
勤策活动上报+分销订单赠品+退换货赠品dwd_mkt_activity_report_d
勤策费用类型绑定dim_qince_expense_type_bind
主题域dwd/dws
经销、联建、特约商目标达成情况(明细版)
经销商销量月表dws_cust_sales_m
BIP订单表dwd_bip_sales_order
当前人员dim_employee_info
BI 数据应用
历史人员dim_employee_info_month