源系统平台：金蝶云星空
源系统接口： 物料查询executeBillQuery
目标系统平台： 管易云
目标系统接口： 商品新增gy.erp.item.add
源平台元数据配置：
{
"id": "FMATERIALID",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FNumber",
"idCheck": true,
"request": [
{
"id": "f2b482a8-43b6-3772-80ff-f14e09acbaac",
"type": "string",
"field": "FMATERIALID",
"label": "实体主键",
"value": "FMATERIALID",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "57a13bca-3ff3-3930-9346-8742f6dc82bb",
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "44ebeb31-cae8-3ecf-a4c7-b0ec0b25b314",
"type": "string",
"field": "FName",
"label": "名称",
"value": "FName",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "e2293815-5ba4-3c05-ad38-57e0316b93f4",
"type": "string",
"field": "FSpecification",
"label": "规格型号",
"value": "FSpecification",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "35004d3f-829c-3f42-9118-49e49f639ab5",
"type": "string",
"field": "FOldNumber",
"label": "旧物料编码",
"value": "FOldNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "bbfd00a7-fd7d-353e-8528-fb62a9dcd5b7",
"type": "string",
"field": "FBARCODE",
"label": "条码",
"value": "FBARCODE",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "61ea5cdd-805f-31f0-a266-f2e886c2c374",
"type": "string",
"field": "FDescription",
"label": "描述",
"value": "FDescription",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "ca408ff4-545c-3ae7-8a8d-e297f6f46347",
"type": "string",
"field": "FMaterialGroup_FNumber",
"label": "物料分组",
"value": "FMaterialGroup.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "fd7701d6-dd98-33a6-927b-5603392cee53",
"type": "string",
"field": "FErpClsID",
"label": "物料属性",
"value": "FErpClsID",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "2e8dde34-edd1-3cc5-a00f-bbace75cf696",
"type": "string",
"field": "FDocumentStatus",
"label": "数据状态",
"value": "FDocumentStatus",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "b06cfac9-b019-37b6-be65-5375d92c73da",
"type": "string",
"field": "FForbidStatus",
"label": "禁用状态",
"value": "FForbidStatus",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "167c413b-a91a-3106-a4e5-bf79b354304a",
"type": "string",
"field": "FBaseUnitId_FNumber",
"label": "基本单位.编码",
"value": "FBaseUnitId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "692fe340-85ce-39ab-9b40-cc4b7dde6b11",
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": "FCreateOrgId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "07f3e14e-3197-3262-96ee-d50714ce9738",
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": "FUseOrgId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "9b0024e1-d469-3d3f-9a24-fff319392895",
"type": "string",
"field": "FIsInventory",
"label": "允许库存",
"value": "FIsInventory",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "a0ee5fe6-057a-3cab-af5e-daf076ad07bd",
"type": "string",
"field": "FIsSale",
"label": "允许销售",
"value": "FIsSale",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "175d41ad-52b6-34b0-ab60-a57fce7d4425",
"type": "string",
"field": "FIsAsset",
"label": "允许资产",
"value": "FIsAsset",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "c688820c-3de6-3421-9026-5cd8d2b3691e",
"type": "string",
"field": "FIsSubContract",
"label": "允许委外",
"value": "FIsSubContract",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "2cb4b8c4-e034-3608-a320-fa5d7241b7a3",
"type": "string",
"field": "FIsProduce",
"label": "允许生产",
"value": "FIsProduce",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "2e55b159-83b0-3660-adf2-8595a1d90618",
"type": "string",
"field": "FIsPurchase",
"label": "允许采购",
"value": "FIsPurchase",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "079c8e31-effe-3724-b185-8e38d13ab277",
"type": "string",
"field": "FStockId_FNumber",
"label": "仓库",
"value": "FStockId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "86019dfb-5c1c-34d6-941a-6d0830eafe35",
"type": "string",
"field": "FPurchaseOrgId_FNumber",
"label": "采购组织.编码",
"value": "FPurchaseOrgId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "1152d7c9-18f2-37cb-bf52-fabc8c76fd8e",
"type": "string",
"field": "FPurchaseOrgId_FName",
"label": "采购组织",
"value": "FPurchaseOrgId.FName",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "9973c8eb-92d8-3311-b5ae-9fa5bcac8fd4",
"type": "string",
"field": "FIsBatchManage",
"label": "启用批号管理",
"value": "FIsBatchManage",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "e832c3e8-8800-3b98-8101-4034884d774e",
"type": "string",
"field": "FIsKFPeriod",
"label": "启用保质期管理",
"value": "FIsKFPeriod",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "947a9a77-5ccd-3991-89f7-b00252baeae7",
"type": "string",
"field": "FIsSNManage",
"label": "启用序列号管理",
"value": "FIsSNManage",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "25ba262e-a00c-3677-9298-ba5349e7e62e",
"type": "string",
"field": "FSafeStock",
"label": "安全库存",
"value": "FSafeStock",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "747df27b-93d5-3bcd-a8ab-7b876219242c",
"type": "string",
"field": "FCategoryID",
"label": "存货类别",
"value": "FCategoryID",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "75b0ff81-1ed0-3753-8dd0-8db626c6e9dc",
"type": "string",
"field": "FExpPeriod",
"label": "保质期",
"value": "FExpPeriod",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "86cdda6c-fe24-3cbb-9003-904fe0c03b59",
"type": "string",
"field": "FOrderQty",
"label": "起订量",
"value": "FOrderQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "f76a5880-b887-374c-95a9-13603080c004",
"type": "string",
"field": "FMinQty",
"label": "最小批量",
"value": "FMinQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "29575334-fab6-3e4e-b781-45e9b6e07e6b",
"type": "string",
"field": "FMaxQty",
"label": "最大批量",
"value": "FMaxQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "60fd9a09-f742-37a3-a952-08325617277d",
"type": "string",
"field": "FDefaultVendor_FNumber",
"label": "默认供应商",
"value": "FDefaultVendor.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "1033f61e-86a6-371a-90cc-ba72fcd0886e",
"type": "string",
"field": "FMaxPOQty",
"label": "最大订货量",
"value": "FMaxPOQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "30fdaf05-7cee-376e-9d9b-b29ffc19b555",
"type": "string",
"field": "FMinPOQty",
"label": "最小订货量",
"value": "FMinPOQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "2e9119c4-c8ba-381a-a949-b800e093f7f0",
"type": "string",
"field": "FIncreaseQty",
"label": "最小包装量",
"value": "FIncreaseQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "21351eb5-8937-36fc-8e98-5506b33a38cf",
"type": "string",
"field": "FFixLeadTime",
"label": "固定提前期",
"value": "FFixLeadTime",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "b5d9776a-fd93-3e35-91d5-2b623e5f6442",
"type": "string",
"field": "FVarLeadTime",
"label": "变动提前期",
"value": "FVarLeadTime",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "048321a7-dab9-319b-8110-5f303bd12728",
"type": "string",
"field": "FPlanBatchSplitQty",
"label": "拆分批量",
"value": "FPlanBatchSplitQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "ac110537-3e6c-3e83-89ff-cc8c298554e3",
"type": "string",
"field": "FProduceBillType_FNumber",
"label": "生产类型",
"value": "FProduceBillType.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "9233b100-3a91-3c56-8241-ab4db1882103",
"type": "string",
"field": "FPOBillTypeId_FNumber",
"label": "采购类型",
"value": "FPOBillTypeId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "d42378f5-cd5e-34ad-88c9-a4c95cb64f21",
"type": "string",
"field": "FSubBillType_FNumber",
"label": "委外类型",
"value": "FSubBillType.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "f937f244-b8a3-3739-a0a9-0d79d28af137",
"type": "string",
"field": "FGROSSWEIGHT",
"label": "毛重",
"value": "FGROSSWEIGHT",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "1c132d85-31c1-3037-b1ed-8b53b146b868",
"type": "string",
"field": "FNETWEIGHT",
"label": "净重",
"value": "FNETWEIGHT",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "f89dd1d0-afb5-35bc-a3eb-caa24a5c31ee",
"type": "string",
"field": "FWEIGHTUNITID_FNumber",
"label": "重量单位",
"value": "FWEIGHTUNITID.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "174fed55-b255-31c8-ae97-222b9a8a8abd",
"type": "string",
"field": "FLENGTH",
"label": "长",
"value": "FLENGTH",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "09d1c2f5-2370-3adc-9678-09d88a5a6955",
"type": "string",
"field": "FWIDTH",
"label": "宽",
"value": "FWIDTH",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "31183eb0-1d20-390a-a0c1-f1bd8386c6a2",
"type": "string",
"field": "FHEIGHT",
"label": "高",
"value": "FHEIGHT",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "356c445a-e80d-3f2c-a13d-66e2a5ea7a3d",
"type": "string",
"field": "FVOLUME",
"label": "体积",
"value": "FVOLUME",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "21c1a8a8-e916-3467-ac39-e182356e76b2",
"type": "string",
"field": "FWARRANTY",
"label": "保修期",
"value": "FWARRANTY",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "140e65a1-1859-36bf-9d19-9dcaa13704f3",
"type": "string",
"field": "FSalePrice_CMK",
"label": "零售价",
"value": "FSalePrice_CMK",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "de0efbb7-9d99-36c2-947f-7998c223c8a8",
"type": "string",
"field": "FVIPPrice_CMK",
"label": "会员价",
"value": "FVIPPrice_CMK",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "b6971036-2e92-39c1-a428-0cc538606f7f",
"type": "string",
"field": "FPurPrice_CMK",
"label": "采购单价",
"value": "FPurPrice_CMK",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "562b10ad-3396-37a1-bbb4-d07c54281b69",
"type": "string",
"field": "FComBrandId_CMK_FNumber",
"label": "品牌",
"value": "FComBrandId_CMK.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
}
],
"response": [
{
"id": "f77feb01-2df3-344c-8fb7-5a08ef2dcc32",
"type": "string",
"field": "FMATERIALID",
"label": "实体主键",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "6f912535-ddae-353a-b056-493cfcd299dd",
"type": "string",
"field": "FNumber",
"label": "编码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "70a12071-c79a-3439-8852-9b54e48822fc",
"type": "string",
"field": "FName",
"label": "名称",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "a0807c00-7cc5-3e1d-82e0-d8af592d4d22",
"type": "string",
"field": "FSpecification",
"label": "规格型号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "4d63e08e-003e-34ea-8103-595d41b59189",
"type": "string",
"field": "FOldNumber",
"label": "旧物料编码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "7c4a0e38-b595-3b7b-8da2-2056c0d14224",
"type": "string",
"field": "FBARCODE",
"label": "条码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "811c9f90-2f49-35e4-9e3e-f6cb971d8c2f",
"type": "string",
"field": "FDescription",
"label": "描述",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "59e9f9b0-3385-3457-bc50-659a7b2c4124",
"type": "string",
"field": "FMaterialGroup_FNumber",
"label": "物料分组",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "1389ebd4-5e23-347c-863d-b70e6d0a5e4e",
"type": "string",
"field": "FErpClsID",
"label": "物料属性",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "ef051d0f-7b63-326c-966e-391ca8e6d6dc",
"type": "string",
"field": "FDocumentStatus",
"label": "数据状态",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "7272200f-636c-3a8e-b529-58139eedd4b3",
"type": "string",
"field": "FForbidStatus",
"label": "禁用状态",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "7dec496f-82db-3955-9f98-13b0201c7dc8",
"type": "string",
"field": "FBaseUnitId_FNumber",
"label": "基本单位.编码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "d00f5dcf-28f8-3319-8389-1d3b436c4564",
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "d50e93b6-2196-34a1-8947-2c0bf76526a7",
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "e13cbb5b-9b73-3a03-8cbf-5f01133e9c89",
"type": "string",
"field": "FIsInventory",
"label": "允许库存",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "a3901a88-3d9d-3aa4-8aa6-c7482c012f88",
"type": "string",
"field": "FIsSale",
"label": "允许销售",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "79490051-4400-318b-b51d-d1173da832ee",
"type": "string",
"field": "FIsAsset",
"label": "允许资产",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "cf8e1307-e675-3318-b647-6272864354d7",
"type": "string",
"field": "FIsSubContract",
"label": "允许委外",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "4b543dc1-1e7b-337b-9763-3d84a2db95ea",
"type": "string",
"field": "FIsProduce",
"label": "允许生产",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "2dc97f31-483b-3e07-b959-2ea656799b17",
"type": "string",
"field": "FIsPurchase",
"label": "允许采购",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "f6f2f37b-a53d-3c23-9d35-988dbb7db9ba",
"type": "string",
"field": "FStockId_FNumber",
"label": "仓库",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "9a3c6033-a3e8-36db-a43e-31a39f9123ad",
"type": "string",
"field": "FPurchaseOrgId_FNumber",
"label": "采购组织.编码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "3ff1b70a-1b5a-3899-9d47-f5f0f0d88699",
"type": "string",
"field": "FPurchaseOrgId_FName",
"label": "采购组织",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "a2a45976-0c45-3944-b220-107186398427",
"type": "string",
"field": "FIsBatchManage",
"label": "启用批号管理",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "8996cc8c-cf74-3107-b09a-a2aad8ee1af8",
"type": "string",
"field": "FIsKFPeriod",
"label": "启用保质期管理",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "07cb14d3-6f09-39db-a0cc-283063ca59ac",
"type": "string",
"field": "FIsSNManage",
"label": "启用序列号管理",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "4440dfd9-03ca-3c18-adf8-e00824bb731f",
"type": "string",
"field": "FSafeStock",
"label": "安全库存",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "9db966b2-c8b8-3874-8e74-0bad144917d7",
"type": "string",
"field": "FCategoryID",
"label": "存货类别",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "63a1823d-c44d-361a-badf-fa328e8bb46c",
"type": "string",
"field": "FExpPeriod",
"label": "保质期",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "0c213287-6e75-3d70-a06f-c6c495164b19",
"type": "string",
"field": "FOrderQty",
"label": "起订量",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "9af2d8bb-57ec-3b1f-a61e-076eba5b36a4",
"type": "string",
"field": "FMinQty",
"label": "最小批量",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "87c0c0af-f295-3069-a094-2196e2f6dbf8",
"type": "string",
"field": "FMaxQty",
"label": "最大批量",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "3dce1ec9-5a78-3cd1-877d-26511c1a04bf",
"type": "string",
"field": "FDefaultVendor_FNumber",
"label": "默认供应商",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "a2965d19-c3da-3f02-8c80-6d708653074a",
"type": "string",
"field": "FMaxPOQty",
"label": "最大订货量",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "becca68e-82d0-3693-a3b6-f6503f2b9b62",
"type": "string",
"field": "FMinPOQty",
"label": "最小订货量",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "6e1dea84-84a4-3e25-8227-bd62ff9daff4",
"type": "string",
"field": "FIncreaseQty",
"label": "最小包装量",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "1c2d8dc4-7bba-36e9-970a-daa9cb9f73b8",
"type": "string",
"field": "FFixLeadTime",
"label": "固定提前期",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "bf61d21b-b7f1-335a-861a-6a4443b8d91a",
"type": "string",
"field": "FVarLeadTime",
"label": "变动提前期",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "eb3f6eb4-1aa9-3289-8ef2-d97e7abce6d7",
"type": "string",
"field": "FPlanBatchSplitQty",
"label": "拆分批量",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "06190cfa-2d38-3cd0-8ae3-7b792ce03bb8",
"type": "string",
"field": "FProduceBillType_FNumber",
"label": "生产类型",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "519c7f6e-ae89-3564-b926-a09eb880f507",
"type": "string",
"field": "FPOBillTypeId_FNumber",
"label": "采购类型",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "9ebf3838-205f-31b7-97e5-5358bf2680ac",
"type": "string",
"field": "FSubBillType_FNumber",
"label": "委外类型",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "77168761-198f-3db2-8606-18b35ccaf02d",
"type": "string",
"field": "FGROSSWEIGHT",
"label": "毛重",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "32ad63ef-2706-3c85-815c-b7a42ae6bd44",
"type": "string",
"field": "FNETWEIGHT",
"label": "净重",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "bbd08304-5ab7-32a5-9430-8ea745ad0df2",
"type": "string",
"field": "FWEIGHTUNITID_FNumber",
"label": "重量单位",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "4efc64ef-99ff-3a59-9c99-7259e9675b77",
"type": "string",
"field": "FLENGTH",
"label": "长",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "791e3789-6c41-3a07-a243-5f19217ff96d",
"type": "string",
"field": "FWIDTH",
"label": "宽",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "02cca0c1-32ce-3092-8dde-1f2efed67038",
"type": "string",
"field": "FHEIGHT",
"label": "高",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "a4043a69-c05f-3092-8158-96540e6ba020",
"type": "string",
"field": "FVOLUME",
"label": "体积",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "8176bc78-3aac-3a3e-9aba-282e44d0c6de",
"type": "string",
"field": "FWARRANTY",
"label": "保修期",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "f39146fa-faf1-3d72-9ffa-7b9daf73b37e",
"type": "string",
"field": "FSalePrice_CMK",
"label": "零售价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "aed67d90-529a-34fc-ae44-908bf29b31cf",
"type": "string",
"field": "FVIPPrice_CMK",
"label": "会员价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "867e621a-90c3-3fdd-be7d-ab2acc5e43ed",
"type": "string",
"field": "FPurPrice_CMK",
"label": "采购单价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "91f76ff7-87b7-3364-90c4-bc1abf41e65e",
"type": "string",
"field": "FComBrandId_CMK_FNumber",
"label": "品牌",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
}
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"id": "2db4ef6c-54c0-3d94-bf1c-35238e2476c2",
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": true
},
{
"id": "fe06f3a7-833f-3267-b63b-0bef5e6c8a43",
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": true
},
{
"id": "97d27c1b-8bf6-3a22-8eda-a20c127fbdc8",
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": false
},
{
"id": "28d52b2e-96cd-3816-9766-0411c5869253",
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "FApproveDate>='{{LAST_SYNC_TIME|dateTime}}'",
"describe": "示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=",
"parent_id": null,
"is_required": false
},
{
"id": "47d733bd-f48a-384f-b4c0-61e6810d142b",
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"parent_id": null,
"is_required": true
},
{
"id": "bb281aad-09e4-3da9-844d-09e47f6bdbe5",
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "BD_MATERIAL",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"parent_id": null,
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "gy.erp.item.add",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"id": "a1f128e1-e4b2-3ba7-a518-f831297938e9",
"type": "string",
"field": "code",
"label": "商品代码",
"value": "{{FNumber}}",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "93920995-8a97-3ffc-b6c5-6c1e589451b3",
"type": "string",
"field": "name",
"label": "商品名称",
"value": "{{FName}}",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "b8e06f2f-7256-3961-b6bd-479b6f3c3ea3",
"type": "string",
"field": "item_brand_id",
"label": "商品品牌id",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "1c1abbb2-eea6-36a0-82da-670cb805c053",
"type": "string",
"field": "item_brand_code",
"label": "商品品牌代码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "3b03f840-779d-33b0-a421-b363b2fcada3",
"type": "string",
"field": "simple_name",
"label": "商品简称",
"value": "{{FName}}",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "e2a3048f-9c1e-3562-93e1-e644829bee5e",
"type": "string",
"field": "category_code",
"label": "商品分类code",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "d221c496-bdbd-35b7-a787-ecf36dd091a3",
"type": "string",
"field": "supplier_code",
"label": "供应商code",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "422dec3e-444c-3bde-9e90-a75ad6ed7af9",
"type": "string",
"field": "note",
"label": "备注",
"value": "金蝶同步",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "bdf3abec-7a53-3da8-a96f-ebdd96b1713d",
"type": "string",
"field": "minusStock",
"label": "是否启用负库存",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "b9c77623-d992-3a58-9f28-2f3fa07b2e0f",
"type": "string",
"field": "item_add_attribute",
"label": "商品附加属性",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "0e1ea0ce-66da-33cf-8a88-99ac32c274bc",
"type": "string",
"field": "pic_url",
"label": "图片url",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "7510ce95-ed83-3703-9850-43f4ef896ea4",
"type": "string",
"field": "tax_code",
"label": "税收分类编码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "4ff9f9a7-42a1-3879-8fdf-647e242d3aa3",
"type": "string",
"field": "tax_no",
"label": "商品税号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "61ebb286-3593-3412-87c6-843cc166cf3f",
"type": "string",
"field": "tax_rate",
"label": "商品税率",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "65c0d4cc-683b-3961-a495-68f29d657c39",
"type": "string",
"field": "unit_code",
"label": "商品单位code",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "6007d90d-d73c-357e-8a3c-773486fa1538",
"type": "string",
"field": "supplier_outer_id",
"label": "供应商货号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "37a81222-7e09-32af-84c2-b54e799bf020",
"type": "string",
"field": "weight",
"label": "商品重量",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "5e11f800-20fa-38c7-aabe-637d2e7e761b",
"type": "string",
"field": "length",
"label": "长",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "e7759b95-ea9f-3144-8563-06404c3c9faf",
"type": "string",
"field": "width",
"label": "宽",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "04634921-90a1-3277-b11b-43d6fc31f079",
"type": "string",
"field": "height",
"label": "高",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "366aae2f-be39-3e92-b690-0850586ef3d7",
"type": "string",
"field": "volume",
"label": "商品体积",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "5db4f7fa-ce63-3c92-a6cf-46206125041e",
"type": "string",
"field": "package_point",
"label": "打包积分",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "8dde6f89-0350-39d5-987c-a267451eb8ee",
"type": "string",
"field": "sales_point",
"label": "销售积分",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "1673e057-6215-3b6a-8ad5-fde131f53ae3",
"type": "string",
"field": "sales_price",
"label": "标准售价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "7926ffe9-d8ad-3be8-8345-c1d82e0d4e01",
"type": "string",
"field": "purchase_price",
"label": "标准进价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "d8ca8eb1-f54f-3976-9069-456c0920a127",
"type": "string",
"field": "cost_price",
"label": "成本价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "3dcb62f9-acb7-3a07-bc14-df9e4f56e1bb",
"type": "string",
"field": "agent_price",
"label": "代理售价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "c0e4212f-9cb7-393b-ac42-b32e35e1e200",
"type": "string",
"field": "stock_status_code",
"label": "库存状态code",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"type": "array",
"field": "skus",
"label": "skus",
"children": [
{
"id": "ce5e0920-f22d-36a7-8d99-23c270a6ca4c",
"type": "string",
"field": "sku_code",
"label": "规格代码",
"value": "{{FNumber}}",
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
},
{
"id": "64f4d3c3-943c-3a10-8e4e-70e019f52fc7",
"type": "string",
"field": "sku_name",
"label": "规格名称",
"value": "{{FName}}",
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
},
{
"id": "02395bd3-9f8a-3578-9d18-941e133cbe57",
"type": "string",
"field": "sku_weight",
"label": "规格重量",
"value": null,
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
},
{
"id": "952cb549-a777-3c13-a1e0-be1e0afb3737",
"type": "string",
"field": "sku_purchase_price",
"label": "规格标准进价",
"value": null,
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
},
{
"id": "a47ed5cc-864a-331e-ac42-6fcd3bc182dc",
"type": "string",
"field": "sku_sales_price",
"label": "规格标准售价",
"value": null,
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
},
{
"id": "463cfb09-195a-3c00-b413-9bf085905128",
"type": "string",
"field": "sku_agent_price",
"label": "规格代理售价",
"value": null,
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
},
{
"id": "5246ccb2-cea0-3b55-a5d9-f4cf94aaf721",
"type": "string",
"field": "sku_cost_price",
"label": "规格成本价",
"value": null,
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
},
{
"id": "10ba5c42-b0da-3e12-b52a-d358926c0013",
"type": "string",
"field": "sku_package_point",
"label": "规格打包积分",
"value": null,
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
},
{
"id": "eb806f27-678e-3863-b21e-3014264a9977",
"type": "string",
"field": "sku_sales_point",
"label": "规格销售积分",
"value": null,
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
},
{
"id": "7c1af7ab-338d-31ca-8ef6-8297247ae908",
"type": "string",
"field": "sku_note",
"label": "规格备注",
"value": null,
"parent": "skus",
"describe": null,
"parent_id": "2f310689-fc86-32a1-8b4b-ed8324cd4160",
"is_required": false
}
],
"describe": null,
"parent_id": null,
"is_required": false
}
],
"response": [],
"otherRequest": [],
"otherResponse": []
}
