UFN_REVENUE_GETSTOCKDETAILGLDISTRIBUTION

            CREATE function dbo.UFN_REVENUE_GETSTOCKDETAILGLDISTRIBUTION(@STOCKDETAILID uniqueidentifier) 
            returns @STOCKDETAILGLDISTRIBUTION table
            (
                ID uniqueidentifier null,
                GLPAYMENTMETHODREVENUETYPEMAPPINGID uniqueidentifier not null,
                TRANSACTIONTYPECODE tinyint not null,
                DEBITCREDIT nvarchar(50) not null,
                ACCOUNT nvarchar(100) not null,
                PROJECT nvarchar(100) null,
                AMOUNT money not null,
                REFERENCE nvarchar(255) not null,
                STOCKSALEID uniqueidentifier not null,
                ORGANIZATIONAMOUNT money not null,
                BASECURRENCYID uniqueidentifier,
                TRANSACTIONAMOUNT money not null,
                TRANSACTIONCURRENCYID uniqueidentifier,
                BASEEXCHANGERATEID uniqueidentifier,
                ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )
            as 
            begin    
                insert into @STOCKDETAILGLDISTRIBUTION 
                    (ID, GLPAYMENTMETHODREVENUETYPEMAPPINGID, TRANSACTIONTYPECODE, DEBITCREDIT, ACCOUNT, PROJECT, AMOUNT, REFERENCE, STOCKSALEID, ORGANIZATIONAMOUNT, BASECURRENCYID, TRANSACTIONAMOUNT, TRANSACTIONCURRENCYID,    BASEEXCHANGERATEID,    ORGANIZATIONEXCHANGERATEID)
                    select 
                        STOCKSALEGLDISTRIBUTION.ID, 
                        STOCKSALEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                        STOCKSALEGLDISTRIBUTION.TRANSACTIONTYPECODE, 
                        STOCKSALEGLDISTRIBUTION.TRANSACTIONTYPE as DEBITCREDIT, 
                        STOCKSALEGLDISTRIBUTION.ACCOUNT, 
                        STOCKSALEGLDISTRIBUTION.PROJECT, 
                        STOCKSALEGLDISTRIBUTION.AMOUNT, 
                        STOCKSALEGLDISTRIBUTION.REFERENCE,
                        STOCKSALEGLDISTRIBUTION.STOCKSALEID,
                        STOCKSALEGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                        STOCKSALEGLDISTRIBUTION.BASECURRENCYID,
                        STOCKSALEGLDISTRIBUTION.TRANSACTIONAMOUNT,
                        STOCKSALEGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        STOCKSALEGLDISTRIBUTION.BASEEXCHANGERATEID,
                        STOCKSALEGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID
                    from 
                        dbo.STOCKSALEGLDISTRIBUTION
                    inner join
                        dbo.STOCKSALE on STOCKSALEGLDISTRIBUTION.STOCKSALEID = STOCKSALE.ID
                    where 
                        STOCKSALE.STOCKDETAILID = @STOCKDETAILID
                        and STOCKSALEGLDISTRIBUTION.OUTDATED = 0;
                return
            end