源系统平台:金蝶云星空
源系统接口: 供应商查询executeBillQuery
目标系统平台: 旺店通·企业奇门
目标系统接口: 创建供应商wdt.purchase.provider.create
源平台元数据配置:
{
"id": "FSupplierId",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FNumber",
"idCheck": false,
"request": [
{
"type": "string",
"field": "FSupplierId",
"label": "FSupplierId",
"value": "FSupplierId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FName",
"label": "名称",
"value": "FName",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": "FCreateOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": "FUseOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": "FDescription",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FShortName",
"label": "简称",
"value": "FShortName",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMinPOValue",
"label": "最小订单量",
"value": "FMinPOValue",
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FCountry_FNumber",
"label": "国家",
"value": "FCountry.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FBusinessStatus",
"label": "业务状态",
"value": "FBusinessStatus",
"describe": "单据状态",
"is_required": false
},
{
"type": "string",
"field": "FProvincial_FNumber",
"label": "地区",
"value": "FProvincial.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FFreezeLimit",
"label": "冻结范围",
"value": "FFreezeLimit",
"describe": "多选下拉列表",
"is_required": false
},
{
"type": "string",
"field": "FAddress",
"label": "通讯地址",
"value": "FAddress",
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FZip",
"label": "邮政编码",
"value": "FZip",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FFreezeDate",
"label": "冻结日期",
"value": "FFreezeDate",
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FPurchaserGroupId_FNumber",
"label": "采购组",
"value": "FPurchaserGroupId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FParentSupplierId_FNumber",
"label": "汇总公司",
"value": "FParentSupplierId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FLanguage_FNumber",
"label": "语言",
"value": "FLanguage.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FWebSite",
"label": "公司网址",
"value": "FWebSite",
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FCustomerId_FNumber",
"label": "对应客户",
"value": "FCustomerId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FPayCurrencyId_FNumber",
"label": "结算币别",
"value": "FPayCurrencyId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FSettleTypeId_FNumber",
"label": "结算方式",
"value": "FSettleTypeId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FPayCondition_FNumber",
"label": "付款条件",
"value": "FPayCondition.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FSettleId_FNumber",
"label": "结算方",
"value": "FSettleId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FPayAdvanceAmount",
"label": "单次预付额度",
"value": "FPayAdvanceAmount",
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FTaxType_FNumber",
"label": "税分类",
"value": "FTaxType.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FTaxRegisterCode",
"label": "税务登记号",
"value": "FTaxRegisterCode",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FTendType_FNumber",
"label": "经营类型",
"value": "FTendType.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FChargeId_FNumber",
"label": "收款方",
"value": "FChargeId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FInvoiceType",
"label": "发票类型",
"value": "FInvoiceType",
"describe": "下拉列表",
"is_required": false
},
{
"type": "string",
"field": "FTaxRateId_FNumber",
"label": "默认税率",
"value": "FTaxRateId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FFinanceDesc",
"label": "描述",
"value": "FFinanceDesc",
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FTrade_FNumber",
"label": "行业",
"value": "FTrade.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FPRICELISTID_FNumber",
"label": "默认价目表",
"value": "FPRICELISTID.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FDiscountListId_FNumber",
"label": "默认折扣表",
"value": "FDiscountListId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FFoundDate",
"label": "创立日期",
"value": "FFoundDate",
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FNeedConfirm",
"label": "需要确认",
"value": "FNeedConfirm",
"describe": "复选框",
"is_required": false
},
{
"type": "string",
"field": "FProviderId_FNumber",
"label": "供货方",
"value": "FProviderId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FLegalPerson",
"label": "法人代表",
"value": "FLegalPerson",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FWipStockId_FNumber",
"label": "默认WIP仓库",
"value": "FWipStockId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FRegisterFund",
"label": "注册资金(万元)",
"value": "FRegisterFund",
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FRegisterCode",
"label": "工商登记号",
"value": "FRegisterCode",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FVmiBusiness",
"label": "VMI业务",
"value": "FVmiBusiness",
"describe": "复选框",
"is_required": false
},
{
"type": "string",
"field": "FSOCIALCRECODE",
"label": "统一社会信用代码",
"value": "FSOCIALCRECODE",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FTendPermit",
"label": "生产经营许可证",
"value": "FTendPermit",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FVmiStockId_FNumber",
"label": "VMI仓库",
"value": "FVmiStockId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FRegisterAddress",
"label": "注册地址",
"value": "FRegisterAddress",
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FDeptId_FNumber",
"label": "负责部门",
"value": "FDeptId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FStaffId_FNumber",
"label": "负责人",
"value": "FStaffId.FNumber",
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FSupplierClassify_FNumber",
"label": "供应商分类",
"value": "FSupplierClassify.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FSupplyClassify",
"label": "供应类别",
"value": "FSupplyClassify",
"describe": "下拉列表",
"is_required": false
},
{
"type": "string",
"field": "FSupplierGrade_FNumber",
"label": "供应商等级",
"value": "FSupplierGrade.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FGroup",
"label": "供应商分组",
"value": "FGroup",
"describe": "分组",
"is_required": false
},
{
"type": "string",
"field": "FCompanyClassify_FNumber",
"label": "公司类别",
"value": "FCompanyClassify.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FCompanyNature_FNumber",
"label": "公司性质",
"value": "FCompanyNature.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FCompanyScale_FNumber",
"label": "公司规模",
"value": "FCompanyScale.FNumber",
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FCorrespondOrgId_FNumber",
"label": "对应组织",
"value": "FCorrespondOrgId.FNumber",
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FStartDate",
"label": "生效日期",
"value": "FStartDate",
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FEndDate",
"label": "失效日期",
"value": "FEndDate",
"describe": "日期",
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "FSupplierId",
"label": "FSupplierId",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FName",
"label": "名称",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FShortName",
"label": "简称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMinPOValue",
"label": "最小订单量",
"value": null,
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FCountry_FNumber",
"label": "国家",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FBusinessStatus",
"label": "业务状态",
"value": null,
"describe": "单据状态",
"is_required": false
},
{
"type": "string",
"field": "FProvincial_FNumber",
"label": "地区",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FFreezeLimit",
"label": "冻结范围",
"value": null,
"describe": "多选下拉列表",
"is_required": false
},
{
"type": "string",
"field": "FAddress",
"label": "通讯地址",
"value": null,
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FZip",
"label": "邮政编码",
"value": null,
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FFreezeDate",
"label": "冻结日期",
"value": null,
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FPurchaserGroupId_FNumber",
"label": "采购组",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FParentSupplierId_FNumber",
"label": "汇总公司",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FLanguage_FNumber",
"label": "语言",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FWebSite",
"label": "公司网址",
"value": null,
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FCustomerId_FNumber",
"label": "对应客户",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FPayCurrencyId_FNumber",
"label": "结算币别",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FSettleTypeId_FNumber",
"label": "结算方式",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FPayCondition_FNumber",
"label": "付款条件",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FSettleId_FNumber",
"label": "结算方",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FPayAdvanceAmount",
"label": "单次预付额度",
"value": null,
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FTaxType_FNumber",
"label": "税分类",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FTaxRegisterCode",
"label": "税务登记号",
"value": null,
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FTendType_FNumber",
"label": "经营类型",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FChargeId_FNumber",
"label": "收款方",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FInvoiceType",
"label": "发票类型",
"value": null,
"describe": "下拉列表",
"is_required": false
},
{
"type": "string",
"field": "FTaxRateId_FNumber",
"label": "默认税率",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FFinanceDesc",
"label": "描述",
"value": null,
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FTrade_FNumber",
"label": "行业",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FPRICELISTID_FNumber",
"label": "默认价目表",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FDiscountListId_FNumber",
"label": "默认折扣表",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FFoundDate",
"label": "创立日期",
"value": null,
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FNeedConfirm",
"label": "需要确认",
"value": null,
"describe": "复选框",
"is_required": false
},
{
"type": "string",
"field": "FProviderId_FNumber",
"label": "供货方",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FLegalPerson",
"label": "法人代表",
"value": null,
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FWipStockId_FNumber",
"label": "默认WIP仓库",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FRegisterFund",
"label": "注册资金(万元)",
"value": null,
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FRegisterCode",
"label": "工商登记号",
"value": null,
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FVmiBusiness",
"label": "VMI业务",
"value": null,
"describe": "复选框",
"is_required": false
},
{
"type": "string",
"field": "FSOCIALCRECODE",
"label": "统一社会信用代码",
"value": null,
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FTendPermit",
"label": "生产经营许可证",
"value": null,
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FVmiStockId_FNumber",
"label": "VMI仓库",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FRegisterAddress",
"label": "注册地址",
"value": null,
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FDeptId_FNumber",
"label": "负责部门",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FStaffId_FNumber",
"label": "负责人",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FSupplierClassify_FNumber",
"label": "供应商分类",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FSupplyClassify",
"label": "供应类别",
"value": null,
"describe": "下拉列表",
"is_required": false
},
{
"type": "string",
"field": "FSupplierGrade_FNumber",
"label": "供应商等级",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FGroup",
"label": "供应商分组",
"value": null,
"describe": "分组",
"is_required": false
},
{
"type": "string",
"field": "FCompanyClassify_FNumber",
"label": "公司类别",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FCompanyNature_FNumber",
"label": "公司性质",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FCompanyScale_FNumber",
"label": "公司规模",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FCorrespondOrgId_FNumber",
"label": "对应组织",
"value": null,
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FStartDate",
"label": "生效日期",
"value": null,
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FEndDate",
"label": "失效日期",
"value": null,
"describe": "日期",
"is_required": false
}
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0",
"describe": "金蝶的查询分页参数",
"is_required": false
},
{
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "FAuditDate>='{{LAST_SYNC_TIME|dateTime}}' and FDocumentStatus = 'C'",
"describe": "示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=",
"is_required": false
},
{
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式:FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"is_required": true
},
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "BD_Supplier",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "wdt.purchase.provider.create",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "provider_no",
"label": "供应商编号",
"value": "{{FNumber}}",
"describe": "代表供应商所有属性的唯一编码,用于供应商区分,ERP内支持自定义(ERP供应商界面设置),用于创建供应商数据信息",
"is_required": true
},
{
"type": "string",
"field": "provider_name",
"label": "供应商名称",
"value": "{{FName}}",
"describe": "供应商名称",
"is_required": true
},
{
"type": "string",
"field": "min_purchase_num",
"label": "最小采购量",
"value": "1",
"describe": "最小采购量",
"is_required": true
},
{
"type": "string",
"field": "purchase_cycle_days",
"label": "采购周期",
"value": "1",
"describe": "采购周期",
"is_required": true
},
{
"type": "string",
"field": "arrive_cycle_days",
"label": "到货周期",
"value": "1",
"describe": "到货周期",
"is_required": true
},
{
"type": "string",
"field": "contact",
"label": "联系人",
"value": null,
"describe": "联系人",
"is_required": false
},
{
"type": "string",
"field": "telno",
"label": "座机",
"value": null,
"describe": "座机",
"is_required": false
},
{
"type": "string",
"field": "mobile",
"label": "移动电话",
"value": null,
"describe": "手机号",
"is_required": false
},
{
"type": "string",
"field": "fax",
"label": "传真",
"value": null,
"describe": "传真",
"is_required": false
},
{
"type": "string",
"field": "zip",
"label": "邮编",
"value": null,
"describe": "邮政编码",
"is_required": false
},
{
"type": "string",
"field": "email",
"label": "邮箱",
"value": null,
"describe": "电子邮箱",
"is_required": false
},
{
"type": "string",
"field": "qq",
"label": "qq",
"value": null,
"describe": "腾讯QQ号码",
"is_required": false
},
{
"type": "string",
"field": "wangwang",
"label": "旺旺",
"value": null,
"describe": "淘宝旺旺号",
"is_required": false
},
{
"type": "string",
"field": "address",
"label": "地址",
"value": null,
"describe": "省、市、区(县)、地址详情",
"is_required": false
},
{
"type": "string",
"field": "website",
"label": "网址",
"value": null,
"describe": "供应商官网地址",
"is_required": false
},
{
"type": "string",
"field": "last_purchase_time",
"label": "最后采购日期",
"value": null,
"describe": "对供应商最后一次采购日期,不传默认接口创建供应商的年月日,格式:yyyy-MM-dd HH:mm:ss",
"is_required": false
},
{
"type": "string",
"field": "is_disabled",
"label": "停用",
"value": null,
"describe": "是否停用",
"is_required": false
},
{
"type": "string",
"field": "charge_cycle_days",
"label": "结算周期",
"value": "0",
"describe": "对供应商的账款结算周期,单位(天),不传默认0",
"is_required": false
}
],
"response": [],
"otherRequest": [],
"otherResponse": []
}