[dbo].[CommStmtVendor

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	6:57:31 AM Friday, September 12, 2025
Last Modified	6:57:31 AM Friday, September 12, 2025

Name
VendorJoinField
MSID
CommStmtHeader
VendorID
VendorName
Balance
AccountingVendorFid

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

SQL Script

/**
* Do not use this view directly. Use CommStmtVendor_Synonym instead.
* That synonym should be used to join the CommStmtVendor table to another table when joining on a Vendor identifier.
* That synonym will point to CommStmtVendor_XLedger if XLedger is being used.
* Otherwise, it will point to this view (CommStmtVendor_Legacy).
*/
create view [dbo].[CommStmtVendor_Legacy]
as
select
    VendorJoinField = CommStmtVendor.VendorID,
    CommStmtVendor.*
from CommStmtVendor
GO
GRANT SELECT ON  [dbo].[CommStmtVendor_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[CommStmtVendor_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[CommStmtVendor_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[CommStmtVendor_Legacy] TO [MssExec]
GO