Table of Contents

Table Wms_Warehouse_Processes

Entity

Entity: Logistics.Wms.WarehouseProcesses

Contains warehouse process configurations that determine which algorithm is executed. The configurations can optionally be limited by document type, managed warehouse, and validity period. The algorithm defines the applicable conditions, processing steps, and Warehouse Order generation logic. Entity: Wms_Warehouse_Processes (Introduced in version 27.1.1.5)

Summary

Name Type Description
Active_From datetime Specifies the date and time from which the warehouse process configuration can be used. If empty, no start date restriction is applied.
Active_To datetime Specifies the date and time until which the warehouse process configuration can be used. If empty, no end date restriction is applied.
Is_Active bit Specifies whether the warehouse process configuration can participate in process selection. Inactive configurations are not considered.
Notes nvarchar(max) Additional information or comments about the warehouse process configuration.
Party_Id uniqueidentifier Specifies the party for which the process is applicable. If empty, the process is not restricted to a specific party.
Process_No int Determines the order in which warehouse process configurations are checked for applicability to the Warehouse Requisition. Configurations with lower numbers are checked first.
Warehouse_Id uniqueidentifier Specifies the managed warehouse for which the process is applicable. If empty, the process is not restricted to a specific managed warehouse.
Warehouse_Process_Id uniqueidentifier PK Unique identifier of the Warehouse Process.
Warehouse_Requisition_Document_Type_Id uniqueidentifier Specifies the Warehouse Requisition document type for which the process is applicable.

Columns

Active_From

Specifies the date and time from which the warehouse process configuration can be used. If empty, no start date restriction is applied.

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

Active_From - Supported Filters

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

Active_To

Specifies the date and time until which the warehouse process configuration can be used. If empty, no end date restriction is applied.

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 datetime (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
GreaterThanOrLessThan None no no

Is_Active

Specifies whether the warehouse process configuration can participate in process selection. Inactive configurations are not considered.

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

Notes

Additional information or comments about the warehouse process configuration.

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

Party_Id

Specifies the party for which the process is applicable. If empty, the process is not restricted to a specific 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 (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Party_Id - Supported Filters

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

Process_No

Determines the order in which warehouse process configurations are checked for applicability to the Warehouse Requisition. Configurations with lower numbers are checked first.

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 yes
Summary Type None
Supports EQUALS_IN no
Type int
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Warehouse_Id

Specifies the managed warehouse for which the process is applicable. If empty, the process is not restricted to a specific managed 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 2147483647
Ownership Reference no
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 (Allows NULL)
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 yes no

Warehouse_Process_Id

Unique identifier of the Warehouse Process.

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_Process_Id - Supported Filters

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

Warehouse_Requisition_Document_Type_Id

Specifies the Warehouse Requisition document type for which the process is applicable.

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

Warehouse_Requisition_Document_Type_Id - Supported Filters

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