USP_DATALIST_BILLINGINDIVIDUALACTIVITYBALANCEFORWARD

Shows billing activity for a given individual in a balance forward system.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@TYPECODE	tinyint	IN	Type
@TRANSACTIONDATERANGECODE	tinyint	IN	Transaction date range
@TRANSACTIONDATERANGEBILLINGCYCLEID	uniqueidentifier	IN
@TRANSACTIONDUEDATERANGECODE	tinyint	IN	Due date range
@TRANSACTIONDUEDATERANGEBILLINGCYCLEID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_BILLINGINDIVIDUALACTIVITYBALANCEFORWARD
                (
                    @CONSTITUENTID uniqueidentifier,
                    @TYPECODE tinyint = 0,
                    @TRANSACTIONDATERANGECODE tinyint = 0,
                    @TRANSACTIONDATERANGEBILLINGCYCLEID uniqueidentifier = null,
                    @TRANSACTIONDUEDATERANGECODE tinyint = 0,
                    @TRANSACTIONDUEDATERANGEBILLINGCYCLEID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select ID,
                           DATE,
                           DUEDATE,
                           TYPE,
                           TYPECODE,
                           DESCRIPTION,
                           AMOUNT,
                           PAIDBY
                    from dbo.UFN_BILLINGINDIVIDUALACTIVITYDATALIST(@CONSTITUENTID, 
                                                                        @TYPECODE, 
                                                                        0, -- All Status

                                                                        @TRANSACTIONDATERANGECODE,
                                                                        @TRANSACTIONDATERANGEBILLINGCYCLEID,
                                                                        @TRANSACTIONDUEDATERANGECODE,
                                                                        @TRANSACTIONDUEDATERANGEBILLINGCYCLEID);