Views [dbo].[VendorPhoneNumbers_XLedger]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created7:47:19 PM Saturday, February 7, 2026
Last Modified7:47:19 PM Saturday, February 7, 2026
Columns
Name
VendorJoinField
Phone
Fax
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/*
* Do not access this view by this view name.  Instead, use the VendorPhoneNumbers_Synonym which will either
* point to this view or to the VendorPhoneNumbers_Legacy as appropriate for that system.
*/

create view [dbo].[VendorPhoneNumbers_XLedger]
(
    VendorJoinField,
    Phone,
    Fax
)
as
select
    VendorJoinField = AccountingVendor.AccountingVendorId,
    Phone = AccountingVendor.Phone,
    Fax = AccountingVendor.Fax
from AccountingVendor
GO
GRANT SELECT ON  [dbo].[VendorPhoneNumbers_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[VendorPhoneNumbers_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[VendorPhoneNumbers_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[VendorPhoneNumbers_XLedger] TO [MssExec]
GO
Uses