/**
* This view gets vendor classes from the non-XLedger accounting system (usually GP).
* To get vendor classes from XLedger, see the VendorClass_XLedger view.
*/
create view [dbo].[VendorClass_Legacy]
(
    Code,
    [Description],
    AccountingVendorClassId,
    VendorClassJoinField
)
as
select
    VendorClass.VNDCLSID as Code,
    VendorClass.VNDCLDSC as [Description],
    convert( int, null ) as AccountingVendorClassId,
    VendorClass.VNDCLSID as VendorClassJoinField
from PM00100_Synonym as VendorClass
GO
GRANT SELECT ON  [dbo].[VendorClass_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[VendorClass_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[VendorClass_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[VendorClass_Legacy] TO [MssExec]
GO