辅助资料视图

--辅助资料规格[OA_AUXSPECIFICATION]

--FNUMBER : 辅助资料编码

--FDATAVALUE ：辅助资料名称

IF EXISTS (

SELECT *

FROM sysobjects

WHERE name = 'OA_AUXSPECIFICATION'

)

DROP VIEW OA_AUXSPECIFICATION

GO

CREATE VIEW OA_AUXSPECIFICATION

AS

SELECT a.FNUMBER, b.FDATAVALUE

FROM T_BAS_ASSISTANTDATAENTRY a

LEFT JOIN T_BAS_ASSISTANTDATAENTRY_L b

ON a.FENTRYID = b.FENTRYID

AND b.FLOCALEID = 2052

WHERE a.FID = '5cbfb58966b446' --辅助资料类型内码 规格

AND a.FDOCUMENTSTATUS = 'C'

AND a.FFORBIDSTATUS = 'A'

GO

GRANT SELECT ON OA_AUXSPECIFICATION TO db_oaview