Table Inv_Store_Order_Lines

Entity

Entity: Logistics.Inventory.StoreOrderLines

Detail lines of store orders. Each line represents one planned stock transaction line, but can be executed in parts. E.g. many transaction lines can be bound to one order line. Entity: Inv_Store_Order_Lines

Owner Tables Hierarchy

• Inv_Store_Orders
• Gen_Documents

Summary

Name	Type	Description
For_Ordering	bit	Specifies that the quantity of the product can be less than free to use quantity, because the product will be supplied
Guarantee_Period_Days	int	Guarantee period in days for the offered product. NULL for non-serviced products
Line_Cost	decimal(14, 2)	Total cost for the line in the currency of the document. Equals Quantity * Unit_Cost
Line_No	int	Line number within the store order
Lot_Id	uniqueidentifier	If non-null, contains the specific lot to use for the movement
Lot_Number	nvarchar(16)	Obsolete. Not used.
Notes	nvarchar(254)
Parent_Document_Id	uniqueidentifier	The document, which the current line executes. NULL when the current line does not execute another line.
Parent_Line_Id	uniqueidentifier	Id of the line of the parent document, which generated the store order. NULL for user-entered store orders or if not applicable
Parent_Line_No	int	The number of the line within the parent document, which the current line executes. NULL when the current line does not execute parent line.
Persist_Lot	bit	If checked specifies that the lot in the line cannot be changed in the sub-documents created by the current document.
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.
Quantity	decimal(18, 3)	Quantity ordered for receipt/issue
Quantity_Base	decimal(18, 3) Readonly	Quantity in the base (default) measurement unit of the Item (calculated at the time of last update of the current store order line). Should be updated in parallel with each Quantity update
Quantity_Unit_Id	uniqueidentifier	The measurement unit of Quantity
Row_Version	timestamp
Sales_Order_Line_Id	uniqueidentifier	Sales order line which is managed by this store order line. When specified sales order line is used to make the margin analysis.
Serial_Number_Id	uniqueidentifier	Which serial number to receive/issue. NULL means that serial number is unknown or not applicable
Standard_Quantity_Base	decimal(18, 3) Readonly	The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution.
Store_Bin_Id	uniqueidentifier	From/to which store bin to issue/receive the products. NULL means that the store bin is unknown or not applicable
Store_Order_Id	uniqueidentifier
Store_Order_Line_Id	uniqueidentifier PK	Store order line Id
Transaction_Timestamp	datetime Readonly	Exact time when the transaction for this store order line changes the cost of the product
Unit_Cost	decimal(14, 5)	Cost for 1 unit of measure in the currency of the document

Columns

For_Ordering

Specifies that the quantity of the product can be less than free to use quantity, because the product will be supplied

Property	Value
Auto Complete	no
Data Filter	no
Default Value	False
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	14
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bit
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Guarantee_Period_Days

Guarantee period in days for the offered product. NULL for non-serviced products

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
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	int (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Line_Cost

Total cost for the line in the currency of the document. Equals Quantity * Unit_Cost

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	5
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(14, 2) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Line_No

Line number within the store order

Property	Value
Auto Complete	no
Autoincrement	10
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	0
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	int
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Line_No - 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	19
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	no

Lot_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	no

Lot_Number

Obsolete. Not used.

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	16
Order	9
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(16) (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	no

Notes

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	254
Order	12
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(254) (Allows NULL)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	no

Parent_Document_Id

The document, which the current line executes. NULL when the current line does not execute another 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	21
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Documents
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

Parent_Document_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	no

Parent_Line_Id

Id of the line of the parent document, which generated the store order. NULL for user-entered store orders or if not applicable

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	17
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 (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Parent_Line_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	no

Parent_Line_No

The number of the line within the parent document, which the current line executes. NULL when the current line does not execute parent 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	22
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	int (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Parent_Line_No - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	no

Persist_Lot

If checked specifies that the lot in the line cannot be changed in the sub-documents created by the current document.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	False
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	15
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bit
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Persist_Lot - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	yes

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	1
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	yes

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	20
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	no

Product_Variant_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	yes

Quantity

Quantity ordered for receipt/issue

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(18, 3)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Quantity_Base

Quantity in the base (default) measurement unit of the Item (calculated at the time of last update of the current store order line). Should be updated in parallel with each Quantity update

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	6
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(18, 3)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	no

Quantity_Unit_Id

The measurement unit of Quantity

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	3
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Measurement_Units
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Quantity_Unit_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	no

Row_Version

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	23
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Sales_Order_Line_Id

Sales order line which is managed by this store order line. When specified sales order line is used to make the margin analysis.

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	11
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Sales_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	no

Sales_Order_Line_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	no

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	10
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

Standard_Quantity_Base

The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution.

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	24
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(18, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Store_Bin_Id

From/to which store bin to issue/receive the products. NULL means that the store bin 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	7
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Inv_Store_Bins
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

Store_Bin_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	no

Store_Order_Id

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	18
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Inv_Store_Orders
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	100
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

Store order line Id

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	16
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
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	no

Store_Order_Line_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	no

Transaction_Timestamp

Exact time when the transaction for this store order line changes the cost of the product

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	13
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	datetime (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Transaction_Timestamp - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	no	no

Unit_Cost

Cost for 1 unit of measure in the currency of 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	4
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(14, 5) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes