应收账龄分析表打开报错,提示:列名 'FCorrespondOrgId' 无效
解决方案:
视图缺失字段所致,需要在数据库中重建视图 V_FIN_CONTACTTYPE
以及 V_FIN_CONTACTTYPE_L
,相关执行脚本如下:
ALTER VIEW [dbo].[V_FIN_CONTACTTYPE] AS SELECT FSupplierId fitemid, 'BD_Supplier' fformid, FNUMBER fnumber, FMasterId fmasterid, FCREATEORGID fcreateorgid, FUSEORGID fuseorgid, FDOCUMENTSTATUS fdocumentstatus, FFORBIDSTATUS fforbidstatus, FCREATORID fcreatorid, FMODIFIERID fmodifierid, FCREATEDATE fcreatedate, FMODIFYDATE fmodifydate ,FCORRESPONDORGID FCORRESPONDORGID FROM t_BD_Supplier UNION SELECT FCUSTID fitemid, 'BD_Customer' fformid, FNUMBER fnumber, FMasterId fmasterid, FCREATEORGID fcreateorgid, FUSEORGID fuseorgid, FDOCUMENTSTATUS fdocumentstatus, FFORBIDSTATUS fforbidstatus, FCREATORID fcreatorid, FMODIFIERID fmodifierid, FCREATEDATE fcreatedate, FMODIFYDATE fmodifydate ,FCORRESPONDORGID FCORRESPONDORGID FROM T_BD_CUSTOMER UNION SELECT FDEPTID fitemid, 'BD_Department' fformid, FNUMBER fnumber, FMASTERID fmasterid, FCREATEORGID fcreateorgid, FUSEORGID fuseorgid, FDOCUMENTSTATUS fdocumentstatus, FFORBIDSTATUS fforbidstatus, FCREATORID fcreatorid, FMODIFIERID fmodifierid, FCREATEDATE fcreatedate, FMODIFYDATE fmodifydate ,0 AS FCORRESPONDORGID FROM T_BD_DEPARTMENT UNION SELECT FID fitemid, 'BD_Empinfo' fformid, FSTAFFNUMBER fnumber, FMasterId fmasterid, FCREATEORGID fcreateorgid, FUSEORGID fuseorgid, FDOCUMENTSTATUS fdocumentstatus, FFORBIDSTATUS fforbidstatus, FCREATORID fcreatorid, FMODIFIERID fmodifierid, FCREATEDATE fcreatedate, FMODIFYDATE fmodifydate ,0 AS FCORRESPONDORGID FROM T_HR_EMPINFO UNION SELECT FID fitemid, 'FIN_OTHERS' fformid, FNUMBER fnumber, FMasterId fmasterid, FCREATEORGID fcreateorgid, FUSEORGID fuseorgid, FDOCUMENTSTATUS fdocumentstatus, FFORBIDSTATUS fforbidstatus, FCREATORID fcreatorid, FMODIFIERID fmodifierid, FCREATEDATE fcreatedate, FMODIFYDATE fmodifydate ,0 AS FCORRESPONDORGID FROM T_FIN_OTHERS UNION SELECT FOrgID fitemid, 'ORG_Organizations' fformid, FNUMBER fnumber, FOrgID fmasterid, 0 fcreateorgid, 0 fuseorgid, FDOCUMENTSTATUS fdocumentstatus, FFORBIDSTATUS fforbidstatus, FCREATORID fcreatorid, FMODIFIERID fmodifierid, FCREATEDATE fcreatedate, FMODIFYDATE fmodifydate ,0 AS FCORRESPONDORGID FROM T_ORG_Organizations UNION SELECT FBANKID fitemid, 'BD_BANK' fformid, FNUMBER fnumber, FMasterId fmasterid, FCREATEORGID fcreateorgid, FUSEORGID fuseorgid, FDOCUMENTSTATUS fdocumentstatus, FFORBIDSTATUS fforbidstatus, FCREATORID fcreatorid, FMODIFIERID fmodifierid, FCREATEDATE fcreatedate, FMODIFYDATE fmodifydate ,0 AS FCORRESPONDORGID FROM T_BD_BANKUNION SELECT FCATEGORYID fitemid, 'k4a4f9cd23f4e49688dd0080966886bc9' fformid, FNUMBER fnumber, FMasterId fmasterid, FCREATEORGID fcreateorgid, FUSEORGID fuseorgid, FDOCUMENTSTATUS fdocumentstatus, FFORBIDSTATUS fforbidstatus, FCREATORID fcreatorid, FMODIFIERID fmodifierid, FCREATEDATE fcreatedate, FMODIFYDATE fmodifydate ,0 AS FCORRESPONDORGID FROM cyh_t_Cust100008 GOALTER VIEW [dbo].[V_FIN_CONTACTTYPE_L] AS SELECT FPKID, FSUPPLIERID fitemid, FLOCALEID, FNAME fname, FDESCRIPTION fdescription, 'BD_Supplier' fformid FROM T_BD_SUPPLIER_L UNION ALL SELECT FPKID, FCUSTID fitemid, FLOCALEID, FNAME fname, FDESCRIPTION fdescription, 'BD_Customer' fformidFROM T_BD_CUSTOMER_L UNION ALL SELECT FPKID, FDEPTID fitemid, FLOCALEID, FNAME fname, FDESCRIPTION fdescription, 'BD_Department' fformid FROM T_BD_DEPARTMENT_L UNION ALL SELECT FPKID, FID fitemid, FLOCALEID, FNAME fname, FDESCRIPTION fdescription, 'BD_Empinfo' fformid FROM T_HR_EMPINFO_L UNION ALL SELECT FPKID, FID fitemid, FLOCALEID, FNAME fname, FDESCRIPTION fdescription, 'FIN_OTHERS' fformid FROM T_FIN_OTHERS_L UNION ALL SELECT FPKID, FORGID fitemid, FLOCALEID, FNAME fname, FDESCRIPTION fdescription, 'ORG_Organizations' fformid FROM T_ORG_ORGANIZATIONS_L UNION ALL SELECT FPKID, FBANKID fitemid, FLOCALEID, FNAME fname, FDESCRIPTION fdescription, 'BD_BANK' fformid FROM T_BD_BANK_L UNION all SELECT FPKID, FCATEGORYID fitemid, FLOCALEID, FNAME fname, '投资单位' fdescription, 'cyh_t_Cust100008_L' fformid FROM cyh_t_Cust100008_L GO
为什么修正之后,过一段时间又不行了,又恢复到原来样子了,反反复复这样修正呢
怎末用
thanks for sharing! 值得收藏
学习收藏了
应收账龄分析表打开报错,提示:列名 'FCorrespondOrgId' 无效
解决方案:视图缺失字段所致,需要在数据库中重建视图 V_FIN_CONTACTTYPE 以及 V_FIN_CONTACTTYPE_L,相关执行脚本如下:ALTER VIEW [dbo].[...
点击下载文档
本文2024-09-16 17:38:07发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-16968.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章