Scalar-valued Functions [dbo].[GetAccountingVendorId_Legacy]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inVendorIdvarchar(15)15
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
/*
*    Gets a null value.
*    The GetAccountingVendorId_Synonym will be set to use the appropriate function for the current
*    system, based upon if they have XLedger, GP, QuickBooks or no accounting system.
* Since this function is only used when the accounting system is not XLedger, there will be no Accounting Vendor data, so we just return null.
*/

create function [dbo].[GetAccountingVendorId_Legacy]( @inVendorId varchar(15) )
returns int
as
begin
    return null
end
GO
GRANT EXECUTE ON  [dbo].[GetAccountingVendorId_Legacy] TO [MssExec]
GO
Uses
Used By