dContactNarrow (new 2014-05-09)
| Based on (table.column) | Type | Column alias | Localised english name | Comment |
| contact.Contact Id | E | Contact Id | Nr. of companies | May be used for filtering by column filter. Not for display. |
| - | E | Total | Total | Used for grouping. Not for display. |
| contact.name | P | ContactName |
Company
|
The name of the company. |
| contact.department | P | ContactDepartment |
Department
|
The department. |
| contact.orgNr | P | orgNr |
Organization nr.
|
Organizational number. |
| contact.category_idx -> category.name | P |
CategoryName
|
Category name
|
Category. |
| contact.business_idx -> business.name | P |
BusinessName
|
Business
|
Business. |
|
person.firstname, person.middlename, person.lastname |
E | PersonName(FirstLast) | Sales person | Account manager. |
| contact.registered | P | Registered | Registered | Registered date. |
| contact.registered | P | Registered2 | Registered2 | Registered date. Used for pivoting / comparing this/last year. |
