财务涉及dw.live_order_basic_extend_df
2021-08-09 14:40:47 1 举报遥望网络
作者其他创作
大纲/内容
dwd.live_order_basic_di t2
dw.live_order_commission_df
dim.live_zhubo_user_info_df
dept_id
dim.zh_multiple_enum_df tB4
ods.goods_terminal_category_df t4
dim.live_platform_goods_info_df t3
ods.live_goods_category_df t1
dim.zh_multiple_enum_df tB3
ods.live_zhubo_user_info_df t1
goods_id + from_source
dw.live_order_goods_extend_df t11
dim.goods_supplier_cps_item_df t8
ods.live_cps_user_info_di
dwd.live_erp_order_new_di
buyer_order_no
dim.zh_multiple_enum_df t2
ods.live_order_commission_di
ods.goods_spu_df t3
platform_order_goods_no
ods.live_activity_data_export_detail_di
order_no
dw.live_order_goods_fin_df t1
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唯一
CPS商品表
dingding_user_id
ods.live_erp_order_new_di
ods.live_erp_warehouse_df t7
dim.goods_supplier_cps_item_df
1条pon多条数据，1商品1佣金
org_id
dim.goods_supplier_cps_item_df t4
dim.live_zhubo_user_info_df t6
init_sku_code + supplier_no
sku_no
sync.dim_live_ship_select_df
订单商品扩展表
ods.goods_sell_submit_spu_df t2
ods.live_erp_after_sale_order t8
platform_order_no+ goods_id + combo_sku_id (>2020-11-26)
dwd.live_erp_order_goods_new_di t1
platform_order_no
ods.ywcloud_org_df t5
ding_user_id
unique_no
ods.live_platform_rate_config_df t5
ods.live_supplier_base_df t6
dw.live_order_commission_fin_df
dwd.live_activity_data_export_detail_di t12
1161 财务发货成本_下拉框
ods.goods_supplier_cps_item_df t1
ods.live_order_goods_di
dim.live_platform_goods_info_df t3
platform_order_no+ goods_id + combo_sku_id
ods.goods_system_plate_form_rel_df t2
dwd.live_account_base_df t5
dwd.live_order_basic_di t1
dw.live_order_goods_fin_df
mid.live_order_goods_extend_df
佣金表
ods.live_erp_order_logistics_di
app.finance_ship_detail_df
dw.live_erp_order_df t4
user_no
dwd.live_order_basic_di t5
dw.live_order_basic_extend_df
dw.live_erp_order_goods_df t2
dw.live_order_goods_df t2
dwd.live_order_commission_di t1
dwd.live_erp_order_logistics_di
ods.goods_sell_submit_sku_df t1
ods.live_order_basic_di tB1
dw.live_order_goods_extend_df
dw.live_erp_order_df
ods.goods_system_plate_form_rel_df t3
dwd.live_erp_order_goods_ext_di t2
dim.live_ship_select_df
ods.live_brand_df t4
dw.live_erp_order_goods_df t10
dim.ywcloud_user_info_df t2
ods.goods_item_category_df t5
dingding_user_id + dept_id
mid.live_order_goods_extend_df t1
dim.goods_sku_spu_df t3
dim.goods_sku_spu_df
ods.live_youzan_order_df t3
ods.ywcloud_dingding_user_df t2
dw.live_erp_order_goods_df
dwd.live_cps_user_info_di t13
dw.live_order_goods_df t4
dwd.live_order_basic_di tA
raw_so_id （order_no+A）
platform_goods_no+order_from_source
ods.zh_multiple_enum_df t2
ods.live_account_base_df
ods.live_erp_order_goods_ext_di
dw.live_order_commission_fin_df t3
dim.zh_multiple_enum_df tB2
sku_code+supplier_no
platform_goods_no+cooperation_mode
ods.live_zhubo_platform_account_df t7
dw.live_order_goods_df
ods.live_erp_order_goods_new_di
ods.ywcloud_dingding_dept_user_rel_df t3
ods.live_erp_after_sale_order_df t6
dw.live_order_commission_fin_df t2
dw.live_erp_order_goods_df t4
dim.live_platform_goods_info_df
ods.ywcloud_dingding_dept_df t4
0 条评论
下一页
