供应商银行信息初始化提示字段无效“Caused exception message is: 列名 'FBENEFICIARY' 无效。”

问题：供应商银行信息初始化提示字段无效“Caused exception message is: 列名 'FBENEFICIARY' 无效。”

问题分析：研发提供的供应商银行信息方案是基于EAS850版本，不通的EAS版本或者不同的EAS850补丁基准不一样，会出现表结构不一样的情况。该方案中关联了一个视图类型的分类表，视图内容如下：

select

         companyBank.FSeq as companyBank_seq,

         companyBank.FBank as companyBank_bank,

         companyBank.FBankAccount as companyBank_account,

         companyBank.FIsDefault as companyBank_isDefault,

         companyBank.FBankAddress as companyBank_address,

         companyBank.FBENEFICIARY as companyBank_Beneficiary,

         companyInfo.FSettlementCurrencyID as companyInfo_currencyId,

         companyInfo.FSupplierID as companyInfo_supplierId

  from T_BD_SupplierCompanyBank companyBank,

       T_BD_SupplierCompanyInfo companyInfo

  where companyBank.FSupplierCompanyInfoID = companyInfo.FID

解决方案：

1. 获取视图脚本内容，在EAS查询分析器执行该脚本内容

   
   

2. 修改视图脚本，直到EAS查询分析可以执行成功查询出结果

1. select