源系统平台：管易云
源系统接口： 发货单查询2.0gy.erp.kingdeecloud.delivery.orders.querybydate
目标系统平台： 金蝶K3-WISE
目标系统接口： 新增其他出库新增其他出库
源平台元数据配置：
{
"id": "code",
"api": "gy.erp.kingdeecloud.delivery.orders.querybydate",
"type": "QUERY",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "string",
"field": "start_date",
"label": "创建时间开始段",
"value": "{{LAST_SYNC_TIME|datetime}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "end_date",
"label": "创建时间结束段",
"value": "{{CURRENT_TIME|datetime}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "del",
"label": "返回是否作废的单据",
"value": "0",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "delivery",
"label": "发货状态",
"value": "1",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shop_code",
"label": "店铺代码",
"value": null,
"describe": null,
"is_required": false
}
],
"beatFlat": [
"details",
"batchs"
],
"response": [
{
"type": "String",
"field": "code",
"label": "单据编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "tagName",
"label": "标记名",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "tagCode",
"label": "标记码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "shop_code",
"label": "店铺代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "warehouse_code",
"label": "仓库代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "delivery_time",
"label": "交货时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "vip_code",
"label": "会员代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "vip_name",
"label": "会员名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "receiver_name",
"label": "收货人姓名",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "receiver_phone",
"label": "收货人电话",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "receiver_mobile",
"label": "审核人",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "area_name",
"label": "收货地区",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "receiver_address",
"label": "收货地址",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "express_code",
"label": "快递公司代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "express_name",
"label": "快递公司名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "express_no",
"label": "快递单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "listId",
"label": "列表Id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "detailApi",
"label": "详细Api",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "details",
"label": "商品列表",
"children": [
{
"type": "String",
"field": "platform_code",
"label": "平台单号",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "qty",
"label": "商品数量",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "price",
"label": "实际单价",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "amount",
"label": "商品总价",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "memo",
"label": "备注",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "batchs",
"label": "批次",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "sns",
"label": "社交网络",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "goods_id",
"label": "商品标识",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "is_gift",
"label": "是否赠品",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "discount_fee",
"label": "让利金额",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "amount_after",
"label": "让利后金额",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "post_fee",
"label": "物流费用",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "post_cost",
"label": "物流成本",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "tax_rate",
"label": "税率",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "cost_price",
"label": "成本价",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "trade_code",
"label": "销售订单号",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "other_service_fee",
"label": "其他服务费",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "tax_amount",
"label": "税额",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "String",
"field": "order_type",
"label": "订单类型",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"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
},
{
"type": "object",
"field": "detailApi",
"label": "详情查询api",
"children": [
{
"type": "string",
"field": "api",
"label": "api",
"value": "gy.erp.kingdeecloud.delivery.details.querybycode",
"parent": "detailApi",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "Miscellaneous_Delivery/Save",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "array",
"field": "Page1",
"label": "表头",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"children": [
{
"type": "string",
"field": "Fdate",
"label": "日期",
"value": "{{delivery_time|date}}",
"parent": "Page1",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDeptID",
"label": "领料部门",
"value": "_findCollection find Fdepartment_FNumber from 0e70a6e2-190d-379a-8d3e-2bbb6ecc580f where FNumber={{shop_code}}",
"parent": "Page1",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSupplyID",
"label": "客户",
"value": "{{shop_code}}",
"parent": "Page1",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBillNo",
"label": "编 号",
"value": "{{code}}没价格",
"parent": "Page1",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FEmpID",
"label": "业务员",
"value": "_findCollection find Femployee_FNumber from 0e70a6e2-190d-379a-8d3e-2bbb6ecc580f where FNumber={{shop_code}}",
"parent": "Page1",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FManagerID",
"label": "负责人",
"value": "_findCollection find Femployee_FNumber from 0e70a6e2-190d-379a-8d3e-2bbb6ecc580f where FNumber={{shop_code}}",
"parent": "Page1",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FFManagerID",
"label": "领料",
"value": "_findCollection find Femployee_FNumber from 0e70a6e2-190d-379a-8d3e-2bbb6ecc580f where FNumber={{shop_code}}",
"parent": "Page1",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSManagerID",
"label": "发货",
"value": "_findCollection find Femployee_FNumber from 0e70a6e2-190d-379a-8d3e-2bbb6ecc580f where FNumber={{shop_code}}",
"parent": "Page1",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FHeadSelfB0942",
"label": "收货地址：",
"value": "{{area_name}}-{{receiver_address}}",
"parent": "Page1",
"describe": null,
"is_required": true
}
],
"describe": null,
"is_required": true
},
{
"type": "array",
"field": "Page2",
"label": "表体",
"value": "details",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"children": [
{
"type": "string",
"field": "FItemID",
"label": "产品代码",
"value": "{{details_goods_code}}",
"parent": "Page2",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBatchNo",
"label": "批号",
"value": "{{details_batchs_batch}}",
"parent": "Page2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FUnitID",
"label": "单位",
"value": "_findCollection find FOrderUnitID_FNumber from 5d62b9e3-246b-337f-88a6-7b44782b84c4 where FNumber={{details_goods_code}}",
"parent": "Page2",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "Fauxqty",
"label": "数量",
"value": "{{details_qty}}",
"parent": "Page2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDCStockID1",
"label": "发货仓库",
"value": "{{warehouse_code}}",
"parent": "Page2",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber",
"params2": "FName"
},
"describe": null,
"is_required": true
}
],
"describe": null,
"is_required": true
}
],
"response": [],
"autoCheck": "Miscellaneous_Delivery/CheckBill",
"otherRequest": [
{
"type": "object",
"field": "autoCheck",
"label": "审核参数",
"value": null,
"children": [
{
"type": "string",
"field": "api",
"label": "api",
"value": "Miscellaneous_Delivery/CheckBill",
"parent": "primaryWriteback",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillNo",
"label": "FBillNo",
"value": "{{Data.BillNo}}",
"parent": "primaryWriteback",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FChecker",
"label": "FChecker",
"value": "administrator",
"parent": "primaryWriteback",
"describe": null,
"is_required": false
},
{
"id": "FCheckDirection",
"type": "string",
"field": "FCheckDirection",
"label": "FCheckDirection",
"value": "1,2",
"parent": "autoCheck"
},
{
"id": "FDealComment",
"type": "string",
"field": "FDealComment",
"label": "FDealComment",
"value": "审核",
"parent": "autoCheck"
}
],
"describe": null,
"is_required": false
}
],
"otherResponse": [],
"groupCalculate": {
"bodyName": "details",
"bodyGroup": [
"details_goods_code",
"details_batchs_batch",
"details_qty",
"warehouse_code"
],
"calculate": [],
"bodyMaxLine": 100,
"headerGroup": [
"delivery_time",
"shop_code",
"code",
"area_name",
"receiver_address"
]
}
}
