Views [dbo].[QuoteDetailVendor_Legacy]
BUILD09 > MoversSuite2 > Views > dbo.QuoteDetailVendor_Legacy
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created3:09:18 PM Tuesday, June 24, 2025
Last Modified3:09:18 PM Tuesday, June 24, 2025
Columns
Name
VendorJoinField
QuoteDetailID
QuoteGroupFID
ItemCodeFID
RateTypeFID
Description
Rate
Quantity
Quantity2
Charge
QuoteServiceProviderTypeFID
VendorID
VendorQuotedCharge
VendorActualCharge
Hidden
SortOrder
PONumber
InvoiceNumber
ServiceDate
NoteText
LaborRatingTypeFID
QuoteServiceProviderBillToFID
RateSource
RateSourceRecord
CurrentRowVersion
ExternalVendorID
ExternalVendorName
IsLocked
AccountingVendorFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Do not use this view directly. Use QuoteDetailVendor_Synonym instead.
* That synonym should be used to join the QuoteDetail table to another table when joining on a Vendor identifier.
* That synonym will point to QuoteDetailVendor_XLedger if XLedger is being used.
* Otherwise, it will point to this view (QuoteDetailVendor_Legacy).
*/
create view [dbo].[QuoteDetailVendor_Legacy]
as
select
    VendorJoinField = QuoteDetail.VendorID,
    QuoteDetail.*
from QuoteDetail
GO
GRANT SELECT ON  [dbo].[QuoteDetailVendor_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[QuoteDetailVendor_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[QuoteDetailVendor_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[QuoteDetailVendor_Legacy] TO [MssExec]
GO
Uses
Used By
Created 24 June 2025 15:32
Copyright  2025 - All Rights Reserved