Table Reg_Jurisdictions

Entity

Represents a single coherent legal authority that governs a geographic or political area. Entity: Reg_Jurisdictions (Introduced in version 26.2.0.62)

Summary

Name	Type	Description
Code	`nvarchar(50)`	Short code of the jurisdiction (ISO-style preferrable).
Country_Code	`nvarchar(10)`	ISO country code (if applicable).
Currency_Sign	`nvarchar(10)`	Primary currency sign (if applicable).
Is_Active	`bit`	Specifies whether the jurisdiction is active.
Jurisdiction_Id	`uniqueidentifier` `PK`
Name	`nvarchar(254)` `ML`	Name of the jurisdiction.
Notes	`nvarchar(max)`	Notes for the jurisdiction.
Row_Version	`timestamp`
Valid_From	`date`	When not null specifies the first date when the jurisdiction is valid.
Valid_To	`date`	When not null specifies the last date (inclusive) when the jurisdiction is valid.

Columns

Code

Short code of the jurisdiction (ISO-style preferrable).

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	50
Order	1
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(50)
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

Country_Code

ISO country code (if 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	10
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(10)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Country_Code - Supported Filters

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

Currency_Sign

Primary currency sign (if 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	10
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	nvarchar(10)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Currency_Sign - Supported Filters

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

Is_Active

Specifies whether the jurisdiction is 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

Jurisdiction_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

Jurisdiction_Id - Supported Filters

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

Name

Name of the jurisdiction.

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	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	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 jurisdiction.

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

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

Valid_From

When not null specifies the first date when the jurisdiction is valid.

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

Valid_From - Supported Filters

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

Valid_To

When not null specifies the last date (inclusive) when the jurisdiction is valid.

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

Valid_To - Supported Filters

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

Table of Contents