TRAN_DESTINATION

Definition


The TRAN_DESTINATION table contains the list of transport destinations related to transport requests

Technical Data


Schema Version 4.5.13
Filegroup CATALOG_DATA
Partitioned No

Summary


The TRAN_DESTINATION table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
TRAN_OID       TRANSPORT_REQUEST (OID)
 
 
ALIAS          
STATUS          
SEND_DATE          
RESPONSE_DATE          
FAILURE_CATEGORY          
FAILURE_MESSAGE          
ERROR_STACK          

Column Details


TRAN_OID

Definition The unique identifier of the related transport request
Type DECIMAL(28), NOT NULL

ALIAS

Definition The alias of the transport destination
Type NVARCHAR(64), NOT NULL

STATUS

Definition The status of the execution of the transport request for the transport destination
Format

The possible values are:

  • 0: created
  • 1: inProgress
  • 2: successful
  • 3: failed

Type DECIMAL(1), NOT NULL

SEND_DATE

Definition The date when the transport request was sent
Type DATETIME, NULL

RESPONSE_DATE

Definition The date when the response of the transport destination was received
Type DATETIME, NULL

FAILURE_CATEGORY

Definition The failure category if the execution of the transport request failed for the transport destination
Format

The possible values are:

  • 0: authenticationFailure
  • 1: communicationFailure
  • 2: invalid
  • 3: incompatibleConfiguration
  • 4: illegalState
  • 5: temporaryIllegalState

Type DECIMAL(1), NULL

FAILURE_MESSAGE

Definition The failure message if the execution of the transport request failed for the transport destination
Type NVARCHAR(2000), NULL

ERROR_STACK

Definition The stack of error if the execution of the transport request failed for the transport destination. The content of this field is in XML format.
Type VARBINARY(MAX), NULL