[dbo].[CustomerEmailInformation

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	7:47:33 PM Saturday, February 7, 2026
Last Modified	7:48:55 PM Saturday, February 7, 2026

Name
CustomerJoinField
Email

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

/**
* Don't use this view directly but instead use CustomerEmailInformation_Synonym.
* CustomerEmailInformation_Synonym will either point to this view or to
* CustomerEmailInformation_Legacy if that is active.
*/
create view [dbo].[CustomerEmailInformation_XLedger]
/*(
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)*/
as
select
    CustomerJoinField = AccountingCustomer.AccountingCustomerId,
    Email = ltrim( rtrim( AccountingCustomer.Email ) )
from AccountingCustomer
GO
GRANT SELECT ON  [dbo].[CustomerEmailInformation_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[CustomerEmailInformation_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[CustomerEmailInformation_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[CustomerEmailInformation_XLedger] TO [MssExec]
GO