源系统平台:金蝶K3-WISE
源系统接口: 收料通知/请检单Material_Receipt_Notice/GetList
目标系统平台: 黑湖MES
目标系统接口: 导入采购清单openapi/v1/order/procure_order/import
源平台元数据配置:
{
"id": "FInterID",
"api": "Material_Receipt_Notice/GetList",
"type": "QUERY",
"method": "POST",
"number": "FBillNo",
"idCheck": true,
"request": [
{
"type": "string",
"field": "Fdate",
"label": "日期",
"value": "Fdate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPOStyle",
"label": "采购方式",
"value": "FPOStyle",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": "FBizType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWWType",
"label": "委外类型",
"value": "FWWType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAreaPS",
"label": "采购范围",
"value": "FAreaPS",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FFetchAdd",
"label": "交货地点",
"value": "FFetchAdd",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockID",
"label": "收料仓库",
"value": "FStockID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSupplyID",
"label": "供应商",
"value": "FSupplyID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FRelateBrID",
"label": "供货机构",
"value": "FRelateBrID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FClassTypeID",
"label": "事务类型",
"value": "FClassTypeID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExplanation",
"label": "摘要",
"value": "FExplanation",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCurrencyID",
"label": "币别",
"value": "FCurrencyID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSelTranType",
"label": "源单类型(选单)",
"value": "FSelTranType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSelBillNo",
"label": "选单号",
"value": "FSelBillNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExchangeRate",
"label": "汇率",
"value": "FExchangeRate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillNo",
"label": "编号",
"value": "FBillNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExchangeRateType",
"label": "汇率类型",
"value": "FExchangeRateType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPOMode",
"label": "采购模式",
"value": "FPOMode",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCheckerID",
"label": "审核",
"value": "FCheckerID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCheckDate",
"label": "审核日期",
"value": "FCheckDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FFManagerID",
"label": "主管",
"value": "FFManagerID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDeptID",
"label": "部门",
"value": "FDeptID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FEmpID",
"label": "业务员",
"value": "FEmpID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillerID",
"label": "制单",
"value": "FBillerID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FManageType",
"label": "保税监管类型",
"value": "FManageType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FEntryID2",
"label": "行号",
"value": "FEntryID2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxSampleBreakQty",
"label": "样本破坏数量",
"value": "FAuxSampleBreakQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxScrapInCommitQty",
"label": "报废入库关联数量",
"value": "FAuxScrapInCommitQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxScrapQty",
"label": "报废数量",
"value": "FAuxScrapQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMapNumber",
"label": "对应代码",
"value": "FMapNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMapName",
"label": "对应名称",
"value": "FMapName",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FItemID",
"label": "物料代码",
"value": "FItemID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FItemName",
"label": "物料名称",
"value": "FItemName",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FItemModel",
"label": "规格型号",
"value": "FItemModel",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxPropID",
"label": "辅助属性",
"value": "FAuxPropID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBaseUnit",
"label": "基本单位名称",
"value": "FBaseUnit",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBatchNo",
"label": "批号",
"value": "FBatchNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQty",
"label": "基本单位数量",
"value": "FQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FUnitID",
"label": "单位",
"value": "FUnitID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Fauxqty",
"label": "数量",
"value": "Fauxqty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecUnitID",
"label": "辅助单位",
"value": "FSecUnitID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecCoefficient",
"label": "换算率",
"value": "FSecCoefficient",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecQty",
"label": "辅助数量",
"value": "FSecQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Fauxprice",
"label": "单价",
"value": "Fauxprice",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Famount",
"label": "金额",
"value": "Famount",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Fnote",
"label": "备注",
"value": "Fnote",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDischarged",
"label": "紧急放行",
"value": "FDischarged",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FKFDate",
"label": "生产/采购日期",
"value": "FKFDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FKFPeriod",
"label": "保质期(天)",
"value": "FKFPeriod",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPeriodDate",
"label": "有效期至",
"value": "FPeriodDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockID1",
"label": "收料仓库",
"value": "FStockID1",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDCSPID",
"label": "仓位",
"value": "FDCSPID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSourceBillNo",
"label": "源单单号",
"value": "FSourceBillNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSourceTranType",
"label": "源单类型",
"value": "FSourceTranType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSourceInterId",
"label": "源单内码",
"value": "FSourceInterId",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSourceEntryID",
"label": "源单分录",
"value": "FSourceEntryID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FContractBillNo",
"label": "合同单号",
"value": "FContractBillNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FContractInterID",
"label": "合同内码",
"value": "FContractInterID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FContractEntryID",
"label": "合同分录",
"value": "FContractEntryID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderBillNo",
"label": "订单单号",
"value": "FOrderBillNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderInterID",
"label": "订单内码",
"value": "FOrderInterID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderEntryID",
"label": "订单分录",
"value": "FOrderEntryID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxPropCls",
"label": "辅助属性类别",
"value": "FAuxPropCls",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPlanMode",
"label": "计划模式",
"value": "FPlanMode",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMTONo",
"label": "计划跟踪号",
"value": "FMTONo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderType",
"label": "订单类型",
"value": "FOrderType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCheckMethod",
"label": "检验方式",
"value": "FCheckMethod",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQCheckQty",
"label": "基本单位检验数量",
"value": "FQCheckQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxQCheckQty",
"label": "检验数量",
"value": "FAuxQCheckQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecQCheckQty",
"label": "辅助单位检验数量",
"value": "FSecQCheckQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FRelateQty",
"label": "检验基本关联数量",
"value": "FRelateQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxRelateQty",
"label": "检验关联数量",
"value": "FAuxRelateQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecRelateQty",
"label": "辅助单位检验关联数量",
"value": "FSecRelateQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQtyPass",
"label": "基本单位合格数量",
"value": "FQtyPass",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxQtyPass",
"label": "合格数量",
"value": "FAuxQtyPass",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecQtyPass",
"label": "辅助单位合格数量",
"value": "FSecQtyPass",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FConPassQty",
"label": "基本单位让步接收数量",
"value": "FConPassQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxConPassQty",
"label": "让步接收数量",
"value": "FAuxConPassQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecConPassQty",
"label": "辅助单位让步接收数量",
"value": "FSecConPassQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FNotPassQty",
"label": "基本单位不合格数量",
"value": "FNotPassQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxNotPassQty",
"label": "不合格数量",
"value": "FAuxNotPassQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSampleBreakQty",
"label": "基本单位样本破坏数量",
"value": "FSampleBreakQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecNotPassQty",
"label": "辅助单位不合格数量",
"value": "FSecNotPassQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecSampleBreakQty",
"label": "辅助单位样本破坏数量",
"value": "FSecSampleBreakQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FScrapQty",
"label": "基本单位报废数量",
"value": "FScrapQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FConCommitQty",
"label": "入库基本关联数量",
"value": "FConCommitQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxConCommitQty",
"label": "入库关联数量",
"value": "FAuxConCommitQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBackQty",
"label": "退料基本关联数量",
"value": "FBackQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDeliveryNoticeFID",
"label": "交货通知单内码",
"value": "FDeliveryNoticeFID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxBackQty",
"label": "退料关联数量",
"value": "FAuxBackQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDeliveryNoticeEntryID",
"label": "交货通知单分录",
"value": "FDeliveryNoticeEntryID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecScrapQty",
"label": "辅助单位报废数量",
"value": "FSecScrapQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecConCommitQty",
"label": "辅助单位入库关联数量",
"value": "FSecConCommitQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecBackQty",
"label": "辅助单位退料关联数量",
"value": "FSecBackQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FScrapInCommitQty",
"label": "报废入库基本关联数量",
"value": "FScrapInCommitQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecScrapInCommitQty",
"label": "辅助单位报废入库关联数量",
"value": "FSecScrapInCommitQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxQtyMust",
"label": "应收数量",
"value": "FAuxQtyMust",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQtyMust",
"label": "基本单位应收数量",
"value": "FQtyMust",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxPickQty",
"label": "挑选使用数量",
"value": "FAuxPickQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPickQty",
"label": "基本单位挑选使用数量",
"value": "FPickQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSamBillNo",
"label": "样品试制单号",
"value": "FSamBillNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSamEntryID",
"label": "样品试制单行号",
"value": "FSamEntryID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSamInterID",
"label": "样品试制单内码",
"value": "FSamInterID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecPickQty",
"label": "辅助单位挑选使用数量",
"value": "FSecPickQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTime",
"label": "打样次数",
"value": "FTime",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBarCodeListID",
"label": "WMS条码外键",
"value": "FBarCodeListID",
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "Fdate",
"label": "日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPOStyle",
"label": "采购方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWWType",
"label": "委外类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAreaPS",
"label": "采购范围",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FFetchAdd",
"label": "交货地点",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockID",
"label": "收料仓库",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSupplyID",
"label": "供应商",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FRelateBrID",
"label": "供货机构",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FClassTypeID",
"label": "事务类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExplanation",
"label": "摘要",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCurrencyID",
"label": "币别",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSelTranType",
"label": "源单类型(选单)",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSelBillNo",
"label": "选单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExchangeRate",
"label": "汇率",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillNo",
"label": "编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExchangeRateType",
"label": "汇率类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPOMode",
"label": "采购模式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCheckerID",
"label": "审核",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCheckDate",
"label": "审核日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FFManagerID",
"label": "主管",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDeptID",
"label": "部门",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FEmpID",
"label": "业务员",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillerID",
"label": "制单",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FManageType",
"label": "保税监管类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FEntryID2",
"label": "行号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxSampleBreakQty",
"label": "样本破坏数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxScrapInCommitQty",
"label": "报废入库关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxScrapQty",
"label": "报废数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMapNumber",
"label": "对应代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMapName",
"label": "对应名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FItemID",
"label": "物料代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FItemName",
"label": "物料名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FItemModel",
"label": "规格型号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxPropID",
"label": "辅助属性",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBaseUnit",
"label": "基本单位名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBatchNo",
"label": "批号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQty",
"label": "基本单位数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FUnitID",
"label": "单位",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Fauxqty",
"label": "数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecUnitID",
"label": "辅助单位",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecCoefficient",
"label": "换算率",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecQty",
"label": "辅助数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Fauxprice",
"label": "单价",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Famount",
"label": "金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "Fnote",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDischarged",
"label": "紧急放行",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FKFDate",
"label": "生产/采购日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FKFPeriod",
"label": "保质期(天)",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPeriodDate",
"label": "有效期至",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockID1",
"label": "收料仓库",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDCSPID",
"label": "仓位",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSourceBillNo",
"label": "源单单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSourceTranType",
"label": "源单类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSourceInterId",
"label": "源单内码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSourceEntryID",
"label": "源单分录",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FContractBillNo",
"label": "合同单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FContractInterID",
"label": "合同内码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FContractEntryID",
"label": "合同分录",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderBillNo",
"label": "订单单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderInterID",
"label": "订单内码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderEntryID",
"label": "订单分录",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxPropCls",
"label": "辅助属性类别",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPlanMode",
"label": "计划模式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMTONo",
"label": "计划跟踪号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrderType",
"label": "订单类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCheckMethod",
"label": "检验方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQCheckQty",
"label": "基本单位检验数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxQCheckQty",
"label": "检验数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecQCheckQty",
"label": "辅助单位检验数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FRelateQty",
"label": "检验基本关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxRelateQty",
"label": "检验关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecRelateQty",
"label": "辅助单位检验关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQtyPass",
"label": "基本单位合格数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxQtyPass",
"label": "合格数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecQtyPass",
"label": "辅助单位合格数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FConPassQty",
"label": "基本单位让步接收数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxConPassQty",
"label": "让步接收数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecConPassQty",
"label": "辅助单位让步接收数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FNotPassQty",
"label": "基本单位不合格数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxNotPassQty",
"label": "不合格数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSampleBreakQty",
"label": "基本单位样本破坏数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecNotPassQty",
"label": "辅助单位不合格数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecSampleBreakQty",
"label": "辅助单位样本破坏数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FScrapQty",
"label": "基本单位报废数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FConCommitQty",
"label": "入库基本关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxConCommitQty",
"label": "入库关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBackQty",
"label": "退料基本关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDeliveryNoticeFID",
"label": "交货通知单内码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxBackQty",
"label": "退料关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDeliveryNoticeEntryID",
"label": "交货通知单分录",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecScrapQty",
"label": "辅助单位报废数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecConCommitQty",
"label": "辅助单位入库关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecBackQty",
"label": "辅助单位退料关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FScrapInCommitQty",
"label": "报废入库基本关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecScrapInCommitQty",
"label": "辅助单位报废入库关联数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxQtyMust",
"label": "应收数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQtyMust",
"label": "基本单位应收数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAuxPickQty",
"label": "挑选使用数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPickQty",
"label": "基本单位挑选使用数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSamBillNo",
"label": "样品试制单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSamEntryID",
"label": "样品试制单行号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSamInterID",
"label": "样品试制单内码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSecPickQty",
"label": "辅助单位挑选使用数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTime",
"label": "打样次数",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBarCodeListID",
"label": "WMS条码外键",
"value": null,
"describe": null,
"is_required": false
}
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"type": "string",
"field": "Top",
"label": "当前记录数",
"value": "90000000",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "string",
"field": "PageSize",
"label": "每页条数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "string",
"field": "PageIndex",
"label": "开始行索引",
"value": "_function {{PAGINATION_START_PAGE}}+1",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "string",
"field": "Filter",
"label": "过滤条件",
"value": "[FCheckDate]>='{{LAST_SYNC_TIME|date}}' and [FCheckerID] > 0",
"describe": "需要先去k3增加自定义字段示例写法 [Fdate]>='{{LAST_SYNC_TIME|dateTime}}'",
"is_required": false
},
{
"type": "array",
"field": "Fields",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式:FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"is_required": true
},
{
"id": "SelectPage",
"type": "string",
"field": "SelectPage",
"label": "SelectPage",
"value": "2",
"parent": null
}
],
"otherResponse": [],
"getK3DetailPage": true
}
目标平台元数据配置:
{
"id": null,
"api": "openapi/v1/order/procure_order/import",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "array",
"field": "procureOrders",
"label": "array",
"value": "details",
"children": [
{
"type": "string",
"field": "procureOrderCode",
"label": "单号",
"value": "{{FBillNo}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "supplierCode",
"label": "供应商",
"value": "test",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "amountPlanned",
"label": "数量",
"value": "{{details.FQty}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "demandTime",
"label": "时间",
"value": "{{Fdate|datex}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "unitName",
"label": "单位",
"value": "{{details.FUnitID_DSPName}}",
"parent": "items",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "erpline",
"label": "行号",
"value": "{{details.FEntryID2}}",
"parent": "items",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "note",
"label": "单头备注",
"value": null,
"describe": null,
"is_required": false
},
{
"id": "materialCode",
"type": "string",
"field": "materialCode",
"label": "materialCode",
"value": "{{details.FItemID_FNDName}}",
"parent": "procureOrders"
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"otherRequest": [],
"otherResponse": []
}