[dbo].[VendorClass

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	7:47:19 PM Saturday, February 7, 2026
Last Modified	7:47:19 PM Saturday, February 7, 2026

Name
Code
Description
AccountingVendorClassId
VendorClassJoinField

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

/**
* This view gets vendor classes from XLedger.
* To get vendor classes from another accounting system, see the VendorClass_Legacy view.
*/
create view [dbo].[VendorClass_XLedger]
(
    Code,
    [Description],
    AccountingVendorClassId,
    VendorClassJoinField
)
as
select
    AccountingVendorClass.ClassCode as Code,
    AccountingVendorClass.ClassDescription as [Description],
    AccountingVendorClass.AccountingVendorClassId,
    AccountingVendorClass.AccountingVendorClassId as VendorClassJoinField
from AccountingVendorClass
GO
GRANT SELECT ON  [dbo].[VendorClass_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[VendorClass_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[VendorClass_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[VendorClass_XLedger] TO [MssExec]
GO