/**
* Do NOT access this view by this view name.  Instead, use the CustomerPhoneNumbers_Synonym which will either
* point to this view or to the CustomerPhoneNumbers_XLedger as appropriate for that system.
*
* IMPORTANT -- READ ON
* ====================
* This view MUST return the same named columns and data types and in the same order as the
* CustomerPhoneNumbers_XLedger view, which is why they can be hot swapped when XLedger is
* activated/deactivated.
*/
create view [dbo].[CustomerPhoneNumbers_Legacy]
(
    CustomerJoinField,
    PhoneNumber1,
    PhoneNumber2,
    PhoneNumber3,
    Fax
)
as
select
    CustomerJoinField = RM00101.CUSTNMBR,
    PhoneNumber1 = dbo.FormatGreatPlainsPhoneNumber( RM00101.PHONE1 ),
    PhoneNumber2 = dbo.FormatGreatPlainsPhoneNumber( RM00101.PHONE2 ),
    PhoneNumber3 = dbo.FormatGreatPlainsPhoneNumber( RM00101.PHONE3 ),
    Fax = dbo.FormatGreatPlainsPhoneNumber( RM00101.FAX )
from RM00101_Synonym as RM00101
GO
GRANT SELECT ON  [dbo].[CustomerPhoneNumbers_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[CustomerPhoneNumbers_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[CustomerPhoneNumbers_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[CustomerPhoneNumbers_Legacy] TO [MssExec]
GO