# AdministrationFiscalYears: Minox Administration Fiscal Years Retrieves a single administration. - Catalog: `Minox` - Schema: `MasterDataAdministration` - Label: Administration 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 `AdministrationFiscalYears` 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. | | `ledger_accounts_automatic_payments_description` | `varchar2` | Ledger Accounts Automatic Payments Description | ☐ | | | `ledger_accounts_automatic_payments_id` | `varchar2` | Ledger Accounts Automatic Payment ID | ☐ | | | `ledger_accounts_automatic_payments_scheme` | `varchar2` | Ledger Accounts Automatic Payment Scheme | ☐ | | | `ledger_accounts_automatic_payments_type` | `varchar2` | Ledger Accounts Automatic Payment Type | ☐ | | | `ledger_accounts_debt_collection_description` | `varchar2` | Ledger Accounts Debt Collection Description | ☐ | | | `ledger_accounts_debt_collection_id` | `varchar2` | Ledger Accounts Debt Collection ID | ☐ | | | `ledger_accounts_debt_collection_scheme` | `varchar2` | Ledger Accounts Debt Collection Scheme | ☐ | | | `ledger_accounts_debt_collection_type` | `varchar2` | Ledger Accounts Debt Collection Type | ☐ | | | `ledger_accounts_exchange_rate_description` | `varchar2` | Ledger Accounts Exchange Rate Description | ☐ | | | `ledger_accounts_exchange_rate_id` | `varchar2` | Ledger Accounts Exchange Rate ID | ☐ | | | `ledger_accounts_exchange_rate_scheme` | `varchar2` | Ledger Accounts Exchange Rate Scheme | ☐ | | | `ledger_accounts_exchange_rate_type` | `varchar2` | Ledger Accounts Exchange Rate Type | ☐ | | | `ledger_accounts_invoice_high_description` | `varchar2` | Ledger Accounts Invoice High Description | ☐ | | | `ledger_accounts_invoice_high_id` | `varchar2` | Ledger Accounts Invoice High ID | ☐ | | | `ledger_accounts_invoice_high_scheme` | `varchar2` | Ledger Accounts Invoice High Scheme | ☐ | | | `ledger_accounts_invoice_high_type` | `varchar2` | Ledger Accounts Invoice High Type | ☐ | | | `ledger_accounts_invoice_low_description` | `varchar2` | Ledger Accounts Invoice Low Description | ☐ | | | `ledger_accounts_invoice_low_id` | `varchar2` | Ledger Accounts Invoice Low ID | ☐ | | | `ledger_accounts_invoice_low_scheme` | `varchar2` | Ledger Accounts Invoice Low Scheme | ☐ | | | `ledger_accounts_invoice_low_type` | `varchar2` | Ledger Accounts Invoice Low Type | ☐ | | | `ledger_accounts_invoice_zero_description` | `varchar2` | Ledger Accounts Invoice Zero Description | ☐ | | | `ledger_accounts_invoice_zero_id` | `varchar2` | Ledger Accounts Invoice Zero ID | ☐ | | | `ledger_accounts_invoice_zero_scheme` | `varchar2` | Ledger Accounts Invoice Zero Scheme | ☐ | | | `ledger_accounts_invoice_zero_type` | `varchar2` | Ledger Accounts Invoice Zero Type | ☐ | | | `ledger_accounts_paid_received_vat_description` | `varchar2` | Ledger Accounts Paid Received VAT Description | ☐ | | | `ledger_accounts_paid_received_vat_id` | `varchar2` | Ledger Accounts Paid Received VAT ID | ☐ | | | `ledger_accounts_paid_received_vat_scheme` | `varchar2` | Ledger Accounts Paid Received VAT Scheme | ☐ | | | `ledger_accounts_paid_received_vat_type` | `varchar2` | Ledger Accounts Paid Received VAT Type | ☐ | | | `ledger_accounts_private_vat_description` | `varchar2` | Ledger Accounts Private VAT Description | ☐ | | | `ledger_accounts_private_vat_id` | `varchar2` | Ledger Accounts Private VAT ID | ☐ | | | `ledger_accounts_private_vat_scheme` | `varchar2` | Ledger Accounts Private VAT Scheme | ☐ | | | `ledger_accounts_private_vat_type` | `varchar2` | Ledger Accounts Private VAT Type | ☐ | | | `ledger_accounts_profit_loss_description` | `varchar2` | Ledger Accounts Profit Loss Description | ☐ | | | `ledger_accounts_profit_loss_id` | `varchar2` | Ledger Accounts Profit Loss ID | ☐ | | | `ledger_accounts_profit_loss_scheme` | `varchar2` | Ledger Accounts Profit Loss Scheme | ☐ | | | `ledger_accounts_profit_loss_type` | `varchar2` | Ledger Accounts Profit Loss Type | ☐ | | | `ledger_accounts_transaction_rounding_description` | `varchar2` | Ledger Accounts Transaction Rounding Description | ☐ | | | `ledger_accounts_transaction_rounding_id` | `varchar2` | Ledger Accounts Transaction Rounding ID | ☐ | | | `ledger_accounts_transaction_rounding_scheme` | `varchar2` | Ledger Accounts Transaction Rounding Scheme | ☐ | | | `ledger_accounts_transaction_rounding_type` | `varchar2` | Ledger Accounts Transaction Rounding Type | ☐ | | | `ledger_accounts_unknown_transactions_description` | `varchar2` | Ledger Accounts Unknown Transactions Description | ☐ | | | `ledger_accounts_unknown_transactions_id` | `varchar2` | Ledger Accounts Unknown Transactions ID | ☐ | | | `ledger_accounts_unknown_transactions_scheme` | `varchar2` | Ledger Accounts Unknown Transactions Scheme | ☐ | | | `ledger_accounts_unknown_transactions_type` | `varchar2` | Ledger Accounts Unknown Transactions Type | ☐ | | | `ledger_accounts_vat_in_europe_gl_account_description` | `varchar2` | Ledger Accounts VAT In Europe GL Account Description | ☐ | | | `ledger_accounts_vat_in_europe_gl_account_id` | `varchar2` | Ledger Accounts VAT In Europe GL Account ID | ☐ | | | `ledger_accounts_vat_in_europe_gl_account_scheme` | `varchar2` | Ledger Accounts VAT In Europe GL Account Scheme | ☐ | | | `ledger_accounts_vat_in_europe_gl_account_type` | `varchar2` | Ledger Accounts VAT In Europe GL Account Type | ☐ | | | `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 | ☐ | | | `tax_sourcing_provided_by_becon_number` | `varchar2` | Tax Sourcing Provided by Becon Number | ☐ | | | `tax_sourcing_provided_by_contact` | `varchar2` | Tax Sourcing Provided by Contact | ☐ | | | `tax_sourcing_provided_by_phone_number` | `varchar2` | Tax Sourcing Provided by Phone Number | ☐ | | | `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 | ☐ | |