UFN_INVOICE_SCHEDULES

Returns the schedule for an invoice

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@FINANCIALTRANSACTIONID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_INVOICE_SCHEDULES(@FINANCIALTRANSACTIONID uniqueidentifier)
  returns table
  as return
      select 
        FTS.ID
      ,FTS.DUEDATE
      ,FTS.AMOUNT
      ,FTS.AMOUNT - FTS.BALANCE AMOUNTPAID
    from 
      FINANCIALTRANSACTIONSCHEDULE as FTS
    where 
      FTS.FINANCIALTRANSACTIONID = @FINANCIALTRANSACTIONID and FTS.DELETED = 0