Views [dbo].[ClaimHandlingExpenseVendor_Legacy]
BUILD09 > MoversSuite2 > Views > dbo.ClaimHandlingExpenseVendor_Legacy
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created6:57:27 AM Friday, September 12, 2025
Last Modified6:57:27 AM Friday, September 12, 2025
Columns
Name
VendorJoinField
ClaimHandlingExpenseID
ClaimHandlingTypeFID
ClaimFID
Amount
HandledDate
VendorNumber
PONumber
InvoiceNumber
BranchFID
DivisionFID
Description
DocDate
JournalDate
PostedDate
PostedBySysuserFID
1099Flag
DocumentNumber
AccountingVendorFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
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 ClaimHandlingExpenseVendor_XLedger if XLedger is being used.
* Otherwise, it will point to this view (ClaimHandlingExpenseVendor_Legacy).
*/
create view [dbo].[ClaimHandlingExpenseVendor_Legacy]
as
select
    VendorJoinField = ClaimHandlingExpense.VendorNumber,
    ClaimHandlingExpense.*
from ClaimHandlingExpense
GO
GRANT SELECT ON  [dbo].[ClaimHandlingExpenseVendor_Legacy] TO [MssExec]
GRANT INSERT ON  [dbo].[ClaimHandlingExpenseVendor_Legacy] TO [MssExec]
GRANT DELETE ON  [dbo].[ClaimHandlingExpenseVendor_Legacy] TO [MssExec]
GRANT UPDATE ON  [dbo].[ClaimHandlingExpenseVendor_Legacy] TO [MssExec]
GO
Uses
Used By
Created 12 September 2025 07:19
Copyright  2025 - All Rights Reserved