Customer2ById: Minox Klant op ID

administration_code

string

☐

Partition to retrieve data from.

customer_id

int64

☑

The customer to access.

administration_code

string(30)

Administratiecode

☑

Partition code, segmenting the data.

administration_name

string(240)

Administratie Naam

☑

Name of the partition.

aggregation_aggregation_level

int64

Aggregatieniveau

☐

The level of the aggregation

aggregation_description

string

Aggregatiebeschrijving

☐

The description of the aggregation.

bank_bic

string

Bank BIC

☐

The Business Identifier Code (BIC). Go to https://en.wikipedia.org/wiki/ISO_9362for more information.

bank_city

string

Bankstad

☐

The city the bank branch office is located in.

bank_iban

string

Bank IBAN

☐

The International Bank Account Number. Go to https://en.wikipedia.org/wiki/International_Bank_Account_Numberfor more information.

bank_name

string

Naam van de Bank

☐

De naam van de bank.

block_collection

boolean

Verzameling Blokkeren

☐

Specifies whether debt collection (Dutch: 'incasso') isblocked for the customer.

block_sending_reminders

boolean

Blokkeer Herinnering Sturen

☐

Specifies whether reminders are blocked for the customer.

blocked_active

boolean

Actieve Geblokkeerd

☐

Indicates whether the customer is blocked.

blocked_reason

string

Blokkeerreden

☐

The reason the customer is blocked.

chamber_of_commerce

string

Kamer van Koophandel

☐

The chamber of commerce (Dutch: 'KvK') number.

currency_description

string

Valuta Omschrijving

☐

currency_exchange_rate

decimal

Wisselkoers

☐

currency_id

string

Valuta ID

☐

externalid

string

Externe ID

☐

The external identification that has been linked to the customervia third-party software.

id

int64

ID

☐

The identifying number for a customer. Must fall within therange of one of the sales journals

is_one_time

boolean

Is Eenmalig

☐

Specifies if a customer is used for one-time sales.

language

string

Taal

☐

The language of the customer. Represented as an ISO-639-1 languagecode.

memo_active

boolean

Memo Actief

☐

Whether the memo is shown in the UI when this account is used.

memo_text

string

Memotekst

☐

The content of the memo.

payment_term_days

decimal

Betalingstermijn Dagen

☐

payment_term_description

string

Betalingstermijn Omschrijving

☐

payment_term_id

int64

Betalingstermijn-ID

☐

payment_term_mandate

string

Machtiging Betalingstermijn

☐

payment_term_start

string

Betalingstermijn Start

☐

payment_term_terms_days

decimal

Betalingsvoorwaarden in Dagen

☐

payment_term_terms_percentage

decimal

Percentage Betalingsvoorwaarden

☐

payment_term_terms_type

string

Soort Betalingsvoorwaarden

☐

sales_billoflading_type_attachment

boolean

Verkoop Vrachtbriefsoort Bijlage

☐

Send as an attachment once a bill of lading has beengenerated for the customer.

sales_billoflading_type_email_with_pdf

boolean

Verkoop Vrachtbriefsoort E-mail met PDF

☐

Send an e-mail with the PDF once a bill of lading hasbeen sent to the customer.

sales_billoflading_type_email

string

Verkoop Vrachtbriefsoort E-mail

☐

The e-mail address to which the e-mail will be sentonce a bill of lading has been sent to the customer.

sales_billoflading_type_pdf_download

boolean

Verkoop Vrachtbriefsoort PDF-Download

☐

Download the PDF once a bill of lading has been sentto the customer.

sales_carrier_description

string

Verkoop Transporteur Omschrijving

☐

[NOT IN USE] The description of the carrier.

sales_carrier_id

int64

Verkoop Transporteur ID

☐

The identifying number of the carrier.

sales_credit_limit

decimal

Verkoop Kredietlimiet

☐

The credit limit.

sales_customer_type_description

string

Verkoop Klantsoortomschrijving

☐

[NOT IN USE] The description of the customer type

sales_customer_type_id

int64

Verkoop Klantsoort ID

☐

The identifying number of the customer type.

sales_delivery_address_description

string

Verkoop Afleveradresomschrijving

☐

[NOT IN USE] The description of the delivery address.

sales_delivery_address_id

int64

Verkoop Afleveradres ID

☐

The identifying number of the delivery address

sales_delivery_terms_description

string

Verkoop Leveringsvoorwaardenomschrijving

☐

[NOT IN USE] The description of the delivery term.

sales_delivery_terms_id

int64

Verkoop Leveringsvoorwaarden ID

☐

The identifying number of the delivery term.

sales_discount_group_description

string

Verkoop Kortingsgroepomschrijving

☐

[NOT IN USE] The description of the discount group.

sales_discount_group_id

int64

Verkoop Kortingsgroep ID

☐

The identifying number of the discount group.

sales_g_rekening_percentage

decimal

Verkoop G-rekening Percentage

☐

A 'G-rekening' is a frozen account that you can use solelyto make payroll taxes or VAT payments to the Tax and Customs Administration.The recipient deposits the estimated amount of payroll taxes or VATpayments into your g account. You can use this amount solely to paypayroll taxes or VAT. In case there is a 'G-rekening', by defaultthe percentage from the administration will be used. In case a customerhas a custom percentage, this can be defined here.

sales_invoice_discount_percentage

decimal

Verkoopfactuur Kortingspercentage

☐

The discount percentage on an invoice.

sales_invoice_type_attachment

boolean

Verkoopfactuursoort Bijlage

☐

Send as an attachment once a sales invoice has beengenerated for the customer.

sales_invoice_type_email_with_pdf

boolean

Verkoopfactuursoort E-mail met PDF

☐

Send an e-mail with the PDF once a sales invoice hasbeen generated for the customer.

sales_invoice_type_email_with_ubl

boolean

Verkoopfactuursoort E-mail met UBL

☐

Send an e-mail with the UBL once a sales invoice hasbeen generated for the customer.

sales_invoice_type_email

string

Verkoopfactuursoort E-mail

☐

The e-mail address to which the e-mail will be sentonce a sales invoice has been generated for the customer.

sales_invoice_type_pdf_download

boolean

Verkoopfactuursoort PDF-Download

☐

Download the PDF once a sales invoice has been generatedfor the customer.

sales_order_type_attachment

boolean

Verkoopordersoort Bijlage

☐

Send as an attachment once an order has been generatedfor the customer.

sales_order_type_email_with_pdf

boolean

Verkoopordersoort E-mail met PDF

☐

Send an e-mail with the PDF once an order has beensent to the customer.

sales_order_type_email

string

Verkoopordersoort E-mail

☐

The e-mail address to which the e-mail will be sentonce an order has been sent to the customer.

sales_order_type_pdf_download

boolean

Verkoopordersoort PDF-download

☐

Download the PDF once an order has been sent to thecustomer.

sales_packinglist_type_attachment

boolean

Verkoop Paklijstsoort Bijlage

☐

Send as an attachment once a packing list has beengenerated for the customer.

sales_packinglist_type_email_with_pdf

boolean

Verkoop Paklijstsoort E-mail met PDF

☐

Send an e-mail with the PDF once a packing list hasbeen sent to the customer.

sales_packinglist_type_email

string

Verkoop Paklijstsoort E-mail

☐

The e-mail address to which the e-mail will be sentonce a packing list has been sent to the customer.

sales_packinglist_type_pdf_download

boolean

Verkoop Paklijstsoort PDF-Download

☐

Download the PDF once a packing list has been sentto the customer.

sales_pricecode

int64

Verkoopprijscode

☐

The type of selling price. If it is different than thenormal selling price, a code between 1 and 9 will be returned.

sales_quotation_type_attachment

boolean

Verkoop Offertesoort Bijlage

☐

Send as an attachment once a quotation has been generatedfor the customer.

sales_quotation_type_email_with_pdf

boolean

Verkoop Offertesoort E-mail met PDF

☐

Send an e-mail with the PDF once a quotation has beensent to the customer.

sales_quotation_type_email

string

Verkoop Offertesoort E-mail

☐

The e-mail address to which the e-mail will be sentonce a quotation has been sent to the customer.

sales_quotation_type_pdf_download

boolean

Verkoop Offertesoort PDF-Download

☐

Download the PDF once a quotation has been sent tothe customer.

sales_region_description

string

Verkoopregio Omschrijving

☐

The string representation of the region.

sales_region_id

int64

Verkoopregio ID

☐

The identifying number of the region.

sales_reminder_type_email_with_pdf

boolean

Verkoop Herinneringsoort E-mail met PDF

☐

Send an e-mail with the PDF once a reminder has beensent to the customer.

sales_reminder_type_email

string

Verkoop Herinneringsoort E-mail

☐

The e-mail address to which the e-mail will be sentonce a reminder has been sent to the customer.

sales_reminder_type_pdf_download

boolean

Verkoop Herinneringsoort PDF-Download

☐

Download the PDF once a reminder has been sent to thecustomer.

sales_representative_description

string

Verkoop Vertegenwoordiger Omschrijving

☐

[NOT IN USE] The description of the representative.

sales_representative_id

int64

Verkoop Vertegenwoordiger ID

☐

The identifying number of the representative.

sales_revenue_category

int64

Verkoopopbrengsten Categorie

☐

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

string

Verkoopstatistiekencode

☐

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 customerIf the given value is not equal to one of those, the statistics code will be set to 'C'.

sales_subscription_type_attachment

boolean

Verkoop Abonnementssoort Bijlage

☐

Send as an attachment once a subscription has beengenerated for the customer.

sales_subscription_type_email_with_pdf

boolean

Verkoop Abonnementssoort E-mail met PDF

☐

Send an e-mail with the PDF once a subscription hasbeen sent to the customer.

sales_subscription_type_email

string

Verkoop Abonnementssoort E-mail

☐

The e-mail address to which the e-mail will be sentonce a subscription has been sent to the customer.

sales_subscription_type_pdf_download

boolean

Verkoop Abonnementssoort PDF-Download

☐

Download the PDF once a subscription has been sentto the customer.

sales_track_sales_history

boolean

Verkoop Volg Verkoophistorie

☐

Specifies whether or not to track the sales history forthe customer.

sales_vat_inclusive

boolean

Verkoop inclusief BTW

☐

Whether the selling price is VAT inclusive.

vat_active

boolean

BTW Actief

☐

Whether an automatic VAT proposition will be made for thecustomer.

vat_suggested_gl_account

int64

Voorgestelde BTW Grootboekrekening

☐

The suggested GL account (Dutch: 'tegenrekening') thatwill be used when an automatic VAT proposition will be made.

vat_suggested_vat_id

int64

Voorgestelde BTW ID

☐

The suggested VAT identification that will be used whenan automatic VAT proposition will be made.

vat_vat_in_europe_gl_account

int64

BTW in Europa Grootboekrekening

☐

The suggested GL account (Dutch: 'tegenrekening') thatwill be used when dealing with sales inside Europe.

vat_vat_registration_number

string

BTW-registratienummer

☐

The identifying number of a VAT registration. This numberis also used for sales tax.