源系统平台：管易云·奇门
源系统接口： 发货单查询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
},
{
"type": "string",
"field": "end_create",
"label": "创建时间结束段",
"value": null
},
{
"type": "string",
"field": "start_delivery_date",
"label": "发货时间开始段",
"value": "{{LAST_SYNC_TIME|datetime}}"
},
{
"type": "string",
"field": "end_delivery_date",
"label": "发货时间结束段",
"value": "{{CURRENT_TIME|datetime}}"
},
{
"type": "string",
"field": "start_ modify_date",
"label": "修改时间开始段",
"value": null
},
{
"type": "string",
"field": "end_ modify_date",
"label": "修改时间结束段",
"value": null
},
{
"type": "string",
"field": "del",
"label": "返回是否作废的单据",
"value": "0"
},
{
"type": "string",
"field": "delivery",
"label": "发货状态",
"value": "1"
},
{
"type": "string",
"field": "code",
"label": "单据编号",
"value": null
}
],
"response": [
{
"type": "string",
"field": "id",
"label": "id",
"value": null
},
{
"type": "string",
"field": "code",
"label": "单据编号",
"value": null
},
{
"type": "string",
"field": "warehouse_code",
"label": "仓库代码",
"value": null
},
{
"type": "string",
"field": "shop_code",
"label": "店铺代码",
"value": null
},
{
"type": "string",
"field": "outer_code",
"label": "平台单号",
"value": null
},
{
"type": "string",
"field": "print",
"label": "打印状态",
"value": null
},
{
"type": "string",
"field": "scan",
"label": "扫描状态",
"value": null
},
{
"type": "string",
"field": "delivery",
"label": "发货状态",
"value": null
},
{
"type": "string",
"field": "cod",
"label": "货到付款状态",
"value": null
},
{
"type": "string",
"field": "vip_name",
"label": "会员名称",
"value": null
},
{
"type": "string",
"field": "create_date",
"label": "制单时间",
"value": null
},
{
"type": "string",
"field": "modify_date",
"label": "修改时间",
"value": null
},
{
"type": "string",
"field": "delivery_date",
"label": "发货时间",
"value": null
},
{
"type": "string",
"field": "cancel",
"label": "取消状态",
"value": null
},
{
"type": "string",
"field": "payment",
"label": "已付金额",
"value": null
},
{
"type": "string",
"field": "pay_time",
"label": "支付时间",
"value": null
},
{
"type": "string",
"field": "invoiceDate",
"label": "确认开票时间",
"value": null
},
{
"type": "string",
"field": "bigchar",
"label": "大头笔",
"value": null
},
{
"type": "string",
"field": "unpaid_amount",
"label": "未付金额",
"value": null
},
{
"type": "string",
"field": "cod_fee",
"label": "货到付款服务费",
"value": null
},
{
"type": "string",
"field": "post_cost",
"label": "物流成本",
"value": null
},
{
"type": "string",
"field": "plan_delivery_date",
"label": "预计发货时间",
"value": null
},
{
"type": "string",
"field": "buyer_memo",
"label": "买家留言",
"value": null
},
{
"type": "string",
"field": "seller_memo",
"label": "卖家备注",
"value": null
},
{
"type": "string",
"field": "receiver_name",
"label": "收货人姓名",
"value": null
},
{
"type": "string",
"field": "receiver_phone",
"label": "收货人电话",
"value": null
},
{
"type": "string",
"field": "receiver_mobile",
"label": "收货人手机",
"value": null
},
{
"type": "string",
"field": "receiver_zip",
"label": "收货邮编",
"value": null
},
{
"type": "string",
"field": "receiver_address",
"label": "收货地址",
"value": null
},
{
"type": "string",
"field": "create_name",
"label": "制单人",
"value": null
},
{
"type": "string",
"field": "express_no",
"label": "快递单号",
"value": null
},
{
"type": "string",
"field": "shop_name",
"label": "店铺名称",
"value": null
},
{
"type": "string",
"field": "area_name",
"label": "收货地区",
"value": null
},
{
"type": "string",
"field": "warehouse_name",
"label": "仓库名称",
"value": null
},
{
"type": "string",
"field": "location_code",
"label": "库位代码",
"value": null
},
{
"type": "string",
"field": "express_code",
"label": "快递公司代码",
"value": null
},
{
"type": "string",
"field": "express_name",
"label": "快递公司名称",
"value": null
},
{
"type": "string",
"field": "tag_name",
"label": "订单标记名称",
"value": null
},
{
"type": "string",
"field": "seller_memo_late",
"label": "二次备注",
"value": null
},
{
"type": "string",
"field": "shelf_no",
"label": "格子号",
"value": null
},
{
"type": "array",
"field": "details",
"label": "商品列表",
"value": null,
"children": [
{
"type": "string",
"field": "qty",
"label": "商品数量",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "price",
"label": "实际单价",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "amount",
"label": "商品总价",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "refund",
"label": "退款状态",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "itemCategoryName",
"label": "商品类别名称",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "itemUnitName",
"label": "商品单位",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "barcode",
"label": "商品条码",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "tariff",
"label": "关税",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "memo",
"label": "备注",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "picUrl",
"label": "图片地址",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "oid",
"label": "子订单号",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "trade_code",
"label": "销售订单号",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "item_id",
"label": "商品ID",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "item_sku_id",
"label": "规格ID",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "item_code",
"label": "商品代码",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "item_name",
"label": "商品名称",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "sku_code",
"label": "规格代码",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "sku_name",
"label": "规格名称",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "sku_note",
"label": "商品的规格备注",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "discount_fee",
"label": "让利金额",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "amount_after",
"label": "让利后金额",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "post_fee",
"label": "物流费用",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "order_type",
"label": "订单类型",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "platform_flag",
"label": "平台旗帜",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "detail_unique",
"label": "唯一码列表",
"value": null,
"parent": "details"
},
{
"type": "array",
"field": "detail_batch",
"label": "批次列表",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "is_gift",
"label": "是否赠品",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "businessman_name",
"label": "业务员",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "platform_code",
"label": "平台单号",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "tax_rate",
"label": "税率",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "tax_amount",
"label": "税额",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "tax_no",
"label": "税号",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "other_service_fee",
"label": "其他服务费",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "gift_source_view",
"label": "赠品来源",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "currency_code",
"label": "币别代码",
"value": null,
"parent": "details"
},
{
"type": "string",
"field": "currency_name",
"label": "币别名称",
"value": null,
"parent": "details"
}
]
},
{
"type": "array",
"field": "detail_batch",
"label": "批次列表",
"value": null,
"children": [
{
"type": "string",
"field": "batchNumber",
"label": "批次号",
"value": null,
"parent": "detail_batch"
},
{
"type": "string",
"field": "qty",
"label": "数量",
"value": null,
"parent": "detail_batch"
},
{
"type": "string",
"field": "productionTime",
"label": "生产日期",
"value": null,
"parent": "detail_batch"
},
{
"type": "string",
"field": "validTime",
"label": "有效日期",
"value": null,
"parent": "detail_batch"
}
]
},
{
"type": "array",
"field": "delivery_statusInfo",
"label": "单据状态信息",
"value": null,
"children": [
{
"type": "string",
"field": "delivery_date",
"label": "发货时间",
"value": null,
"parent": "delivery_statusInfo"
}
]
},
{
"type": "string",
"field": "invoices",
"label": "发票列表",
"value": null
},
{
"type": "string",
"field": "vip_code",
"label": "会员代码",
"value": null
},
{
"type": "string",
"field": "vip_real_name",
"label": "真实姓名",
"value": null
},
{
"type": "string",
"field": "vip_id_card",
"label": "身份证号码",
"value": null
},
{
"type": "string",
"field": "package_center_code",
"label": "集包地代码",
"value": null
},
{
"type": "string",
"field": "package_center_name",
"label": "集包地名称",
"value": null
},
{
"type": "string",
"field": "sync_status",
"label": "数据同步状态",
"value": null
},
{
"type": "string",
"field": "sync_memo",
"label": "数据同步备注",
"value": null
},
{
"type": "string",
"field": "picture_bill",
"label": "是否多包裹",
"value": null
},
{
"type": "string",
"field": "drp_tenant_name",
"label": "分销商名称",
"value": null
},
{
"type": "string",
"field": "drp_tenant_mobile",
"label": "分销商手机号",
"value": null
}
],
"pagination": {
"pageSize": 20
},
"otherRequest": [
{
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "{{PAGINATION_PAGE_SIZE}}"
},
{
"type": "string",
"field": "page_no",
"label": "页号",
"value": "{{PAGINATION_START_PAGE}}"
}
],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "XSCKD01_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{code}}"
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "{{delivery_statusInfo.delivery_date}}"
},
{
"type": "string",
"field": "FSaleOrgId",
"label": "销售组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FCustomerID",
"label": "客户",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FSaleDeptID",
"label": "销售部门",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FStockOrgId",
"label": "发货组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": null
},
{
"type": "string",
"field": "F_ora_platform_code",
"label": "网上订单号",
"value": "{{platform_code}}"
},
{
"type": "string",
"field": "F_PBLH_Text",
"label": "平台单号",
"value": "{{platform_code}}"
},
{
"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.sku_code}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FRealQty",
"label": "实发数量",
"value": "{{details.qty}}",
"parent": "FEntity"
},
{
"type": "string",
"field": "FPrice",
"label": "单价",
"value": null,
"parent": "FEntity"
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": null,
"parent": "FEntity"
},
{
"type": "string",
"field": "FIsFree",
"label": "是否赠品",
"value": null,
"parent": "FEntity"
},
{
"type": "string",
"field": "FLot",
"label": "批号",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": null,
"parent": "FEntity"
},
{
"type": "string",
"field": "FExpiryDate",
"label": "有效期至",
"value": null,
"parent": "FEntity"
},
{
"type": "string",
"field": "FEntryTaxRate",
"label": "税率%",
"value": null,
"parent": "FEntity"
},
{
"type": "string",
"field": "FAmount",
"label": "金额",
"value": null,
"parent": "FEntity"
},
{
"type": "string",
"field": "FAllAmount",
"label": "价税合计",
"value": "{{details.amount_after}}",
"parent": "FEntity"
},
{
"type": "string",
"field": "FStockID",
"label": "仓库",
"value": "{{warehouse_code}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FOwnerTypeId",
"label": "货主类型",
"value": "BD_OwnerOrg",
"parent": "FEntity"
},
{
"type": "string",
"field": "FOwnerId",
"label": "货主",
"value": "100",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FEntrynote",
"label": "备注",
"value": null,
"parent": "FEntity"
},
{
"type": "string",
"field": "F_PBLH_Decimal",
"label": "原订单金额",
"value": "{{amount}}",
"parent": "FEntity"
},
{
"type": "string",
"field": "F_PBLH_Decimal1",
"label": "让利金额",
"value": "{{discount_fee}}",
"parent": "FEntity"
},
{
"type": "string",
"field": "F_PBLH_Assistant",
"label": "管易订单类型",
"value": "{{order_type}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "F_PBLH_Decimal4",
"label": "管易让利后金额对比",
"value": "{{details.amount_after}}",
"parent": "FEntity"
},
{
"type": "string",
"field": "F_PBLH_Decimal5",
"label": "管易物流费用",
"value": "{{details.post_fee}}",
"parent": "FEntity"
}
]
}
],
"response": [],
"operation": {
"rows": 20,
"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": "false"
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "true"
},
{
"id": "SubSystemId",
"type": "string",
"field": "SubSystemId",
"label": "相应位置",
"value": "21",
"parent": null
}
],
"otherResponse": []
}
