[dbo].[ARCCustomerInformationCustomer

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	3:09:14 PM Tuesday, June 24, 2025
Last Modified	3:09:14 PM Tuesday, June 24, 2025

Name
CustomerJoinField
CustomerNumber
CollectorSysuserFID
ARCAlertGroupFID
AccountingCustomerFid

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 ARCCustomerInformationCustomer_Synonym.
* ARCCustomerInformationCustomer_Synonym will either point to this view or to
* ARCCustomerInformationCustomer_XLedger if that is active.
*/
create view [dbo].[ARCCustomerInformationCustomer_Legacy]
/*(
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)*/
as
select
    CustomerJoinField = ARCCustomerInformation.CustomerNumber,
    ARCCustomerInformation.*
from ARCCustomerInformation
GO
GRANT SELECT ON  [dbo].[ARCCustomerInformationCustomer_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[ARCCustomerInformationCustomer_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[ARCCustomerInformationCustomer_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[ARCCustomerInformationCustomer_Legacy] TO [MssExec]
GO