源系统平台：吉客云
源系统接口： 调拨查询erp.allocate.get
目标系统平台： 金蝶云星空
目标系统接口： 分布式调入单新增batchSave
源平台元数据配置：
{
"id": "allocateId",
"api": "erp.allocate.get",
"type": "QUERY",
"method": "POST",
"number": "allocateNo",
"idCheck": true,
"request": [
{
"type": "string",
"field": "pageIndex",
"label": "页码(默认从0开始)",
"value": "0",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "pageSize",
"label": "每页条数(默认50)",
"value": "50",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "status",
"label": "调拨单状态（多个中间逗号隔开)",
"value": "2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "startCreateTime",
"label": "创建时间的起始时间",
"value": "2021-12-23 00:00:00",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "endCreateTime",
"label": "创建时间结束时间",
"value": "2021-12-23 23:59:59",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "inWarehouseCode",
"label": "调入仓库编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outSkuCode",
"label": "外部货品主键（支持批量 例:123,456）",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outWarehouseCode",
"label": "调出仓库编号",
"value": null,
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "isAllocateDifferentCompany",
"label": "是否跨公司调拨(0-否 1-是)",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "allocateNo",
"label": "调拨单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outWarehouseId",
"label": "调出仓库id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "inWarehouseId",
"label": "调入仓库id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outWarehouseCode",
"label": "调出仓库编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "intWarehouseCode",
"label": "调入仓库编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outWarehouseName",
"label": "调出仓库名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "intWarehouseName",
"label": "调入仓库名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "allocateType",
"label": "调拨类型:0=同价调拨1=异价调拨",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "allocatePrice",
"label": "1=批发价，2=零售价，3=会员价",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "applyUserId",
"label": "申请人id,关联用户表",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "applyUserName",
"label": "申请人姓名",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "applyDepartId",
"label": "申请部门id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "applyDepartName",
"label": "申请人部门",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "applyDate",
"label": "申请时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "operator",
"label": "制单人",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "operatorId",
"label": "制单人id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "auditUserId",
"label": "审核人id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "auditUserName",
"label": "审核人姓名",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "auditDate",
"label": "审核时间(时间戳)",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "status",
"label": "0=草稿1=待审核2=已审核3=已关闭 10-审核中",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outStatus",
"label": "出库状态1=出库等待2=部分出库3=出库完成",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "inStatus",
"label": "入库状态1=入库等待2=部分入库3=入库完成",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "memo",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goodsCount",
"label": "货品种类",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "gmtCreate",
"label": "创建时间(时间戳)",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "allocatePriceType",
"label": "调拨价格类型:1=批发价，2=零售价，3=会员价",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "flagData",
"label": "标记Id集合",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "companyId",
"label": "公司id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "companyName",
"label": "公司名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "planOutDate",
"label": "预计出库时间(时间戳)",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "planInDate",
"label": "预计入库时间(时间戳)",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "stockAllocateDetailViews",
"label": "库存调拨明细",
"children": [
{
"type": "string",
"field": "allocateId",
"label": "调拨单id,关联调拨单",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "skuCount",
"label": "数量",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "totalAmount",
"label": "总金额",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "allocateDetailId",
"label": "主键id",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goodsId",
"label": "货品id",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goodsName",
"label": "货品名称（冗余字段）",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "skuId",
"label": "skuid",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "skuName",
"label": "sku名称，冗余字段",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "unitName",
"label": "计量单位名称（冗余字段）",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "skuPrice",
"label": "单价",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outCount",
"label": "已出库数量",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "inCount",
"label": "已入库数量",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "isCertified",
"label": "是否正品",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "rowRemark",
"label": "备注",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "skuBarcode",
"label": "条形码",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goodsNo",
"label": "商品编号",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "assistUnit",
"label": "辅助单位",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outSkuCode",
"label": "外部货品主键",
"value": null,
"parent": "stockAllocateDetailViews",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "isNegativeStock",
"label": "是否允许负库存出库1-是 空或者0是否",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "stockAllocateExpressInfo",
"label": "收发货人信息",
"children": [
{
"type": "string",
"field": "id",
"label": "主键id",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "relDataNo",
"label": "关联入库申请单编号",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendCompanyName",
"label": "发件公司名称",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "send",
"label": "发件人",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendTel",
"label": "发件人电话",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendPhone",
"label": "发件人手机号",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendEmail",
"label": "发件人邮箱",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendCountryName",
"label": "发件人国家",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendProvinceName",
"label": "发件人省",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendCityName",
"label": "发件人市",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendTownName",
"label": "发件人镇，区",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendStreetName",
"label": "发件人街道",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sendAddress",
"label": "发件人详细地址",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiveCompanyName",
"label": "收件公司名称",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receive",
"label": "收件人",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiveTel",
"label": "收件人电话",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receivePhone",
"label": "收件人手机号",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiveEmail",
"label": "收件人邮箱",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiveCountryName",
"label": "收件人国家",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiveProvinceName",
"label": "收件人省",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiveCityName",
"label": "收件人市",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiveTownName",
"label": "收件人镇，区",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiveStreetName",
"label": "收件人街道",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiveAddress",
"label": "收件人详细地址",
"value": null,
"parent": "stockAllocateExpressInfo",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"pagination": {
"pageSize": 50
},
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{allocateNo}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockOrgID",
"label": "调入库存组织",
"value": "_findCollection find textField_kvgbyy6b from ba7b4c50-b81c-315d-835f-9e07995df2a1 where textField_kvgbyy68={{intWarehouseCode}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "_function FROM_UNIXTIME( ( {{auditDate}} / 1000 ) ,'%Y-%m-%d %T' )",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "FBDR01_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTransferDirect",
"label": "调拨方向",
"value": "GENERAL",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FNOTE",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCreateDate",
"label": "创建日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTransferMode",
"label": "调拨方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTransferBizType",
"label": "调拨类型",
"value": "InnerOrgTransfer",
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "FSTKTRSINENTRY",
"label": "明细信息",
"value": "stockAllocateDetailViews",
"children": [
{
"type": "string",
"field": "FMaterialID",
"label": "物料编码",
"value": "{{stockAllocateDetailViews.goodsNo}}",
"parent": "FSTKTRSINENTRY",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCMKBarCode",
"label": "零售条形码",
"value": null,
"parent": "FSTKTRSINENTRY",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcStockID",
"label": "调出仓库",
"value": "{{outWarehouseCode}}",
"parent": "FSTKTRSINENTRY",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDestStockID",
"label": "调入仓库",
"value": "{{intWarehouseCode}}",
"parent": "FSTKTRSINENTRY",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQty",
"label": "调入数量",
"value": "{{stockAllocateDetailViews.skuCount}}",
"parent": "FSTKTRSINENTRY",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOwnerID",
"label": "调入货主",
"value": "_findCollection find textField_kvgbyy6b from ba7b4c50-b81c-315d-835f-9e07995df2a1 where textField_kvgbyy68={{intWarehouseCode}}",
"parent": "FSTKTRSINENTRY",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDestStockLocId",
"label": "调入仓位",
"value": null,
"parent": "FSTKTRSINENTRY",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSRCStockLocId",
"label": "调出仓位",
"value": null,
"parent": "FSTKTRSINENTRY",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOwnerOutID",
"label": "调出货主",
"value": "_findCollection find textField_kvgbyy6b from ba7b4c50-b81c-315d-835f-9e07995df2a1 where textField_kvgbyy68={{outWarehouseCode}}",
"parent": "FSTKTRSINENTRY",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FLOT",
"label": "调出批号",
"value": null,
"parent": "FSTKTRSINENTRY",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FEntryNote",
"label": "备注",
"value": null,
"parent": "FSTKTRSINENTRY",
"describe": null,
"is_required": false
},
{
"id": "FSrcMaterialId",
"type": "string",
"field": "FSrcMaterialId",
"label": "调出物料",
"value": "{{stockAllocateDetailViews.goodsNo}}",
"parent": "FSTKTRSINENTRY"
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "STK_TRANSFERIN",
"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": "false",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false",
"describe": "是否验证所有的基础资料有效性，布尔类，默认false（非必录）",
"is_required": false
}
],
"otherResponse": []
}
