/**
* Don't use this view directly but instead use OrdersCustomer_Synonym.
* OrdersCustomer_Synonym will either point to this view or to
* OrdersCustomer_XLedger if that is active.
*/
create view [dbo].[OrdersCustomer_Legacy]
(
    -- Join to Orders.PriKey
    PriKey,
    -- Join to CustomerInformation_Synonym.CustomerJoinField
    CustomerJoinField,
    -- Join to CustomerAddressInformation_Synonym.CustomerAddressJoinField (along with CustomerJoinField)
    CustomerAddressJoinField
)
as
select
    PriKey = Orders.PriKey,
    CustomerJoinField = Orders.CustomerNumber,
    -- Orders.CustomerAddressCode is NULL (not '') when not specified and you can't join on a NULL!!
    CustomerAddressJoinField = isnull( Orders.CustomerAddressCode, '' )
from Orders
GO
GRANT SELECT ON  [dbo].[OrdersCustomer_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[OrdersCustomer_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[OrdersCustomer_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[OrdersCustomer_Legacy] TO [MssExec]
GO