Views [dbo].[ThirdPartyVendor_Legacy]
BUILD09 > MoversSuite2 > Views > dbo.ThirdPartyVendor_Legacy
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created9:18:37 AM Wednesday, October 15, 2025
Last Modified9:18:37 AM Wednesday, October 15, 2025
Columns
Name
VendorJoinField
TPPriKey
BMinPriKey
BMinDistPriKey
VendorID
PayableAmount
InvoiceNumber
PONumber
ANPriKey
Description
DocDate
JournalDate
PostedDate
PostedBy
ApplyToDoc
InvoiceDate
1099Flag
OnHoldFlag
DocumentNumber
OriginalInvoiceNumber
AccountingVendorFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Do not use this view directly. Use ThirdPartyVendor_Synonym instead.
* That synonym should be used to join the ThirdParty table to another table when joining on a Vendor identifier.
* That synonym will point to ThirdPartyVendor_XLedger if XLedger is being used.
* Otherwise, it will point to this view (ThirdPartyVendor_Legacy).
*/
create view [dbo].[ThirdPartyVendor_Legacy]
as
select
    VendorJoinField = ThirdParty.VendorID,
    ThirdParty.*
from ThirdParty
GO
GRANT SELECT ON  [dbo].[ThirdPartyVendor_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[ThirdPartyVendor_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[ThirdPartyVendor_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[ThirdPartyVendor_Legacy] TO [MssExec]
GO
Uses
Used By
Created 15 October 2025 11:23
Copyright  2025 - All Rights Reserved