UFN_REVENUE_GETSTOCKSALEGLDISTRIBUTION

Gets a table of sold stock GL distribution (Actual or Projected).
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@STOCKSALEID	uniqueidentifier	IN
Definition

Copy


            CREATE function dbo.UFN_REVENUE_GETSTOCKSALEGLDISTRIBUTION
            (
                @STOCKSALEID uniqueidentifier
            )
            returns table
            as
            return
                select 
                    STOCKSALEGLDISTRIBUTION.ID, 
                    STOCKSALEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                    STOCKSALEGLDISTRIBUTION.TRANSACTIONTYPECODE, 
                    STOCKSALEGLDISTRIBUTION.TRANSACTIONTYPE as DEBITCREDIT,
                    STOCKSALEGLDISTRIBUTION.ACCOUNT, 
                    STOCKSALEGLDISTRIBUTION.PROJECT, 
                    STOCKSALEGLDISTRIBUTION.AMOUNT, 
                    STOCKSALEGLDISTRIBUTION.REFERENCE,
                    STOCKSALEGLDISTRIBUTION.STOCKSALEID,
                    MAP.DESCRIPTION as MAPPINGTYPE,
                    STOCKSALEGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                    STOCKSALEGLDISTRIBUTION.BASECURRENCYID,
                    STOCKSALEGLDISTRIBUTION.TRANSACTIONAMOUNT,
                    STOCKSALEGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                    STOCKSALEGLDISTRIBUTION.BASEEXCHANGERATEID,
                    STOCKSALEGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID
                from dbo.STOCKSALEGLDISTRIBUTION
                inner join dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on STOCKSALEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                where 
                    STOCKSALEID = @STOCKSALEID
                    and STOCKSALEGLDISTRIBUTION.OUTDATED = 0;