Views [dbo].[SITInformationVendor_XLedger]
BUILD09 > MoversSuite2 > Views > dbo.SITInformationVendor_XLedger
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created6:57:26 AM Friday, September 12, 2025
Last Modified6:57:26 AM Friday, September 12, 2025
Columns
Name
VendorJoinField
SITInformationID
OrdersFID
SITTypeFID
AgentFID
MilitaryCarrierFID
VendorID
Authorization
Days
EstimatedInDate
ActualInDate
EstimatedOutDate
ActualOutDate
SITToPermDate
DrayageMiles
Weight
SITNumRequestedDate
SITNumReturnedDate
SITNumToAgentDate
DPSArrivalDate
ArrivalDate
Overflow
DANotificationDate
TCNotificationDate
OrderAuditInfoFID
OrderAuditInfoManualCleanup
AccountingVendorFid
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
/**
* Do not use this view directly. Use SITInformationVendor_Synonym instead.
* That synonym should be used to join the SITInformation table to another table when joining on a Vendor identifier.
* That synonym will point to this view (SITInformationVendor_XLedger) if XLedger is being used.
* Otherwise, it will point to SITInformationVendor_Legacy.
*/
create view [dbo].[SITInformationVendor_XLedger]
as
select
    VendorJoinField = SITInformation.AccountingVendorFid,
    SITInformation.*
from SITInformation
GO
GRANT SELECT ON  [dbo].[SITInformationVendor_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[SITInformationVendor_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[SITInformationVendor_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[SITInformationVendor_XLedger] TO [MssExec]
GO
Uses
Created 12 September 2025 07:19
Copyright  2025 - All Rights Reserved