invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerAddressEmailAddressesByEmail: Minox Customer Address Email Addresses by Email

read only per partition REST

  • Catalog: Minox
  • Schema: MasterDataCustomer
  • Label: Customer Address Email Addresses by Email

Get a list of customers by e-mail address.

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

Parameters

Name Data Type Required Default Documentation
administration_code `` Partition to retrieve data from.
email ``

Table Columns

The columns of the table CustomerAddressEmailAddressesByEmail 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.
aggregation_aggregation_level int64 Aggregation Level filters on the platform, writable, ::ancestor.::ancestor.aggregation.aggregation_level The level of the aggregation
aggregation_description varchar2 Aggregation Description filters on the platform, writable, ::ancestor.::ancestor.aggregation.description The description of the aggregation.
bank_bic varchar2 Bank BIC filters on the platform, writable, ::ancestor.::ancestor.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, ::ancestor.::ancestor.bank.city The city the bank branch office is located in.
bank_iban varchar2 Bank IBAN filters on the platform, writable, ::ancestor.::ancestor.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, ::ancestor.::ancestor.bank.name The name of the bank.
block_collection char Block Collection filters on the platform, writable, ::ancestor.::ancestor.block_collection Specifies whether debt collection (Dutch: 'incasso') is blocked for the customer.
block_sending_reminders char Block Sending Reminders filters on the platform, writable, ::ancestor.::ancestor.block_sending_reminders Specifies whether reminders are blocked for the customer.
blocked_active char Blocked Active filters on the platform, writable, ::ancestor.::ancestor.blocked.active Indicates whether the customer is blocked.
blocked_reason varchar2 Blocked Reason filters on the platform, writable, ::ancestor.::ancestor.blocked.reason The reason the customer is blocked.
chamber_of_commerce varchar2 Chamber Of Commerce filters on the platform, writable, ::ancestor.::ancestor.chamber_of_commerce The chamber of commerce (Dutch: 'KvK') number.
city varchar2 City writable, ::ancestor.city The city of where it is located.
contact_name varchar2 Contact Name writable, ::ancestor.contact_name The name of the contact person.
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
extended_name varchar2 Extended Name writable, ::ancestor.extended_name The extended name of the company.
externalid varchar2 External ID filters on the platform, writable, ::ancestor.::ancestor.externalid The external identification that has been linked to the customer via third-party software.
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 The identifying number for a customer. Must fall within the range of one of the sales journals
is_one_time char Is One-Time filters on the platform, writable, ::ancestor.::ancestor.is_one_time Specifies if a customer is used for one-time sales.
language varchar2 Language filters on the platform, writable, ::ancestor.::ancestor.language The language of the customer. Represented as an ISO-639-1 language code.
memo_active char Memo Active filters on the platform, writable, ::ancestor.::ancestor.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, ::ancestor.::ancestor.memo.text The content of the memo.
name varchar2 Name writable, ::ancestor.name The company name.
payment_term_days decimal Payment Term Days filters on the platform, writable, ::ancestor.::ancestor.payment_term.days
payment_term_description varchar2 Payment Term Description filters on the platform, writable, ::ancestor.::ancestor.payment_term.description
payment_term_id int64 Payment Term ID filters on the platform, writable, ::ancestor.::ancestor.payment_term.id
payment_term_mandate varchar2 Payment Term Mandate filters on the platform, writable, ::ancestor.::ancestor.payment_term.mandate
payment_term_start varchar2 Payment Term Start filters on the platform, writable, ::ancestor.::ancestor.payment_term.start
postal_code varchar2 Postal Code writable, ::ancestor.postal_code The postal code.
sales_credit_limit decimal Sales Credit Limit filters on the platform, writable, ::ancestor.::ancestor.sales.credit_limit The credit limit.
sales_g_rekening_percentage decimal Sales G-Account Percentage filters on the platform, writable, ::ancestor.::ancestor.sales.g_rekening_percentage A 'G-rekening' is a frozen account that you can use solely to make payroll taxes or VAT payments to the Tax and Customs Administration. The recipient deposits the estimated amount of payroll taxes or VAT payments into your g account. You can use this amount solely to pay payroll taxes or VAT. In case there is a 'G-rekening', by default the percentage from the administration will be used. In case a customer has a custom percentage, this can be defined here.
sales_invoice_discount_percentage decimal Sales Invoice Discount Percentage filters on the platform, writable, ::ancestor.::ancestor.sales.invoice_discount_percentage The discount percentage on an invoice.
sales_pricecode int64 Sales Price Code filters on the platform, writable, ::ancestor.::ancestor.sales.pricecode The type of selling price. If it is different than the normal selling price, a code between 1 and 9 will be returned.
sales_revenue_category int64 Sales Revenue Category filters on the platform, writable, ::ancestor.::ancestor.sales.revenue_category The revenue category. This can be one of the following values: - 1 | NL - 2 | EU - 3 | non-EU - 4 | shifted (free1) - 5 | free2 - 6 | free3 - 7 | free4 - 8 | free5
sales_statistics_code varchar2 Sales Statistics Code filters on the platform, writable, ::ancestor.::ancestor.sales.statistics_code Together with the statistics code of the selling item, it can be decided how the revenue statistics are printed. Possible values: - C | Article code, the revenue will be split per customer per article code - G | Article group, the revenue will be split per customer per article group - N | Not split, the revenue will not be split per customer If the given value is not equal to one of those, the statistics code will be set to 'C'.
sales_track_sales_history char Sales Track Sales History filters on the platform, writable, ::ancestor.::ancestor.sales.track_sales_history Specifies whether or not to track the sales history for the customer.
sales_vat_inclusive char Sales VAT Inclusive filters on the platform, writable, ::ancestor.::ancestor.sales.vat_inclusive Whether the selling price is VAT inclusive.
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.
streetname_and_number varchar2 Street Name And Number writable, ::ancestor.streetname_and_number The name of the street and house number.
vat_active char VAT Active filters on the platform, writable, ::ancestor.::ancestor.vat.active Whether an automatic VAT proposition will be made for the customer.
vat_suggested_gl_account int64 VAT Suggested GL Account filters on the platform, writable, ::ancestor.::ancestor.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, ::ancestor.::ancestor.vat.suggested_vat_id The suggested VAT identification that will be used when an automatic VAT proposition will be made.
vat_vat_in_europe_gl_account int64 VAT In Europe GL Account filters on the platform, writable, ::ancestor.::ancestor.vat.vat_in_europe_gl_account The suggested GL account (Dutch: 'tegenrekening') that will be used when dealing with sales inside Europe.
vat_vat_registration_number varchar2 VAT Registration Number filters on the platform, writable, ::ancestor.::ancestor.vat.vat_registration_number The identifying number of a VAT registration. This number is also used for sales tax.
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