{"text_format":"2","workbook":"xlsx","n_sheets":12,"sheets":["设计思路","创建物料档案","查询物料档案","创建BOM","查询BOM","创建文档","查询文档","创建物料文档关联","查询物料文档关联","查询采购在途","查询在库库存","查询生产在制"],"not_rendered":{"charts":0,"images":2,"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":"设计思路","index":0,"n_rows":40,"n_cols":1,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,0,38,13],[39,0,39,13]]}
{"$rows_empty":38}
["1.   ECR阶段：从客开系统开始，通过接口从PLM获取物料、BOM、文档信息，通过接口从U8获取初步影响的库存、在途订单、在制工单信息，无信息返回到PLM；"]
["2.   ECO-Part1阶段：从客开系统开始，通过接口从PLM获取物料、BOM、文档信息，通过接口从U8获取影响范围内的库存、在途订单、在制工单信息；流程结束后通过接口返回变更后的物料、BOM、文档信息，PLM接受到信息后对物料、BOM、文档进行版本更新；"]

{"sheet":"创建物料档案","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[14,0,14,5],[15,0,15,5]]}
["创建物料CreateItemMaster"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"PARTID","物料编码",100,"nvarchar","Y"]
[2,"PARTVAR","物料版本",100,"nvarchar","Y","物料的版本规则是什么，是PLM定还是我们系统来定"]
[3,"CHINANAME","物料名称",100,"nvarchar","Y"]
[4,"PARTFIXEDBACK3","分类",100,"nvarchar","Y","这个如果是必填，需要提供接口，有哪些分类"]
[5,"KIND","种类",100,"nvarchar","N"]
[6,"SOURCE","属性",100,"nvarchar","N"]
[7,"MATERIAL","材料",100,"nvarchar","N"]
[8,"SPEC","规格",100,"nvarchar","N"]
[9,"MODEL","型号",100,"nvarchar","N"]
[10,"CCREATOR","创建人",100,"nvarchar","Y","这个创建人是PLM账号ID吗？"]
[11,"CCREATORDATE","创建日期",null,"datetime","Y"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]

{"sheet":"查询物料档案","index":2,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[7,0,7,5],[8,0,8,5],[13,0,13,5]]}
["查询物料档案QueryItemMaster"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"PARTID","物料编码",100,"nvarchar","N","这个应该是必填项吧？这个是对应物料的IPN号？"]
[2,"PARTVAR","物料版本",100,"nvarchar","N"]
[3,"CCREATOR","创建人",100,"nvarchar","N"]
[4,"CCREATORDATE","创建日期",null,"datetime","Y","这个不应该是必填项"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]
["Data返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"PARTID","物料编码",100,"nvarchar","Y"]
[2,"PARTVAR","物料版本",100,"nvarchar","Y"]
[3,"CHINANAME","物料名称",100,"nvarchar","Y"]
[4,"PARTFIXEDBACK3","分类",100,"nvarchar","Y"]
[5,"KIND","种类",100,"nvarchar","N"]
[6,"SOURCE","属性",100,"nvarchar","N"]
[7,"MATERIAL","材料",100,"nvarchar","N"]
[8,"SPEC","规格",100,"nvarchar","N"]
[9,"MODEL","型号",100,"nvarchar","N"]
[10,"CCREATOR","创建人",100,"nvarchar","Y"]
[11,"CCREATORDATE","创建日期",null,"datetime","Y"]
[12,"CEDITOR","修改人",100,"nvarchar","N"]
[13,"CEDITTIME","修改日期",null,"datetime","N"]

{"sheet":"创建BOM","index":3,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[17,0,17,5],[18,0,18,5]]}
["创建BOM-CreateBOM"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"BOMNAME","BOM名称",100,"nvarchar","Y"]
[2,"BOMVAR","BOM版本",100,"nvarchar","Y"]
[3,"PARENTID","父项编码",100,"nvarchar","Y"]
[4,"FATHERPARTVAR","父项版本",100,"nvarchar","Y"]
[5,"CCREATOR","创建人",100,"nvarchar","Y"]
[6,"CCREATORDATE","创建日期",null,"datetime","Y"]
[7,"Details","子表集合","信息如下"]
[1,"PARTID","物料编码",100,"nvarchar","Y"]
[2,"PARTVAR","物料版本",100,"nvarchar","Y"]
[3,"ASSEMBLELEVEL","层次号",null,"int","Y","3-7这些都不是特别清楚怎么设置"]
[4,"COUNTS","节点数量",100,"nvarchar","Y"]
[5,"SEQNUM","序列号",100,"nvarchar","Y"]
[6,"FREZONBOMBACKUP3","父项序列号",100,"nvarchar","Y"]
[7,"TOTALWEIGHT","重总",100,"nvarchar","Y"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]

{"sheet":"查询BOM","index":4,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["查询BOM-QueryBOM"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"BOMNAME","BOM名称",100,"nvarchar","N"]
[2,"BOMVAR","BOM版本",100,"nvarchar","N"]
[3,"PARENTID","父项编码",100,"nvarchar","N"]
[4,"FATHERPARTVAR","父项版本",100,"nvarchar","N"]
[5,"CCREATOR","创建人",100,"nvarchar","N"]
[6,"CCREATORDATE","创建日期",null,"datetime","Y"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]
["Data返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"BOMNAME","BOM名称",100,"nvarchar","Y"]
[2,"BOMVAR","BOM版本",100,"nvarchar","Y"]
[3,"PARENTID","父项编码",100,"nvarchar","Y"]
[4,"FATHERPARTVAR","父项版本",100,"nvarchar","Y"]
[5,"CCREATOR","创建人",100,"nvarchar","Y"]
[6,"CCREATORDATE","创建日期",null,"datetime","Y"]
[7,"Details","子表集合","信息如下"]
[1,"PARTID","物料编码",100,"nvarchar","Y"]
[2,"PARTVAR","物料版本",100,"nvarchar","Y"]
[3,"ASSEMBLELEVEL","层次号",null,"int","Y"]
[4,"COUNTS","节点数量",100,"nvarchar","Y"]
[5,"SEQNUM","序列号",100,"nvarchar","Y"]
[6,"FREZONBOMBACKUP3","父项序列号",100,"nvarchar","Y"]
[7,"TOTALWEIGHT","重总",100,"nvarchar","Y"]
[]
[]
["这个是查询BOM，但是没有根据物料查询相关联的其他BOM的接口，因为一个物料的变更，可能会影响其他产品，进而影响其他BOM,需要同步更新的"]

{"sheet":"创建文档","index":5,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["创建文档-CreateDocument"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"CDOCUMENTID","文档编码",50,"nvarchar","Y","文件编码是否有固定规则"]
[2,"CDOCUMENTVER","文档版本",20,"nvarchar","Y","文件版本的升级规则的什么，是PLM定还是我们系统来定"]
[3,"CDOCUMENTNAME","文档名称",512,"nvarchar","Y"]
[4,"CDFORMAT","格式",50,"nvarchar","Y","文件格式都有哪些，需要接口？"]
[5,"CFILE","文件流",null,"object","Y"]
[6,"CMKIND","文档分类",50,"nvarchar","Y","文件分类都有哪些，需要接口？"]
[7,"VALIDTIME","生效时间",null,"datetime","Y","生效时间是指什么时间，创建物料里就没有生效时间"]
[8,"TRASHTIME","失效时间",null,"datetime","N"]
[9,"CCREATOR","创建人",100,"nvarchar","Y"]
[10,"CCREATORDATE","创建日期",null,"datetime","Y"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]

{"sheet":"查询文档","index":6,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[7,0,7,5],[8,0,8,5],[13,0,13,5]]}
["查询文档-QueryDocument"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"CDOCUMENTID","文档编码",50,"nvarchar","N","这个应该是必填项"]
[2,"CDOCUMENTVER","文档版本",20,"nvarchar","N"]
[3,"CCREATOR","创建人",100,"nvarchar","N"]
[4,"CCREATORDATE","创建日期",null,"datetime","Y","这个不应该是必填项"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]
["Data返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"CDOCUMENTID","文档编码",50,"nvarchar","Y"]
[2,"CDOCUMENTVER","文档版本",20,"nvarchar","Y"]
[3,"CDOCUMENTNAME","文档名称",512,"nvarchar","Y"]
[4,"CDFORMAT","格式",50,"nvarchar","Y"]
[5,"CFILE","文件流",null,"object","Y"]
[6,"CMKIND","文档分类",50,"nvarchar","Y"]
[7,"VALIDTIME","生效时间",null,"datetime","Y"]
[8,"TRASHTIME","失效时间",null,"datetime","N"]
[9,"CCREATOR","创建人",100,"nvarchar","Y"]
[10,"CCREATORDATE","创建日期",null,"datetime","Y"]

{"sheet":"创建物料文档关联","index":7,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[10,0,10,5]]}
["创建物料文档关联CreateRelationInvDoc"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"PARTID","物料编码",100,"nvarchar","Y"]
[2,"PARTVAR","物料版本",100,"nvarchar","Y"]
[3,"CDOCUMENTID","文档编码",50,"nvarchar","Y"]
[4,"CDOCUMENTVER","文档版本",20,"nvarchar","Y"]
[10,"CCREATOR","创建人",100,"nvarchar","Y"]
[11,"CCREATORDATE","创建日期",null,"datetime","Y"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]
[]
[]
["物料文件关联关系是否为1对多"]

{"sheet":"查询物料文档关联","index":8,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[9,0,9,5],[10,0,10,5],[15,0,15,5]]}
["查询物料文档关联-QueryRelationInvDoc"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"PARTID","物料编码",100,"nvarchar","N","应是必填项"]
[2,"PARTVAR","物料版本",100,"nvarchar","N"]
[3,"CDOCUMENTID","文档编码",50,"nvarchar","N"]
[4,"CDOCUMENTVER","文档版本",20,"nvarchar","N"]
[5,"CCREATOR","创建人",100,"nvarchar","N"]
[6,"CCREATORDATE","创建日期",null,"datetime","Y","这个不应该是必填项"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]
["Data返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"PARTID","物料编码",100,"nvarchar","Y"]
[2,"PARTVAR","物料版本",100,"nvarchar","Y"]
[3,"CHINANAME","物料名称",100,"nvarchar","Y"]
[4,"PARTFIXEDBACK3","分类",100,"nvarchar","Y"]
[5,"KIND","种类",100,"nvarchar","N"]
[6,"SOURCE","属性",100,"nvarchar","N"]
[7,"MATERIAL","材料",100,"nvarchar","N"]
[8,"SPEC","规格",100,"nvarchar","N"]
[9,"MODEL","型号",100,"nvarchar","N"]
[10,"CDOCUMENTID","文档编码",50,"nvarchar","Y"]
[11,"CDOCUMENTVER","文档版本",20,"nvarchar","Y"]
[12,"CDOCUMENTNAME","文档名称",512,"nvarchar","Y"]
[13,"CDFORMAT","格式",50,"nvarchar","Y"]
[14,"CMKIND","文档分类",50,"nvarchar","Y"]
[15,"VALIDTIME","生效时间",null,"datetime","Y"]
[16,"TRASHTIME","失效时间",null,"datetime","N"]
[17,"CCREATOR","创建人",100,"nvarchar","Y"]
[18,"CCREATORDATE","创建日期",null,"datetime","Y"]
[]
["这个接口是否只能返回一个关联文档，可能一个物料的关联文档不止一个"]

{"sheet":"查询采购在途","index":9,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[40,0,40,5],[41,0,41,5]]}
["查询采购采购在途物料：QueryGoodsInTransit"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"InvCode","物料代码",null,"nvarchar","Y"]
[2,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"POCode","采购订单号",50,"nvarchar","Y"]
[2,"Sequence","采购订单行号",null,"int","Y"]
[3,"VenCode","供应商代码",50,"nvarchar","N"]
[4,"DepCode","部门代码",50,"nvarchar","N"]
[5,"PersonCode","业务员代码",50,"nvarchar","N"]
[6,"POType","类型（1:标准，2:委外）",null,"int","N"]
[7,"InvCode","物料代码",50,"nvarchar","Y"]
[8,"InvName","产品名称",200,"nvarchar","N"]
[9,"InvStd","规格型号",200,"nvarchar","N"]
[10,"Quantity","数量",null,"float","Y"]
[11,"Amount","辅计量数量",null,"float","N"]
[12,"UnitPrice","原币无税单价 ",null,"float","N"]
[13,"iMoney","原币无税金额 ",null,"float","N"]
[14,"iTaxPrice ","原币含税单价",null,"float","N"]
[15,"iPerTaxRate","税率",null,"float","N"]
[16,"iTax","原币税额",null,"float","N"]
[17,"iSum ","原币价税合计 ",null,"float","N"]
[18,"Currency","币种",50,"nvarchar","N"]
[19,"nFlat ","汇率",null,"float","N"]
[20,"Status","行状态（1：开立，2：审核，3：关闭）",null,"int","Y"]
[21,"dArriveDate","计划到货日期 ",null,"Datetime","N"]
[22,"cMemo ","头备注",255,"nvarchar","N"]
[23,"cbMemo ","行备注",255,"nvarchar","N"]
[24,"CreatePerson","创建人",50,"nvarchar","N"]
[25,"CreateDateTime","创建时间",50,"nvarchar","N"]
[26,"dEndDate ","停用日期",null,"Datetime","N"]
[27,"cModifyPerson ","变更人",50,"nvarchar","N"]
[28,"dModifyDate ","变更日期",null,"Datetime","N"]
[29,"iReceivedQTY","累计到货数量",null,"float","N"]
[30,"DeliveryAddress","采购送货地址",200,"nvarchar","N"]
[31,"InvRecAddress","采购发票接收地址",200,"nvarchar","N"]
[32,"InvVersion","料品版本（扩展字段）",100,"nvarchar","N"]
[33,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]

{"sheet":"查询在库库存","index":10,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[26,0,26,5],[27,0,27,5]]}
["查询在库库存信息：QueryGoodsInStock"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"InvCode","物料代码",null,"nvarchar","Y"]
[2,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"cWhCode","仓库编码",50,"nvarchar","Y"]
[2,"cWhName","仓库名称",null,"int","Y"]
[3,"InvCode","物料代码",50,"nvarchar","Y"]
[4,"InvVersion","物料版本",50,"nvarchar","N"]
[5,"InvName","物料名称",200,"nvarchar","N"]
[6,"InvStd","规格型号",200,"nvarchar","N"]
[7,"cBatch ","批号",50,"nvarchar","N"]
[8,"Quantity","结存数量",null,"decimal(18,6)","Y"]
[9,"fOutQuantity ","待发货数量",null,"decimal(18,6)","N"]
[10,"fInQuantity","待入库数量",null,"decimal(18,6)","N"]
[11,"fAvaQuantity ","可用数量",null,"decimal(18,6)","Y"]
[12,"InvVersion","料品版本（扩展字段）",100,"nvarchar","N"]
[13,"Extension1","自由项1",50,"nvarchar","N"]
[14,"Extension2","自由项2",50,"nvarchar","N"]
[15,"Extension3","自由项3",50,"nvarchar","N"]
[16,"Extension4","自由项4",50,"nvarchar","N"]
[17,"Extension5","自由项5",50,"nvarchar","N"]
[18,"dModifyDate ","操作时间",null,"Datetime","N"]
[19,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]

{"sheet":"查询生产在制","index":11,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[25,0,25,5],[26,0,26,5]]}
["查询生产在制产品：QueryGoodsInProcess"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"InvCode","产品代码",null,"nvarchar","Y"]
[2,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"MOCode","生产订单号",50,"nvarchar","Y"]
[2,"Sequence","生产订单行号",null,"int","Y"]
[3,"DepCode","生产部门代码",50,"nvarchar","N"]
[4,"PersonCode","业务员代码",50,"nvarchar","N"]
[5,"MOStatus","生产状态：\n1: 初始, \n2: 下发, \n3: 关单",null,"int","N"]
[6,"InvCode","产品代码",50,"nvarchar","Y"]
[7,"InvName","产品名称",200,"nvarchar","N"]
[8,"InvStd","规格型号",200,"nvarchar","N"]
[9,"cBatch ","批号",50,"nvarchar","N"]
[10,"Quantity","数量",null,"float","Y"]
[11,"Status","行状态\n（1：开立，2：审核，3：关闭）",null,"int","Y"]
[12,"StartDate","计划开工日期 ",null,"Datetime","N"]
[13,"DueDate","计划完工日期 ",null,"Datetime","N"]
[14,"MOMemo","工单备注",255,"nvarchar","N"]
[15,"CreatePerson","创建人",50,"nvarchar","N"]
[16,"CreateDateTime","创建时间",50,"nvarchar","N"]
[17,"InvVersion","料品版本（扩展字段）",100,"nvarchar","N"]
[18,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]