[dbo].[RevenueGetThirdPartyVendor1099Flag

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)	Direction
@inVendorID	varchar(15)	15
@inBranchID	int	4
@out1099Flag	bit	1	Out

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/*
*    Creates a stored proc for getting the 1099 flag for a vendor by vendor ID and branch.
*    The stored proc does an index seek no matter which vendor data source is used.
*    The RevenueGetThirdPartyVendor1099Flag_Synonym will be set to use the appropriate stored proc for the current
*    system, based upon if they have XLedger, GP, QuickBooks or no accounting system.
*
*/
create procedure [dbo].[RevenueGetThirdPartyVendor1099Flag_XLedger]
    @inVendorID varchar(15),
    @inBranchID int,
    @out1099Flag bit output
as

select
    @out1099Flag = AccountingVendor.Ten99Type
from AccountingVendor
where AccountingVendor.VendorNumber = @inVendorID
GO
GRANT EXECUTE ON  [dbo].[RevenueGetThirdPartyVendor1099Flag_XLedger] TO [MssExec]
GO