USP_DATALIST_DOCUMENTPRINTINGHISTORYCREDIT

Lists the sales document printing history for a refund.

Parameters

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

Definition

Copy


                CREATE procedure dbo.USP_DATALIST_DOCUMENTPRINTINGHISTORYCREDIT(@CREDITID uniqueidentifier)
                as
                    set nocount on;

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