金蝶云星空对接打通四化智造MES（API）逐个单据查询接口与新增订单接口

数据源平台:金蝶云星空

金蝶K/3Cloud（金蝶云星空）是移动互联网时代的新型ERP，是基于WEB2.0与云技术的新时代企业管理服务平台。金蝶K/3Cloud围绕着“生态、人人、体验”，旨在帮助企业打造面向新时代的生态互联与协同平台，围绕生态中的每个角色，提供随手可得的云服务，最终实现敏捷协同，智慧运营的企业运营新境界。整个产品采用SOA架构，完全基于BOS平台组建而成，业务架构上贯穿流程驱动与角色驱动思想，结合中国管理模式与中国管理实践积累，精细化支持企业财务管理、供应链管理、生产管理、供应链协同管理、人力资源管理等核心应用。技术架构上该产品采用平台化构建，支持跨数据库应用，支持本地部署、私有云部署与公有云部署三种部署方式，同时还在公有云上开放中国第一款基于ERP的协同开发云平台。任何一家使用金蝶K/3Cloud产品的企业，其拥有的是包含金蝶在内的众多基于同一个平台提供服务的IT服务伙伴。

接通系统：四化智造MES（API）

MES系统是集成生产管理、品质管理、设备管理、BI数据中心、库存管理、工时管理、数据采集、看板管理等为一体的综合性生产管理系统。通过强调制造过程的透明化，帮助企业由粗放式向精益化管理模式升级。

数据集成方案配置

通过可视化界面的拖、拉、拽即可轻松快速构建数据集成流程，将金蝶云星空、四化智造MES（API）之间接口数据联通，支持数据在线预览、数据集成流程全过程调试，Web界面追踪调试日志等功能。平台兼具实时数据处理和数据集成分发功能，用户通过可视化的拖、拽即可完成数据处理逻辑，将数据加工处理后分发到下游业务系统或其他异构存储中。

金蝶云星空接口明细

接口：ExecuteBillQuery
接口名称：逐个单据查询
接口方法：POST

请求参数

字段名称类型描述 Limit最大行数string金蝶的查询分页参数 StartRow开始行索引string金蝶的查询分页参数 TopRowCount返回总行数int金蝶的查询分页参数 FilterString过滤条件string示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>= FieldKeys需查询的字段key集合array金蝶分录主键ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber FormId业务对象表单Idstring必须填写金蝶的表单ID如😛UR_PurchaseOrder

响应参数

字段名称类型描述 DocumentStatus数据状态string ForbidStatus禁用状态string NameBOM简称string NumberBOM版本string Description描述string CreateOrgId_Id创建组织Idstring CreateOrgId_Name创建组织_名称string CreateOrgId_Number创建组织编码string UseOrgId_Id使用组织_Idstring UseOrgId_Name使用组织名称string UseOrgId_Number使用组织_编码string CreatorId_Id创建人Idstring CreatorId_Name创建人_名称string CreatorId_Number创建人编码string ModifierId_Id修改人_Idstring ModifierId_Name修改人名称string ModifierId_Number修改人_编码string CreateDate创建日期string ModifyDate修改日期string ForbidderId_Id禁用人Idstring ForbidderId_Name禁用人_名称string ForbidderId_Number禁用人编码string ApproverId_Id审核人_Idstring ApproverId_Name审核人名称string ApproverId_Number审核人_编码string ForbidDate禁用日期string ApproveDate审核日期string BOMCATEGORYBOM分类string BOMUSEBOM用途string MATERIALID_Id父项物料编码Idstring MATERIALID_Name父项物料编码_名称string MATERIALID_Number父项物料编码编码string YIELDRATE成品率%string BILLTYPE单据类型string FUNITID_Id父项物料单位_Idstring FUNITID_Name父项物料单位名称string FUNITID_Number父项物料单位_编码string BaseUnitId_Id父项基本单位Idstring BaseUnitId_Name父项基本单位_名称string BaseUnitId_Number父项基本单位编码string ISDEFAULT是否新版本string CfgBomId配置BOMstring Qty批量string BaseQty基本单位批量string GROUP_IdBOM分组_Idstring GROUP_NameBOM分组名称string GROUP_NumberBOM分组_编码string PLMBOMIdPLMBOM内码string BOMSRCBOM来源string MDLID_Id产品模型Idstring MDLID_Name产品模型_名称string MDLID_Number产品模型编码string ForbidReson禁用原因string F_lyzx_Text客户版次号string F_lyzx_Qty单重(KG)string F_lyzx_Text1功能原理string F_lyzx_Text2材质及成份string F_lyzx_Text3型号string F_lyzx_Price单价string F_lyzx_Text4用途说明string F_lyzx_Text5其他补充说明string F_lyzx_Base_Id料号属性_Idstring F_lyzx_Base_Name料号属性名称string F_lyzx_Base_Number料号属性_编码string F_lyzx_UnitID_Id企业单位Idstring F_lyzx_UnitID_Name企业单位_名称string F_lyzx_UnitID_Number企业单位编码string F_lyzx_Base1_Id币别_Idstring F_lyzx_Base1_Name币别名称string F_lyzx_Base1_Number币别_编码string F_lyzx_Text6品牌string F_lyzx_Date申请日期string F_lyzx_Integer申请序号string F_lyzx_Text7商品名称string F_lyzx_Text8商品编码string F_lyzx_Text9CIQCODEstring F_lyzx_UnitID1_Id计量单位Idstring F_lyzx_UnitID1_Name计量单位_名称string F_lyzx_UnitID1_Number计量单位编码string F_lyzx_UnitID2_Id申报单位_Idstring F_lyzx_UnitID2_Name申报单位名称string F_lyzx_UnitID2_Number申报单位_编码string F_lyzx_UnitID3_Id法定一Idstring F_lyzx_UnitID3_Name法定一_名称string F_lyzx_UnitID3_Number法定一编码string F_lyzx_UnitID4_Id法定二_Idstring F_lyzx_UnitID4_Name法定二名称string F_lyzx_UnitID4_Number法定二_编码string F_lyzx_Qty1比例因子string F_lyzx_Decimal法比一string F_lyzx_Decimal1法比二string F_lyzx_Text10申报要素string F_lyzx_Assistant出货关区string F_lyzx_Text11备注string F_lyzx_CheckBox确认报关string F_lyzx_CheckBox1是否需要报关string F_lyzx_Combo是否报关string TreeEntity子项明细array TreeEntity.ParentRowId父级行主键string TreeEntity.RowExpandType行展开类型string TreeEntity.RowId行标识string TreeEntity.MATERIALTYPE子项类型string TreeEntity.DOSAGETYPE用量类型string TreeEntity.PROCESSID_Id作业Idstring TreeEntity.PROCESSID_Name作业_名称string TreeEntity.PROCESSID_Number作业编码string TreeEntity.FIXSCRAPQTY固定损耗string TreeEntity.EFFECTDATE生效日期string TreeEntity.EXPIREDATE失效日期string TreeEntity.ISSUETYPE发料方式string TreeEntity.SUPPLYORG_Id发料组织_Idstring TreeEntity.SUPPLYORG_Name发料组织名称string TreeEntity.SUPPLYORG_Number发料组织_编码string TreeEntity.STOCKID_Id默认发料仓库Idstring TreeEntity.STOCKID_Name默认发料仓库_名称string TreeEntity.STOCKID_Number默认发料仓库编码string TreeEntity.ALLOWOVER允许超发string TreeEntity.BACKFLUSHTYPE倒冲时机string TreeEntity.FTIMEUNIT时间单位string TreeEntity.ISKEYCOMPONENT是否关键件string TreeEntity.MATERIALIDCHILD_Id子项物料编码_Idstring TreeEntity.MATERIALIDCHILD_Name子项物料编码名称string TreeEntity.MATERIALIDCHILD_Number子项物料编码_编码string TreeEntity.POSITIONNO位置号string TreeEntity.FSCRAPRATE变动损耗率%string TreeEntity.DISASSMBLERATE拆卸成本拆分比例string TreeEntity.OFFSETTIME偏置时间string TreeEntity.FISGETSCRAP是否发损耗string TreeEntity.BOMID_Id子项BOM版本Idstring TreeEntity.BOMID_Name子项BOM版本_名称string TreeEntity.BOMID_Number子项BOM版本编码string TreeEntity.NUMERATOR用量:分子string TreeEntity.DENOMINATOR用量:分母string TreeEntity.OWNERTYPEID货主类型string TreeEntity.OWNERID货主string TreeEntity.OPERID工序string TreeEntity.MEMO备注string TreeEntity.CHILDUNITID_Id子项单位_Idstring TreeEntity.CHILDUNITID_Name子项单位名称string TreeEntity.CHILDUNITID_Number子项单位_编码string TreeEntity.EntryRowId子项标识string TreeEntity.ChildBaseUnitID_Id子项基本单位Idstring TreeEntity.ChildBaseUnitID_Name子项基本单位_名称string TreeEntity.ChildBaseUnitID_Number子项基本单位编码string TreeEntity.BaseNumerator基本单位分子string TreeEntity.BaseFixscrapQty基本单位固定损耗string TreeEntity.BaseDenominator基本单位分母string TreeEntity.Qty标准用量string TreeEntity.ActualQty实际用量string TreeEntity.OverControlMode超发控制方式string TreeEntity.ReplaceGroup项次string TreeEntity.ReplacePolicy替代策略string TreeEntity.ReplaceType替代方式string TreeEntity.ReplacePriority替代优先级string TreeEntity.MRPPriority动态优先级string TreeEntity.IskeyItem替代主料string TreeEntity.IsCanChoose可选择string TreeEntity.IsCanEdit可修改string TreeEntity.IsCanReplace可替换string TreeEntity.CfgBomEntryId配置BOM分录内码string TreeEntity.CfgFeatureEntryId父项特征件分录内码string TreeEntity.ChildSupplyOrgId_Id供应组织_Idstring TreeEntity.ChildSupplyOrgId_Name供应组织名称string TreeEntity.ChildSupplyOrgId_Number供应组织_编码string TreeEntity.OptQueue工序序列string TreeEntity.PLMBOMEntryIdPLMBOM分录内码string TreeEntity.BOMEntrySRCBOM分录来源string TreeEntity.ISSkip跳层string TreeEntity.TreeEntryIdBak子项明细Id备份(引入时与BOP关联)string TreeEntity.ISMinIssueQty领料考虑最小发料批量string TreeEntity.ChangeType变更类型string TreeEntity.ChangeTime变更日期string TreeEntity.ECNBillNo变更单号string TreeEntity.ECNChgType变更类型string TreeEntity.ECNChgDate变更日期string TreeEntity.SupplyMode供料方式string TreeEntity.ECNRowTypeECN行类型string TreeEntity.RecordData记录字段string TreeEntity.FPLMBOMEntryRowIdCloudPLMBOM分录内码string TreeEntity.IsMrpRunMRP运算string TreeEntity.SubstitutionId_Id替代方案编码Idstring TreeEntity.SubstitutionId_Name替代方案编码_名称string TreeEntity.SubstitutionId_Number替代方案编码编码string TreeEntity.STEntryId替代方案分录内码string TreeEntity.SupplyType供应类型string TreeEntity.F_UZMJ_BaseProperty3宽string TreeEntity.BOMCHILDLOTBASEDQTY阶梯用量array TreeEntity.BOMCHILDLOTBASEDQTY.MATERIALIDLOTBASED_Id子项物料编码_Idstring TreeEntity.BOMCHILDLOTBASEDQTY.MATERIALIDLOTBASED_Name子项物料编码名称string TreeEntity.BOMCHILDLOTBASEDQTY.MATERIALIDLOTBASED_Number子项物料编码_编码string TreeEntity.BOMCHILDLOTBASEDQTY.STARTQTY起始数量（含）string TreeEntity.BOMCHILDLOTBASEDQTY.ENDQTY截止数量string TreeEntity.BOMCHILDLOTBASEDQTY.FIXSCRAPQTYLOT固定损耗string TreeEntity.BOMCHILDLOTBASEDQTY.NOTELOT备注string TreeEntity.BOMCHILDLOTBASEDQTY.SCRAPRATELOT变动损耗率string TreeEntity.BOMCHILDLOTBASEDQTY.NUMERATORLOT用量:分子string TreeEntity.BOMCHILDLOTBASEDQTY.DENOMINATORLOT用量:分母string TreeEntity.BOMCHILDLOTBASEDQTY.UNITIDLOT_Id子项单位Idstring TreeEntity.BOMCHILDLOTBASEDQTY.UNITIDLOT_Name子项单位_名称string TreeEntity.BOMCHILDLOTBASEDQTY.UNITIDLOT_Number子项单位编码string TreeEntity.BOMCHILDLOTBASEDQTY.BASEUNITIDLOT_Id子项阶梯基本单位_Idstring TreeEntity.BOMCHILDLOTBASEDQTY.BASEUNITIDLOT_Name子项阶梯基本单位名称string TreeEntity.BOMCHILDLOTBASEDQTY.BASEUNITIDLOT_Number子项阶梯基本单位_编码string TreeEntity.BOMCHILDLOTBASEDQTY.BASENUMERATORLOT子项基本单位分子string TreeEntity.BOMCHILDLOTBASEDQTY.BASESTARTQTY基本单位起始数量string TreeEntity.BOMCHILDLOTBASEDQTY.BASEENDQTY基本单位截止数量string TreeEntity.BOMCHILDLOTBASEDQTY.BASEFIXSCRAPQTYLOT基本单位固定损耗数量string TreeEntity.BOMCHILDLOTBASEDQTY.BASEDENOMINATORLOT子项基本单位分母string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY联副产品array TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.COBYTYPE联副产品类型string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.MATERIALIDCOBY_Id联副产品物料编码Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.MATERIALIDCOBY_Name联副产品物料编码_名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.MATERIALIDCOBY_Number联副产品物料编码编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.QTYCOBY数量string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.COSTRATECOBY成本权重string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.PPROCESSID产出工序string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.EFFECTDATECOBY生效日期string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.EXPIREDATECOBY失效日期string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.NOTECOBY备注string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BaseQtyCoby联副产品基本数量string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BaseUnitIdCoby_Id联副产品基本单位_Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BaseUnitIdCoby_Name联副产品基本单位名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BaseUnitIdCoby_Number联副产品基本单位_编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.TASKIDCOBY_Id产出作业编码Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.TASKIDCOBY_Name产出作业编码_名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.TASKIDCOBY_Number产出作业编码编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.UNITIDCOBY_Id单位_Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.UNITIDCOBY_Name单位名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.UNITIDCOBY_Number单位_编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.OutPutOptQueue产出工序序列string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BOMID_IdBOM版本Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BOMID_NameBOM版本_名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BOMID_NumberBOM版本编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.ISBACKFLUSH倒冲领料string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntityBOParray TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.ReplaceGroupBop项次string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.ProductLineId_Id生产线编码_Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.ProductLineId_Name生产线编码名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.ProductLineId_Number生产线编码_编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.PrdLineLocId_Id工位/工序Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.PrdLineLocId_Name工位/工序_名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.PrdLineLocId_Number工位/工序编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopMaterialId_Id子项物料编码_Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopMaterialId_Name子项物料编码名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopMaterialId_Number子项物料编码_编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopUnitId_Id子项单位Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopUnitId_Name子项单位_名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopUnitId_Number子项单位编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopDosageType用量类型string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopNumerator用量:分子string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopDenominator用量:分母string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopBaseUnitID_Id子项基本单位_Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopBaseUnitID_Name子项基本单位名称string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BopBaseUnitID_Number子项基本单位_编码string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BaseBopNumeratorBOP基本单位分子string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.BaseBopDenominatorBOP基本单位分母string TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.TreeEntryId子项明细Idstring TreeEntity.BOMCHILDLOTBASEDQTY.EntryBOMCOBY.BopEntity.FITEMMODEL规格型号string

四化智造MES（API）接口明细

接口：/api/addBomOrder
接口名称：新增订单
接口方法：POST

请求参数

字段名称类型描述 CutEmsBomOrderDTOBOM明细信息array CutEmsBomOrderDTO.machIdmachIdstring CutEmsBomOrderDTO.customerPartNo客户料号string CutEmsBomOrderDTO.aircraftType机种string CutEmsBomOrderDTO.customerVersion客户版本string CutEmsBomOrderDTO.ysdPartNoYSD料号string CutEmsBomOrderDTO.ysdVersionYSD版本string CutEmsBomOrderDTO.finishedGradeName成品品名string CutEmsBomOrderDTO.finishedSpec成品规格string CutEmsBomOrderDTO.finishedUnitName成品单位string CutEmsBomOrderDTO.bomVersionBOM版次string CutEmsBomOrderDTO.zcdmcUnitConsumption子材对母材单耗string CutEmsBomOrderDTO.childVersion子项版本string CutEmsBomOrderDTO.cpdzcUnitConsumption成品对子材单耗string CutEmsBomOrderDTO.materialGradeName材料品名string CutEmsBomOrderDTO.supplierMark供应商牌号string CutEmsBomOrderDTO.parentPartNo母材料号string CutEmsBomOrderDTO.parentHeight材料厚度string CutEmsBomOrderDTO.parentWidth母材宽度string CutEmsBomOrderDTO.parentLength母材长度string CutEmsBomOrderDTO.parentUnitName母材核价单位string CutEmsBomOrderDTO.childPartNo子材料号string CutEmsBomOrderDTO.childWidth子材宽度string CutEmsBomOrderDTO.childLength产品步距string CutEmsBomOrderDTO.modulus模数string CutEmsBomOrderDTO.materialUsageRatio用量比string CutEmsBomOrderDTO.cycleIndex循环次数string CutEmsBomOrderDTO.useRatio利用率string CutEmsBomOrderDTO.projectCode专案工程string CutEmsBomOrderDTO.companyCode公司代码string

系统集成总览

数据集成中台设计中心Web界面以“拖拽”式交互设计，使用鼠标即可构建设计多异构系统数据集成流程，低代码平台大大降低流程设计者上手门槛。还有丰富的组件库快速满足复杂业务需求，结合不同模块即可生成不同业务流程，提升流程设计效率。平台支持多种高度灵活部署，高并发、高性能、高可用，可以通过多节点组成集群实现性能的横向扩展。适度集群配置其数据集成处理能力可达GB级/秒，为业务流提供更高数据吞吐量。平台已集成数据回压、优先级队列等能力，保障运行稳定性。完善的企业API运营管理机制帮助您构建“API生产者、API管理者、API消费者”三者结合的统一API数字化生态。支持市面上主流厂家软件如：金蝶、用友、SAP、泛微、蓝凌、旺店通、聚水潭、马帮、小满CRM等等。

金蝶云星空对接打通四化智造MES（API）逐个单据查询接口与新增订单接口