[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_XLedger as appropriate for that system.
*/
create view [dbo].[CustomerPrimaryContact_Legacy]
(
    CustomerJoinField,
    Contact
)
as
select
    CustomerJoinField = RM00101.CUSTNMBR,
    Contact = RM00101.CNTCPRSN
from RM00101_Synonym as RM00101
GO
GRANT SELECT ON  [dbo].[CustomerPrimaryContact_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[CustomerPrimaryContact_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[CustomerPrimaryContact_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[CustomerPrimaryContact_Legacy] TO [MssExec]
GO