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

BATCHJOBS

Column Name	Data format	Possible values	Description
BATCHID	[4xcharacters][yyyymmdd]	n/a	the leading characters are the first 4 characters in the destination BIC; generated when creating the batch
USERID	[integer]	{fincfg.....}
BATCHCOUNT	[integer]	n/a
BATCHAMOUNT	[numeric]	n/a
COMBATCHID	[4xcharacters][yyyymmdd][decimals]	n/a	the leading characters are the first 4 characters in the destination BIC; generated when creating the batch
DEFJOBCOUNT	[integer]	n/a
BATCHSTATUS	[integer]	{0, 10, 15, 20, 30}	0 - new; 10 - in progress; 15 - ready; 20 - failed; 30 - completed;
INSERTDATE	[timestamp]	current timestamp
COMBATCHAMT	[numeric]	n/a
ROUTINGPOINT	[characters]	{fincfg.queues.name}
REASON	[characters]	{ok, [error text]}
BATCHTYPE	[message type namespace]
BATCHUID	[characters]
BATCHACKCODE

BATCHJOBSINC

Column Name	Data format	Possible values	Description
SENDER	[characters]
COMBATCHID	[characters]	n/a
BATCHTYPE	[message type namespace]
INSERTDATE	[timestamp]	current date

ENTRYQUEUE

Column Name	Data format	Possible values	Description
GUID	[characters]	n/a	unique identifier generated by the entity inserting the record
PAYLOAD	[xml format message payload]	n/a
BATCHID	[characters]	n/a
CORRELATIONID	[characters]	n/a	unique identifier generated by the entity inserting the record
REQUESTORSERVICE	[characters]	{fincfg.servicemaps.friendlyname}
RESPONDERSERVICE	[characters]	{fincfg.servicemaps.friendlyname}
REQUESTTYPE	[characters]	{SingleMessage, Request, Response}
PRIORITY	[integer]	{1 - 99}
HOLDSTATUS	[integer]	{1, 0}	1 - active; 0 - inactive;
SEQUENCE	[integer]	{fincfg.routingrules.sequence where rule=[current queue]}
FEEDBACK	[characters]
SESSIONID
STATUS
QUEUENAME	[characters]	{fincfg.queues.name}

---

FEEDBACKAGG

Column Name	Data format	Possible values	Description
REQUESTOR	[characters]	{fincfg.servicemaps.friendlyname}
WMQID
CORRELID	[characters]	{findata.entryqueue.correlationid}
INTERFACECODE	[characters]	n/a
NETWORKCODE	[characters]	n/a
CORRESPCODE	[characters]	n/a
APPCODE	[characters]	n/a
PAYLOAD	[xml format message payload]	n/a
SWIFTMIR
INSERTDATE	[timestamp]	current date
BATCHID	[characters]	{findata.batchjobs.combatchid}
BATCHSEQ	[integer]	n/a
TRN	[characters]	{findata.routedmessages.trn}
OSESSION
ISESSION
ISSUER
OBATCHID

HISTORY

Column Name	Data format	Possible values	Description
GUID	[characters]	n/a	unique identifier generated by the entity inserting the record
PAYLOAD	[xml format message payload]	n/a	text is encoded
BATCHID	[characters]	n/a
CORRELATIONID	[characters]	{findata.entryqueue.correlationid}
SESSIONID
REQUESTORSERVICE	[characters]	{fincfg.servicemaps.friendlyname}
RESPONDERSERVICE	[characters]	{fincfg.servicemaps.friendlyname}
REQUESTTYPE	[characters]	{SingleMessage, Request, Response}
PRIORITY	[integer]	{1 - 99}
HOLDSTATUS	[integer]	{0, 1}	1 - active; 0 - inactive;
SEQUENCE
INSERTDATE	[timestamp]	current date
FEEDBACK

MT103TAB

Column Name	Data format	Possible values	Description
CORRELID	Varchar2(30)	NO		FK	Correlation identifier
MSGTYPE	Varchar2(50)	NO			Message type
DBACCOUNT	Varchar2(50)	NO			Debtor account number
CDACCOUNT	Varchar2(50)	NO			Creditor account number
AMOUNT	Varchar2(50)	NO			Transaction amount

MT202TAB

Column Name	Data format	Possible values	Description
CORRELID	Varchar2(30)	NO		FK	Correlation identifier
MSGTYPE	Varchar2(50)	NO			Message type
AMOUNT	Varchar2(50)	NO			Transaction amount
STLMDATE	Varchar2(6)	NO			Settlement date

ROUTEDMESSAGES

Column Name	Data format	Possible values	Description
GUID	[characters]	n/a	unique identifier generated by the entity inserting the record
CORRELID	[characters]	{findata.entryqueue.correlationid}
INSERTDATE	[timestamp]	current date
ACK	[integer]
MSGTYPE	[characters]	{fincfg.msgtypes.messagetype}
CURRENTQUEUE	[integer]	{fincfg.queues.guid}
SENDER	[characters]	n/a
RECEIVER	[characters]	n/a
TRN	[characters]	n/a
SENDERAPP	[characters]	{fincfg.servicemaps.friendlyname}
RECEIVERAPP	[characters]	{fincfg.servicemaps.friendlyname}
USERID	[integer]	{fincfg...}
AMOUNT	[digits]

ROUTINGJOBS

Column Name	Data format	Possible values	Description
GUID	[characters]	{findata.entryqueue.guid}
STATUS	[integer]	{-1, 0, 1}	0 - (new) job to process; -1 - job in process; 1 - job to be processed in next session;
BACKOUT	[integer]	{1-4}
PRIORITY	[integer]	{findata.entryqueue.priority}
ROUTINGPOINT	[characters]	{fincfg.queues.name / findata.entryqueue.queuename}
FUNCTION	[F={value}],[P={value}]	F:{Route, Complete, Unhold, Dispose, Batch}; P:{Feedback(value), Bank(value), GroupOrder(value), BatchSum(value), BatchId(value)}	F-function; P-parameter; different functions and parameters are comma separated
USERID	[integer]	{fincfg....}

SERVICEPERFORMANCE

Column Name	Data format	Possible values	Description
SERVICEID	[integer]	{fincfg.servicemaps.serviceid}
INSERTDATE	[timestamp]	current date
MINTRANSACTIONTIME
MAXTRANSACTIONTIME
MEANTRANSACTIONTIME
SEQUENCENO
IOIDENTIFIER	[integer]	{0; 1}	0 – output connector; 1 – input connector
SESSIONID
COMMITEDTRNS
ABORTEDTRNS

STATUS

Column Name	Data format	Possible values	Description
GUID	[characters]	n/a	unique identifier generated by the entity inserting the record
SERVICE	[integer]	{fincfg.servicemaps.serviceid}
TYPE	[characters]	{Info, Warning, Error}
MACHINE	[characters]	n/a
EVENTDATE	[timestamp]	current date
INSERTDATE	[timestamp]	current date
MESSAGE	[characters]	n/a
CLASS
INNEREXCEPTION	[characters]	n/a
ADDITIONALINFO	[characters]	n/a
SESSIONID

TEMPBATCHJOBS

Column Name	Data format	Possible values	Description
JOBID
SEQUENCE
COMBATCHID
XFORMITEM
CORRELATIONID
FEEDBACK