invantive documentation
Invantive Support ForumsLog In / Sign Up

Administrations: Minox Administrations

read only per partition REST

  • Catalog: Minox
  • Schema: MasterDataAdministration
  • Label: Administrations

Retrieves an administration list.

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
  • Operation: get /tenant/{tenant_id}/administration

Table Columns

The columns of the table Administrations 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
bank_account varchar2 Bank Account filters on the platform, writable, bank_account
chamber_of_commerce_city varchar2 Chamber Of Commerce City filters on the platform, writable, chamber_of_commerce.city
chamber_of_commerce_id varchar2 Chamber Of Commerce ID filters on the platform, writable, chamber_of_commerce.id
contact_email varchar2 Contact Email filters on the platform, writable, contact.email
contact_name varchar2 Contact Name filters on the platform, writable, contact.name
contact_salutation varchar2 Contact Salutation filters on the platform, writable, contact.salutation
currency_description varchar2 Currency Description filters on the platform, writable, currency.description
currency_exchange_rate decimal Currency Exchange Rate filters on the platform, writable, currency.exchange_rate
currency_id varchar2 Currency ID filters on the platform, writable, currency.id
decimals_amount int64 Decimals Amount filters on the platform, writable, decimals.amount
decimals_volume int64 Decimals Volume filters on the platform, writable, decimals.volume
declaration_type varchar2 Declaration Type filters on the platform, writable, declaration_type
follow_up_description_extra_description varchar2 Follow Up Description Extra Description filters on the platform, writable, follow_up_description.extra_description
follow_up_description_invoice_texts char Follow Up Description Invoice Texts filters on the platform, writable, follow_up_description.invoice_texts
follow_up_description_manual_descriptions char Follow Up Description Manual Descriptions filters on the platform, writable, follow_up_description.manual_descriptions
follow_up_description_under_or_after varchar2 Follow Up Description Under or After filters on the platform, writable, follow_up_description.under_or_after
g_rekening_iban varchar2 G-Account IBAN filters on the platform, writable, g_rekening.iban
g_rekening_percentage decimal G-Account Percentage filters on the platform, writable, g_rekening.percentage
id int64 ID filters on the platform, writable, id
incasso_mandate_id varchar2 Incasso Mandate ID filters on the platform, writable, incasso_mandate_id
include_invoice varchar2 Include Invoice filters on the platform, writable, include_invoice
memo_action_text varchar2 Memo Action Text filters on the platform, writable, memo_action.text Memo to note actions that must be undertaken
memo_assignation_text varchar2 Memo Assignation Text filters on the platform, writable, memo_assignation.text Memo to note permanent agreements
memo_text varchar2 Memo Text filters on the platform, writable, memo.text Deprecated / Not in use
name varchar2 Name filters on the platform, writable, name
new_document varchar2 New Document filters on the platform, writable, new_document
next_number_invoice_number int64 Next Number Invoice Number filters on the platform, writable, next_number.invoice_number
next_number_order_number int64 Next Number Order Number filters on the platform, writable, next_number.order_number
next_number_quotation_number int64 Next Number Quotation Number filters on the platform, writable, next_number.quotation_number
next_number_subscription_number int64 Next Number Subscription Number filters on the platform, writable, next_number.subscription_number
number_of_periods int64 Number of Periods filters on the platform, writable, number_of_periods
order_collection_sorting varchar2 Order Collection Sorting filters on the platform, writable, order_collection_sorting
share_id varchar2 Share ID filters on the platform, writable, share_id
show_on_accountancy_dashboard char Show On Accountancy Dashboard filters on the platform, writable, show_on_accountancy_dashboard
tax_sourcing_method varchar2 Tax Sourcing Method filters on the platform, writable, tax_sourcing.method
uuid varchar2 UUID filters on the platform, writable, uuid
vat_codes_high_vat_id int64 VAT Codes High VAT ID filters on the platform, writable, vat_codes.high_vat_id
vat_codes_low_vat_id int64 VAT Codes Low VAT ID filters on the platform, writable, vat_codes.low_vat_id
vat_id varchar2 VAT ID filters on the platform, writable, vat_id
vat_in_europe_threshold_active char VAT in Europe Threshold Active filters on the platform, writable, vat_in_europe_threshold_active
vat_number varchar2 VAT Number filters on the platform, writable, vat_number
vat_on_sub char VAT On Sub filters on the platform, writable, vat_on_sub
write_off_vat_difference_until decimal Write Off VAT Difference Until filters on the platform, writable, write_off_vat_difference_until

Sample Queries

--
-- Retrieve companies from Minox.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/minox-data-model/webhelp/minox-connector-masterdataadministration-administrations.html
--
select *
from   Minox.MasterDataAdministration.Administrations@mnx
limit  100

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