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

最新推荐文章于 2024-05-06 09:48:16 发布

轻易云系统集成平台

最新推荐文章于 2024-05-06 09:48:16 发布

阅读量309

点赞数

分类专栏：系统对接金蝶系统集成文章标签： java mysql 开发语言

原文链接：https://bbs.qeasy.cloud/d/749-ji-ke-yun-yu-jin-die-yun-xing-kong-ji-ke-yun-zhang-dan-cha-xun-dui-jie-jin-die-fu-kuan-dan

版权

系统对接同时被 3 个专栏收录

76 篇文章 1 订阅

订阅专栏

系统集成

75 篇文章 2 订阅

订阅专栏

金蝶

41 篇文章 5 订阅

订阅专栏

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