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)
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.
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.
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
int
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
int
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