源系统平台:积加ERP
源系统接口: 出入库记录api/v2/warehouse/inbound
目标系统平台: 金蝶云星空
目标系统接口: 其他出库新增batchSave
源平台元数据配置:
{
"id": "id",
"api": "api/v2/warehouse/inbound",
"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": "createdAt",
"is_required": false
},
{
"type": "string",
"field": "order",
"label": "顺序或逆序",
"value": null,
"describe": "descend/ascend",
"is_required": false
},
{
"type": "string",
"field": "createStartDate",
"label": "创建时间开始时间",
"value": "{{LAST_SYNC_TIME|date}}",
"describe": "44440",
"is_required": true
},
{
"type": "string",
"field": "createEndDate",
"label": "创建时间结束时间",
"value": "{{CURRENT_TIME|date}}",
"describe": "44440",
"is_required": true
},
{
"type": "string",
"field": "warehouseId",
"label": "仓库ID",
"value": null,
"describe": "13",
"is_required": true
},
{
"type": "string",
"field": "opType",
"label": "单操作类型据类型",
"value": "IVOutbound",
"describe": "otherOut",
"is_required": true
},
{
"type": "string",
"field": "code",
"label": "出入库单号",
"value": null,
"describe": "IB2109010021",
"is_required": true
}
],
"response": [
{
"type": "string",
"field": "traceId",
"label": "日志id",
"value": null,
"describe": "b17d390d-df4e-4690-be43-e0575c7956e3",
"is_required": true
},
{
"type": "string",
"field": "code",
"label": "响应代码",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "message",
"label": "响应信息",
"value": null,
"describe": "request success",
"is_required": true
},
{
"type": "string",
"field": "data",
"label": "数据",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "allStatus",
"label": "allStatus",
"value": null,
"describe": "21",
"is_required": true
},
{
"type": "string",
"field": " In",
"label": " In",
"value": null,
"describe": "9",
"is_required": true
},
{
"type": "string",
"field": "pageInfo",
"label": "pageInfo",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "total",
"label": "总数",
"value": null,
"describe": "20",
"is_required": true
},
{
"type": "string",
"field": "from",
"label": "起始条数",
"value": null,
"describe": "1",
"is_required": true
},
{
"type": "string",
"field": " size",
"label": "条数",
"value": null,
"describe": "20",
"is_required": true
},
{
"type": "string",
"field": "page",
"label": "页码",
"value": null,
"describe": "1",
"is_required": true
},
{
"type": "string",
"field": " pagesize",
"label": "条数",
"value": null,
"describe": "20",
"is_required": true
},
{
"type": "string",
"field": " rows",
"label": "数据",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": " id",
"label": " id",
"value": null,
"describe": "21",
"is_required": true
},
{
"type": "string",
"field": "warehouseId",
"label": "仓库id",
"value": null,
"describe": "13",
"is_required": true
},
{
"type": "string",
"field": "fcode",
"label": "关联单据号",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": " code",
"label": "单号",
"value": null,
"describe": "IB2109010021",
"is_required": true
},
{
"type": "string",
"field": " type",
"label": "单据类型",
"value": null,
"describe": "Out",
"is_required": true
},
{
"type": "string",
"field": "stockCountType",
"label": "盘库出库类型",
"value": null,
"describe": "出入库3",
"is_required": true
},
{
"type": "string",
"field": " opType",
"label": "操作类型",
"value": null,
"describe": "otherOut",
"is_required": true
},
{
"type": "string",
"field": " creater",
"label": "创建人",
"value": null,
"describe": "admin",
"is_required": true
},
{
"type": "string",
"field": "[number]",
"label": "创建人ID",
"value": null,
"describe": "1",
"is_required": true
},
{
"type": "string",
"field": "createdAt",
"label": "创建时间",
"value": null,
"describe": "44440.871527778",
"is_required": true
},
{
"type": "string",
"field": " memo",
"label": "备注",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": " requestStatus",
"label": "请款状态",
"value": null,
"describe": "un_request",
"is_required": true
},
{
"type": "string",
"field": "checkFlag",
"label": "请款数据核对标记 0:未核对 1:已核对",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "items",
"label": "明细集合",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "totalQuantity",
"label": "总数",
"value": null,
"describe": "-2",
"is_required": true
},
{
"type": "string",
"field": "itemsUpdateVal",
"label": "明细更新属性",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "warehouseName",
"label": "仓库名称",
"value": null,
"describe": "US_01",
"is_required": true
},
{
"type": "string",
"field": " stockCountTypeName",
"label": "子操作类型",
"value": null,
"describe": "退货出库",
"is_required": true
},
{
"type": "string",
"field": "itemVOS",
"label": "出入库明细集合",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "opTypeName",
"label": "操作类型名称",
"value": null,
"describe": "其它出库",
"is_required": true
},
{
"type": "string",
"field": "mid",
"label": "mid",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "Out",
"label": "Out",
"value": null,
"describe": "12",
"is_required": true
}
],
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置:
{
"id": "code",
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{code}}",
"describe": "单据编号",
"is_required": false
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "PKD001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单据类型",
"is_required": true
},
{
"type": "string",
"field": "FStockOrgId",
"label": "库存组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FPickOrgId",
"label": "领用组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "{{createdAt}}",
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FDeptId",
"label": "领料部门",
"value": "BM000001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FOwnerIdHead",
"label": "货主",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "多类别基础资料",
"is_required": false
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": "{{memo}}",
"describe": "多行文本",
"is_required": false
},
{
"type": "array",
"field": "FEntity",
"label": "明细信息",
"value": "itemVOS",
"children": [
{
"type": "string",
"field": "FMaterialId",
"label": "物料编码",
"value": "{{itemVOS.product}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FCMKBarCode",
"label": "零售条形码",
"value": null,
"parent": "FEntity",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FQty",
"label": "实发数量",
"value": "_function {{itemVOS.quantity}} * (-1)",
"parent": "FEntity",
"describe": "数量",
"is_required": false
},
{
"type": "string",
"field": "FStockId",
"label": "发货仓库",
"value": "{{warehouseId}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FStockLocId",
"label": "仓位",
"value": "_findCollection find stockidcode from ebc3d4e2-1362-3392-a9c6-49fbbaee3865 where id={{itemVOS.locationId}}",
"parent": "FEntity",
"parser": {
"name": "ConvertTwoStageObjectParser",
"params1": "FSTOCKLOCID__FF100001",
"params2": "FNumber"
},
"describe": "维度关联字段",
"is_required": false
},
{
"type": "string",
"field": "FAmount",
"label": "总成本",
"value": null,
"parent": "FEntity",
"describe": "金额",
"is_required": false
},
{
"type": "string",
"field": "FPrice",
"label": "成本价",
"value": null,
"parent": "FEntity",
"describe": "单价",
"is_required": false
},
{
"type": "string",
"field": "FLot",
"label": "批号",
"value": null,
"parent": "FEntity",
"describe": "批次",
"is_required": false
},
{
"type": "string",
"field": "FSrcBillTypeId",
"label": "源单类型",
"value": null,
"parent": "FEntity",
"describe": "源单类型",
"is_required": false
},
{
"type": "string",
"field": "FSrcBillNo",
"label": "源单编号",
"value": null,
"parent": "FEntity",
"describe": "源单编号",
"is_required": false
},
{
"type": "string",
"field": "FEntryNote",
"label": "备注",
"value": "{{itemVOS.memo}}",
"parent": "FEntity",
"describe": "多行文本",
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "STK_MisDelivery",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "true",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false",
"describe": "是否验证所有的基础资料有效性,布尔类,默认false(非必录)",
"is_required": false
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "Save",
"describe": null,
"is_required": true
}
],
"otherResponse": []
}