/*
*    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_Legacy]
    @inVendorID varchar(15),
    @inBranchID int,
    @out1099Flag bit output
as

select
    @out1099Flag = isnull( ( select
            case
                when PM00200.Ten99Type is null then 0
                when PM00200.Ten99Type = 1 then 0
                else 1
            end
    from PM00200_Synonym as PM00200
    where PM00200.VendorID = @inVendorID ), 0 )
GO
GRANT EXECUTE ON  [dbo].[RevenueGetThirdPartyVendor1099Flag_Legacy] TO [MssExec]
GO