Table Log_Transportation_Orders
Entity
Entity: Logistics.Shipment.TransportationOrders
Transportation ordered to specific carrier or vehicle. Entity: Log_Transportation_Orders
Owner Tables Hierarchy
Summary
Name |
Type |
Description |
Arrival_Date |
date |
Planned arrival date. |
Arrival_Time |
time |
Planned arrival time. |
Carrier_Id |
uniqueidentifier |
The carrier chosen for this transportation. NULL when the transportation is done with own transport. |
Crew_Id |
uniqueidentifier |
The crew which is assigned to operate the vehicle of the current Transportation Order. If null means the crew is yet unknown or the order is executed by external carrier. |
Departure_Date |
date |
Planned departure date. |
Departure_Time |
time |
Planned departure time. |
Document_Id |
uniqueidentifier |
|
From_Geo_Point_Id |
uniqueidentifier |
The geographic point from which the route begins. |
Row_Version |
timestamp |
|
To_Geo_Point_Id |
uniqueidentifier |
The geographic point at which the route ends. |
Transportation_Mode_Id |
uniqueidentifier |
The mode of transportation which should be used for this order. NULL when it is unknown or doesn't matter. |
Transportation_Order_Id |
uniqueidentifier PK |
|
Transportation_Vehicle_Id |
uniqueidentifier |
The own transportation vehicle, which will be used for the transportation. |
Columns
Arrival_Date
Planned arrival date.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
date |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Arrival_Date - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
GreaterThanOrLessThan |
None |
no |
no |
Arrival_Time
Planned arrival time.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
time |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Arrival_Time - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
GreaterThanOrLessThan |
None |
no |
no |
Carrier_Id
The carrier chosen for this transportation. NULL when the transportation is done with own transport.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Log_Carriers |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Carrier_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Crew_Id
The crew which is assigned to operate the vehicle of the current Transportation Order. If null means the crew is yet unknown or the order is executed by external carrier.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Fleet_Crews |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Crew_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Departure_Date
Planned departure date.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
date |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Departure_Date - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
GreaterThanOrLessThan |
None |
no |
no |
Departure_Time
Planned departure time.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
time |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Departure_Time - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
GreaterThanOrLessThan |
None |
no |
no |
Document_Id
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
yes |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Gen_Documents |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
no |
Document_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
From_Geo_Point_Id
The geographic point from which the route begins.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Gen_Geo_Points |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
From_Geo_Point_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Row_Version
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
timestamp |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
no |
To_Geo_Point_Id
The geographic point at which the route ends.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Gen_Geo_Points |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
To_Geo_Point_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Transportation_Mode_Id
The mode of transportation which should be used for this order. NULL when it is unknown or doesn't matter.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Log_Transportation_Modes |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Transportation_Mode_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Transportation_Order_Id
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
NewGuid |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
yes (order: 1) |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
no |
Transportation_Order_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Transportation_Vehicle_Id
The own transportation vehicle, which will be used for the transportation.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Log_Transportation_Vehicles |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Transportation_Vehicle_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |