Table Log_Transportation_Vehicles
Entity
Entity: Logistics.Shipment.TransportationVehicles
A vehicle, which is used for transportation. One actual vehicle might be defined multiple times as transportation vehicle - for different modes of transportation or cargo types. Entity: Log_Transportation_Vehicles
Owner Tables Hierarchy
Summary
Name |
Type |
Description |
Cargo_Type_Id |
uniqueidentifier |
The cargo type supported by this transportation vehicle. |
Carrier_Id |
uniqueidentifier |
The carrier, operating the vehicle. NULL for our own vehicles. |
Code |
nvarchar(16) |
The unique code (or call sign) of this transportation vehicle. |
Enterprise_Company_Id |
uniqueidentifier |
The enterprise company to which the transportation vehicle will be bound. |
Max_Cargo_Weight_Kg |
int |
The maximum weight of the cargo (in kg), which can be transported. NULL when this is unknown and no limit should be enforced. |
Max_Pallets_Count |
int |
The maximum number of pallets, which can be transported by the vehicle. NULL when this is unknown and no limit should be enforced. |
Notes |
nvarchar(max) |
|
Row_Version |
timestamp |
|
Transportation_Mode_Id |
uniqueidentifier |
The mode of transportation provided by this transportation vehicle. The same base vehicle might be used for more than one mode. |
Transportation_Vehicle_Id |
uniqueidentifier PK |
|
Vehicle_Id |
uniqueidentifier |
The definition of the base vehicle. |
Columns
Cargo_Type_Id
The cargo type supported by this transportation vehicle.
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_Cargo_Types |
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 |
Cargo_Type_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Carrier_Id
The carrier, operating the vehicle. NULL for our own vehicles.
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 |
Code
The unique code (or call sign) of this transportation vehicle.
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 |
16 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
yes |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
nvarchar(16) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Code - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Like |
None |
no |
no |
Enterprise_Company_Id
The enterprise company to which the transportation vehicle will be bound.
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_Enterprise_Companies |
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 |
Enterprise_Company_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Max_Cargo_Weight_Kg
The maximum weight of the cargo (in kg), which can be transported. NULL when this is unknown and no limit should be enforced.
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 |
int (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Max_Pallets_Count
The maximum number of pallets, which can be transported by the vehicle. NULL when this is unknown and no limit should be enforced.
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 |
int (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Notes
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 |
2147483647 |
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 |
nvarchar(max) (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
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 |
Transportation_Mode_Id
The mode of transportation provided by this transportation vehicle. The same base vehicle might be used for more than one mode.
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 |
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 |
no |
no |
Transportation_Vehicle_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_Vehicle_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Vehicle_Id
The definition of the base vehicle.
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 |
Fleet_Vehicles |
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 |
Vehicle_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |