[dbo].[ClaimItemDueFromCustomer

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
ClaimItemDueFromID
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 StorageAlternateCustomer_Synonym.
* StorageAlternateCustomer_Synonym will either point to this view or to
* StorageAlternateCustomer_Legacy otherwise.
*/
create view [dbo].[ClaimItemDueFromCustomer_XLedger]
(
    -- Join to ClaimItemDueFrom.ClaimItemDueFromID
    ClaimItemDueFromID,
    -- Join to CustomerAddressInformation_Synonym( or CustomerAddressInformation_Synonym).CustomerJoinField
    CustomerJoinField
)
as
select
    ClaimItemDueFromID = ClaimItemDueFrom.ClaimItemDueFromID,
    CustomerJoinField = ClaimItemDueFrom.AccountingCustomerFid
from ClaimItemDueFrom
GO
GRANT SELECT ON  [dbo].[ClaimItemDueFromCustomer_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimItemDueFromCustomer_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimItemDueFromCustomer_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimItemDueFromCustomer_XLedger] TO [MssExec]
GO