Skip to main content

Field Reference Table

Field NameLabelTypeLength
aum__cAUMcurrency0
accounts_merged_description__cAccounts Merged Descriptiontextarea32768
alternative_platform_description__cAlternative Platform Descriptiontextarea130000
assets_boy__cAssets BOYcurrency0
average_ticket_size__cAverage Ticket Sizecurrency0
bank_loans__cBank Loanspicklist255
billingcityBilling Citystring40
billingcountryBilling Countrystring80
billinglatitudeBilling Latitudedouble0
billinglongitudeBilling Longitudedouble0
billingpostalcodeBilling Zip/Postal Codestring20
billingstateBilling State/Provincestring80
billingstreetBilling Streettextarea255
cit_usage__cCIT Usagepicklist255
cmbs__cCMBSpicklist255
crd__cCRD#string18
client_base__cClient Basemultipicklist4099
co_investments__cCo-Investmentspicklist255
convertibles__cConvertiblespicklist255
core_bonds__cCore Bondspicklist255
createddateCreated Datedatetime0
cryptocurrency__cCryptocurrencypicklist255
current_searches__cCurrent Searchesurl255
custodian_s__cCustodian(s)multipicklist4099
dc_consultant_name__cDC Consultant Namestring1300
dc_consultant__cDC Consultantreference to: Account18
date_received__cDate Receiveddate0
descriptionAccount Descriptiontextarea32000
discretionary_assets__cDiscretionary Assetscurrency0
etf_usage__cETF Usagepicklist255
emerging_manager_program__cEmerging Manager Programpicklist255
emerging_market_bonds__cEmerging Market Bondspicklist255
emerging_market_equities__cEmerging Market Equitiespicklist255
form_5500_pdf__cForm 5500 PDFstring1300
form_adv_part_2a_brochure__cForm ADV Part 2A Brochureurl255
general_consultant_2_name__cGeneral Consultant 2 Namestring1300
general_consultant_2__cGeneral Consultant 2reference to: Account18
general_consultant_name__cConsultant 1 Namestring1300
general_consultant__cGeneral Consultantreference to: Account18
global_equities__cGlobal Equitiespicklist255
government_bonds__cGovernment Bondspicklist255
hedge_fof__cHedge FOFpicklist255
hedge_fund_consultant_name__cHedge Fund Consultant Namestring1300
hedge_fund_consultant__cHedge Fund Consultantreference to: Account18
hedge_funds__cHedge Fundspicklist255
high_yield_bonds__cHigh Yield Bondspicklist255
idAccount IDid18
international_equities__cInternational Equitiespicklist255
investment_policy_statement__cInvestment Policy Statementurl255
investments_page__cInvestments Pageurl255
investments_team_page__cInvestments Team Pageurl255
invests_in_impact_sri_or_esg__cInvests in Impact, SRI or ESGpicklist255
lp_power_user__cLP Power Userpicklist255
lp_usage__cLP Usagepicklist255
large_cap_equities__cLarge Cap Equitiespicklist255
lastmodifieddateLast Modified Datedatetime0
liquid_alternatives__cLiquid Alternativespicklist255
mbs__cMBSpicklist255
main_page__cMain Pageurl255
metroarea__cMetro Areareference to: Metro_Area__c18
metro_area_name__cMetro Area Namestring1300
micro_cap_us_equities__cMicro Cap US Equitiespicklist255
mid_cap_equities__cMid Cap Equitiespicklist255
minicipal_bonds__cMunicipal Bondspicklist255
models__cModelspicklist255
mutual_fund_family_name__cMutual Fund Family Namestring50
mutual_fund_usage__cMutual Fund Usagepicklist255
nameAccount Namestring255
news_page__cNews Pageurl255
non_discretionary_assets__cNon-Discretionary Assetscurrency0
number_of_qps__c# of QPsdouble0
ocio_business__cOCIO Businesspicklist255
opportunity_description__cOpportunity Descriptiontextarea131072
pn__cPNstring4
parentidParent Account IDreference to: Account18
parent_account__cParent Accountreference to: Account18
participants_eoy__cParticipants EOYdouble0
phoneAccount Phonephone40
plan_codes__cPlan Codesstring50
plan_type__cPlan Typepicklist255
plan_year__cPlan Yearstring4
platform_description__cPlatform Descriptiontextarea131072
preferred_investment_vehicle__cPreferred Investment Vehiclepicklist255
private_credit_consultant_name__cPrivate Credit Consultant Namestring1300
private_credit_consultant__cPrivate Credit Consultantreference to: Account18
private_credit__cPrivate Creditpicklist255
private_equity_consultant_name__cPrivate Equity Consultant Namestring1300
private_equity_consultant__cPrivate Equity Consultantreference to: Account18
private_equity_fof__cPrivate Equity FOFpicklist255
private_equity__cPrivate Equitypicklist255
private_real_estate__cPrivate Real Estatepicklist255
quarterly_annual_report__cQuarterly/Annual Reporturl255
ric_usage__cRIC Usagepicklist255
real_assets__cReal Assetspicklist255
real_estate_consultant_name__cReal Estate Consultant Namestring1300
real_estate_consultant__cReal Estate Consultantreference to: Account18
real_estate_fof__cReal Estate FOFpicklist255
recordtypeidRecord Type IDreference to: RecordType18
research_team_overview__cResearch Team Overviewtextarea131072
select_lists__cSelect Listspicklist255
separate_account_usage__cSeparate Account Usagepicklist255
small_cap_equities__cSmall Cap Equitiespicklist255
sub_advised_mf_family__cSub-Advised MF Familystring100
tamp_name__cTAMP Namestring1300
tamp__cTAMPreference to: Account18
total_participants__cTotal Participantsdouble0
typeAccount Typepicklist255
ucits_usage__cUCITS Usagepicklist255
uhnw_division_name__cUHNW Division Namestring1300
uhnw_division__cUHNW Divisionreference to: Account18
uma_usage__cUMA Usagepicklist255
venture_capital__cVenture Capitalpicklist255
websiteWebsiteurl255
x1031_exchange__c1031 Exchangepicklist255