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