invantive documentation
Invantive Support ForumsLog In / Sign Up

AdministrationAddressPhoneNumbers: Minox Administration Address Phone Numbers

read only per partition REST

  • Catalog: Minox
  • Schema: MasterDataAdministration
  • Label: Administration Address Phone Numbers

Retrieves a single administration.

The data in this table is partitioned per value of the administration_code column.

Can only retrieve data.

API Source

  • Endpoint: /tenant/{tenant_id}/administration/{administration_id}
  • Operation: get /tenant/{tenant_id}/administration/{administration_id}

Table Columns

The columns of the table AdministrationAddressPhoneNumbers are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
address_type varchar2 Address Type writable, ::ancestor.address_type The address type.
bank_account varchar2 Bank Account filters on the platform, writable, ::ancestor.::ancestor.bank_account
chamber_of_commerce_city varchar2 Chamber Of Commerce City filters on the platform, writable, ::ancestor.::ancestor.chamber_of_commerce.city
chamber_of_commerce_id varchar2 Chamber Of Commerce ID filters on the platform, writable, ::ancestor.::ancestor.chamber_of_commerce.id
city varchar2 City writable, ::ancestor.city The city of where it is located.
contact_email varchar2 Contact Email filters on the platform, writable, ::ancestor.::ancestor.contact.email
contact_name varchar2 Contact Name writable, ::ancestor.contact_name The name of the contact person.
contact_name_2 varchar2 itgen_minox_contact_name_2 filters on the platform, writable, ::ancestor.::ancestor.contact.name
contact_salutation varchar2 Contact Salutation filters on the platform, writable, ::ancestor.::ancestor.contact.salutation
country_code varchar2 Country Code writable, ::ancestor.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 filters on the platform, writable, ::ancestor.::ancestor.currency.description
currency_exchange_rate decimal Currency Exchange Rate filters on the platform, writable, ::ancestor.::ancestor.currency.exchange_rate
currency_id varchar2 Currency ID filters on the platform, writable, ::ancestor.::ancestor.currency.id
decimals_amount int64 Decimals Amount filters on the platform, writable, ::ancestor.::ancestor.decimals.amount
decimals_volume int64 Decimals Volume filters on the platform, writable, ::ancestor.::ancestor.decimals.volume
declaration_type varchar2 Declaration Type filters on the platform, writable, ::ancestor.::ancestor.declaration_type
extended_name varchar2 Extended Name writable, ::ancestor.extended_name The extended name of the company.
follow_up_description_extra_description varchar2 Follow Up Description Extra Description filters on the platform, writable, ::ancestor.::ancestor.follow_up_description.extra_description
follow_up_description_invoice_texts char Follow Up Description Invoice Texts filters on the platform, writable, ::ancestor.::ancestor.follow_up_description.invoice_texts
follow_up_description_manual_descriptions char Follow Up Description Manual Descriptions filters on the platform, writable, ::ancestor.::ancestor.follow_up_description.manual_descriptions
follow_up_description_under_or_after varchar2 Follow Up Description Under or After filters on the platform, writable, ::ancestor.::ancestor.follow_up_description.under_or_after
g_rekening_iban varchar2 G-Account IBAN filters on the platform, writable, ::ancestor.::ancestor.g_rekening.iban
g_rekening_percentage decimal G-Account Percentage filters on the platform, writable, ::ancestor.::ancestor.g_rekening.percentage
id varchar2 ID writable, ::ancestor.id The unique identifier of a delivery address.
id_2 int64 itgen_minox_id_2 filters on the platform, writable, ::ancestor.::ancestor.id
incasso_mandate_id varchar2 Incasso Mandate ID filters on the platform, writable, ::ancestor.::ancestor.incasso_mandate_id
include_invoice varchar2 Include Invoice filters on the platform, writable, ::ancestor.::ancestor.include_invoice
ledger_accounts_automatic_payments_description varchar2 Ledger Accounts Automatic Payments Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.automatic_payments.description
ledger_accounts_automatic_payments_id varchar2 Ledger Accounts Automatic Payment ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.automatic_payments.id
ledger_accounts_automatic_payments_scheme varchar2 Ledger Accounts Automatic Payment Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.automatic_payments.scheme
ledger_accounts_automatic_payments_type varchar2 Ledger Accounts Automatic Payment Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.automatic_payments.type
ledger_accounts_debt_collection_description varchar2 Ledger Accounts Debt Collection Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.debt_collection.description
ledger_accounts_debt_collection_id varchar2 Ledger Accounts Debt Collection ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.debt_collection.id
ledger_accounts_debt_collection_scheme varchar2 Ledger Accounts Debt Collection Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.debt_collection.scheme
ledger_accounts_debt_collection_type varchar2 Ledger Accounts Debt Collection Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.debt_collection.type
ledger_accounts_exchange_rate_description varchar2 Ledger Accounts Exchange Rate Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.exchange_rate.description
ledger_accounts_exchange_rate_id varchar2 Ledger Accounts Exchange Rate ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.exchange_rate.id
ledger_accounts_exchange_rate_scheme varchar2 Ledger Accounts Exchange Rate Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.exchange_rate.scheme
ledger_accounts_exchange_rate_type varchar2 Ledger Accounts Exchange Rate Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.exchange_rate.type
ledger_accounts_invoice_high_description varchar2 Ledger Accounts Invoice High Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_high.description
ledger_accounts_invoice_high_id varchar2 Ledger Accounts Invoice High ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_high.id
ledger_accounts_invoice_high_scheme varchar2 Ledger Accounts Invoice High Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_high.scheme
ledger_accounts_invoice_high_type varchar2 Ledger Accounts Invoice High Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_high.type
ledger_accounts_invoice_low_description varchar2 Ledger Accounts Invoice Low Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_low.description
ledger_accounts_invoice_low_id varchar2 Ledger Accounts Invoice Low ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_low.id
ledger_accounts_invoice_low_scheme varchar2 Ledger Accounts Invoice Low Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_low.scheme
ledger_accounts_invoice_low_type varchar2 Ledger Accounts Invoice Low Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_low.type
ledger_accounts_invoice_zero_description varchar2 Ledger Accounts Invoice Zero Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_zero.description
ledger_accounts_invoice_zero_id varchar2 Ledger Accounts Invoice Zero ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_zero.id
ledger_accounts_invoice_zero_scheme varchar2 Ledger Accounts Invoice Zero Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_zero.scheme
ledger_accounts_invoice_zero_type varchar2 Ledger Accounts Invoice Zero Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.invoice_zero.type
ledger_accounts_paid_received_vat_description varchar2 Ledger Accounts Paid Received VAT Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.paid_received_vat.description
ledger_accounts_paid_received_vat_id varchar2 Ledger Accounts Paid Received VAT ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.paid_received_vat.id
ledger_accounts_paid_received_vat_scheme varchar2 Ledger Accounts Paid Received VAT Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.paid_received_vat.scheme
ledger_accounts_paid_received_vat_type varchar2 Ledger Accounts Paid Received VAT Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.paid_received_vat.type
ledger_accounts_private_vat_description varchar2 Ledger Accounts Private VAT Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.private_vat.description
ledger_accounts_private_vat_id varchar2 Ledger Accounts Private VAT ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.private_vat.id
ledger_accounts_private_vat_scheme varchar2 Ledger Accounts Private VAT Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.private_vat.scheme
ledger_accounts_private_vat_type varchar2 Ledger Accounts Private VAT Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.private_vat.type
ledger_accounts_profit_loss_description varchar2 Ledger Accounts Profit Loss Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.profit_loss.description
ledger_accounts_profit_loss_id varchar2 Ledger Accounts Profit Loss ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.profit_loss.id
ledger_accounts_profit_loss_scheme varchar2 Ledger Accounts Profit Loss Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.profit_loss.scheme
ledger_accounts_profit_loss_type varchar2 Ledger Accounts Profit Loss Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.profit_loss.type
ledger_accounts_transaction_rounding_description varchar2 Ledger Accounts Transaction Rounding Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.transaction_rounding.description
ledger_accounts_transaction_rounding_id varchar2 Ledger Accounts Transaction Rounding ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.transaction_rounding.id
ledger_accounts_transaction_rounding_scheme varchar2 Ledger Accounts Transaction Rounding Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.transaction_rounding.scheme
ledger_accounts_transaction_rounding_type varchar2 Ledger Accounts Transaction Rounding Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.transaction_rounding.type
ledger_accounts_unknown_transactions_description varchar2 Ledger Accounts Unknown Transactions Description filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.unknown_transactions.description
ledger_accounts_unknown_transactions_id varchar2 Ledger Accounts Unknown Transactions ID filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.unknown_transactions.id
ledger_accounts_unknown_transactions_scheme varchar2 Ledger Accounts Unknown Transactions Scheme filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.unknown_transactions.scheme
ledger_accounts_unknown_transactions_type varchar2 Ledger Accounts Unknown Transactions Type filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.unknown_transactions.type
ledger_accounts_vat_in_europe_gl_account_description varchar2 Ledger Accounts VAT In Europe GL Account Description filters on the platform, writable, ::ancestor.::ancestor.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 filters on the platform, writable, ::ancestor.::ancestor.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 filters on the platform, writable, ::ancestor.::ancestor.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 filters on the platform, writable, ::ancestor.::ancestor.ledger_accounts.vat_in_europe_gl_account.type
memo_action_text varchar2 Memo Action Text filters on the platform, writable, ::ancestor.::ancestor.memo_action.text Memo to note actions that must be undertaken
memo_assignation_text varchar2 Memo Assignation Text filters on the platform, writable, ::ancestor.::ancestor.memo_assignation.text Memo to note permanent agreements
memo_text varchar2 Memo Text filters on the platform, writable, ::ancestor.::ancestor.memo.text Deprecated / Not in use
name varchar2 Name writable, ::ancestor.name The company name.
name_2 varchar2 itgen_minox_name_2 filters on the platform, writable, ::ancestor.::ancestor.name
new_document varchar2 New Document filters on the platform, writable, ::ancestor.::ancestor.new_document
next_number_invoice_number int64 Next Number Invoice Number filters on the platform, writable, ::ancestor.::ancestor.next_number.invoice_number
next_number_order_number int64 Next Number Order Number filters on the platform, writable, ::ancestor.::ancestor.next_number.order_number
next_number_quotation_number int64 Next Number Quotation Number filters on the platform, writable, ::ancestor.::ancestor.next_number.quotation_number
next_number_subscription_number int64 Next Number Subscription Number filters on the platform, writable, ::ancestor.::ancestor.next_number.subscription_number
number_of_periods int64 Number of Periods filters on the platform, writable, ::ancestor.::ancestor.number_of_periods
order_collection_sorting varchar2 Order Collection Sorting filters on the platform, writable, ::ancestor.::ancestor.order_collection_sorting
phone_number varchar2 Phone Number writable, phone_number The phone number.
phone_number_type varchar2 Phone Number Type writable, phone_number_type
postal_code varchar2 Postal Code writable, ::ancestor.postal_code The postal code.
salutation varchar2 Salutation writable, ::ancestor.salutation The salutation of the contact person.
search varchar2 Search writable, ::ancestor.search The search name of the delivery address.
share_id varchar2 Share ID filters on the platform, writable, ::ancestor.::ancestor.share_id
show_on_accountancy_dashboard char Show On Accountancy Dashboard filters on the platform, writable, ::ancestor.::ancestor.show_on_accountancy_dashboard
streetname_and_number varchar2 Street Name And Number writable, ::ancestor.streetname_and_number The name of the street and house number.
tax_sourcing_method varchar2 Tax Sourcing Method filters on the platform, writable, ::ancestor.::ancestor.tax_sourcing.method
tax_sourcing_provided_by_becon_number varchar2 Tax Sourcing Provided by Becon Number filters on the platform, writable, ::ancestor.::ancestor.tax_sourcing.provided_by.becon_number
tax_sourcing_provided_by_contact varchar2 Tax Sourcing Provided by Contact filters on the platform, writable, ::ancestor.::ancestor.tax_sourcing.provided_by.contact
tax_sourcing_provided_by_phone_number varchar2 Tax Sourcing Provided by Phone Number filters on the platform, writable, ::ancestor.::ancestor.tax_sourcing.provided_by.phone_number
uuid varchar2 UUID filters on the platform, writable, ::ancestor.::ancestor.uuid
vat_codes_high_vat_id int64 VAT Codes High VAT ID filters on the platform, writable, ::ancestor.::ancestor.vat_codes.high_vat_id
vat_codes_low_vat_id int64 VAT Codes Low VAT ID filters on the platform, writable, ::ancestor.::ancestor.vat_codes.low_vat_id
vat_id varchar2 VAT ID filters on the platform, writable, ::ancestor.::ancestor.vat_id
vat_in_europe_threshold_active char VAT in Europe Threshold Active filters on the platform, writable, ::ancestor.::ancestor.vat_in_europe_threshold_active
vat_number varchar2 VAT Number filters on the platform, writable, ::ancestor.::ancestor.vat_number
vat_on_sub char VAT On Sub filters on the platform, writable, ::ancestor.::ancestor.vat_on_sub
write_off_vat_difference_until decimal Write Off VAT Difference Until filters on the platform, writable, ::ancestor.::ancestor.write_off_vat_difference_until
www varchar2 www writable, ::ancestor.www The website.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

Changes of This Table, 26.0 to 27.0

  • - administration_code
  • - administration_name

All changes of the driver, 26.0 to 27.0