USP_DATALIST_INVOICE_LINEITEM

A list of the invoice's line items.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_INVOICE_LINEITEM(@INVOICEID uniqueidentifier)
as
    set nocount on;

    select ID,
             SEQUENCE,
           TRANSACTIONAMOUNT as AMOUNT,
           DESCRIPTION
    from dbo.FINANCIALTRANSACTIONLINEITEM
    where FINANCIALTRANSACTIONID = @INVOICEID
    order by SEQUENCE asc