dContact (new 2014-02-26)
| 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 | E | ContactName |
Company
|
The name of the company. |
| contact.department | E | ContactDepartment |
Department
|
The department. |
| contact.orgNr | E | orgNr |
Organization nr.
|
Organizational number. |
| contact.contact_id -> country.name | E | ContactsCountryName | Company's nationality | Nationality of company. |
| address.zip | E | ContactZip | Zip | Zip code of company. |
|
address.city
|
E |
ContactCity
|
City | Located in City. |
| address.state | E |
ContactState
|
State
|
Located in state. |
| address.address1 | E | ContactAddress1 |
Address
|
Address. |
| contact.category_idx -> category.name | E |
CategoryName
|
Category name
|
Category. |
| contact.business_idx -> business.name | E |
BusinessName
|
Business
|
Business. |
|
person.firstname, person.middlename, person.lastname |
E | PersonName(FirstLast) | Sales person | Account manager. |
| contact.contact_id | C | LinkContact | Company URL | Owl-link URL. Clicking on the owl brings up the company dialog. |
| sale.contact_id | C | Open | No. open | Open cases. |
| sale.contact_id | C | Won | No. won | Won cases. |
| sale.contact_id | C | Lost | No. lost | Lost cases. |
| sale.contact_id | C | Stalled | No. stalled | Stalled cases. |
| sale.contact_id | C | OpenAmount | Open amount | Total amount of open cases. |
| sale.contact_id | C | WonAmount | Won amount | Total amount of woncases. |
| sale.contact_id | C | LostAmount | Lost amount | Total amount of lostcases. |
| sale.contact_id | C | StalledAmount | Stalled amount | Total amount of stalledcases. |
| appointment.contact_id | C | Appointments | Nr. of activities | Nr. of activities. |
| appointment.contact_id | C | Documents | Nr. of documents | Nr. of documents. |
| ticket.cust_id | C | Open tickets | Open tickets | Open tickets. |
| ticket.cust_id | C | Closed tickets | Closed tickets | Closed tickets. |
| contact.registered | E | Registered | Registered | Registered date. |
| contact.registered | E | Registered2 | Registered2 | Registered date. Used for pivoting / comparing this/last year. |
| contact.updated | E | Updated | Updated | Updated date. |
| contact.updated | E | Updated2 |
Updated2
|
Updated date. Used for pivoting / comparing this/last year. |
| contact.number1 | E | number1 | number1 | number1 |
| contact.number2 | E | number2 | number2 | number2 |
| contact.associate_id | E | AssociateId |
AssociateId
|
Account managers associate_id. For filtering. |
| contact.associate_id -> associate.group_idx | E | UsergroupId |
UsergroupId
|
Account managers primary usergroup id. For filtering. |
