Logistics.Inventory.StoreOrderLinesUnfulfilledView (View)
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.
General
Namespace: Logistics.Inventory
Repository: Logistics.Inventory.StoreOrderLinesUnfulfilledView
Introduced In Version: 21.1.1.16
API access: ReadWrite
Visualization
Display Format: {StoreOrderLineId}: {StoreOrderId}
Search Members:
Category: Views
Show in UI: HiddenByDefault
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 | boolean | 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 | boolean | 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=ISSUERequired 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. |
| Lot | Lots (nullable) | If non-null, contains the specific lot to use for the movement |
| Product | Products | The product which should be received/issued. |
| ProductVariant | ProductVariants (nullable) | If specified determines which product variant of the current product in this line is used. |
| SerialNumber | SerialNumbers (nullable) | Which serial number to receive/issue. NULL means that serial number is unknown or not applicable |
| Store | Stores | The designated warehouse for the operation. |
| StoreOrder | StoreOrders | Store Order |
| StoreOrderLine | StoreOrderLines (nullable) | The line, containing the ordered quantity, which this execution line executes. |
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: boolean
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: boolean
Category: System
Supported Filters: Equals, EqualsIn
Supports Order By: False
Show in UI: ShownByDefault
MovementType
Store order movement type. R=RECEIPT, I=ISSUERequired 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.
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
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.
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.
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
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.
Type: Stores
Category: System
Inherited From: Inv_Store_Orders_Table.Store_Id
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
StoreOrder
Store Order
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.
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 Entity Set: Logistics_Inventory_StoreOrderLinesUnfulfilledView
Domain API Entity Type: Logistics_Inventory_StoreOrderLinesUnfulfilledViewEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Logistics_Inventory_StoreOrderLinesUnfulfilledView?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Logistics_Inventory_StoreOrderLinesUnfulfilledView?$top=10