{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","发货流程","发货单相关表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,9,7,9],[17,1,18,1],[2,2,7,2],[8,2,10,2],[1,1,7,1],[8,1,10,1]]}
["排序","反馈人","修改/新功能","具体内容",null,"优先级","需求来源","负责人","人/天","完成时间","测试状态"]
[null,"Daisy","修改","1. 报价单：未维护价格的item不要显示在导出的报价单上",null,null,null,"Famas",null,"2022-12-06","已完成"]
[null,null,"新功能","2. 产品发布机型后，商务要有维护是否销售的模块",null,null,null,"Famas",null,"2022-12-07","已完成"]
[null,null,null,"3. 海外销售额：统计销售数据：按照已发货的统计，不是订单金额",null,"低","海外商务","Famas","10","2022-12-15","已做，daisy用下来需要修改"]
[null,null,null,"4. 导出的台账，按照我们的模板，数据可筛选",{"$nulls":4},"确定需求","需求未定，需讨论"]
[null,null,null,"5. 销售的催款也需要有EXCEL表格，能筛选--比如筛选客户，OA到期日期，金额等",null,"中","海外商务",null,"确认"]
[null,null,null,"6. 跟财务的收款表格链接，并自动发送PI给财务，每月统计已发货订单的订单应收明细给财务",null,"中","海外商务/财务",null,2]
[null,null,null,"7.香港的库存表格中增加在途的数量，发货时间",null,"中","海外商务",null,"需求未定，需讨论"]
[null,null,"新功能","FCST模块：计划维护需要提供FCST机型，销售维护上报给大区经理，大区经理汇总提交给商务&计划，选型核算FCST准确率--计划，商务，销售===预测销售",{"$nulls":4},"需求未定，需讨论"]
[null,null,null,"选型制作报关资料：箱单发票等",null,"低","海外商务",null,"需求未定，需讨论"]
[null,null,null,"海外Demo模块\nxuany:因为目前国外申请demo较频繁，还有配置等都需要销售确认，销售需要把信息填在表里，然后我们邮件一一列出发送给生产；\n为了简化流程和确认配置，请帮忙增加国外demo需求板块，国外销售在选型中申请提交→我审批→我发送给生产（参照国内demo模块），请帮忙处理一下，谢谢。\nDaisy:\n帮忙再开发个demo转销售的模块，当demo机器卖掉之后，可以一键复制转成demo转销售订单（订单号D开头）\n要设防呆的是：\n如果申请demo的清单里主机项下有申请开通module 2部分的功能，此台机器如果转销售，module2的功能也一定要转销售。\n如果销售去掉了，订单无法提交。",null,null,null,"Kylie",null,"2022-12-12","已完成"]
[null,"Candice","新功能","可以根据物料信息反向搜索机型 【新系统实现】新实现：更进IPN号查询",null,null,null,"Kylie",null,"2022-12-08","已完成"]
[1,"Gary","新功能","出货功能：2022/10/19 gary邮件，licenseV2 集成license工具",null,"高","仓库/生产","kylie/Famas",30,"2023-05-28",""]
[2,"James","新功能","Spec进选型接口，需开发一个Spec服务，替代原先的excel，可提交至选型系统。",null,"高","研发","kylie/Famas",2,"2023-05-30"]
[3,"韩暄","新功能","国内客户”模块，想要实现导出功能： 可以导出生成表格，表头包括：客户名、大区、省区、客户地址，这些信息-",null,"高","商务","kylie/Famas",2,"2023-05-30"]
[4,"Hayley","优化/新功能","3.产品配置导入删掉的物料也需要通知到产品【市场部】",null,"高","市场部","kylie/Famas",2,"2023-06-01"]
[null,"Lisa","新功能","计划预测：\n大致的流程和需要关注的重点我描述一下，具体的实现需要大家再沟通\n\n1：需要一个check环节（商务），确保各区都已经提交了之后，系统汇总到一个表单中输出给计划--开发\n2：需要系统完成转为裸机的滚动预测（计划需要维护对应关系或者根据BOM抓取对应关系）--bresson\n3：基于销售的预测，趋势以及过往的出货并加上探头的需求转化为周，月的生产计划---bresson\n4：审批转化后的生产计划（需要有可以调整的功能）---lisa\n5：审批后的计划转到U8中的预测单---开发",null,"中","供应链","kylie/Famas"]
[5,"sean","新功能","预销售功能，在产品未正式release前可录入到选型系统，此时状态为预售无货状态。",null,"高","研发","kylie/Famas",5,"2023-06-09",null,"确认是否跟未发布可有限接单"]
[null,null,"新功能","选型系统是否支持按单次订单的最小数量由商务设置最低价格？\n不是单个订单的价格，而是最低价格的规则，与MOQ关联，由管理员后台设定，系统应自动比较，限制实际订单的价格不低于规则。\n需增加一种规则，设置MOQ参数，根据MOQ设置不同的底价。",null,"中","销售","kylie/Famas","需求未定，需讨论","2023-03-27"]
[6,null,"优化/新功能","4.国内配置单导出新PDF 新模板\n配置单2022/8/24\n国内机型：\n1.添加产品维护物料描述 【新系统实现】---TODO\n销售端：\n1.配置单选择机型显示VCode，IPN，产品描述【主机显示机型，其他显示功能】，备注【产品在国内机型维护】  【新系统实现】---TODO\n2.导出配置单需要维护物料分类，按照新的配置模板导出经销商版【标注:标配，选配】，客户版  【新系统实现】--TODO",null,"高","市场部","kylie/Famas",30,"2023-07-14"]
[7,"Lisa","新功能","2022年9月7日Lisa提出的需要新增维护售后价格的功能，售后下单可看到售后价格【新系统实现】",null,"高","售后","kylie/Famas",3,"2023-07-19"]
[null,"Adien","新功能","制氧机选型电商下单，导入选型，后续操作流同超声机",null,"低","国内销售","kylie/Famas","需求未定，需讨论"]
[8,"Wengjing","新功能","手机上能简单实现的一些功能：\n目前不求能下配置下订单，就是后面操作这块能用到编辑即可。\n订单/配置系统\n收款编辑功能（包含日期修改）\n地址维护编辑\n导入U8/导出\n配置系统审批查看",null,"高","商务","kylie/Famas",10,"2023-07-28"]
[9,"daisy，candice","新功能","国外和国内在选型上输入预测，需要包含的信息：国别，区域，IPN（可以是90号），描述。\n     更新频次要求：每月更新连续6个月的计划。\n     国内区分了成交的风险大小，风险大的需要能识别到",null,"高","供应链","kylie/Famas",10,"2023-08-09"]
[10,"Balaji","新功能","苏州账套目前的权限可配，若Balaj想要和Daisy一样的权限可进行配置\n需要增加EVQ到其他代理商的订单维护，包括存量，发货，OA等和苏州一样都要\nEVQ导出PI要经过Cassie审批，修改需要再次审核，Bill要看到\nEVQ到其他客户的单子Bill,商务都要看到\n逾期要发邮件给代理商（需维护）（到期前两周，一周，到期发送），抄送商务（现在是发给销售的）",null,"高","销售","kylie/Famas",40,"2023-09-13"]
[null,"Molly","新功能","海外的package为固定搭配，探头只增不减不换，标配探头在婷婷导入的文件增加打勾标识标识是标配，\n选中这个机型的时候，标配探头默认选中不能修改",null,"中","销售","kylie/Famas","需求未定，需讨论"]
[null,"","新功能","1.手机适配",null,"低",null,"kylie/Famas"]
[null,"hayley",null,"1国内机型搜索，根据描述，存货档案名称等搜索物料在那些机型下使用",null,"中","市场部","kylie/Famas",3]
[null,null,null,"2.销售配置单页面根据物料Vcode/IPN/描述/备注等搜索物料所使用的机型",null,"中","市场部","kylie/Famas",3]
[null,"Candice","新功能","应有个离职人员定时任务：维护好离职人员的离职时间",null,null,null,"kylie/Famas"]
[null,null,null,"常规易用性，便捷性，bug 修复",null,null,null,"kylie/Famas",10]
[null,"Daisy","新功能","一个物料在不同机型的所属分类可能是不同的，比如物料A在机型1中是Module1,在机型2中是Module2"]
[null,"Hayley","新功能","国内机型从主机从待售变成在售，标配，电源线说明书也要变成在售"]

{"sheet":"发货流程","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"发货单相关表","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,0,12,0]]}
["配置单页面"]
[]
["OrderConfiguration","属性","类型","说明"]
[null,"Number","string","配置单号"]
[null,"OrderId","string","订单号"]
[null,"OrderNumber","string","订单号"]
[null,"Item","Arry","配置单相关物料"]
[null,"Status","int","1，草稿，2，审核"]
[null,"IsDeleted","bool","是否删除"]
[null,"LastUodateTime","time","最后更新时间"]
[null,"LastUpdateId","string","最后更新人"]
[null,"CreatTime","time","创建时间"]
[null,"CreatId","string","创建人"]