dwd层
sh_ads_merchant_dailytoday 日期count_1w_money当天金额大于1w商户数ticket_total_amount当天总金额大于20w商户数
dws层
云票c端
sh_dw_kaipiao_todaytoday 日期invoice_kind 类型channel 渠道industry 行业province 省份billing_merchants 有效商户数quantity_invoice 当天开票量success_invoice 当天成功开票量fail_invoice 当天失败开票量one_success_invoice 一次开票成功量
dwd_m_sell_clientschannel 渠道id 税号industry 行业province 省份
ods层
ads_i_invoice_dailyinvoice_num 每天发票数total_invoice_num累计发票量source 来源today 日期effective_invoice_num有效发票数total_effective_invoice_num累计有效发票量
sh_dws_merchant_dailytoday 日期max_count_1w_money当天最大金额ticket_total_amount_money当天总金额
dwd_kaipiaocreate_at 创建时间invoice_kind 类型sell_tax_code 纳税人税号state票据状态state_max开票状态最大值ticket_total_amount_has_tax 合计含税金额
ods_kaipiaocreate_at 创建时间invoice_kind 类型sell_tax_code 纳税人税号state票据状态state_max开票状态最大值ticket_total_amount_has_tax 合计含税金额
ads层
ods_m_sell_clientschannel 渠道id 税号industry 行业province 省份
dwd_qx_user_authuser_id 用户idsource_id 去重来源id
sh_ads_kaipiao_todaytoday 日期invoice_kind 类型channel 渠道industry 行业province 省份billing_merchants 有效商户数quantity_invoice 当天开票量total_quantity_invoice 累计开票量success_invoice 当天成功开票量total_success_invoice 累计开票成功量fail_invoice 当天失败开票量total_fail_invoice 累计开票失败量one_success_invoice 一次开票成功量count_1w_money 当天金额大于1w商户数ticket_total_amount 当天总金额大于20w商户数
dw_i_invoice_dailyinvoice_num 每天发票数source 来源today 日期effective_invoice_num有效发票数
qx_user_authuser_id 用户idsource_id 来源id
dwd_i_invoiceuser_id 用户idinvoice_id 发票idsource 发票来源today 日期
dws_i_invoice_dailyuser_id 用户idinvoice_id 开票idsource 发票来源today 日期union_id有效开票id
dws_m_sell_clientschannel 渠道id 税号industry 行业province 省份
云票b端
i_invoiceuser_id 用户idinvoice_id 发票idsource 发票来源created_at 创建日期
