invantive documentation
Invantive Support ForumsLog In / Sign Up

SupplierById: Minox Supplier by ID

read only per partition REST

  • Catalog: Minox
  • Schema: MasterDataSupplier
  • Label: Supplier by ID

Get the supplier using its identity.

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

Parameters

Name Data Type Required Default Documentation
administration_code `` Partition to retrieve data from.
supplier_id `` The supplier to access.

Table Columns

The columns of the table SupplierById 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
aggregation_aggregation_level int64 Aggregation Level filters on the platform, writable, aggregation.aggregation_level The level of the aggregation
aggregation_description varchar2 Aggregation Description filters on the platform, writable, aggregation.description The description of the aggregation.
bank_bic varchar2 Bank BIC filters on the platform, writable, bank.bic The Business Identifier Code (BIC). Go to https://en.wikipedia.org/wiki/ISO_9362 for more information.
bank_city varchar2 Bank City filters on the platform, writable, bank.city The city the bank branch office is located in.
bank_iban varchar2 Bank IBAN filters on the platform, writable, bank.iban The International Bank Account Number. Go to https://en.wikipedia.org/wiki/International_Bank_Account_Number for more information.
bank_name varchar2 Bank Name filters on the platform, writable, bank.name The name of the bank.
block_automatic_payments char Block Automatic Payments filters on the platform, writable, block_automatic_payments
blocked_active char Blocked Active filters on the platform, writable, blocked.active Indicates whether the supplier is blocked.
blocked_reason varchar2 Blocked Reason filters on the platform, writable, blocked.reason The reason the supplier is blocked.
chamber_of_commerce varchar2 Chamber Of Commerce filters on the platform, writable, chamber_of_commerce The chamber of commerce (Dutch: 'KvK') number. This field is important when working with Scan & Herken, where based on this number, it is decided on which supplier id the purchase invoice will be booked. In case this field is not provided, this will be marked as 'partially recognized'.
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
default_payment_reference varchar2 Default Payment Reference filters on the platform, writable, default_payment_reference A payment reference can be set in order to give the supplier information what this payment was meant for.
externalid varchar2 External ID filters on the platform, writable, externalid The external identification that has been linked to the supplier via third-party software.
id int64 ID filters on the platform, writable, id The identifying number for a supplier. Must fall within the range of one of the sales journals
is_one_time char Is One-Time filters on the platform, writable, is_one_time Specifies if a supplier is used for one-time sales.
language varchar2 Language filters on the platform, writable, language The language of the supplier. Represented as an ISO-639-1 language code.
memo_active char Memo Active filters on the platform, writable, memo.active Whether the memo is shown in the UI when this account is used.
memo_text varchar2 Memo Text filters on the platform, writable, memo.text The content of the memo.
payment_term_days decimal Payment Term Days filters on the platform, writable, payment_term.days
payment_term_description varchar2 Payment Term Description filters on the platform, writable, payment_term.description
payment_term_id int64 Payment Term ID filters on the platform, writable, payment_term.id
payment_term_mandate varchar2 Payment Term Mandate filters on the platform, writable, payment_term.mandate
payment_term_start varchar2 Payment Term Start filters on the platform, writable, payment_term.start
payment_term_terms_days decimal Payment Term Terms Days filters on the platform, writable, payment_term.terms.days
payment_term_terms_percentage decimal Payment Term Terms Percentage filters on the platform, writable, payment_term.terms.percentage
payment_term_terms_type varchar2 Payment Term Terms Type filters on the platform, writable, payment_term.terms.type
vat_active char VAT Active filters on the platform, writable, vat.active Whether an automatic VAT proposition will be made for the supplier.
vat_suggested_gl_account int64 VAT Suggested GL Account filters on the platform, writable, vat.suggested_gl_account The suggested GL account (Dutch: 'tegenrekening') that will be used when an automatic VAT proposition will be made.
vat_suggested_vat_id int64 VAT Suggested VAT ID filters on the platform, writable, vat.suggested_vat_id The suggested VAT identification that will be used when an automatic VAT proposition will be made.
vat_vat_registration_number varchar2 VAT Registration Number filters on the platform, writable, vat.vat_registration_number The identifying number of a VAT registration. This number is also used for sales tax.

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