Table of Contents

Table Log_Transportation_Vehicles

Entity

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