Table Scm_Purchase_Order_Lines

Entity

Entity: Logistics.Procurement.PurchaseOrderLines

Contains detail lines of purchase orders. Entity: Scm_Purchase_Order_Lines

Owner Tables Hierarchy

• Scm_Purchase_Orders
• Gen_Documents

Summary

Name	Type	Description
Confirmed_Price_Per_Unit	decimal(14, 5)	The unit price that is confirmed by the supplier. NULL if there was no order confirmation.
Confirmed_Quantity	decimal(18, 3)	The quantity that is confirmed by the supplier. NULL if there was no order confirmation.
Confirmed_Quantity_Base	decimal(18, 3) Readonly	The theoretical equivalence of Confirmed Quantity in base measurement unit according to the current measurement dimensions of the product.
Confirmed_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. NULL means to convert the value from Confirmed Quantity using the measurement ratios.
Line_No	int
Lot_Id	uniqueidentifier	When not null, indicates that a specific lot is required to be delivered.
Notes	nvarchar(254)
Parent_Document_Id	uniqueidentifier
Parent_Line_No	int
Planned_Delivery_Date	datetime	The planned delivery date for this line.
Price_Per_Unit	decimal(14, 5)	The expected unit price of the ordered products, in the document currency.
Product_Code_Id	uniqueidentifier	When not NULL, specifies that the product was selected using the specified product code record.
Product_Description	nvarchar(254) ML	The name of the ordered product, initially copied from the name in the product definition. The field can be edited by the user.
Product_Id	uniqueidentifier	The ordered product.
Product_Variant_Id	uniqueidentifier	If specified determines which product variant of the current product in this line is used.
Purchase_Order_Id	uniqueidentifier
Purchase_Order_Line_Id	uniqueidentifier PK
Purchase_Product_Price_Id	uniqueidentifier	When not NULL, specifies that the purchase unit price is loaded automatically from the specified purchase price record.
Quantity	decimal(18, 3)	The quantity ordered.
Quantity_Base	decimal(18, 3) Readonly	The equivalence of Quantity, in the base measurement category of the product.
Quantity_Unit_Id	uniqueidentifier	The measurement unit of Quantity.
Requisition_Line_Id	uniqueidentifier	When not NULL, specifies that the current line is based on the specified requisition line.
Row_Version	timestamp
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.

Columns

Confirmed_Price_Per_Unit

The unit price that is confirmed by the supplier. NULL if there was no order confirmation.

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	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	decimal(14, 5) (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	no

Confirmed_Quantity

The quantity that is confirmed by the supplier. NULL if there was no order confirmation.

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	decimal(18, 3) (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	no

Confirmed_Quantity - Supported Filters

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

Confirmed_Quantity_Base

The theoretical equivalence of Confirmed Quantity in base measurement unit according to the current measurement dimensions of the product.

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

Confirmed_Standard_Quantity_Base

The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution. NULL means to convert the value from Confirmed Quantity using the measurement ratios.

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

Line_No

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

Lot_Id

When not null, indicates that a specific lot is required to be delivered.

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

Notes

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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	100
User Login	no
Visible	no

Parent_Document_Id

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_No

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

Planned_Delivery_Date

The planned delivery date for this 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	10
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	no

Planned_Delivery_Date - Supported Filters

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

Price_Per_Unit

The expected unit price of the ordered products, in the document currency.

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	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, 5) (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Product_Code_Id

When not NULL, specifies that the product was selected using the specified product code record.

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

Product_Code_Id - Supported Filters

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

Product_Description

The name of the ordered product, initially copied from the name in the product definition. The field can be edited by the user.

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	254
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	nvarchar(254) (MultiLanguage)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	no

Product_Description - Supported Filters

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

Product_Id

The ordered product.

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	Long
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	17
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

Purchase_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	7
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Scm_Purchase_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

Purchase_Order_Id - Supported Filters

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

Purchase_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	6
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

Purchase_Order_Line_Id - Supported Filters

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

Purchase_Product_Price_Id

When not NULL, specifies that the purchase unit price is loaded automatically from the specified purchase price record.

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

Purchase_Product_Price_Id - Supported Filters

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

Quantity

The quantity ordered.

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	3
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 - Supported Filters

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

Quantity_Base

The equivalence of Quantity, in the base measurement category of the product.

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

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

Requisition_Line_Id

When not NULL, specifies that the current line is based on the specified requisition line.

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

Requisition_Line_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	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	19
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

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