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