Table Cm_Persons

Entity

Personal records. Requires related party record. Entity: Cm_Persons (Introduced in version 22.1.6.13)

Owner Tables Hierarchy

Gen_Parties

Summary

Name	Type	Description
Birth_Date	`datetime`	Birth date. NULL means unknown
City	`nvarchar(64)` `ML`	City from the legal registration address for the person
Creation_Time	`datetime` Readonly
Creation_User	`nvarchar(64)` Readonly
First_Name	`nvarchar(64)` `ML`	First name of the person.
Gender	`nvarchar(1)` Allowed: `F`, `M`, `O`, `N`	Person gender. M=Male;F=Female;O=Other;N=Prefer not to say;NULL=not known/not provided
Last_Name	`nvarchar(64)` `ML`	Last name of the person.
Middle_Name	`nvarchar(64)` `ML`	Middle name of the person.
National_Number	`nvarchar(16)`	Government assigned unique personal number. NULL means unknown
Nationality	`uniqueidentifier`	Person's nationality. NULL means the default (same as enterprise) nationality
Notes	`nvarchar(254)`	Internal notes for the person
Party_Id	`uniqueidentifier`	The Id of the party record for this person. The party stores the person's full name
Passport_Issuing_Date	`datetime`	Date of issuing the passport. NULL means unknown
Passport_Number	`nvarchar(14)`	Current passport number. NULL means unknown
Person_Id	`uniqueidentifier` `PK`	Unique person Id
Row_Version	`timestamp`
Title	`nvarchar(32)` `ML`	The persons title. It may be one of the standard titles - Mr., Mrs., etc., but it can also contains professional or academic qualification.
Update_Time	`datetime` Readonly
Update_User	`nvarchar(64)` Readonly

Columns

Birth_Date

Birth date. NULL means unknown

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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	datetime (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Birth_Date - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	yes	yes

City

City from the legal registration address for the person

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	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	nvarchar(64) (MultiLanguage) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

City - Supported Filters

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

Creation_Time

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	datetime (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Creation_Time - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	yes	yes

Creation_User

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	64
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(64) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	yes
Visible	no

Creation_User - Supported Filters

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

First_Name

First name of the person.

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

First_Name - Supported Filters

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

Gender

Person gender. M=Male;F=Female;O=Other;N=Prefer not to say;NULL=not known/not provided

Property	Value
Allowed Values	`F`, `M`, `O`, `N`
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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	nvarchar(1) (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Gender - Supported Filters

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

Last_Name

Last name of the person.

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

Last_Name - Supported Filters

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

Middle_Name

Middle name of the person.

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

Middle_Name - Supported Filters

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

National_Number

Government assigned unique personal number. NULL means unknown

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

National_Number - Supported Filters

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

Nationality

Person's nationality. NULL means the default (same as enterprise) nationality

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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
Referenced Table	Gen_Countries
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

Nationality - Supported Filters

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

Notes

Internal notes for the person

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

Party_Id

The Id of the party record for this person. The party stores the person's full name

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

Party_Id - Supported Filters

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

Passport_Issuing_Date

Date of issuing the passport. NULL means unknown

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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	datetime (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Passport_Issuing_Date - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	yes	yes

Passport_Number

Current passport number. NULL means unknown

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

Passport_Number - Supported Filters

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

Person_Id

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

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

Title

The persons title. It may be one of the standard titles - Mr., Mrs., etc., but it can also contains professional or academic qualification.

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

Update_Time

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	datetime (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Update_Time - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	yes	yes

Update_User

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	64
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(64) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	yes
Visible	no

Update_User - Supported Filters

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

Table of Contents