Table Pos_Sequence_Selectors

Entity

Maps point-of-sale context data to the appropriate sequence definition used for number generation. Entity: Pos_Sequence_Selectors (Introduced in version 26.2.1.31)

Summary

Name	Type	Description
Enterprise_Company_Id	`uniqueidentifier`	Identifies the company for which the sequence selection applies; null means the rule applies to all companies.
Notes	`nvarchar(max)`	Stores optional descriptive notes; null means no additional information is provided.
Pos_Device_Id	`uniqueidentifier`	Identifies the POS device used to determine the sequence; null means all devices are applicable.
Pos_Location_Id	`uniqueidentifier`	Identifies the POS location used in sequence selection; null means all locations are applicable.
Row_Version	`timestamp`	Used for concurrency control to track changes to the record.
Sale_Kind	`char(3)` Allowed: `SAL`, `RET`, `INV`, `CRN`	Specifies the type of sale that determines which sequence is selected.
Sequence_Id	`uniqueidentifier`	References the sequence definition selected for the given POS context.
Sequence_Selector_Id	`uniqueidentifier` `PK`	Unique identifier of the POS sequence selector record.

Columns

Enterprise_Company_Id

Identifies the company for which the sequence selection applies; null means the rule applies to all companies.

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

Notes

Stores optional descriptive notes; null means no additional information is provided.

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

Pos_Device_Id

Identifies the POS device used to determine the sequence; null means all devices are 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	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Pos_Devices
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

Pos_Device_Id - Supported Filters

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

Pos_Location_Id

Identifies the POS location used in sequence selection; null means all locations are 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	2147483647
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

Pos_Location_Id - Supported Filters

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

Row_Version

Used for concurrency control to track changes to the 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	2147483647
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

Sale_Kind

Specifies the type of sale that determines which sequence is selected.

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

Sale_Kind - Supported Filters

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

Sequence_Id

References the sequence definition selected for the given POS context.

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

Sequence_Id - Supported Filters

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

Sequence_Selector_Id

Unique identifier of the POS sequence selector record.

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

Sequence_Selector_Id - Supported Filters

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

Table of Contents