Table Pos_Sale_Lines

Entity

Stores line-level details for items or services sold in a POS transaction. Each line is linked to a POS Sales record and typically represents a single product, quantity, and unit price. It supports complex tracking in environments like retail chains, restaurants, and service centers, including execution status for kitchen/service integration, discounts, and tax breakdowns. Entity: Pos_Sale_Lines (Introduced in version 25.1.3.46)

Owner Tables Hierarchy

Pos_Sales

Summary

Name	Type	Description
Created_At	`datetime`	The time when this line was created. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Created_By_Id	`uniqueidentifier`	The operator who created the line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Discount_Amount	`decimal(12, 2)`	The amount of discount applied to the line. Positive for normal sales, negative for refunds.
Execution_Area_Id	`uniqueidentifier`	Route items to the correct kitchen/bar section. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Execution_Changed_At	`datetime`	Indicates the time of the last execution status change. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Execution_Changed_By_Id	`uniqueidentifier`	Which staff member last updated the execution status. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Execution_Note	`nvarchar(64)`	Notes for the kitchen or service team, e.g., “no garlic”, “extra ice”, “medium rare”. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Execution_Resource_Id	`uniqueidentifier`	The resource (table, room, etc.) used to execute the current line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Execution_Stage	`char(3)` Allowed: `PND`, `PRP`, `DEL`, `FIN`	Execution status of the line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Execution_Status_Id	`uniqueidentifier`	User-configurable status of the process. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Is_Voided	`bit`	Specifies whether the current line was voided. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Line_Amount	`decimal(12, 2)`	Final total amount for the line after discount and tax. Positive for normal sales, negative for refunds.
Line_No	`int`	Line number within the POS sale.
Notes	`nvarchar(64)`	Notes for the line.
Pos_Sale_Id	`uniqueidentifier`	The main POS sale.
Pos_Sale_Line_Id	`uniqueidentifier` `PK`
Product_Id	`uniqueidentifier`	The sold product.
Quantity	`decimal(12, 3)`	The quantity sold (in Quantity Unit). Positive for normal sales, negative for returns.
Quantity_Base	`decimal(12, 3)`	Quantity sold in base measurement unit of the product. Positive for normal sales, negative for returns.
Quantity_Unit_Id	`uniqueidentifier`	Measurement unit of Quantity.
Row_Version	`timestamp`
Tax_Amount	`decimal(12, 2)`	Amount of tax (VAT) for this line. The tax amount is already included in Unit Price and Line Amount and is provided for reference. Positive for normal sales, negative for refunds.
Unit_Price	`decimal(12, 2)`	Gross price (incl. VAT if applicable) at the time of the sale. Should always by a positive number.
Voided_At	`datetime`	Time of voiding the line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).
Voided_By_Id	`uniqueidentifier`	Operator who voided the line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

Columns

Created_At

The time when this line was created. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

Property	Value
Auto Complete	no
Data Filter	no
Default Value	CurrentDateTime
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
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	datetime (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Created_At - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no
GreaterThanOrLessThan	None	no	no

Created_By_Id

The operator who created the line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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

Created_By_Id - Supported Filters

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

Discount_Amount

The amount of discount applied to the line. Positive for normal sales, negative for refunds.

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	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(12, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Discount_Amount - Supported Filters

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

Execution_Area_Id

Route items to the correct kitchen/bar section. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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
Referenced Table	Pos_Location_Areas
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

Execution_Area_Id - Supported Filters

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

Execution_Changed_At

Indicates the time of the last execution status change. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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

Execution_Changed_At - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no
GreaterThanOrLessThan	None	no	no

Execution_Changed_By_Id

Which staff member last updated the execution status. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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
Referenced Table	Pos_Operators
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

Execution_Changed_By_Id - Supported Filters

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

Execution_Note

Notes for the kitchen or service team, e.g., “no garlic”, “extra ice”, “medium rare”. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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

Execution_Note - Supported Filters

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

Execution_Resource_Id

The resource (table, room, etc.) used to execute the current line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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
Referenced Table	Pos_Execution_Resources
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

Execution_Resource_Id - Supported Filters

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

Execution_Stage

Execution status of the line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

Property	Value
Allowed Values	`PND`, `PRP`, `DEL`, `FIN`
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	3
Order	17
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	char(3) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Execution_Stage - Supported Filters

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

Execution_Status_Id

User-configurable status of the process. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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

Execution_Status_Id - Supported Filters

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

Is_Voided

Specifies whether the current line was voided. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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	yes

Is_Voided - Supported Filters

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

Line_Amount

Final total amount for the line after discount and tax. Positive for normal sales, negative for refunds.

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	decimal(12, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Line_Amount - Supported Filters

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

Line_No

Line number within the POS sale.

Property	Value
Auto Complete	no
Autoincrement	1
Data Filter	no
Default Value	None
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	int
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Line_No - Supported Filters

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

Notes

Notes for the 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	64
Order	11
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(64) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Notes - Supported Filters

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

Pos_Sale_Id

The main POS sale.

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	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Pos_Sales
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

Pos_Sale_Id - Supported Filters

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

Pos_Sale_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	0
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

Pos_Sale_Line_Id - Supported Filters

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

Product_Id

The sold 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	3
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

Quantity

The quantity sold (in Quantity Unit). Positive for normal sales, negative for returns.

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(12, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Quantity - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
GreaterThanOrLessThan	None	yes	no

Quantity_Base

Quantity sold in base measurement unit of the product. Positive for normal sales, negative for returns.

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	6
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(12, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Quantity_Base - Supported Filters

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

Quantity_Unit_Id

Measurement unit of Quantity.

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
Referenced Table	Gen_Measurement_Units
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

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

Tax_Amount

Amount of tax (VAT) for this line. The tax amount is already included in Unit Price and Line Amount and is provided for reference. Positive for normal sales, negative for refunds.

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	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(12, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Tax_Amount - Supported Filters

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

Unit_Price

Gross price (incl. VAT if applicable) at the time of the sale. Should always by a positive number.

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	7
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(12, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Unit_Price - Supported Filters

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

Voided_At

Time of voiding the line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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

Voided_At - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no
GreaterThanOrLessThan	None	no	no

Voided_By_Id

Operator who voided the line. Used only for businesses with real-time execution tracking (restaurants, bars, services, etc.).

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	no
Referenced Table	Pos_Operators
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

Voided_By_Id - Supported Filters

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

Table of Contents