
[dbo].[VendorPhoneNumbers_XLedger]
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