Table Pos_Execution_Resources
Entity
Entity: Crm.Pos.ExecutionResources
Defines physical or logical resources used to execute services or fulfill POS Sale Lines. This includes tables in a restaurant, rooms in a salon or clinic, training stations in a gym, or equipment in a workshop. Entity: Pos_Execution_Resources (Introduced in version 25.1.3.45)
Owner Tables Hierarchy
Summary
Name
Type
Description
Area_Id
uniqueidentifier
Area (zone) within the POS location, where the resource is located.
Capacity
int
Optional: number of simultaneous uses (e.g., seating for 4)
Code
nvarchar(16)
Unique (within the location) code of the resource. Used for display constrained devices, import/export matching, etc.
Is_Active
bit
Indicates whether the POS execution resource is currently active.
Location_Id
uniqueidentifier
The POS location where the resource is situated.
Name
nvarchar(254)
ML
Human readable resource name, e.g. "Table 5", "Room 58".
Notes
nvarchar(max)
Notes for the execution resource.
Pos_Execution_Resource_Id
uniqueidentifier
PK
Row_Version
timestamp
Columns
Area_Id
Area (zone) within the POS location, where the resource is located.
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
2
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
Area_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
Capacity
Optional: number of simultaneous uses (e.g., seating for 4)
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
int (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Capacity - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
GreaterThanOrLessThan
None
no
no
Code
Unique (within the location) code of the resource. Used for display constrained devices, import/export matching, 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
16
Order
3
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
yes
Summary Type
None
Supports EQUALS_IN
no
Type
nvarchar(16)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Code - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Like
None
no
no
Is_Active
Indicates whether the POS execution resource is currently active.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
True
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
bit
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Is_Active - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Location_Id
The POS location where the resource is situated.
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_Locations
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
Location_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Name
Human readable resource name, e.g. "Table 5", "Room 58".
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
254
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
nvarchar(254) (MultiLanguage)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Name - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Like
None
no
no
Notes
Notes for the execution resource.
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
2147483647
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
nvarchar(max) (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_Execution_Resource_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_Execution_Resource_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
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
timestamp
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no