USP_DATALIST_DISCOUNTGLDISTRIBUTION

A datalist of the discount GL distribution for sales order revenue.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            create procedure dbo.USP_DATALIST_DISCOUNTGLDISTRIBUTION(@ID uniqueidentifier)
            as
                set nocount on;

                select 
                    CREDITGLDISTRIBUTION.CREDITITEMID,
                    CREDITGLDISTRIBUTION.REVENUEID,
                    CREDITGLDISTRIBUTION.ID as CREDITGLDISTRIBUTION,
                    CREDITGLDISTRIBUTION.TRANSACTIONTYPE,                        
                    CREDITGLDISTRIBUTION.ACCOUNT,
                    CREDITGLDISTRIBUTION.AMOUNT,
                    CREDITGLDISTRIBUTION.REFERENCE
                from 
                    dbo.CREDITGLDISTRIBUTION
                inner join
                    dbo.CREDITITEM on CREDITGLDISTRIBUTION.CREDITITEMID = CREDITITEM.ID
                inner join 
                    dbo.CREDIT on CREDITITEM.CREDITID = CREDIT.ID
                where 
                    CREDITGLDISTRIBUTION.REVENUEID = @ID
                    and CREDITGLDISTRIBUTION.OUTDATED = 0
                    and CREDIT.TYPECODE = 1
                order by
                    CREDITGLDISTRIBUTION.TRANSACTIONTYPE desc;