Logistics.Inventory.DemandManagement.AvailableToPromiseByLots View
Namespace: Logistics.Inventory.DemandManagement
Quantities available to promise for the different date periods. Also contains the current and projected availability. The algorithm accounts for the quantities for each lot and separately for the quantities without lot. Entity: Inv_Demand_Management_ATP_By_Lots (Introduced in version 23.1.1.80)
Default Visualization
Default Display Text Format:
{ATPBaseValue}: {CurrentAvailabilityBaseValue}
Default 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 |
|---|---|---|
| ATPBase | Quantity (38, 3) | Indicates the quantity available to promise (in a base unit). It is valid from this date on. Unit: Product.BaseMeasurementCategory.BaseUnit Required |
| CurrentAvailabilityBase | Quantity (38, 3) | The current availability in а base measurement unit. Unit: Product.BaseMeasurementCategory.BaseUnit Required |
| FromDate | datetime | Тhe date from which the available to promise quantity is valid. Required Filter(eq;ge;le) |
| MovementsBase | Quantity (38, 3) | The sum of the quantity of all planned stock movements on this date in а base measurement unit. . Unit: Product.BaseMeasurementCategory.BaseUnit Required |
| MovementsToDateBase | Quantity (38, 3) | The sum of the quantity of all planned stock movements until this date (inclusive) in а base measurement unit. The value is cumulative. Unit: Product.BaseMeasurementCategory.BaseUnit Required |
| ProjectedAvailabilityBase | Quantity (38, 3) | Projected Availability in а base measurement unit on the particular date. The value is cumulative and includes the sum of all planned stock movements until this date (inclusive) and the current availability. Unit: Product.BaseMeasurementCategory.BaseUnit Required |
References
| Name | Type | Description |
|---|---|---|
| EnterpriseCompany | EnterpriseCompanies | Тhe Enterprise Company, for which the quantities are calculated. Required Filter(multi eq) Inherited from Gen_Documents_Table.Enterprise_Company_Id |
| Lot | Lots (nullable) | The Lot, for which the quantities are calculated. Filter(multi eq) Inherited from Inv_Store_Order_<br />Lines_Table.Lot_Id |
| Product | Products | The Product, for which the quantities are calculated. Required Filter(multi eq) Inherited from Inv_Store_Order_<br />Lines_Table.Product_Id |
| Store | Stores | The Store, for which the quantities are calculated. Required Filter(multi eq) Inherited from Inv_Store_Orders_Table.Store_Id |
Attribute Details
ATPBase
Indicates the quantity available to promise (in a base unit). It is valid from this date on. Unit: Product.BaseMeasurementCategory.BaseUnit Required
Type: Quantity (38, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
CurrentAvailabilityBase
The current availability in а base measurement unit. Unit: Product.BaseMeasurementCategory.BaseUnit Required
Type: Quantity (38, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
FromDate
Тhe date from which the available to promise quantity is valid. Required Filter(eq;ge;le)
Type: datetime
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
MovementsBase
The sum of the quantity of all planned stock movements on this date in а base measurement unit. . Unit: Product.BaseMeasurementCategory.BaseUnit Required
Type: Quantity (38, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
MovementsToDateBase
The sum of the quantity of all planned stock movements until this date (inclusive) in а base measurement unit. The value is cumulative. Unit: Product.BaseMeasurementCategory.BaseUnit Required
Type: Quantity (38, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ProjectedAvailabilityBase
Projected Availability in а base measurement unit on the particular date. The value is cumulative and includes the sum of all planned stock movements until this date (inclusive) and the current availability. Unit: Product.BaseMeasurementCategory.BaseUnit Required
Type: Quantity (38, 3)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Reference Details
EnterpriseCompany
Тhe Enterprise Company, for which the quantities are calculated. Required Filter(multi eq) Inherited from Gen_Documents_Table.Enterprise_Company_Id
Type: EnterpriseCompanies
Category: System
Inherited From: Gen_Documents_Table.Enterprise_Company_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
Lot
The Lot, for which the quantities are calculated. Filter(multi eq) Inherited from Inv_Store_Order_Lines_Table.Lot_Id
Type: Lots (nullable)
Category: System
Inherited From: Inv_Store_Order_Lines_Table.Lot_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
Product
The Product, for which the quantities are calculated. Required Filter(multi eq) Inherited from Inv_Store_Order_Lines_Table.Product_Id
Type: Products
Category: System
Inherited From: Inv_Store_Order_Lines_Table.Product_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
Store
The Store, for which the quantities are calculated. Required Filter(multi eq) Inherited from Inv_Store_Orders_Table.Store_Id
Type: Stores
Category: System
Inherited From: Inv_Store_Orders_Table.Store_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
API
Domain API Query: https://demodb.my.erp.net/api/domain/odata/Logistics_Inventory_DemandManagement_AvailableToPromiseByLots?$top=10
Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Logistics_Inventory_DemandManagement_AvailableToPromiseByLots?$top=10