[dbo].[ClaimHandlingRevenueCustomer

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	6:57:31 AM Friday, September 12, 2025
Last Modified	6:57:31 AM Friday, September 12, 2025

Name
ClaimHandlingRevenueID
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 ClaimHandlingRevenueCustomer_Synonym.
* ClaimHandlingRevenueCustomer_Synonym will either point to this view or to
* ClaimHandlingRevenueCustomer_Legacy otherwise.
*/
create view [dbo].[ClaimHandlingRevenueCustomer_XLedger]
(
    -- Join to ClaimHandlingRevenue.ClaimHandlingRevenueID
    ClaimHandlingRevenueID,
    -- Join to CustomerAddressInformation_Synonym( or CustomerAddressInformation_Synonym).CustomerJoinField
    CustomerJoinField
)
as
select
    ClaimHandlingRevenueID = ClaimHandlingRevenue.ClaimHandlingRevenueID,
    CustomerJoinField = ClaimHandlingRevenue.AccountingCustomerFid
from ClaimHandlingRevenue
GO
GRANT SELECT ON  [dbo].[ClaimHandlingRevenueCustomer_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimHandlingRevenueCustomer_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimHandlingRevenueCustomer_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimHandlingRevenueCustomer_XLedger] TO [MssExec]
GO