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