UFN_CONSTITUENTACCOUNT_GETMANDATES

CREATE function dbo.UFN_CONSTITUENTACCOUNT_GETMANDATES(@CONSTITUENTACCOUNTID uniqueidentifier)
returns table
as return
    select
        SEPAMANDATE.ID,
        SEPAMANDATE.SEQUENCEID,
        SEPAMANDATE.LOOKUPID,
        SEPAMANDATE.SIGNATUREDATE,
        SEPAMANDATE.TYPECODE,
        SEPAMANDATE.STATUSCODE
    from
        dbo.SEPAMANDATE
    where
        SEPAMANDATE.CONSTITUENTACCOUNTID = @CONSTITUENTACCOUNTID;