TRANSPORT_REQUEST

Definition

The TRANSPORT_REQUEST table contains the list of transport requests created in the system

Technical Data

Schema Version	2025.0.0
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The TRANSPORT_REQUEST table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	FK	IX	Uses	Used by	Definition
OID	PK_TRANSPORT_REQUEST				TRAN_DESTINATION (TRAN_OID)	The unique identifier of the transport request
CLIENT_NUMBER						The client number associated to the transport request
CREATION_DATE						The date when the transport request was created
STATUS						The status of the execution of the transport request More...
CHAN_OID						The unique identifier of the related change list
FAILURE_MESSAGE						The failure message if the execution of the transport request failed

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

OID

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

CLIENT_NUMBER

Definition	The client number associated to the transport request
Type	DECIMAL(3), NOT NULL

CREATION_DATE

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

STATUS

Definition	The status of the execution of the transport request
Format	The possible values are: 0: created 1: executed
Type	DECIMAL(1), NOT NULL

CHAN_OID

Definition	The unique identifier of the related change list
Type	DECIMAL(28), NOT NULL

FAILURE_MESSAGE

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

Primary Key Details

See the primary key information:

PK_TRANSPORT_REQUEST

Column(s)	OID
Filegroup	CATALOG_DATA