Logistics.Inventory.StoreOrderLinesUnfulfilledView View
Namespace: Logistics.Inventory
Returns the remaining (unfulfilled) quantity and cost for each Store Order Line in Store Orders, which are Planned, FirmPlanned or Released. Is_Fulfilled and Is_QuantityFulfilled can be used to filter out lines which appear fulfilled. For best performance, the store orders should be finished after fulfilling. Entity: Inv_Store_Order_Lines_Unfulfilled_View (Introduced in version 21.1.1.16)
Default Visualization
Default Display Text Format:
{StoreOrderLineId}: {StoreOrderId}
Default Search Members:
__
Category: Views
Show in UI: CannotBeShown
Aggregate
An aggregate is a cluster of domain objects that can be treated as a single unit.
Aggregate Tree
Attributes
| Name | Type | Description |
|---|---|---|
| DocumentDate | datetime | The date on which the document was issued. Required Default(Today) Filter(eq;ge;le) Inherited from Gen_Documents_Table.Document_Date |
| IsFulfilled | int32 | Returns 1/true when both the Quantity and Cost are fulfilled or only negligible (less than 0.001 for qty and 0.01 for cost) sums remain. Please note, that filtering by this fields forces full scan and calculation of remaining amounts for all non-finished store orders. For best performance, the store orders should be finished after fulfilling. Required Filter(multi eq) |
| IsQuantityFulfilled | int32 | Returns 1/true when the Quantity is fulfilled or only negligible (less than 0.001) sum remains. Please note, that filtering by this fields forces full scan and calculation of remaining amounts for all non-finished store orders. For best performance, the store orders should be finished after fulfilling. Required Filter(multi eq) |
| MovementType | MovementType | Store order movement type. R=RECEIPT, I=ISSUE. Required Default("R") Filter(multi eq) Inherited from Inv_Store_Orders_Table.Movement_Type |
| OrderRemainingLineCost | decimal (38, 2) | The remaining (unfulfilled) line cost of the order line. Required Filter(multi eq;ge;le) |
| OrderRemainingQuantityBase | decimal (38, 3) | The remaining (unfulfilled) quantity of the order line in base measurement unit. Required Filter(multi eq;ge;le) |
References
| Name | Type | Description |
|---|---|---|
| EnterpriseCompany | EnterpriseCompanies | The enterprise company which issued the document. Required Filter(multi eq) Inherited from Gen_Documents_Table.Enterprise_Company_Id |
| Lot | Lots (nullable) | If non-null, contains the specific lot to use for the movement. Filter(multi eq) Inherited from Inv_Store_Order_<br />Lines_Table.Lot_Id |
| Product | Products | The product which should be received/issued. Required Filter(multi eq) Inherited from Inv_Store_Order_<br />Lines_Table.Product_Id |
| ProductVariant | ProductVariants (nullable) | If specified determines which product variant of the current product in this line is used. Filter(multi eq) Inherited from Inv_Store_Order_<br />Lines_Table.Product_Variant_Id |
| SerialNumber | SerialNumbers (nullable) | Which serial number to receive/issue. null means that serial number is unknown or not applicable. Filter(multi eq) Inherited from Inv_Store_Order_<br />Lines_Table.Serial_Number_Id |
| Store | Stores | The designated warehouse for the operation. Required Filter(multi eq) Inherited from Inv_Store_Orders_Table.Store_Id |
| StoreOrder | StoreOrders | Store Order. Required Default(New Guid) Filter(multi eq) Inherited from Inv_Store_Orders_Table.Store_Order_Id Introduced in version 24.1.1.78 |
| StoreOrderLine | StoreOrderLines (nullable) | The line, containing the ordered quantity, which this execution line executes. Filter(multi eq) Inherited from Inv_Transaction_<br />Lines_Table.Parent_Store_Order_<br />Line_Id FilterableReference |
Attribute Details
DocumentDate
The date on which the document was issued. Required Default(Today) Filter(eq;ge;le) Inherited from Gen_Documents_Table.Document_Date
Type: datetime
Category: System
Inherited From: Gen_Documents_Table.Document_Date
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: False
Default Value: CurrentDate
Show in UI: ShownByDefault
IsFulfilled
Returns 1/true when both the Quantity and Cost are fulfilled or only negligible (less than 0.001 for qty and 0.01 for cost) sums remain. Please note, that filtering by this fields forces full scan and calculation of remaining amounts for all non-finished store orders. For best performance, the store orders should be finished after fulfilling. Required Filter(multi eq)
Type: int32
Category: System
Supported Filters: Equals, EqualsIn
Supports Order By: False
Show in UI: ShownByDefault
IsQuantityFulfilled
Returns 1/true when the Quantity is fulfilled or only negligible (less than 0.001) sum remains. Please note, that filtering by this fields forces full scan and calculation of remaining amounts for all non-finished store orders. For best performance, the store orders should be finished after fulfilling. Required Filter(multi eq)
Type: int32
Category: System
Supported Filters: Equals, EqualsIn
Supports Order By: False
Show in UI: ShownByDefault
MovementType
Store order movement type. R=RECEIPT, I=ISSUE. Required Default("R") Filter(multi eq) Inherited from Inv_Store_Orders_Table.Movement_Type
Type: MovementType
Category: System
Specifies the movement type (direction) of a warehouse document.
Allowed Values (Logistics.Inventory.MovementType Enum Members)
| Value | Description |
|---|---|
| Issue | Goods issue Database Value: 'I' Model Value: 0 Domain API Value: 'Issue' |
| Receipt | Goods receive Database Value: 'R' Model Value: 1 Domain API Value: 'Receipt' |
Inherited From: Inv_Store_Orders_Table.Movement_Type
Supported Filters: Equals, EqualsIn
Supports Order By: False
Default Value: Receipt
Show in UI: ShownByDefault
OrderRemainingLineCost
The remaining (unfulfilled) line cost of the order line. Required Filter(multi eq;ge;le)
Type: decimal (38, 2)
Category: System
Supported Filters: Equals, GreaterThanOrLessThan, EqualsIn
Supports Order By: False
Show in UI: ShownByDefault
OrderRemainingQuantityBase
The remaining (unfulfilled) quantity of the order line in base measurement unit. Required Filter(multi eq;ge;le)
Type: decimal (38, 3)
Category: System
Supported Filters: Equals, GreaterThanOrLessThan, EqualsIn
Supports Order By: False
Show in UI: ShownByDefault
Reference Details
EnterpriseCompany
The enterprise company which issued the document. 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
If non-null, contains the specific lot to use for the movement. 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 which should be received/issued. 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
ProductVariant
If specified determines which product variant of the current product in this line is used. Filter(multi eq) Inherited from Inv_Store_Order_Lines_Table.Product_Variant_Id
Type: ProductVariants (nullable)
Category: System
Inherited From: Inv_Store_Order_Lines_Table.Product_Variant_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
SerialNumber
Which serial number to receive/issue. null means that serial number is unknown or not applicable. Filter(multi eq) Inherited from Inv_Store_Order_Lines_Table.Serial_Number_Id
Type: SerialNumbers (nullable)
Category: System
Inherited From: Inv_Store_Order_Lines_Table.Serial_Number_Id
Supported Filters: Equals, EqualsIn
Show in UI: HiddenByDefault
Store
The designated warehouse for the operation. 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
StoreOrder
Store Order. Required Default(New Guid) Filter(multi eq) Inherited from Inv_Store_Orders_Table.Store_Order_Id Introduced in version 24.1.1.78
Type: StoreOrders
Category: System
Inherited From: Inv_Store_Orders_Table.Store_Order_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
StoreOrderLine
The line, containing the ordered quantity, which this execution line executes. Filter(multi eq) Inherited from Inv_Transaction_Lines_Table.Parent_Store_Order_Line_Id FilterableReference
Type: StoreOrderLines (nullable)
Category: System
Inherited From: Inv_Transaction_Lines_Table.Parent_Store_Order_Line_Id
Supported Filters: Equals, EqualsIn
Filterable Reference: True
Show in UI: ShownByDefault
API
Domain API Query: https://demodb.my.erp.net/api/domain/odata/Logistics_Inventory_StoreOrderLinesUnfulfilledView?$top=10
Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Logistics_Inventory_StoreOrderLinesUnfulfilledView?$top=10