[dbo].[ClaimItemDueFromCustomer

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	6:57:26 AM Friday, September 12, 2025
Last Modified	6:57:26 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 ClaimItemDueFromCustomer_Synonym.
* ClaimItemDueFromCustomer_Synonym will either point to this view or to
* ClaimItemDueFromCustomer_XLedger otherwise.
*/
create view [dbo].[ClaimItemDueFromCustomer_Legacy]
(
    -- Join to ClaimItemDueFrom.ClaimItemDueFromID
    ClaimItemDueFromID,
    -- Join to CustomerAddressInformation_Synonym( or CustomerAddressInformation_Synonym).CustomerJoinField
    CustomerJoinField
)
as
select
    ClaimItemDueFromID = ClaimItemDueFrom.ClaimItemDueFromID,
    CustomerJoinField = ClaimItemDueFrom.CustomerNumber
from ClaimItemDueFrom
GO
GRANT SELECT ON  [dbo].[ClaimItemDueFromCustomer_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimItemDueFromCustomer_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimItemDueFromCustomer_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimItemDueFromCustomer_Legacy] TO [MssExec]
GO