|
All the available columns of the ixi-UMS Journal Data Base are described in the following. The German description is used for the Export by ODBC in the XML-templates.
For reasons of completeness, all the available columns are described, no matter whether they are needed for an analysis or not.
The order corresponds with the order, which is written into a table with a journal export without query criteria.
For the analysis of the journal data, the field contents marked with "internal use" are irrelevant.
Fieldname
|
Description
|
RECORD_ID
|
Internal use - primary key
|
CALL_ID
|
Internal use
|
BOUNDTYPE
|
Information whether this is an incoming or and outgoing message
Values: in, out
|
SERVICE
|
Information about the type of the message
Values:
FAXG3, FAXPOLL, VOC,SMS, ALERT = used services, connection OK
FAXG3_CALL,VOC_CALL = not clear because the connection had been interrupted
UNKNOWN = could not be detected
|
SENDERADDRESS
|
CallingPartyNumber= (D-channel) sender number
|
MAILFROM
|
Information of the "Mail From"-field with outgoing messages. This can be an e-mail address (SMTP) or a call number (e.g. SAP), depending on the connection
|
RECIPADDRESS
|
CalledPartyNumber - number to which the message is sent by ixi-UMS Business
|
ORIGRECIPADDRESS
|
Recipient number as entered by the user in an outgoing message
|
CHARGE
|
Must be transferred by the PSTN to ixi-UMS Business with SMS: number of the single messages
|
BILLINGCODE
|
Information of the cost center from the user properties
|
ASSOCFILENAME
|
Information for internal processing - Internal use
|
SUBJECT
|
Subject of the message
|
FAXTRANSSPEED
|
Only with fax messages
|
FAXNUMOFPAGES
|
Number of the transmitted fax pages
|
FAXRESOLUTION
|
Only with fax messages
|
FAXREMOTESTATION_ID
|
Only for outgoing faxes, ID of the remote station
|
FAXLOCALSTATION_ID
|
Corresponds with the sender call number, made up of the license and the fax sender number of the user.
This number is sent in the header as sender number
|
TRANSTIME
|
Date and time the entry was written into the journal
|
TRANSDURATION
|
Transmission time, duration the channel was busy in milliseconds
|
RESULTCODE
|
Final result (as code) after the connection was terminated; passed on from CAPI to ixi-UMS
|
RESULTMESSAGE
|
Translation of the final result code into text
|
CONNECTIONCODE
|
ISDN protocol information that gives a cause for a disconnect
|
CONNECTIONMESSAGE
|
Translation of the connection code into text
|
TRANSMISSIONCODE
|
ISDN protocol information that provides information about transmission errors
|
TRANSMISSIONMESSAGE
|
Translation of the transmission codes into text
|
CONNECTOR
|
Information from which ixi-UMS Connector the outgoing message has been sent
|
PRIORITY
|
Priority of the outgoing message
|
CONNECTOR_ID
|
Internal description of the ixi-UMS Connector
|
BCHANNEL
|
Information via which channel the message had been sent or received
|
SDNCONTROLLER Controller
|
Information via which controller the message had been received or sent
|
CHARGELOCCURRENCY
|
Must be passed on from the PSTN to the %PRODUKTNAME% Kernel
|
URL
|
Information whether and on which script the incoming call had been routed
|
ROUTEMETHOD
|
Information whether and how theixi-UMS Business passed on the calls: DDI, REDIRECTING, SUBADDRESS, CALLINGPARTY, DTMF
|
JOB_ID
|
Information for internal processing - Internal use
|
USER_JOB_ID
|
Currently is not used
|
MESSAGE_ID
|
If a message ID is transferred in the outgoing message, it is entered here. If no message ID is entered, theixi-UMS Business generates a new, unambiguous one.
|
FINALFLAG
|
With the last connection try of a job, FINALFLAG is set to 1, at all the previous jobs, it is 0. When the value is 1, the job is displayed in the journal. All the other connection tries are displayed in the job details. VALUES:
0 – not final entry for job
1 – final entry for job
|
RETRYCOUNT
|
States, which transmission try for outgoing messages the entry represents.
VALUES:
Depend on the configured connection retries in the spooling
|
|