大单功能详细设计

目录一、数据表...............................................................................................................................2二、申报事项—行单采购申请...............................................................................................5三、申报事项—行单采购申请（大单采购专员）.............................................................22四、草稿箱—行单采购申请草稿.........................................................................................24五、申报事项—行单采购修改.............................................................................................24六、申报事项—行单采购改单.............................................................................................30七、申报事项—行单销售申请.............................................................................................30八、查询列表—大单采购查询列表.....................................................................................47九、查询列表—大单销售查询列表.....................................................................................49十、统计报表—大单采购明细表.........................................................................................51十一、统计报表—大单进展跟踪表（采购）/大单进展跟踪表.......................................53十二、统计报表—大单出库查询表.....................................................................................60十三、统计报表—销售关联表.............................................................................................61十四、申报事项—行单返款.................................................................................................64十五、条码维护—华三条码导入.........................................................................................65十六、信息维护—采购订单行项目号修改.........................................................................65十七、大单合同—合同修改、作废.....................................................................................66十八、大单合同—修改采购订单合同.................................................................................66十九、物流待办补数.............................................................................................................67二十、华三管理—总代超长期项目报备汇总.....................................................................68二十一、华三管理—物流可视化.........................................................................................69二十二、华三管理—华三订单关联查询.............................................................................71二十三、行单采购删除.........................................................................................................73二十四、行单销售删除.........................................................................................................75二十五、超期超额解冻.........................................................................................................76二十六、渠道采购库存地，几个库存地显示几列。.........................................................76一、数据表新增字段：altertablet_bo_purchase_mainadd(operate_typevarchar2(20),is_split_deliveryvarchar2(20),transactor_namevarchar2(20),apply_person_namevarchar2(20),sales_org_idvarchar2(20),is_accountvarchar2(20),next_auditorvarchar2(256),company_weekplanvarchar2(20),company_weekreachvarchar2(20),attachment_oidnumber,old_main_oidnumber,contract_idvarchar2(50),is_manual_contractvarchar2(20),is_contract_originalvarchar2(20),is_zg_storevarchar2(20));commentoncolumnt_bo_purchase_main.operate_typeis'类别：01-新增；02-修改；03-关闭';commentoncolumnt_bo_purchase_main.is_split_deliveryis'是否分批交货';commentoncolumnt_bo_purchase_main.transactor_nameis'经办人名称';commentoncolumnt_bo_purchase_main.apply_person_nameis'申请人名称';commentoncolumnt_bo_purchase_main.sales_org_idis'销售组织编码';commentoncolumnt_bo_purchase_main.is_accountis'是否款到账';commentoncolumnt_bo_purchase_main.next_auditoris'下一审批人';commentoncolumnt_bo_purchase_main.company_weekplanis'公司周计划';commentoncolumnt_bo_purchase_main.company_weekreachis'公司周达成';commentoncolumnt_bo_purchase_main.attachment_oidis'附件主表oid';commentoncolumnt_bo_purchase_main.old_main_oidis'原申请单号，修改时填';commentoncolumnt_bo_purchase_main.contract_idis'合同编号';commentoncolumnt_bo_purchase_main.is_manual_contractis'是否手动更改过合同编号';commentoncolumnt_bo_purchase_main.is_contract_originalis'能否收到合同原件';commentoncolumnt_bo_purchase_main.is_zg_storeis'货物是否到紫光库房';commentoncolumnt_bo_purchase_main.statusis'状态：01-草稿,02-申请,03-审批中,06-完成,99-取消,92-删除,98-因修改无效';altertablet_bo_purchase_orderadd(is_split_deliveryvarchar2(20),credit_explainvarchar2(1024),sap_sales_orgvarchar2(20),hp_price_numvarchar2(256),old_stock_moneyvarchar2(20),close_reasonvarchar2(1024));commentoncolumnt_bo_purchase_order.is_split_deliveryis'是否分批交货';commentoncolumnt_bo_purchase_order.credit_explainis'信用说明';commentoncolumnt_bo_purchase_order.sap_sales_orgis'入sap销售组织';commentoncolumnt_bo_purchase_order.hp_price_numis'hp报价单号';commentoncolumnt_bo_purchase_order.old_stock_moneyis'原采购总金额，修改时填';commentoncolumnt_bo_purchase_order.statusis'状态：01-草稿,02-申请,03-审批中,06-完成,99-取消,92-删除,98-因修改无效';commentoncolumnt_bo_purchase_order.close_reasonis'关闭原因';altertablet_bo_purchase_itemadd(main_oidnumber,old_item_oidnumber,apply_stock_numvarchar2(20),item_numvarchar2(20),contract_item_idvarchar2(20),h3c_project_numvarchar2(50),h3c_item_numvarchar2(20),operat