[dbo].[TemporaryVendor

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

Name
VendorJoinField
TemporaryVendorID
VendorNumber
VendorName
Address1
Address2
Address3
City
State
PostalCode
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 TemporaryVendor_Synonym instead.
* That synonym should be used to join the TemporaryVendor table to another table when joining on a Vendor identifier.
* That synonym will point to TemporaryVendor_XLedger if XLedger is being used.
* Otherwise, it will point to this view (TemporaryVendor_Legacy).
*/
create view [dbo].[TemporaryVendor_Legacy]
as
select
    VendorJoinField = TemporaryVendor.VendorNumber,
    TemporaryVendor.*
from TemporaryVendor
GO
GRANT SELECT ON  [dbo].[TemporaryVendor_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[TemporaryVendor_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[TemporaryVendor_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[TemporaryVendor_Legacy] TO [MssExec]
GO