# AdministrationAddresses: Minox Administration Addresses Retrieves an administration list. - Catalog: `Minox` - Schema: `MasterDataAdministration` - Label: Administration Addresses 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 `AdministrationAddresses` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `address_type` | `varchar2` | Address Type | ☐ | The address type. | | `bank_account` | `varchar2` | Bank Account | ☐ | | | `chamber_of_commerce_city` | `varchar2` | Chamber Of Commerce City | ☐ | | | `chamber_of_commerce_id` | `varchar2` | Chamber Of Commerce ID | ☐ | | | `city` | `varchar2` | City | ☐ | The city of where it is located. | | `contact_email` | `varchar2` | Contact Email | ☐ | | | `contact_name_2` | `varchar2` | | ☐ | | | `contact_name` | `varchar2` | Contact Name | ☐ | The name of the contact person. | | `contact_salutation` | `varchar2` | Contact Salutation | ☐ | | | `country_code` | `varchar2` | Country Code | ☐ | An ISO-3166-1-alpha2 country code. See https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2#Officially_assigned_code_elements for more information. | | `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 | ☐ | | | `extended_name` | `varchar2` | Extended Name | ☐ | The extended name of the company. | | `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 | ☐ | The unique identifier of a delivery address. | | `incasso_mandate_id` | `varchar2` | Incasso Mandate ID | ☐ | | | `include_invoice` | `varchar2` | Include Invoice | ☐ | | | `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_2` | `varchar2` | | ☐ | | | `name` | `varchar2` | Name | ☐ | The company 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` | `int64` | Number of Periods | ☐ | | | `order_collection_sorting` | `varchar2` | Order Collection Sorting | ☐ | | | `postal_code` | `varchar2` | Postal Code | ☐ | The postal code. | | `salutation` | `varchar2` | Salutation | ☐ | The salutation of the contact person. | | `search` | `varchar2` | Search | ☐ | The search name of the delivery address. | | `share_id` | `varchar2` | Share ID | ☐ | | | `show_on_accountancy_dashboard` | `char` | Show On Accountancy Dashboard | ☐ | | | `streetname_and_number` | `varchar2` | Street Name And Number | ☐ | The name of the street and house number. | | `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 | ☐ | | | `www` | `varchar2` | www | ☐ | The website. |