/*
* Do not access this view by this view name.  Instead, use the VendorPhoneNumbers_Synonym which will either
* point to this view or to the VendorPhoneNumbers_XLedger as appropriate for that system.
*/
create view [dbo].[VendorPhoneNumbers_Legacy]
(
    VendorJoinField,
    Phone,
    Fax
)
as
select
    VendorJoinField =PM00200.VENDORID,
    Phone =
        case
            when rtrim( isnull( PM00200.PHNUMBR1, '' ) ) in ( '1', '' ) then null
            else PM00200.PHNUMBR1
        end,
    Fax =
        case
            when rtrim( isnull( PM00200.FAXNUMBR, '' ) ) in ( '1', '' ) then null
            else PM00200.FAXNUMBR
        end
from PM00200_Synonym as PM00200
GO
GRANT SELECT ON  [dbo].[VendorPhoneNumbers_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[VendorPhoneNumbers_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[VendorPhoneNumbers_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[VendorPhoneNumbers_Legacy] TO [MssExec]
GO