UFN_MKTDOCUMENT_GETVIEW

create function dbo.[UFN_MKTDOCUMENT_GETVIEW]
(
  @DOCUMENTID uniqueidentifier
)
returns table
as  
return (select 
          [MKTDOCUMENT].[NAME] as [NAME],
          [MKTDOCUMENT].[DESCRIPTION] as [DESCRIPTION],
          [MKTDOCUMENT].[SITEID] as [SITEID],
          [MKTDOCUMENT].[COST] as [COST],
          [MKTDOCUMENT].[COSTDISTRIBUTIONMETHODCODE] as [COSTDISTRIBUTIONMETHODCODE],
          [MKTDOCUMENT].[DOCUMENTTYPECODEID] as [DOCUMENTTYPECODEID],
          [MKTDOCUMENT].[FILEURL] as [FILEURL],
          null as [FILE], -- file will be loaded on demand

          [MKTDOCUMENT].[FILENAME] as [FILENAME],
          [MKTDOCUMENT].[BASECURRENCYID] as [BASECURRENCYID],
          dbo.[UFN_CURRENCY_GETDESCRIPTION]([MKTDOCUMENT].[BASECURRENCYID]) as [CURRENCY],
          [MKTDOCUMENTTYPECODE].[DESCRIPTION] as [DOCUMENTTYPE],
          dbo.[UFN_TRANSLATIONFUNCTION_SITE_GETNAME]([MKTDOCUMENT].[SITEID]) as [SITE],
          [MKTDOCUMENT].[COSTDISTRIBUTIONMETHOD] as [COSTDISTRIBUTIONMETHOD]
        from dbo.[MKTDOCUMENT]
        left join [MKTDOCUMENTTYPECODE] on [MKTDOCUMENTTYPECODE].[ID] = [MKTDOCUMENT].[DOCUMENTTYPECODEID]
        where [MKTDOCUMENT].[ID] = @DOCUMENTID);