UFN_DOCUMENTPRINTINGHISTORY_GETUNPRINTABLE_BYREPRINTID

Retrieves sales documents that failed to print.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REPRINTJOBID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_DOCUMENTPRINTINGHISTORY_GETUNPRINTABLE_BYREPRINTID(
                @REPRINTJOBID uniqueidentifier
            )
            returns table
            as return
                select 
                    [ID],
                    [TYPECODE],
                    [TYPE]
                from dbo.[DOCUMENTPRINTINGHISTORY]
                where 
                    [REPRINTJOBID] = @REPRINTJOBID and
                    [WORKSTATIONID] is null