[dbo].[CommStmtVendor

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	9:18:42 AM Wednesday, October 15, 2025
Last Modified	9:18:42 AM Wednesday, October 15, 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 this view (CommStmtVendor_XLedger) if XLedger is being used.
* Otherwise, it will point to CommStmtVendor_Legacy.
*/
create view [dbo].[CommStmtVendor_XLedger]
as
select
    VendorJoinField = CommStmtVendor.AccountingVendorFid,
    CommStmtVendor.*
from CommStmtVendor
GO
GRANT SELECT ON  [dbo].[CommStmtVendor_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[CommStmtVendor_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[CommStmtVendor_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[CommStmtVendor_XLedger] TO [MssExec]
GO