USP_TOKENIZERUSERCONFIG_GET

create procedure dbo.USP_TOKENIZERUSERCONFIG_GET
(
    @APPUSERID uniqueidentifier
)
as
begin

    declare @FIELDMAPPING as xml = null;

    select @FIELDMAPPING = FIELDMAPPING
    from TOKENIZERUSERCONFIG
    where APPUSERID = @APPUSERID

    if @FIELDMAPPING is null
    begin
        set @FIELDMAPPING = 
        '<FIELDMAPPING>
            <ITEM>
                <CREDITCARDFIELD>0</CREDITCARDFIELD>
                <CSVFIELD></CSVFIELD>
            </ITEM>
            <ITEM>
                <CREDITCARDFIELD>1</CREDITCARDFIELD>
                <CSVFIELD></CSVFIELD>
            </ITEM>
            <ITEM>
                <CREDITCARDFIELD>2</CREDITCARDFIELD>
                <CSVFIELD></CSVFIELD>
            </ITEM>
        </FIELDMAPPING>';
    end

    select @FIELDMAPPING as FIELDMAPPING

end