源系统平台：吉客云
源系统接口： 分页查询货品信息erp.storage.goodslist
目标系统平台： 金蝶云星空
目标系统接口： 收款单新增batchSave
源平台元数据配置：
{
"id": "billAccountNo",
"api": "acs.billinfo.get",
"type": "QUERY",
"method": "Get",
"number": "billAccountNo",
"idCheck": true,
"request": [
{
"id": "7f474d36-cfc0-387f-9aab-d573c5f93544",
"type": "string",
"field": "pageIndex",
"label": "分页页码",
"value": "0",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "163270bd-0cb6-346f-9056-1ddfb4114861",
"type": "string",
"field": "pageSize",
"label": "分页页数",
"value": "20",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "e0b2bdd9-395e-3675-a20c-70fdd1180514",
"type": "string",
"field": "settleAccountNameHeader",
"label": "账户名",
"value": "$eq$拼多多享美食折扣店",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "a91c0cd9-2afa-382d-ab4f-fd925ef24fd8",
"type": "string",
"field": "bookTimeStart",
"label": "开始时间",
"value": "_function from_unixtime(({{CURRENT_TIME}}-5184000),'%Y-%m-%d %h:%i:%s')",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "ee74be56-c96a-3153-b9b9-f0ccca82eb3b",
"type": "string",
"field": "bookTimeEnd",
"label": "结束时间",
"value": "{{CURRENT_TIME|datetime}}",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "d696b5f8-585c-32dc-8973-79c6c71b9e9c",
"type": "string",
"field": "tradeNos",
"label": "网店订单号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "0203fcd5-b3b1-34e4-86fb-5f22000aa16c",
"type": "string",
"field": "billAccountNos",
"label": "账务流水号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "4dc49f68-0cec-35ba-b2ed-3e4b9711f3e4",
"type": "string",
"field": "bizNos",
"label": "业务流水号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "caName",
"type": "string",
"field": "billType",
"label": "账单类型",
"value": "1",
"parent": null
},
{
"id": "caName",
"type": "string",
"field": "auditStatus",
"label": "账单状态",
"value": "1",
"parent": null
},
{
"id": "caName",
"type": "string",
"field": "checkStatus",
"label": "对账状态",
"value": "1",
"parent": null
},
{
"id": "caName",
"type": "string",
"field": "oppAccountNum",
"label": "对方帐号",
"value": null,
"parent": null
},
{
"id": "caName",
"type": "string",
"field": "oppAccountName",
"label": "对方户名",
"value": null,
"parent": null
},
{
"id": "caName",
"type": "string",
"field": "tradeMemoHeader",
"label": "备注",
"value": null,
"parent": null
},
{
"id": "caName",
"type": "string",
"field": "itemName",
"label": "收支项目",
"value": null,
"parent": null
},
{
"id": "caName",
"type": "string",
"field": "gmtModifiedStart",
"label": "修改时间开始值",
"value": null,
"parent": null
},
{
"id": "caName",
"type": "string",
"field": "gmtModifiedEnd",
"label": "修改时间结束值",
"value": null,
"parent": null
}
],
"response": [
{
"id": "904119b1-9640-3d96-a878-f0115fc882ac",
"type": "string",
"field": "imgUrl",
"label": "图片地址",
"value": null,
"describe": "http:asasda.png",
"parent_id": null,
"is_required": false
},
{
"id": "b16c6a77-3e4b-3a6a-a6b6-e4be72ba2713",
"type": "string",
"field": "isMainImage",
"label": "是否主图 0-是 1-否",
"value": null,
"describe": "1",
"parent_id": null,
"is_required": false
},
{
"id": "6a153b63-86e9-3347-ba71-674cc7496f23",
"type": "string",
"field": "imagePosition",
"label": "图片位置main-主图 left-左侧图 right-右侧图 ",
"value": null,
"describe": "left",
"parent_id": null,
"is_required": false
},
{
"id": "83519ac2-7e7b-3634-891c-59cec1ce47d9",
"type": "string",
"field": "imgKey",
"label": "图片地址key",
"value": null,
"describe": "美美哒.png",
"parent_id": null,
"is_required": false
},
{
"id": "acb03ac4-9808-32df-b5ca-3cd21744cbc9",
"type": "string",
"field": "skuIsBlockup",
"label": "规格是否停用 0 否 1 是",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "316792aa-5178-3556-a680-e8073206c122",
"type": "string",
"field": "abcCate",
"label": "ABC分类(A类,B类,C类)",
"value": null,
"describe": "A类",
"parent_id": null,
"is_required": false
},
{
"id": "03e72615-e18c-3db6-98f3-6fb0d29d69f0",
"type": "string",
"field": "skuLength",
"label": "长",
"value": null,
"describe": "2",
"parent_id": null,
"is_required": false
},
{
"id": "0f4ced51-b712-3b07-969f-5f7dfc771383",
"type": "string",
"field": "skuWidth",
"label": "宽",
"value": null,
"describe": "1",
"parent_id": null,
"is_required": false
},
{
"id": "9f1b65f6-39b0-3d84-8c6d-40987f81cba4",
"type": "string",
"field": "skuHeight",
"label": "高",
"value": null,
"describe": "4",
"parent_id": null,
"is_required": false
},
{
"id": "8934cccc-126c-3681-b551-ad1842c905fd",
"type": "string",
"field": "colorCode",
"label": "颜色编码",
"value": null,
"describe": "1",
"parent_id": null,
"is_required": false
},
{
"id": "fe237f19-ff8e-3fa6-bd97-644a544c92df",
"type": "string",
"field": "goodsId",
"label": "货品ID",
"value": null,
"describe": "1123123",
"parent_id": null,
"is_required": false
},
{
"id": "10179f9d-8b79-3fb1-a3fc-e5296a99ae2f",
"type": "string",
"field": "colorName",
"label": "颜色名称",
"value": null,
"describe": "4",
"parent_id": null,
"is_required": false
},
{
"id": "b0af74e2-fd7b-385e-97f6-a732daaee7ac",
"type": "string",
"field": "goodsNo",
"label": "货品编号",
"value": null,
"describe": "货品编号",
"parent_id": null,
"is_required": false
},
{
"id": "11e1d22c-7c08-3f01-ace8-66ec817e7196",
"type": "string",
"field": "goodsName",
"label": "货品名称",
"value": null,
"describe": "货品名称",
"parent_id": null,
"is_required": false
},
{
"id": "d3ae7fb8-4976-3d28-9aed-5f0538b42162",
"type": "string",
"field": "sizeCode",
"label": "尺码编号",
"value": null,
"describe": "1",
"parent_id": null,
"is_required": false
},
{
"id": "8852a1a7-d508-37ea-b86f-b687857c76cc",
"type": "string",
"field": "sizeName",
"label": "尺寸名称",
"value": null,
"describe": "2",
"parent_id": null,
"is_required": false
},
{
"id": "f54991a2-4627-30df-9980-c117900deddc",
"type": "string",
"field": "skuName",
"label": "规格名称",
"value": null,
"describe": "规格名称",
"parent_id": null,
"is_required": false
},
{
"id": "6b421380-bff0-398e-96e1-3304a395dbc7",
"type": "string",
"field": "skuWeight",
"label": "重量(g)",
"value": null,
"describe": "1.2",
"parent_id": null,
"is_required": false
},
{
"id": "f91dc724-f46b-3261-95de-04bd30b3281b",
"type": "string",
"field": "skuId",
"label": "规格ID",
"value": null,
"describe": "1212",
"parent_id": null,
"is_required": false
},
{
"id": "67340e0c-d314-3acb-a962-41a8c8d32af7",
"type": "string",
"field": "volume",
"label": "体积（cm³）",
"value": null,
"describe": "1",
"parent_id": null,
"is_required": false
},
{
"id": "b5ecca9c-786b-34e0-86b5-9b9cd5079aba",
"type": "string",
"field": "skuBarcode",
"label": "条码",
"value": null,
"describe": "code_0001",
"parent_id": null,
"is_required": false
},
{
"id": "0d582002-a157-339b-b5ab-085de255d805",
"type": "string",
"field": "goodsGmtModified",
"label": "货品修改时间",
"value": null,
"describe": "1631020179000",
"parent_id": null,
"is_required": false
},
{
"id": "66fc19a5-f576-3796-bd9e-b5efaf40d608",
"type": "string",
"field": "unitName",
"label": "单位",
"value": null,
"describe": "个",
"parent_id": null,
"is_required": false
},
{
"id": "e8909a5c-f9e1-39c9-8f5e-45f4353b4813",
"type": "string",
"field": "cateId",
"label": "分类ID",
"value": null,
"describe": "12",
"parent_id": null,
"is_required": false
},
{
"id": "defa2cc5-d161-3a18-b4c0-18856ff2d4e5",
"type": "string",
"field": "cateName",
"label": "分类",
"value": null,
"describe": "服装",
"parent_id": null,
"is_required": false
},
{
"id": "a361eeaa-cb2e-3c27-8ca1-25750737b6ce",
"type": "string",
"field": "brandId",
"label": "品牌ID",
"value": null,
"describe": "12",
"parent_id": null,
"is_required": false
},
{
"id": "e7b4b7eb-4b02-34ed-80d7-e41751904c9c",
"type": "string",
"field": "brandName",
"label": "品牌",
"value": null,
"describe": "活鼎红",
"parent_id": null,
"is_required": false
},
{
"id": "3e0108c1-fc6e-33b4-9a69-273f74555cf2",
"type": "string",
"field": "skuCode",
"label": "外部货品code",
"value": null,
"describe": "123",
"parent_id": null,
"is_required": false
},
{
"id": "f707f2b3-4460-317a-8567-a67cf5b67c4b",
"type": "string",
"field": "goodsDesc",
"label": "货品描述",
"value": null,
"describe": "货品描述",
"parent_id": null,
"is_required": false
},
{
"id": "3f823268-5341-3656-8e5c-904014ef3e3b",
"type": "string",
"field": "goodsAlias",
"label": "货品别名",
"value": null,
"describe": "货品别名",
"parent_id": null,
"is_required": false
},
{
"id": "bd147622-d91d-3ee5-9027-1928349be2cf",
"type": "string",
"field": "goodsField",
"label": "货品自定义字段，对应吉客云自定义属性",
"value": null,
"describe": "货品自定义字段",
"parent_id": null,
"is_required": false
},
{
"id": "6fb61d85-b022-36ed-ba9c-9a410f895457",
"type": "string",
"field": "skuImgUrl",
"label": "规格图片",
"value": null,
"describe": "http:2qwuqweuq\\.png",
"parent_id": null,
"is_required": false
},
{
"id": "c7ab6ae2-1b94-3e49-bbbf-042337347a9e",
"type": "string",
"field": "extendValue",
"label": "自定义项",
"value": null,
"describe": "\"{\\\"extend843337487958029056\\\":\\\"121.0000\\\",\\\"extend855097154722339968\\\":\\\"驱蚊器二去\\\"}\",",
"parent_id": null,
"is_required": false
},
{
"id": "2ebdc8aa-81d8-3626-bd25-6d21bd095db7",
"type": "string",
"field": "imgUrlList",
"label": "货品图片详情",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
}
],
"condition": [
[
{
"field": "outAmount",
"logic": "gt",
"value": "0"
}
]
],
"buildModel": false,
"pagination": {
"pageSize": 50
},
"otherRequest": [],
"otherResponse": [],
"autoFillResponse": false
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": null,
"describe": "单据编号",
"is_required": false
},
{
"type": "string",
"field": "FSETTLEORGID",
"label": "结算组织",
"value": "_function CASE '{{settleAccountName}}' when '生和堂科技（天猫生和堂食品旗舰）支付宝' then 104 else 103 end",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "结算组织",
"is_required": false
},
{
"type": "string",
"field": "FEXCHANGETYPE",
"label": "汇率类型",
"value": "HLTX01_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCURRENCYID",
"label": "币别",
"value": "PRE001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "币别",
"is_required": true
},
{
"type": "string",
"field": "FDATE",
"label": "业务日期",
"value": "{{bookTime_new}}",
"describe": "业务日期",
"is_required": true
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "FKDLX02_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单据类型",
"is_required": true
},
{
"id": "FSALEORGID",
"type": "string",
"field": "FPURCHASEORGID",
"label": "采购组织",
"value": "_function CASE '{{settleAccountName}}' when '生和堂科技（天猫生和堂食品旗舰）支付宝' then 104 else 103 end",
"parent": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FCONTACTUNITTYPE",
"label": "往来单位类型",
"value": "BD_Customer",
"describe": "往来单位类型",
"is_required": true
},
{
"type": "string",
"field": "FCONTACTUNIT",
"label": "往来单位",
"value": "{{settleAccountName}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "63355e76dd8524103c0b8f13",
"describe": "往来单位",
"is_required": true,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FRECTUNITTYPE",
"label": "收款单位类型",
"value": "BD_Customer",
"describe": "付款单位类型",
"is_required": true
},
{
"type": "string",
"field": "FRECTUNIT",
"label": "收款单位",
"value": "{{settleAccountName}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "63355e76dd8524103c0b8f13",
"describe": "付款单位",
"is_required": true,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FBUSINESSTYPE",
"label": "业务类型",
"value": "3",
"describe": "业务类型",
"is_required": true
},
{
"type": "string",
"field": "FPAYORGID",
"label": "付款组织",
"value": "_function CASE '{{settleAccountName}}' when '生和堂科技（天猫生和堂食品旗舰）支付宝' then 104 else 103 end",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "收款组织",
"is_required": true
},
{
"type": "string",
"field": "FSETTLECUR",
"label": "结算币别",
"value": "PRE001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNUMBER"
},
"describe": null,
"is_required": true
},
{
"id": "FREMARK",
"type": "string",
"field": "FREMARK",
"label": "备注",
"value": null,
"parent": null
},
{
"type": "array",
"field": "FPAYBILLENTRY",
"label": "付款单明细",
"value": "details",
"children": [
{
"type": "string",
"field": "FSETTLETYPEID",
"label": "结算方式",
"value": "JSFS04_SYS",
"parent": "FRECEIVEBILLENTRY",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FPURPOSEID",
"label": "付款用途",
"value": "SFKYT2205100003",
"parent": "FRECEIVEBILLENTRY",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "收款用途",
"is_required": true
},
{
"type": "string",
"field": "FPAYTOTALAMOUNTFOR",
"label": "表体-应付金额",
"value": "{{details.outAmount}}",
"parent": "FRECEIVEBILLENTRY",
"describe": "表体-应收金额",
"is_required": false
},
{
"type": "string",
"field": "FACCOUNTID",
"label": "我方银行账号",
"value": "_findCollection find FNumber from e0411585-ebc3-30fb-ac16-872da1e0bfde where FName={{settleAccountName}}",
"parent": "FRECEIVEBILLENTRY",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "我方银行账号",
"is_required": false
},
{
"id": "FCOMMENT",
"type": "string",
"field": "FCOMMENT",
"label": "备注",
"value": "{{bizType}}",
"parent": "FRECEIVEBILLENTRY"
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "AP_PAYBILL",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "BatchSave",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "true",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false",
"describe": "是否验证所有的基础资料有效性，布尔类，默认false（非必录）",
"is_required": false
}
],
"otherResponse": [],
"groupCalculate": {
"bodyName": "details",
"bodyGroup": [
"bizType"
],
"calculate": {
"outAmount": "$sum"
},
"bodyMaxLine": 50,
"headerGroup": [
"settleAccountName",
"bookTime_new",
"bizType"
],
"targetBodyName": "FRECEIVEBILLENTRY"
}
}
