invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerAddressEmailAddressesById: Minox Customer Address Email Addresses by ID

read only per partition REST

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

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

Parameters

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

Table Columns

The columns of the table CustomerAddressEmailAddressesById 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
email_address varchar2 Email Address writable, email_address The e-mail address.
email_address_type varchar2 Email Address Type writable, email_address_type Deprecated.
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
payment_term_terms_days decimal Payment Term Terms Days filters on the platform, writable, ::ancestor.::ancestor.payment_term.terms.days
payment_term_terms_percentage decimal Payment Term Terms Percentage filters on the platform, writable, ::ancestor.::ancestor.payment_term.terms.percentage
payment_term_terms_type varchar2 Payment Term Terms Type filters on the platform, writable, ::ancestor.::ancestor.payment_term.terms.type
postal_code varchar2 Postal Code writable, ::ancestor.postal_code The postal code.
sales_billoflading_type_attachment char Sales Bill-of-lading Type Attachment filters on the platform, writable, ::ancestor.::ancestor.sales.billoflading_type.attachment Send as an attachment once a bill of lading has been generated for the customer.
sales_billoflading_type_email varchar2 Sales Bill-of-lading Type Email filters on the platform, writable, ::ancestor.::ancestor.sales.billoflading_type.email The e-mail address to which the e-mail will be sent once a bill of lading has been sent to the customer.
sales_billoflading_type_email_with_pdf char Sales Bill-of-lading Type Email with PDF filters on the platform, writable, ::ancestor.::ancestor.sales.billoflading_type.email_with_pdf Send an e-mail with the PDF once a bill of lading has been sent to the customer.
sales_billoflading_type_pdf_download char Sales Bill-of-lading Type PDF Download filters on the platform, writable, ::ancestor.::ancestor.sales.billoflading_type.pdf_download Download the PDF once a bill of lading has been sent to the customer.
sales_carrier_description varchar2 Sales Carrier Description filters on the platform, writable, ::ancestor.::ancestor.sales.carrier.description [NOT IN USE] The description of the carrier.
sales_carrier_id int64 Sales Carrier ID filters on the platform, writable, ::ancestor.::ancestor.sales.carrier.id The identifying number of the carrier.
sales_credit_limit decimal Sales Credit Limit filters on the platform, writable, ::ancestor.::ancestor.sales.credit_limit The credit limit.
sales_customer_type_description varchar2 Sales Customer Type Description filters on the platform, writable, ::ancestor.::ancestor.sales.customer_type.description [NOT IN USE] The description of the customer type
sales_customer_type_id int64 Sales Customer Type ID filters on the platform, writable, ::ancestor.::ancestor.sales.customer_type.id The identifying number of the customer type.
sales_delivery_address_description varchar2 Sales Delivery Address Description filters on the platform, writable, ::ancestor.::ancestor.sales.delivery_address.description [NOT IN USE] The description of the delivery address.
sales_delivery_address_id int64 Sales Delivery Address ID filters on the platform, writable, ::ancestor.::ancestor.sales.delivery_address.id The identifying number of the delivery address
sales_delivery_terms_description varchar2 Sales Delivery Terms Description filters on the platform, writable, ::ancestor.::ancestor.sales.delivery_terms.description [NOT IN USE] The description of the delivery term.
sales_delivery_terms_id int64 Sales Delivery Terms ID filters on the platform, writable, ::ancestor.::ancestor.sales.delivery_terms.id The identifying number of the delivery term.
sales_discount_group_description varchar2 Sales Discount Group Description filters on the platform, writable, ::ancestor.::ancestor.sales.discount_group.description [NOT IN USE] The description of the discount group.
sales_discount_group_id int64 Sales Discount Group ID filters on the platform, writable, ::ancestor.::ancestor.sales.discount_group.id The identifying number of the discount group.
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_invoice_type_attachment char Sales Invoice Type Attachment filters on the platform, writable, ::ancestor.::ancestor.sales.invoice_type.attachment Send as an attachment once a sales invoice has been generated for the customer.
sales_invoice_type_email varchar2 Sales Invoice Type Email filters on the platform, writable, ::ancestor.::ancestor.sales.invoice_type.email The e-mail address to which the e-mail will be sent once a sales invoice has been generated for the customer.
sales_invoice_type_email_with_pdf char Sales Invoice Type Email with PDF filters on the platform, writable, ::ancestor.::ancestor.sales.invoice_type.email_with_pdf Send an e-mail with the PDF once a sales invoice has been generated for the customer.
sales_invoice_type_email_with_ubl char Sales Invoice Type Email with UBL filters on the platform, writable, ::ancestor.::ancestor.sales.invoice_type.email_with_ubl Send an e-mail with the UBL once a sales invoice has been generated for the customer.
sales_invoice_type_pdf_download char Sales Invoice Type PDF Download filters on the platform, writable, ::ancestor.::ancestor.sales.invoice_type.pdf_download Download the PDF once a sales invoice has been generated for the customer.
sales_order_type_attachment char Sales Order Type Attachment filters on the platform, writable, ::ancestor.::ancestor.sales.order_type.attachment Send as an attachment once an order has been generated for the customer.
sales_order_type_email varchar2 Sales Order Type Email filters on the platform, writable, ::ancestor.::ancestor.sales.order_type.email The e-mail address to which the e-mail will be sent once an order has been sent to the customer.
sales_order_type_email_with_pdf char Sales Order Type Email with PDF filters on the platform, writable, ::ancestor.::ancestor.sales.order_type.email_with_pdf Send an e-mail with the PDF once an order has been sent to the customer.
sales_order_type_pdf_download char Sales Order Type PDF Download filters on the platform, writable, ::ancestor.::ancestor.sales.order_type.pdf_download Download the PDF once an order has been sent to the customer.
sales_packinglist_type_attachment char Sales Packinglist Type Attachment filters on the platform, writable, ::ancestor.::ancestor.sales.packinglist_type.attachment Send as an attachment once a packing list has been generated for the customer.
sales_packinglist_type_email varchar2 Sales Packinglist Type Email filters on the platform, writable, ::ancestor.::ancestor.sales.packinglist_type.email The e-mail address to which the e-mail will be sent once a packing list has been sent to the customer.
sales_packinglist_type_email_with_pdf char Sales Packinglist Type Email with PDF filters on the platform, writable, ::ancestor.::ancestor.sales.packinglist_type.email_with_pdf Send an e-mail with the PDF once a packing list has been sent to the customer.
sales_packinglist_type_pdf_download char Sales Packinglist Type PDF Download filters on the platform, writable, ::ancestor.::ancestor.sales.packinglist_type.pdf_download Download the PDF once a packing list has been sent to the customer.
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_quotation_type_attachment char Sales Quotation Type Attachment filters on the platform, writable, ::ancestor.::ancestor.sales.quotation_type.attachment Send as an attachment once a quotation has been generated for the customer.
sales_quotation_type_email varchar2 Sales Quotation Type Email filters on the platform, writable, ::ancestor.::ancestor.sales.quotation_type.email The e-mail address to which the e-mail will be sent once a quotation has been sent to the customer.
sales_quotation_type_email_with_pdf char Sales Quotation Type Email with PDF filters on the platform, writable, ::ancestor.::ancestor.sales.quotation_type.email_with_pdf Send an e-mail with the PDF once a quotation has been sent to the customer.
sales_quotation_type_pdf_download char Sales Quotation Type PDF Download filters on the platform, writable, ::ancestor.::ancestor.sales.quotation_type.pdf_download Download the PDF once a quotation has been sent to the customer.
sales_region_description varchar2 Sales Region Description filters on the platform, writable, ::ancestor.::ancestor.sales.region.description The string representation of the region.
sales_region_id int64 Sales Region ID filters on the platform, writable, ::ancestor.::ancestor.sales.region.id The identifying number of the region.
sales_reminder_type_email varchar2 Sales Reminder Type Email filters on the platform, writable, ::ancestor.::ancestor.sales.reminder_type.email The e-mail address to which the e-mail will be sent once a reminder has been sent to the customer.
sales_reminder_type_email_with_pdf char Sales Reminder Type Email With PDF filters on the platform, writable, ::ancestor.::ancestor.sales.reminder_type.email_with_pdf Send an e-mail with the PDF once a reminder has been sent to the customer.
sales_reminder_type_pdf_download char Sales Reminder Type PDF Download filters on the platform, writable, ::ancestor.::ancestor.sales.reminder_type.pdf_download Download the PDF once a reminder has been sent to the customer.
sales_representative_description varchar2 Sales Representative Description filters on the platform, writable, ::ancestor.::ancestor.sales.representative.description [NOT IN USE] The description of the representative.
sales_representative_id int64 Sales Representative ID filters on the platform, writable, ::ancestor.::ancestor.sales.representative.id The identifying number of the representative.
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_subscription_type_attachment char Sales Subscription Type Attachment filters on the platform, writable, ::ancestor.::ancestor.sales.subscription_type.attachment Send as an attachment once a subscription has been generated for the customer.
sales_subscription_type_email varchar2 Sales Subscription Type Email filters on the platform, writable, ::ancestor.::ancestor.sales.subscription_type.email The e-mail address to which the e-mail will be sent once a subscription has been sent to the customer.
sales_subscription_type_email_with_pdf char Sales Subscription Type Email with PDF filters on the platform, writable, ::ancestor.::ancestor.sales.subscription_type.email_with_pdf Send an e-mail with the PDF once a subscription has been sent to the customer.
sales_subscription_type_pdf_download char Sales Subscription Type PDF Download filters on the platform, writable, ::ancestor.::ancestor.sales.subscription_type.pdf_download Download the PDF once a subscription has been sent to the customer.
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