USP_DATALIST_REPRINTSALESDOCUMENTS

Contains the list of sales documents to print/reprint.

Parameters

Parameter Parameter Type Mode Description
@SALESORDERID 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_REPRINTSALESDOCUMENTS(
    @SALESORDERID uniqueidentifier,
    @REPRINTJOBID uniqueidentifier)
as
    set nocount on;

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