EAS8.1版本在出纳管理中的 收款单添加了两个字段后，单据新增保存时报错，提示错误界面为：
查询后台日志 发现 有sql关联了n个表，取了很多字段，导致数据库报错
:30,532 ERROR RPC-28]current org is:A5EAAAAAAubM567U
2016-08-20 15:09:31 INFO [con.out] [2016-08-20 15:09:31,379 ERROR RPC-75]current org is:A5EAAAAAAubM567U
2016-08-20 15:09:40 INFO [con.out] [2016-08-20 15:09:40,068 ERROR RPC-68]execute sql error: ORA-01792: maximum number of columns in a table or view is 1000
sql:SELECT "T0"."FID" "ID", "T0"."FCREATORID" "T1.ID", "T0"."FCREATETIME" "CREATETIME", "T0"."FLASTUPDATEUSERID" "T2.ID", "T0"."FLASTUPDATETIME" "LASTUPDATETIME", "T0"."FCONTROLUNITID" "T3.ID", "T0"."FNUMBER" "NUMBER", "T0"."FBIZDATE" "BIZDATE", "T0"."FHANDLERID" "T4.ID", "T0"."FDESCRIPTION" "DESCRIPTION", "T0"."FHASEFFECTED" "HASEFFECTED", "T0"."FAUDITORID" "T5.ID", "T0"."FSOURCEBILLID" "SOURCEBILLID", "T0"."FSOURCEFUNCTION" "SOURCEFUNCTION", "T0"."FCOMPANYID" "T6.ID", "T6"."FCREATORID" "T7.ID", "T6"."FCREATETIME" "T6.CREATETIME", "T6"."FLASTUPDATEUSERID" "T8.ID", "T6"."FLASTUPDATETIME" "T6.LASTUPDATETIME", "T6"."FCONTROLUNITID" "T9.ID", "T6"."FNAME_L2" "T6.NAME", "T6"."FNAME_L1" "T6.NAME_L1", "T6"."FNAME_L2" "T6.NAME_L2", "T6"."FNAME_L3" "T6.NAME_L3", "T6"."FNUMBER" "T6.NUMBER", "T6"."FDESCRIPTION_L2" "T6.DESCRIPTION", "T6"."FDESCRIPTION_L1" "T6.DESCRIPTION_L1", "T6"."FDESCRIPTION_L2" "T6.DESCRIPTION_L2", "T6"."FDESCRIPTION_L3" "T6.DESCRIPTION_L3", "T6"."FSIMPLENAME" "T6.SIMPLENAME", "T6"."FISLEAF" "T6.ISLEAF", "T6"."FLEVEL" "T6.LEVEL", "T6"."FLONGNUMBER" "T6.LONGNUMBER", "T6"."FDISPLAYNAME_L2" "T6.DISPLAYNAME", "T6"."FDISPLAYNAME_L1" "T6.DISPLAYNAME_L1", "T6"."FDISPLAYNAME_L2" "T6.DISPLAYNAME_L2", "T6"."FDISPLAYNAME_L3" "T6.DISPLAYNAME_L3", "T6"."FISGROUPING" "T6.ISGROUPING", "T6"."FEFFECTDATE" "T6.EFFECTDATE", "T6"."FINVALIDDATE" "T6.INVALIDDATE", "T6"."FISFREEZE" "T6.ISFREEZE", "T6"."FISCOMPANYORGUNIT" "T6.ISCOMPANYORGUNIT", "T6"."FISADMINORGUNIT" "T6.ISADMINORGUNIT", "T6"."FISSALEORGUNIT" "T6.ISSALEORGUNIT", "T6"."FISPURCHASEORGUNIT" "T6.ISPURCHASEORGUNIT", "T6"."FISSTORAGEORGUNIT" "T6.ISSTORAGEORGUNIT", "T6"."FISPROFITORGUNIT" "T6.ISPROFITORGUNIT", "T6"."FISCOSTORGUNIT" "T6.ISCOSTORGUNIT", "T6"."FISCU" "T6.ISCU", "T6"."FISUNION" "T6.ISUNION", "T6"."FISHRORGUNIT" "T6.ISHRORGUNIT", "T6"."FISTRANSPORTORGUNIT" "T6.ISTRANSPORTORGUNIT", "T6"."FISQUALITYORGUNIT" "T6.ISQUALITYORGUNIT", "T6"."FISSTART" "T6.ISSTART", "T6"."FISOUSEALUP" "T6.ISOUSEALUP", "T6"."FCODE" "T6.CODE", "T6"."FVERSIONNUMBER" "T6.VERSIONNUMBER", "T6"."FORGTYPESTR" "T6.ORGTYPESTR", "T6"."FISSEALUP" "T6.ISSEALUP", "T6"."FISBIZUNIT" "T6.ISBIZUNIT", "T6"."FPROPERTYSEALUPDATE" "T6.PROPERTYSEALUPDATE", "T6"."FTAXNUMBER" "T6.TAXNUMBER", "T6"."FISGROUP" "T6.ISGROUP", "T6"."FISONLYUNION" "T6.ISONLYUNION", "T6"."FINDUSTRY" "T10.ID", "T6"."FBANKID" "T11.ID", "T6"."FREPORTCURRENCYID" "T12.ID", "T6"."FACCOUNTPERIODID" "T13.ID", "T6"."FJURIDICALPERSONID" "T14.ID", "T6"."FACCOUNTTABLEID" "T15.ID", "T6"."FADDRESSID" "T16.ID", "T6"."FBASECURRENCYID" "T17.ID", "T6"."FBASEEXGTABLEID" "T18.ID", "T6"."FADJUSTEXGTABLEID" "T19.ID", "T6"."FREPORTCONVERTMODE" "T6.REPORTCONVERTMODE", "T6"."FREPORTEXGTABLEID" "T20.ID", "T6"."FREGION" "T21.ID", "T6"."FECONOMICTYPE" "T6.ECONOMICTYPE", "T6"."FREGISTEREDCAPITAL" "T6.REGISTEREDCAPITAL", "T6"."FSETUPDATE" "T6.SETUPDATE", "T6"."FENDUPDATE" "T6.ENDUPDATE", "T6"."FTERRITORY_L2" "T6.TERRITORY", "T6"."FTERRITORY_L1" "T6.TERRITORY_L1", "T6"."FTERRITORY_L2" "T6.TERRITORY_L2", "T6"."FTERRITORY_L3" "T6.TERRITORY_L3", "T6"."FISCHURCHYARD" "T6.ISCHURCHYARD", "T6"."FREGISTEREDCODE" "T6.REGISTEREDCODE", "T6"."FISASSISTANTORG" "T6.ISASSISTANTORG", "T6"."FMAINORGID" "T22.ID", "T6"."FACCOUNTSCHEMEID" "T23.ID", "T6"."FPARENTID" "T24.ID", "T0"."FSOURCESYSTYPE" "SOURCESYSTYPE", "T0"."FSOURCETYPE" "SOURCETYPE", "T0"."FCURRENCYID" "T25.ID", "T25"."FNAME_L2" "T25.NAME", "T25"."FNAME_L1" "T25.NAME_L1", "T25"."FNAME_L2" "T25.NAME_L2", "T25"."FNAME_L3" "T25.NAME_L3", "T25"."FPRECISION" "T25.PRECISION", "T0"."FEXCHANGERATE" "EXCHANGERATE", "T0"."FISEXCHANGED" "ISEXCHANGED", "T0"."FLASTEXHANGERATE" "LASTEXHANGERATE", "T0"."FSETTLEMENTTYPEID" "T26.ID", "T26"."FCREATORID" "T27.ID", "T26"."FCREATETIME" "T26.CREATETIME", "T26"."FLASTUPDATEUSERID" "T28.ID", "T26"."FLASTUPDATETIME" "T26.LASTUPDATETIME", "T26"."FCONTROLUNITID" "T29.ID", "T26"."FNAME_L2" "T26.NAME", "T26"."FNAME_L1" "T26.NAME_L1", "T26"."FNAME_L2" "T26.NAME_L2", "T26"."FNAME_L3" "T26.NAME_L3", "T26"."FNUMBER" "T26.NUMBER", "T26"."FDESCRIPTION_L2" "T26.DESCRIPTION", "T26"."FDESCRIPTION_L1" "T26.DESCRIPTION_L1", "T26"."FDESCRIPTION_L2" "T26.DESCRIPTION_L2", "T26"."FDESCRIPTION_L3" "T26.DESCRIPTION_L3", "T26"."FSIMPLENAME" "T26.SIMPLENAME", "T26"."FISDEFAULT" "T26.ISDEFAULT", "T26"."FNTTYPEID" "T30.ID", "T30"."FCREATORID" "T31.ID", "T30"."FCREATETIME" "T30.CREATETIME", "T30"."FLASTUPDATEUSERID" "T32.ID", "T30"."FLASTUPDATETIME" "T30.LASTUPDATETIME", "T30"."FCONTROLUNITID" "T33.ID", "T30"."FNAME_L2" "T30.NAME", "T30"."FNAME_L1" "T30.NAME_L1", "T30"."FNAME_L2" "T30.NAME_L2", "T30"."FNAME_L3" "T30.NAME_L3", "T30"."FNUMBER" "T30.NUMBER", "T30"."FDESCRIPTION_L2" "T30.DESCRIPTION", "T30"."FDESCRIPTION_L1" "T30.DESCRIPTION_L1", "T30"."FDESCRIPTION_L2" "T30.DESCRIPTION_L2", "T30"."FDESCRIPTION_L3" "T30.DESCRIPTION_L3", "T30"."FSIMPLENAME" "T30.SIMPLENAME", "T30"."FISSYSTEM" "T30.ISSYSTEM", "T30"."FISUSED" "T30.ISUSED", "T30"."FGROUP" "T30.GROUP", "T30"."FSUPERGROUP" "T30.SUPERGROUP", "T30"."FFINANCETYPEID" "T34.ID", "T30"."FISCASH" "T30.ISCASH", "T26"."FDELETEDSTATUS" "T26.DELETEDSTATUS", "T26"."FPAYTHROUGHBE" "T26.PAYTHROUGHBE", "T26"."FISPERSONPAY" "T26.ISPERSONPAY", "T26"."FISAGENCYPERSONPAY" "T26.ISAGENCYPERSONPAY", "T0"."FSETTLEMENTNUMBER" "SETTLEMENTNUMBER", "T0"."FOPPACCOUNTID" "T35.ID", "T35"."FNAME_L2" "T35.NAME", "T35"."FNAME_L1" "T35.NAME_L1", "T35"."FNAME_L2" "T35.NAME_L2", "T35"."FNAME_L3" "T35.NAME_L3", "T35"."FNUMBER" "T35.NUMBER", "T35"."FCAA" "T36.ID", "T0"."FFPITEMID" "T37.ID", "T37"."FNAME_L2" "T37.NAME", "T37"."FNAME_L1" "T37.NAME_L1", "T37"."FNAME_L2" "T37.NAME_L2", "T37"."FNAME_L3" "T37.NAME_L3", "T37"."FNUMBER" "T37.NUMBER", "T37"."FDIRECTION" "T37.DIRECTION", "T0"."FISCOMMITSETTLE" "ISCOMMITSETTLE", "T0"."FSETTLEBIZTYPE" "SETTLEBIZTYPE", "T0"."FAUDITDATE" "AUDITDATE", "T0"."FCASHIERID" "T38.ID", "T0"."FACCOUNTANTID" "T39.ID", "T0"."FISINITIALIZEBILL" "ISINITIALIZEBILL", "T0"."FFIVOUCHERED" "FIVOUCHERED", "T0"."FBILLSTATUS" "BILLSTATUS", "T0"."FSETTLEMENTSTATUS" "SETTLEMENTSTATUS", "T0"."FFUNDTYPE" "FUNDTYPE", "T0"."FISIMPORT" "ISIMPORT", "T0"."FAMOUNT" "AMOUNT", "T0"."FLOCALAMOUNT" "LOCALAMT", "T0"."FADMINORGUNITID" "T40.ID", "T40"."FNAME_L2" "T40.NAME", "T40"."FNAME_L1" "T40.NAME_L1", "T40"."FNAME_L2" "T40.NAME_L2", "T40"."FNAME_L3" "T40.NAME_L3", "T40"."FNUMBER" "T40.NUMBER", "T0"."FPERSONID" "T41.ID", "T41"."FNAME_L2" "T41.NAME", "T41"."FNAME_L1" "T41.NAME_L1", "T41"."FNAME_L2" "T41.NAME_L2", "T41"."FNAME_L3" "T41.NAME_L3", "T41"."FNUMBER" "T41.NUMBER", "T0"."FACCESSORYAMT" "ACCESSORYAMT", "T0"."FCONCEIT" "CONCEIT", "T0"."FSUMMARY" "SUMMARY", "T0"."FCONTRACTNO" "CONTRACTNO", "T0"."FDAYACCOUNT" "DAYACCOUNT", "T0"."FCAPITALAMOUNT" "CAPITALAMOUNT", "T0"."FCONTRACTBILLID" "CONTRACTBILLID", "T0"."FPROJECTID" "T42.ID", "T42"."FNAME_L2" "T42.NAME", "T42"."FNAME_L1" "T42.NAME_L1", "T42"."FNAME_L2" "T42.NAME_L2", "T42"."FNAME_L3" "T42.NAME_L3", "T42"."FNUMBER" "T42.NUMBER", "T0"."FPROJECTMANAGERID" "T43.ID", "T43"."FNAME_L2" "T43.NAME", "T43"."FNAME_L1" "T43.NAME_L1", "T43"."FNAME_L2" "T43.NAME_L2", "T43"."FNAME_L3" "T43.NAME_L3", "T0"."FISBOOKRL" "ISBOOKRL", "T0"."FBIZTYPEID" "T44.ID", "T44"."FCREATORID" "T45.ID", "T44"."FCREATETIME" "T44.CREATETIME", "T44"."FLASTUPDATEUSERID" "T46.ID", "T44"."FLASTUPDATETIME" "T44.LASTUPDATETIME", "T44"."FCONTROLUNITID" "T47.ID", "T44"."FNAME_L2" "T44.NAME", "T44"."FNAME_L1" "T44.NAME_L1", "T44"."FNAME_L2" "T44.NAME_L2", "T44"."FNAME_L3" "T44.NAME_L3", "T44"."FNUMBER" "T44.NUMBER", "T44"."FDESCRIPTION_L2" "T44.DESCRIPTION", "T44"."FDESCRIPTION_L1" "T44.DESCRIPTION_L1", "T44"."FDESCRIPTION_L2" "T44.DESCRIPTION_L2", "T44"."FDESCRIPTION_L3" "T44.DESCRIPTION_L3", "T44"."FSIMPLENAME" "T44.SIMPLENAME", "T44"."FTYPE" "T44.TYPE", "T44"."FISSENDDOWNUNIT" "T44.ISSENDDOWNUNIT", "T44"."FISONLYCLHOUSE" "T44.ISONLYCLHOUSE", "T44"."FNOTSUBMITHOUSE" "T44.NOTSUBMITHOUSE", "T0"."FISREDBILL" "ISREDBILL", "T0"."FISTRANSBILL" "ISTRANSBILL", "T0"."FFEETYPEID" "T48.ID", "T48"."FNAME_L2" "T48.NAME", "T48"."FNAME_L1" "T48.NAME_L1", "T48"."FNAME_L2" "T48.NAME_L2", "T48"."FNAME_L3"
推荐阅读