[dbo].[AdvanceBankingServiceProviderVendor

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	6:57:28 AM Friday, September 12, 2025
Last Modified	6:57:28 AM Friday, September 12, 2025

Name
VendorJoinField
AdvanceBankingServiceProviderID
VendorID
GenerateTransactionsFlag
AdvanceBankingServiceProviderTypeFID
FTPGenerateUploadFileFlag
FTPAutoUploadFlag
FTPUserName
FTPPassword
FTPHost
FTPPort
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 AdvanceBankingServiceProviderVendor_Synonym instead.
* That synonym should be used to join the AdvanceBankingServiceProvider table to another table when joining on a Vendor identifier.
* That synonym will point to this view (AdvanceBankingServiceProviderVendor_XLedger) if XLedger is being used.
* Otherwise, it will point to AdvanceBankingServiceProviderVendor_Legacy.
*/
create view [dbo].[AdvanceBankingServiceProviderVendor_XLedger]
as
select
    VendorJoinField = AdvanceBankingServiceProvider.AccountingVendorFid,
    AdvanceBankingServiceProvider.*
from AdvanceBankingServiceProvider
GO
GRANT SELECT ON  [dbo].[AdvanceBankingServiceProviderVendor_XLedger] TO [MssExec]
GRANT INSERT ON  [dbo].[AdvanceBankingServiceProviderVendor_XLedger] TO [MssExec]
GRANT DELETE ON  [dbo].[AdvanceBankingServiceProviderVendor_XLedger] TO [MssExec]
GRANT UPDATE ON  [dbo].[AdvanceBankingServiceProviderVendor_XLedger] TO [MssExec]
GO