[dbo].[VendorClass

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	9:18:38 AM Wednesday, October 15, 2025
Last Modified	9:18:38 AM Wednesday, October 15, 2025

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