USP_DATALIST_FINANCIALTRANSACTION1099DISTRIBUTION

CREATE procedure dbo.USP_DATALIST_FINANCIALTRANSACTION1099DISTRIBUTION(
  @FINANCIALTRANSACTIONID uniqueidentifier
)
as
    set nocount on;

    select D.ID,
           (B.BOXNUMBER + ' - ' + B.DESCRIPTION) as [BOXNUMBER1099],
           S.ABBREVIATION 'STATE',
           D.AMOUNT,
       D.[PERCENT]
       ,dbo.UFN_FINANCIALTRANSACTION_PAID(D.FINANCIALTRANSACTIONID) as [PAID]
       ,(select top 1 FTLI.POSTSTATUSCODE 
          from dbo.FINANCIALTRANSACTION FT 
            inner join dbo.FINANCIALTRANSACTIONLINEITEM FTLI 
              on ((FT.ID = FTLI.FINANCIALTRANSACTIONID) 
              and (FTLI.TYPECODE = 0) 
              and (FTLI.DELETEDON is null)) 
           where FT.ID = D.FINANCIALTRANSACTIONID) as [POSTSTATUSCODE]
    from dbo.FINANCIALTRANSACTION1099DISTRIBUTION as D
    left outer join dbo.STATE as S on S.ID = D.STATEID
    left outer join dbo.FINANCIALTRANSACTION1099BOXNUMBER as B on B.ID = D.BOXNUMBER1099ID
    where D.FINANCIALTRANSACTIONID = @FINANCIALTRANSACTIONID
  order by D.SEQUENCE asc