Views [dbo].[ClaimLiabilityVendor_XLedger]
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
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 this view (ClaimLiabilityVendor_XLedger) if XLedger is being used.
* Otherwise, it will point to ClaimLiabilityVendor_Legacy.
*/

create view [dbo].[ClaimLiabilityVendor_XLedger]
as
select
    VendorJoinField = ClaimLiability.AccountingVendorFid,
    ClaimLiability.*
from ClaimLiability
GO
GRANT SELECT ON  [dbo].[ClaimLiabilityVendor_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimLiabilityVendor_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimLiabilityVendor_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimLiabilityVendor_XLedger] TO [MssExec]
GO
Uses