Views [dbo].[ClaimLiabilityVendor_Legacy]
BUILD09 > MoversSuite2 > Views > dbo.ClaimLiabilityVendor_Legacy
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created7:47:19 PM Saturday, February 7, 2026
Last Modified7:48:55 PM Saturday, February 7, 2026
Columns
Name
VendorJoinField
ClaimLiabilityID
ClaimFID
Description
LiablePersonSysUserFID
ThirdPartyFlag
ThirdPartyName
VendorNumber
WarehouseFID
AgentFID
BranchFID
DivisionFID
ClaimChargebackTypeFID
1099Flag
LaborTypeFID
AccountingVendorFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Do not use this view directly. Use ClaimLiabilityVendor_Synonym instead.
* That synonym should be used to join the ClaimLiability table to another table when joining on a Vendor identifier.
* That synonym will point to ClaimLiabilityVendor_XLedger if XLedger is being used.
* Otherwise, it will point to this view (ClaimLiabilityVendor_Legacy).
*/
create view [dbo].[ClaimLiabilityVendor_Legacy]
as
select
    VendorJoinField = ClaimLiability.VendorNumber,
    ClaimLiability.*
from ClaimLiability
GO
GRANT SELECT ON  [dbo].[ClaimLiabilityVendor_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimLiabilityVendor_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimLiabilityVendor_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimLiabilityVendor_Legacy] TO [MssExec]
GO
Uses
Used By
Created 09 February 2026 07:28
Copyright  2026 - All Rights Reserved