USP_DATAFORMTEMPLATE_EDIT_PROCESSORTRANSACTIONCOLUMNMAPPING

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@TRANSACTIONDATEHEADER	nvarchar(100)	IN
@CARDTYPEHEADER	nvarchar(100)	IN
@CARDHOLDERNAMEHEADER	nvarchar(100)	IN
@CREDITCARDPARTIALNUMBERHEADER	nvarchar(100)	IN
@AUTHORIZATIONCODEHEADER	nvarchar(100)	IN
@TRANSACTIONAMOUNTHEADER	nvarchar(100)	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PROCESSORTRANSACTIONCOLUMNMAPPING (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @TRANSACTIONDATEHEADER nvarchar(100),
    @CARDTYPEHEADER nvarchar(100),
    @CARDHOLDERNAMEHEADER nvarchar(100),
    @CREDITCARDPARTIALNUMBERHEADER nvarchar(100),
    @AUTHORIZATIONCODEHEADER nvarchar(100),
    @TRANSACTIONAMOUNTHEADER nvarchar(100)
)
as
    set nocount on;

    declare @VENDORIDHEADER nvarchar(100);
    declare @CURRENCYHEADER nvarchar(100);

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PROCESSORTRANSACTIONCOLUMNMAPPING @ID=@ID, @VENDORIDHEADER=@VENDORIDHEADER output, @CURRENCYHEADER=@CURRENCYHEADER output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_PROCESSORTRANSACTIONCOLUMNMAPPING2
        @ID
        ,@CHANGEAGENTID
        ,@NAME
        ,@TRANSACTIONDATEHEADER
        ,@CARDTYPEHEADER
        ,@CARDHOLDERNAMEHEADER
        ,@CREDITCARDPARTIALNUMBERHEADER
        ,@AUTHORIZATIONCODEHEADER
        ,@TRANSACTIONAMOUNTHEADER
        ,@VENDORIDHEADER
        ,@CURRENCYHEADER;