Views [dbo].[ClaimSettlementVendor_Legacy]
BUILD09 > MoversSuite2 > Views > dbo.ClaimSettlementVendor_Legacy
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created7:47:33 PM Saturday, February 7, 2026
Last Modified7:48:55 PM Saturday, February 7, 2026
Columns
Name
VendorJoinField
ClaimSettlementID
ClaimFID
ClaimSettlementTypeFID
VendorNumber
PONumber
InvoiceNumber
AssignedToVendorDate
ShipperDeductibleApplyAmount
1099Flag
Description
InvoiceDate
DocDate
JournalDate
PostedDate
PostedBySysuserFID
DocumentNumber
AccountingVendorFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Do not use this view directly. Use ClaimSettlementVendor_Synonym instead.
* That synonym should be used to join the ClaimSettlement table to another table when joining on a Vendor identifier.
* That synonym will point to ClaimSettlementVendor_XLedger if XLedger is being used.
* Otherwise, it will point to this view (ClaimSettlementVendor_Legacy).
*/
create view [dbo].[ClaimSettlementVendor_Legacy]
as
select
    VendorJoinField = ClaimSettlement.VendorNumber,
    ClaimSettlement.*
from ClaimSettlement
GO
GRANT SELECT ON  [dbo].[ClaimSettlementVendor_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimSettlementVendor_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimSettlementVendor_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimSettlementVendor_Legacy] TO [MssExec]
GO
Uses
Used By
Created 09 February 2026 07:28
Copyright  2026 - All Rights Reserved