源系统平台：管易云
源系统接口： 其他出库查询gy.erp.stock.other.out.order.get
目标系统平台： 金蝶云星空
目标系统接口： 其他出库新增batchSave
源平台元数据配置：
{
"id": "code",
"api": "gy.erp.stock.other.out.order.get",
"type": "QUERY",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "string",
"field": "start_date",
"label": "开始时间",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "end_date",
"label": "结束时间",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "date_type",
"label": "时间类型",
"value": "2",
"describe": "0：修改时间\r\n1：创建时间\r\n2：审核时间\r\n3：出库时间\r\n默认修改时间",
"is_required": false
},
{
"type": "string",
"field": "approve",
"label": "审核状态",
"value": "1",
"describe": "0：所有状态\r\n1：审核成功\r\n2：未审核",
"is_required": false
},
{
"type": "string",
"field": "status",
"label": "出库状态",
"value": "1",
"describe": "0：所有状态\r\n1：出库成功\r\n2：未出库",
"is_required": false
},
{
"type": "string",
"field": "del",
"label": "返回作废",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "warehouse_code",
"label": "仓库代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "code",
"label": "单据编号",
"value": null,
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "code",
"label": "单据编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "note",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "approve",
"label": "审核状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "del",
"label": "作废状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "approve_date",
"label": "审核时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "create_date",
"label": "创建时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "modify_date",
"label": "修改时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "operate_date",
"label": "出库时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "status",
"label": "出库状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "approve_user_name",
"label": "审核人名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "create_name",
"label": "制单人名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "warehouse_code",
"label": "仓库代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "type_code",
"label": "出库类型代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "type_name",
"label": "出库类型名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sourceorder_code",
"label": "来源建议单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "from_no",
"label": "外部单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "details",
"label": "明细",
"children": [
{
"type": "string",
"field": "qty",
"label": "数量",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_code",
"label": "商品代码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sku_code",
"label": "规格代码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "stock_qty",
"label": "库存数",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outstore_qty",
"label": "出库数量",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "batch",
"label": "批次列表",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"pagination": {
"pageSize": 1
},
"otherRequest": [
{
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "默认为10",
"is_required": false
},
{
"type": "string",
"field": "page_no",
"label": "页号",
"value": "{{PAGINATION_START_PAGE}}",
"describe": "默认1",
"is_required": false
}
],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{code}}",
"describe": "单据编号",
"is_required": false
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "QTCKD01_SYS",
"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": "FStockDirect",
"label": "库存方向",
"value": "3700",
"describe": "下拉列表",
"is_required": false
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "2022-02-15",
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FCustId",
"label": "客户",
"value": "fw00064",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FDeptId",
"label": "领料部门",
"value": "BM000001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": "CG",
"describe": "下拉列表",
"is_required": false
},
{
"type": "string",
"field": "FOwnerTypeIdHead",
"label": "货主类型",
"value": "BD_OwnerOrg",
"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": null,
"describe": "多行文本",
"is_required": false
},
{
"type": "array",
"field": "FEntity",
"label": "明细信息",
"value": "details",
"children": [
{
"type": "string",
"field": "FMaterialId",
"label": "物料编码",
"value": "00064",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FQty",
"label": "实发数量",
"value": "{{details.qty}}",
"parent": "FEntity",
"describe": "数量",
"is_required": false
},
{
"type": "string",
"field": "FStockId",
"label": "发货仓库",
"value": "3700",
"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": "100",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "多类别基础资料",
"is_required": false
},
{
"id": "FStockStatusId",
"type": "string",
"field": "FStockStatusId",
"label": "库存状态",
"value": "KCZT01_SYS",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"id": "FBaseUnitId",
"type": "string",
"field": "FBaseUnitId",
"label": "基本单位",
"value": "Pcs",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
}
],
"describe": null,
"is_required": false
},
{
"id": "FUnitID",
"type": "string",
"field": "FUnitID",
"label": "单位",
"value": "Pcs",
"parent": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
}
],
"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": []
}
