---以下语句全部执行即可 use hbposev9_branch ---如果是总部使用hbposev9 go delete from t_sys_report go INSERT INTO t_sys_report VALUES ( 'DM销售对比查询', 'd_pc_form_sale_dm', '分析报表', 'G', NULL, '', 'S', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( 'DM销售日比', 'd_pc_form_sale_dmday', '分析报表', 'G', NULL, '', 'S', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '安装单月报表', 'sah_d_fx_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '报损汇总表', 'd_im_report_jo_summary', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '补货分析表', 'd_pm_report_po', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '补货分析表(按分店和商品分组)', 'd_pm_report_po_bybranch_item', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '部门调货汇总表', 'd_im_report_zh_summary', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购大类汇总报表', 'd_pm_report_bigcls_pi', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购订单到货率报表', 'd_pm_report_co', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购订单到期报表', 'd_pm_report_expire_po', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购订单供应商汇总报表', 'd_pm_report_sup_po_sum', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购订单类别汇总报表', 'd_pm_report_cls_po', '采购报表', 'G', NULL, '', 'S', '', '', '', '', 'DateRange=自选范围', NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购订单状态报表', 'd_pm_report_detail', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购供应商汇总报表', 'd_pm_report_sup', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购类别汇总报表', 'd_pm_report_cls_pi', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购商品汇总报表', 'd_pm_report_item_pi', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购商品明细报表', 'd_pm_query_item_detail', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '采购中类汇总报表', 'd_pm_report_midcls_pi', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '差异回调报表', 'd_dm_report_diff', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '出入库汇总', 'd_im_report_branch_io_summary', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '出入库明细', 'd_im_report_branch_io_detail', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '促销让利汇总', 'd_rm_pc_query_discount_total', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '大类进销存日报表', 'd_da_jxcday_bigclsrpt', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '大类库存汇总', 'd_im_report_stock_bigcls_sum', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '大类毛利汇总报表', 'd_da_profitday_bigclsrpt_total', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsname', 'avg_profitamt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '大类毛利日报表', 'd_da_profit_day_bigclass', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '大类毛利月报表', 'd_da_profitmonth_bigclsrpt', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '大类批次毛利报表', 'd_da_batch_profit_bigcls', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '大类批次毛利日报表', 'd_da_batch_profit_bigcls_day', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '大类批发汇总报表', 'd_wm_report_bigcls_so', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '大类批发毛利汇总报表', 'd_wm_bigcls_profit', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsname', 'avg_profit', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '大类销售汇总报表', 'd_rm_report_bigclass_total', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsname', 'compute_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '大类销售日报表', 'd_rm_report_day_bigclass', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '大类销售周报', 'd_da_week_bigcls_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '大类月同期对比', 'd_da_report_period_compare_bigcls', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsname', 'profit_rate', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '店组大类汇总', 'd_rm_group_bigcls_new1', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '店组-大类库存分析', 'd_im_group_bigclsno', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '店组分部汇总', 'd_rm_group_branch_new', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '店组--供应商采购汇总报表', 'd_pm_report_sup_branch', '店组--供应商采购汇总报表', 'G', NULL, '', 's', '', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '店组--供应商销售汇总报表', 'd_rm_report_sup_branch', '店组--供应商销售汇总报表', 'G', NULL, '', 's', '', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '店组类别汇总', 'd_rm_group_clsno_new', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '店组-类别库存分析', 'd_im_group_clsno', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '店组商品汇总', 'd_rm_group_item_new', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '店组-商品库存分析', 'd_im_group_item', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '店组销售汇总', 'd_rpt_group_branch', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '调拨分部汇总报表', 'd_dm_dido_report_branch_summary', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '调拨类别汇总报表', 'd_dm_dido_report_cls_summary', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '调拨商品汇总报表', 'd_dm_dido_report_item_summary', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '调出单查询报表', 'd_dm_mo_query_report', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '调价生效提醒', 'd_pc_report_price_prompt_px', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '调入单查询报表', 'd_dm_mi_query_report', '分析报表', 'G', NULL, '', 'S', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '分店库存汇总', 'd_im_report_stock_summary_bybranch', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商到期帐款报表', 'd_fm_due_expire2', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商对帐情况报表', 'd_fm_sup_dp_detail', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商对账单明细报表', 'd_fm_dp_master_report', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商费用汇总报表', 'd_fm_sup_fee_summary', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商费用机构汇总报表', 'd_fm_sup_fee_branch_summary', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商费用明细报表', 'd_fm_sup_fee_detail', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商贡献度分析', 'ta_d_analyse_sup_gx', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商机构销售汇总报表', 'd_rm_report_item_supplier_branch_total', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商结款分析', 'ta_d_analyse_sup_jk', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商进销存汇总报表', 'd_da_jxcday_mainsup_total', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商进销存日报表', 'd_da_jxcday_mainsup', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商类别毛利汇总报表', 'd_da_profitday_sup_clsrpt_total', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'main_sup', 'avg_profitamt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商历史往来帐款报表', 'd_fm_sup_recpay_detail', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商毛利汇总报表', 'd_da_profit_sup_sum', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'main_supcust', 'avg_profitamt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商毛利日报表', 'd_da_profit_day_sup', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商每天单品销售报表', 'd_rm_report_item_supplier_detail', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商品牌销售分析', 'd_da_profitday_sup_pp_total', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_brand', 'sale_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商品牌销售明细', 'd_da_profitday_sup_pp_detail', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_brand', 'sale_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商商品分析', 'ta_d_analyse_sup_item', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商送货分析', 'ta_d_analyse_sup_sh', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商送货信用度报表', 'd_pm_sup_deliver_credit', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商退货分析', 'ta_d_analyse_sup_th', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商往来账', 'd_fm_account_report', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商销售汇总', 'd_rm_report_item_supplier', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商销售汇总报表', 'd_rm_report_sup_sum', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'sup_name', 'compute_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商销售明细报表', 'd_rm_report_item_supplier_saleflow', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商销售日报表', 'd_rm_report_day_sup', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商销售周报', 'd_da_week_sup_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商信誉度分析', 'ta_d_analyse_sup_credit', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商信誉度分析(商品)', 'ta_d_analyse_sup_credit_item', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商信誉分析(订单)', 'd_da_report_po_pi_info', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '供应商月同期对比', 'd_da_report_period_compare_sup', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'main_sup', 'profit_rate', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商月效益分析', 'ta_d_analyse_sup_yxy', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '供应商综合分析', 'ta_d_analyse_sup_zh', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '顾客投诉处理月报表', 'sah_d_ts_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '环比销售分析', 'd_da_report_month_sale', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '会员群体分析', 'ta_d_analyse_vip_qtfx', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '会员生日', 'd_vip_birthday1_query', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '会员忠诚度分析', 'ta_d_analyse_vip_zcd', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '机构商品库存汇总', 'd_im_report_stock_summary1', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '加盟店单据毛利汇总报表', 'd_dm_profit_sheet', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '加盟店单据毛利明细报表', 'd_dm_profit_sheet_detail', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '进销存月大类汇总', 'd_da_jxcmonth_bigclsrpt', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '进销存月类别汇总', 'd_da_jxcmonth_clsrpt', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '进销存月品牌汇总', 'd_da_jxcmonth_pp', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '进销存月商品汇总', 'd_da_jxcmonth_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '进销存月中级类别汇总', 'd_da_jxcmonth_midclsrpt', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '进销存月主供应商汇总', 'd_da_jxcmonth_report_sup', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '经营方式分析', 'ta_d_analyse_sale_jyfs', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'sale_way', 'paid_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '经营方式毛利汇总报表', 'ta_d_profitday_report_total_jyfs', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_sup_flag', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '经营方式销售汇总报表', 'd_pos_report_jyfs', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_sup_flag', 'compute_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '经营总况日报表', 'd_rm_daysum_all', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '客户到期帐款报表', 'd_fm_due_expire_rp', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '客户类别毛利汇总报表', 'd_wm_custtype_profit', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '客户历史往来帐款报表', 'd_fm_cust_recpay_detail', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '客户历史往来帐款汇总报表', 'd_fm_cust_receivable_summary1', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '客户毛利汇总报表', 'd_wm_cust_profit', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'sup_name', 'avg_profit', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '客户销售汇总报表', 'd_wm_report_cust', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '客户销售让利汇总报表', 'd_wm_query_dct_total', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '客户销售商品汇总报表', 'd_wm_report_cust_item', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '客户信誉额度报表', 'd_fm_cust_credit_line', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '客户赠品报表', 'd_wm_report_cust_gitem', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '扣补单查询报表', 'd_im_sheet_kb_query', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '扣补单明细查询', 'd_im_kb_sheet_detail', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '库存调整汇总表', 'd_im_report_oo_summary', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '库存调整明细表', 'd_im_report_oo_detail', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '库存分析报表', 'd_im_report_bigcls_stock', '分析报表', 'G', NULL, '', 'S', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '库位毛利汇总报表', 'd_da_profitday_place_total', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'place_name', 'avg_profitamt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '库位商品毛利汇总报表', 'd_rm_report_place_itemno', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'place_name', 'avg_profitamt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '库位销售汇总报表', 'd_rm_report_place_sum', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '库位销售明细报表', 'd_rm_report_place_item', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别进销存报表', 'd_da_jxc_daysum_fz_cls_days', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别进销存类别日报表', 'd_da_jxcday_clsrpt', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别库存汇总', 'd_im_report_stock_bigcls', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别毛利汇总报表', 'd_da_profitday_clsrpt_total', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsname', 'avg_profitamt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '类别毛利日报表', 'd_da_profit_day_class', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别毛利月报表', 'd_da_profitmonth_clsrpt', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别批次毛利报表', 'd_da_batch_profit_cls', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别批次毛利日报表', 'd_da_batch_profit_cls_day', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别批发汇总报表', 'd_wm_report_cls_so', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '类别批发毛利汇总报表', 'd_wm_cls_profit', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsname', 'avg_profit', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '类别销售分部汇总报表', 'd_rm_report_branch_class_detail', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别销售汇总报表', 'd_rm_report_class_total', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsname', 'compute_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '类别销售日报表', 'd_rm_report_day_class', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别销售周报', 'd_da_week_cls_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '类别月同期对比', 'd_da_report_period_compare_cls', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsname', 'profit_rate', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '类别月销售环比', 'd_da_report_month_sale_byitemcls', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '历史进价查询', 'd_pm_report_pi_price', '采购报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '领用汇总表', 'd_im_report_ko_summary', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '毛利分析(按税率)', 'd_da_profitday_total_tax', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '毛利增长分析', 'd_da_analyse_profit', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'oper_date', 'sub_amt', NULL, NULL, 7, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '门店到货率分析报表', 'd_dm_report_completed_rate', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '门店毛利汇总报表', 'd_da_profit_branch_sum', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'branch_no', 'avg_profitamt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '门店毛利日报表', 'd_da_profitday_dayrpt_total', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '门店缺货分析报表', 'd_dm_report_uncompleted_summary', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '门店销售汇总报表', 'd_rm_report_branch_summary', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'branch_no', 'compute_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '门店销售坪效分析', 'd_rm_report_branch_sum_area', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '门店销售日报表', 'd_rm_report_day_branch', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'oper_date', 'compute_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '门店销售周报', 'd_da_week_branch_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '门店要货单状态跟踪报表', 'd_dm_report_yh_status', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '门店要货汇总报表', 'd_dm_report_yh_summary', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '门店要货商品汇总报表', 'd_dm_report_yh_summary_item', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '门店月同期对比', 'd_da_report_period_compare_branch', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'branch_no', 'profit_rate', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '门店月销售环比', 'd_da_report_month_sale_bybranch', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '配送大类汇总报表', 'd_dm_report_bigcls_summary', '配送报表', 'G', NULL, '', 's', '', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '配送分部汇总报表', 'd_dm_report_branch_summary', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '配送类别汇总报表', 'd_dm_report_cls_summary', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '配送率分析-按单汇总报表', 'd_dm_report_completed_rate_mo_bysheet', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '配送率分析报表', 'd_dm_report_completed_rate_mo', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '配送商品汇总报表', 'd_dm_report_item_summary', '配送报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '配送商品明细报表', 'd_dm_report_item_detail2', '配送报表', 'G', NULL, '', 'S', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '批次出库', 'd_im_report_batch_out', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '批次结存', 'd_im_report_batch_stock', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '批次进销存', 'd_im_report_batch_jxc', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '批次未冲销数据', 'd_im_report_batch_suspend', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '批发单据毛利报表', 'd_wm_sheet_profit', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '批发销售明细报表', 'd_wm_query_detail', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '品牌毛利汇总报表', 'd_da_profit_pp_sum', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'pp_clsname', 'avg_profitamt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '品牌毛利日报表', 'd_da_profit_day_pp', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '品牌毛利月报表', 'd_da_profitmonth_pp', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '品牌批发汇总报表', 'd_wm_report_pp', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'brand_name', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '品牌销售分店汇总表', 'd_rm_report_branch_pp_total', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '品牌销售汇总报表', 'd_rm_report_pp_sum', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_brand', 'compute_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '品牌销售日报表', 'd_rm_report_day_pp', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '品牌销售周报', 'd_da_week_pp_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '品牌月同期对比', 'd_da_report_period_compare_brand', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_brand', 'profit_rate', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '区域毛利汇总报表', 'd_wm_area_profit', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'region_no', 'avg_profit', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '区域批发汇总报表', 'd_wm_report_region', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'region_name', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '让利大类汇总', 'd_da_dct_classified_total_bigcls', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '让利类别汇总', 'd_da_dct_classified_total', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '日均销售报表', 'd_rm_report_days_sum', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品价格带分析', 'ta_d_report_priceband', 'ta_w_anal_priceband', 'G', NULL, 'RATE', 'S', '', '', 'price_band', 'item_count', NULL, NULL, 7, NULL, '0', NULL, 'Pie3D'); INSERT INTO t_sys_report VALUES ( '商品价格带销售分析', 'ta_d_report_priceband_sale', 'ta_w_anal_priceband_sale', 'G', NULL, 'RATE', 'S', '', '', 'price_band', 'sale_amt,sale_qty', NULL, NULL, 7, NULL, '0', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '商品价格分析', 'ta_d_report_price_anal', 'pub_w_analyze_cond', 'G', NULL, 'RATE', 'S', '', '', 'oper_date', 'pos_price', NULL, NULL, 7, NULL, '0', NULL, 'linegraph'); INSERT INTO t_sys_report VALUES ( '商品交叉比率分析', 'd_da_report_crossrate_anal', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_no', 'cross_rate', NULL, NULL, 7, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '商品结构分析(大类)', 'd_da_ana_item_bigcls', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '商品结构分析(类别)', 'd_da_ana_item_cls', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsno', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '商品进销存报表', 'd_da_jxc_daysum_fz_item_days', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品进销存日报表', 'd_da_jxcday_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品库存汇总', 'd_im_report_stock_summary_total', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品库存金额分析', 'd_da_report_stock_anal', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_no', 'stock_amt', NULL, NULL, 7, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '商品库位销售汇总报表', 'd_rm_report_item_place_sum', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品毛利汇总报表', 'd_da_profitday_report_total', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品毛利汇总报表(按仓库)', 'd_rm_stock_profit', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品毛利日报表', 'd_da_profit_day_item', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品毛利月报表', 'd_da_profitmonth_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品批次毛利报表', 'd_da_batch_profit', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品批次毛利日报表', 'd_da_batch_profit_day', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品批发汇总报表', 'd_wm_report_item_so', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品批发毛利汇总报表', 'd_wm_item_profit', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品批发日毛利汇总报表', 'd_wm_item_dayprofit', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品销售分部汇总报表', 'd_rm_report_branch_item_detail', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品销售汇总报表', 'd_rm_report_item_sum', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品销售汇总报表(按商品和售价分组)', 'd_rm_report_item_sum_byitemprice', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品销售明细报表', 'd_rm_report_oper_date_item', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品销售日报表', 'd_rm_report_day_item', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品销售增长率分析', 'd_da_report_saleqty_anal', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品销售周报', 'd_da_week_item_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品月同期对比', 'd_da_report_period_compare_item', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品月销售环比', 'd_da_report_month_sale_byitem', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '商品周转率分析', 'd_da_report_velocity_anal', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_no', 'velocity_rate', NULL, NULL, 7, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '实付账款汇总报表', 'd_fm_report_sup_paid_sum_query', '结算报表', 'G', NULL, '', 'S', '', '', '', '', 'DateRange=自选范围', NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '实付账款明细报表', 'd_fm_report_sup_paid_detail_query', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '实时库存', 'd_im_report_stock_real1', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '收银员让利', 'd_rm_report_cashier_discount', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '收银员让利明细', 'd_da_dct_oper_classified_total', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '收银员业绩考核报表', 'd_rm_report_cashier_sale', '分析报表', 'G', NULL, '', 'S', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '售后服务月报表', 'sah_d_shfw_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '送货单月报表', 'sah_d_dl_report', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '无业务客户报表', 'd_wm_report_nosale_cust', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '销售让利汇总', 'd_wm_report_dct_total', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '销售让利明细', 'd_wm_report_dct_detail', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '询价单明细查询', 'd_pm_query_xj_detail', '查询报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '业务员客户销售报表', 'd_wm_report_saleman_cust', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '业务员客户销售明细报表', 'd_wm_report_item_so', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '业务员毛利汇总报表', 'd_wm_saleman_profit', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'oper_name', 'avg_profit', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '业务员批发销售明细报表', 'd_wm_query_saleman_item', '批发报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '已收账款明细报表', 'd_fm_report_cust_rece_detail_query', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '应付帐款汇总报表', 'd_fm_sup_payable_summary', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '应付帐款明细报表', 'd_fm_sup_payable_detail', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '应收帐款汇总报表', 'd_fm_cust_receivable_summary', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '应收帐款明细报表', 'd_fm_cust_receivable_detail', '结算报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '营业额增长率分析', 'd_da_analyse_turnover', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'oper_date', 'sub_amt', NULL, NULL, 7, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '在途库存报表', 'd_im_report_stock_route_real', '在途库存报表', 'G', NULL, '', 's', '', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '中级类别毛利月报表', 'd_da_profitmonth_midclsrpt', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '中类毛利汇总', 'd_da_profitday_midclsrpt_total', 'POS报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '中类销售汇总报表', 'd_rm_report_midclass_total', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'item_clsname', 'compute_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '主供应商毛利月报表', 'd_da_profitmonth_report_sup', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '主供应商批发汇总报表', 'd_wm_report_mainsup', 'pub_w_analyze_cond', 'G', NULL, '', 'S', '', '', 'sup_name', 'so_amt', NULL, NULL, 30, NULL, '1', NULL, 'col3dobjgraph'); INSERT INTO t_sys_report VALUES ( '主供应商月销售环比', 'd_da_report_month_sale_bysup', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '主推商品报表', 'd_da_report_main_item', '分析报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '转仓分部汇总', 'd_dm_report_io_branch_summary', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '转仓类别汇总', 'd_dm_report_io_cls_summary', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '转仓明细查询', 'd_dm_report_item_detail', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '转仓商品汇总', 'd_dm_report_io_item_summary', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL); INSERT INTO t_sys_report VALUES ( '组合拆分汇总表', 'd_im_report_cs_summary', '库管报表', 'G', NULL, '', 'S', '', '', '', '', NULL, NULL, 0, NULL, NULL, NULL, NULL);