/**
* Don't use this view directly but instead use BillingMinorItemAlternateCustomer_Synonym.
* BillingMinorItemAlternateCustomer_Synonym will either point to this view or to
* BillingMinorItemAlternateCustomer_XLedger if that is active.
*/
create view [dbo].[BillingMinorItemAlternateCustomer_Legacy]
(
    -- Join to BillingMinorItem.BMinPriKey
    BMinPriKey,
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField,
    -- Join to CustomerAddressInformation_Synonym.CustomerAddressJoinField (along with CustomerJoinField)
    CustomerAddressJoinField
)
as
select
    BMinPriKey = BillingMinorItem.BMinPriKey,
    CustomerJoinField = BillingMinorItem.AlternateCustomerNumber,
    CustomerAddressJoinField = BillingMinorItem.AlternateCustomerAddressCode
from BillingMinorItem
GO
GRANT SELECT ON  [dbo].[BillingMinorItemAlternateCustomer_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[BillingMinorItemAlternateCustomer_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[BillingMinorItemAlternateCustomer_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[BillingMinorItemAlternateCustomer_Legacy] TO [MssExec]
GO