UFN_RE7INTEGRATION_GETAVAILABLEFIELDS

            create function dbo.UFN_RE7INTEGRATION_GETAVAILABLEFIELDS(@DIRECTIONCODE tinyint)
            returns table
            as
                return
                (
          select 
              RE7INTEGRATIONAVAILABLEFIELD.ID, 
              RE7INTEGRATIONAVAILABLEFIELD.NAME,
              RE7INTEGRATIONAVAILABLEFIELD.DESCRIPTION,
              case when RE7INTEGRATIONSELECTEDFIELD.ID is null 
                  then 'False' 
                  else 'True' 
              end as SELECTED
          from 
              RE7INTEGRATIONAVAILABLEFIELD
          left join RE7INTEGRATIONSELECTEDFIELD
              on RE7INTEGRATIONAVAILABLEFIELD.ID = RE7INTEGRATIONSELECTEDFIELD.ID
          where RE7INTEGRATIONAVAILABLEFIELD.DIRECTIONCODE = @DIRECTIONCODE
                );