USP_SIMPLEDATALIST_BANKACCOUNTADJUSTMENTTRANSFERACCOUNT
This provides a simple list of bank accounts.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACCOUNTID | uniqueidentifier | IN | Account ID |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_BANKACCOUNTADJUSTMENTTRANSFERACCOUNT
(
@ACCOUNTID as uniqueidentifier = null
) as
set nocount on;
select
ID as VALUE,
ACCOUNTNAME as LABEL
from dbo.BANKACCOUNT
where ID <> @ACCOUNTID
order by ACCOUNTNAME