Table of Contents

Table Log_Transportation_Orders

Entity

Entity: Logistics.Transportation.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
Suggest improvement to this page