{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,59,0],[60,0,64,0],[65,0,73,0],[2,1,6,1],[7,1,15,1],[16,1,25,1],[26,1,35,1],[36,1,37,1],[38,1,45,1],[48,1,59,1],[60,1,64,1],[65,1,73,1],[10,2,15,2],[17,2,18,2],[20,2,21,2],[22,2,25,2],[26,2,29,2],[30,2,31,2],[32,2,34,2],[38,2,39,2],[40,2,41,2],[44,2,45,2],[46,2,47,2],[50,2,51,2],[52,2,55,2],[56,2,57,2],[58,2,59,2],[52,3,54,3],[2,4,6,4],[7,5,15,5],[16,5,25,5],[26,5,35,5],[65,5,73,5],[49,6,59,6]]}
["业务中台功能清单"]
["项目","功能分类","功能管理","具体事务","功能说明","备注","解读","e码头是否明确支持","优化","新增","优化新增预估时间"]
["业务中台","组织架构管理","用户管理",null,"1.基于公司组织进行数据及接口的隔离；\n2.基于角色与用户管理对应应用单元的权限控制。",null,null,"Y"]
[null,null,"角色权限管理",{"$nulls":4},"Y"]
[null,null,"角色管理",{"$nulls":4},"Y"]
[null,null,"岗位管理",{"$nulls":4},"Y"]
[null,null,"组织架构管理",{"$nulls":4},"Y"]
[null,"库存中心","库存明细",null,"平台商品库存变动记录",null,null,"Y"]
[null,null,"库存事务单据",null,"库存变动单据类型，进销存及仓库出入库记录",null,null,"Y"]
[null,null,"仓库管理",null,"实体仓、虚拟仓、门店仓维护",null,null,"Y"]
[null,null,"库存类型","共享库存","全渠道统一分配库存，由业务中台通知各业务渠道库存的变动，为避免超卖，需要订单中台对库存进行预占和审核。",null,"需要了解“渠道”的界定，“审核”机制。另，库存预占具备。","不明确。保税仓本身就是共享库存。（库存预占具备）"]
[null,null,null,"大促库存","渠道库存中适用于秒杀活动的库存分配，同时需要独立服务支持高并发处理及库存缓存机制。",null,"需要了解哪些业务环节参与“秒杀”，其承担的具体业务任务。","不明确"]
[null,null,null,"渠道库存","分配业务渠道独享库存",null,null,"Y"]
[null,null,null,"可售库存","与渠道销售平台进行库存同步",null,"对同步的理解，1.一般采取盘点对帐方式进行。2.也可以同步库存数据，形成差异后，由业务处理差异，再决定是否同步。","有可售库存，但同步方式不明确"]
[null,null,null,"库存预警","根据库存区间进行设置安全库存，支持预警提醒",null,"理解，库存减扣到一定数据，由电商进行采购预警。我司为电商商户提供库存管理，只向电商反馈库存结果。","不明确"]
[null,null,null,"库存控制","1.库存类型可以允许超过实际库存上限（例如预售）\n2.根据实际库存按比例分配渠道",null,"理解，“允许超过实际库存上限”，必须要有系统上的库存数据，但可能无实际库存实物，才能发生“预售”","N",null,"需要了解如何增加预售库存具体需求业务，方可实现","2周"]
[null,null,"商品列表","商品管理列表","全平台商品列表，支持批量维护",null,null,"Y"]
[null,null,"商品新增","自营商品新增","同步进销存的商品信息",null,null,"Y"]
[null,null,null,"商家商品新增","同步前端业务系统中的商家的商品信息。",null,null,"Y"]
[null,null,"组合商品","组合商品维护","将两个实物商品组建成一个新的商品提供前端渠道售卖",null,"理解，需要了解组成的规则，由电商系统完成","N",null,"需要根据具体业务规则，方能实现","2周"]
[null,null,"商品价格管理","价格预警","基于配置对商品最终成交价与建议零售价、成本价进行对比判断定义阈值，当业务渠道出现超阈值时进行预警提醒或基于订单审核做处理。",null,"理解，由电商系统完成。","N",null,"可以实现","3天"]
[null,null,null,"建议零售价","维护平台自营商品建议零售价同步到前端售卖渠道",null,"理解，由电商系统完成。","N",null,"电商系统已实现"]
[null,null,"商品设置","品牌管理","商品品牌维护",null,"理解，由电商系统完成。","N",null,"电商系统已实现"]
[null,null,null,"类目管理","商品类目维护，基于商品类目可以对商品进行批量维护",null,"理解，由电商系统完成。","N",null,"电商系统已实现"]
[null,null,null,"商品服务",null,null,"理解，由电商系统完成。","N",null,"电商系统实现","3天"]
[null,null,null,"属性管理（增加支持跨境）","商品的类型包括但不限于：完税商品，跨境商品，免税商品，虚拟商品，不同商品类型支持对商品赋予相应的额外字段",null,"1.完税商品是指一般贸易商品吗？2.免税具体是退税处理吗，因为海关商品一定会有税？3.虚拟商品指哪类型的商品？","支持跨境电商所属海关商品编码对应的税率。其它需要明确"]
[null,"订单中心","设置","订单规则配置","基于订单类型设置相应的订单推送规则以及时效处理，例如延迟推单等",null,"理解，由电商系统完成。","N",null,"电商系统可以实现","3天"]
[null,null,null,"超时预警设置","订单超时预警、售后超时预警（异常事件超时预警优先级降低）",null,"理解，由电商系统完成。","N",null,"电商系统可以实现","3天"]
[null,null,null,"订单审核","平台订单支持基于库存，价格阈值进行处理，将订单归于异常订单待人工审核",null,null,"N",null,"可以实现","4天"]
[null,null,null,"订单类型","线上：跨境、免税预约、一件代发、第三方商家、预售订单 线下：门店收银  并支持扩展类型与前端渠道系统进行对接",null,"一件代发不再支持。\n需要明确，支持扩展类型与前端渠道系统进行对接","线上：跨境、免税预约（无）、一件代发（无）、第三方商家、预售订单（无）。 线下：门店收银  并支持扩展类型与前端渠道系统进行对接（不明确）",null,"免税预约，预售订单需要了了解具体需求，可以实现。","预估1周"]
[null,null,"预警监控","订单超时预警",null,null,null,"N（同上）",null,"可以实现","3天"]
[null,null,null,"售后超时预警",null,null,null,"N（同上）",null,"可以实现","3天"]
[null,null,"系统订单管理","订单物流管理","订单物流信息查看，对物流路由进行解析",null,null,"N",null,"可以实现","3天"]
[null,null,null,"订单列表","全平台订单列表，支持基于渠道、类型、状态过滤",null,null,"Y"]
[null,null,null,"订单审核列表","对异常订单或需要人工审核的订单列表",null,null,"Y"]
[null,null,"售后订单管理","售后单管理",null,null,null,"N",null,"根据具体业务确定后，可以实现","预估2周"]
[null,"渠道中心","商家管理",null,"有前端业务渠道同步商家信息",null,null,"Y"]
[null,null,"门店管理",null,"维护门店信息与对应门店收银系统对接",null,null,"Y"]
[null,"报关中心","口岸列表","关口限额","口岸规则、每日限额、每单限额、年度限额等信息",null,null,"N",null,"每单限额可以实现","3天"]
[null,null,null,"关口基本信息","海关编号、口岸编号、口岸名称",null,null,"Y"]
[null,null,"税率表单","税率表单","关税税率、增值税率、消费税率、综合税率配置、商品类别名称、商品税则号",null,null,"Y"]
[null,null,null,"税率表单详情","关税税率、增值税率、消费税率、综合税率配置、商品类别名称、商品税则号",null,null,"Y"]
[null,null,"报关基本信息配置","框架参数配置","跨境商户号、电商平台互联网域名、平台编号、电商平台名称、交易所商家编号等",null,null,"Y"]
[null,null,"跨境订单列表","根据报备拆跨境订单","根据不同的口岸、类型、拆分跨境的订单",null,"理解，应由电商系统拆分","N",null,"电商系统可以实现","10天"]
[null,null,"报关清关","清关详情","海关回执信息",null,null,"Y"]
[null,null,null,"清关列表","海关回执列表",null,null,"Y"]
[null,null,"财务对账中心","应付","全平台订单退款信息，对应退款类型及明细",null,"理解，应由电商系统完成","Y"]
[null,null,null,"应收","全平台订单收款信息，对应订单支付类型、优惠明细",null,"理解，应由电商系统完成","Y"]
[null,"支付分账中心","订单支付",null,"订单支付流水信息",null,"理解，应由电商系统完成","Y"]
[null,null,"分账列表",null,"对应商家、供应商分账列表",null,"有，由独立系统已经实现","Y"]
[null,null,"供应商管理","商家管理","同步前端业务系统商家信息",null,null,"Y"]
[null,null,null,"供应商管理","同步进销存供应商信息",null,null,"Y"]
[null,null,"结算配置","结算配置","包含商家基础结算设置",null,null,"Y"]
[{"$nulls":4},"商品类型结算设置",null,null,"Y"]
[{"$nulls":4},"商家商品结算设置",null,null,"Y"]
[null,null,null,"平台结算配置","自营商品分账设置",null,null,"Y"]
[null,null,"商家分账","结算凭证","基于结算规则，根据订单不同状态进行结算凭证生成",null,null,"Y"]
[null,null,null,"财务结算单","将同一供应商的结算凭证进行归集生成财务结算单",null,null,"Y"]
[null,null,"分账明细","分账明细列表","分账列表，包含相关订单、相关账单、支付平台流水、商品交易订单号、分账状态、支付金额、支付状态、分账状态",null,null,"Y"]
[null,null,null,"分账详情",null,null,null,"Y"]
["公用服务",null,"实名认证",null,"实名信息校验",null,"电商平台已有","Y"]
[null,null,"消息提醒",null,"短信对接",null,null,"Y"]
[null,null,"物流系统对接",null,"直连快递公司或快递100物流信息查询",null,"有直接对接物流公司，也有对接的菜鸟物流信息","Y"]
[null,null,"跨境179支付单回调查询",null,"跨境支付流水查询",null,"支付原始报文数据","Y"]
[null,null,"银联对接",null,"银联分账、支付、跨境汇款对接",null,"理解，1.支付由电商系统完成。2.银联分帐","N",null,"根据具体对接接口，可以实现","需要评估银联分账、支付、跨境汇款具体接口。预估4周"]
["系统对接",null,"供应商档案接口",null,"进销存","1.进销存：供应商、物料同步，库存更新，订单推送，订单状态更新\n2.仓库：订单推送，订单状态更新\n3.会员系统：订单推送，商品查询\n4.业务系统：商家同步，商品同步，库存更新与通知，订单推送，订单状态更新\n5.外部erp：订单接入，商品同步","从外部拉到接口无，但我司系统有维护商户档案","N",null,"根据业务，确定拉取标准接口，可以实现","5天"]
[null,null,"商品档案读取接口/写入接口",null,"进销存、业务系统",null,"从外部拉到接口无，我司系统有维护商品档案","N",null,"根据业务，确定拉取标准接口，可以实现","5天"]
[null,null,"销售订单推送接口",null,"会员系统、进销存、仓库",null,null,"Y"]
[null,null,"发货单生成以及订单接口",null,"仓库、业务系统",null,null,"Y"]
[null,null,"订单发货状态查询接口",null,"业务系统",null,null,"Y"]
[null,null,"仓库管理出入库业务接口",null,"仓库",null,null,"Y"]
[null,null,"订单接入接口",null,"外部ERP系统",null,null,"Y"]
[null,null,"跨境对应接口",null,"业务系统",null,"需要了解具体接口","不明确"]
[null,null,"库存通知，同步接口",null,"业务系统，进销存",null,"同步接口要看具体接口。","库存通知具备，其它要明确。"]