USP_DATALIST_TICKETTOREPRINT

Returns a list of tickets 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_TICKETTOREPRINT(
    @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_TICKET_GETTICKETSTOREPRINT(@REPRINTJOBID, @WORKSTATIONID)
    order by
        TEMPLATEPRINTORDER, DOCUMENTSEQUENCE, PROGRAMID, REPORTCATALOGID, PRINTERSEQUENCE