USP_DATALIST_DOCUMENTPRINTINGHISTORY

Lists the sales document printing history for a sales order.

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DOCUMENTPRINTINGHISTORY(@SALESORDERID uniqueidentifier)
                as
                    set nocount on;

                select 
                    PRINTINGHISTORY.ID,
                    PRINTINGHISTORY.TYPE,
                    PRINTINGHISTORY.PRINTEDDATE,
                    PRINTINGHISTORY.PRINTEDTIME,
                    PRINTINGHISTORY.APPUSER,
                    PRINTINGHISTORY.WORKSTATION
                from dbo.UFN_DOCUMENT_GETPRINTINGHISTORY(@SALESORDERID) PRINTINGHISTORY
                order by PRINTINGHISTORY.PRINTEDDATE