Table Log_Logistic_Units
Entity
Entity: Logistics.Common.LogisticUnits
Composition of products established for transport and/or storage which needs to be managed through the supply chain. Entity: Log_Logistic_Units (Introduced in version 21.1.0.77)
Summary
Name
Type
Description
Cargo_Type_Id
uniqueidentifier
General type of the cargo of the logistic unit. NULL means unknown or N/A.
Expected_Weight
decimal(12, 3)
Expected weight in KG. Used for planning purposes. NULL means unknown.
Is_Active
bit
Indicates whether the logistic unit is currently active.
Logistic_Unit_Id
uniqueidentifier PK
Logistic_Unit_Type_Id
uniqueidentifier
The type of the logistic unit. NULL means the type is currently unknown.
Measured_Weight
decimal(12, 3)
Actual measured weight of the unit in KG. NULL means unknown.
Notes
nvarchar(max)
Represented_As_Product_Id
uniqueidentifier
When the logistic unit is also a tradeable item, specifies the product used to trade the unit. The product should uniquely identify only one logistic unit. Note that this is different from a logistic unit containing a single item. NULL means that the unit is not a tradeable item.
Row_Version
timestamp
Seal_Status
char(3) Allowed: OPN, SLD
Specifies the sealing status of the logistic unit and determines whether its contents can still be modified or have been finalized.
Serial_Code
nvarchar(32)
Unique serial code of the logistic unit. If GS1 coding is used, this is the SSCC.
Source_Document_Id
uniqueidentifier
Specifies the document from which the logistic unit was created.
Columns
Cargo_Type_Id
General type of the cargo of the logistic unit. NULL means unknown or N/A.
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 (Allows NULL)
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
yes
no
Expected_Weight
Expected weight in KG. Used for planning purposes. NULL means unknown.
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
decimal(12, 3) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Expected_Weight - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
GreaterThanOrLessThan
None
yes
yes
Is_Active
Indicates whether the logistic unit is currently active.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
True
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
bit
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Is_Active - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Logistic_Unit_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
Logistic_Unit_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
GreaterThanOrLessThan
None
no
yes
Logistic_Unit_Type_Id
The type of the logistic unit. NULL means the type is currently unknown.
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_Logistic_Unit_Types
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
Logistic_Unit_Type_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
Measured_Weight
Actual measured weight of the unit in KG. NULL means unknown.
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
decimal(12, 3) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Measured_Weight - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
GreaterThanOrLessThan
None
yes
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
Notes - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Like
None
no
no
Represented_As_Product_Id
When the logistic unit is also a tradeable item, specifies the product used to trade the unit. The product should uniquely identify only one logistic unit. Note that this is different from a logistic unit containing a single item. NULL means that the unit is not a tradeable item.
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_Products
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
Represented_As_Product_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
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
Seal_Status
Specifies the sealing status of the logistic unit and determines whether its contents can still be modified or have been finalized.
Property
Value
Allowed Values
OPN, SLD
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
3
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
char(3) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Serial_Code
Unique serial code of the logistic unit. If GS1 coding is used, this is the SSCC.
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
32
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
yes
Summary Type
None
Supports EQUALS_IN
yes
Type
nvarchar(32)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Serial_Code - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Like
None
no
no
Source_Document_Id
Specifies the document from which the logistic unit was created.
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_Documents
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
Source_Document_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no