# FiscalYears: Minox Fiscal Years Retrieves an administration list. - Catalog: `Minox` - Schema: `MasterDataAdministration` - Label: Fiscal Years The data in this table is partitioned per value of the `administration_code` column. This is a read-only table. The Minox API may not support changing the data or the Invantive UniversalSQL driver for Minox does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Minox API. ## Table Columns The columns of the table `FiscalYears` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `bank_account` | `varchar2` | Bank Account | ☐ | | | `chamber_of_commerce_city` | `varchar2` | Chamber Of Commerce City | ☐ | | | `chamber_of_commerce_id` | `varchar2` | Chamber Of Commerce ID | ☐ | | | `contact_email` | `varchar2` | Contact Email | ☐ | | | `contact_name` | `varchar2` | Contact Name | ☐ | | | `contact_salutation` | `varchar2` | Contact Salutation | ☐ | | | `currency_description` | `varchar2` | Currency Description | ☐ | | | `currency_exchange_rate` | `decimal` | Currency Exchange Rate | ☐ | | | `currency_id` | `varchar2` | Currency ID | ☐ | | | `decimals_amount` | `int64` | Decimals Amount | ☐ | | | `decimals_volume` | `int64` | Decimals Volume | ☐ | | | `declaration_type` | `varchar2` | Declaration Type | ☐ | | | `end_date` | `datetime` | End Date | ☐ | | | `fiscal_year` | `int64` | Fiscal Year | ☐ | | | `follow_up_description_extra_description` | `varchar2` | Follow Up Description Extra Description | ☐ | | | `follow_up_description_invoice_texts` | `char` | Follow Up Description Invoice Texts | ☐ | | | `follow_up_description_manual_descriptions` | `char` | Follow Up Description Manual Descriptions | ☐ | | | `follow_up_description_under_or_after` | `varchar2` | Follow Up Description Under or After | ☐ | | | `g_rekening_iban` | `varchar2` | G-Account IBAN | ☐ | | | `g_rekening_percentage` | `decimal` | G-Account Percentage | ☐ | | | `id_2` | `int64` | | ☐ | | | `id` | `varchar2` | ID | ☐ | | | `incasso_mandate_id` | `varchar2` | Incasso Mandate ID | ☐ | | | `include_invoice` | `varchar2` | Include Invoice | ☐ | | | `indefinitely_closed_until_period` | `int64` | Indefinitely Closed until Period | ☐ | This fiscal year is closed until the given period. It might still be reopened back up to 'permanently_closed_until_period'. No more transactions can be created in these periods. | | `memo_action_text` | `varchar2` | Memo Action Text | ☐ | Memo to note actions that must be undertaken | | `memo_assignation_text` | `varchar2` | Memo Assignation Text | ☐ | Memo to note permanent agreements | | `memo_text` | `varchar2` | Memo Text | ☐ | Deprecated / Not in use | | `name` | `varchar2` | Name | ☐ | | | `new_document` | `varchar2` | New Document | ☐ | | | `next_number_invoice_number` | `int64` | Next Number Invoice Number | ☐ | | | `next_number_order_number` | `int64` | Next Number Order Number | ☐ | | | `next_number_quotation_number` | `int64` | Next Number Quotation Number | ☐ | | | `next_number_subscription_number` | `int64` | Next Number Subscription Number | ☐ | | | `number_of_periods_2` | `int64` | | ☐ | | | `number_of_periods` | `int64` | Number of Periods | ☐ | | | `order_collection_sorting` | `varchar2` | Order Collection Sorting | ☐ | | | `permanently_closed_until_period` | `int64` | Permanently Closed Until Period | ☐ | This fiscal year is closed until the given period. No more transactions can be created in these periods. | | `share_id` | `varchar2` | Share ID | ☐ | | | `show_on_accountancy_dashboard` | `char` | Show On Accountancy Dashboard | ☐ | | | `start_date` | `datetime` | Start Date | ☐ | | | `tax_sourcing_method` | `varchar2` | Tax Sourcing Method | ☐ | | | `uuid` | `varchar2` | UUID | ☐ | | | `vat_codes_high_vat_id` | `int64` | VAT Codes High VAT ID | ☐ | | | `vat_codes_low_vat_id` | `int64` | VAT Codes Low VAT ID | ☐ | | | `vat_id` | `varchar2` | VAT ID | ☐ | | | `vat_in_europe_threshold_active` | `char` | VAT in Europe Threshold Active | ☐ | | | `vat_number` | `varchar2` | VAT Number | ☐ | | | `vat_on_sub` | `char` | VAT On Sub | ☐ | | | `write_off_vat_difference_until` | `decimal` | Write Off VAT Difference Until | ☐ | |