create procedure dbo.MssWebGetAccountingCustomerLookupItem
    @inAccountingCustomerId int
as
begin
    set nocount on;

    select
        Id = AccountingCustomer.AccountingCustomerId,
        CustomerName = AccountingCustomer.Name,
        CustomerNumber = AccountingCustomer.CustomerNumber
    from
        AccountingCustomer
    where
        AccountingCustomer.AccountingCustomerId = @inAccountingCustomerId
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetAccountingCustomerLookupItem] TO [MssExec]
GO