Data Dictionary

How to interpret enumerated values throughout Wealthtech API responses

Frequency Codes

Codes for various fields that describe periodic events

CodeDescription
DDaily
WWeekly
MMonthly
QQuarterly
YYearly

Transaction Codes

Codes for various transaction scenarios

CodeDescription
BTOBuy to Open
BTCBuy to Close
STOSell to Open
STCSell to Close
DEPCash Deposit
WITHCash Withdrawal
TLOSecurity Transfer to Open Long
TLCSecurity Transfer to Close Long
TSOSecurity Transfer to Open Short
TSCSecurity Transfer to Close Short
SLOSplit to Open Long
SLCSplit to Close Long
SSOSplit to Open Short
SSCSplit to Close Short
INCIncome
EXPExpense
ILOInitial Security Position Long
ISOInitial Security Position Short
ICCInitial Cash Position
MCManual Account Contribution
MWManual Account Withdrawal
MHINCManual Account Income
MHEXPManual Account Expense
IMLManual Account Initial Position

Billing Calculation Types

Different metrics for billing rates

TypeDescription
RFlat rate
AFlat account fee
GFlat group fee
DDrop through
TTiered
FFavor

Billing Collection Types

The different methods of billing collection

TypeDescription
RArrears
DAdvance only
PAdvance with proration

Billing Quarter Cycle Codes

Billing cycles and the respective months covered

CodeName
1One
2Two
3Standard

Shared File Types

The different possible file formats of shared files

TypeDescription
1Text file
2Word document
3PDF document
4Powerpoint presentation
5Excel spreadsheet
6Archive
7Image

Account Types

Top 30 account types. We accept all account types from the custodians we're connected to and record them as-is.

Type
IRA
Roth IRA
Rollover IRA
Individual
Trust
JTWROS
Simple IRA
UGMA-UTMA
Inherited IRA
Traditional Beneficiary IRA
Corporation
401k
Corporation
Tax Exempt
Community Property
Limited Partnership
Schwab One
Individual 401K
Limited Liability
Security Benefit
Contributory IRA
Traditional IRA
Estate
Profit Sharing Plan
Minor Roth IRA
Education Savings Account
Tenants by the Entirety
Tenants In Common
Nationwide Annuity IRA
Nationwide IRA