[dbo].[OrderThirdPartysVendor

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	3:09:18 PM Tuesday, June 24, 2025
Last Modified	3:09:18 PM Tuesday, June 24, 2025

Name
VendorJoinField
OrdThirdPartyPriKey
OrdPriKey
VendorID
Amount
PONumber
InvoiceNumber
Description
Date
InvoiceReceivedDate
InvoiceApprovedDate
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 OrderThirdPartysVendor_Synonym instead.
* That synonym should be used to join the OrderThirdPartys table to another table when joining on a Vendor identifier.
* That synonym will point to this view (OrderThirdPartysVendor_XLedger) if XLedger is being used.
* Otherwise, it will point to OrderThirdPartysVendor_Legacy.
*/
create view [dbo].[OrderThirdPartysVendor_XLedger]
as
select
    VendorJoinField = OrderThirdPartys.AccountingVendorFid,
    OrderThirdPartys.*
from OrderThirdPartys
GO
GRANT SELECT ON  [dbo].[OrderThirdPartysVendor_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[OrderThirdPartysVendor_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[OrderThirdPartysVendor_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[OrderThirdPartysVendor_XLedger] TO [MssExec]
GO