/**
* This view gets vendors from Microsoft GP.
* To get vendors from XLedger, see the Vendor_XLedger view.
*/
create view [dbo].[Vendor_Legacy]
(
    [Name],
    VendorID,
    Contact,
    [Address1],
    [Address2],
    [Address3],
    City,
    [State],
    PostalCode,
    CountryName,
    [Status],
    Hold,
    VendorStatus,
    AccountingVendorId,
    AccountingVendorAddressId,
    VendorJoinField,
    Ten99Type,
    VendorClass
)
as
select
    Vendor.VENDNAME as [Name],
    Vendor.VENDORID as VendorID,
    isnull( Vendor.VNDCNTCT, '' ) as Contact,
    isnull( Vendor.ADDRESS1, '' ) as [Address1],
    isnull( Vendor.ADDRESS2, '' ) as [Address2],
    isnull( Vendor.ADDRESS3, '' ) as [Address3],
    isnull( Vendor.CITY, '' ) as City,
    isnull( Vendor.[STATE], '' ) as [State],
    isnull( Vendor.ZIPCODE, '' ) as PostalCode,
    isnull( Vendor.Country, '' ) as CountryName,
    case Vendor.VendStts
        when 1 then convert( varchar( 9 ), 'Active' )
        when 2 then convert( varchar(9), 'Inactive' )
        when 3 then convert( varchar(9), 'Temporary' )
        else convert( varchar(9), '' )
    end as [Status],
    case Vendor.Hold
        when 1 then convert( varchar(7),'On Hold' )
        else convert( varchar(7), '' )
    end as Hold,
    Vendor.VendStts as VendorStatus,
    AccountingVendorId = convert( int, null ),
    AccountingVendorAddressId = convert( int, null ),
    VendorJoinField = Vendor.VENDORID,
    Vendor.TEN99TYPE as Ten99Type,
    Vendor.VNDCLSID as VendorClass
from PM00200_Synonym as Vendor
GO
GRANT SELECT ON  [dbo].[Vendor_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[Vendor_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[Vendor_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[Vendor_Legacy] TO [MssExec]
GO