源系统平台:积加ERP
源系统接口: 采购计划查询api/v2/purchase/plan
目标系统平台: 金蝶云星空
目标系统接口: 预测单新增batchSave
![](//pic.qeasy.cloud/2022-10-15/1665853413-478593-image.png~tplv-syqr462i7n-qeasy.image)
![](//pic.qeasy.cloud/2022-10-15/1665853417-412412-image.png~tplv-syqr462i7n-qeasy.image)
源平台元数据配置:
{
"id": "id",
"api": "api/v2/purchase/plan",
"type": "QUERY",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "string",
"field": "page",
"label": "页码",
"value": "1",
"describe": "1",
"is_required": true
},
{
"type": "string",
"field": "pagesize",
"label": "条数",
"value": "20",
"describe": "20",
"is_required": true
},
{
"type": "string",
"field": "sort",
"label": "排序",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "order",
"label": "顺序或逆序",
"value": null,
"describe": "descend/ascend",
"is_required": false
},
{
"type": "string",
"field": "code",
"label": "计划单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "arrivalWarehouseId",
"label": "目的仓库",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "invoicesStateList",
"label": "单据状态集",
"value": "99",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "transport",
"label": "物流方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "createdStartDate",
"label": "创建时间起",
"value": "2022-02-21",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "createdEndDate",
"label": "创建时间止",
"value": "2022-02-28",
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "id",
"label": "采购计划主键id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "code",
"label": "计划单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "arrivalWarehouseId",
"label": "目的仓库",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "arrivalWarehouseName",
"label": "目的仓库名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "arrivalMarketId",
"label": "亚马逊站点",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "arrivalMarketName",
"label": "目的站点名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "transferMarketName",
"label": "中转站点名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "transferWarehouseId",
"label": "中转仓",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "transferWarehouseName",
"label": "中转仓名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "procurementMethod",
"label": "采购方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "procurementMethodName",
"label": "采购方式名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "invoicesState",
"label": "单据状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "invoicesStateName",
"label": "单据状态名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "totalQuantity",
"label": "总数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "totalNum",
"label": "产品种类",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "totalPurchaseCost",
"label": "总采购成本",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "baseCurrencySymbol",
"label": "本位币",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "transport",
"label": "采购计划物流方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "transportName",
"label": "运输方式名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "memo",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "processState",
"label": "跟单状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "processStateName",
"label": "跟单状态名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "purchaseOrderCode",
"label": "关联采购单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "reviewerId",
"label": "审单人",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "reviewerName",
"label": "审单人名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "reviewerTime",
"label": "审单时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "createrId",
"label": "创建人",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "createrName",
"label": "创建人名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "createdAt",
"label": "创建时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "uuid",
"label": "审批流关联字段",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "totalExpectPrice",
"label": "预估货值",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "planItemVoList",
"label": "采购计划明细集合",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "fbaWarehouse",
"label": "是否为FBA仓库",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "turnover",
"label": "库周转",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shippedTurnover",
"label": "途周转",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "totalTurnover",
"label": "总周转",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "attachmentIds",
"label": "附件ID集合",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "attachmentVOList",
"label": "附件集合",
"value": null,
"children": [
{
"type": "string",
"field": "filename",
"label": "附件名称",
"value": null,
"parent": "attachmentVOList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "filePath",
"label": "附件存储路径",
"value": null,
"parent": "attachmentVOList",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FForeOrgId",
"label": "预测组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "预测组织",
"is_required": false
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "YCD01_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单据类型",
"is_required": true
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "{{createdAt}}",
"describe": "日期",
"is_required": true
},
{
"type": "string",
"field": "FDescription",
"label": "备注",
"value": null,
"describe": "备注",
"is_required": false
},
{
"type": "array",
"field": "FEntity",
"label": "单据明细",
"children": [
{
"type": "string",
"field": "FSupplyOrgId",
"label": "供应组织",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "供应组织",
"is_required": false
},
{
"type": "string",
"field": "FCustID",
"label": "客户名称",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "客户名称",
"is_required": false
},
{
"type": "string",
"field": "FProductType",
"label": "产品类型",
"value": "0",
"parent": "FEntity",
"describe": "产品类型",
"is_required": true
},
{
"type": "string",
"field": "FMaterialID",
"label": "物料编码",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "物料编码",
"is_required": true
},
{
"type": "string",
"field": "FMapId",
"label": "客户物料编码",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "客户物料编码",
"is_required": false
},
{
"type": "string",
"field": "FBomID",
"label": "BOM版本",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "BOM版本",
"is_required": false
},
{
"type": "string",
"field": "FUnitID",
"label": "单位",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单位",
"is_required": true
},
{
"type": "string",
"field": "FQty",
"label": "数量",
"value": null,
"parent": "FEntity",
"describe": "数量",
"is_required": false
},
{
"type": "string",
"field": "FParentMtrlId",
"label": "父项物料",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "父项物料",
"is_required": false
},
{
"type": "string",
"field": "FStartDate",
"label": "预测开始日期",
"value": null,
"parent": "FEntity",
"describe": "预测开始日期",
"is_required": true
},
{
"type": "string",
"field": "FEndDate",
"label": "预测结束日期",
"value": null,
"parent": "FEntity",
"describe": "预测结束日期",
"is_required": true
},
{
"type": "string",
"field": "FAuxPropId",
"label": "辅助属性",
"value": null,
"parent": "FEntity",
"describe": "辅助属性",
"is_required": false
},
{
"type": "string",
"field": "FMtoNo",
"label": "计划跟踪号",
"value": null,
"parent": "FEntity",
"describe": "计划跟踪号",
"is_required": false
},
{
"type": "string",
"field": "FBaseUnitID",
"label": "基本计量单位",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基本计量单位",
"is_required": false
},
{
"type": "string",
"field": "FBaseQty",
"label": "基本单位数量",
"value": null,
"parent": "FEntity",
"describe": "基本单位数量",
"is_required": false
},
{
"type": "string",
"field": "FBaseOrderQty",
"label": "基本单位关联数量",
"value": null,
"parent": "FEntity",
"describe": "基本单位关联数量",
"is_required": false
},
{
"type": "string",
"field": "FBaseWriteOffQty",
"label": "基本单位执行数量",
"value": null,
"parent": "FEntity",
"describe": "基本单位执行数量",
"is_required": false
},
{
"type": "string",
"field": "FBaseSelPrdQty",
"label": "基本单位关联生产委外数量",
"value": null,
"parent": "FEntity",
"describe": "基本单位关联生产委外数量",
"is_required": false
},
{
"type": "string",
"field": "FAVERATYPE",
"label": "均化类型",
"value": "N",
"parent": "FEntity",
"describe": "均化类型",
"is_required": true
},
{
"type": "string",
"field": "FAveraCycle",
"label": "均化周期",
"value": "0",
"parent": "FEntity",
"describe": "均化周期",
"is_required": false
},
{
"type": "string",
"field": "FStockOrgId",
"label": "库存组织",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "库存组织",
"is_required": false
},
{
"type": "string",
"field": "FOwnerTypeId",
"label": "货主类型",
"value": "BD_OwnerOrg",
"parent": "FEntity",
"describe": "货主类型",
"is_required": false
},
{
"type": "string",
"field": "FOwnerId",
"label": "货主",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "货主",
"is_required": false
},
{
"type": "string",
"field": "FReserveType",
"label": "预留类型",
"value": null,
"parent": "FEntity",
"describe": "预留类型",
"is_required": true
},
{
"type": "string",
"field": "FPriority",
"label": "需求优先级",
"value": null,
"parent": "FEntity",
"describe": "需求优先级",
"is_required": false
},
{
"type": "string",
"field": "FWriteOffQty",
"label": "执行数量",
"value": null,
"parent": "FEntity",
"describe": "执行数量",
"is_required": false
},
{
"type": "string",
"field": "FOrderQty",
"label": "关联数量",
"value": null,
"parent": "FEntity",
"describe": "关联数量",
"is_required": false
},
{
"type": "string",
"field": "FSelPrdQty",
"label": "关联生产委外数量",
"value": null,
"parent": "FEntity",
"describe": "关联生产委外数量",
"is_required": false
},
{
"type": "string",
"field": "FRemark",
"label": "备注",
"value": null,
"parent": "FEntity",
"describe": "备注",
"is_required": false
}
],
"describe": "单据明细",
"is_required": false
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "PLN_FORECAST",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "BatchSave",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "true",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "true",
"describe": "是否验证所有的基础资料有效性,布尔类,默认false(非必录)",
"is_required": false
}
],
"otherResponse": []
}