{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["接口清单","查询采购在途和在检","查询在库库存","查询生产在制","查询所有物料档案","查询消耗量","查询收款列表信息","查询业务员","查询收款单最大编码","参考"],"not_rendered":{"charts":0,"images":6,"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":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,8,0]]}
["类型","序号","接口名称","动作","状态","接口方向（源）","接口方向（目标）","接口方式","接口名称"]
["U8接口开发",1,"查询采购采购在途在检","查询","无","U8","数据中台","API","QueryGoodsInTransit"]
[null,2,"查询在库库存信息","查询","无","U8","数据中台","API","QueryGoodsInStock"]
[null,3,"查询生产在制产品","查询","无","U8","数据中台","API","QueryGoodsInProcess"]
[null,4,"查询所有物料档案","查询","无","U8","数据中台","API","QueryALllItemMaster"]
[null,5,"查询消耗量","查询","无","U8","数据中台","API","QueryConsumption"]
[null,6,"查询收款列表信息","查询","无","U8","数据中台","API","QueryPaymentList"]
[null,7,"查询业务员","查询","无","U8","数据中台","API","QueryBusinessPersonnel"]
[null,8,"查询收款单最大编码","查询","无","U8","数据中台","API","QueryMaxReceipt"]

{"sheet":"查询采购在途和在检","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[6,0,6,5],[15,0,15,5],[16,0,16,5]]}
["查询采购采购在途物料：QueryGoodsInTransit"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"InvCode","物料代码","模糊查询","nvarchar"]
[2,"InvName","物料名称","模糊查询","nvarchar"]
[3,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"InvCode","物料代码",50,"nvarchar","Y"]
[2,"InvName","物料名称",200,"nvarchar","N"]
[3,"InvStd","规格型号",200,"nvarchar","N"]
[4,"InvVersion","料品版本（扩展字段）",100,"nvarchar","N"]
[6,"TransitQTY","订单累计在途量（不含已到货和入库）",null,"float","N"]
[7,"InspectionQTY","累计在检数量（已到货未入库）",null,"float","N"]
[8,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]
[]
["备注：","已审核的委外订单、采购订单 未交货数量"]

{"sheet":"查询在库库存","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[6,0,6,5],[21,0,21,5],[22,0,22,5]]}
["查询在库库存信息：QueryGoodsInStock"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"InvCode","物料代码","模糊查询","nvarchar"]
[2,"InvName","物料名称","模糊查询","nvarchar"]
[3,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"cWhCode","仓库编码",50,"nvarchar","Y"]
[2,"cWhName","仓库名称",null,"int","Y"]
[3,"InvCode","物料代码",50,"nvarchar","Y"]
[4,"InvName","物料名称",200,"nvarchar","N"]
[5,"InvStd","规格型号",200,"nvarchar","N"]
[6,"InvVersion","料品版本（扩展字段）",100,"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,"dModifyDate ","操作时间",null,"Datetime","N"]
[13,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]

{"sheet":"查询生产在制","index":3,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[6,0,6,5],[15,0,15,5],[16,0,16,5]]}
["查询生产在制产品：QueryGoodsInProcess"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"InvCode","产品代码","模糊查询","nvarchar"]
[2,"InvName","产品名称","模糊查询","nvarchar"]
[3,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"InvCode","产品代码",50,"nvarchar","Y"]
[2,"InvName","产品名称",200,"nvarchar","N"]
[3,"InvStd","规格型号",200,"nvarchar","N"]
[4,"InvVersion","料品版本（扩展字段）",100,"nvarchar","N"]
[5,"cBatch ","批号（可能为空）",50,"nvarchar","N"]
[6,"Quantity","累计在制数量",null,"float","Y"]
[7,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]
[]
[]
["备注：","已审核的生产订单 未交货数量"]

{"sheet":"查询所有物料档案","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[8,0,8,5],[9,0,9,5],[15,0,15,5]]}
["查询所有物料档案QueryALllItemMaster"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"返回页序列","PageIndex",null,"Int","Y"]
[2,"每页数量","PageSize",null,"Int","Y"]
[3,"InvCode","物料代码","模糊查询","nvarchar"]
[4,"InvName","物料名称","模糊查询","nvarchar"]
[5,"WorkPoint","站点",null,"nvarchar（30）","Y"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool","Y"]
[2,"Message","信息",200,"nvarchar"]
[3,"TotalSize","总数量",null,"Int"]
[4,"Data","数据",null,"object"]
["Data返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"InvCode","物料代码",50,"nvarchar","Y"]
[2,"InvName","物料名称",200,"nvarchar","N"]
[3,"InvStd","规格型号",200,"nvarchar","N"]
[4,"LeadTime","固定提前期",null,"float","Y"]

{"sheet":"查询消耗量","index":5,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[12,0,12,5],[29,0,29,5],[30,0,30,5]]}
["查询消耗量：QueryConsumption"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"InvCode","物料代码","模糊查询","nvarchar"]
[2,"InvName","物料名称","模糊查询","nvarchar"]
[3,"cWhCode","仓库编码","模糊查询","nvarchar"]
[4,"cWhName","仓库名称","模糊查询","nvarchar"]
[5,"cFree1","料品版本（扩展字段）",null,"nvarchar"]
[6,"BeginDate","开始日期","和审核日期比较","datetime","Y"]
[7,"EndDate","结束日期","和审核日期比较","datetime","Y"]
[8,"ReceiptType","单据类型","为List集合"]
[9,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"BusinessDate","单据日期",null,"datetime","N"]
[2,"ApplyDate","审核日期",null,"datetime","N"]
[3,"ReceiptCode","单据号",100,"nvarchar","N"]
[4,"ReceiptType","单据类型",50,"nvarchar","N"]
[5,"cWhCode","仓库编码",50,"nvarchar","Y"]
[6,"cWhName","仓库名称",100,"nvarchar","Y"]
[7,"InvCode","物料代码",50,"nvarchar","Y"]
[8,"InvName","物料名称",200,"nvarchar","N"]
[9,"InvStd","规格型号",200,"nvarchar","N"]
[10,"InvVersion","料品版本（扩展字段）",100,"nvarchar","N"]
[11,"cBatch ","批号（可能为空）",50,"nvarchar","N"]
[12,"fInQuantity","收入数量",null,"decimal(18,6)","Y"]
[13,"fOutQuantity ","发出数量",null,"decimal(18,6)","N"]
[14,"Quantity ","结存数量",null,"decimal(18,6)","N"]
[15,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]

{"sheet":"查询收款列表信息","index":6,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[7,0,7,5],[23,0,23,5],[24,0,24,5]]}
["查询收款列表信息：QueryPaymentList"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"ReceiptType","单据类型","为List集合"]
[2,"BeginDate","开始日期","和审核日期比较","datetime","Y"]
[3,"EndDate","结束日期","和审核日期比较","datetime","Y"]
[4,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"CusCode","客户编码",50,"nvarchar","Y"]
[2,"CusName","客户名称",200,"nvarchar"]
[3,"ReceiptCode","单据编号",50,"nvarchar"]
[4,"ReceiptDate","单据日期",null,"Datetime","N"]
[5,"DueDate","到期日",null,"Datetime","N"]
[6,"OriginalAmount","原币金额",null,"float"]
[7,"OriginalBalance","原币余额",null,"float"]
[8,"CanDiscounts","可享受折扣",null,"float","N"]
[9,"ThisDiscount","本次折扣",null,"float","N"]
[10,"AmountCollected","收款金额",null,"float"]
[11,"PersonnelName","业务员姓名",50,"nvarchar","N"]
[12,"Department ","部门名称",50,"nvarchar"]
[13,"SalesOrder","销售订单",50,"nvarchar"]
[14,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]

{"sheet":"查询业务员","index":7,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[15,0,15,5],[16,0,16,5]]}
["查询业务员：QueryBusinessPersonnel"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"SalesOrder","销售订单号","模糊查询","nvarchar"]
[2,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"SalesOrder","销售订单号",50,"nvarchar","Y"]
[2,"PersonnelCode","业务员编码",200,"nvarchar","N"]
[3,"PersonnelName","业务员名称",200,"nvarchar","N"]
[4,"CusCode","客户编码",200,"nvarchar","N"]
[5,"CusName","客户编码",200,"nvarchar","N"]
[6,"PerDepartmentCode","业务员部门编码",200,"nvarchar","N"]
[7,"PerDepartmentName","业务员部门名称",200,"nvarchar","N"]
[8,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]

{"sheet":"查询收款单最大编码","index":8,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[4,0,4,5],[8,0,8,5],[9,0,9,5]]}
["查询收款单最大编码：QueryMaxReceipt"]
["传入参数"]
["序号","字段名称","字段描述","备注","字符类型","必输"]
[1,"WorkPoint","站点",null,"nvarchar（30）","Y"]
["返回字段"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"MaxReceiptCode","收款单最大编码（当前已存在）",50,"nvarchar","Y"]
[2,"WorkPoint","站点",50,"nvarchar","N"]
[]
["返回参数"]
["序号","栏位名称","栏位名称","长度","字符类型","必输"]
[1,"IsSuccess","是否成功",null,"bool"]
[2,"Message","信息",200,"nvarchar"]

{"sheet":"参考","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}