源系统平台:汤臣倍健营销云
源系统接口: 查询采购入库订单接口/erp/api/order/query/purInWarehsOrder
目标系统平台: 畅捷通T+
目标系统接口: 创建采购入库单/tplus/api/v2/purchaseReceive/Create
源平台元数据配置:
{
"id": "id",
"api": "/erp/api/order/query/purInWarehsOrder",
"type": "QUERY",
"method": "POST",
"number": "number",
"idCheck": true,
"request": [
{
"type": "string",
"field": "tenantId",
"label": "经销商id",
"value": null,
"describe": "经销商id(必填,营销云id)如:34cc4109705e4c058b7b3b0352e57d31",
"is_required": true
},
{
"type": "string",
"field": "yxyNumber",
"label": "营销云销售订单号",
"value": null,
"describe": "如:YD1215710122031701,传此参数时,其他时间状态等条件无效",
"is_required": false
},
{
"type": "string",
"field": "number",
"label": "系统订单号",
"value": null,
"describe": "如:XOUT0000000293,传此参数时,其他时间状态等条件无效",
"is_required": false
},
{
"type": "string",
"field": "status",
"label": "订单状态",
"value": "1",
"describe": "0:未审核 1:已审核(已出库)",
"is_required": false
},
{
"type": "string",
"field": "beginTime",
"label": "开始时间",
"value": null,
"describe": "timeType为空或者0,基于创建时间查询,timeType为1,基于更新时间查询,格式:0000-00-00或0000-00-00 00:00:00,如果不传单号此字段必填",
"is_required": false
},
{
"type": "string",
"field": "endTime",
"label": "结束时间",
"value": null,
"describe": "timeType为空或者0,基于创建时间查询,timeType为1,基于更新时间查询,格式:0000-00-00或0000-00-00 00:00:00,如果不传单号此字段必填",
"is_required": false
},
{
"type": "string",
"field": "pageNo",
"label": "页码",
"value": null,
"describe": "默认1",
"is_required": false
},
{
"type": "string",
"field": "pageSize",
"label": "每页条数",
"value": null,
"describe": "默认30",
"is_required": false
},
{
"type": "string",
"field": "timeType",
"label": "时间段标志",
"value": "1",
"describe": "查询时间段标识,0:创建时间(默认),1:最后更新时间",
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "number",
"label": "采购入库单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "yxyNumber",
"label": "营销云单号",
"value": null,
"describe": "营销云单号",
"is_required": false
},
{
"type": "string",
"field": "saleOrderNo",
"label": "汤臣销售单号",
"value": null,
"describe": "汤臣销售单号",
"is_required": false
},
{
"type": "string",
"field": "easSaleissueOrderNo",
"label": "汤臣托运单号",
"value": null,
"describe": "托运单号",
"is_required": false
},
{
"type": "string",
"field": "othernumber",
"label": "外部单号唯一标识",
"value": null,
"describe": "托运单号+公司id的hashCode",
"is_required": false
},
{
"type": "string",
"field": "opertime",
"label": "业务日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "approverId",
"label": "审批人id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "linknumber",
"label": "关联订单号",
"value": null,
"describe": "关联的源单号",
"is_required": false
},
{
"type": "string",
"field": "defaultnumber",
"label": "默认单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "organName",
"label": "供应商名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "organid",
"label": "供应商id",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sourceBillType",
"label": "来源订单类型",
"value": null,
"describe": "100:采购订单",
"is_required": false
},
{
"type": "string",
"field": "status",
"label": "订单状态",
"value": null,
"describe": "0:未审核,1:已审核(已出库)",
"is_required": false
},
{
"type": "string",
"field": "subtype",
"label": "单据类型",
"value": null,
"describe": "101:采购入库单",
"is_required": false
},
{
"type": "string",
"field": "tenantName",
"label": "公司名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "type",
"label": "出入库类型",
"value": null,
"describe": "-1:扣减库存,1:增加库存,0:不加不减",
"is_required": false
},
{
"type": "string",
"field": "version",
"label": "版本号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "itemList",
"label": "商品列表",
"children": [
{
"type": "string",
"field": "id",
"label": "明细行id",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "tenantId",
"label": "公司id",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "createtime",
"label": "创建时间",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "updateTime",
"label": "更新时间",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "remark",
"label": "备注",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "headerid",
"label": "订单id",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "depotName",
"label": "仓库名",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "depotNo",
"label": "仓库编号",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "depotid",
"label": "仓库id",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "materialName",
"label": "产品名称",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "materialNumber",
"label": "产品编码",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "materialid",
"label": "产品id",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "lot",
"label": "批次",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "mfg",
"label": "生产日期",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "exp",
"label": "到期日期",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "opernumber",
"label": "下单数量",
"value": null,
"parent": "itemList",
"describe": "真实出库数量",
"is_required": false
},
{
"type": "string",
"field": "basicnumber",
"label": "基础数量",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "taxrate",
"label": "税率",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "taxunitprice",
"label": "含税单价",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "taxlastmoney",
"label": "价税合计",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "extMaterialNo",
"label": "外围系统产品编码",
"value": null,
"parent": "itemList",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "helpCode",
"label": "产品助记码",
"value": null,
"parent": "itemList",
"describe": "如:AA010302",
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"pagination": {
"pageSize": 30
},
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "/tplus/api/v2/purchaseReceive/Create",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "ExternalCode",
"label": "外部单号",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "Code",
"label": "单据编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "VoucherType",
"label": "单据类型",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "VoucherDate",
"label": "单据日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "BusiType",
"label": "业务类型",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Partner",
"label": "往来单位",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "RdStyle",
"label": "出库类别",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Warehouse",
"label": "仓库",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "RDRecordDetails",
"label": "明细",
"children": [
{
"type": "string",
"field": "Inventory",
"label": "存货",
"value": null,
"parent": "RDRecordDetails",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Unit",
"label": "单位",
"value": null,
"parent": "RDRecordDetails",
"parser": {
"name": "ConvertObjectParser",
"params": "Code"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "BaseQuantity",
"label": "主计量单位数量",
"value": null,
"parent": "RDRecordDetails",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Amount",
"label": "成本金额",
"value": null,
"parent": "RDRecordDetails",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Price",
"label": "成本单价",
"value": null,
"parent": "RDRecordDetails",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"otherRequest": [
{
"type": "string",
"field": "dataKey",
"label": "dataKey",
"value": "dto",
"describe": null,
"is_required": false
}
],
"otherResponse": []
}