View Inv_Store_Order_Lines_Unfulfilled_View
Entity
Entity: Logistics.Inventory.StoreOrderLinesUnfulfilledView
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)
Summary
| Name |
Type |
Description |
| Document_Date |
datetime |
The date on which the document was issued. |
| Enterprise_Company_Id |
uniqueidentifier |
The enterprise company which issued the document. |
| Is_Fulfilled |
bit |
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. |
| Is_QuantityFulfilled |
bit |
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. |
| Lot_Id |
uniqueidentifier |
If non-null, contains the specific lot to use for the movement |
| Movement_Type |
nvarchar(1) Allowed: I, R |
Store order movement type. R=RECEIPT, I=ISSUE |
| Order_Remaining_Line_Cost |
decimal(38, 2) |
The remaining (unfulfilled) line cost of the order line. |
| Order_Remaining_Quantity_Base |
decimal(38, 3) |
The remaining (unfulfilled) quantity of the order line in base measurement unit. |
| Product_Id |
uniqueidentifier |
The product which should be received/issued. |
| Product_Variant_Id |
uniqueidentifier |
If specified determines which product variant of the current product in this line is used. |
| Serial_Number_Id |
uniqueidentifier |
Which serial number to receive/issue. NULL means that serial number is unknown or not applicable |
| Store_Id |
uniqueidentifier |
The designated warehouse for the operation. |
| Store_Order_Id |
uniqueidentifier |
Store Order |
| Store_Order_Line_Id |
uniqueidentifier |
The line, containing the ordered quantity, which this execution line executes. |
Columns
Document_Date
The date on which the document was issued.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
CurrentDate |
| 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 |
Document_Date - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
| GreaterThanOrLessThan |
None |
yes |
no |
Enterprise_Company_Id
The enterprise company which issued the document.
| 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_Enterprise_Companies |
| 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 |
Enterprise_Company_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Is_Fulfilled
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.
| 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 |
yes |
| Type |
bit |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Is_Fulfilled - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
Is_QuantityFulfilled
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.
| 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 |
yes |
| Type |
bit |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Is_QuantityFulfilled - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
Lot_Id
If non-null, contains the specific lot to use for the movement
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Depends On |
Product_Id |
| Enter Stop |
no |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
17 |
| 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 |
Movement_Type
Store order movement type. R=RECEIPT, I=ISSUE
| Property |
Value |
| Allowed Values |
I, R |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
R |
| Enter Stop |
no |
| 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 |
nvarchar(1) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Movement_Type - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Order_Remaining_Line_Cost
The remaining (unfulfilled) line cost of the 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 |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
decimal(38, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Order_Remaining_Line_Cost - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
| GreaterThanOrLessThan |
None |
no |
no |
Order_Remaining_Quantity_Base
The remaining (unfulfilled) quantity of the order line in base measurement 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 |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
decimal(38, 3) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Order_Remaining_Quantity_Base - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
| GreaterThanOrLessThan |
None |
no |
no |
Product_Id
The product which should be received/issued.
| 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
If specified determines which product variant of the current product in this line is used.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Depends On |
Product_Id |
| 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 |
yes |
Serial_Number_Id
Which serial number to receive/issue. NULL means that serial number is unknown or not applicable
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
no |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
8 |
| 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 |
no |
Serial_Number_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
yes |
Store_Id
The designated warehouse for the operation.
| 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_Stores |
| 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 |
Store_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Store_Order_Id
Store Order
| 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 |
no |
| 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 |
yes |
Store_Order_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Store_Order_Line_Id
The line, containing the ordered quantity, which this execution line executes.
| Property |
Value |
| Auto Complete |
no |
| Base Table.Column |
Inv_Transaction_Lines.Parent_Store_Order_Line_Id |
| 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_Store_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 |
Store_Order_Line_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
yes |
no |