吉客云与金蝶云星空账单查询对接金蝶付款单

源系统平台：吉客云
源系统接口： 分页查询货品信息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"}
}