[dbo].[ClaimHandlingExpenseVendor

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	7:47:32 PM Saturday, February 7, 2026
Last Modified	7:48:55 PM Saturday, February 7, 2026

Name
VendorJoinField
ClaimHandlingExpenseID
ClaimHandlingTypeFID
ClaimFID
Amount
HandledDate
VendorNumber
PONumber
InvoiceNumber
BranchFID
DivisionFID
Description
DocDate
JournalDate
PostedDate
PostedBySysuserFID
1099Flag
DocumentNumber
AccountingVendorFid

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

/**
* Do not use this view directly. Use ClaimHandlingExpenseVendor_Synonym instead.
* That synonym should be used to join the ClaimHandlingExpense table to another table when joining on a Vendor identifier.
* That synonym will point to this view (ClaimHandlingExpenseVendor_XLedger) if XLedger is being used.
* Otherwise, it will point to ClaimHandlingExpenseVendor_Legacy.
*/
create view [dbo].[ClaimHandlingExpenseVendor_XLedger]
as
select
    VendorJoinField = ClaimHandlingExpense.AccountingVendorFid,
    ClaimHandlingExpense.*
from ClaimHandlingExpense
GO
GRANT SELECT ON  [dbo].[ClaimHandlingExpenseVendor_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimHandlingExpenseVendor_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimHandlingExpenseVendor_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimHandlingExpenseVendor_XLedger] TO [MssExec]
GO