USP_DATALIST_SALESDOCUMENTSTOREPRINT

Returns a list of sales documents and prioritized printers to reprint for an order.

Parameters

Parameter	Parameter Type	Mode	Description
@REPRINTJOBID	uniqueidentifier	IN	Reprint job ID
@WORKSTATIONMACHINENAME	nvarchar(255)	IN	Workstation machine name

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SALESDOCUMENTSTOREPRINT(
    @REPRINTJOBID uniqueidentifier,
    @WORKSTATIONMACHINENAME nvarchar(255))
as
    set nocount on;

declare @WORKSTATIONID uniqueidentifier = dbo.UFN_WORKSTATION_GETIDBYMACHINENAME(@WORKSTATIONMACHINENAME);

select
    ID,
    NAME,
    TEMPLATEPRINTORDER,    
    REPORTCATALOGID,
    PROGRAMID,
    PRINTERNAME,
    PRINTERSEQUENCE,
    TEMPLATETYPECODE,
    CREDITCARDPAYMENTMETHODDETAILID,
    ISMERCHANTCOPY,
    SALESORDERID,
    DOCUMENTPRINTINGHISTORYID,
    CREDITPAYMENTID,
    CREDITID,
    DOCUMENTSEQUENCE,
    0 as SHOULDPRINTMERCHANTANDCUSTOMERCOPIES,
    SVGTEMPLATE
from dbo.UFN_DOCUMENT_GETDOCUMENTSTOREPRINT(@REPRINTJOBID, @WORKSTATIONID) DOCUMENTINFO
order by
    TEMPLATEPRINTORDER, DOCUMENTSEQUENCE, CREDITCARDPAYMENTMETHODDETAILID, CREDITPAYMENTID, ISMERCHANTCOPY desc, PRINTERSEQUENCE