**only these values are implemented in the application; use of different ones may cause either errors or bad functionality
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 |
Column Name | Data format | Possible values | Description |
---|---|---|---|
SENDER | [characters] | ||
COMBATCHID | [characters] | n/a | |
BATCHTYPE | [message type namespace] | ||
INSERTDATE | [timestamp] | current date |
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} |
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 |
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 |
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 |
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 |
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...} |
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-function; P-parameter; different functions and parameters are comma separated | |
USERID | [integer] | {fincfg....} |
Column Name | Data format | Possible values | Description |
---|---|---|---|
SERVICEID | [integer] | {fincfg.servicemaps.serviceid} | |
INSERTDATE | [timestamp] | current date | |
MINTRANSACTIONTIME | |||
MAXTRANSACTIONTIME | |||
MEANTRANSACTIONTIME | |||
SEQUENCENO | |||
IOIDENTIFIER | |||
SESSIONID | |||
COMMITEDTRNS | |||
ABORTEDTRNS |
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 |
Column Name | Data format | Possible values | Description |
---|---|---|---|
JOBID | |||
SEQUENCE | |||
COMBATCHID | |||
XFORMITEM | |||
CORRELATIONID | |||
FEEDBACK |