Table Crm_Customer_External_Access

Entity

Entity: Crm.Sales.CustomerExternalAccess

Defines the users permissions to specific customer data. Entity: Crm_Customer_External_Access (Introduced in version 25.1.2.51)

Owner Tables Hierarchy

Crm_Customers

Summary

Name	Type	Description
Customer_External_Access_Id	`uniqueidentifier` `PK`
Customer_Id	`uniqueidentifier`	The customer whose data is being accessed.
Days_Back_Access	`int`	The maximum number of past days the user is allowed to view. If NULL, the access is unlimited.
Notes	`nvarchar(max)`	Notes for this External Access.
Role	`char(3)` Allowed: `L10`, `L20`, `L30`, `L80`, `L90`	The role of the user, defines the granted access.
Row_Version	`timestamp`
Ship_To_Customer_Id	`uniqueidentifier`	The customers location, whose data is being accessed.
User_Id	`uniqueidentifier`	The user to whom the access is granted.

Columns

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

Customer_External_Access_Id - Supported Filters

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

Customer_Id

The customer whose data is being accessed.

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

Customer_Id - Supported Filters

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

Days_Back_Access

The maximum number of past days the user is allowed to view. If NULL, the access is unlimited.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	30
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

Days_Back_Access - Supported Filters

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

Notes

Notes for this External Access.

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

Role

The role of the user, defines the granted access.

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

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

Ship_To_Customer_Id

The customers location, whose data is being accessed.

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

Ship_To_Customer_Id - Supported Filters

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

User_Id

The user to whom the access is granted.

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

User_Id - Supported Filters

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

Table of Contents