Table of Contents

Table Log_Transportation_Requisitions

Entity

Entity: Logistics.Transportation.TransportationRequisitions

Client requisition for transportation. Entity: Log_Transportation_Requisitions

Owner Tables Hierarchy

Summary

Name Type Description
Document_Id uniqueidentifier
Requested_Arrival_Date date Requested arrival date. NULL when no specific date is requested.
Requested_Arrival_Time time Requested arrival time. NULL when no specific time is requested.
Requested_Departure_Date date Requested date of departure. NULL when no specific date is requested.
Requested_Departure_Time time Requested time of departure. NULL when no specific time is requested.
Row_Version timestamp
Transport_From_Geo_Point_Id uniqueidentifier Geographical location of the loading, if available.
Transport_From_Party_Contact_Mechanism_Id uniqueidentifier Loading address.
Transport_From_Party_Id uniqueidentifier Shipping party.
Transport_To_Geo_Point_Id uniqueidentifier Geographical location of the unloading, if available.
Transport_To_Party_Contact_Mechanism_Id uniqueidentifier Unload address.
Transport_To_Party_Id uniqueidentifier Receiving party.
Transportation_Requisition_Id uniqueidentifier PK

Columns

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

Requested_Arrival_Date

Requested arrival date. NULL when no specific date is requested.

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

Requested_Arrival_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Requested_Arrival_Time

Requested arrival time. NULL when no specific time is requested.

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 (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Requested_Arrival_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Requested_Departure_Date

Requested date of departure. NULL when no specific date is requested.

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

Requested_Departure_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Requested_Departure_Time

Requested time of departure. NULL when no specific time is requested.

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 (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Requested_Departure_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None 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

Transport_From_Geo_Point_Id

Geographical location of the loading, if available.

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 (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Transport_From_Geo_Point_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Transport_From_Party_Contact_Mechanism_Id

Loading address.

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 Cm_Party_Contact_Mechanisms
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

Transport_From_Party_Contact_Mechanism_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Transport_From_Party_Id

Shipping party.

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_Parties
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

Transport_From_Party_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Transport_To_Geo_Point_Id

Geographical location of the unloading, if available.

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 (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Transport_To_Geo_Point_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Transport_To_Party_Contact_Mechanism_Id

Unload address.

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 Cm_Party_Contact_Mechanisms
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

Transport_To_Party_Contact_Mechanism_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Transport_To_Party_Id

Receiving party.

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_Parties
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

Transport_To_Party_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Transportation_Requisition_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_Requisition_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Suggest improvement to this page