Table of Contents

Table Wms_Warehouse_Workers

Entity

Entity: Logistics.Wms.WarehouseWorkers

Human or robot worker, which can execute warehouse tasks. Entity: Wms_Warehouse_Workers (Introduced in version 22.1.6.31)

Owner Tables Hierarchy

Summary

Name Type Description
Active_From date The date, from which the worker record has become active in the warehouse.
Active_To date The date of termination of the activity of the worker in the warehouse. Can be NULL for workers, which are still active and do not have previous terminations.
Default_Warehouse_Location_Id uniqueidentifier Specifies the default warehouse location used by the worker during task execution to temporarily hold goods being collected, moved, or otherwise processed.
Is_Active bit Specifies whether the worker is active and can execute new warehouse tasks.
Notes nvarchar(max)
Person_Id uniqueidentifier Readonly The definition of the person, when the worker is human worker. NULL means that the person is unknown or the worker is non-person.
Row_Version timestamp
User_Id uniqueidentifier The user who is going to work in the selected warehouse
Warehouse_Id uniqueidentifier The warehouse, where the worker works.
Warehouse_Worker_Id uniqueidentifier PK
Warehouse_Worker_Name nvarchar(254) ML Name of the worker (multi-language).
Warehouse_Worker_Role char(3) Allowed: CKR, LBR, PKR, RVR, HNR, PCR, KTR, DKR, GNR Specifies the main role of the Warehouse Worker in the managed warehouse. The role is used to identify and filter workers during warehouse management. It does not restrict warehouse order assignment—a worker can also be assigned orders typically performed by another role. CKR=Checker; LBR=Labeler; PKR=Picker; RVR=Receiver; HNR=Handler; PCR=Packer; KTR=Kitter; DKR=Dekitter; GNR=General.

Columns

Active_From

The date, from which the worker record has become active in the warehouse.

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDate
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 7
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

Active_From - Supported Filters

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

Active_To

The date of termination of the activity of the worker in the warehouse. Can be NULL for workers, which are still active and do not have previous terminations.

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

Active_To - Supported Filters

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

Default_Warehouse_Location_Id

Specifies the default warehouse location used by the worker during task execution to temporarily hold goods being collected, moved, or otherwise processed.

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

Default_Warehouse_Location_Id - Supported Filters

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

Is_Active

Specifies whether the worker is active and can execute new warehouse tasks.

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

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

Person_Id

The definition of the person, when the worker is human worker. NULL means that the person is unknown or the worker is non-person.

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 3
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
Referenced Table Cm_Persons
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

Person_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes 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 5
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

User_Id

The user who is going to work in the selected warehouse

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 9
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Sec_Users
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

User_Id - Supported Filters

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

Warehouse_Id

The warehouse, where the worker works.

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 1
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Wms_Warehouses
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

Warehouse_Id - Supported Filters

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

Warehouse_Worker_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 0
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

Warehouse_Worker_Id - Supported Filters

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

Warehouse_Worker_Name

Name of the worker (multi-language).

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 254
Order 2
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type nvarchar(254) (MultiLanguage)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Warehouse_Worker_Name - Supported Filters

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

Warehouse_Worker_Role

Specifies the main role of the Warehouse Worker in the managed warehouse. The role is used to identify and filter workers during warehouse management. It does not restrict warehouse order assignment—a worker can also be assigned orders typically performed by another role. CKR=Checker; LBR=Labeler; PKR=Picker; RVR=Receiver; HNR=Handler; PCR=Packer; KTR=Kitter; DKR=Dekitter; GNR=General.

Property Value
Allowed Values CKR, LBR, PKR, RVR, HNR, PCR, KTR, DKR, GNR
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 yes
Type char(3)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Warehouse_Worker_Role - Supported Filters

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