源系统平台:旺店通·旗舰奇门
源系统接口: 采购入库查询wdt.wms.stockin.purchase.querywithdetail
目标系统平台: 金蝶云星空
目标系统接口: 采购入库新增batchSave
源平台元数据配置:
{
"id": "order_no",
"api": "wdt.wms.stockin.purchase.querywithdetail",
"type": "QUERY",
"method": "POST",
"number": "order_no",
"idCheck": true,
"request": [
{
"type": "object",
"field": "pager",
"label": "分页参数",
"children": [
{
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "50",
"parent": "pager",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "page_no",
"label": "页号",
"value": "1",
"parent": "pager",
"describe": null,
"is_required": true
}
],
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "params",
"label": "业务参数",
"children": [
{
"type": "string",
"field": "start_time",
"label": "开始时间",
"value": "{{LAST_SYNC_TIME|datetime}}",
"parent": "params",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "end_time",
"label": "结束时间",
"value": "{{CURRENT_TIME|datetime}}",
"parent": "params",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "status",
"label": "入库单状态",
"value": "80",
"parent": "params",
"describe": "10=已取消;20=编辑中;30=待审核;37=待质检;40=质检确认;80=已完成",
"is_required": false
},
{
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": null,
"parent": "params",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "stockin_no",
"label": "入库单号",
"value": null,
"parent": "params",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "purchase_no",
"label": "采购单号",
"value": null,
"parent": "params",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "order_no",
"label": "入库单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "status",
"label": "入库单状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "modified",
"label": "最后修改时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "created_time",
"label": "建单时间",
"value": "{{LAST_SYNC_TIME|datetime}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "logistics_type",
"label": "入库单物流类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "check_time",
"label": "入库单审核时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "purchase_no",
"label": "采购单编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goods_count",
"label": "入库单货品总数",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "provider_no",
"label": "供应商编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "provider_name",
"label": "供应商名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "outer_no",
"label": "外部单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "logistics_no",
"label": "入库单物流单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "logistics_name",
"label": "入库单物流名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "logistics_code",
"label": "物流公司编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goods_amount",
"label": "货品总价格,不包含优惠",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "total_price",
"label": "折后总额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "flag_name",
"label": "标记",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "details_list",
"label": "入库单明细",
"children": [
{
"type": "string",
"field": "remark",
"label": "入库单明细备注",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "tax_amount",
"label": "税后总价",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "rec_id",
"label": "入库单明细id",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "num",
"label": "数量",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "discount",
"label": "折扣",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "cost_price",
"label": "单价",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "src_price",
"label": "折后价",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "tax_price",
"label": "税后价(折后加税率)",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "tax",
"label": "税率",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "total_cost",
"label": "折后总价",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goods_name",
"label": "货品名称",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goods_no",
"label": "货品编号",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "spec_no",
"label": "商家编码",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "prop2",
"label": "规格自定义属性2",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "spec_name",
"label": "规格名称",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "brand_name",
"label": "品牌名称",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "unit_name",
"label": "基本单位",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "batch_no",
"label": "批次",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "expire_date",
"label": "有效期",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "defect",
"label": "是否残次品",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "RKD01_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单据类型",
"is_required": true
},
{
"type": "string",
"field": "FBusinessType",
"label": "业务类型",
"value": "CG",
"describe": "下拉列表",
"is_required": true
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{order_no}}",
"describe": "单据编号",
"is_required": true
},
{
"type": "string",
"field": "FStockOrgId",
"label": "收料组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": true
},
{
"type": "string",
"field": "FStockDeptId",
"label": "收料部门",
"value": "BM000014",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FPurchaseOrgId",
"label": "采购组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": true
},
{
"type": "string",
"field": "FSupplierId",
"label": "供应商",
"value": "{{provider_no}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FDate",
"label": "入库日期",
"value": "{{check_time|dateTime}}",
"describe": "日期",
"is_required": true
},
{
"type": "string",
"field": "FDeliveryBill",
"label": "送货单号",
"value": null,
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FTakeDeliveryBill",
"label": "提货单号",
"value": null,
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FSupplyId",
"label": "供货方",
"value": "{{provider_no}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "object",
"field": "FInStockFin",
"label": "财务信息",
"children": [
{
"type": "string",
"field": "FSettleOrgId",
"label": "结算组织",
"value": "100",
"parent": "FInStockFin",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FPayOrgId",
"label": "付款组织",
"value": "100",
"parent": "FInStockFin",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"id": "FSettleCurrId",
"type": "string",
"field": "FSettleCurrId",
"label": "结算币别",
"value": "PRE001",
"parent": "FInStockFin",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
}
],
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "FInStockEntry",
"label": "明细信息",
"value": "details_list",
"children": [
{
"type": "string",
"field": "FMaterialId",
"label": "物料编码",
"value": "{{details_list.spec_no}}",
"parent": "FInStockEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FCMKBarCode",
"label": "零售条形码",
"value": null,
"parent": "FInStockEntry",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FRealQty",
"label": "实收数量",
"value": "{{details_list.num}}",
"parent": "FInStockEntry",
"describe": "数量",
"is_required": true
},
{
"type": "string",
"field": "FPrice",
"label": "单价",
"value": "{{details_list.cost_price}}",
"parent": "FInStockEntry",
"describe": "单价",
"is_required": false
},
{
"type": "string",
"field": "FLot",
"label": "批号",
"value": null,
"parent": "FInStockEntry",
"describe": "批次",
"is_required": false
},
{
"type": "string",
"field": "FStockId",
"label": "仓库",
"value": "{{details_list.warehouse_no}}",
"parent": "FInStockEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FStockLocId",
"label": "仓位",
"value": null,
"parent": "FInStockEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "维度关联字段",
"is_required": false
},
{
"type": "string",
"field": "FMtoNo",
"label": "计划跟踪号",
"value": null,
"parent": "FInStockEntry",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FGiveAway",
"label": "是否赠品",
"value": "_function case '{{details_list.tax_price}}' when '0' then true else false end",
"parent": "FInStockEntry",
"describe": "复选框",
"is_required": false
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": null,
"parent": "FInStockEntry",
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": "{{details_list.tax_price}}",
"parent": "FInStockEntry",
"describe": "单价",
"is_required": false
},
{
"type": "string",
"field": "FEntryTaxRate",
"label": "税率(%)",
"value": null,
"parent": "FInStockEntry",
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FDiscountRate",
"label": "折扣率(%)",
"value": null,
"parent": "FInStockEntry",
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FSRCBILLTYPEID",
"label": "源单类型",
"value": "PUR_PurchaseOrder",
"parent": "FInStockEntry"
},
{
"type": "string",
"field": "FSRCBillNo",
"label": "源单编号",
"value": "{{purchase_no}}",
"parent": "FInStockEntry"
},
{
"type": "string",
"field": "FPOOrderNo",
"label": "订单编号",
"value": "{{purchase_no}}",
"parent": "FInStockEntry"
},
{
"type": "string",
"field": "FOWNERID",
"label": "货主",
"value": null,
"parent": "FInStockEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "多类别基础资料",
"is_required": false
},
{
"type": "array",
"field": "FInStockEntry_Link",
"label": "关联关系",
"value": null,
"parent": "FInStockEntry",
"children": [
{
"type": "string",
"field": "FInStockEntry_Link_FSBillId",
"label": "源单ID",
"value": "_findCollection find FID from 073dfe24-a1b7-326a-a5e6-acc3dac6e096 where FBillNo={{purchase_no}}",
"parent": "FInStockEntry_Link",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FInStockEntry_Link_FRuleId",
"label": "下推关系",
"value": "PUR_PurchaseOrder-STK_InStock",
"parent": "FInStockEntry_Link",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FInStockEntry_Link_FSId",
"label": "表体ID",
"value": "_findCollection find FPOOrderEntry_FEntryId from 073dfe24-a1b7-326a-a5e6-acc3dac6e096 where FBillNo={{purchase_no}} FMaterialId_FNumber={{details_list.spec_no}}",
"parent": "FInStockEntry_Link",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FInStockEntry_Link_FSTableName",
"label": "源单表名",
"value": "t_PUR_POOrderEntry",
"parent": "FInStockEntry_Link",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"id": "FSTOCKSTATUSID",
"type": "string",
"field": "FSTOCKSTATUSID",
"label": "库存状态",
"value": "_function case '{{defect}}' when true then 'KCZT08_SYS' else 'KCZT01_SYS' end",
"parent": "FInStockEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "STK_InStock",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "true",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "Save",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false",
"describe": "是否验证所有的基础资料有效性,布尔类,默认false(非必录)",
"is_required": false
},
{
"type": "string",
"field": "SubSystemId",
"label": "系统模块",
"value": "21",
"describe": "默认仓库模块",
"is_required": false
}
],
"otherResponse": []
}