/**
* Don't use this view directly but instead use the synonym GlAccountInformation_Synonym.
* GlAccountInformation_Synonym will either point to this view or to
* GlAccountInformation_XLedger if that is active.
*/
create view [dbo].[GlAccountInformation_Legacy]
(
    GlAccountJoinField,
    GLNumber,
    AccountingAccountFid,
    [Description]
)
as
select
    GlAccountJoinField = GL00105.ACTNUMST,
    GLNumber = GL00105.ACTNUMST,
    AccountingAccountFid = null,
    [Description] = GL00100.ActDescr
from GL00105_Synonym as GL00105
left outer join GL00100_Synonym as GL00100 on GL00105.ActIndx = GL00100.ActIndx
GO
GRANT SELECT ON  [dbo].[GlAccountInformation_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[GlAccountInformation_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[GlAccountInformation_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[GlAccountInformation_Legacy] TO [MssExec]
GO