源系统平台:管易云·奇门
源系统接口: 发货单查询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": "{{LAST_SYNC_TIME|datetime}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "end_delivery_date",
"label": "发货时间结束段",
"value": "{{CURRENT_TIME|datetime}}",
"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
}
],
"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": "shop_code",
"logic": "eq",
"value": "B001"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "B003"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "B007"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "B008"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "B009"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "DY001"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "B010"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "B012"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "B014"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "B015"
}
],
[
{
"field": "shop_code",
"logic": "eq",
"value": "B011"
}
]
],
"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": []
}
目标平台元数据配置:
{
"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"
},
"describe": "单据类型",
"is_required": true
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{code}}",
"describe": "单据编号",
"is_required": true
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "{{modify_date}}",
"describe": "日期",
"is_required": true
},
{
"type": "string",
"field": "FSaleOrgId",
"label": "销售组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": true
},
{
"type": "string",
"field": "FCustomerID",
"label": "客户",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FSaleDeptID",
"label": "销售部门",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FCorrespondOrgId",
"label": "对应组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "F_ora_platform_code",
"label": "网上订单号",
"value": "{{details.platform_code}}",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "F_ora_Base",
"label": "项目",
"value": "{{shop_code}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "F_ora_tag_name",
"label": "电商订单标记名称",
"value": "{{details.platform_flag}}",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "F_ora_Text",
"label": "收货人",
"value": "{{receiver_name}}",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FStockOrgId",
"label": "发货组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": null,
"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"
},
"describe": "组织",
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "FEntity",
"label": "明细信息",
"value": "details",
"children": [
{
"type": "string",
"field": "FMaterialID",
"label": "物料编码",
"value": "{{details.item_code}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FRealQty",
"label": "实发数量",
"value": "{{details.qty}}",
"parent": "FEntity",
"describe": "数量",
"is_required": true
},
{
"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": "FIsFree",
"label": "是否赠品",
"value": "_function case '{{details.amount_after}}' when '0' then true else false end",
"parent": "FEntity",
"describe": "复选框",
"is_required": false
},
{
"type": "string",
"field": "FLot",
"label": "批号",
"value": "1",
"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": "FExpiryDate",
"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": "FEntryTaxAmount",
"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": "FAllAmount",
"label": "价税合计",
"value": "{{details.amount_after}}",
"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": "FEntrynote",
"label": "备注",
"value": null,
"parent": "FEntity",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "F_ora_eplatform_code",
"label": "网上订单号",
"value": "{{details.platform_code}}",
"parent": "FEntity",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FDiscountRate",
"label": "折扣率%",
"value": null,
"parent": "FEntity",
"describe": "小数",
"is_required": false
}
],
"describe": null,
"is_required": true
}
],
"response": [],
"operation": {
"rows": 20,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "SAL_OUTSTOCK",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "Save",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "false",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false",
"describe": "是否验证所有的基础资料有效性,布尔类,默认false(非必录)",
"is_required": false
},
{
"type": "string",
"field": "SubSystemId",
"label": "系统模块",
"value": "21",
"describe": "默认仓库模块",
"is_required": false
}
],
"otherResponse": []
}