/**
* Don't use this view directly but instead use the synonym GlAccountInformation_Synonym.
* GlAccountInformation_Synonym will either point to this view or to
* GlAccountInformation_Legacy if that is active.
*/
create view [dbo].[GlAccountInformation_XLedger]
(
    GlAccountJoinField,
    GLNumber,
    AccountingAccountFid,
    [Description]
)
as
select
    GlAccountJoinField = AccountingAccount.AccountingAccountId,
    GLNumber = AccountingAccount.Code,
    AccountingAccountFid = AccountingAccount.AccountingAccountId,
    [Description] = AccountingAccount.[Description]
from AccountingAccount
GO
GRANT SELECT ON  [dbo].[GlAccountInformation_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[GlAccountInformation_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[GlAccountInformation_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[GlAccountInformation_XLedger] TO [MssExec]
GO