USP_DATAFORMTEMPLATE_VIEW_PROCESSORTRANSACTIONCOLUMNMAPPING

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(100)	INOUT
@TRANSACTIONDATEHEADER	nvarchar(100)	INOUT
@TRANSACTIONTYPEHEADER	nvarchar(100)	INOUT
@CARDTYPEHEADER	nvarchar(100)	INOUT
@CARDHOLDERNAMEHEADER	nvarchar(100)	INOUT
@CREDITCARDPARTIALNUMBERHEADER	nvarchar(100)	INOUT
@AUTHORIZATIONCODEHEADER	nvarchar(100)	INOUT
@TRANSACTIONAMOUNTHEADER	nvarchar(100)	INOUT
@VENDORIDHEADER	nvarchar(100)	INOUT
@CURRENCYHEADER	nvarchar(100)	INOUT

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PROCESSORTRANSACTIONCOLUMNMAPPING
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output,
                @TRANSACTIONDATEHEADER nvarchar(100) = null output,
                @TRANSACTIONTYPEHEADER nvarchar(100) = null output,
                @CARDTYPEHEADER nvarchar(100) = null output,
                @CARDHOLDERNAMEHEADER nvarchar(100) = null output,
                @CREDITCARDPARTIALNUMBERHEADER nvarchar(100) = null output,
                @AUTHORIZATIONCODEHEADER nvarchar(100) = null output,
                @TRANSACTIONAMOUNTHEADER nvarchar(100) = null output,
                @VENDORIDHEADER nvarchar(100) = null output,
                @CURRENCYHEADER nvarchar(100) = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @NAME = NAME,
                    @TRANSACTIONDATEHEADER = TRANSACTIONDATEHEADER,
                    @TRANSACTIONTYPEHEADER = TRANSACTIONTYPEHEADER,
                    @CARDTYPEHEADER = CARDTYPEHEADER,
                    @CARDHOLDERNAMEHEADER = CARDHOLDERNAMEHEADER,
                    @CREDITCARDPARTIALNUMBERHEADER = CREDITCARDPARTIALNUMBERHEADER,
                    @AUTHORIZATIONCODEHEADER = AUTHORIZATIONCODEHEADER,
                    @TRANSACTIONAMOUNTHEADER = TRANSACTIONAMOUNTHEADER,
                    @VENDORIDHEADER = VENDORIDHEADER,
                    @CURRENCYHEADER = CURRENCYHEADER
                from dbo.PROCESSORTRANSACTIONCOLUMNMAPPING
                where ID = @ID

                return 0;