USP_DATALIST_REPRINTCREDITDOCUMENTS

Contains the list of sales documents to print/reprint for a refund.

Parameters

Parameter Parameter Type Mode Description
@CREDITID uniqueidentifier IN Input parameter indicating the context ID for the data list.
@REPRINTJOBID uniqueidentifier IN Reprint job ID

Definition

Copy


CREATE procedure dbo.USP_DATALIST_REPRINTCREDITDOCUMENTS(
    @CREDITID uniqueidentifier,
    @REPRINTJOBID uniqueidentifier)
as
    set nocount on;

    select ID,
           TYPECODE,
           CREDITCARDPAYMENTMETHODDETAILID,           
           CREDITPAYMENTID,
           TYPE
    from dbo.DOCUMENTPRINTINGHISTORY
    where CREDITID = @CREDITID and
        REPRINTJOBID = @REPRINTJOBID