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