layouttitle
schemaaccount

Account Schema


An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.

Properties

NameDescriptionTypeEnum
id
The unique identifier for the record within the firm.
string-
date
The observation or value date for the data in this object. Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
acc_fv_change_before_taxes
Accumulated change in fair value before taxes.
integer-
accounting_treatment
An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.
string
amortised_costavailable_for_salecb_or_demandfv_mandatorilyfv_ocifv_thru_pnlheld_for_hedgeheld_for_tradingheld_to_maturityloans_and_recs
accrued_interest
The accrued interest since the last payment date and due at the next payment date. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
arrears_balance
The balance of the capital amount that is considered to be in arrears (for overdrafts/credit cards). Monetary type represented as a naturally positive integer number of cents/pence.
integer-
asset_liability
An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.
string
assetequityliabilitypnl
balance
The contractual balance on the date and in the currency given. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
base_rate
The base rate represents the basis of the rate on the balance at the given date as agreed in the terms of the account.
string
FDTRUKBRBASEZERO
behavioral_curve_id
The unique identifier for the behavioral curve used by the financial institution.
string-
break_dates
Dates where this contract can be broken (by either party). Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
array-
call_dates
Dates where this contract can be called (by the customer). Formatted as YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
array-
ccf
An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.
number-
cost_center_code
The organizational unit or sub-unit to which costs/profits are booked.
string-
count
Describes the number of accounts aggregated into a single row.
integer-
country_code
An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.
string
AAADAEAFAGAIALAMAOAQARASATAUAWAXAZBABBBDBEBFBGBHBIBJBLBMBNBOBQBRBSBTBVBWBYBZCACCCDCFCGCHCICKCLCMCNCOCRCUCVCWCXCYCZDEDJDKDMDODZECEEEGEHERESETFIFJFKFMFOFRGAGBGDGEGFGGGHGIGLGMGNGPGQGRGSGTGUGWGYHKHMHNHRHTHUIDIEILIMINIOIQIRISITJEJMJOJPKEKGKHKIKMKNKPKRKWKYKZLALBLCLILKLRLSLTLULVLYMAMCMDMEMFMGMHMKMLMMMNMOMPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFPGPHPKPLPMPNPRPSPTPWPYQAQMQNQOQPQQQRQSQTQUQVQWQXQYQZRERORSRURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSSSTSVSXSYSZTCTDTFTGTHTJTKTLTMTNTOTRTTTVTWTZUAUGUMUSUYUZVAVCVEVGVIVNVUWFWSXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZYEYTZAZMZWZZ
currency_code
An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.
string
AEDAFNALLAMDANGAOAARSAUDAWGAZNBAMBBDBDTBGNBHDBIFBMDBNDBOBBOVBRLBSDBTNBWPBYNBZDCADCDFCHECHFCHWCLFCLPCNHCNYCOPCOUCRCCUCCUPCVECZKDJFDKKDOPDZDEGPERNETBEURFJDFKPGBPGELGHSGIPGMDGNFGTQGYDHKDHNLHRKHTGHUFIDRILSINRIQDIRRISKJMDJODJPYKESKGSKHRKMFKPWKRWKWDKYDKZTLAKLBPLKRLRDLSLLYDMADMDLMGAMKDMMKMNTMOPMRUMURMVRMWKMXNMXVMYRMZNNADNGNNIONOKNPRNZDOMRPABPENPGKPHPPKRPLNPYGQARRONRSDRUBRWFSARSBDSCRSDGSEKSGDSHPSLLSOSSRDSSPSTNSYPSZLTHBTJSTMTTNDTOPTRYTTDTWDTZSUAHUGXUSDUSNUSSUYIUYUUYWUZSVESVNDVUVWSTXAFXAGXAUXBAXBBXBCXBDXCDXDRXOFXPDXPFXPTXSUXTSXUAXXXYERZARZMW
customer_id
The unique identifier used by the financial institution to identify the customer that owns the account.
string-
encumbrance_amount
The amount of the account that is encumbered by potential future commitments or legal liabilities. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
encumbrance_type
The type of the encumbrance causing the encumbrance_amount.
string
covered_bondderivativenoneotherrepo
end_date
The end or maturity date of the account. Format should be YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601
string-
first_payment_date
The first payment date for interest payments.
string-
fvh_level
Fair value hierarchy category according to IFRS 13.93 (b)
integer-
guarantee_amount
The amount of the account that is guaranteed under a Government Deposit Guarantee Scheme. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
guarantee_scheme
The Government Deposit Scheme scheme under which the guarantee_amount is guaranteed.
string
be_pfbg_difcy_dpscz_difde_edbde_edode_edwdk_gdfiee_dgses_fgdfi_dgffr_fdggb_fscsgr_dgshr_dihu_ndifie_dgsit_fitdlt_vilu_fgdllv_dgfmt_dcsnl_dgspl_bfgpt_fgdro_fgdbse_ndosi_dgssk_dpfus_fdic
impairment_amount
The impairment amount is the allowance set aside by the firm that accounts for the event that the asset becomes impaired in the future.
integer-
impairment_status
An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.
string
doubtfullossnon_performingnormalperformingstage_1stage_1_doubtfulstage_1_lossstage_1_normalstage_1_substandardstage_1_watchstage_2stage_2_doubtfulstage_2_lossstage_2_normalstage_2_substandardstage_2_watchstage_3stage_3_doubtfulstage_3_lossstage_3_normalstage_3_substandardstage_3_watchsubstandardwatch
insolvency_rank
The insolvency ranking as per the national legal framework of the reporting institution.
integer-
interest_repayment_frequency
Repayment frequency of the interest.
string
dailyweeklybi_weeklymonthlybi_monthlyquarterlysemi_annuallyannuallyat_maturitybienniallysesquiennially
last_payment_date
The final payment date for interest payments, often coincides with end_date.
string-
ledger_code
The internal ledger code or line item name.
string-
limit_amount
The minimum balance the customer can go overdrawn in their account.
integer-
minimum_balance_eur
Indicates the minimum balance, in Euros, of each account within the aggregate. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
mtd_deposits
Month to date amount deposited within the account as a naturally positive integer number of cents/pence.
integer-
mtd_interest_paid
Month to date interest added to account as a naturally positive integer number of cents/pence.
integer-
mtd_withdrawals
Month to date amount withdrawn from the account as a naturally positive integer number of cents/pence.
integer-
next_payment_date
The next date at which interest will be paid or accrued_interest balance returned to zero.
string-
next_repricing_date
The date on which the interest rate of the account will be re-calculated. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
next_withdrawal_date
The next date at which customer is allowed to withdraw money from this account.
string-
on_balance_sheet
Is the account or deposit reported on the balance sheet of the financial institution?
boolean-
prev_payment_date
The most recent previous date at which interest was paid or accrued_interest balance returned to zero.
string-
product_name
The name of the product as given by the financial institution to be used for display and reference purposes.
string-
purpose
The purpose for which the account was created or is being used.
string
adminannual_bonus_accrualsbenefit_in_kindcapital_gain_taxcash_managementcf_hedgeci_serviceclearingcollateralcommitmentscomputer_and_it_costcorporation_taxcredit_card_feecritical_servicecurrent_account_feecustodydealing_rev_derivdealing_rev_deriv_nsedealing_rev_fxdealing_rev_fx_nsedealing_rev_secdealing_rev_sec_nsedealing_revenuedepositderivative_feedgs_contributiondiv_from_cisdiv_from_money_mktdividenddonationemployeeemployee_stock_optionescrowfeesfinefirm_operating_expensesfirm_operationsfxgoodwillinsurance_feeint_on_bond_and_frnint_on_bridging_loanint_on_credit_cardint_on_depositint_on_deriv_hedgeint_on_derivativeint_on_ecgd_lendingint_on_loan_and_advint_on_money_mktint_on_mortgageint_on_sftinterestintra_group_feeinv_in_subsidiaryinvestment_banking_feeinvestment_propertyipsloan_and_advance_feemanufactured_dividendmortgage_feeni_contributionnon_life_ins_premiumoccupancy_costoperationaloperational_escrowoperational_excessotherother_expenditureother_fs_feeother_non_fs_feeother_social_contribother_staff_costother_staff_removerdraft_feeown_propertypensionppeprime_brokeragepropertyrecoveryredundancy_pymtreferencereg_lossregular_wagesreleaserentres_fund_contributionrestructuringretained_earningsrevaluationrevenue_reserveshare_planshare_premiumstaffsystemtaxunsecured_loan_feewrite_off
rate
The full interest rate applied to the account balance in percentage terms. Note that this therefore includes the base_rate (ie. not the spread).
number-
rate_type
Describes the type of interest rate applied to the account.
string
combinedfixedpreferentialtrackervariable
regulatory_book
An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.
string
banking_booktrading_book
reporting_entity_name
The name of the reporting legal entity for display purposes.
string-
reporting_id
The internal ID for the legal entity under which the account is being reported.
string-
risk_country_code
An Account represents a financial account that describes the funds that a customer has entrusted to a financial institution in the form of deposits or credit balances.
string
AAADAEAFAGAIALAMAOAQARASATAUAWAXAZBABBBDBEBFBGBHBIBJBLBMBNBOBQBRBSBTBVBWBYBZCACCCDCFCGCHCICKCLCMCNCOCRCUCVCWCXCYCZDEDJDKDMDODZECEEEGEHERESETFIFJFKFMFOFRGAGBGDGEGFGGGHGIGLGMGNGPGQGRGSGTGUGWGYHKHMHNHRHTHUIDIEILIMINIOIQIRISITJEJMJOJPKEKGKHKIKMKNKPKRKWKYKZLALBLCLILKLRLSLTLULVLYMAMCMDMEMFMGMHMKMLMMMNMOMPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFPGPHPKPLPMPNPRPSPTPWPYQAQMQNQOQPQQQRQSQTQUQVQWQXQYQZRERORSRURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSSSTSVSXSYSZTCTDTFTGTHTJTKTLTMTNTOTRTTTVTWTZUAUGUMUSUYUZVAVCVEVGVIVNVUWFWSXAXBXCXDXEXFXGXHXIXJXKXLXMXNXOXPXQXRXSXTXUXVXWXXXYXZYEYTZAZMZWZZ
risk_weight_std
The standardised approach risk weight represented as a decimal/float such that 1.5% is 0.015.
number-
source
The source(s) where this data originated. If more than one source needs to be stored for data lineage, it should be separated by a dash. eg. Source1-Source2
string-
start_date
The timestamp that the trade or financial product commences. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
status
Describes if the Account is active or been cancelled.
string
activecancelledcancelled_payout_agreedothertransactional
trade_date
The timestamp that the trade or financial product terms are agreed. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
type
This is the type of the account with regards to common regulatory classifications.
string
amortisationbondscallcdcredit_cardcurrentdeferreddepreciationexpenseincomeintangibleinternet_onlyiraisamoney_marketnon_deferrednon_productotherprepaid_cardprovisionreserveretail_bondssavingssuspensetangibletime_depositvostro
uk_funding_type
Funding type calculated according to BIPRU 12.5/12.6
string
ab
version_id
The version identifier of the data such as the firm’s internal batch identifier.
string-
withdrawal_penalty
This is the penalty incurred by the customer for an early withdrawal on this account. An early withdrawal is defined as a withdrawal prior to the next_withdrawal_date. Monetary type represented as a naturally positive integer number of cents/pence.
integer-