**only these values are implemented in the application; use of different ones may cause either errors or bad functionality

ALERTS

Column Name	Data format	Possible values	Description
QUEUEID	[integer]	{fincfg.queues.guid}
ALERTID	[characters]		internally generated - see ...
TYPE	[integer]	{1, 2}	1 - new message; 2 - check for messages;
EMAILADDRESS	[characters][@][characters][.][characters]	n/a
FREQUENCY	[integer]	n/a	Number of minutes *mandatory for TYPE=2
STATE	[integer]	{1, 2}	1 - active; 2 - inactive;
DESCRIPTION	[charcaters]	n/a
ALERTNAME	[characters]	n/a
WEEKDAYS	[DD]	{MF, MS}	MF - Monday to Friday; MS - Monday to Sunday; *mandatory for TYPE=2
STARTTIME	[h24:mi]	n/a	*mandatory for TYPE=2
ENDTIME	[h24:mi]	n/a	*mandatory for TYPE=2

BICCODES

Column Name	Data format	Possible values	Description
BIC	[characters]	n/a
DESCRIPTION	[characters]	n/a

CURRENCIES

Column Name	Data format	Possible values	Description
CURRENCY	[CCC]	n/a
EXCHRATE	[number]	n/a
DESCRIPTION	[characters]	n/a

FEEDBACKCODES

Column Name	Data format	Possible values	Description
GUID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='FEEDBACKCODES_GUID'+1}	identifier is generated by incrementing the current value
CODE	[characters]	n/a
DESCRIPTION	[characters]	n/a
CATEGORY	[characters:capitals]	{ACK, NACK}	ACK - positive feedback code; NACK - negative feedback code;
SOURCE	[characters:capitals]	...
USERACTION	[characters]	n/a

MSGTYPES

<br

Column Name	Data format	Possible values	Description
MTID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='MSGTYPES_MTID'+1}	identifier is generated by incrementing the current value
MESSAGETYPE	[characters]	{MT/MX Swift identifiers}
FRIENDLYNAME	[characters]	n/a	may be the same for several message types if they are having the same business purpose
DISPLAYORDER
STORAGE	[MT][msgtype][TAB]	n/a	table name must be real
BUSINESSAREA	[characters]	{Customer Credit Transfer, Debit Instruments, Treasury Markets, Interbank Funds Transfer}

NTBDAYS

Column Name	Data format	Possible values	Description
FREEDATE	[mm/dd/yyyy]	n/a

PARAMS

Column Name	Data format	Possible values	Description
NAME	[characters]	{Auto Archiving Interval, Auto Archiving Period, Duplicate Detection Period, BIC}	Auto Archiving Interval - scheduled transaction auto archiving Auto Archiving Period - number of days transactions are kept live Duplicate Detection Period - number of days transactions are tracked, detecting the duplicates BIC - BIC code of application owner
VALUE	[depending on each parameter]	{Auto Archiving Interval, Auto Archiving Period, Duplicate Detection Period, BIC}	Auto Archiving Interval - [h24-h24] Auto Archiving Period - [decimal] Duplicate Detection Period - [decimal] BIC - [swift BIC code]
DESCRIPTION	[characters]	n/a
CATEGORY	[characters]	{ARCHIVE, ALERT,INFO}

QMOVEPRIVMAPS

Column Name	Data format	Possible values	Description
MAPID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='QMOVEPRIVMAPS_MAPID'+1}	identifier is generated by incrementing the current value
SOURCEQUEUEID	[integer]	{fincfg.queues.guid}
DESTQUEUEID	[integer]	{fincfg.queues.guid}

QTYPEACTIONMAPS

Column Name	Data format	Possible values	Description
MAPID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='QTYPEACTIONMAPS_MAPID'+1}	indentifier is generated by incrementing the current value
QTYPEID	[integer]	{fincfg.queuetypes.typeid}
QACTIONID	[integer]	{fincfg.queuetypes.actionid}

QUEUEACTIONS

Column Name	Data format	Possible values	Description
ACTIONID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='QUEUEACTIONS_ACTIONID'+1}	indentifier is generated by incrementing the current value
ACTION	[charcaters]	{Authorize,Batch .....}
DESCRIPTION	[characters]	n/a
SINGLEMSG	[integer]	{1, 0}	1 - action applicable on single message 0 - action not applicable on single message
GROUPMSG	[integer]	{1, 0}	1 - action applicable on group of messages 0 - action not applicable on group of messages
OPTIONVALUES	[table name]	n/a

QUEUES

Column Name	Data format	Possible values	Description
GUID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='QUEUES_GUID'+1}	indentifier is generated by incrementing the current value
NAME	[{flow}][In/Out][Queue]	n/a
HOLDSTATUS	[integer]	{0, 1}	1 - true 0 - false
CONNECTOR	[integer]	{fincfg.servicemaps.serviceid}
TYPEID	[integer]	{fincfg.queuetypes.typeid}
BATCHNO	[integer]	n/a
DESCRIPTION	[characters]	n/a
PRIORITY	[integer]	{1-99}

QUEUETYPES

Column Name	Data format	Possible values	Description
TYPEID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='QUEUETYPES_TYPEID'+1}	indentifier is generated by incrementing the current value
TYPENAME	[characters]	{SENT Credit Transfer,.....}
LEV1KWORD1	[characters]	{routingkeywords.keyword}
LEV1KWORD2	[characters]	{routingkeywords.keyword}
LEV1KWORD3	[characters]	{routingkeywords.keyword}
LEV1KWORD4	[characters]	{routingkeywords.keyword}
LEV1KWORD5	[characters]	{routingkeywords.keyword}
LEV2KWORD1	[characters]	{routingkeywords.keyword}
LEV2KWORD2	[characters]	{routingkeywords.keyword}
LEV2KWORD3	[characters]	{routingkeywords.keyword}
LEV2KWORD4	[characters]	{routingkeywords.keyword}
LEV2KWORD5	[characters]	{routingkeywords.keyword}

ROUTINGKEYWORDMAPS

Column Name	Data format	Possible values	Description
KEYWORDID	[integer]	{routingkeywords.guid}
TAG	[//{smt/sg}:tagname/][] iso format:[//x:tagname/][text()]	n/a
MT	[characters]	{fincfg.msgtypes.messagetype}
SELECTOR	[characters]	{selector/selectoriso}
MAPID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='ROUTINGKEYWORDMAPS_MAPID'+1}	indentifier is generated by incrementing the current value

ROUTINGKEYWORDS

Column Name	Data format	Possible values	Description
GUID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='ROUTINGKEYWORDS_GUID'+1}	indentifier is generated by incrementing the current value
KEYWORD	[characters]	{TRN, ...}
COMPARER	[characters]	{string, date}
SELECTOR	[standard regular expression]	n/a
DESCRIPTION	[characters]	n/a
SELECTORISO	[standard regular expression]	n/a

ROUTINGRULES

Column Name	Data format	Possible values	Description
GUID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='ROUTINGRULES_GUID'+1}	indentifier is generated by incrementing the current value
QUEUEID	[integer]	{fincfg.queues.guid}
SCHEMAGUID	[integer]	{fincfg.routingschemas.guid}
SEQUENCE	[integer]	n/a	for tracking purposes, best use 5x
RULETYPE	[integer]	{0, 1, 2}	0 - normal 1 - afterStop 2 - beforeStart
DESCRIPTION	[characters]	[anyvalue]
MSGCOND	[keyword][operator][value]	keyword = {routingkeywords.keyword} operator = {==, !=, <=, =>, LIKE, IN, <, >} value = [anyvalue]
FUNCCOND	[function][operator][boolean]	function = {IsAck([namespace]), IsNack([namespace]), IsReply([namespace])} operator = {==, !=} boolean = {true, false}
METACOND	[metadata][operator][value]	metadata = {REQUESTOR, RESPONDER, OriginalRequestor, NS, FEEDBACKCODE} operator = {==, !=} value = {anyvalue}
ACTION	[action(parameter)]	{MoveTo, ChangeHoldStatus, Complete, SendReply, TransformMessage}

ROUTINGSCHEMAS

Column Name	Data format	Possible values	Description
NAME	[characters]	n/a
DESCRIPTION	[characters]	n/a
ACTIVE	{0, 1}	0 - inactive; 1 - active;
GUID	{fincfg.idgenlist.idvalue where tabcolname='ROUTINGSCHEMAS_GUID'+1}	indentifier is generated by incrementing the current value
STARTLIMIT	{fincfg.timelimits.guid}	n/a
STOPLIMIT	{fincfg.timelimits.guid}	n/a
SESSIONCODE	[characters:capitals]	{flow}
ISVISIBLE	[integer]	{1, 0}	1 - visible 0 - invisible

SERVICEMAPS

Column Name	Data format	Possible values	Description
FRIENDLYNAME	[characters]	n/a
SERVICEID	{fincfg.idgenlist.idvalue where tabcolname='SERVICEMAPS_SERVICEID'+1}	indentifier is generated by incrementing the current value
STATUS	[integer]	{0, 1, 3}
LASTSESSIONID
HEARTBEATINTERVAL
LASTHEARTBEAT
VERSION
PARTNER
SERVICETYPE
IOIDENTIFIER	[integer]	{0, 1}	0 – output connector 1 – input connector
EXITPOINT
SESSIONID
DUPLICATECHECK	[integer]	{0, 1, 2}	0 – duplicate detection inactive 1 - duplicate detection active for RE&CONN 2 - duplicate detection active for CONN
DUPLICATEQ
DUPLICATEMAP
DUPLICATENOTIFQ
DELAYEDNOTIFQ

TIMELIMITS

Column Name	Data format	Possible values	Description
GUID	[integer]	{fincfg.idgenlist.idvalue where tabcolname='TIMELIMITS_GUID'+1}	indentifier is generated by incrementing the current value
LIMITNAME	[characters]	n/a
LIMITTIME	[date]	n/a	hour will be extracted; date is ignored