源系统平台：管易云
源系统接口： 发货单查询2.0gy.erp.kingdeecloud.delivery.orders.querybydate
目标系统平台： 金蝶云星空
目标系统接口： 发货通知单新增batchSave
源平台元数据配置：
{
"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": "2022-06-06 14:00:00",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "end_date",
"label": "创建时间结束段",
"value": "2022-06-06 16:00:00",
"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
}
],
"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": "platform_code",
"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": "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": "platform_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
}
],
"describe": null,
"is_required": false
}
],
"condition": [
[
{
"field": "shop_code",
"logic": "eq",
"value": "004"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "alibaba"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "HONGXING"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "11418388"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "003"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "1000855"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "650928"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "163389"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "38"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "JBMEOM"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "005"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "1216"
}
]
],
"pagination": {
"pageSize": 100
},
"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": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "DSFHTZD",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单据类型",
"is_required": false
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{code}}",
"describe": "单据编号",
"is_required": false
},
{
"type": "string",
"field": "FSaleOrgId",
"label": "销售组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "销售组织",
"is_required": false
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "{{delivery_time}}",
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FCustomerID",
"label": "客户",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "客户",
"is_required": false
},
{
"type": "string",
"field": "FSaleDeptID",
"label": "销售部门",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "销售部门",
"is_required": false
},
{
"type": "string",
"field": "F_ora_platform_code",
"label": "网上订单号",
"value": "{{platform_code}}",
"describe": "运输单号",
"is_required": false
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": null,
"describe": "备注",
"is_required": false
},
{
"type": "string",
"field": "FDeliveryOrgID",
"label": "发货组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "发货组织",
"is_required": false
},
{
"type": "string",
"field": "FReceiverContactID",
"label": "收货方联系人",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"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": "object",
"field": "SubHeadEntity",
"label": "财务信息",
"children": [
{
"type": "string",
"field": "FSettleOrgID",
"label": "结算组织",
"value": "100",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FSETTLECURRID",
"label": "结算币别",
"value": "PRE001",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
}
]
},
{
"type": "array",
"field": "FEntity",
"label": "明细信息",
"value": "details",
"children": [
{
"type": "string",
"field": "FMaterialID",
"label": "物料编码",
"value": "{{details.goods_code}}",
"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": "{{warehouse_code}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "出货仓库",
"is_required": false
},
{
"type": "string",
"field": "FNoteEntry",
"label": "备注",
"value": "{{details.memo}}",
"parent": "FEntity",
"describe": "备注",
"is_required": false
},
{
"type": "string",
"field": "FLot",
"label": "批号",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "批号",
"is_required": false
},
{
"type": "string",
"field": "FPRODUCEDATE",
"label": "生产日期",
"value": null,
"parent": "FEntity",
"describe": "生产日期",
"is_required": false
},
{
"type": "string",
"field": "FEXPPERIOD",
"label": "保质期",
"value": null,
"parent": "FEntity",
"describe": "保质期",
"is_required": false
},
{
"type": "string",
"field": "FEXPIRYDATE",
"label": "有效期至",
"value": null,
"parent": "FEntity",
"describe": "有效期至",
"is_required": false
},
{
"type": "string",
"field": "FIsFree",
"label": "是否赠品",
"value": "{{details.is_gift}}",
"parent": "FEntity",
"describe": "是否赠品",
"is_required": false
},
{
"type": "string",
"field": "FPrice",
"label": "单价",
"value": null,
"parent": "FEntity",
"describe": "单价",
"is_required": false
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": null,
"parent": "FEntity",
"describe": "含税单价",
"is_required": false
},
{
"type": "string",
"field": "FEntryTaxRate",
"label": "税率%",
"value": null,
"parent": "FEntity",
"describe": "税率%",
"is_required": false
},
{
"type": "string",
"field": "FAmount",
"label": "金额",
"value": null,
"parent": "FEntity",
"describe": "金额",
"is_required": false
},
{
"type": "string",
"field": "FEntryTaxAmount",
"label": "税额",
"value": null,
"parent": "FEntity",
"describe": "税额",
"is_required": false
},
{
"type": "string",
"field": "FAllAmount",
"label": "价税合计",
"value": "{{details.amount_after}}",
"parent": "FEntity",
"describe": "价税合计",
"is_required": false
}
],
"describe": "明细信息",
"is_required": false
}
],
"response": [],
"operation": {
"rows": 20,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "SAL_DELIVERYNOTICE",
"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": "false",
"describe": "是否验证所有的基础资料有效性，布尔类，默认false（非必录）",
"is_required": false
}
],
"otherResponse": []
}
