The following Contact business objects are commonly used in contact-related queries. Review the descriptions to see how each can be joined with other business objects and what properties they include.
In This Article
Comparing the contact business objects
The following table goes over the differences between the contact-specific business objects.
Tip! ASI recommends using NetContactData for all queries requiring contact data.
What is a Contact Key?
A Contact Key is a unique identifier for contacts across any business object in iMIS. For example, a contact may have an ID of 1000, however, there may also be a GL Account with a code of 1000, a commerce product with a code of 1000, and so forth. A contact may have a Contact Key of 8B00A23E-9C15-41A2-A1F3-0007DB3AF5B9 that will only ever appear for that particular contact.
NetContactData
Contains name, primary mailing address, and contact information along with membership type, category and status. Contains both individual and organization records. Combo records are returned as one row (organization).
Common joins
Some common joins include:
| Business Object | Relation |
|---|---|
| CsActivity | NetContactData.Id = CsActivity.ID |
| CsCommitteeMember | NetContactData.Id = CsCommitteeMember.ID |
| CsRelationship |
NetContactData.Id = CsRelationship.ID |
| CsInvoice | NetContactData.Id = CsInvoice.Bt Id |
| CsSubscriptions | NetContactData.Id = CsSubscriptions.Id |
| CsOrders | NetContactData.Id = CsOrders.Ship to Id |
Properties
| Properties | |||
|---|---|---|---|
| AddressNumber1 | Fax | Prefix | CreatedOn |
| AddressNumber2 | FullAddress | PreviousMemberType | UpdatedByUserKey |
| AddressNumber3 | FunctionalTitle | SicCode | UpdatedOn |
| BarCode | Gender | SourceCode | AccessKey |
| BillAddressNum | HomePhone | StateHouse | FullName |
| BirthDate | Informal | StateProvince Note: It is recommended to use StateProvinceId rather than StateProvince when filtering in IQA queries. |
IsCompany |
| Category | IntentToEdit | StateSenate | Backorders |
| Chapter | JoinDate | Status | CreditLimit |
| CompanyId | LastFirst | Suffix | NoStatements |
| CompanyMemberType | LastName | Title | RenewMonths |
| Company | LastUpdated | UpdatedBy | RenewedThru |
| CompanySort | MailAddressNumber | UsCongress | DefaultTaxAuthority |
| ContactRank | MailCode | Website | TaxExempt |
| Country | MajorKey | WorkPhone | DefaultTermsCode |
| County | IsMember | Zip | VatExempt |
| Crrt | MemberStatus | FirstName | VatCountry |
| DateAdded | MemberStatusDate | City | VatRegNumber |
| Designation | MemberType | TollFree | ContactStatusCode |
| DupMatchKey | MiddleName | ShipAddressNum | SortName |
| MemberTypeChangeDate | ID | TaxIDNumber | |
| ExcludeDirectory | EntityCode | ContactKey | MobilePhone |
| ExcludeEmail | PaidThrough | CreatedByUserKey | BillToID |
| StateProvinceId Note: It is recommended to use StateProvinceId rather than StateProvince when filtering in IQA queries. |
|||
CsActivity
Contains all the information stored in traditional iMIS activities. These include calls or emails, meetings attended, dues history, product orders and committee membership among others. It will also contain any user defined activity types you have created. There are likely multiple rows per iMIS ID in this BO.
Activity is multi-purpose, so the fields you want to use in your queries will depend on the type of activity you are using. Some fields are used for certain purposes in one activity but may not be used the same for other types of activities, or not at all. Refer to the activity setup in the Advanced Accounting Console to better understand the setup.
Panel Editor creates a data source for each Activity, with the prompts you use for the fields, as the field names, making it easy to use.
Common joins
Some common joins include:
| Business Object | Relation |
|---|---|
| NetContactData | CsActivity.Id = NetContactData.Id |
| CsProductType | CsActivity.Activity Type = CsProductType.Prod Type |
Properties
| Properties | |||
|---|---|---|---|
| ActionCodes | MemberType | Sequence | UserField2 |
| ActivityType | NextInstallDate | SolicitorID | UserField3 |
| Amount | Note | SourceCode | UserField4 |
| CampaignCode | FollowUp | SourceSystem | UserField5 |
| Category | EntityCode | StatusCode | UserField6 |
| CompanyID | OtherCode | TaxableValue | UserField7 |
| Description | PayMethod | ThruDate | Units |
| EffectiveDate | ProductCode | ReminderDate | Originating_Trans_Num |
| GracePeriod | Quantity | TransactionDate | MemberTributeCode |
| ID | RecurringRequest | UserField1 | |
CsAddress
Contains all the address information for records in iMIS. There is likely multiple rows per iMIS ID in this BO, making it multi-instance.
Address contains multiple rows per record based on the number of addresses that have been entered. Querying will need to consider which specific address information you are looking for. NetContactData also contains address information which is a copy of the primary mailing address from CsAddress.
Common joins
Some common joins include:
| Business Object | Relation |
|---|---|
| NetContactData |
Primary billing address: CsAddress.Address Number = NetContactData.Bill Address Num |
| All address details: CsAddress.Id = NetContactData.Id |
Properties
| Properties | ||
|---|---|---|
| Address1 | CRRT | PreferredMail |
| Address2 | PreferredShip | |
| Address3 | Fax | AddressPurpose |
| AddressFormat | FullAddress | StateHouse |
| AddressNumber | ID | StatusProvince |
| BadAddress | LastUpdated | StateSenate |
| BarCode | LastVerified | UsCongress |
| City | MailCode | Zip |
| Country | Phone | |
| County | PreferredBill | |
CsNameLog
Contains standard iMIS change log details. There are likely multiple rows per iMIS ID in this BO, one row for each change recorded on the record. Log text contains lengthy change details which require parsing to get individual change details. Use Contains filters to search on this field.
Common joins
Some common joins include:
| Business Object | Relation |
|---|---|
| NetContactData | CsNameLog.Id = NetContactData.Id |
Properties
| Properties |
|---|
| Date_Time |
| ID |
| Log_Text |
| Log_Type |
| Sub_Type |
| User_Id |
CsRelationship
Stores relationships between two contacts. There is one row per relationship. This means there is likely multiple rows per iMIS ID. Commonly used to view relationships between two people and/or organizations.
Common joins
Some common joins include:
| Business Object | Relation |
|---|---|
| NetContactData |
CsRelationship.Id = NetContactData.Id |
| CsRelationshipTypes | CsRelationship.Relationship = CsRelationshipTypes.Relationship type |
Properties
| Properties | |||
|---|---|---|---|
| BeginDate | GroupCode | RelatedToID | Status |
| EndDate | ID | RelatedToName | Title |
| FunctionalTitle | Note | Relationship | |
| Properties |
|---|
| ContactMaster |
| EffectiveDate |
| ExpirationDate |
| IsDisabled |
| UpdateByUserKey |
| UpdatedOn |
| UserId |
| CreatedByUserKey |
| CreatedOn |
| UserKey |
| DefaultDepartmentGroupKey |
| DefaultPerspectiveKey |
| ProviderKey |
| MultiFactorInfo |