/**
* 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].[StorageAlternateCustomer_XLedger]
(
    -- Join to Storage.StoragePriKey
    StoragePriKey,
    -- Join to CustomerAddressInformation_Synonym( or CustomerAddressInformation_Synonym).CustomerJoinField
    CustomerJoinField,
    -- Join to CustomerAddressInformation_Synonym.CustomerAddressJoinField (along with CustomerJoinField)
    CustomerAddressJoinField
)
as
select
    StoragePriKey = Storage.StoragePriKey,
    CustomerJoinField = Storage.AlternateAccountingCustomerFid,
    CustomerJoinField = Storage.AlternateAccountingCustomerAddressFid
from Storage
GO
GRANT SELECT ON  [dbo].[StorageAlternateCustomer_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[StorageAlternateCustomer_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[StorageAlternateCustomer_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[StorageAlternateCustomer_XLedger] TO [MssExec]
GO