财务表关系-old
2024-12-24 13:52:01 0 举报
遥望网络
作者其他创作
大纲/内容
ods.live_zhubo_platform_account_df
app.finance_order_extend_detail_df
app.finance_ship_detail_df
dim.live_zhubo_user_info_df
dept_id
sync.app_finance_goods_stat_1_df
dw.live_erp_order_goods_df
1159 财务发货成本_一件代发
自营订单表
ods.live_goods_category_df t1
dim.zh_multiple_enum_df tB3
ods.live_account_crawler_conf_df
dw.live_order_basic_extend_df
982 财务订单_订单明细
app.finance_output_warehouse_goods_stat_ma t3
974 财务订单_统计概览_维度统计_店铺
buyer_order_no
sync.dhu_live_room_goods_detail_df
platform_order_goods_no
dw.live_order_goods_fin_df t1
order_no
替代线上的:dw.live_erp_order_di表该表按照天分区
dw.live_info_detail_df
dw.live_order_basic_extend_df t1
dw.live_coarse_room_order_goods_df
ods.live_live_custom_room_info_df
CPS商品表
dim.live_zhubo_manual_dept_df t2
1156 财务发货成本_发货明细
ods.live_erp_warehouse_df t7
dim.goods_supplier_cps_item_df
1条pon多条数据,1商品1佣金
dwd.live_order_logistics_di t5
org_id
dim.goods_supplier_cps_item_df t4
init_sku_code + supplier_no
ods.live_zhibo_live_cart_goods_df
inner join
1020 财务订单_统计明细_商品
968 财务订单-统计概览_天维度折线图
sync.app_finance_order_extend_detail_output_df_idxx
订单商品扩展表
dw.live_supplier_cps_item_order_df
ods.live_erp_after_sale_order_df t8
sync.app_finance_zhubo_stat_df
ods.ywcloud_org_df t5
ods.live_live_platform_room_info_df
dw.live_cart_goods_df
ding_user_id
1158 财务发货成本_自营总成本
dw.live_order_goods_df
970 财务订单_统计概览_维度统计_部门
unique_no
ods.live_supplier_base_df t6
dw.live_order_commission_fin_df
dwd.live_activity_data_export_detail_di t12
dw.live_erp_order_goods_df
t1.sku_id = t2.shangpinbianma
自营订单商品宽表
dw.live_order_goods_extend_df t2
app.finance_order_extend_detail_output_di
sync.app_finance_ship_detail_df_idx_v1
dw.live_order_goods_fin_df
dwd.live_t_rt_user_info_trend_detail_rpt_df
t1.cooperation_mode = t2.enum_id
app.dhu_30d_live_room_goods_detail_di
sync.live_supplier_cps_item_order_df
1157 财务发货成本_指标卡_折线图
976 财务订单_统计明细_主播商品
ods.live_delete_sku_detail_df t2
app.finance_ship_stat_df
dw.live_order_goods_df t3
app.finance_ship_detail_output_di
dw.live_erp_order_df t4
app.finance_zhubo_stat_df
dw.live_eff_zhubo_user_info_df
财务发货成本
dw.live_order_basic_extend_df
dwd.live_order_commission_di t1
dwd.live_erp_order_logistics_di
平台商品
dw.live_order_basic_extend_df t1
dw.live_erp_order_df
订单商品宽表
977 财务订单_统计明细_主播
platform_order_no
dw.live_order_goods_extend_df
ods.live_brand_df t4
dw.live_erp_order_goods_df t10
dw.live_erp_order_goods_df t1
ods.goods_item_category_df t5
app.finance_goods_stat_1_df
dw.live_coarse_room_order_goods_df
mid.live_order_goods_extend_df t1
app.finance_ship_month_stat_df
app.finance_order_extend_detail_df t2
dwd.live_order_basic_di tA
raw_so_id (order_no+A)
goods_id + from_source
遥望用户
dw.live_room_order_goods_ref_df
sync.app_finance_ship_month_stat_df
dwd.dhu_goods_info_back_track_df
platform_order_no+ goods_id + combo_sku_id
dw.live_eshop_cart_goods_df
dwd.live_t_rt_live_cart_goods_info_rpt_di
ods.live_zhubo_platform_account_df t7
975 财务订单_统计概览_维度统计_商品类目
ods.ywcloud_dingding_dept_user_rel_df t3
dw.live_order_commission_fin_df t2
dw.live_erp_order_goods_df t4
dim.live_platform_goods_info_df
ods.live_zhibo_live_cart_goods_other_info_df
973 财务订单_统计概览_维度统计_商品品牌
mid.live_user_goods_sales_hour_df
dwd.live_order_basic_di t2
dw.live_order_commission_df
dim.zh_multiple_enum_df tB4
ods.goods_terminal_category_df t4
output表结果为增量,同步到ES五个索引中
dim.live_platform_goods_info_df t3
dw.live_order_room_df 扩为全量订单 t1;cart_goods_df 关联t1(去掉无房间号的) 得到映射表t2;dw.live_order_room_df 关联t2 打上流量标记
app.live_goods_detail_df
dw.live_order_goods_extend_df t2
ods.live_zhubo_user_info_df t1
dw.live_order_goods_extend_df t11
dim.goods_supplier_cps_item_df t8
ods.xp_item_platform_relation_df
dw.dhu_live_room_goods_detail_df
dwd.live_erp_order_new_di
969 财务订单_统计概览_维度统计_主播
user_id+dept_id 定位dim唯一记录(一个员工可能会有多个部门[领导])t1.ding_user_id = t2.dingding_user_idt2.dingding_user_id = t3.dingding_user_idt3.dept_id = t4.dept_idt4.dept_id = t5.org_id
商品中心
dwd.live_order_goods_di
自营部分 span style=\"font-size: inherit;\
dw.live_cart_goods_relation_df 扩张为订单商品 得到t2;order_goods_extend 关联 t2
dim.zh_multiple_enum_df t2
dw.xp_plan_live_room_goods_detail_df
dw.live_goods_zhubo_detail_df t1
dw.live_cart_goods_relation_df
ods.goods_spu_df t3
roi 投资回报率: 付款GMV[sales_amt]: span style=\"font-weight: normal;\
ods.ywcloud_user_df t1
user_id+dept_id
dwd.live_order_goods_di t1
dwd.live_order_logistics_di t9
dwd.live_order_basic_di
pk_id+platform_order_no 11-26前 pk_id为null platform_order_no唯一11-26后,pk_id唯一
sync.app_finance_goods_zhubo_stat_1_df
dw.live_order_basic_extend_df
dingding_user_id
ods.live_zhibo_off_live_goods_data_df
app.finance_goods_stat_df
dim.live_zhubo_user_info_df t6
dw.live_room_order_goods_df
mid.dhu_replay_live_room_goods_df
sku_no
sync.dim_live_ship_select_df
只插入数据,不删除不更新,遇到唯一键冲突则忽略该记录(定制开发的同步任务Jar包)
app.dhu_30d_live_room_info_di
dw.live_order_goods_extend_df
ods.goods_sell_submit_spu_df t2
STOP |每月发货订单明细
app.live_warehouse_compare_df
platform_order_no+ goods_id + combo_sku_id (>2020-11-26)
dwd.live_erp_order_goods_new_di t1
999 商品详情
dim.live_show_select_df
ods.live_platform_rate_config_df t5
998 主播详情
1161 财务发货成本_下拉框
ods.goods_supplier_cps_item_df t1
981 财务订单_下拉框
推补录
dim.live_platform_goods_info_df t3
order_from_source: 1-淘宝 2-京东 3-拼多多 4-快手小店 5-有赞微商城 6-微小店 7-有赞客 8-抖音小店 9-京东来客 10-抖音CPS 11-魔筷 12-抖音小店+抖音CPS 13-有赞分销 14-快手CPS'15-有赞微商城+有赞客16-快手小店+快手CPS
dw.live_order_basic_extend_df t1
ods.goods_system_plate_form_rel_df t2
dwd.live_account_base_df t5
dwd.live_order_basic_di t1
app.finance_goods_zhubo_stat_df
订单扩展宽表
mid.live_order_goods_extend_df
佣金表
dim.zh_multiple_enum_df t6
tA表所有字段做判空处理tB1.order_from_source = tB2.enum_idtB1.platform=tB3.enum_id tB1.order_status= tB4.enum_id ==> tBtA.platform_order_no = tB.platform_order_no
dw.live_user_goods_sales_hour_df
user_no
dwd.live_order_basic_di t5
on t1.platform_order_no = t2.platform_order_not1.goods_id = t3.goods_id and t2.order_from_source = t3.from_source
group by t2.user_id去重t1.zhubo_bc=t2.user_id
dw.live_erp_order_goods_df t2
dw.live_coarse_room_order_goods_df
dw.live_order_goods_df t2
ods.live_zhubo_user_info_df
ods.goods_sell_submit_sku_df t1
ods.live_order_basic_di tB1
sync.live_show_select_df
app.finance_order_extend_detail_df t1
ods.goods_item_category_df
dw.live_order_goods_extend_df
t5.order_no as order_not5.pon as platform_order_not1.outer_order_no as raw_so_id[A]t1.platform_order_no as inner_outer_not1.platform_order_goods_no as pogn
ods.goods_system_plate_form_rel_df t3
dim.live_live_platform_room_info_df
sync.app_finance_ship_stat_df
<2020-11-26聚合处理 group by platform_order_no;>2020-11-26保留并剪裁掉了 1/2 的列
dwd.live_erp_order_goods_ext_di t2
dim.live_ship_select_df
1000 瑜大商品详情
app.finance_goods_zhubo_stat_1_df
sync.app_finance_goods_stat_df
dim.ywcloud_user_info_df t2
dingding_user_id + dept_id
订单表
dim.goods_sku_spu_df t3
dim.goods_sku_spu_df
ods.live_youzan_order_df t3
ods.ywcloud_dingding_user_df t2
dwd.live_cps_user_info_di t13
dw.live_order_goods_df t4
dwd.live_order_basic_di
主播部门信息
sync.live_goods_detail_df
platform_goods_no+order_from_source
dw.live_erp_order_goods_df t4
dw.live_order_commission_fin_df t3
dim.zh_multiple_enum_df tB2
pon
972 财务订单_统计概览_维度统计_商品平台
sku_code+supplier_no
platform_goods_no+cooperation_mode
ods.live_erp_after_sale_order_df t6
sync.app_finance_goods_zhubo_stat_df
ods.ywcloud_dingding_dept_df t4
0 条评论
下一页