Table of Contents

Table Pos_Execution_Statuses

Entity

Entity: Crm.Pos.ExecutionStatuses

Defines user-configurable status values that describe sub-stages within a broader, system-defined execution stage (ExecutionStage). This allows businesses to model their unique operational workflows — such as food prep steps, service sessions, or treatment progress. Entity: Pos_Execution_Statuses (Introduced in version 25.1.3.45)

Summary

Name Type Description
Code nvarchar(16) Unique short descriptive code of the user status. Used for display constrained devices, import/export matching, etc.
Enterprise_Company_Id uniqueidentifier
Execution_Stage char(3) Allowed: PND, PRP, DEL, FIN The system-defined stage under which is the current status.
Is_Active bit Indicates whether the POS execution status is currently active.
Location_Id uniqueidentifier When specified, means that the status applies only to the specified location. NULL means the status is applicable to all locations.
Name nvarchar(254) ML Name of the execution status. Should be action-oriented, e.g. reflect the NEXT action which should be taken (and not what is completed). For example, "Scheduled", "Ready-to-serve", etc.
Ord int The sort order of the status within the stage.
Pos_Execution_Status_Id uniqueidentifier PK When specified, means that the status applies only to the specified enterprise company. NULL means the status is applicable to all enterprise companies.
Row_Version timestamp

Columns

Code

Unique short descriptive code of the user status. 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

Enterprise_Company_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 1
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Enterprise_Companies
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

Enterprise_Company_Id - Supported Filters

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

Execution_Stage

The system-defined stage under which is the current status.

Property Value
Allowed Values PND, PRP, DEL, FIN
Auto Complete no
Data Filter no
Default Value PND
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 3
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 char(3)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Is_Active

Indicates whether the POS execution status 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 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 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

When specified, means that the status applies only to the specified location. NULL means the status is applicable to all locations.

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

Location_Id - Supported Filters

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

Name

Name of the execution status. Should be action-oriented, e.g. reflect the NEXT action which should be taken (and not what is completed). For example, "Scheduled", "Ready-to-serve", 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 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

Ord

The sort order of the status within the stage.

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 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 int
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Ord - Supported Filters

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

Pos_Execution_Status_Id

When specified, means that the status applies only to the specified enterprise company. NULL means the status is applicable to all enterprise companies.

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