Table of Contents

Table Wms_Warehouse_Transactions

Entity

Entity: Logistics.Wms.WarehouseTransactions

Represents increase or decrease in the quantity available in a warehouse location. Entity: Wms_Warehouse_Transactions (Introduced in version 21.1.1.26)

Summary

Name Type Description
Catch_Quantity decimal(12, 3) Catch (measured) quantity for the transaction. Positive values indicate transactions. Negative values are used for adjustments. NULL when catch measurement is not configured for the product.
Catch_Quantity_Unit_Id uniqueidentifier The measurement unit of the catch quantity. NULL when catch measurement is not configured for the product.
Creation_Time_Utc datetime The creation time in UTC.
Creation_User_Id uniqueidentifier The creation user.
Direction nvarchar(1) Allowed: I, O Direction of the transaction - I=IN, O=OUT.
Logistic_Unit_Id uniqueidentifier Logistic unit, which was transacted. NULL when the transaction was not for a logistic unit.
Lot_Id uniqueidentifier The lot which was transacted. NULL when the transaction was not for a specific lot.
Product_Id uniqueidentifier The product, which was transacted.
Product_Variant_Id uniqueidentifier The product variant, which was transacted. NULL when the transaction was not for a product variant.
Quantity decimal(12, 3) The transacted net change in quantity. Positive values indicate transactions. Negative values are used for adjustments.
Quantity_Base decimal(12, 3) Quantity in the base measurement unit of the product.
Quantity_Unit_Id uniqueidentifier The measurement unit of quantity.
Row_Version timestamp
Serial_Number_Id uniqueidentifier The serial number which was transacted. NULL when the transaction was not for a specific serial number.
Standard_Quantity decimal(12, 3) The theoretical quantity according to the current measurement dimensions of the product. Used to measure the execution.
Task_Type nvarchar(3) Allowed: REC, DIS, MOV, LBL, INS, PCK, UPK, KIT, DKT, CNT, TSK, CDP, CRC, ASM, DSM The type of the task (operation), which was transacted.
Warehouse_Id uniqueidentifier The warehouse in which the transaction occurred.
Warehouse_Location_Id uniqueidentifier The warehouse location, where the transaction occurred.
Warehouse_Order_Id uniqueidentifier The order which created this transaction. NULL when this transaction was not based on order.
Warehouse_Order_Line_Id uniqueidentifier The order line which created this transaction. NULL when this transaction was not based on order line.
Warehouse_Transaction_Id uniqueidentifier PK

Columns

Catch_Quantity

Catch (measured) quantity for the transaction. Positive values indicate transactions. Negative values are used for adjustments. NULL when catch measurement is not configured for the product.

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

Catch_Quantity - Supported Filters

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

Catch_Quantity_Unit_Id

The measurement unit of the catch quantity. NULL when catch measurement is not configured for the product.

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

Catch_Quantity_Unit_Id - Supported Filters

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

Creation_Time_Utc

The creation time in UTC.

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDateTimeUtc
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
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Creation_Time_Utc - Supported Filters

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

Creation_User_Id

The creation user.

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

Creation_User_Id - Supported Filters

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

Direction

Direction of the transaction - I=IN, O=OUT.

Property Value
Allowed Values I, O
Auto Complete no
Data Filter no
Default Value I
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 nvarchar(1)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Direction - Supported Filters

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

Logistic_Unit_Id

Logistic unit, which was transacted. NULL when the transaction was not for a logistic unit.

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_Units
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_Id - Supported Filters

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

Lot_Id

The lot which was transacted. NULL when the transaction was not for a specific lot.

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

Lot_Id - Supported Filters

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

Product_Id

The product, which was transacted.

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

Product_Id - Supported Filters

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

Product_Variant_Id

The product variant, which was transacted. NULL when the transaction was not for a product variant.

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

Product_Variant_Id - Supported Filters

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

Quantity

The transacted net change in quantity. Positive values indicate transactions. Negative values are used for adjustments.

Property Value
Auto Complete no
Data Filter no
Default Value 0
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 yes
Type decimal(12, 3)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Quantity - Supported Filters

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

Quantity_Base

Quantity in the base measurement unit of the product.

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

Quantity_Unit_Id

The measurement unit of quantity.

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

Quantity_Unit_Id - Supported Filters

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

Serial_Number_Id

The serial number which was transacted. NULL when the transaction was not for a specific serial number.

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

Serial_Number_Id - Supported Filters

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

Standard_Quantity

The theoretical quantity according to the current measurement dimensions of the product. Used to measure the execution.

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

Task_Type

The type of the task (operation), which was transacted.

Property Value
Allowed Values REC, DIS, MOV, LBL, INS, PCK, UPK, KIT, DKT, CNT, TSK, CDP, CRC, ASM, DSM
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 nvarchar(3)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Task_Type - Supported Filters

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

Warehouse_Id

The warehouse in which the transaction occurred.

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

The warehouse location, where the transaction occurred.

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

Warehouse_Location_Id - Supported Filters

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

Warehouse_Order_Id

The order which created this transaction. NULL when this transaction was not based on order.

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_Orders
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_Order_Id - Supported Filters

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

Warehouse_Order_Line_Id

The order line which created this transaction. NULL when this transaction was not based on order line.

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_Order_Lines
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_Order_Line_Id - Supported Filters

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

Warehouse_Transaction_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

Warehouse_Transaction_Id - Supported Filters

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