[dbo].[LookupAccountingCustomerIdByCustomerNumber]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.LookupAccountingCustomerIdByCustomerNumber

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)	Direction
@inCustomerNumber	varchar(15)	15
@outAccountingCustomerId	int	4	Out

Type	Action	Owning Principal
Grant	Execute	MssExec

/**
*    Looks up the AccountingCustomerId for the specified CustomerNumber.
*
*    Parameters:
*    @inCustomerNumber - the customer number
*    @outAccountingCustomerId - the returned AccountingCustomerId, if found.
*/
CREATE PROCEDURE [dbo].[LookupAccountingCustomerIdByCustomerNumber]
    @inCustomerNumber varchar(15),
    @outAccountingCustomerId int output
as
set nocount on

set @outAccountingCustomerId = null

if( isnull( @inCustomerNumber, '' ) != '' )
begin
    select
        @outAccountingCustomerId = AccountingCustomerId
    from AccountingCustomer
    where CustomerNumber = @inCustomerNumber
end
GO
GRANT EXECUTE ON  [dbo].[LookupAccountingCustomerIdByCustomerNumber] TO [MssExec]
GO