USP_DATALIST_INVOICESCHEDULE

This datalist returns an invoice's schedule.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_INVOICESCHEDULE(@CONTEXTID uniqueidentifier)
as
    set nocount on;

  select
    FTS.ID
    ,FTS.DUEDATE
    ,FTS.AMOUNT
    ,FTS.AMOUNT - FTS.BALANCE as AMOUNTPAID
  from 
    dbo.FINANCIALTRANSACTIONSCHEDULE as FTS
  where
    FTS.FINANCIALTRANSACTIONID = @CONTEXTID and FTS.DELETED = 0
  order by
    FTS.DUEDATE ASC;