USP_SIMPLEDATALIST_1099BOXCODE
The simple list of 1099 Box numbers
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_1099BOXCODE as
select
ID as VALUE,
(BOXNUMBER + ' - ' + DESCRIPTION) as LABEL
from dbo.FINANCIALTRANSACTION1099BOXNUMBER
where ISDROPDOWNITEM = 1
order by SEQUENCE