UFN_DOCUMENT_GETSALESDOCUMENTSANDTICKETSTOPRINT

Gets all generated non refunded tickets and sales document to print and reprint for an order.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_DOCUMENT_GETSALESDOCUMENTSANDTICKETSTOPRINT(@SALESORDERID uniqueidentifier)
returns table
as return
    select
        T.ID, 
        T.NAME,
        T.EVENTDATE,
        T.EVENTTIME,
        T.PRINTCOUNT,
        T.PRINTCOUNT as HIDDENPRINTCOUNT,
        T.BARCODE,
        T.[PRINT] TOPRINT,
        0 TYPECODE,
        null CREDITCARDPAYMENTMETHODDETAILID,
        null CREDITID,
        null CREDITPAYMENTID    
    from
        dbo.UFN_ORDER_GETTICKETS(@SALESORDERID) T
    inner join
        dbo.TICKET on T.ID = TICKET.ID
    where
        TICKET.STATUSCODE not in (2 , 3)  --refunded, exchanged


    union all

    select
        null ID, 
        [TYPE] NAME,
        null EVENTDATE,
        null EVENTTIME,
        null PRINTCOUNT,
        0 HIDDENPRINTCOUNT,
        null BARCODE,
        TOPRINT TOPRINT,
        TYPECODE,
        CREDITCARDPAYMENTMETHODDETAILID,
        CREDITID,
        CREDITPAYMENTID
    from
        dbo.UFN_DOCUMENT_GETSALESDOCUMENTSTOPRINT(@SALESORDERID)