[dbo].[CustomerPrimaryContact

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

Name
CustomerJoinField
Contact

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

SQL Script

/**
* Do NOT access this view by this view name.  Instead, use the CustomerPrimaryContact_Synonym which will either
* point to this view or to the CustomerPrimaryContact_Legacy as appropriate for that system.
*/
create view [dbo].[CustomerPrimaryContact_XLedger]
(
    CustomerJoinField,
    Contact
)
as
select
    CustomerJoinField = AccountingCustomer.AccountingCustomerId,
    Contact = AccountingCustomer.Contact
from AccountingCustomer
GO
GRANT SELECT ON  [dbo].[CustomerPrimaryContact_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[CustomerPrimaryContact_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[CustomerPrimaryContact_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[CustomerPrimaryContact_XLedger] TO [MssExec]
GO