源系统平台：汤臣倍健营销云
源系统接口： 门户-查询订单表头&表体组合/openapi-basesubject/order/queryOrderHead
目标系统平台： 畅捷通T+
目标系统接口： 创建销售订单/tplus/api/v2/saleOrder/Create
源平台元数据配置：
{
"id": "id",
"api": "/openapi-basesubject/order/queryOrderHead",
"type": "QUERY",
"method": "POST",
"number": "no",
"idCheck": true,
"request": [
{
"type": "string",
"field": "orgId",
"label": "组织ID",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "page",
"label": "页码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "id",
"label": "订单id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "applyerId",
"label": "要货方id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "supplierId",
"label": "供货方id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "no",
"label": "订单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "distributionType",
"label": "分销类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "distributorId",
"label": "分销商id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "orderStatus",
"label": "订单状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "createDt",
"label": "创建时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "orderTypeCode",
"label": "订单类型,如普通订单、直运销售",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "isDeliveryFreezed",
"label": "是否暂停发货",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "nature",
"label": "订单分类",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "relatedApplyerId",
"label": "关联交易经销商id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "saleDistribution",
"label": "销售渠道",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "disApplyerId",
"label": "分销商id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "startDt",
"label": "订单时间（开始）",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "endDt",
"label": "订单时间（结束）",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "appStartDt",
"label": "审批时间（开始）",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "appEndDt",
"label": "审批时间（结束）",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "lastStartDt",
"label": "最后修改时间（开始）",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "lastEndDt",
"label": "最后修改时间（结束）",
"value": null,
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "applyerId",
"label": "要货方id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "supplierId",
"label": "供货方id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "no",
"label": "订单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "distributionType",
"label": "分销类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "distributorId",
"label": "分销商id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "orgId",
"label": "订单组织",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "orderStatus",
"label": "订单状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "createDt",
"label": "创建时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "contractNo",
"label": "合同编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "isReport",
"label": "是否随批报告",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "predictArriveDt",
"label": "预计到货日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "deliveryLevelCode",
"label": "发货优先级",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "orderTypeCode",
"label": "订单类型,如普通订单、直运销售",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "isDeliveryFreezed",
"label": "是否暂停发货",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "taxCode",
"label": "税码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "areaCode",
"label": "区域id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "currencyCode",
"label": "币种",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "settlementModeCode",
"label": "结算方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "deliveryCode",
"label": "交货方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "isCreditManaged",
"label": "是否信用暂挂",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "salesman",
"label": "订单销售人员",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "relatedApplyerId",
"label": "关联交易经销商id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "saleDistribution",
"label": "销售渠道",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "nature",
"label": "订单分类，如要货单、退货单",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "actGiftQuantity",
"label": "实际审批数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "giftQuantity",
"label": "赠品数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "province",
"label": "省份",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "city",
"label": "城市",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "county",
"label": "县城",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "newExchangeOrder",
"label": "是否新的积分订单绑定方式（婴童特殊要求，值为1是，没有值或0为否）",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "contacts",
"label": "收货联系人",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "phone",
"label": "收货联系人电话",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "storagePlace",
"label": "仓库归属地",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shippingAddress",
"label": "收货地址",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "expectDate",
"label": "预计到达天数",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "disApplyerId",
"label": "分销商id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "freeGiftTotal",
"label": "免费赠品余量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "discountTotalMoney",
"label": "产品折让总额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "returnedMoney",
"label": "应退金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "retunsOvertopMoney",
"label": "退货超额金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "remainMoney",
"label": "折让后金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "fineMoney",
"label": "罚金金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "totalMoney",
"label": "总金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "netDiscountTotalMoney",
"label": "网络品&赠品折让总额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "netDiscountCanuseMoney",
"label": "网络品(产品)使用网络品&赠品可用总额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "netDiscountMoney",
"label": "网络品(产品)实际使用网络品&赠品折让金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "netGiftDiscountCanuseMoney",
"label": "赠品使用网络品&赠品可用总额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "netGiftDiscountMoney",
"label": "赠品实际使用网络品&赠品折让金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "fullDiscountTotalMoney",
"label": "全品折让总额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "fullDiscountCanuseMoney",
"label": "产品使用全品可用总额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "fullDiscountMoney",
"label": "产品实际使用全品折让金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "fullGiftDiscountCanuseMoney",
"label": "赠品使用全品可用总额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "fullGiftDiscountMoney",
"label": "赠品实际使用全品折让金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "retunsFullyMoney",
"label": "全额退款金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "orderContacts",
"label": "订单联系人",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "orderPhone",
"label": "订单联系人电话",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "orderDt",
"label": "订单时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "approveDt",
"label": "审批时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "lastUpdateDt",
"label": "最后更新时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "clientAppNo",
"label": "经销商外围系统编码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "partnerName",
"label": "经销商名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "orgName",
"label": "租户名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "details",
"label": "明细",
"children": [
{
"type": "string",
"field": "id",
"label": "明细Id",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "discountMoney",
"label": "折扣后金额",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "quantity",
"label": "下单数量",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "productId",
"label": "产品id",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "productName",
"label": "产品名称",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "productNo",
"label": "产品编码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "spec",
"label": "规格",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "unitCode",
"label": "单位",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "minUnit",
"label": "包装数",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "basePrice",
"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": "actQuantity",
"label": "审批数量",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "money",
"label": "金额",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "type",
"label": "类型",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "isFree",
"label": "是否免费",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "discountAmount",
"label": "折扣额",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "discountPrice",
"label": "折扣后单价",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "discountRate",
"label": "折扣率",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "itemDiscountMoney",
"label": "普通行折让",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "itemFullDiscountMoney",
"label": "全品行折让",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "itemNetDiscountMoney",
"label": "网络品&赠品行折让",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "easNo",
"label": "产品长编码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "extNo",
"label": "产品外围编码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "batchNum",
"label": "产品批次号",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"pagination": {
"pageSize": 30
},
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "/tplus/api/v2/saleOrder/Create",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "VoucherDate",
"label": "单据日期",
"value": null,
"describe": "默认系统时间",
"is_required": false
},
{
"type": "string",
"field": "Code",
"label": "编码",
"value": null,
"describe": "1、T+系统单据编码。 2、此参数可空，为空时，默认按T+系统自动规则取值，若无法自动生成，则取外部系统单据编码。",
"is_required": false
},
{
"type": "string",
"field": "ExternalCode",
"label": "外部编码",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "BusinessType",
"label": "业务类型",
"value": "15",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Customer",
"label": "客户",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": "1、客户，PartnerDTO对象，客户信息。 2、PartnerDTO对象包括如下常用属性： { \"Code\": \"\"//T+系统客户编码 } 3、非空，此编码要与T+系统客户编码一致。",
"is_required": true
},
{
"type": "string",
"field": "Warehouse",
"label": "仓库",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": true
},
{
"type": "array",
"field": "SaleOrderDetails",
"label": "明细",
"children": [
{
"type": "string",
"field": "Inventory",
"label": "存货",
"value": null,
"parent": "SaleOrderDetails",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Unit",
"label": "单位",
"value": null,
"parent": "SaleOrderDetails",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Quantity",
"label": "数量",
"value": null,
"parent": "SaleOrderDetails",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "IsPresent",
"label": "是否赠品",
"value": "false",
"parent": "SaleOrderDetails",
"describe": "1、是否赠品\n2、为true时是赠品，为false时是非赠品",
"is_required": false
},
{
"type": "string",
"field": "DeliveryDate",
"label": "交货日期",
"value": null,
"parent": "SaleOrderDetails",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "TaxRate",
"label": "税率",
"value": "0.13",
"parent": "SaleOrderDetails",
"describe": "百分比",
"is_required": false
},
{
"type": "string",
"field": "OrigTaxPrice",
"label": "含税价",
"value": null,
"parent": "SaleOrderDetails",
"describe": null,
"is_required": true
}
],
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Memo",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "Warehouse",
"label": "仓库",
"value": null,
"parent": "SaleOrderDetails",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": true
}
],
"otherRequest": [
{
"type": "string",
"field": "dataKey",
"label": "dataKey",
"value": "dto",
"describe": null,
"is_required": false
}
],
"otherResponse": []
}
