源系统平台:金蝶云星空
源系统接口: 调拨单查询executeBillQuery
目标系统平台: 旺店通·企业奇门
目标系统接口: 创建其他入库单wdt.stockin.order.push
源平台元数据配置:
{
"id": "FBillEntry_FEntryID",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FBillNo",
"idCheck": true,
"request": [
{
"id": "4ff8ca10-21a1-3dbe-a962-dd1fe45be6f2",
"type": "string",
"field": "FBillEntry_FEntryID",
"label": "FEntryID",
"value": "FBillEntry_FEntryID",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "fc5a1ce5-5728-3214-beb1-fc0c8d3cfeef",
"type": "string",
"field": "FID",
"label": "实体主键",
"value": "FID",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "1681d516-4a75-3349-8995-fcb36891fa80",
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "FBillNo",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "7a80865d-c85a-330f-850f-be5a021c8b82",
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": "FDocumentStatus",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "a51128d5-4c81-3775-8e27-dd85825efdfa",
"type": "string",
"field": "FStockOrgId_FNumber",
"label": "调入库存组织",
"value": "FStockOrgId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "7f574e63-577b-3a26-b0c3-b4b368a1796b",
"type": "string",
"field": "FDate",
"label": "日期",
"value": "FDate",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "e70e672d-44b4-32e5-8d0f-85e8c9b821ee",
"type": "string",
"field": "FBillTypeID_FNumber",
"label": "单据类型",
"value": "FBillTypeID.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "d7b0c7cb-6a3d-397d-b735-21e5e880bf07",
"type": "string",
"field": "FTransferBizType",
"label": "调拨类型",
"value": "FTransferBizType",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "8b191312-eb74-3aeb-a0d4-c3784d59ba84",
"type": "string",
"field": "FStockOutOrgId_FNumber",
"label": "调出库存组织",
"value": "FStockOutOrgId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "da098b9a-2d8a-3d1f-b9c3-ecb1bf58ea0f",
"type": "string",
"field": "FTransferDirect",
"label": "调拨方向",
"value": "FTransferDirect",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "fd96ad51-98f5-340c-aef6-506a10566d6d",
"type": "string",
"field": "FNote",
"label": "备注",
"value": "FNote",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "d7670f53-720f-3aa8-97bf-7b881d31f541",
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": "FBizType",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "522b9dc1-1587-3c26-a5cb-896e17fee20a",
"type": "string",
"field": "FSaleOrgId_FNumber",
"label": "销售组织",
"value": "FSaleOrgId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "ecceb1cb-0ed3-3afc-9fe9-3bc306876e5d",
"type": "string",
"field": "FSettleOrgId_FNumber",
"label": "结算组织",
"value": "FSettleOrgId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "40288d70-fafc-37f5-92a7-4b6c5aeb436f",
"type": "string",
"field": "FCustID_FNumber",
"label": "对应客户",
"value": "FCustID.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "0541b2f3-37d8-3242-84a9-9e136b659b8e",
"type": "string",
"field": "FSUPPLIERID_FNumber",
"label": "对应供应商",
"value": "FSUPPLIERID.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "de6a2444-53c5-35dc-b343-e103286f46c7",
"type": "string",
"field": "FThirdSrcId",
"label": "第三方源单内码",
"value": "FThirdSrcId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "f45d5d4f-ce64-3593-9168-13d8ccb5c03e",
"type": "string",
"field": "FThirdSrcBillNo",
"label": "第三方源单编码",
"value": "FThirdSrcBillNo",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "e39c8603-36f5-343a-ad77-8b3631d97e27",
"type": "string",
"field": "FThirdSystem",
"label": "第三方系统",
"value": "FThirdSystem",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "07a46229-677e-38d4-bf5a-5bc0a6dface0",
"type": "string",
"field": "FMaterialId_FNumber",
"label": "物料编码",
"value": "FMaterialId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "6bab8989-93fc-3248-907c-39005db4cb6c",
"type": "string",
"field": "FLot",
"label": "调出批号",
"value": "FLot",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "dc7cf135-df7a-35df-a6b0-9a88b2d3a022",
"type": "string",
"field": "FSrcStockId_FNumber",
"label": "调出仓库",
"value": "FSrcStockId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "d3e1f8f2-4a1b-369c-a996-c36c29f701f4",
"type": "string",
"field": "FSrcStockLocId",
"label": "调出仓位",
"value": "FSrcStockLocId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "9cf95b55-a3b0-3477-852b-4e026acfa0e9",
"type": "string",
"field": "FDestStockId_FNumber",
"label": "调入仓库",
"value": "FDestStockId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "6dd31314-8d14-3eda-84a4-75d71acefc6b",
"type": "string",
"field": "FDestStockLocId",
"label": "调入仓位",
"value": "FDestStockLocId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "d9e1834f-b792-3004-9214-970b86f3fbe8",
"type": "string",
"field": "FQty",
"label": "调拨数量",
"value": "FQty",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "2c25cd7a-e4a2-3e61-b68c-2b91e6190742",
"type": "string",
"field": "FPrice",
"label": "成本价",
"value": "FPrice",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "cd0a6fe3-eeed-3658-954a-b6a1b7be60b4",
"type": "string",
"field": "FAmount",
"label": "总成本",
"value": "FAmount",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "beeed4a7-c627-3997-abcb-8db39a912476",
"type": "string",
"field": "FBomId",
"label": "BOM版本",
"value": "FBomId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "570e949e-5b42-3429-8368-3328fe4eb268",
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": "FProduceDate",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "dbfa7bc5-d183-32c1-949d-da5a541608d8",
"type": "string",
"field": "FExpiryDate",
"label": "有效期至",
"value": "FExpiryDate",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "ba121241-4903-35d3-893b-59fa7bbeac2f",
"type": "string",
"field": "FExpPeriod",
"label": "保质期",
"value": "FExpPeriod",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "8807eb41-797c-3927-80f5-5d3ae8a61a8d",
"type": "string",
"field": "FSrcStockStatusId",
"label": "调出库存状态",
"value": "FSrcStockStatusId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "24c1c1e7-46ea-3520-a384-87b7a2f478a7",
"type": "string",
"field": "FDestStockStatusId",
"label": "调入库存状态",
"value": "FDestStockStatusId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "f9a9c87d-e1b0-3223-82ac-fa0439e2f843",
"type": "string",
"field": "FOwnerId_FNumber",
"label": "调入货主",
"value": "FOwnerId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "7080cb23-5d16-35b2-9191-50081d0725c2",
"type": "string",
"field": "FOwnerOutId_FNumber",
"label": "调出货主",
"value": "FOwnerOutId.FNumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "c089bc90-002a-3eeb-bc08-b84e9e6c3098",
"type": "string",
"field": "FSrcBillTypeId",
"label": "源单类型",
"value": "FSrcBillTypeId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "30fac352-a381-3dd9-bb10-686bb96e39a9",
"type": "string",
"field": "FSrcSeq",
"label": "源单行号",
"value": "FSrcSeq",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "15fd4a7a-30f5-314d-a194-a803d327765d",
"type": "string",
"field": "FOrderNo",
"label": "订单编号",
"value": "FOrderNo",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "f8ea98a0-e222-37fc-92ab-dceed1eabed4",
"type": "string",
"field": "FNoteEntry",
"label": "备注",
"value": "FNoteEntry",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "cdefce69-0267-3048-9615-cc523872e506",
"type": "string",
"field": "FSrcBillNo",
"label": "源单编号",
"value": "FSrcBillNo",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "0ff4aad8-aa77-3ca7-8a77-ce1cc7468b82",
"type": "string",
"field": "FBFLowId",
"label": "业务流程",
"value": "FBFLowId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "296be387-648f-36a3-8417-a89269a55894",
"type": "string",
"field": "FConsignPrice",
"label": "单价",
"value": "FConsignPrice",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "c3c2143e-04b0-3550-afa8-dd5a55ef7f32",
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": "FTaxPrice",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "60394d01-e8c9-3c19-8f4c-9ce81a344e1b",
"type": "string",
"field": "FTaxRate",
"label": "税率%",
"value": "FTaxRate",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "7ee0bddd-951d-3722-bb0d-dd3aafd64175",
"type": "string",
"field": "FDestLot",
"label": "调入批号",
"value": "FDestLot.fnumber",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "d8c163c4-12de-34fa-abc6-8c7baf762e08",
"type": "string",
"field": "FQmEntryId",
"label": "库存请检单EntryId",
"value": "FQmEntryId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "5fa6788e-6bd3-362e-bd2f-2916b178a69a",
"type": "string",
"field": "FConvertEntryId",
"label": "库存状态转换EntryId",
"value": "FConvertEntryId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "ef7bc48e-9ea7-3ec0-b26f-98839011cf64",
"type": "string",
"field": "FSOEntryId",
"label": "销售订单EntryId",
"value": "FSOEntryId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "9a6ec752-aec7-3cad-82e8-01121826b372",
"type": "string",
"field": "FThirdSrcEntryId",
"label": "第三方源单分录编码",
"value": "FThirdSrcEntryId",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "048ec097-d393-351d-9a98-2a0fe0a96baa",
"type": "string",
"field": "FISFREE",
"label": "赠品",
"value": "FISFREE",
"describe": null,
"parent_id": null,
"is_required": true
}
],
"response": [
{
"id": "6585c2e5-30e0-3bbb-b55d-12e0df13f7d3",
"type": "string",
"field": "FBillEntry_FEntryID",
"label": "FEntryID",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "e0d20768-20bd-3c46-8d9b-0914791fe0ca",
"type": "string",
"field": "FID",
"label": "实体主键",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "48334773-57e0-3bb7-b070-112413cb026a",
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "e3384c29-1f45-395b-b06e-7442a5841902",
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "8e5deb18-df95-3133-a31b-42f5fb711e19",
"type": "string",
"field": "FStockOrgId_FNumber",
"label": "调入库存组织",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "608d06b4-b7b0-32dd-bdcd-c19bc939e794",
"type": "string",
"field": "FDate",
"label": "日期",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "b6d15ffc-b67c-33b4-9852-4020d02c0edd",
"type": "string",
"field": "FBillTypeID_FNumber",
"label": "单据类型",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "27f2df4d-fb95-313f-b0e5-b9df529387b8",
"type": "string",
"field": "FTransferBizType",
"label": "调拨类型",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "52999b1d-099d-370c-ac5d-9932c2bdc2bb",
"type": "string",
"field": "FStockOutOrgId_FNumber",
"label": "调出库存组织",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "ffeafe91-c230-33c3-81f6-627760ce1a4f",
"type": "string",
"field": "FTransferDirect",
"label": "调拨方向",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "0cc3674e-21df-33fd-a42d-939a30301461",
"type": "string",
"field": "FNote",
"label": "备注",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "b5852796-1c82-3414-8cf0-a64a5da14f6b",
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "344c856d-b953-3adf-aed9-96620f14e8d6",
"type": "string",
"field": "FSaleOrgId_FNumber",
"label": "销售组织",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "fdb06df7-1c0c-3eb7-9dfc-3e9884193a80",
"type": "string",
"field": "FSettleOrgId_FNumber",
"label": "结算组织",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "9a64e884-482d-3c78-86da-6baeafd40f28",
"type": "string",
"field": "FCustID_FNumber",
"label": "对应客户",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "24c5b893-3710-32c6-93b3-200a9e144c1b",
"type": "string",
"field": "FSUPPLIERID_FNumber",
"label": "对应供应商",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "6af470c6-9da1-39e3-a67c-4b8823861da3",
"type": "string",
"field": "FThirdSrcId",
"label": "第三方源单内码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "827f0031-9c5f-38f3-94c9-03aaddb1fb85",
"type": "string",
"field": "FThirdSrcBillNo",
"label": "第三方源单编码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "f241f635-59fe-3a64-a604-a3b0cdc21ff0",
"type": "string",
"field": "FThirdSystem",
"label": "第三方系统",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "f01e99b2-3212-32a1-bb29-08a96931e1c6",
"type": "string",
"field": "FMaterialId_FNumber",
"label": "物料编码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "040fa33e-5b5b-3233-8c4a-cba4f944a77a",
"type": "string",
"field": "FLot",
"label": "调出批号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "d8769da2-d48b-367f-8918-005381dbd97e",
"type": "string",
"field": "FSrcStockId_FNumber",
"label": "调出仓库",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "425f155e-0d59-37b8-be5a-f4b9e41f34a8",
"type": "string",
"field": "FSrcStockLocId",
"label": "调出仓位",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "49b18818-9753-305b-8687-a1fddf9a7b26",
"type": "string",
"field": "FDestStockId_FNumber",
"label": "调入仓库",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "1a666afb-b547-3f47-8203-4e8bbdc46a1f",
"type": "string",
"field": "FDestStockLocId",
"label": "调入仓位",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "70420a5f-f15a-3d2c-bda2-fe073c4f6bba",
"type": "string",
"field": "FQty",
"label": "调拨数量",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "58916434-3015-3061-9170-76fbecf1e7ad",
"type": "string",
"field": "FPrice",
"label": "成本价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "ed2e8f62-038f-3cd5-8460-8377fff120cf",
"type": "string",
"field": "FAmount",
"label": "总成本",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "d082a9a5-f642-35dc-b148-ff7a70625fce",
"type": "string",
"field": "FBomId",
"label": "BOM版本",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "b4f8ac66-d61f-3998-9347-93c9665503a9",
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "9469ad4a-8bbe-34c3-929c-91fb7d881572",
"type": "string",
"field": "FExpiryDate",
"label": "有效期至",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "df2505e9-7eb5-3090-baa1-392f8d0d8f95",
"type": "string",
"field": "FExpPeriod",
"label": "保质期",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "b5771ea1-dac7-3594-9a51-5eae0cd1121b",
"type": "string",
"field": "FSrcStockStatusId",
"label": "调出库存状态",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "fca7a53f-2575-302b-8da6-d91702d80435",
"type": "string",
"field": "FDestStockStatusId",
"label": "调入库存状态",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "ea0ca2e8-bc7a-3a5d-ae70-b60a06bc7ecf",
"type": "string",
"field": "FOwnerId_FNumber",
"label": "调入货主",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "858f4d01-a27f-386c-8231-30727be2b6a6",
"type": "string",
"field": "FOwnerOutId_FNumber",
"label": "调出货主",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "740b91dc-2c16-338a-a3a8-eab1d7c97d55",
"type": "string",
"field": "FSrcBillTypeId",
"label": "源单类型",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "7db38be1-d7ea-339d-903a-a1ab94f365d4",
"type": "string",
"field": "FSrcSeq",
"label": "源单行号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "f14fd71c-3f48-3458-b8f9-d67d6f9079fe",
"type": "string",
"field": "FOrderNo",
"label": "订单编号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "12f2ed54-f8aa-367a-89a8-ff9fbc403de4",
"type": "string",
"field": "FNoteEntry",
"label": "备注",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "2522d654-bdbc-3fe9-8d69-fe216eaf0201",
"type": "string",
"field": "FSrcBillNo",
"label": "源单编号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "269e2517-b5b1-35c1-a967-49c83d2cc32f",
"type": "string",
"field": "FBFLowId",
"label": "业务流程",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "9fb86b86-4791-3ec1-856c-1abe9a4ccc99",
"type": "string",
"field": "FConsignPrice",
"label": "单价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "a3e2462c-4a9c-340a-997a-70a452cc6744",
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "4e3055b6-ff7c-3966-a3a9-21cfd2cb1cac",
"type": "string",
"field": "FTaxRate",
"label": "税率%",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "f1840297-eb94-3d4c-8fe7-ebe5a6369a95",
"type": "string",
"field": "FDestLot",
"label": "调入批号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "8a535494-083c-3dc6-b276-84581336a2bb",
"type": "string",
"field": "FQmEntryId",
"label": "库存请检单EntryId",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "7bfbb3d1-4e81-3eab-b80b-535ed4710da3",
"type": "string",
"field": "FConvertEntryId",
"label": "库存状态转换EntryId",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "8823c2ee-2ed7-31ce-8e9b-eb11235d17ba",
"type": "string",
"field": "FSOEntryId",
"label": "销售订单EntryId",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "3db71be5-127b-32a7-9964-ea2f53a814a1",
"type": "string",
"field": "FThirdSrcEntryId",
"label": "第三方源单分录编码",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "fa6fba85-84a5-3350-b43c-749c87ca45ec",
"type": "string",
"field": "FISFREE",
"label": "赠品",
"value": null,
"describe": null,
"parent_id": null,
"is_required": true
}
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"id": "14e8c689-f5d3-3cf7-b816-badbe4d1a0a6",
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": true
},
{
"id": "17da3077-5c93-390c-ba20-bfd969b06ba0",
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式:FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"parent_id": null,
"is_required": true
},
{
"id": "89ddafd2-327d-35ed-be05-8bd2f2510352",
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": false
},
{
"id": "8fdf479b-a215-38f8-9e01-43a049727be1",
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "FApproveDate>='{{LAST_SYNC_TIME|dateTime}}' AND FDocumentStatus = 'C' and FBillTypeID.Fnumber='ZJDB01_SYS' and FDestStockId.FNumber not in('HYKC01','HYKC02','HYKC03','HYKC04','HYKC05','HYKC06') and FBillNo not in('444','555','666','777','000','999')",
"describe": "示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=",
"parent_id": null,
"is_required": false
},
{
"id": "b26606d4-4815-30af-a330-0c4276826bf6",
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "STK_TransferDirect",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"parent_id": null,
"is_required": true
},
{
"id": "f9149ecd-401c-3ea9-8632-d441e90c0722",
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "wdt.stockin.order.push",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"id": "c9b23155-9397-368a-a217-97bf31fd7bad",
"type": "string",
"field": "outer_no",
"label": "外部单号",
"value": "{{FBillNo}}-{{goods_list.FMaterialId_FNumber}}",
"describe": "外部系统的唯一单据编号,避免重复推送数据",
"parent_id": null,
"is_required": false
},
{
"id": "4b4bf9de-9f0a-33c3-bea5-6b92897d6700",
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": "{{FDestStockId_FNumber}}",
"describe": "代表仓库所有属性的唯一编码,用于仓库区分,ERP内支持自定义(ERP仓库界面设置)",
"parent_id": null,
"is_required": false
},
{
"id": "24d5b03a-bb54-3986-b838-aeea413cf41a",
"type": "string",
"field": "logistics_code",
"label": "物流编号",
"value": null,
"describe": "代表物流所有属性的唯一编码,用于物流区分,ERP内支持自定义(ERP物流界面设置)",
"parent_id": null,
"is_required": false
},
{
"id": "3ce59940-4374-34a6-ad2a-664cdeae2bc3",
"type": "string",
"field": "logistics_no",
"label": "物流单号",
"value": null,
"describe": "物流公司的运单号,用于追踪物流、快递流转信息(路由)的数字编码",
"parent_id": null,
"is_required": false
},
{
"id": "a4435c42-c6d9-312f-bd72-0eab637c3912",
"type": "string",
"field": "is_check",
"label": "是否审核",
"value": "1",
"describe": "1:审核 0:不审核 默认0",
"parent_id": null,
"is_required": false
},
{
"id": "05dd3a57-01e0-3c68-9603-d227d73b3809",
"type": "string",
"field": "is_create_batch",
"label": "是否创建批次",
"value": "1",
"describe": "0:否;1:是,默认是0。ERP“批次管理”不存在推送的批次号,是否允许单据创建成功,并创建新的“批次号”。",
"parent_id": null,
"is_required": false
},
{
"id": "0637d415-3366-365d-b4a2-e01201bacca5",
"type": "string",
"field": "post_fee",
"label": "邮资",
"value": null,
"describe": "物流或者快递运输货物产生的费用",
"parent_id": null,
"is_required": false
},
{
"id": "40a31d1e-295a-3845-bf1f-dc8aac6e3179",
"type": "string",
"field": "other_fee",
"label": "其他费用",
"value": null,
"describe": "其他费用",
"parent_id": null,
"is_required": false
},
{
"id": "0e8852a1-314d-319d-8f4b-ce62a79872e4",
"type": "string",
"field": "remark",
"label": "备注",
"value": "金蝶调拨单调拨入库部分对接",
"describe": "其他入库单备注",
"parent_id": null,
"is_required": false
},
{
"id": "b7c664ee-c6af-38e6-b5c6-11cf01dfb15e",
"type": "string",
"field": "reason",
"label": "入库原因",
"value": null,
"describe": "入库原因(需要在客户端维护好该原因,如客户端无该原因或者原因停用,则推送失败,路径:设置—>基本设置—>原因列表)",
"parent_id": null,
"is_required": false
},
{
"id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"type": "array",
"field": "goods_list",
"label": "货品明细节点",
"children": [
{
"id": "b6f39bf8-8c19-3125-bb54-e1773df7f1f8",
"type": "string",
"field": "spec_no",
"label": "商家编码",
"value": "{{goods_list.FMaterialId_FNumber}}",
"parent": "goods_list",
"describe": "ERP内单品唯一编码(SKU),代表单品(SKU)所有属性,并且为库存量出入计算最小单元。SKU概念介绍,单击这里",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "25d6a2f6-aafc-31ff-a020-f1b72924a640",
"type": "string",
"field": "stockin_num",
"label": "入库数量",
"value": "{{FQty}}",
"parent": "goods_list",
"describe": "入库数量",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "05ee9307-15a1-38cc-9873-82a91c52e3ce",
"type": "string",
"field": "position_no",
"label": "货位编号",
"value": null,
"parent": "goods_list",
"describe": "商品在仓库内的位置编号,不传此参数,读ERP配置【入库开单货位优先级配置】,来决定取默认货位、上一次入库货位、ZANCUN货位其中一个货位。",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "44179a3c-24a8-35a3-9481-9de9343f0e89",
"type": "string",
"field": "batch_no",
"label": "批次",
"value": "{{FDestLot}}",
"parent": "goods_list",
"describe": "货品批次编号",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "b9c12a2a-d6b2-3a7d-befc-06c777685e62",
"type": "string",
"field": "batch_remark",
"label": "批次备注",
"value": null,
"parent": "goods_list",
"describe": "货品批次备注",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "537e1ee1-4882-3b7d-884b-27449bd52089",
"type": "string",
"field": "production_date",
"label": "生产日期",
"value": "{{FProduceDate}}",
"parent": "goods_list",
"describe": "货品生产日期,格式:yyyy-MM-dd HH:mm:ss",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "1be83ee8-d042-3fea-b481-33349fc019ee",
"type": "string",
"field": "validity_days",
"label": "有效期天数",
"value": "{{FExpPeriod }}",
"parent": "goods_list",
"describe": "商品有效期,单位:天",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "90eb81bc-9c1c-366c-9215-1fe864ad2159",
"type": "string",
"field": "src_price",
"label": "原价",
"value": "0",
"parent": "goods_list",
"describe": "上层单据的的货品价格,例如采购单的税前折后单价为采购入库的原价,原价减去入库价得出货品优惠。其他入库没有上层单据,根据业务情况自行传值。无特殊业务建议同入库价一致。",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "45dc9c7a-d5dc-3d74-a798-8808deccd1e6",
"type": "string",
"field": "stockin_price",
"label": "入库价",
"value": "0",
"parent": "goods_list",
"describe": "入库价格,如推送为0默认取成本价。",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "9369ccde-9d62-3274-bb44-53ae33e61005",
"type": "string",
"field": "tax",
"label": "税率",
"value": null,
"parent": "goods_list",
"describe": "对征税对象的征收比例或征收额度。例如税率为16%,请求时填值为0.16",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "b9f26b8a-654d-3af7-a873-49b8ed58b050",
"type": "string",
"field": "is_enable_sn",
"label": "是否开启序列号",
"value": null,
"parent": "goods_list",
"describe": "是否开启序列号: 0代表不开启序列号 1代表开启序列号 默认为不开启",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
},
{
"id": "20585df4-a732-3a3d-8f9e-24018959c6e6",
"type": "string",
"field": "sn_list",
"label": "序列号列表",
"value": null,
"parent": "goods_list",
"describe": "序列号列表,多个序列号通过\",\"隔开字符串区分,例如\"xxx1,xxx2,xxx3\"",
"parent_id": "dfb1c66a-a75c-3433-9f2a-911bea4ffb38",
"is_required": false
}
],
"describe": "入库单货品列表节点",
"parent_id": null,
"is_required": false
}
],
"response": [],
"operation": {
"body": [
"FMaterialId_FNumber",
"FQty",
"FDestLot",
"FExpPeriod",
"FProduceDate"
],
"field": "FBillNo,FDestStockId_FNumber,FMaterialId_FNumber,FDestLot",
"header": [
"FDestStockId_FNumber",
"FBillNo"
],
"method": "merge",
"bodySum": [
"FQty"
],
"bodyName": "goods_list"
},
"otherRequest": [
{
"id": "4350215f-65b1-3ebe-badd-4ec2c15655ea",
"type": "string",
"field": "stockin_info",
"label": "stockin_info",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
}
],
"otherResponse": []
}