Table 344. Contact Integration Component and Integration Component Fields
|
|
|
|
|
|
IC: Contact |
Alias |
Alias |
Text |
50 |
No |
None |
Assistant |
Assistant |
Text |
50 |
No |
None |
Assistant Phone # |
AssistantPhone |
Text |
40 |
No |
None |
Best Call Time |
BestCallTime |
Text |
30 |
No |
Bound by FINCORP_CONTACT_CALL_TIME |
Cellular Phone # |
CellularPhone |
Text |
40 |
No |
None |
Customer Value |
CustomerValue |
Text |
30 |
No |
Bound by FIN_CON_VALUE_TYPE |
Date of Birth |
DateofBirth |
Date |
7 |
No |
None |
Email Address |
EmailAddress |
Text |
50 |
No |
None |
Email Address 2 |
EmailAddress2 |
Text |
50 |
No |
None |
Fax Phone # |
FaxPhone |
Text |
40 |
No |
None |
First Name |
FirstName |
Text |
50 |
Yes |
None |
Home Phone # |
HomePhone |
Text |
40 |
No |
None |
Id |
Id |
Id |
15 |
Yes |
This tag is required for ID cross-referencing. It stores the incoming external ID. |
Income |
Income |
Currency |
22 |
No |
None |
Income Currency Code |
IncomeCurrencyCode |
Text |
20 |
No |
Used for determining a related entity. |
Income Exchange Date |
IncomeExchangeDate |
Date |
7 |
No |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Job Title |
JobTitle |
Text |
75 |
No |
None |
Last Name |
LastName |
Text |
50 |
Yes |
None |
M/F |
MF |
Text |
30 |
No |
Bound by SEX_MF |
M/M |
MM |
Text |
15 |
No |
Bound by MR_MS |
Manager First Name |
ManagerFirstName |
Text |
50 |
No |
None |
Manager Id |
ManagerId |
Id |
15 |
No |
None |
Manager Integration Id |
ManagerIntegrationId |
Text |
30 |
No |
None |
Manager Last Name |
ManagerLastName |
Text |
50 |
No |
Used for picking a related entity |
Manager Middle Name |
ManagerMiddleName |
Text |
50 |
No |
None |
Manager Primary Organization |
ManagerPrimaryOrganization |
Text |
100 |
No |
None |
Manager Primary Organization Id |
ManagerPrimaryOrganizationId |
Id |
15 |
No |
None |
Manager UId |
ManagerUId |
Text |
100 |
No |
None |
Marital Status |
MaritalStatus |
Text |
30 |
No |
Bound by MARITAL_STATUS |
Middle Name |
MiddleName |
Text |
50 |
No |
None |
Mother Maiden Name |
MotherMaidenName |
Text |
50 |
No |
None |
Party UId |
PartyUId |
Text |
100 |
No |
None |
Person UId |
PersonUId |
Text |
100 |
No |
None |
Preferred Communications |
PreferredCommunications |
Text |
30 |
No |
Bound by OFFER_MEDIA |
Preferred Language Code |
PreferredLanguageCode |
Text |
20 |
No |
None |
Privacy Code |
PrivacyCode |
Text |
30 |
No |
Bound by PRIVACY_CODE |
Social Security Number |
SocialSecurityNumber |
Text |
11 |
No |
None |
Status |
Status |
Text |
30 |
No |
Bound by CONTACT_STATUS |
Suppress All Calls |
SuppressAllCalls |
Text |
1 |
No |
None |
Suppress All Emails |
SuppressAllEmails |
Text |
1 |
No |
None |
Suppress All Faxes |
SuppressAllFaxes |
Text |
1 |
No |
None |
Suppress All Mailings |
SuppressAllMailings |
Text |
1 |
No |
None |
Time Zone Id |
TimeZoneId |
Id |
15 |
No |
None |
Time Zone Name |
TimeZoneName |
Text |
100 |
No |
Used for picking a related entity. |
Work Phone # |
WorkPhone |
Text |
40 |
No |
None |
Work Phone Extension |
WorkPhoneExtension |
Text |
10 |
No |
None |
operation |
operation |
Text |
30 |
No |
System field |
IC: Account |
Account |
Account |
Text |
100 |
Yes |
None |
Account Location |
AccountLocation |
Text |
50 |
No |
None |
Account Organization |
AccountOrganization |
Text |
100 |
No |
None |
Account Party UId |
AccountPartyUId |
Text |
100 |
No |
None |
Account Row Id |
AccountRowId |
Id |
15 |
No |
None |
Account Status |
AccountStatus |
Text |
24 |
No |
Bound by ACCOUNT_STATUS |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
Related Account Integration Id |
RelatedAccountIntegrationId |
Text |
30 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
Alternate Phone |
Alternate Phone # |
AlternatePhone |
Text |
40 |
Yes |
None |
Alternate Phone Id |
AlternatePhoneId |
Id |
15 |
No |
None |
Alternate Phone Integration Id |
AlternatePhoneIntegrationId |
Text |
30 |
No |
None |
Alternate Phone Medium Type |
AlternatePhoneMediumType |
Text |
30 |
No |
None |
Alternate Phone Name |
AlternatePhoneName |
Text |
50 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
operation |
operation |
Text |
30 |
No |
System field |
IC: Communication Address |
Alternate Email Address |
AlternateEmailAddress |
Text |
100 |
Yes |
None |
Communication Address Id |
CommunicationAddressId |
Id |
15 |
No |
None |
Communication Address Integration Id |
CommunicationAddressIntegrationId |
Text |
30 |
No |
None |
Communication Address Medium Type |
CommunicationAddressMediumType |
Text |
30 |
No |
None |
Communication Address Name |
CommunicationAddressName |
Text |
50 |
Yes |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
operation |
operation |
Text |
30 |
No |
System field |
IC: Household |
Household Id |
HouseholdId |
Id |
15 |
No |
None |
Household Integration Id |
HouseholdIntegrationId |
Text |
30 |
No |
None |
Household Name |
HouseholdName |
Text |
50 |
No |
None |
Household Number |
HouseholdNumber |
Text |
100 |
No |
None |
Household Party UId |
HouseholdPartyUId |
Text |
100 |
No |
None |
Household Status |
HouseholdStatus |
Text |
30 |
No |
Bound by HOUSEHOLD_STATUS |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
INS Personal Address |
INS Personal Address Id |
INSPersonalAddressId |
Id |
15 |
No |
None |
INS Personal Address Name |
INSPersonalAddressName |
Text |
100 |
No |
None |
INS Personal Address Type |
INSPersonalAddressType |
Text |
30 |
No |
None |
INS Personal City |
INSPersonalCity |
Text |
50 |
Yes |
None |
INS Personal Country |
INSPersonalCountry |
Text |
30 |
No |
Bound by COUNTRY |
INS Personal County |
INSPersonalCounty |
Text |
50 |
No |
None |
INS Personal Integration Id |
INSPersonalIntegrationId |
Text |
30 |
No |
None |
INS Personal Postal Code |
INSPersonalPostalCode |
Text |
30 |
No |
None |
INS Personal State |
INSPersonalState |
Text |
10 |
No |
Bound by STATE_ABBREV |
INS Personal Street Address |
INSPersonalStreetAddress |
Text |
200 |
Yes |
None |
INS Personal Street Address 2 |
INSPersonalStreetAddress2 |
Text |
100 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
operation |
operation |
Text |
30 |
No |
System field |
IC: Organization |
Division |
Division |
Text |
255 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
Position |
Position |
Text |
50 |
No |
None |
Position Id |
PositionId |
Id |
15 |
No |
None |
Position Integration Id |
PositionIntegrationId |
Text |
30 |
No |
None |
Sales Rep |
SalesRep |
Text |
50 |
No |
None |
operation |
operation |
Text |
30 |
No |
System field |
IC: Position |
Division |
Division |
Text |
255 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
operation |
operation |
Text |
30 |
No |
System field |
Position |
Position |
Text |
50 |
No |
None |
Position Id |
PositionId |
Id |
15 |
No |
None |
Position Integration Id |
PositionIntegrationId |
Text |
30 |
No |
None |
Sales Rep |
SalesRep |
Text |
50 |
No |
None |
IC: Action |
Account Id |
AccountId |
Id |
15 |
No |
None |
Account Location |
AccountLocation |
Text |
50 |
No |
None |
Account Name |
AccountName |
Text |
100 |
No |
Used for picking a related entity. |
Audience |
Audience |
Text |
30 |
No |
Bound by ACTIVITY_AUDIENCE_TYPE |
Category |
Category |
Text |
30 |
No |
Bound by TODO_TYPE |
Description |
Description |
Text |
100 |
No |
None |
Done |
Done |
UTC date time |
7 |
No |
None |
Done Flag |
DoneFlag |
Text |
1 |
No |
None |
Due |
Due |
UTC date time |
7 |
No |
None |
Duration Minutes |
DurationMinutes |
Integer |
22 |
No |
Bound by APPOINTMENT_DURATION |
Id |
Id |
Id |
15 |
No |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
MeetingLocation |
MeetingLocation |
Text |
100 |
No |
None |
No Sooner Than Date |
NoSoonerThanDate |
UTC date time |
7 |
No |
None |
operation |
operation |
Text |
30 |
No |
System field |
Planned |
Planned |
UTC date time |
7 |
No |
None. |
Started |
Started |
UTC date time |
7 |
No |
None |
Status |
Status |
Text |
30 |
No |
Bound by EVENT_STATUS |
Type |
Type |
Text |
30 |
Yes |
Bound by TODO_TYPE |
IC: FINCORP Account |
Account Branch ABA |
AccountBranchABA |
Text |
50 |
No |
Used for picking a related entity. |
Account Branch Id |
AccountBranchId |
Id |
15 |
No |
None |
Account Holder |
AccountHolder |
Text |
100 |
No |
Used for picking a related entity. |
Account Name |
AccountName |
Text |
100 |
No |
None |
Account Number |
AccountNumber3 |
Text |
100 |
Yes |
None |
Account Status |
AccountStatus2 |
Text |
30 |
No |
Bound by FINS_CRPST_LFLN_IPFS_PLC_MLOV |
Account Type |
AccountType |
Text |
30 |
No |
Bound by FINCORP_PROD_ADMIN_CLASS_MLOV |
Acct Gen - Branch Id |
AcctGen-BranchId |
Id |
15 |
No |
None |
Available Balance |
AvailableBalance |
Currency |
22 |
No |
None |
Billing Option |
BillingOption |
Text |
30 |
No |
Bound by FINCORP_ACCOUNT_BILL_OPTION |
Branch |
Branch |
Text |
50 |
No |
None |
Current Balance |
CurrentBalance |
Currency |
22 |
No |
None |
Id |
Id |
Id |
15 |
No |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Name |
Name |
Text |
100 |
Yes |
Used for picking a related entity |
operation |
operation |
Text |
30 |
No |
System field |
Organization Id |
OrganizationId2 |
Id |
15 |
No |
None |
Product Id |
ProductId |
Id |
15 |
Yes |
None |
Relationship Limit |
RelationshipLimit |
Currency |
22 |
No |
None |
Start Date |
StartDate |
Date and time |
7 |
No |
None |
IC: UCM Contact Privacy |
Affiliate Flag |
AffiliateFlag |
Text |
30 |
No |
None |
Affiliate Method |
AffiliateMethod |
Text |
30 |
No |
None |
Affiliate Source |
AffiliateSource |
Text |
30 |
No |
None |
Affiliate System |
AffiliateSystem |
Text |
30 |
No |
None |
Channel Flag |
ChannelFlag |
Text |
30 |
No |
None |
Channel Method |
ChannelMethod |
Text |
30 |
No |
None |
Channel Source |
ChannelSource |
Text |
30 |
No |
None |
Channel System |
ChannelSystem |
Text |
30 |
No |
None |
Contact Id |
ContactId |
Id |
|
No |
None |
Cover Letter Type |
CoverLetterType |
Text |
30 |
No |
None |
Cover Letter Type II |
CoverLetterTypeII |
Text |
30 |
No |
None |
Id |
Id |
Id |
30 |
No |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Nonaffiliate Flag |
NonaffiliateFlag |
Text |
30 |
No |
None |
Nonaffiliate Method |
NonaffiliateMethod |
Text |
30 |
No |
None |
Nonaffiliate Source |
NonaffiliateSource |
Text |
30 |
No |
None |
Nonaffiliate System |
NonaffiliateSystem |
Text |
30 |
No |
None |
Notice Send Flag |
NoticeSendFlag |
Text |
30 |
No |
None |
Notice Sent Date |
NoticeSentDate |
UTC date time |
Not applicable |
No |
None |
Notice Sent Reason |
NoticeSentReason |
Text |
100 |
No |
None |
Notice Sent Type |
NoticeSentType |
Text |
30 |
No |
None |
OFAC Flag |
OFACFlag |
Boolean |
Not applicable |
No |
None |
PEND End Date |
PENDEndDate |
UTC date time |
Not applicable |
No |
None |
PEND Start Date |
PENDStartDate |
UTC date time |
Not applicable |
No |
None |
Privacy Parent Type |
PrivacyParentType |
Text |
30 |
No |
None |
Privacy State Code |
PrivacyStateCode |
Text |
30 |
No |
None |
Receive Annual Notice Flag |
ReceiveAnnualNoticeFlag |
Text |
30 |
No |
None |
Receive Annual Notice Method |
ReceiveAnnualNoticeMethod |
Text |
30 |
No |
None |
Receive Annual Notice Source |
ReceiveAnnualNoticeSource |
Text |
30 |
No |
None |
Receive Annual Notice System |
ReceiveAnnualNoticeSystem |
Text |
30 |
No |
None |
State PEND Period |
StatePENDPeriod |
Integer |
Not applicable |
No |
None |
Telemarketing Flag |
TelemarketingFlag |
Text |
30 |
No |
None |
Telemarketing Method |
TelemarketingMethod |
Text |
30 |
No |
None |
Telemarketing Source |
TelemarketingSource |
Text |
30 |
No |
None |
Telemarketing System |
TelemarketingSystem |
Text |
30 |
No |
None |
Updated |
Updated |
Date and time |
30 |
No |
None |
Updated By |
UpdatedBy |
Id |
30 |
No |
None |