“MailingsShadowStaticSelectionV2”
This provider name is implemented by the classSupported Entities
| Name | Description |
|---|---|
| ”mailings” | Mailing |
Supported Columns
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| getAllRows | bool | GetAll: Get all rows of archive - use with care, you may be fetching the whole database | |
| getNoRows | bool | GetNone: Do not get any rows from the archive | |
| mailingId | int | ID: Displays the ID of the mailing | x |
| mailingFolderId | int | Hierarchy ID: Foreign key to hierarchy table | x |
| mailingSelectionId | int | Selection ID: The database ID of the selection | x |
| mailingDescription | string | Name: Displays the name of the mailing | x |
| mailingSent | listAny | Sent: Displays the sent status of the mailing | x |
| mailingSimpleStatus | listAny | Status: Status | x |
| mailingEndDate | date | Date sent: Displays the date when the mailing was sent (completed) | x |
| scheduledAt | date | Scheduled at: Scheduled at | x |
| mailingType | listAny | Type: Display the type of the mailing | x |
| mailingTypeId | None | Type: Display the type of the mailing | |
| mailingStatusId | int | Status: Status | |
| mailingConfiguration | int | Type: Display the type of the mailing | |
| mailingSubscriptionType | listAny | Subscription type: The subscription type for a mailing | x |
| mailingSentTo | int | Sent to: Displays to whom the mailing was sent | x |
| mailingOwner | associate | Owner: Displays the owner of the mailing | x |
| mailingFrom | string | From: Mailing from | x |
| mailingReplyTo | string | To: To | x |
| mailingSentCount | int | Number sent: Number of sent mailings | x |
| mailingOpenRate | decimal | Open rate: The open rate for a mailing | x |
| mailingClickRate | decimal | Click-through rate: Mailing click-through rate | x |
| mailingBounceRate | decimal | Bounce rate: Mailing bounce rate | x |
| mailingDeleted | bool | Deleted: Deleted | |
| recipientStatus | listAny | Recipient status: Status of mailing recipient | |
| thumbnail | None | Thumbnail | |
| icon | None | Category: Displays the icon for an activity type | x |
| date | date | Date: Displays start date of a follow-up / sale date of a sale | x |
| type | listAny | Type: Displays the type of an activity | x |
| text | positiveString | Text: Displays a descriptive text for the item | x |
| associateId | associate | ID: Displays the login ID of the associate who owns the activity. | x |
| contactId | listAny | Company ID: Database ID of company | x |
| personId | listAny | Contact ID: Database ID of the contact row | x |
| projectId | listAny | Project ID: Database ID of project record | x |
| updatedBy | associate | Updated by: The user who last updated the data | x |
| updatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
| registeredBy | associate | Registered by: The user who registered the data | x |
| registeredDate | date | Registered date: The date/time the data was registered in UTC. | x |
| recordTypeText | None | Activity type: The type of the activity (appointment, phone call, etc) | x |
| mailingAddr/mailingAddrId | int | !!!Mailing addr Id: !!!Mailing addr Id Tooltip | x |
| mailingAddr/contact/contactId | int | Company - Company ID: Database ID of company | x |
| mailingAddr/contact/name | stringorPK | Company - Company name | x |
| mailingAddr/contact/department | string | Company - Department | x |
| mailingAddr/contact/nameDepartment | string | Company - Company: Displays the company an activity is linked to | x |
| mailingAddr/contact/hasInfoText | bool | Company - Has note: Displays an icon indicating if there is additional information available about the contact | x |
| mailingAddr/contact/hasInterests | bool | Company - Has interests: Displays an Icon indicating if the contact has active interests | x |
| mailingAddr/contact/associateId | associate | Company - Our contact: Displays our contact | x |
| mailingAddr/contact/category | listAny | Company - Category | x |
| mailingAddr/contact/categoryGroup | listAny | Company - Category group | x |
| mailingAddr/contact/companyCategoryRank | int | Company - Category rank | x |
| mailingAddr/contact/business | listAny | Company - Business | x |
| mailingAddr/contact/country | listAny | Company - Country: This criterion corresponds to the Country field on the Company card. | x |
| mailingAddr/contact/countryId | int | Company - Country ID: Country ID | x |
| mailingAddr/contact/number | string | Company - Number | x |
| mailingAddr/contact/code | string | Company - Code | x |
| mailingAddr/contact/orgnr | string | Company - VAT No. | x |
| mailingAddr/contact/stop | bool | Company - Stop | x |
| mailingAddr/contact/contactNoMail | bool | Company - No mailings (company) | x |
| mailingAddr/contact/updatedBy | associate | Company - Updated by: The user who last updated the data | x |
| mailingAddr/contact/updatedByFullName | associate | Company - Updated by - Full name: The user who last updated the data | x |
| mailingAddr/contact/updatedDate | date | Company - Updated: The date/time the data was last updated in UTC. | x |
| mailingAddr/contact/registeredBy | associate | Company - Registered by: The user who registered the data | x |
| mailingAddr/contact/registeredByFullName | associate | Company - Registered by - Full name: The user who registered the data | x |
| mailingAddr/contact/registeredDate | date | Company - Registered date: The date/time the data was registered in UTC. | x |
| mailingAddr/contact/contactSource | listAny | Company - Source: Source (Company) | x |
| mailingAddr/contact/contactDeleted | bool | Company - Deleted: Deleted | x |
| mailingAddr/contact/phone/formattedNumber | string | Company - Phone: Displays phone number | |
| mailingAddr/contact/activeErpLinks | bool | Company - ERP connected: Is there an active ERP Sync? | x |
| mailingAddr/contact/deletedDate | datetime | Company - Deleted date: Deleted date | |
| mailingAddr/contact/mainContact | None | Company - Main contact: Main contact for this company | x |
| mailingAddr/contact/forceCompany | bool | Company - Dummy: Dummy | |
| mailingAddr/contact/contactPhone/formattedNumber | string | Company - Telephone - Phone: Displays phone number | |
| mailingAddr/contact/contactPhone/description | string | Company - Telephone - Description: Phone number description | x |
| mailingAddr/contact/contactFax/formattedNumber | string | Company - Fax - Phone: Displays phone number | |
| mailingAddr/contact/contactFax/description | string | Company - Fax - Description: Phone number description | x |
| mailingAddr/contact/searchPhone/formattedNumber | string | Company - Searchphone - Phone: Displays phone number | |
| mailingAddr/contact/searchPhone/description | string | Company - Searchphone - Description: Phone number description | x |
| mailingAddr/contact/email/emailProtocol | string | Company - Protocol: E-mail protocol, such as SMTP | x |
| mailingAddr/contact/email/emailAddress | string | Company - E-mail | x |
| mailingAddr/contact/email/emailDescription | string | Company - Description | x |
| mailingAddr/contact/email/emailId | int | Company - ID | x |
| mailingAddr/contact/email/emailLastSent | datetime | Company - Last sent: The date and time an e-mail was last sent to this address | x |
| mailingAddr/contact/email/emailBounceCount | int | Company - Bounce count: Bounce count for this e-mail address | x |
| mailingAddr/contact/email/emailLastBounce | datetime | Company - Last bounce: Date and time for last bounce to this e-mail address | x |
| mailingAddr/contact/email/emailHasBounced | bool | Company - Has bounced: This checkbox is active if delivery to this e-mail address has failed. | x |
| mailingAddr/contact/postAddress/addressId | int | Company - Postal address - Address ID: Database ID for the address record | x |
| mailingAddr/contact/postAddress/line1 | string | Company - Postal address - Address 1: First line of the address | x |
| mailingAddr/contact/postAddress/line2 | string | Company - Postal address - Address 2: Second line of the address | x |
| mailingAddr/contact/postAddress/line3 | string | Company - Postal address - Address 3: Third line of the address | x |
| mailingAddr/contact/postAddress/county | string | Company - Postal address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country’s address format. | x |
| mailingAddr/contact/postAddress/city | string | Company - Postal address - City: This criterion corresponds to the City field on the Company card. | x |
| mailingAddr/contact/postAddress/zip | string | Company - Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| mailingAddr/contact/postAddress/state | string | Company - Postal address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country’s address format. | x |
| mailingAddr/contact/postAddress/wgs84latitude | decimal | Company - Postal address - Latitude: Latitude | x |
| mailingAddr/contact/postAddress/wgs84longitude | decimal | Company - Postal address - Longitude: Longitude | x |
| mailingAddr/contact/postAddress/formattedAddress | None | Company - Postal address - : | |
| mailingAddr/contact/postAddress/formattedMultiLineAddress | None | Company - Postal address - : | |
| mailingAddr/contact/streetAddress/addressId | int | Company - Street address - Address ID: Database ID for the address record | x |
| mailingAddr/contact/streetAddress/line1 | string | Company - Street address - Address 1: First line of the address | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| mailingAddr/contact/streetAddress/line2 | string | Company - Street address - Address 2: Second line of the address | x |
| mailingAddr/contact/streetAddress/line3 | string | Company - Street address - Address 3: Third line of the address | x |
| mailingAddr/contact/streetAddress/county | string | Company - Street address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country’s address format. | x |
| mailingAddr/contact/streetAddress/city | string | Company - Street address - City: This criterion corresponds to the City field on the Company card. | x |
| mailingAddr/contact/streetAddress/zip | string | Company - Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| mailingAddr/contact/streetAddress/state | string | Company - Street address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country’s address format. | x |
| mailingAddr/contact/streetAddress/wgs84latitude | decimal | Company - Street address - Latitude: Latitude | x |
| mailingAddr/contact/streetAddress/wgs84longitude | decimal | Company - Street address - Longitude: Longitude | x |
| mailingAddr/contact/streetAddress/formattedAddress | None | Company - Street address - : | |
| mailingAddr/contact/streetAddress/formattedMultiLineAddress | None | Company - Street address - : | |
| mailingAddr/contact/restrictionAddress/addressId | int | Company - Search address - Address ID: Database ID for the address record | x |
| mailingAddr/contact/restrictionAddress/line1 | string | Company - Search address - Address 1: First line of the address | x |
| mailingAddr/contact/restrictionAddress/line2 | string | Company - Search address - Address 2: Second line of the address | x |
| mailingAddr/contact/restrictionAddress/line3 | string | Company - Search address - Address 3: Third line of the address | x |
| mailingAddr/contact/restrictionAddress/county | string | Company - Search address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country’s address format. | x |
| mailingAddr/contact/restrictionAddress/city | string | Company - Search address - City: This criterion corresponds to the City field on the Company card. | x |
| mailingAddr/contact/restrictionAddress/zip | string | Company - Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| mailingAddr/contact/restrictionAddress/state | string | Company - Search address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country’s address format. | x |
| mailingAddr/contact/restrictionAddress/wgs84latitude | decimal | Company - Search address - Latitude: Latitude | x |
| mailingAddr/contact/restrictionAddress/wgs84longitude | decimal | Company - Search address - Longitude: Longitude | x |
| mailingAddr/contact/restrictionAddress/formattedAddress | None | Company - Search address - : | |
| mailingAddr/contact/restrictionAddress/formattedMultiLineAddress | None | Company - Search address - : | |
| mailingAddr/contact/url/URLAddress | string | Company - URL | x |
| mailingAddr/contact/url/URLDescription | string | Company - Description | x |
| mailingAddr/contact/contactAssociate/firstName | string | Company - First name: Displays the contact’s first name | x |
| mailingAddr/contact/contactAssociate/lastName | string | Company - Last name: Displays the contact’s last name | x |
| mailingAddr/contact/contactAssociate/middleName | string | Company - Middle Name: Displays the contact’s middle name. | x |
| mailingAddr/contact/contactAssociate/fullName | string | Company - Full name: Displays full name of user (first, middle, last - according to settings) | x |
| mailingAddr/contact/contactAssociate/contactId | int | Company - Company ID: Database ID of the company the user belongs to | |
| mailingAddr/contact/contactAssociate/personId | int | Company - Contact ID: Database ID of the contact row | |
| mailingAddr/contact/contactAssociate/mrMrs | string | Company - Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| mailingAddr/contact/contactAssociate/title | string | Company - Title: Displays whether the contact is addressed as Mr or Ms | x |
| mailingAddr/contact/contactAssociate/associateDbId | associate | Company - ID | x |
| mailingAddr/contact/contactAssociate/contactName | string | Company - Owning company: Name of the company the user belongs to | x |
| mailingAddr/contact/contactAssociate/contactDepartment | string | Company - Owning department: Name of the department at the company the user belongs to | x |
| mailingAddr/contact/contactAssociate/usergroup | userGroup | Company - Primary group: The user’s primary user group | x |
| mailingAddr/contact/contactAssociate/usergroupId | int | Company - Group ID: The user’s primary user group | x |
| mailingAddr/contact/contactAssociate/contactFullName | string | Company - Owner: Name and department of the company the user belongs to | x |
| mailingAddr/contact/contactAssociate/contactCategory | listAny | Company - Category: Category | x |
| mailingAddr/contact/contactAssociate/role | listAny | Company - Role: Role | x |
| mailingAddr/contact/contactAssociate/assocName | associate | Company - User ID: User ID | x |
| mailingAddr/contact/contactAssociate/assocTooltip | string | Company - Description: Description | |
| mailingAddr/contact/contactAssociate/assocType | listAny | Company - Type: Type of user: associate, external user, system user, anonymous account | x |
| mailingAddr/contact/contactAssociate/ejUserId | int | Company - Service user ID: The database ID of a Service user | |
| mailingAddr/contact/contactAssociate/simultaneousEjUser | bool | Company - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| mailingAddr/contact/contactAssociate/ejDisplayName | string | Company - Nickname: User’s nickname in Service | x |
| mailingAddr/contact/contactAssociate/ejStatus | int | Company - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| mailingAddr/contact/contactAssociate/credentialType | None | Company - Auth. type: What type of credentials to use when this user logs in | x |
| mailingAddr/contact/contactAssociate/credentialDisplayValue | None | Company - Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| mailingAddr/contact/contactAssociate/isActive | bool | Company - Active: Is this user active, and should be able to log in? | x |
| mailingAddr/contact/contactAssociate/isActiveText | bool | Company - Active status: Is this user active, and should be able to log in? | x |
| mailingAddr/contact/contactAssociate/portraitThumbnail | None | Company - Person image: Person image | |
| mailingAddr/contact/contactAssociate/otherGroups | userGroup | Company - Other groups: Other groups | |
| mailingAddr/contact/contactAssociate/userName | string | Company - User name: User name | x |
| mailingAddr/contact/contactAssociate/personEmail | string | Company - E-mail | x |
| mailingAddr/contact/contactAssociate/locationAddress | string | Company - Location: Location | x |
| mailingAddr/contact/contactAssociate/isLocation | bool | Company - Is a location: Is a location | x |
| mailingAddr/contact/contactInterestIds | listInterest | Company - Company Interest: This criterion corresponds to the Interests tab on the Company card. | |
| mailingAddr/contact/contactUdef/SuperOffice:1 | string | Company - companyshorttext: tooltipshorttext | x |
| mailingAddr/contact/contactUdef/SuperOffice:2 | string | Company - companylongtext: tooltiplongtext | x |
| mailingAddr/contact/contactUdef/SuperOffice:3 | int | Company - companynumber | x |
| mailingAddr/contact/contactUdef/SuperOffice:4 | date | Company - companydate | x |
| mailingAddr/contact/contactUdef/SuperOffice:5 | unlimitedDate | Company - companyunlimiteddate: tooltipunlimiteddate | x |
| mailingAddr/contact/contactUdef/SuperOffice:6 | bool | Company - companycheckbox | x |
| mailingAddr/contact/contactUdef/SuperOffice:7 | listAny | Company - companydropdownlistbox | x |
| mailingAddr/contact/contactUdef/SuperOffice:8 | decimal | Company - companydecimal | x |
| mailingAddr/contact/contactUdef/SuperOffice:9 | string | Company - page1saleonly | x |
| mailingAddr/contact/contactUdef/SuperOffice:10 | string | Company - page1marketingonly | x |
| mailingAddr/contact/contactUdef/SuperOffice:11 | string | Company - page1adminonly | x |
| mailingAddr/contact/contactUdef/SuperOffice:12 | listAny | Company - Udlist one: Static tooltip for udlist one | x |
| mailingAddr/contact/contactUdef/SuperOffice:13 | listAny | Company - Udlist two: Static tooltip for udlist two | x |
| mailingAddr/contact/contactExtra/x_contact_integer | int | Company - Extra Integer: Custom integer field | x |
| mailingAddr/contact/contactExtra/x_contact_hidden_integer | int | Company - Extra hidden integer: Custom integer field - hidden | x |
| mailingAddr/contact/contactExtra/x_contact_default_integer | int | Company - Extra Default Integer: Custom integer field with default value 123. | x |
| mailingAddr/contact/contactExtra/x_contact_float | decimal | Company - Extra Float: Custom float field with 3 decimals | x |
| mailingAddr/contact/contactExtra/x_contact_longtext | string | Company - Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor | x |
| mailingAddr/contact/contactExtra/x_contact_dropdown | listAny | Company - Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc. | x |
| mailingAddr/contact/contactExtra/x_contact_date | date | Company - Extra date: Custom date field. User current as default. | x |
| mailingAddr/contact/contactExtra/x_contact_datetime | datetime | Company - Extra DateTime: Custom Date Time field. No default value. External | x |
| mailingAddr/contact/contactExtra/x_contact_time | None | Company - Extra time: Custom time field. | x |
| mailingAddr/contact/contactExtra/x_contact_boolean | bool | Company - Extra boolean: Custom boolean field. | x |
| mailingAddr/contact/contactExtra/x_contact_timespan | timeSpan | Company - Extra timespan: Custom timespan field. Hours and minutes in 10 units | x |
| mailingAddr/contact/contactExtra/x_contact_shorttext | string | Company - Extra short text: Custom short text field. Keep HTML tags. | x |
| mailingAddr/contact/contactExtra/x_contact_short_dropdown | listAny | Company - Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External. | x |
| mailingAddr/contact/contactExtra/x_contact_contact_relation | stringorPK | Company - Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons | x |
| mailingAddr/contact/contactExtra/x_contact_request_relation | stringorPK | Company - Extra Request relation: Request relation on company | x |
| mailingAddr/contact/contactExtra/x_contact_contact | stringorPK | Company - Extra contact relation: Contact relation on company | x |
| mailingAddr/contact/contactExtra/y_organization/x_name | string | Company - Organization - Name: Name | x |
| mailingAddr/contact/NumberOfActivities | int | Company - Number of activities | |
| mailingAddr/contact/NumberOfActivitiesInPeriod | int | Company - Number of activities in last 90 days | |
| mailingAddr/contact/NumberOfNotCompletedActivities | int | Company - Number of non-completed activities | |
| mailingAddr/contact/NumberOfNotCompletedActivitiesInPeriod | int | Company - Number of non-completed activities in last 90 days | |
| mailingAddr/contact/LastActivity | date | Company - Date of last activity | |
| mailingAddr/contact/LastCompletedActivity | date | Company - Date of last completed activity | |
| mailingAddr/contact/LastDoByActivity | date | Company - Date of last non-completed activity | |
| mailingAddr/contact/NumberOfSales | int | Company - Number of sales | |
| mailingAddr/contact/NumberOfSalesInPeriod | int | Company - Number of sales in last 90 days | |
| mailingAddr/contact/NumberOfNotCompletedSales | int | Company - Number of non-completed sales | |
| mailingAddr/contact/NumberOfNotCompletedSalesInPeriod | int | Company - Number of non-completed sales in last 90 days | |
| mailingAddr/contact/LastSale | date | Company - Date of last sale |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| mailingAddr/contact/LastCompletedSale | date | Company - Date of last completed sale | |
| mailingAddr/contact/LastDoBySale | date | Company - Date of last non-completed sale | |
| mailingAddr/contact/NumberOfTickets | int | Company - Number of requests | |
| mailingAddr/contact/NumberOfTicketsInPeriod | int | Company - Number of requests in last 90 days | |
| mailingAddr/contact/NumberOfNotCompletedTickets | int | Company - Number of non-completed requests | |
| mailingAddr/contact/NumberOfNotCompletedTicketsInPeriod | int | Company - Number of non-completed requests in last 90 days | |
| mailingAddr/contact/LastTicket | date | Company - Date of last request | |
| mailingAddr/contact/LastCompletedTicket | date | Company - Date of last completed request | |
| mailingAddr/contact/LastDoByTicket | date | Company - Date of last non-completed request | |
| mailingAddr/contact/SaintStatus1 | saintStatus | Company - Neglected customer: Denne kunden har det vært 0 salgsaktiviteter på i perioden. | |
| mailingAddr/contact/SaintStatus2 | saintStatus | Company - C-company: Kundens navn starter med bokstaven C | |
| mailingAddr/contact/saintSaleStatus | listAny | Company - With status | |
| mailingAddr/contact/saintAmountClass | listAny | Company - Amount class | |
| mailingAddr/contact/saintActivityType | listAny | Company - SAINT type | |
| mailingAddr/contact/saintDirection | listAny | Company - Direction | |
| mailingAddr/contact/saintIntention | listAny | Company - Intention | |
| mailingAddr/contact/saintTicketStatus | listAny | Company - Status | |
| mailingAddr/contact/saintTicketCategory | listAny | Company - Category | |
| mailingAddr/person/personId | int | Contact - DB ID: Displays the database ID of a contact | x |
| mailingAddr/person/firstName | string | Contact - First name: Displays the contact’s first name | x |
| mailingAddr/person/lastName | string | Contact - Last name: Displays the contact’s last name | x |
| mailingAddr/person/middleName | string | Contact - Middle name: Displays the contact’s middle name. | x |
| mailingAddr/person/fullName | string | Contact - Contact: Displays the contact to which an item is linked | x |
| mailingAddr/person/contactId | int | Contact - Company ID: Database ID of company | x |
| mailingAddr/person/hasInfoText | bool | Contact - Has note: Displays an icon indicating if there is additional information available about the contact | x |
| mailingAddr/person/hasInterests | bool | Contact - Has interests: Displays an Icon indicating if the contact has active interests | x |
| mailingAddr/person/personHasInterests | bool | Contact - Has interests: Displays an Icon indicating if the contact has active interests | x |
| mailingAddr/person/mrMrs | string | Contact - Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| mailingAddr/person/position | listAny | Contact - Position | x |
| mailingAddr/person/personNumber | string | Contact - Number: Displays the contact’s number | x |
| mailingAddr/person/title | string | Contact - Title: Displays the contact’s job title | x |
| mailingAddr/person/personCountry | listAny | Contact - Country: Country | x |
| mailingAddr/person/personCountryId | int | Contact - Country ID: Country ID | x |
| mailingAddr/person/personNoMail | bool | Contact - No Mailings: Displays the contact’s No Mailings checkbox | x |
| mailingAddr/person/rank | int | Contact - Rank: Displays a contact’s current rank | x |
| mailingAddr/person/birthdate | None | Contact - Birthdate: Displays the contact’s date of birth | |
| mailingAddr/person/associateType | None | Contact - User type: Displays an icon indicating if a contact is an associate or external contact with log-in rights and currently online. This information is updated only once while the archive is loading. | |
| mailingAddr/person/useAsMailingAddress | bool | Contact - Use as postal address: Use as postal address | x |
| mailingAddr/person/personSource | listAny | Contact - Source: Source (Contact) | x |
| mailingAddr/person/retired | bool | Contact - Former employee: Indicates whether the contact has retired/left the company | x |
| mailingAddr/person/birthYear | int | Contact - Birth year: Displays contact’s birth year | x |
| mailingAddr/person/birthMonth | int | Contact - Birth month: Displays contact’s birth month | x |
| mailingAddr/person/birthDay | int | Contact - Birth day: Displays contact’s birth day (day of month) | x |
| mailingAddr/person/kanaFirstName | string | Contact - First name, kana: Contact’s first name, in kana alphabet | x |
| mailingAddr/person/kanaLastName | string | Contact - Last name, kana: Contact’s last name, in kana alphabet | x |
| mailingAddr/person/personUpdatedBy | associate | Contact - Updated by: The user who last updated the data | x |
| mailingAddr/person/personUpdatedByFullName | associate | Contact - Updated by - Full name: The user who last updated the data | x |
| mailingAddr/person/personUpdatedDate | date | Contact - Updated: The date/time the data was last updated in UTC. | x |
| mailingAddr/person/personRegisteredBy | associate | Contact - Registered by: The user who registered the data | x |
| mailingAddr/person/personRegisteredByFullName | associate | Contact - Registered by - Full name: The user who registered the data | x |
| mailingAddr/person/personRegisteredDate | date | Contact - Registered date: The date/time the data was registered in UTC. | x |
| mailingAddr/person/portraitThumbnail | None | Contact - Person image: Person image | |
| mailingAddr/person/personActiveErpLinks | bool | Contact - ERP connected: Is there an active ERP Sync? | x |
| mailingAddr/person/ticketPriority | listAny | Contact - Service priority: Default service priority for this contact | x |
| mailingAddr/person/supportLanguage | listAny | Contact - Preferred language: Preferred language used for reply templates and more | x |
| mailingAddr/person/supportAssociate | associate | Contact - Our service contact: Default service contact for this contact | x |
| mailingAddr/person/supportAssociateFullName | associate | Contact - Our service contact - Full name: Default service contact for this contact | x |
| mailingAddr/person/personAssociateId | associate | Contact - Our contact: Displays our contact | x |
| mailingAddr/person/personAssociateFullName | associate | Contact - Our contact - Full name: Displays our contact | x |
| mailingAddr/person/personCategory | listAny | Contact - Category | x |
| mailingAddr/person/personCategoryGroup | listAny | Contact - Category group | x |
| mailingAddr/person/personCategoryRank | int | Contact - !!Category rank | x |
| mailingAddr/person/personBusiness | listAny | Contact - Business | x |
| mailingAddr/person/leadStatus | listAny | Contact - Lead status | x |
| mailingAddr/person/leadstatusRank | int | Contact - !!Lead status RANK | x |
| mailingAddr/person/personDeletedDate | datetime | Contact - Deleted date: Deleted date | |
| mailingAddr/person/hasCompany | bool | Contact - Has company: The contact is associated with a company | x |
| mailingAddr/person/isProjectMember | bool | Contact - Is project member: This person is a project member | x |
| mailingAddr/person/isStakeholder | bool | Contact - Is stakeholder: This person is a sale stakeholder | x |
| mailingAddr/person/updatedByWorkflow | listAny | Contact - Updated by flow: Updated by flow | x |
| mailingAddr/person/whenUpdatedByWorkflow | datetime | Contact - When updated by flow: When updated by flow | x |
| mailingAddr/person/createdByForm | listAny | Contact - Created by form: Created by form | x |
| mailingAddr/person/phone/formattedNumber | string | Contact - Phone: Displays phone number | |
| mailingAddr/person/personDirectPhone/formattedNumber | string | Contact - Direct - Phone: Displays phone number | |
| mailingAddr/person/personDirectPhone/description | string | Contact - Direct - Description: Phone number description | x |
| mailingAddr/person/personMobilePhone/formattedNumber | string | Contact - Mobile - Phone: Displays phone number | |
| mailingAddr/person/personMobilePhone/description | string | Contact - Mobile - Description: Phone number description | x |
| mailingAddr/person/personPrivate/formattedNumber | string | Contact - Private - Phone: Displays phone number | |
| mailingAddr/person/personPrivate/description | string | Contact - Private - Description: Phone number description | x |
| mailingAddr/person/personPager/formattedNumber | string | Contact - Other - Phone: Displays phone number | |
| mailingAddr/person/personPager/description | string | Contact - Other - Description: Phone number description | x |
| mailingAddr/person/personDirectFax/formattedNumber | string | Contact - Fax - Phone: Displays phone number | |
| mailingAddr/person/personDirectFax/description | string | Contact - Fax - Description: Phone number description | x |
| mailingAddr/person/searchPhone/formattedNumber | string | Contact - Phone: Displays phone number | |
| mailingAddr/person/searchPhone/description | string | Contact - Description: Phone number description | x |
| mailingAddr/person/personInfo/textId | int | Contact - Text ID | x |
| mailingAddr/person/personInfo/infoText | positiveString | Contact - Information: Displays the text entered in the description field | x |
| mailingAddr/person/email/emailProtocol | string | Contact - Protocol: E-mail protocol, such as SMTP | x |
| mailingAddr/person/email/emailAddress | string | Contact - E-mail | x |
| mailingAddr/person/email/emailDescription | string | Contact - Description | x |
| mailingAddr/person/email/emailId | int | Contact - ID | x |
| mailingAddr/person/email/emailLastSent | datetime | Contact - Last sent: The date and time an e-mail was last sent to this address | x |
| mailingAddr/person/email/emailBounceCount | int | Contact - Bounce count: Bounce count for this e-mail address | x |
| mailingAddr/person/email/emailLastBounce | datetime | Contact - Last bounce: Date and time for last bounce to this e-mail address | x |
| mailingAddr/person/email/emailHasBounced | bool | Contact - Has bounced: This checkbox is active if delivery to this e-mail address has failed. | x |
| mailingAddr/person/personUrl/URLAddress | string | Contact - URL | x |
| mailingAddr/person/personUrl/URLDescription | string | Contact - Description | x |
| mailingAddr/person/personAddress/addressId | int | Contact - Contact address - Address ID: Database ID for the address record | x |
| mailingAddr/person/personAddress/line1 | string | Contact - Contact address - Address 1: First line of the address | x |
| mailingAddr/person/personAddress/line2 | string | Contact - Contact address - Address 2: Second line of the address | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| mailingAddr/person/personAddress/line3 | string | Contact - Contact address - Address 3: Third line of the address | x |
| mailingAddr/person/personAddress/county | string | Contact - Contact address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country’s address format. | x |
| mailingAddr/person/personAddress/city | string | Contact - Contact address - City: This criterion corresponds to the City field on the Company card. | x |
| mailingAddr/person/personAddress/zip | string | Contact - Contact address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| mailingAddr/person/personAddress/state | string | Contact - Contact address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country’s address format. | x |
| mailingAddr/person/personAddress/wgs84latitude | decimal | Contact - Contact address - Latitude: Latitude | x |
| mailingAddr/person/personAddress/wgs84longitude | decimal | Contact - Contact address - Longitude: Longitude | x |
| mailingAddr/person/personAddress/formattedAddress | None | Contact - Contact address - : | |
| mailingAddr/person/personAddress/formattedMultiLineAddress | None | Contact - Contact address - : | |
| mailingAddr/person/restrictionAddress/addressId | int | Contact - Search address - Address ID: Database ID for the address record | x |
| mailingAddr/person/restrictionAddress/line1 | string | Contact - Search address - Address 1: First line of the address | x |
| mailingAddr/person/restrictionAddress/line2 | string | Contact - Search address - Address 2: Second line of the address | x |
| mailingAddr/person/restrictionAddress/line3 | string | Contact - Search address - Address 3: Third line of the address | x |
| mailingAddr/person/restrictionAddress/county | string | Contact - Search address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country’s address format. | x |
| mailingAddr/person/restrictionAddress/city | string | Contact - Search address - City: This criterion corresponds to the City field on the Company card. | x |
| mailingAddr/person/restrictionAddress/zip | string | Contact - Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| mailingAddr/person/restrictionAddress/state | string | Contact - Search address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country’s address format. | x |
| mailingAddr/person/restrictionAddress/wgs84latitude | decimal | Contact - Search address - Latitude: Latitude | x |
| mailingAddr/person/restrictionAddress/wgs84longitude | decimal | Contact - Search address - Longitude: Longitude | x |
| mailingAddr/person/restrictionAddress/formattedAddress | None | Contact - Search address - : | |
| mailingAddr/person/restrictionAddress/formattedMultiLineAddress | None | Contact - Search address - : | |
| mailingAddr/person/personInterestIds | listInterest | Contact - Contact interest: This criterion corresponds to a contact’s interests. It is available via the Contact dialog’s Interests tab. | |
| mailingAddr/person/personUdef/SuperOffice:1 | string | Contact - contactshorttext: tooltipshorttext | x |
| mailingAddr/person/personUdef/SuperOffice:2 | string | Contact - contactlongtext: tooltiplongtext | x |
| mailingAddr/person/personUdef/SuperOffice:3 | int | Contact - contactnumber | x |
| mailingAddr/person/personUdef/SuperOffice:4 | date | Contact - contactdate | x |
| mailingAddr/person/personUdef/SuperOffice:5 | unlimitedDate | Contact - contactunlimiteddate: tooltipunlimiteddate | x |
| mailingAddr/person/personUdef/SuperOffice:6 | bool | Contact - contactcheckbox | x |
| mailingAddr/person/personUdef/SuperOffice:7 | listAny | Contact - contactdropdownlistbox | x |
| mailingAddr/person/personUdef/SuperOffice:8 | decimal | Contact - contactdecimal | x |
| mailingAddr/person/personUdef/SuperOffice:9 | string | Contact - page1saleonly | x |
| mailingAddr/person/personUdef/SuperOffice:10 | string | Contact - page1marketingonly | x |
| mailingAddr/person/personUdef/SuperOffice:11 | string | Contact - page1adminonly | x |
| mailingAddr/person/personExtra/x_person_integer | int | Contact - Extra Integer: Custom person integer | x |
| mailingAddr/person/personExtra/x_person_hidden_integer | int | Contact - Extra hidden integer: Custom integer field that is hidden | x |
| mailingAddr/person/personExtra/x_person_float | decimal | Contact - Extra float: Custom float field | x |
| mailingAddr/person/personExtra/x_person_longtext | string | Contact - Extra Long Text: Custom long text field on person, keep HTML tags. Simple input, not text area. Default value = ‘Hello there’ | x |
| mailingAddr/person/personExtra/x_person_date | date | Contact - Extra date: Custom date field on person. Default value = 28.03.2019 | x |
| mailingAddr/person/personExtra/x_person_datetime | datetime | Contact - Extra DateTime: Custom person date and time field. No default | x |
| mailingAddr/person/personExtra/x_person_time | None | Contact - Extra time: Custom time field on person. Current time as default | x |
| mailingAddr/person/personExtra/x_person_boolean | bool | Contact - Extra Boolean: Custom boolean field on person. Default checked | x |
| mailingAddr/person/personExtra/x_person_timespan | timeSpan | Contact - Extra timespan: Custom timespan on person. Minutes only in 15 units | x |
| mailingAddr/person/personExtra/x_person_shorttext | string | Contact - Extra short text: Custom short text on person. With index. Do not keep HTML tags | x |
| mailingAddr/person/personExtra/x_person_shorttext_list | listAny | Contact - Extra short dropdown: Custom Short text dropdown field on person: black, white, transparent | x |
| mailingAddr/person/personExtra/x_person_user_relation | associate | Contact - Extra user relation: Custom person-user relation field | x |
| mailingAddr/person/personExtra/x_person_category_relation | listAny | Contact - Extra category relation: Custom person-category relation | x |
| mailingAddr/person/personExtra/x_person_priority_relation | listAny | Contact - Extra priority relation: Custom person-priority relation | x |
| mailingAddr/person/personExtra/x_person_request_relation | stringorPK | Contact - Extra request relation: Request relation on contact | x |
| mailingAddr/person/personExtra/x_person_appointment_relation | stringorPK | Contact - Extra appointment relation: Appointment relation on person | x |
| mailingAddr/person/personExtra/x_person_contact_relation | stringorPK | Contact - Extra company relation: Company relation on contact | x |
| mailingAddr/person/personExtra/y_rental/id | int | Contact - Rental - id: Displays the row’s primary key (y_rental) | x |
| mailingAddr/person/personExtra/y_rental/x_start | date | Contact - Rental - Start rental: Start rental | x |
| mailingAddr/person/personExtra/y_rental/x_end | date | Contact - Rental - End: End | x |
| mailingAddr/person/personExtra/y_rental/x_amount | int | Contact - Rental - Amount: Number to rent. Default = 1 | x |
| mailingAddr/person/personExtra/y_rental/x_contact | stringorPK | Contact - Rental - Renter: Company that rents equipment | x |
| mailingAddr/person/personExtra/y_rental/y_equipment/x_name | string | Contact - Rental - Equipment - Name: Equpment name custom field. Cannot be null., show in table | x |
| mailingAddr/person/personExtra/y_car/id | int | Contact - Car - id: Displays the row’s primary key (y_car) | x |
| mailingAddr/person/personAssociate/firstName | string | Contact - First name: Displays the contact’s first name | x |
| mailingAddr/person/personAssociate/lastName | string | Contact - Last name: Displays the contact’s last name | x |
| mailingAddr/person/personAssociate/middleName | string | Contact - Middle Name: Displays the contact’s middle name. | x |
| mailingAddr/person/personAssociate/fullName | string | Contact - Full name: Displays full name of user (first, middle, last - according to settings) | x |
| mailingAddr/person/personAssociate/contactId | int | Contact - Company ID: Database ID of the company the user belongs to | |
| mailingAddr/person/personAssociate/personId | int | Contact - Contact ID: Database ID of the contact row | |
| mailingAddr/person/personAssociate/mrMrs | string | Contact - Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| mailingAddr/person/personAssociate/title | string | Contact - Title: Displays whether the contact is addressed as Mr or Ms | x |
| mailingAddr/person/personAssociate/associateDbId | associate | Contact - ID | x |
| mailingAddr/person/personAssociate/contactName | string | Contact - Owning company: Name of the company the user belongs to | x |
| mailingAddr/person/personAssociate/contactDepartment | string | Contact - Owning department: Name of the department at the company the user belongs to | x |
| mailingAddr/person/personAssociate/usergroup | userGroup | Contact - Primary group: The user’s primary user group | x |
| mailingAddr/person/personAssociate/usergroupId | int | Contact - Group ID: The user’s primary user group | x |
| mailingAddr/person/personAssociate/contactFullName | string | Contact - Owner: Name and department of the company the user belongs to | x |
| mailingAddr/person/personAssociate/contactCategory | listAny | Contact - Category: Category | x |
| mailingAddr/person/personAssociate/role | listAny | Contact - Role: Role | x |
| mailingAddr/person/personAssociate/assocName | associate | Contact - User ID: User ID | x |
| mailingAddr/person/personAssociate/assocTooltip | string | Contact - Description: Description | |
| mailingAddr/person/personAssociate/assocType | listAny | Contact - Type: Type of user: associate, external user, system user, anonymous account | x |
| mailingAddr/person/personAssociate/ejUserId | int | Contact - Service user ID: The database ID of a Service user | |
| mailingAddr/person/personAssociate/simultaneousEjUser | bool | Contact - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| mailingAddr/person/personAssociate/ejDisplayName | string | Contact - Nickname: User’s nickname in Service | x |
| mailingAddr/person/personAssociate/ejStatus | int | Contact - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| mailingAddr/person/personAssociate/credentialType | None | Contact - Auth. type: What type of credentials to use when this user logs in | x |
| mailingAddr/person/personAssociate/credentialDisplayValue | None | Contact - Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| mailingAddr/person/personAssociate/isActive | bool | Contact - Active: Is this user active, and should be able to log in? | x |
| mailingAddr/person/personAssociate/isActiveText | bool | Contact - Active status: Is this user active, and should be able to log in? | x |
| mailingAddr/person/personAssociate/portraitThumbnail | None | Contact - Person image: Person image | |
| mailingAddr/person/personAssociate/otherGroups | userGroup | Contact - Other groups: Other groups | |
| mailingAddr/person/personAssociate/userName | string | Contact - User name: User name | x |
| mailingAddr/person/personAssociate/personEmail | string | Contact - E-mail | x |
| mailingAddr/person/personAssociate/locationAddress | string | Contact - Location: Location | x |
| mailingAddr/person/personAssociate/isLocation | bool | Contact - Is a location: Is a location | x |
| mailingAddr/person/correspondingAssociate/firstName | string | Contact - First name: Displays the contact’s first name | x |
| mailingAddr/person/correspondingAssociate/lastName | string | Contact - Last name: Displays the contact’s last name | x |
| mailingAddr/person/correspondingAssociate/middleName | string | Contact - Middle Name: Displays the contact’s middle name. | x |
| mailingAddr/person/correspondingAssociate/fullName | string | Contact - Full name: Displays full name of user (first, middle, last - according to settings) | x |
| mailingAddr/person/correspondingAssociate/contactId | int | Contact - Company ID: Database ID of the company the user belongs to | |
| mailingAddr/person/correspondingAssociate/personId | int | Contact - Contact ID: Database ID of the contact row | |
| mailingAddr/person/correspondingAssociate/mrMrs | string | Contact - Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| mailingAddr/person/correspondingAssociate/title | string | Contact - Title: Displays whether the contact is addressed as Mr or Ms | x |
| mailingAddr/person/correspondingAssociate/associateDbId | associate | Contact - ID | x |
| mailingAddr/person/correspondingAssociate/contactName | string | Contact - Owning company: Name of the company the user belongs to | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| mailingAddr/person/correspondingAssociate/contactDepartment | string | Contact - Owning department: Name of the department at the company the user belongs to | x |
| mailingAddr/person/correspondingAssociate/usergroup | userGroup | Contact - Primary group: The user’s primary user group | x |
| mailingAddr/person/correspondingAssociate/usergroupId | int | Contact - Group ID: The user’s primary user group | x |
| mailingAddr/person/correspondingAssociate/contactFullName | string | Contact - Owner: Name and department of the company the user belongs to | x |
| mailingAddr/person/correspondingAssociate/contactCategory | listAny | Contact - Category: Category | x |
| mailingAddr/person/correspondingAssociate/role | listAny | Contact - Role: Role | x |
| mailingAddr/person/correspondingAssociate/assocName | associate | Contact - User ID: User ID | x |
| mailingAddr/person/correspondingAssociate/assocTooltip | string | Contact - Description: Description | |
| mailingAddr/person/correspondingAssociate/assocType | listAny | Contact - Type: Type of user: associate, external user, system user, anonymous account | x |
| mailingAddr/person/correspondingAssociate/ejUserId | int | Contact - Service user ID: The database ID of a Service user | |
| mailingAddr/person/correspondingAssociate/simultaneousEjUser | bool | Contact - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| mailingAddr/person/correspondingAssociate/ejDisplayName | string | Contact - Nickname: User’s nickname in Service | x |
| mailingAddr/person/correspondingAssociate/ejStatus | int | Contact - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| mailingAddr/person/correspondingAssociate/credentialType | None | Contact - Auth. type: What type of credentials to use when this user logs in | x |
| mailingAddr/person/correspondingAssociate/credentialDisplayValue | None | Contact - Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| mailingAddr/person/correspondingAssociate/isActive | bool | Contact - Active: Is this user active, and should be able to log in? | x |
| mailingAddr/person/correspondingAssociate/isActiveText | bool | Contact - Active status: Is this user active, and should be able to log in? | x |
| mailingAddr/person/correspondingAssociate/portraitThumbnail | None | Contact - Person image: Person image | |
| mailingAddr/person/correspondingAssociate/otherGroups | userGroup | Contact - Other groups: Other groups | |
| mailingAddr/person/correspondingAssociate/userName | string | Contact - User name: User name | x |
| mailingAddr/person/correspondingAssociate/personEmail | string | Contact - E-mail | x |
| mailingAddr/person/correspondingAssociate/locationAddress | string | Contact - Location: Location | x |
| mailingAddr/person/correspondingAssociate/isLocation | bool | Contact - Is a location: Is a location | x |
| mailingAddr/person/isMailingRecipient | bool | Contact - Is mailing recipient: isMailingRecipient | x |
| mailingAddr/person/hasStoreConsent | bool | Contact - Consent - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers. | |
| mailingAddr/person/withdrawnStoreConsent | bool | Contact - Consent is withdrawn - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers. | |
| mailingAddr/person/hasEmarketingConsent | bool | Contact - Consent - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes. | |
| mailingAddr/person/withdrawnEmarketingConsent | bool | Contact - Consent is withdrawn - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes. | |
| mailingAddr/person/subscription | listAny | Contact - Subscription: Subscription for marketing | x |
| mailingAddr/person/legalBaseStore | listAny | Contact - Legal basis - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers. | x |
| mailingAddr/person/legalBaseEmarketing | listAny | Contact - Legal basis - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes. | x |
| mailingAddr/person/consentSourceStore | listAny | Contact - Source - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers. | x |
| mailingAddr/person/consentSourceEmarketing | listAny | Contact - Source - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes. | x |
| associate/firstName | string | First name: Displays the contact’s first name | x |
| associate/lastName | string | Last name: Displays the contact’s last name | x |
| associate/middleName | string | Middle Name : Displays the contact’s middle name. | x |
| associate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| associate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| associate/personId | int | Contact ID: Database ID of the contact row | |
| associate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| associate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| associate/associateDbId | associate | ID | x |
| associate/contactName | string | Owning company: Name of the company the user belongs to | x |
| associate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| associate/usergroup | userGroup | Primary group: The user’s primary user group | x |
| associate/usergroupId | int | Group ID: The user’s primary user group | x |
| associate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| associate/contactCategory | listAny | Category: Category | x |
| associate/role | listAny | Role : Role | x |
| associate/assocName | associate | User ID : User ID | x |
| associate/assocTooltip | string | Description : Description | |
| associate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| associate/ejUserId | int | Service user ID: The database ID of a Service user | |
| associate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| associate/ejDisplayName | string | Nickname: User’s nickname in Service | x |
| associate/ejStatus | int | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| associate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
| associate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| associate/isActive | bool | Active: Is this user active, and should be able to log in? | x |
| associate/isActiveText | bool | Active status: Is this user active, and should be able to log in? | x |
| associate/portraitThumbnail | None | Person image: Person image | |
| associate/otherGroups | userGroup | Other groups: Other groups | |
| associate/userName | string | User name: User name | x |
| associate/personEmail | string | x | |
| associate/locationAddress | string | Location: Location | x |
| associate/isLocation | bool | Is a location: Is a location | x |
| emailFlow/emailFlowId | int | E-mail flow ID: The database ID of the e-mail flow | x |
| emailFlow/emailFlowHierarchyId | int | Hierarchy ID: Foreign key to hierarchy table | x |
| emailFlow/shipmentType | listAny | Mailing type: Mailing type this e-mail flow represents | x |
| emailFlow/overrideConsentSubscription | bool | Override consent: Should consent subscriptions be overridden for this flow? | x |
| emailFlow/thumbnail | None | Thumbnail | |
| emailFlow/mediumThumbnail | None | Thumbnail | |
| emailFlow/workflowId | int | Flow id: Id of a flow definition | x |
| emailFlow/workflowName | string | Name: Name of the flow definition | x |
| emailFlow/workflowDescription | string | Description: Description of flow definition | x |
| emailFlow/workflowDefinitionStatus | listAny | Status: Status of the flow definition | x |
| emailFlow/workflowDefinitionStatusId | listAny | Status: Status of the flow definition | x |
| emailFlow/jumpToFinish | bool | Jump to finish: Should participant jump to finish when the goals are met? | x |
| emailFlow/startOnlyOnce | bool | Start only once: Should the participant enter the flow only once? | x |
| emailFlow/workflowEnrolledCount | None | Enrolled: How many times has a participant entered this flow? | |
| emailFlow/workflowInProgressCount | None | In progress: How many participants are in progress | |
| emailFlow/workflowCompletedCount | None | Completed: How many participants are completed | |
| emailFlow/workflowSucceededCount | None | Succeeded: How many participants have successfully completed the flow (goal criteria met)? | |
| emailFlow/workflowSuccessRate | None | Success rate: Success rate, based on goals criteria met | |
| emailFlow/updatedBy | associate | Updated by: The user who last updated the data | x |
| emailFlow/updatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
| emailFlow/registeredBy | associate | Registered by: The user who registered the data | x |
| emailFlow/registeredDate | date | Registered date: The date/time the data was registered in UTC. | x |
| emailFlow/workflowAssociate/firstName | string | Owner - First name: Displays the contact’s first name | x |
| emailFlow/workflowAssociate/lastName | string | Owner - Last name: Displays the contact’s last name | x |
| emailFlow/workflowAssociate/middleName | string | Owner - Middle Name: Displays the contact’s middle name. | x |
| emailFlow/workflowAssociate/fullName | string | Owner - Full name: Displays full name of user (first, middle, last - according to settings) | x |
| emailFlow/workflowAssociate/contactId | int | Owner - Company ID: Database ID of the company the user belongs to | |
| emailFlow/workflowAssociate/personId | int | Owner - Contact ID: Database ID of the contact row | |
| emailFlow/workflowAssociate/mrMrs | string | Owner - Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| emailFlow/workflowAssociate/title | string | Owner - Title: Displays whether the contact is addressed as Mr or Ms | x |
| emailFlow/workflowAssociate/associateDbId | associate | Owner - ID | x |
| emailFlow/workflowAssociate/contactName | string | Owner - Owning company: Name of the company the user belongs to | x |
| emailFlow/workflowAssociate/contactDepartment | string | Owner - Owning department: Name of the department at the company the user belongs to | x |
| emailFlow/workflowAssociate/usergroup | userGroup | Owner - Primary group: The user’s primary user group | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| emailFlow/workflowAssociate/usergroupId | int | Owner - Group ID: The user’s primary user group | x |
| emailFlow/workflowAssociate/contactFullName | string | Owner - Owner: Name and department of the company the user belongs to | x |
| emailFlow/workflowAssociate/contactCategory | listAny | Owner - Category: Category | x |
| emailFlow/workflowAssociate/role | listAny | Owner - Role: Role | x |
| emailFlow/workflowAssociate/assocName | associate | Owner - User ID: User ID | x |
| emailFlow/workflowAssociate/assocTooltip | string | Owner - Description: Description | |
| emailFlow/workflowAssociate/assocType | listAny | Owner - Type: Type of user: associate, external user, system user, anonymous account | x |
| emailFlow/workflowAssociate/ejUserId | int | Owner - Service user ID: The database ID of a Service user | |
| emailFlow/workflowAssociate/simultaneousEjUser | bool | Owner - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| emailFlow/workflowAssociate/ejDisplayName | string | Owner - Nickname: User’s nickname in Service | x |
| emailFlow/workflowAssociate/ejStatus | int | Owner - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| emailFlow/workflowAssociate/credentialType | None | Owner - Auth. type: What type of credentials to use when this user logs in | x |
| emailFlow/workflowAssociate/credentialDisplayValue | None | Owner - Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| emailFlow/workflowAssociate/isActive | bool | Owner - Active: Is this user active, and should be able to log in? | x |
| emailFlow/workflowAssociate/isActiveText | bool | Owner - Active status: Is this user active, and should be able to log in? | x |
| emailFlow/workflowAssociate/portraitThumbnail | None | Owner - Person image: Person image | |
| emailFlow/workflowAssociate/otherGroups | userGroup | Owner - Other groups: Other groups | |
| emailFlow/workflowAssociate/userName | string | Owner - User name: User name | x |
| emailFlow/workflowAssociate/personEmail | string | Owner - E-mail | x |
| emailFlow/workflowAssociate/locationAddress | string | Owner - Location: Location | x |
| emailFlow/workflowAssociate/isLocation | bool | Owner - Is a location: Is a location | x |
| emailFlow/hierarchyId | int | Hierarchy ID: Foreign key to hierarchy table | x |
| emailFlow/hierarchyFullname | string | Hierarchy name: The full name/path from table hierarchy | x |
| emailFlow/hierarchyName | string | Hierarchy name: The full name/path from table hierarchy | x |
| emailFlow/hierarchyParentId | int | Hierarchy ID: Foreign key to hierarchy table | x |
| emailFlow/hierarchyFullpathIds | None | Folder path IDs: An integer array of nodes leading to a hierarchy/folder item, in root => leaf order | |
| project/completed | bool | Completed: Displays a check mark indicating if the project has been completed. | x |
| project/projectId | int | DB ID: Displays the database ID for a project row | x |
| project/name | stringorPK | Project name: Displays the Project’s name | x |
| project/number | string | Number: Displays the project’s number | x |
| project/type | listAny | Project type: Displays the project’s type | x |
| project/status | listAny | Status: Displays the project’s status | x |
| project/statusRank | None | Status rank: Rank of the project status in the status list | x |
| project/associateId | associate | ID: Displays login ID of the associate who owns the project | x |
| project/hasInfoText | bool | Info: Displays an icon indicating if the project has a description text. The text itself will be displayed in a tooltip. | x |
| project/icon | None | Category: Displays the icon for an activity type | x |
| project/text | string | Text: Displays a descriptive text for the item | x |
| project/description | string | Description : Description | x |
| project/updatedBy | associate | Updated by: The user who last updated the data | x |
| project/updatedByFullName | associate | Updated by - Full name: The user who last updated the data | x |
| project/updatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
| project/registeredBy | associate | Registered by: The user who registered the data | x |
| project/registeredByFullName | associate | Registered by - Full name: The user who registered the data | x |
| project/registeredDate | date | Registered date: The date/time the data was registered in UTC. | x |
| project/hasGuide | bool | Guided: Does this sale have a Sales Guide | x |
| project/nextMilestone | date | Next milestone: Date of next non-completed activity that is marked as a milestone | x |
| project/endDate | date | End date: End date of project | x |
| project/imageThumbnail | None | Thumbnail: Scaled-down image of project image | |
| project/activeErpLinks | bool | ERP connected: Is there an active ERP Sync? | x |
| project/eventId | int | Event ID: Event ID | x |
| project/startDate | date | Start date: Project start date | x |
| project/projectPublish/isPublished | bool | Published: Displays an icon indicating if the project or sale has been published | x |
| project/projectPublish/publishedFrom | date | From date: Start date for publishing. The record will not be visible prior to this date | x |
| project/projectPublish/publishedTo | date | To date: End date for publishing. The record will not be visible after this date | x |
| project/projectPublish/publishedBy | None | Published by: Published by | |
| project/projectEvent/isExternalEvent | bool | Event: Is this an external event | x |
| project/projectEvent/eventDate | date | Event date: Event date | x |
| project/projectEvent/hasSignOn | bool | Sign On: Does this event have the Sign On function enabled | x |
| project/projectEvent/hasSignOff | bool | Sign Off: Does this event have the Sign Off function enabled | x |
| project/projectUrl/URLAddress | string | URL | x |
| project/projectUrl/URLDescription | string | Description | x |
| project/projectAssociate/firstName | string | First name: Displays the contact’s first name | x |
| project/projectAssociate/lastName | string | Last name: Displays the contact’s last name | x |
| project/projectAssociate/middleName | string | Middle Name : Displays the contact’s middle name. | x |
| project/projectAssociate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| project/projectAssociate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| project/projectAssociate/personId | int | Contact ID: Database ID of the contact row | |
| project/projectAssociate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| project/projectAssociate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| project/projectAssociate/associateDbId | associate | ID | x |
| project/projectAssociate/contactName | string | Owning company: Name of the company the user belongs to | x |
| project/projectAssociate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| project/projectAssociate/usergroup | userGroup | Primary group: The user’s primary user group | x |
| project/projectAssociate/usergroupId | int | Group ID: The user’s primary user group | x |
| project/projectAssociate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| project/projectAssociate/contactCategory | listAny | Category: Category | x |
| project/projectAssociate/role | listAny | Role : Role | x |
| project/projectAssociate/assocName | associate | User ID : User ID | x |
| project/projectAssociate/assocTooltip | string | Description : Description | |
| project/projectAssociate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| project/projectAssociate/ejUserId | int | Service user ID: The database ID of a Service user | |
| project/projectAssociate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| project/projectAssociate/ejDisplayName | string | Nickname: User’s nickname in Service | x |
| project/projectAssociate/ejStatus | int | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| project/projectAssociate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
| project/projectAssociate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| project/projectAssociate/isActive | bool | Active: Is this user active, and should be able to log in? | x |
| project/projectAssociate/isActiveText | bool | Active status: Is this user active, and should be able to log in? | x |
| project/projectAssociate/portraitThumbnail | None | Person image: Person image | |
| project/projectAssociate/otherGroups | userGroup | Other groups: Other groups | |
| project/projectAssociate/userName | string | User name: User name | x |
| project/projectAssociate/personEmail | string | x | |
| project/projectAssociate/locationAddress | string | Location: Location | x |
| project/projectAssociate/isLocation | bool | Is a location: Is a location | x |
| project/projectUdef/SuperOffice:1 | string | projectshorttext | x |
| project/projectUdef/SuperOffice:2 | string | projectlongtext | x |
| project/projectUdef/SuperOffice:3 | int | projectnumber | x |
| project/projectUdef/SuperOffice:4 | date | projectdate | x |
| project/projectUdef/SuperOffice:5 | unlimitedDate | projectunlimiteddate | x |
| project/projectUdef/SuperOffice:6 | bool | projectcheckbox | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| project/projectUdef/SuperOffice:7 | listAny | projectdropdownlistbox | x |
| project/projectUdef/SuperOffice:8 | decimal | projectdecimal | x |
| project/projectUdef/SuperOffice:9 | int | page1saleandmarketing | x |
| project/projectUdef/SuperOffice:10 | int | page1saleandadmin | x |
| project/NumberOfActivities | int | Number of activities | |
| project/NumberOfActivitiesInPeriod | int | Number of activities in last 90 days | |
| project/NumberOfNotCompletedActivities | int | Number of non-completed activities | |
| project/NumberOfNotCompletedActivitiesInPeriod | int | Number of non-completed activities in last 90 days | |
| project/LastActivity | date | Date of last activity | |
| project/LastCompletedActivity | date | Date of last completed activity | |
| project/LastDoByActivity | date | Date of last non-completed activity | |
| project/NumberOfSales | int | Number of sales | |
| project/NumberOfSalesInPeriod | int | Number of sales in last 90 days | |
| project/NumberOfNotCompletedSales | int | Number of non-completed sales | |
| project/NumberOfNotCompletedSalesInPeriod | int | Number of non-completed sales in last 90 days | |
| project/LastSale | date | Date of last sale | |
| project/LastCompletedSale | date | Date of last completed sale | |
| project/LastDoBySale | date | Date of last non-completed sale | |
| project/SaintStatus3 | saintStatus | Not completed activites with intention sale: Number of not completed activities for intention sale > 0. | |
| project/saintSaleStatus | listAny | With status | |
| project/saintAmountClass | listAny | Amount class | |
| project/saintActivityType | listAny | SAINT type | |
| project/saintDirection | listAny | Direction | |
| project/saintIntention | listAny | Intention | |
| project/saintTicketStatus | listAny | Status | |
| project/saintTicketCategory | listAny | Category | |
| project/project/textId | int | Text ID | x |
| project/project/infoText | positiveString | Information: Displays the text entered in the description field | x |
| historyRank | int | Rank: Rank of list item, if available | x |
| selectionId | int | Selection ID: The database ID of the selection | |
| selectionMemberId | int | Selection member ID: The database ID of the selection member record | |
| rowKind | None | Icon indicating whether the row comes from a static or a dynamic selection | |
| targetTableNumber | int | TargetTableNumber: TargetTableNumber | x |
| targetRecordId | int | TargetRecordId: TargetRecordId | x |
Sample
GET /api/v1/archive/MailingsShadowStaticSelectionV2?$select=mailingOpenRate,mailingAddr/contact/updatedBy,mailingAddr/contact/restrictionAddress/addressId,mailingAddr/contact/saintAmountClass,mailingAddr/person/firstName
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv