Table 391. Account Integration Component and Integration Component Fields
|
|
|
|
|
|
IC: Account |
Account Region |
AccountRegion |
Text |
30 |
No |
Use for picking a related entity |
Account Status |
AccountStatus |
Text |
24 |
No |
Bound by ACCOUNT_STATUS |
Account Type Code |
AccountTypeCode |
Text |
30 |
Yes |
Bound by CUT_ACCOUNT_TYPE |
Account Value |
AccountValue |
Text |
30 |
No |
Bound by FIN_CON_VALUE_TYPE |
Alias |
Alias |
Text |
50 |
No |
None |
Annual Revenue |
AnnualRevenue |
Text |
22 |
No |
None |
Client Flag |
ClientFlag |
Boolean |
1 |
No |
None |
Competitor |
Competitor |
Boolean |
1 |
No |
None |
Credit Agency Number |
CreditAgencyNumber |
Text |
30 |
No |
None |
Cumulative Sales |
CumulativeSales |
Number |
22 |
No |
None |
Currency Code |
CurrencyCode |
Text |
15 |
Yes |
None |
Current Volume |
CurrentVolume |
Currency |
22 |
No |
None |
Dont Call |
DontCall |
Boolean |
1 |
No |
None |
Drug Spent Currency Code |
DrugSpentCurrencyCode |
Text |
30 |
Yes |
Use for picking a related entity |
Employees |
Employees |
Number |
22 |
No |
None |
Facility Flag |
FacilityFlag |
Boolean |
1 |
No |
None |
Federal Tax Number |
FederalTaxNumber |
Text |
15 |
No |
None |
Financing Method |
FinancingMethod |
Text |
30 |
No |
Bound by FINCORP_CLIENT_FINANCING |
Gross Potential Value |
GrossPotentialValue |
Currency |
22 |
No |
None |
Group Type Code |
GroupTypeCode |
Text |
30 |
Yes |
Bound by GROUP_TYPE_CD |
Home Page |
HomePage |
Text |
100 |
No |
None |
Id |
Id |
Id |
150 |
No |
For cross-referencing |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Internal Org Flag |
InternalOrgFlag |
Boolean |
1 |
Yes |
None |
Investor Flag |
InvestorFlag |
Boolean |
1 |
No |
None |
Last Year Sales |
LastYearSales |
Currency |
22 |
No |
None |
Legal Status |
LegalStatus |
Text |
30 |
No |
Bound by UT_LEGAL_STATUS |
Location |
Location |
Text |
50 |
No |
None |
Main Fax Number |
MainFaxNumber |
Phone |
40 |
No |
None |
Main Phone Number |
MainPhoneNumber |
Phone |
40 |
No |
None |
Master Account Id |
MasterAccountId |
Id |
15 |
No |
None |
Name |
Name |
Text |
100 |
Yes |
None |
operation |
operation |
Text |
30 |
No |
None |
Partner Flag |
PartnerFlag |
Boolean |
1 |
No |
None |
Party UId |
PartyUId |
Text |
100 |
Yes |
None |
Privacy Code |
PrivacyCode |
Text |
30 |
Yes |
Bound by PRIVACY_CODE |
Reference Flag |
ReferenceFlag |
Boolean |
1 |
No |
None |
Referenciable |
Referenciable |
Boolean |
1 |
No |
None |
Revenue Growth |
RevenueGrowth |
Number |
22 |
No |
None |
Service Provider Flag |
ServiceProviderFlag |
Text |
1 |
No |
None |
Status |
Status |
Text |
30 |
No |
Bound by FINS_COMPETITOR_STATUS_MLOV |
Total # Meters |
TotalMeters |
Number |
22 |
No |
None |
Total Potential Volume |
TotalPotentialVolume |
Currency |
22 |
No |
None |
Type |
Type |
Text |
30 |
Yes |
Bound by ACCOUNT_TYPE |
Unionized |
Unionized |
Boolean |
1 |
No |
None |
YTD Net Contribution |
YTDNetContribution |
Currency |
22 |
No |
None |
IC: Account_Business Address |
Address Id |
AddressId |
Id |
30 |
Yes |
None |
Address Integration Id |
AddressIntegrationId |
Text |
30 |
No |
None |
Bill Address Flag |
BillAddressFlag |
Text |
1 |
No |
None |
City |
City |
Text |
50 |
No |
None |
Country |
Country |
Text |
50 |
No |
Use it for picking a related entity |
Email Address |
EmailAddress |
Text |
50 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
Postal Code |
PostalCode |
Text |
30 |
No |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
Ship Address Flag |
ShipAddressFlag |
Text |
1 |
No |
None |
State |
State |
Text |
10 |
No |
Bound by STATE_ABBREV |
Street Address |
StreetAddress |
Text |
200 |
No |
None |
IC: Action |
Alarm |
Alarm |
Boolean |
1 |
No |
None |
Assignment Excluded |
AssignmentExcluded |
Boolean |
1 |
No |
None |
Associated Cost |
AssociatedCost |
Currency |
22 |
No |
None |
Billable Flag |
BillableFlag |
Boolean |
1 |
No |
None |
Call Id |
CallId |
Text |
30 |
No |
None |
Category |
Category |
Text |
30 |
Yes |
Use for picking a related entity |
Class |
Class |
Text |
30 |
No |
Bound by FS_ACTIVITY_CLASS |
Comment |
Comment |
Text |
"1,500" |
No |
None |
Description |
Description |
Text |
100 |
No |
None |
Display |
Display |
Text |
30 |
No |
None |
Done |
Done |
UTC date time |
7 |
No |
None |
Done Flag |
DoneFlag |
Boolean |
1 |
No |
None |
Due |
Due |
UTC date time |
7 |
No |
None |
Duration Minutes |
DurationMinutes |
Integer |
22 |
No |
Bound by APPOINTMENT_DURATION |
Expense Related Flag |
ExpenseRelatedFlag |
Boolean |
1 |
No |
None |
Id |
Id |
Text |
100 |
Yes |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
No Sooner Than Date |
NoSoonerThanDate |
UTC date time |
7 |
No |
None |
Objective |
Objective |
Text |
30 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
Owned By |
OwnedBy |
Text |
30 |
Yes |
Use it for picking a related entity |
Owned By Id |
OwnedById |
Text |
30 |
Yes |
None |
Primary Owned By |
PrimaryOwnedBy |
Text |
50 |
No |
Use it for picking a related entity |
Primary Owner Id |
PrimaryOwnerId |
Id |
30 |
No |
None |
Priority |
Priority |
Text |
30 |
No |
Bound by ACTIVITY_PRIORITY |
Private |
Private |
Boolean |
1 |
No |
None |
Repeating |
Repeating |
Boolean |
1 |
No |
None |
Repeating Expires |
RepeatingExpires |
Date and time |
7 |
No |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
Status |
Status |
Text |
30 |
No |
Bound by EVENT_STATUS |
Type |
Type2 |
Text |
30 |
Yes |
Bound by TODO_TYPE |
IC: Contact |
Account Id |
AccountId |
Id |
30 |
No |
None |
Account Integration Id |
AccountIntegrationId |
Text |
30 |
No |
None |
Assistant |
Assistant |
Text |
50 |
No |
None |
Assistant Phone # |
AssistantPhone |
Phone |
40 |
No |
None |
Cellular Phone # |
CellularPhone |
Phone |
40 |
No |
None |
Fax Phone # |
FaxPhone |
Phone |
40 |
No |
None |
First Name |
FirstName |
Text |
50 |
Yes |
None |
Home Phone # |
HomePhone |
Text |
40 |
No |
None |
Job Title |
JobTitle |
Text |
75 |
No |
None |
Last Name |
LastName |
Text |
50 |
Yes |
None |
M/M |
MM |
Text |
15 |
No |
None |
Middle Name |
MiddleName |
Text |
50 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
Party UId |
PartyUId |
Text |
100 |
Yes |
None |
Person UId |
PersonUId |
Id |
30 |
Yes |
None |
Preferred Communication Method |
PreferredCommunicationMethod |
Text |
20 |
No |
Bound by COMM_METHOD |
Privacy Code |
PrivacyCode |
Text |
30 |
Yes |
Bound by PRIVACY_CODE |
Row Id |
RowId |
Id |
100 |
No |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
Work Phone # |
WorkPhone |
Phone |
45 |
No |
None |
IC: FINCORP Deposit Account |
Account Branch Number |
AccountBranchNumber |
Text |
100 |
No |
None |
Account Category |
AccountCategory |
Text |
30 |
No |
Bound by FINS_ASSET_PROD_CLASS_MLOV |
Account Number |
AccountNumber |
Text |
100 |
Yes |
None |
Account Status |
AccountStatus |
Text |
30 |
No |
Bound by FINS_CRPST_LFLN_IPFS_PLC_MLOV |
Branch |
Branch |
Text |
50 |
No |
None |
Current Balance |
CurrentBalance |
Currency |
22 |
No |
None |
Id |
Id |
Text |
100 |
No |
None |
Integration Id |
Integration Id |
Text |
30 |
No |
None |
Name |
Name |
Text |
100 |
Yes |
Use it for picking a related entity |
operation |
operation |
Text |
30 |
No |
None |
Product Id |
ProductId |
Id |
100 |
Yes |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
Type |
Type |
Text |
30 |
No |
Bound by FINS_OWNERSHIP_TYPE_MLOV |
IC: FINCORP Loan Account |
Account Branch Number |
AccountBranchNumber |
Text |
30 |
No |
None |
Account Category |
AccountCategory |
Text |
30 |
No |
Bound by FINS_ASSET_PROD_CLASS_MLOV |
Account Number |
AccountNumber |
Text |
100 |
Yes |
None |
Account Status |
AccountStatus |
Text |
30 |
No |
Bound by FINS_CRPST_LFLN_IPFS_PLC_MLOV |
Current Balance |
CurrentBalance |
Currency |
22 |
No |
None |
Id |
Id |
Text |
30 |
No |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Name |
Name |
Text |
100 |
Yes |
Use it for picking a related entity |
operation |
operation |
Text |
30 |
No |
None |
Product Id |
ProductId |
Id |
100 |
Yes |
Use it for picking a related entity |
searchspec |
searchspec |
Text |
250 |
No |
|
Type |
Type |
Text |
30 |
No |
FINS_OWNERSHIP_TYPE_MLOV |
IC: Related Industry |
Industry |
Industry |
Text |
50 |
Yes |
None |
Industry Id |
IndustryId |
Id |
30 |
Yes |
None |
Industry Integration Id |
IndustryIntegrationId |
Text |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
Organization |
Organization |
Text |
100 |
Yes |
None |
Organization Id |
OrganizationId |
Id |
100 |
Yes |
None |
Organization Integration Id |
OrganizationIntegrationId |
Text |
30 |
No |
None |
Related Organization |
SIC Code |
SICCode |
Text |
30 |
Yes |
None |
IC: Related Sales Reps |
Division |
Division |
Text |
255 |
Yes |
Use to select a related entity |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
Login |
Login |
Id |
15 |
No |
None |
Position |
Position |
Text |
50 |
No |
None |
Position Id |
PositionId |
Id |
30 |
No |
None |
Position Integration Id |
PositionIntegrationId |
Text |
30 |
No |
None |
IC: Sub Account |
Account Status |
AccountStatus2 |
Text |
30 |
No |
Bound by ACCOUNT_STATUS |
Id |
Id |
Id |
100 |
Yes |
None |
Location |
Location |
Text |
50 |
No |
None |
Main Phone Number |
MainPhoneNumber |
Phone |
40 |
No |
None |
Name |
Name |
Text |
100 |
Yes |
None |
operation |
operation |
Text |
30 |
No |
None |
Party UId |
PartyUId |
Text |
30 |
Yes |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
Type |
Type |
Text |
255 |
Yes |
Bound by ACCOUNT_TYPE |
IC: UCM Account Privacy |
Account Id |
AccountId |
Id |
|
No |
None |
Affiliate Flag |
AffiliateFlag |
Text |
30 |
No |
None |
Affiliate Flag |
AffiliateFlag |
Text |
30 |
No |
None |
Affiliate Method |
AffiliateMethod |
Text |
30 |
No |
None |
Affiliate Method |
AffiliateMethod |
Text |
30 |
No |
None |
Affiliate Source |
AffiliateSource |
Text |
30 |
No |
None |
Affiliate Source |
AffiliateSource |
Text |
30 |
No |
None |
Affiliate System |
AffiliateSystem |
Text |
30 |
No |
None |
Affiliate System |
AffiliateSystem |
Text |
30 |
No |
None |
Channel Flag |
ChannelFlag |
Text |
30 |
No |
None |
Channel Flag |
ChannelFlag |
Text |
30 |
No |
None |
Channel Method |
ChannelMethod |
Text |
30 |
No |
None |
Channel Method |
ChannelMethod |
Text |
30 |
No |
None |
Channel Source |
ChannelSource |
Text |
30 |
No |
None |
Channel Source |
ChannelSource |
Text |
30 |
No |
None |
Channel System |
ChannelSystem |
Text |
30 |
No |
None |
Channel System |
ChannelSystem |
Text |
30 |
No |
None |
Contact Id |
ContactId |
Id |
30 |
No |
None |
Cover Letter Type |
CoverLetterType |
Text |
30 |
No |
None |
Cover Letter Type |
CoverLetterType |
Text |
30 |
No |
None |
Cover Letter Type II |
CoverLetterTypeII |
Text |
30 |
No |
None |
Cover Letter Type II |
CoverLetterTypeII |
Text |
30 |
No |
None |
IC: UCM Contact Privacy |
Id |
Id |
Id |
30 |
No |
None |
Id |
Id |
Id |
30 |
No |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Nonaffiliate Flag |
NonaffiliateFlag |
Text |
30 |
No |
None |
Nonaffiliate Flag |
NonaffiliateFlag |
Text |
30 |
No |
None |
Nonaffiliate Method |
NonaffiliateMethod |
Text |
30 |
No |
None |
Nonaffiliate Method |
NonaffiliateMethod |
Text |
30 |
No |
None |
Nonaffiliate Source |
NonaffiliateSource |
Text |
30 |
No |
None |
Nonaffiliate Source |
NonaffiliateSource |
Text |
30 |
No |
None |
Nonaffiliate System |
NonaffiliateSystem |
Text |
30 |
No |
None |
Nonaffiliate System |
NonaffiliateSystem |
Text |
30 |
No |
None |
Notice Send Flag |
NoticeSendFlag |
Text |
30 |
No |
None |
Notice Send Flag |
NoticeSendFlag |
Text |
30 |
No |
None |
Notice Sent Date |
NoticeSentDate |
UTC date time |
30 |
No |
None |
Notice Sent Date |
NoticeSentDate |
UTC date time |
30 |
No |
None |
Notice Sent Reason |
NoticeSentReason |
Text |
100 |
No |
None |
Notice Sent Reason |
NoticeSentReason |
Text |
100 |
No |
None |
Notice Sent Type |
NoticeSentType |
Text |
30 |
No |
None |
Notice Sent Type |
NoticeSentType |
Text |
30 |
No |
None |
OFAC Flag |
OFACFlag |
Boolean |
Not applicable |
No |
None |
OFAC Flag |
OFACFlag |
Boolean |
Not applicable |
No |
None |
PEND End Date |
PENDEndDate |
UTC date time |
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 |
PEND Start Date |
PENDStartDate |
UTC date time |
Not applicable |
No |
None |
Privacy Parent Type |
PrivacyParentType |
Text |
30 |
No |
Account |
Privacy Parent Type |
PrivacyParentType |
Text |
30 |
No |
None |
Privacy State Code |
PrivacyStateCode |
Text |
30 |
No |
None |
Privacy State Code |
PrivacyStateCode |
Text |
30 |
No |
None |
Receive Annual Notice Flag |
ReceiveAnnualNoticeFlag |
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 Method |
ReceiveAnnualNoticeMethod |
Text |
30 |
No |
None |
Receive Annual Notice Source |
ReceiveAnnualNoticeSource |
Text |
30 |
No |
None |
Receive Annual Notice Source |
ReceiveAnnualNoticeSource |
Text |
30 |
No |
None |
Receive Annual Notice System |
ReceiveAnnualNoticeSystem |
Text |
30 |
No |
None |
Receive Annual Notice System |
ReceiveAnnualNoticeSystem |
Text |
30 |
No |
None |
State PEND Period |
StatePENDPeriod |
Integer |
30 |
No |
None |
State PEND Period |
StatePENDPeriod |
Integer |
30 |
No |
None |
Telemarketing Flag |
TelemarketingFlag |
Text |
30 |
No |
None |
Telemarketing Flag |
TelemarketingFlag |
Text |
30 |
No |
None |
Telemarketing Method |
TelemarketingMethod |
Text |
30 |
No |
None |
Telemarketing Method |
TelemarketingMethod |
Text |
30 |
No |
None |
Telemarketing Source |
TelemarketingSource |
Text |
30 |
No |
None |
Telemarketing Source |
TelemarketingSource |
Text |
30 |
No |
None |
Telemarketing System |
TelemarketingSystem |
Text |
30 |
No |
None |
Telemarketing System |
TelemarketingSystem |
Text |
30 |
No |
None |
Updated |
Updated |
Date and time |
30 |
No |
None |
Updated |
Updated |
Date and time |
30 |
No |
None |
Updated By |
UpdatedBy |
Id |
30 |
No |
None |
Updated By |
UpdatedBy |
Id |
30 |
No |
None |
