Table of Contents

ACK - Acknowledge Entries

Module ACK

Description

Acknowledgment
A row in this table represents that an object is waiting for an
acknowledgment for a message that was sent or received, or it has
received a feedback (but the dispatch is not entered yet).
ACK rows can be inserted by services, when a message is sent out.
ACK rows are updated (STA and RCVDAT/RCVTIM)
- either by a service that handles incoming, external
acknowledgment messages
- or directly by an external process reflecting 'acknowledgment'
The status of ACK rows for an object (transaction) is checked by
SRVPDA.


Datafields

Name Description Data Type Len Dec. View lines View type Inst. Visible Codetable
INR Internal Unique ID of Acknowledgment Text 8 1 Edit Yes Public
OBJTYP Table Used to Store Associated Object Text 6 1 Edit Yes Public
OBJINR INR of Object Text 8 1 Edit Yes Public
OBJSUB Sub-ID for Object (e.g.SMHINR) Text 8 1 Edit Yes Public
OUTSRV Sending Service Text 6 1 Edit Yes Public
GENDATTIM Timestamp of Generation Datetime 15 0 Unknown Yes Public
ACKSRV Service for Incoming Acknowledgment Text 6 1 Edit Yes Public
EXTKEY Reference on Incoming Service Text 32 1 Edit Yes Public
RCVDATTIM Last Update Datetime 15 0 Unknown Yes Public
CLA Class of ACK (within Object) Text 3 1 Edit Yes Public
STA Status Text 1 1 Edit Yes Public Embedded
NACTXT Reason of NACK Text 60 1 Edit Yes Public
NACSTM Additional NACK Information Stream 1 0 Source Yes Public
VER Version Counter Text 4 1 Edit Yes Public
ETGEXTKEY Entity Group of Acknowledgment Entry Text 8 1 Edit Yes Public
GETFLDNRM Field holding the normalized search fields Text 10 1 Edit Yes Public

Indices

Name Fields Properties
ACK_GETFLDNRM GETFLDNRM
ACK_INR INR Unique
ACK_OBJSUB OBJSUB
ACK_REF ACKSRV, EXTKEY Unique
ACK_REF ACKSRV, EXTKEY, ETGEXTKEY Unique
ACK_STA OBJTYP, OBJINR, CLA, STA

/


Lock

INR

Datafield Description and Properties


Datafield INR Internal Unique ID

Description

Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter ACK. The field INR is used to maintain links from other tables into this table.

Helpinformation

Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.

For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.


Datafield OBJTYP Object Type

Description

Type of object the ACK entry refers to. This is the table the object is stored in. Typically 'TRN'.

Helpinformation

The field identifies the type of object the acknowledgement entry refers to.


Datafield OBJINR Object INR

Description

INR of the object within the table, defined in OBJTYP.

Helpinformation

The identification number (INR) of the object within the table, defined in Object Type.


Datafield OBJSUB Sub-ID for Object (e.g.SMHINR)

Description

An ID identifying the message within an object can be stored here. This is typically the INR of the SMH to differentiate between different messages for the same business transaction (TRN).

Helpinformation

An ID identifying the message within an object can be stored here. This is typically the identification number (INR) of the message header used to differentiate between different messages for the same business transaction.


Datafield OUTSRV Sending Service

Description

Logical channel over which the message was sent.

Helpinformation

Logical channel used to send the message.


Datafield GENDATTIM Timestamp of Generation

Description

Date and time this record was created.

Helpinformation

Date and time when this record was created.


Datafield ACKSRV Service for Incoming Acknowledgment

Description

Logical channel on which acknowlegement is expected. Typically set on generation of ACK record depending on value of OUTSRV (e.g. in a specific installation outgoing SWIFT messages might be acknowledged by incoming SWIFT system messages).

Helpinformation

The logical channel on which an acknowledgment is expected. Depending on the value of the 'Sending Service', this is normally set to generate an acknowledgment record (e.g. in a specific installation, outgoing SWIFT messages might be acknowledged by incoming SWIFT system messages).


Datafield EXTKEY External Key

Description

Reference that will be contained in the message received for acknowledgment. This key allows to reconcile incoming acknowledge messages and ACK records and is typically set, when the ACK record is created.

Helpinformation

Reference that has to be contained in a message received as acknowledgment (ACK). This key allows the reconciliation of incoming acknowledge messages and ACK records and is typically set, when the ACK record is created.


Datafield RCVDATTIM Last Update

Description

Date and time last acknowledgment was received.

Helpinformation

Date and time the last acknowledgement was received.


Datafield CLA Class of ACK (in the Object)

Description

Allows to build different classes of ACKs for an object if this field is not left empty.

Example for usage: In combination with several waiting services this could allow the workflow to proceed to a certain step when all ACKs of one level (e.g. 'messages sent') have been received, while other steps (e.g.'CLN') are postponed until other acknowledges (e.g. 'funds transfer confirmed') have been received.

Helpinformation

Allows different classes of acknowledgements (ACKs) to be created for an object, unless this field has been left empty.

Example: In combination with several pending services, this could allow the workflow to proceed to a certain step when all ACKs of one level (e.g. 'messages sent') have been received, while other steps (e.g. cancel) are postponed until other acknowledgments (e.g. 'funds transfer confirmed') have been received.


Datafield STA Status

Description

'O'pen ACK record has been created when message was sent. Waiting for positive or negative acknowledgement.

'A'cknowledged Positive acknowledgement has been received.

'R'ejected Negative acknowledgement has been received (SRVPDA will be set to 'E'rror).

Helpinformation

'O'pen acknowledgement record was created when message was sent. Waiting for positive or negative acknowledgment.

'A'cknowledged Positive acknowledge has been received.

'R'ejected Negative acknowledgement has been received.

Codetable
Code Text
O Open
R Rejected (NAC)
A Acknowledged
M Manually confirmed

Datafield ETGEXTKEY Entitygroup

Description

This table is defined on entity group level with separate entries for each entity group. This field holds the EXTKEY of the entity group which is the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the entity group of the currently active entity are visible to the user.

Helpinformation

This field holds the external key of the owning entity group to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity group are visible to the user.


Datafield GETFLDNRM Field holding the normalized search fields.

Description

Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.

Helpinformation

Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.


Datafield NACTXT Reason of NACK

Description

Reason of rejection. Text is coming from external interface and copied to the acknowledgement entry (ACK).

Helpinformation

Reason of rejection. Text is coming from external interface and copied to the acknowledgement entry (ACK).


Datafield NACSTM Additional NACK Information

Description

This stream can be filled with additional information why a send message has been NACKed. for NACK received via pseudoACKNAK this field will show all infomation from xml node <Contents><AckNack> and its childnodes

Helpinformation

If additional information on the NACK Reason are received from the message channel, platform, this information is tored in this info field


Datafield VER Version

Description

This field holds the version counter to keep track of the version history of an ACK entry. The individual versions are controlled by entries in the SLG table.

Helpinformation

This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.