Logistics.Wms.WarehouseAvailability (View)
The availability of goods in the warehouse locations of the warehouse.
General
Namespace: Logistics.Wms
Repository: Logistics.Wms.WarehouseAvailability
Introduced In Version: 21.1.1.35
API access: ReadWrite
Visualization
Display Format: {WarehouseId}: {WarehouseLocationId}
Search Members:
Category: Views
Show in UI: ShownByDefault
Aggregate
An aggregate is a cluster of domain objects that can be treated as a single unit.
Aggregate Tree
Attributes
| Name | Type | Description |
|---|---|---|
| QuantityBaseAvailable | decimal (38, 3) | Currently available quantity in base measurement unit.Required Filter(eq;ge;le) Introduced in version 22.1.5.25 |
| StandardQuantityAvailable | decimal (38, 3) | Currently available theoretical quantity according to the measurement dimensions of the product. It can be used to calculate the quantity available in fixed measurement units like pieces.Required Filter(eq;ge;le) Introduced in version 22.1.5.25 |
References
| Name | Type | Description |
|---|---|---|
| LogisticUnit | LogisticUnits (nullable) | Logistic unit, which was transacted. NULL when the transaction was not for a logistic unit. |
| Lot | Lots (nullable) | The lot which was transacted. NULL when the transaction was not for a specific lot. |
| Product | Products | The product, which was transacted. |
| ProductVariant | ProductVariants (nullable) | The product variant, which was transacted. NULL when the transaction was not for a product variant. |
| SerialNumber | SerialNumbers (nullable) | The serial number which was transacted. NULL when the transaction was not for a specific serial number. |
| Warehouse | Warehouses | The warehouse in which the transaction occurred. |
| WarehouseLocation | WarehouseLocations | The warehouse location, where the transaction occurred. |
Attribute Details
QuantityBaseAvailable
Currently available quantity in base measurement unit.Required Filter(eq;ge;le) Introduced in version 22.1.5.25
Type: decimal (38, 3)
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
StandardQuantityAvailable
Currently available theoretical quantity according to the measurement dimensions of the product. It can be used to calculate the quantity available in fixed measurement units like pieces.Required Filter(eq;ge;le) Introduced in version 22.1.5.25
Type: decimal (38, 3)
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
Reference Details
LogisticUnit
Logistic unit, which was transacted. NULL when the transaction was not for a logistic unit.
Type: LogisticUnits (nullable)
Category: System
Inherited From: Wms_Warehouse_Transactions_Table.Logistic_Unit_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
Lot
The lot which was transacted. NULL when the transaction was not for a specific lot.
Type: Lots (nullable)
Category: System
Inherited From: Wms_Warehouse_Transactions_Table.Lot_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
Product
The product, which was transacted.
Type: Products
Category: System
Inherited From: Wms_Warehouse_Transactions_Table.Product_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
ProductVariant
The product variant, which was transacted. NULL when the transaction was not for a product variant.
Type: ProductVariants (nullable)
Category: System
Inherited From: Wms_Warehouse_Transactions_Table.Product_Variant_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
SerialNumber
The serial number which was transacted. NULL when the transaction was not for a specific serial number.
Type: SerialNumbers (nullable)
Category: System
Inherited From: Wms_Warehouse_Transactions_Table.Serial_Number_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
Warehouse
The warehouse in which the transaction occurred.
Type: Warehouses
Category: System
Inherited From: Wms_Warehouse_Transactions_Table.Warehouse_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
WarehouseLocation
The warehouse location, where the transaction occurred.
Type: WarehouseLocations
Category: System
Inherited From: Wms_Warehouse_Transactions_Table.Warehouse_Location_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
API
Domain API Entity Set: Logistics_Wms_WarehouseAvailability
Domain API Entity Type: Logistics_Wms_WarehouseAvailabilityEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Logistics_Wms_WarehouseAvailability?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Logistics_Wms_WarehouseAvailability?$top=10