USP_DATALIST_BILLINGINDIVIDUALACTIVITY

Shows billing activity for a given individual.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@TYPECODE	tinyint	IN	Type
@STATUSCODE	tinyint	IN	Status
@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_BILLINGINDIVIDUALACTIVITY
                (
                    @CONSTITUENTID uniqueidentifier,
                    @TYPECODE tinyint = 0,
                    @STATUSCODE tinyint = 0,
                    @TRANSACTIONDATERANGECODE tinyint = 0,
                    @TRANSACTIONDATERANGEBILLINGCYCLEID uniqueidentifier = null,
                    @TRANSACTIONDUEDATERANGECODE tinyint = 0,
                    @TRANSACTIONDUEDATERANGEBILLINGCYCLEID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select ID,
                           DATE,
                           DUEDATEDISPLAY,
                           TYPE,
                           TYPECODE,
                           DESCRIPTION,
                           AMOUNT,
                           AMOUNTREMAINING,
                           PAIDBY,
                           STATUSCODE,
                           STATUS
                    from dbo.UFN_BILLINGINDIVIDUALACTIVITYDATALIST(@CONSTITUENTID, 
                                                                        @TYPECODE, 
                                                                        @STATUSCODE,
                                                                        @TRANSACTIONDATERANGECODE,
                                                                        @TRANSACTIONDATERANGEBILLINGCYCLEID,
                                                                        @TRANSACTIONDUEDATERANGECODE,
                                                                        @TRANSACTIONDUEDATERANGEBILLINGCYCLEID);