源系统平台：管易云·奇门
源系统接口： 发货单查询gy.erp.trade.deliverys.get
目标系统平台： 金蝶云星空
目标系统接口： 销售出库新增batchSave
源平台元数据配置：
{
"id": "code",
"api": "gy.erp.trade.deliverys.get",
"type": "QUERY",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "string",
"field": "start_create",
"label": "创建时间开始段",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "end_create",
"label": "创建时间结束段",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "start_delivery_date",
"label": "发货时间开始段",
"value": "2022-05-29 00:00:00",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "end_delivery_date",
"label": "发货时间结束段",
"value": "2022-05-29 23:59:58",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "start_modify_date",
"label": "修改时间开始段",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "end_modify_date",
"label": "修改时间结束段",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "del",
"label": "返回是否作废的单据",
"value": null,
"describe": null,
"is_required": false
}
],
"beatFlat": [
"details",
"detail_batch"
],
"response": [
{
"type": "string",
"field": "id",
"label": "id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "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": "shop_code",
"label": "店铺代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outer_code",
"label": "平台单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "print",
"label": "打印状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "scan",
"label": "扫描状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "delivery",
"label": "发货状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "cod",
"label": "货到付款状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "vip_name",
"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": "cancel",
"label": "取消状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "payment",
"label": "已付金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "pay_time",
"label": "支付时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "invoiceDate",
"label": "确认开票时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "bigchar",
"label": "大头笔",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "unpaid_amount",
"label": "未付金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "cod_fee",
"label": "货到付款服务费",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "post_cost",
"label": "物流成本",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "plan_delivery_date",
"label": "预计发货时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "buyer_memo",
"label": "买家留言",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "seller_memo",
"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": "receiver_zip",
"label": "收货邮编",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "receiver_address",
"label": "收货地址",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "create_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": "shop_name",
"label": "店铺名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "area_name",
"label": "收货地区",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "warehouse_name",
"label": "仓库名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "location_code",
"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": "tag_name",
"label": "订单标记名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "seller_memo_late",
"label": "二次备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shelf_no",
"label": "格子号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "details",
"label": "商品列表",
"value": null,
"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": "refund",
"label": "退款状态",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "itemCategoryName",
"label": "商品类别名称",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "itemUnitName",
"label": "商品单位",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "barcode",
"label": "商品条码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "tariff",
"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": "picUrl",
"label": "图片地址",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "oid",
"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": "item_id",
"label": "商品ID",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_sku_id",
"label": "规格ID",
"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": "item_name",
"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": "sku_name",
"label": "规格名称",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sku_note",
"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": "order_type",
"label": "订单类型",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "platform_flag",
"label": "平台旗帜",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "detail_unique",
"label": "唯一码列表",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "detail_batch",
"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": "businessman_name",
"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": "tax_rate",
"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": "tax_no",
"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": "gift_source_view",
"label": "赠品来源",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "currency_code",
"label": "币别代码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "currency_name",
"label": "币别名称",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "delivery_statusInfo",
"label": "单据状态信息",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "invoices",
"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_real_name",
"label": "真实姓名",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "vip_id_card",
"label": "身份证号码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "package_center_code",
"label": "集包地代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "package_center_name",
"label": "集包地名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sync_status",
"label": "数据同步状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sync_memo",
"label": "数据同步备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "picture_bill",
"label": "是否多包裹",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "drp_tenant_name",
"label": "分销商名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "drp_tenant_mobile",
"label": "分销商手机号",
"value": null,
"describe": null,
"is_required": false
}
],
"condition": [
[
{
"field": "item_code",
"logic": "neq",
"value": "BF"
}
]
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"type": "string",
"field": "page_no",
"label": "页号",
"value": "{{PAGINATION_START_PAGE}}",
"describe": "默认1",
"is_required": false
},
{
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "{{PAGINATION_PAGE_SIZE}}",
"is_required": false
}
],
"otherResponse": [],
"formatResponse": [
{
"new": "modify_date_new",
"old": "delivery_statusInfo.delivery_date",
"format": "date"
}
]
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "XSCKD07_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": null
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "{{modify_date_new}}"
},
{
"type": "string",
"field": "FSaleOrgId",
"label": "销售组织",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "60abcf24c3a33b7df63aa832",
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FCustomerID",
"label": "客户",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "60abcf1772b0a303c05ab1c7",
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FSaleDeptID",
"label": "销售部门",
"value": "BM000002",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FStockOrgId",
"label": "发货组织",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "60abd0252f7f2f57fa2a7ce9",
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FStockerID",
"label": "仓管员",
"value": "ck102",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "F_BBB_Assistant",
"label": "产品类别",
"value": "T03-1",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FNOTE",
"label": "备注",
"value": "{{shop_code}}",
"mapping": "60b05d870a74bc011c07d5e8",
"mappingDirection": "positive"
},
{
"type": "array",
"field": "FEntity",
"label": "明细信息",
"value": "details",
"children": [
{
"type": "string",
"field": "FMaterialID",
"label": "物料编码",
"value": "{{details.details_item_code}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FRealQty",
"label": "实发数量",
"value": "{{details_detail_batch_qty}}",
"parent": "FEntity"
},
{
"type": "string",
"field": "FEntryTaxRate",
"label": "税率",
"value": "{{details_tax_rate}}",
"parent": "FEntity"
},
{
"type": "string",
"field": "FAllAmount",
"label": "价税合计",
"value": "{{details_amount_after}}",
"parent": "FEntity"
},
{
"type": "string",
"field": "FOwnerTypeId",
"label": "货主类型",
"value": "BD_OwnerOrg"
},
{
"type": "string",
"field": "FOwnerId",
"label": "货主",
"value": "{{warehouse_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "60abceeca8e7eb7dd360bb54",
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FLot",
"label": "批次号",
"value": "{{details_detail_batch_batchNumber}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FStockID",
"label": "仓库",
"value": "{{warehouse_code}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FStockStatusID",
"label": "库存状态",
"value": "KCZT01_SYS",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"id": "生产日期",
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": "{{details_detail_batch_productionTime}}",
"parent": "FEntity"
},
{
"id": "生产日期",
"type": "string",
"field": "FExpiryDate",
"label": "有效期至",
"value": "{{details_detail_batch_validTime}}",
"parent": "FEntity"
}
]
},
{
"type": "object",
"field": "SubHeadEntity",
"label": "财务信息",
"children": [
{
"type": "string",
"field": "FSettleOrgID",
"label": "结算组织",
"value": "{{shop_code}}",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "60abcf24c3a33b7df63aa832",
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FSETTLECURRID",
"label": "结算币别",
"value": "PRE001",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FIsIncludedTax",
"label": "是否含税",
"value": "true",
"parent": "SubHeadEntity"
}
]
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "SAL_OUTSTOCK"
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "Save"
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "true"
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false"
},
{
"id": "SubSystemId",
"type": "string",
"field": "SubSystemId",
"label": "相应位置",
"value": "21",
"parent": null
}
],
"otherResponse": [],
"groupCalculate": {
"bodyName": "details",
"bodyGroup": [
"details_item_code",
"details_detail_batch_batchNumber",
"details_tax_rate",
"details_detail_batch_productionTime",
"details_detail_batch_validTime"
],
"calculate": {
"details_amount_after": "$sum",
"details_detail_batch_qty": "$sum"
},
"bodyMaxLine": 50,
"headerGroup": [
"shop_code",
"warehouse_code",
"modify_date_new"
],
"targetBodyName": "FEntity"
}
}
