USP_DATALIST_SALESORDERBBPAYTRANSACTION
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@SALESORDERID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SALESORDERBBPAYTRANSACTION(@SALESORDERID uniqueidentifier)
as
set nocount on;
select ID,
TRANSACTIONID,
TRANSACTIONAMOUNT,
TRANSACTIONCONFIRMED,
CARDCHARGED,
PROCESSINGRESULTCODE
from dbo.SALESORDERBBPAYTRANSACTION
where SALESORDERID = @SALESORDERID