Table 354. FINCORP Account Integration Component and Integration Component Fields
|
|
|
|
|
IC: FINCORP Account |
Account Branch ABA |
AccountBranchABA |
Text |
50 |
No |
Account Branch Id |
AccountBranchId |
Id |
Not applicable |
No |
Account Holder |
AccountHolder |
Text |
Not applicable |
No |
Account Name |
AccountName |
Text |
100 |
No |
Account Number |
AccountNumber |
Text |
100 |
Yes |
Account Status |
AccountStatus |
Text |
30 |
No |
Account Type |
AccountType |
Text |
30 |
No |
Acct Gen - Branch Id |
AcctGen-BranchId |
Id |
Not applicable |
No |
Acct Gen - Primary Contact Id |
AcctGen-PrimaryContactId |
Id |
Not applicable |
No |
Available Balance |
AvailableBalance |
Text |
Not applicable |
No |
Billing Option |
BillingOption |
Text |
30 |
No |
Branch |
Branch |
Text |
50 |
No |
CA Next Statement Date |
CANextStatementDate |
Date and time |
Not applicable |
No |
Commitment Amount |
CommitmentAmount |
Text |
Not applicable |
No |
Conflict Id |
ConflictId |
Id |
30 |
No |
Created |
Created |
Date and time |
30 |
No |
Current Balance |
CurrentBalance |
Text |
Not applicable |
No |
Id |
Id |
Id |
30 |
No |
Integration Id |
IntegrationId |
Text |
30 |
No |
Mod Id |
ModId |
Id |
30 |
No |
Name |
Name |
Text |
100 |
No |
operation |
operation |
Text |
30 |
No |
Organization Id |
OrganizationId |
Id |
Not applicable |
No |
Owner Type |
OwnerType |
Text |
30 |
No |
Parent ABA Number |
ParentABANumber |
Text |
50 |
No |
Parent Asset ID |
ParentAssetID |
Id |
Not applicable |
No |
Parent Asset Number |
ParentAssetNumber |
Text |
100 |
No |
Primary Account Id |
PrimaryAccountId |
Id |
Not applicable |
No |
Product Id |
ProductId |
Id |
Not applicable |
Yes |
Relationship |
Relationship |
Text |
30 |
No |
Relationship Limit |
RelationshipLimit |
Text |
Not applicable |
No |
searchspec |
searchspec |
Text |
250 |
No |
Start Date |
StartDate |
Date and time |
Not applicable |
No |
Sub Type |
SubType |
Text |
30 |
No |
Type |
Type |
Text |
30 |
No |
Updated |
Updated |
UTC date time |
30 |
No |
Updated By |
UpdatedBy |
Id |
30 |
No |
IC: Contact |
Account Id |
AccountId |
Id |
Not applicable |
No |
Account Integration Id |
AccountIntegrationId |
Text |
30 |
No |
Assistant |
Assistant |
Text |
50 |
No |
Assistant Phone # |
AssistantPhone |
Text |
Not applicable |
No |
Cellular Phone # |
CellularPhone |
Text |
Not applicable |
No |
Fax Phone # |
FaxPhone |
Text |
Not applicable |
No |
First Name |
FirstName |
Text |
50 |
No |
Home Phone # |
HomePhone |
Text |
Not applicable |
No |
Id |
Id |
Id |
100 |
No |
Integration Id |
IntegrationId |
Text |
30 |
No |
Job Title |
JobTitle |
Text |
75 |
No |
Last Name |
LastName |
Text |
50 |
No |
M/M |
MM |
Text |
15 |
No |
Market Cap Pref |
MarketCapPref |
Text |
30 |
No |
Middle Name |
MiddleName |
Text |
50 |
No |
Mod Id |
ModId |
Id |
30 |
No |
operation |
operation |
Text |
30 |
No |
Party UId |
PartyUId |
Text |
30 |
No |
Person UId |
PersonUId |
Id |
30 |
No |
Preferred Communication Method |
PreferredCommunicationMethod |
Text |
20 |
No |
Primary Personal Address Id |
PrimaryPersonalAddressId |
Id |
Not applicable |
No |
Privacy Code |
PrivacyCode |
Text |
30 |
No |
searchspec |
searchspec |
Text |
250 |
No |
Suppress All Calls |
SuppressAllCalls |
Boolean |
Not applicable |
No |
Suppress All Emails |
SuppressAllEmails2 |
Boolean |
Not applicable |
No |
Suppress All Faxes |
SuppressAllFaxes |
Boolean |
Not applicable |
No |
Suppress All Mailings |
SuppressAllMailings |
Boolean |
Not applicable |
No |
Updated |
Updated |
Date and time |
30 |
No |
Updated By |
UpdatedBy |
Id |
30 |
No |
Work Phone # |
WorkPhone |
Text |
Not applicable |
No |
IC: FINCORP Account Contact |
Asset Id |
AssetId |
Id |
Not applicable |
No |
Contact Id |
ContactId |
Id |
Not applicable |
No |
Id |
Id |
Id |
30 |
No |
Status |
Status |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
Updated By |
UpdatedBy |
Id |
30 |
No |
IC: CUT Address |
Address Name |
AddressName |
Text |
100 |
Yes |
City |
City |
Text |
50 |
Yes |
Country |
Country |
Text |
30 |
No |
County |
County |
Text |
50 |
No |
Id |
Id |
Id |
30 |
No |
Integration Id |
IntegrationId |
Text |
30 |
No |
operation |
operation |
Text |
30 |
No |
Postal Code |
PostalCode |
Text |
30 |
No |
searchspec |
searchspec |
Text |
250 |
No |
State |
State |
Text |
10 |
No |
Street Address |
StreetAddress |
Text |
200 |
No |
Street Address 2 |
StreetAddress2 |
Text |
100 |
No |
Updated |
Updated |
Date and time |
30 |
No |
Updated By |
UpdatedBy |
Id |
30 |
No |
IC: FINS CF Financial Account Address |
Active Flag |
ActiveFlag |
Boolean |
Not applicable |
No |
Addr Id |
AddrId |
Id |
Not applicable |
No |
City |
City |
Text |
50 |
No |
Contact Id |
ContactId |
Id |
Not applicable |
No |
Country |
Country |
Text |
30 |
No |
Fin Acct Id |
FinAcctId |
Id |
Not applicable |
No |
First Name |
FirstName |
Text |
50 |
No |
Id |
Id |
Id |
30 |
No |
Last Name |
LastName |
Text |
50 |
No |
operation |
operation |
Text |
30 |
No |
searchspec |
searchspec |
Text |
250 |
No |
State |
State |
Text |
10 |
No |
Street |
Street |
Text |
200 |
Yes |
Updated |
Updated |
Date and time |
30 |
No |
Updated By |
UpdatedBy |
Id |
30 |
No |
Use Type |
UseType |
Text |
30 |
Yes |
Zipcode |
Zipcode2 |
Text |
30 |
No |
IC: UCM Contact Privacy |
Affiliate Flag |
AffiliateFlag |
Text |
30 |
No |
Affiliate Method |
AffiliateMethod |
Text |
30 |
No |
Affiliate Source |
AffiliateSource |
Text |
30 |
No |
Affiliate System |
AffiliateSystem |
Text |
30 |
No |
Channel Flag |
ChannelFlag |
Text |
30 |
No |
Channel Method |
ChannelMethod |
Text |
30 |
No |
Channel Source |
ChannelSource |
Text |
30 |
No |
Channel System |
ChannelSystem |
Text |
30 |
No |
Contact Id |
ContactId |
Id |
Not applicable |
No |
Cover Letter Type |
CoverLetterType |
Text |
30 |
No |
Cover Letter Type II |
CoverLetterTypeII |
Text |
30 |
No |
Id |
Id |
Id |
30 |
No |
Integration Id |
IntegrationId |
Text |
30 |
No |
Nonaffiliate Flag |
NonaffiliateFlag |
Text |
30 |
No |
Nonaffiliate Method |
NonaffiliateMethod |
Text |
30 |
No |
Nonaffiliate Source |
NonaffiliateSource |
Text |
30 |
No |
Nonaffiliate System |
NonaffiliateSystem |
Text |
30 |
No |
Notice Send Flag |
NoticeSendFlag |
Text |
30 |
No |
Notice Sent Date |
NoticeSentDate |
UTC date time |
Not applicable |
No |
Notice Sent Reason |
NoticeSentReason |
Text |
100 |
No |
Notice Sent Type |
NoticeSentType |
Text |
30 |
No |
OFAC Flag |
OFACFlag |
Boolean |
Not applicable |
No |
PEND End Date |
PENDEndDate |
UTC date time |
Not applicable |
No |
PEND Start Date |
PENDStartDate |
UTC date time |
Not applicable |
No |
Privacy Parent Type |
PrivacyParentType |
Text |
30 |
Yes |
Privacy State Code |
PrivacyStateCode |
Text |
30 |
No |
Receive Annual Notice Flag |
ReceiveAnnualNoticeFlag |
Text |
30 |
No |
Receive Annual Notice Method |
ReceiveAnnualNoticeMethod |
Text |
30 |
No |
Receive Annual Notice Source |
ReceiveAnnualNoticeSource |
Text |
30 |
No |
Receive Annual Notice System |
ReceiveAnnualNoticeSystem |
Text |
30 |
No |
State PEND Period |
StatePENDPeriod |
Integer |
Not applicable |
No |
Telemarketing Flag |
TelemarketingFlag |
Text |
30 |
No |
Telemarketing Method |
TelemarketingMethod |
Text |
30 |
No |
Telemarketing Source |
TelemarketingSource |
Text |
30 |
No |
Telemarketing System |
TelemarketingSystem |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
Updated By |
UpdatedBy |
Id |
30 |
No |
IC: UCM FINCORP Account Contact Address |
Address Type |
AddressType |
Text |
30 |
No |
City |
City |
Text |
50 |
No |
Comments |
Comments |
Text |
200 |
No |
Country |
Country |
Text |
30 |
No |
Financial Account Contact Id |
FinancialAccountContactId |
Id |
Not applicable |
No |
Id |
Id |
Id |
30 |
No |
operation |
operation |
Text |
30 |
No |
Personal Address Id |
PersonalAddressId |
Id |
Not applicable |
Yes |
Postal Code |
PostalCode |
Text |
30 |
No |
searchspec |
searchspec |
Text |
250 |
No |
State |
State |
Text |
10 |
No |
Street Address |
StreetAddress |
Text |
200 |
No |
Street Address 2 |
StreetAddress2 |
Text |
200 |
No |
Updated |
Updated |
Date and time |
30 |
No |
Updated By |
UpdatedBy |
Id |
30 |
No |
IC: UCM FINCORP Account Contact Privacy |
Affiliate Flag |
AffiliateFlag |
Text |
30 |
No |
Affiliate Method |
AffiliateMethod |
Text |
30 |
No |
Affiliate Source |
AffiliateSource |
Text |
30 |
No |
Affiliate System |
AffiliateSystem |
Text |
30 |
No |
Channel Flag |
ChannelFlag |
Text |
30 |
No |
Channel Method |
ChannelMethod |
Text |
30 |
No |
Channel Source |
ChannelSource |
Text |
30 |
No |
Channel System |
ChannelSystem |
Text |
30 |
No |
Cover Letter Type |
CoverLetterType |
Text |
30 |
No |
Cover Letter Type II |
CoverLetterTypeII |
Text |
30 |
No |
Financial Account Contact Id |
FinancialAccountContactId |
Id |
Not applicable |
No |
Financial Account Id |
FinancialAccountId |
Id |
|
No |
Id |
Id |
Id |
30 |
No |
Integration Id |
IntegrationId |
Text |
30 |
No |
Nonaffiliate Flag |
NonaffiliateFlag |
Text |
30 |
No |
Nonaffiliate Method |
NonaffiliateMethod |
Text |
30 |
No |
Nonaffiliate Source |
NonaffiliateSource |
Text |
30 |
No |
Nonaffiliate System |
NonaffiliateSystem |
Text |
30 |
No |
Notice Send Flag |
NoticeSendFlag |
Text |
30 |
No |
Notice Sent Date |
NoticeSentDate |
UTC date time |
Not applicable |
No |
Notice Sent Reason |
NoticeSentReason |
Text |
100 |
No |
Notice Sent Type |
NoticeSentType |
Text |
30 |
No |
OFAC Flag |
OFACFlag |
Boolean |
Not applicable |
No |
operation |
operation |
Text |
30 |
No |
PEND Flag |
PENDFlag |
Boolean |
Not applicable |
No |
Privacy Parent Type |
PrivacyParentType |
Text |
30 |
Yes |
Privacy State Code |
PrivacyStateCode |
Text |
30 |
No |
Receive Annual Notice Flag |
ReceiveAnnualNoticeFlag |
Text |
30 |
No |
Receive Annual Notice Method |
ReceiveAnnualNoticeMethod |
Text |
30 |
No |
Receive Annual Notice Source |
ReceiveAnnualNoticeSource |
Text |
30 |
No |
Receive Annual Notice System |
ReceiveAnnualNoticeSystem |
Text |
30 |
No |
searchspec |
searchspec |
Text |
250 |
No |
Telemarketing Flag |
TelemarketingFlag |
Text |
30 |
No |
Telemarketing Method |
TelemarketingMethod |
Text |
30 |
No |
Telemarketing Source |
TelemarketingSource |
Text |
30 |
No |
Telemarketing System |
TelemarketingSystem |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
Updated By |
UpdatedBy |
Id |
30 |
No |
IC: UCM FINCORP Account Privacy |
Affiliate Flag |
AffiliateFlag |
Text |
30 |
No |
Affiliate Method |
AffiliateMethod |
Text |
30 |
No |
Affiliate Source |
AffiliateSource |
Text |
30 |
No |
Affiliate System |
AffiliateSystem |
Text |
30 |
No |
Channel Flag |
ChannelFlag |
Text |
30 |
No |
Channel Method |
ChannelMethod |
Text |
30 |
No |
Channel Source |
ChannelSource |
Text |
30 |
No |
Channel System |
ChannelSystem |
Text |
30 |
No |
Cover Letter Type |
CoverLetterType |
Text |
30 |
No |
Cover Letter Type II |
CoverLetterTypeII |
Text |
30 |
No |
Financial Account Id |
FinancialAccountId |
Id |
|
No |
Id |
Id |
Id |
30 |
No |
Integration Id |
IntegrationId |
Text |
30 |
No |
Nonaffiliate Flag |
NonaffiliateFlag |
Text |
30 |
No |
Nonaffiliate Method |
NonaffiliateMethod |
Text |
30 |
No |
Nonaffiliate Source |
NonaffiliateSource |
Text |
30 |
No |
Nonaffiliate System |
NonaffiliateSystem |
Text |
30 |
No |
Notice Send Flag |
NoticeSendFlag |
Text |
30 |
No |
Notice Sent Date |
NoticeSentDate |
UTC date time |
Not applicable |
No |
Notice Sent Reason |
NoticeSentReason |
Text |
100 |
No |
Notice Sent Type |
NoticeSentType |
Text |
30 |
No |
OFAC Flag |
OFACFlag |
Boolean |
|
No |
operation |
operation |
Text |
30 |
No |
PEND Start Date |
PENDStartDate |
UTC date time |
Not applicable |
No |
Privacy Parent Type |
PrivacyParentType |
Text |
30 |
Yes |
Privacy State Code |
PrivacyStateCode |
Text |
30 |
No |
Receive Annual Notice Flag |
ReceiveAnnualNoticeFlag |
Text |
30 |
No |
Receive Annual Notice Method |
ReceiveAnnualNoticeMethod |
Text |
30 |
No |
Receive Annual Notice Source |
ReceiveAnnualNoticeSource |
Text |
30 |
No |
Receive Annual Notice System |
ReceiveAnnualNoticeSystem |
Text |
30 |
No |
searchspec |
searchspec |
Text |
250 |
No |
State PEND Period |
StatePENDPeriod |
Integer |
Not applicable |
No |
Telemarketing Flag |
TelemarketingFlag |
Text |
30 |
No |
Telemarketing Method |
TelemarketingMethod |
Text |
30 |
No |
Telemarketing Source |
TelemarketingSource |
Text |
30 |
No |
Telemarketing System |
TelemarketingSystem |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
Updated By |
UpdatedBy |
Id |
30 |
No |