finance_fiscal_years


Description

https://dev.folio.org/reference/api/#mod-finance-storage

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 36 null
finance_budgets.fiscal_year_id finance_budgets_fiscal_year_id_fkeyR
finance_group_fund_fiscal_years.fiscal_year_id finance_group_fund_fiscal_years_fiscal_year_id_fkeyR
finance_ledgers.fiscal_year_one_id finance_ledgers_fiscal_year_one_id_fkeyR
finance_transactions.fiscal_year_id finance_transactions_fiscal_year_id_fkeyR
code varchar 6 √ null
currency varchar 3 √ null
name varchar 4 √ null
period_end timestamptz 35,6 √ null
period_start timestamptz 35,6 √ null
series varchar 2 √ null
data json 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
finance_fiscal_years_pkey Primary key Asc id
finance_fiscal_years_code_idx Performance Asc code
finance_fiscal_years_currency_idx Performance Asc currency
finance_fiscal_years_name_idx Performance Asc name
finance_fiscal_years_period_end_idx Performance Asc period_end
finance_fiscal_years_period_start_idx Performance Asc period_start
finance_fiscal_years_series_idx Performance Asc series

Relationships

Close relationships within degrees of separation