|
Name |
Type |
Discontinued? |
|
| 1 |
TXPORT_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the transport request record. |
|
|
| 2 |
LINE |
INTEGER |
No |
|
|
|
| The line number for the information associated with this record. Multiple pieces of information can be associated with this record. |
|
|
| 3 |
EVENT_INSTANT_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The instant at which the assignment status of the transport request was updated on the server, stored as UTC. For local time, use TXPORT_EVENTS.EVENT_INSTANT_LOCAL_DTTM. |
|
|
| 4 |
WORKER_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the transporter assigned to this transport request at the time of the status update. |
|
|
| 5 |
TXPORT_DLY_RSN_C_NAME |
VARCHAR |
No |
|
|
|
| The delay reason category number if the transport request was marked as delayed. |
| May contain organization-specific values: Yes |
|
|
| 6 |
TXPORT_CANC_RSN_C_NAME |
VARCHAR |
No |
|
|
|
| This column contains cancel reasons specified by the user if the transport request was canceled. |
| May contain organization-specific values: Yes |
|
|
| 7 |
HKR_TXPORT_ID |
NUMERIC |
No |
|
|
|
| The ID of the transporter who changes the status of the request. |
|
|
| 8 |
EMP_TXPORT_ID |
VARCHAR |
No |
|
|
|
| The ID of the user who changes the status of the request. |
|
|
| 9 |
EMP_TXPORT_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 10 |
EVENT_INSTANT_LOCAL_DTTM |
DATETIME (Local) |
No |
|
|
|
| The local instant at which the assignment status of the transport request was updated. For UTC, use TXPORT_EVENTS.EVENT_INSTANT_DTTM. |
|
|
| 11 |
ENTRY_INST_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The instant at which an update to the assignment status of the transport request was entered, stored as UTC. |
|
|
