Vendor adapters/Whise/Persons
Persons
35 of 170 known Omnicasa columns mapped on this adapter. Open a mapped column to see how the value is determined.
| Expand | Column | Source | Transform | Entity | Config |
|---|---|---|---|---|---|
| AddressA | contacts.address1 | formula | Persons | formula | |
| AddressAGoogleXUnmapped | — | — | — | — | |
| AddressAGoogleYUnmapped | — | — | — | — | |
| AddressBUnmapped | — | — | — | — | |
| AddressTitle | contacts.contacttitleid | conditional | Persons | 0 case(s) | |
| AddressTypeUnmapped | — | — | — | — | |
| Alt2AddressAUnmapped | — | — | — | — | |
| Alt2AddressAGoogleXUnmapped | — | — | — | — | |
| Alt2AddressAGoogleYUnmapped | — | — | — | — | |
| Alt2AddressBUnmapped | — | — | — | — | |
| Alt2AddressTypeUnmapped | — | — | — | — | |
| Alt2BoxNrUnmapped | — | — | — | — | |
| Alt2CityNameUnmapped | — | — | — | — | |
| Alt2CityPostcodeUnmapped | — | — | — | — | |
| Alt2CountryUnmapped | — | — | — | — | |
| Alt2CountryCodeUnmapped | — | — | — | — | |
| Alt2ProvinceUnmapped | — | — | — | — | |
| AltAddressUnmapped | — | — | — | — | |
| AltAddressAUnmapped | — | — | — | — | |
| AltAddressAGoogleXUnmapped | — | — | — | — | |
| AltAddressAGoogleYUnmapped | — | — | — | — | |
| AltAddressBUnmapped | — | — | — | — | |
| AltAddressTypeUnmapped | — | — | — | — | |
| AltBoxNrUnmapped | — | — | — | — | |
| AltCityIDUnmapped | — | — | — | — | |
| AltCityNameUnmapped | — | — | — | — | |
| AltCityPostcodeUnmapped | — | — | — | — | |
| AltCountryUnmapped | — | — | — | — | |
| AltCountryCodeUnmapped | — | — | — | — | |
| AltFaxUnmapped | — | — | — | — | |
| AltPhoneUnmapped | — | — | — | — | |
| AltProvinceUnmapped | — | — | — | — | |
| AvailableAfterLoanUnmapped | — | — | — | — | |
| AvailableMoneyUnmapped | — | — | — | — | |
| BankA | contacts.bank | direct | Persons | — | |
| BankBUnmapped | — | — | — | — | |
| BICAUnmapped | — | — | — | — | |
| BICBUnmapped | — | — | — | — | |
| BirthDay | contacts.dateofbirth | direct | Persons | — | |
| BirthPlaceUnmapped | — | — | — | — | |
| BIVUnmapped | — | — | — | — | |
| BoxNr | contacts.box | direct | Persons | — | |
| BusinessReceiverIDUnmapped | — | — | — | — | |
| BusinessSenderIDUnmapped | — | — | — | — | |
| C21StatusUnmapped | — | — | — | — | |
| CardTypeUnmapped | — | — | — | — | |
| CardValidFromUnmapped | — | — | — | — | |
| CardValidUntilUnmapped | — | — | — | — | |
| CategoriesDescUnmapped | — | — | — | — | |
| CheckAUnmapped | — | — | — | — | |
| CheckBUnmapped | — | — | — | — | |
| CheckCUnmapped | — | — | — | — | |
| CheckDUnmapped | — | — | — | — | |
| ChipNumberUnmapped | — | — | — | — | |
| CityIDUnmapped | — | — | — | — | |
| CityName | contacts.city | direct | Persons | — | |
| CityPostcode | contacts.zip | direct | Persons | — | |
| Comment | contacts.comments | direct | Persons | — | |
| CompanyIdUnmapped | — | — | — | — | |
| CompanyName | contacts.companies_companydivisionlocation_company_name | direct | Persons | — | |
| CountryCodeUnmapped | — | — | — | — | |
| CountryDescUnmapped | — | — | — | — | |
| CountryID | contacts.countryid | conditional | Persons | 1 case(s) | |
| CountryID2Unmapped | — | — | — | — | |
| CountryID3Unmapped | — | — | — | — | |
| CustomStr1Unmapped | — | — | — | — | |
| CustomStr2Unmapped | — | — | — | — | |
| CustomStr3Unmapped | — | — | — | — | |
| CustomStr4Unmapped | — | — | — | — | |
| CustomStr5Unmapped | — | — | — | — | |
| CustomStr6Unmapped | — | — | — | — | |
| DepartmentIDUnmapped | — | — | — | — | |
| contacts.privateemail | direct | Persons | — | ||
| Email2 | contacts.businessemail | direct | Persons | — | |
| Email3Unmapped | — | — | — | — | |
| Entered | contacts.createdate | direct | Persons | — | |
| EnteredBy | contacts.representativeids_int | lookup | Persons | lookup Users | |
| EntryIDUnmapped | — | — | — | — | |
| ExternalIdUnmapped | — | — | — | — | |
| FacebookIDUnmapped | — | — | — | — | |
| FacebookInfoUnmapped | — | — | — | — | |
| Fax | contacts.fax | direct | Persons | — | |
| FirstBuyUnmapped | — | — | — | — | |
| FirstName | contacts.firstname | direct | Persons | — | |
| Func | contacts.function | direct | Persons | — | |
| GenderUnmapped | — | — | — | — | |
| HasPicUnmapped | — | — | — | — | |
| IDCardNumberUnmapped | — | — | — | — | |
| Ident | contacts.firstname | formula | Persons | formula | |
| IsDeleted | contacts.contactstatusid | conditional | Persons | 1 case(s) | |
| Lang | contacts.languageid | conditional | Persons | 3 case(s) | |
| LastChangeUnmapped | — | — | — | — | |
| LastChangedByUnmapped | — | — | — | — | |
| LetterTitle | contacts.contacttitleid | conditional | Persons | 0 case(s) | |
| LinkedinIDUnmapped | — | — | — | — | |
| LinkedInInfoUnmapped | — | — | — | — | |
| LinkedinToLinkUnmapped | — | — | — | — | |
| LoanLengthUnmapped | — | — | — | — | |
| LoanPercentUnmapped | — | — | — | — | |
| MediaPreference | contacts.contactid | constant | Persons | constant -1 | |
| MiddleNameUnmapped | — | — | — | — | |
| MobilePhone | contacts.privatemobile | direct | Persons | — | |
| ModifiedDate | contacts.contactid | constant | Persons | constant | |
| MoneyLentUnmapped | — | — | — | — | |
| MontlyPaymentsUnmapped | — | — | — | — | |
| Name | contacts.name | direct | Persons | — | |
| NationalityUnmapped | — | — | — | — | |
| NationalRegisterUnmapped | — | — | — | — | |
| NeverSendMailUnmapped | — | — | — | — | |
| NobleConditionUnmapped | — | — | — | — | |
| NoMailingsUnmapped | — | — | — | — | |
| NrPersonsUnmapped | — | — | — | — | |
| OrigID | contacts.contactid | direct | Persons | — | |
| OwnPropertyValueUnmapped | — | — | — | — | |
| PartnerBirthDayUnmapped | — | — | — | — | |
| PartnerFirstNameUnmapped | — | — | — | — | |
| PartnerLastNameUnmapped | — | — | — | — | |
| PasswordUnmapped | — | — | — | — | |
| PersonIDUnmapped | — | — | — | — | |
| PersonStatusUnmapped | — | — | — | — | |
| PhoneBusiness | contacts.businesstel | direct | Persons | — | |
| PhoneComment1Unmapped | — | — | — | — | |
| PhoneComment10Unmapped | — | — | — | — | |
| PhoneComment2Unmapped | — | — | — | — | |
| PhoneComment3Unmapped | — | — | — | — | |
| PhoneComment4Unmapped | — | — | — | — | |
| PhoneComment5Unmapped | — | — | — | — | |
| PhoneComment6Unmapped | — | — | — | — | |
| PhoneComment7Unmapped | — | — | — | — | |
| PhoneComment8Unmapped | — | — | — | — | |
| PhoneComment9Unmapped | — | — | — | — | |
| PhoneDesc1 | contacts.contactid | formula | Persons | formula | |
| PhoneDesc10Unmapped | — | — | — | — | |
| PhoneDesc2 | contacts.contactid | formula | Persons | formula | |
| PhoneDesc3Unmapped | — | — | — | — | |
| PhoneDesc4Unmapped | — | — | — | — | |
| PhoneDesc5Unmapped | — | — | — | — | |
| PhoneDesc6Unmapped | — | — | — | — | |
| PhoneDesc7Unmapped | — | — | — | — | |
| PhoneDesc8Unmapped | — | — | — | — | |
| PhoneDesc9Unmapped | — | — | — | — | |
| PhoneNumber1 | contacts.contactid | formula | Persons | formula | |
| PhoneNumber10Unmapped | — | — | — | — | |
| PhoneNumber2 | contacts.contactid | formula | Persons | formula | |
| PhoneNumber3Unmapped | — | — | — | — | |
| PhoneNumber4Unmapped | — | — | — | — | |
| PhoneNumber5Unmapped | — | — | — | — | |
| PhoneNumber6Unmapped | — | — | — | — | |
| PhoneNumber7Unmapped | — | — | — | — | |
| PhoneNumber8Unmapped | — | — | — | — | |
| PhoneNumber9Unmapped | — | — | — | — | |
| PhonePrivate | contacts.privatetel | direct | Persons | — | |
| PlaceOfIssueUnmapped | — | — | — | — | |
| PrefConfirmationUnmapped | — | — | — | — | |
| ProfessionUnmapped | — | — | — | — | |
| ProfessionC21Unmapped | — | — | — | — | |
| ProvinceUnmapped | — | — | — | — | |
| RCUnmapped | — | — | — | — | |
| RespUnmapped | — | — | — | — | |
| SendEmail2Unmapped | — | — | — | — | |
| SendEmail3Unmapped | — | — | — | — | |
| ShadowCompanyIDUnmapped | — | — | — | — | |
| SiteID | contacts.contactid | constant | Persons | constant -1 | |
| SourceIdUnmapped | — | — | — | — | |
| SpecialStatusUnmapped | — | — | — | — | |
| Title | contacts.contacttitleid | conditional | Persons | 0 case(s) | |
| TwoInComesUnmapped | — | — | — | — | |
| VATUnmapped | — | — | — | — | |
| WebModifiedUnmapped | — | — | — | — | |
| Website | contacts.website | direct | Persons | — |