Table of Contents

Table Gen_Party_Location_Numbers

Entity

Entity: General.Contacts.PartyLocationNumbers

Location numbers for a party. Depending on the partner with which we are doing an exchange, our location number might be different. Entity: Gen_Party_Location_Numbers (Introduced in version 19.1)

Owner Tables Hierarchy

Summary

Name Type Description
Location_Coding_System nvarchar(3) Allowed: GLN, INT The coding system for which we are defining the location number.
Location_Number nvarchar(16) The location number of Party.
Partner_Location_Number nvarchar(16) The location number of the partner party for which we define the main Party location number. The location number of the main Party might be different depending on the location number of the partner party. NULL means that the location number is not dependent on the partner location number.
Partner_Party_Id uniqueidentifier The party with which we are doing exchange. Depending on the Partner Party, the main Party might have different location number. NULL means that the location number is not dependent on the Partner Party.
Party_Id uniqueidentifier The party for which we are defining the location number.
Party_Location_Number_Id uniqueidentifier PK
Row_Version timestamp
Significance int Order of significance of the location number within the main Party. If there are multiple location numbers, only the most significant is used. 0 is the least significant and higher numbers indicate higher significance.

Columns

Location_Coding_System

The coding system for which we are defining the location number.

Property Value
Allowed Values GLN, INT
Auto Complete no
Data Filter no
Default Value GLN
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 nvarchar(3)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Location_Coding_System - Supported Filters

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

Location_Number

The location number of Party.

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 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable yes
Summary Type None
Supports EQUALS_IN yes
Type nvarchar(16)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Location_Number - Supported Filters

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

Partner_Location_Number

The location number of the partner party for which we define the main Party location number. The location number of the main Party might be different depending on the location number of the partner party. NULL means that the location number is not dependent on the partner location number.

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

Partner_Location_Number - Supported Filters

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

Partner_Party_Id

The party with which we are doing exchange. Depending on the Partner Party, the main Party might have different location number. NULL means that the location number is not dependent on the Partner Party.

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

Partner_Party_Id - Supported Filters

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

Party_Id

The party for which we are defining the location number.

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 yes

Party_Id - Supported Filters

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

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

Party_Location_Number_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

Significance

Order of significance of the location number within the main Party. If there are multiple location numbers, only the most significant is used. 0 is the least significant and higher numbers indicate higher significance.

Property Value
Auto Complete no
Data Filter no
Default Value 0
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 yes
Type int
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Significance - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
GreaterThanOrLessThan None no no
Suggest improvement to this page