UFN_REVENUEUPDATEBATCH_GETINSTALLMENTSPLITS

Returns all installment splits for a given installment (only used in revenue update batch)

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEINSTALLMENTID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_REVENUEUPDATEBATCH_GETINSTALLMENTSPLITS(
  @BATCHREVENUEINSTALLMENTID uniqueidentifier
)
returns table as 
return (
          select 
              BATCHREVENUEINSTALLMENTSPLIT.ID, 
              BATCHREVENUEINSTALLMENTSPLIT.INSTALLMENTSPLITID, 
                            BATCHREVENUEINSTALLMENTSPLIT.DESIGNATIONID, 
                            BATCHREVENUEINSTALLMENTSPLIT.AMOUNT,
                            dbo.UFN_INSTALLMENT_GETINSTALLMENTSPLITAMOUNTAPPLIED(BATCHREVENUEINSTALLMENTSPLIT.INSTALLMENTSPLITID) APPLIED
                        from dbo.BATCHREVENUEINSTALLMENTSPLIT
                        left join dbo.DESIGNATION on DESIGNATION.ID = BATCHREVENUEINSTALLMENTSPLIT.DESIGNATIONID
                        where BATCHREVENUEINSTALLMENTSPLIT.BATCHREVENUEINSTALLMENTID = @BATCHREVENUEINSTALLMENTID
       );