源系统平台:金蝶云星空
源系统接口: 物料查询executeBillQuery
目标系统平台: 金蝶云星空
目标系统接口: 物料新增batchSave
源平台元数据配置:
{
"id": "FMasterId",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FNumber",
"idCheck": true,
"request": [
{
"type": "string",
"field": "FMasterId",
"label": "id",
"value": "FMasterId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FName",
"label": "名称",
"value": "FName",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSpecification",
"label": "规格型号",
"value": "FSpecification",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMnemonicCode",
"label": "助记码",
"value": "FMnemonicCode",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOldNumber",
"label": "旧物料编码",
"value": "FOldNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBARCODE",
"label": "条码",
"value": "FBARCODE",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": "FDescription",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaterialGroup_FNumber",
"label": "物料分组",
"value": "FMaterialGroup.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FErpClsID",
"label": "物料属性",
"value": "FErpClsID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "数据状态",
"value": "FDocumentStatus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FForbidStatus",
"label": "禁用状态",
"value": "FForbidStatus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBaseUnitId_FNumber",
"label": "基本单位.编码",
"value": "FBaseUnitId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": "FCreateOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": "FUseOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsInventory",
"label": "允许库存",
"value": "FIsInventory",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsSale",
"label": "允许销售",
"value": "FIsSale",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsAsset",
"label": "允许资产",
"value": "FIsAsset",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsSubContract",
"label": "允许委外",
"value": "FIsSubContract",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsProduce",
"label": "允许生产",
"value": "FIsProduce",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsPurchase",
"label": "允许采购",
"value": "FIsPurchase",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FStockId_FNumber",
"label": "仓库",
"value": "FStockId.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPurchaseOrgId_FNumber",
"label": "采购组织.编码",
"value": "FPurchaseOrgId.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPurchaseOrgId_FName",
"label": "采购组织",
"value": "FPurchaseOrgId.FName",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FIsBatchManage",
"label": "启用批号管理",
"value": "FIsBatchManage",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FIsKFPeriod",
"label": "启用保质期管理",
"value": "FIsKFPeriod",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FIsSNManage",
"label": "启用序列号管理",
"value": "FIsSNManage",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSafeStock",
"label": "安全库存",
"value": "FSafeStock",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCategoryID",
"label": "存货类别",
"value": "FCategoryID",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FExpPeriod",
"label": "保质期",
"value": "FExpPeriod",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderQty",
"label": "起订量",
"value": "FOrderQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMinQty",
"label": "最小批量",
"value": "FMinQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaxQty",
"label": "最大批量",
"value": "FMaxQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDefaultVendor_FNumber",
"label": "默认供应商",
"value": "FDefaultVendor.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaxPOQty",
"label": "最大订货量",
"value": "FMaxPOQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMinPOQty",
"label": "最小订货量",
"value": "FMinPOQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FIncreaseQty",
"label": "最小包装量",
"value": "FIncreaseQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FFixLeadTime",
"label": "固定提前期",
"value": "FFixLeadTime",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FVarLeadTime",
"label": "变动提前期",
"value": "FVarLeadTime",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPlanBatchSplitQty",
"label": "拆分批量",
"value": "FPlanBatchSplitQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FProduceBillType_FNumber",
"label": "生产类型",
"value": "FProduceBillType.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPOBillTypeId_FNumber",
"label": "采购类型",
"value": "FPOBillTypeId.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSubBillType_FNumber",
"label": "委外类型",
"value": "FSubBillType.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FGROSSWEIGHT",
"label": "毛重",
"value": "FGROSSWEIGHT",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FNETWEIGHT",
"label": "净重",
"value": "FNETWEIGHT",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWEIGHTUNITID_FNumber",
"label": "重量单位",
"value": "FWEIGHTUNITID.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FLENGTH",
"label": "长",
"value": "FLENGTH",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWIDTH",
"label": "宽",
"value": "FWIDTH",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FHEIGHT",
"label": "高",
"value": "FHEIGHT",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FVOLUME",
"label": "体积",
"value": "FVOLUME",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWARRANTY",
"label": "保修期",
"value": "FWARRANTY",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSalePrice_CMK",
"label": "零售价",
"value": "FSalePrice_CMK",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FVIPPrice_CMK",
"label": "会员价",
"value": "FVIPPrice_CMK",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPurPrice_CMK",
"label": "采购单价",
"value": "FPurPrice_CMK",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FComBrandId_CMK_FNumber",
"label": "品牌",
"value": "FComBrandId_CMK.FNumber",
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "FMasterId",
"label": "id",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FName",
"label": "名称",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSpecification",
"label": "规格型号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMnemonicCode",
"label": "助记码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOldNumber",
"label": "旧物料编码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBARCODE",
"label": "条码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaterialGroup_FNumber",
"label": "物料分组",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FErpClsID",
"label": "物料属性",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "数据状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FForbidStatus",
"label": "禁用状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBaseUnitId_FNumber",
"label": "基本单位.编码",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsInventory",
"label": "允许库存",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsSale",
"label": "允许销售",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsAsset",
"label": "允许资产",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsSubContract",
"label": "允许委外",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsProduce",
"label": "允许生产",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FIsPurchase",
"label": "允许采购",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FStockId_FNumber",
"label": "仓库",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPurchaseOrgId_FNumber",
"label": "采购组织.编码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPurchaseOrgId_FName",
"label": "采购组织",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FIsBatchManage",
"label": "启用批号管理",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FIsKFPeriod",
"label": "启用保质期管理",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FIsSNManage",
"label": "启用序列号管理",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSafeStock",
"label": "安全库存",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCategoryID",
"label": "存货类别",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FExpPeriod",
"label": "保质期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderQty",
"label": "起订量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMinQty",
"label": "最小批量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaxQty",
"label": "最大批量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDefaultVendor_FNumber",
"label": "默认供应商",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaxPOQty",
"label": "最大订货量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMinPOQty",
"label": "最小订货量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FIncreaseQty",
"label": "最小包装量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FFixLeadTime",
"label": "固定提前期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FVarLeadTime",
"label": "变动提前期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPlanBatchSplitQty",
"label": "拆分批量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FProduceBillType_FNumber",
"label": "生产类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPOBillTypeId_FNumber",
"label": "采购类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSubBillType_FNumber",
"label": "委外类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FGROSSWEIGHT",
"label": "毛重",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FNETWEIGHT",
"label": "净重",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWEIGHTUNITID_FNumber",
"label": "重量单位",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FLENGTH",
"label": "长",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWIDTH",
"label": "宽",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FHEIGHT",
"label": "高",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FVOLUME",
"label": "体积",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWARRANTY",
"label": "保修期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSalePrice_CMK",
"label": "零售价",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FVIPPrice_CMK",
"label": "会员价",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPurPrice_CMK",
"label": "采购单价",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FComBrandId_CMK_FNumber",
"label": "品牌",
"value": null,
"describe": null,
"is_required": false
}
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0",
"describe": "金蝶的查询分页参数",
"is_required": false
},
{
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "FApproveDate>='{{LAST_SYNC_TIME|dateTime}}'",
"describe": "示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=",
"is_required": false
},
{
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式:FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"is_required": true
},
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "BD_MATERIAL",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FName",
"label": "名称",
"value": "{{FName}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "{{FNumber}}测试",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": "{{FDescription}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCreateOrgId",
"label": "创建组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FUseOrgId",
"label": "使用组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": true
},
{
"type": "object",
"field": "SubHeadEntity",
"label": "基本",
"children": [
{
"type": "string",
"field": "FErpClsID",
"label": "物料属性",
"value": "{{FErpClsID}}",
"parent": "SubHeadEntity",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBaseUnitId",
"label": "基本单位",
"value": "{{FBaseUnitId_FNumber}}",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCategoryID",
"label": "存货类别",
"value": "CHLB01_SYS",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": true
}
],
"describe": null,
"is_required": true
},
{
"type": "object",
"field": "SubHeadEntity1",
"label": "库存",
"children": [
{
"type": "string",
"field": "FStockId",
"label": "仓库",
"value": "{{FStockId_FNumber}}",
"parent": "SubHeadEntity1",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"operation": {
"rows": 20,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "BD_MATERIAL",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "Save",
"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": []
}