UFN_WPSECURITIES_TRANSACTIONS

Gets a table of transactions for a given WPSECURITIES ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@WPSECURITIESID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_WPSECURITIES_TRANSACTIONS(@WPSECURITIESID uniqueidentifier) 
            returns table
            as return
                select
                    ID,
                    AMOUNT,
                    DATEFROM,
                    DATETO,
                    BB_PRICE,
                    AMOUNTTYPE,
                    TRANSDESC,
                    TRANSVALUE,
                    BB_TRANSVALUE,
                    TRANSTYPE
                from
                    dbo.WPSECURITIESTRANSACTION
                where
                    WPSECURITIESID=@WPSECURITIESID