USP_DATALIST_SALESDOCUMENTSANDTICKETSTOREPRINT

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_SALESDOCUMENTSANDTICKETSTOREPRINT(    
    @REPRINTJOBID uniqueidentifier,
    @WORKSTATIONMACHINENAME nvarchar(255))
as
set nocount on;

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

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