USP_DATALIST_TREASURYDEPOSITPROCESS

            CREATE procedure dbo.USP_DATALIST_TREASURYDEPOSITPROCESS
            as
                set nocount on;

                select
                    SDP.ID,
          SDP.NAME,
          SDP.DESCRIPTION,
          PD.NAME as ACCOUNTSYSTEMNAME,
          SDP.PAYMENTDATEOPTION,
          case SDP.DEPOSITDATEOPTIONCODE
            when 0 then 'Payment date'
            else SDP.DEPOSITDATEOPTION
          end as DEPOSITDATEOPTION
                from dbo.[SALESDEPOSITPROCESS] SDP
          inner join dbo.[PDACCOUNTSYSTEM] PD on PD.ID = SDP.PDACCOUNTSYSTEMID