{"text_format":"2","workbook":"xlsx","n_sheets":16,"sheets":["设计思路","接口清单","创建物料档案","查询物料分类","查询物料档案","创建BOM","查询BOM","创建文档","查询文档分类","查询文档","创建物料文档关联","查询物料文档关联","查询采购在途","查询在库库存","查询生产在制","查询所有物料档案"],"not_rendered":{"charts":0,"images":3,"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":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,14,0]]}
["类型","序号","接口名称","动作","状态","接口方向（源）","接口方向（目标）","接口方式","接口名称","备注"]
["PLM& 数据中台系统集成",1,"创建物料","回写","审核","数据中台","PLM","API","CreateItemMaster"]
[null,2,"查询物料分类","查询","无","PLM","数据中台","API","QueryItemCategory","增补"]
[null,3,"查询物料档案","查询","无","PLM","数据中台","API","QueryItemMaster"]
[null,4,"创建BOM","回写","归档","数据中台","PLM","API","CreateBOM"]
[null,5,"查询BOM","查询","归档","PLM","数据中台","API","QueryBOM"]
[null,6,"创建文档","回写","审核","数据中台","PLM","API","CreateDocument"]
[null,7,"查询文档文档","查询","所有","PLM","数据中台","API","QueryDocumentCategory","增补"]
[null,8,"查询文档","查询","无","PLM","数据中台","API","QueryDocument"]
[null,9,"创建物料文档关联","回写","审核","数据中台","PLM","API","CreateRelationItemDoc"]
[null,10,"查询物料文档关联","查询","审核","PLM","数据中台","API","QueryRelationItemDoc"]
[null,11,"查询采购采购在途物料","查询","无","PLM","数据中台","API","QueryGoodsInTransit"]
[null,12,"查询在库库存信息","查询","无","PLM","数据中台","API","QueryGoodsInStock"]
[null,13,"查询生产在制产品","查询","无","PLM","数据中台","API","QueryGoodsInProcess"]
[null,14,"查询所有物料档案","查询","无","PLM","数据中台","API","QueryALllItemMaster","增补"]

{"sheet":"创建物料档案","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[15,0,15,5],[16,0,16,5]]}
["创建物料CreateItemMaster"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"PARTID","物料编码",100,"nvarchar","Y"]
[2,"PARTVAR","物料版本",100,"nvarchar","Y","物料的版本规则是什么，是PLM定还是我们系统来定","料号版本是自定义的，类似U8维护的版本信息"]
[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,"BACKUP1","备用栏位",100,"nvarchar","N","备用栏位记录ECO单号"]
[11,"CCREATOR","创建人",100,"nvarchar","Y","这个创建人是PLM账号ID吗？","用户名"]
[12,"CCREATORDATE","创建日期",null,"datetime","Y"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]

{"sheet":"查询物料分类","index":3,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[7,0,7,5],[6,0,6,5],[12,0,12,5]]}
["查询物料分类-QueryItemCategory"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"CTYPEID","分类编号",null,"nvarchar","N"]
[2,"CPARENTID","父分类编号",null,"nvarchar","N"]
[3,"CCREATORDATE","创建日期",null,"datetime","N"]
["查询参数至少输入一项"]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]
["Data返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"CTYPEID","物料分类ID",null,"int","Y"]
[2,"CTYPENAME","物料分类名称",100,"nvarchar","N"]
[3,"CPARENTID","物料父分类ID",null,"int","N"]
[4,"CPARENTNAME","物料父分类名称",100,"nvarchar","N"]
[5,"CTYPEBACKUP1","备用字段1",100,"nvarchar","N"]
[6,"CTYPEBACKUP2","备用字段2",100,"nvarchar","N"]
[7,"CCREATOR","创建人",100,"nvarchar","Y"]
[8,"CCREATORDATE","创建日期",null,"datetime","Y"]

{"sheet":"查询物料档案","index":4,"n_rows":30,"n_cols":8,"rows_kept":30,"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]]}
["查询物料档案QueryItemMaster"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"PARTID","物料编码",100,"nvarchar","N","这个应该是必填项吧？这个是对应物料的IPN号？","查询条件物料编码非必填项，例如根据名称可以模糊查询出多个料品档案"]
[2,"PARTNAME","物料名称",100,"nvarchar","N"]
[3,"PARTSPEC","规格型号",100,"nvarchar","N"]
[4,"PARTVAR","物料版本",100,"nvarchar","N"]
[5,"CCREATOR","创建人",100,"nvarchar","N"]
[6,"CCREATORDATE","创建日期",null,"datetime","Y->N","这个不应该是必填项","创建日期非必填项,但四项至少一项必填"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[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":5,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[18,0,18,5],[19,0,19,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,"BACKUP1","备用栏位",100,"nvarchar","N","备用栏位记录ECO单号"]
[6,"CCREATOR","创建人",100,"nvarchar","Y"]
[7,"CCREATORDATE","创建日期",null,"datetime","Y"]
[8,"Details","子表集合","信息如下"]
[1,"PARTID","物料编码",100,"nvarchar","Y"]
[2,"PARTVAR","物料版本",100,"nvarchar","Y"]
[3,"ASSEMBLELEVEL","层次号",null,"int","Y->N","3-7这些都不是特别清楚怎么设置  ","==>已调整，中台系统不考虑，整套BOM传入接口时自动处理层次号、序列号、父项序列号"]
[4,"COUNTS","节点数量",100,"nvarchar","Y","子件单倍用量"]
[5,"SEQNUM","序列号",100,"nvarchar","Y->N"]
[6,"FREZONBOMBACKUP3","父项序列号",100,"nvarchar","Y->N"]
[7,"TOTALWEIGHT","重总",100,"nvarchar","Y->N","子件单位重量"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]

{"sheet":"查询BOM","index":6,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[11,0,11,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,"PARTID","物料编码",100,"nvarchar","N"]
[6,"PARTVAR","物料版本",100,"nvarchar","N"]
[7,"CCREATOR","创建人",100,"nvarchar","N"]
[8,"CCREATORDATE","创建日期",null,"datetime","Y"]
["查询参数至少输入一项"]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]
["Data LIST 返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[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 List","子表集合","信息如下"]
[1,"PARTID","物料编码",100,"nvarchar","Y"]
[2,"PARTVAR","物料版本",100,"nvarchar","Y"]
[3,"ASSEMBLELEVEL","层次号",null,"int","Y->N"]
[4,"COUNTS","节点数量",100,"nvarchar","Y"]
[5,"SEQNUM","序列号",100,"nvarchar","Y->N"]
[6,"FREZONBOMBACKUP3","父项序列号",100,"nvarchar","Y->N"]
[7,"TOTALWEIGHT","重总",100,"nvarchar","Y->N"]
[]
[]
["这个是查询BOM，但是没有根据物料查询相关联的其他BOM的接口，因为一个物料的变更，可能会影响其他产品，进而影响其他BOM,需要同步更新的"]
["==》 已加上子件编码作为查询条件,查询单阶BOM，不递归"]

{"sheet":"创建文档","index":7,"n_rows":20,"n_cols":8,"rows_kept":20,"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定还是我们系统来定","没有固定规则，一般为10、20、30"]
[3,"CDOCUMENTNAME","文档名称",512,"nvarchar","Y"]
[4,"CDFORMAT","格式",50,"nvarchar","Y","文件格式都有哪些，需要接口？","不需要，自定义格式， PDF、SW等"]
[5,"CFILE","文件流",null,"object","Y"]
[6,"CMKIND","文档分类",50,"nvarchar","Y","文件分类都有哪些，需要接口？","可以做成接口，或一次性导入"]
[7,"VALIDTIME","生效时间",null,"datetime","Y","生效时间是指什么时间，创建物料里就没有生效时间","生效日期可以默认为创建日期"]
[8,"TRASHTIME","失效时间",null,"datetime","N"]
[9,"BACKUP1","备用栏位",100,"nvarchar","N","备用栏位记录ECO单号"]
[10,"CCREATOR","创建人",100,"nvarchar","Y"]
[11,"CCREATORDATE","创建日期",null,"datetime","Y"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]

{"sheet":"查询文档分类","index":8,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[6,0,6,5],[7,0,7,5],[12,0,12,5]]}
["查询文档分类-QueryDocumentCategory"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"CMKINDID","文档分类编号",null,"nvarchar","N"]
[2,"CMPARENTID","文档父分类编号",null,"nvarchar","N"]
[3,"CCREATORDATE","创建日期",null,"datetime","N"]
["查询参数至少输入一项"]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"Data","数据",null,"object"]
["Data返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"CMKINDID","文档分类编号",null,"int","Y"]
[2,"CMKINDNAME","文档分类名称",100,"nvarchar","Y"]
[3,"CMPARENTID","文档父分类编号",null,"int","N"]
[4,"CMPARENTID","文档父分类名称",100,"nvarchar","N"]
[5,"CCREATOR","创建人",100,"nvarchar","Y"]
[6,"CCREATORDATE","创建日期",null,"datetime","Y"]

{"sheet":"查询文档","index":9,"n_rows":25,"n_cols":8,"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->N","这个不应该是必填项","非必填项"]
["查询参数至少输入一项"]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[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":10,"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]]}
["创建物料文档关联CreateRelationItemDoc"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[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对多",null,"==》 是的，1-N关系"]

{"sheet":"查询物料文档关联","index":11,"n_rows":37,"n_cols":8,"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]]}
["查询物料文档关联-QueryRelationItemDoc"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[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->N","这个不应该是必填项","非必填项"]
["查询参数至少输入一项"]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[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"]
[]
["这个接口是否只能返回一个关联文档，可能一个物料的关联文档不止一个",null,null,null,"=》 是的，1-N关系,可能返回多笔"]

{"sheet":"查询采购在途","index":12,"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":13,"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":14,"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"]

{"sheet":"查询所有物料档案","index":15,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[6,0,6,5],[12,0,12,5]]}
["查询所有物料档案QueryALllItemMaster"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"返回页序列","PageIndex",null,"Int","Y"]
[2,"每页数量","PageSize",null,"Int","Y"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"TotalSiza","总数量",null,"Int"]
[4,"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"]