Views [dbo].[InvoicedHeaderCustomer_XLedger]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created7:47:33 PM Saturday, February 7, 2026
Last Modified7:48:55 PM Saturday, February 7, 2026
Columns
Name
IHPriKey
CustomerJoinField
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Don't use this view directly but instead use InvoicedHeaderAlternateCustomer_Synonym.
* InvoicedHeaderCustomer_Synonym will either point to this view or to
* InvoicedHeaderCustomer_Legacy if that is active.
*/

create view [dbo].[InvoicedHeaderCustomer_XLedger]
(
    -- Join to InvoicedHeader.IHPriKey
    IHPriKey,
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField
)
as
select
    IHPriKey = InvoicedHeader.IHPriKey,
    CustomerJoinField = InvoicedHeader.AccountingCustomerFid
from InvoicedHeader
GO
GRANT SELECT ON  [dbo].[InvoicedHeaderCustomer_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[InvoicedHeaderCustomer_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[InvoicedHeaderCustomer_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[InvoicedHeaderCustomer_XLedger] TO [MssExec]
GO
Uses