[dbo].[CustomerInvoiceReportCustomer

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	9:18:38 AM Wednesday, October 15, 2025
Last Modified	9:18:48 AM Wednesday, October 15, 2025

Name
CustomerInvoiceReportID
CustomerJoinField

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