USP_DATAFORMTEMPLATE_EDITLOAD_PROCESSORTRANSACTIONCOLUMNMAPPING

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@NAME	nvarchar(100)	INOUT
@TRANSACTIONDATEHEADER	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_EDITLOAD_PROCESSORTRANSACTIONCOLUMNMAPPING(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @TSLONG bigint = 0 output,
                    @NAME nvarchar(100) = null output,
                    @TRANSACTIONDATEHEADER 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
                set @TSLONG = 0

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

                return 0;