invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Customers: Chargebee Customers

insert update delete REST

  • Catalogus: Chargebee
  • Schema: Customers
  • Primaire sleutels: id
  • Label: Customers

Je kunt gegevens ophalen en wijzigen met insert, update en delete.

API-bron

  • Eindpunt: /customers

Tabelkolommen

De kolommen van de tabel Customers worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
active_id varchar2(50) itgen_cbe_active_id Represents the id of the active version of the customer resource.
allow_direct_debit char Sta Automatische Incasso toe Whether the customer can pay via Direct Debit.
auto_close_invoices char itgen_cbe_auto_close_invoices Override for this customer, the site-level setting for auto-closing invoices.Only applicable when auto-closing invoices has been enabled for the site.This attribute is also available at the subscription level which takes precedence.
auto_collection varchar2(30) Automatische Verzameling
backup_payment_source_id varchar2 Back-up Betalingsbron ID
billing_address_city varchar2(50) Factuuradres Stad
billing_address_company varchar2(250) Factuuradres Bedrijf
billing_address_country varchar2(50) Factuuradres Land
billing_address_email varchar2(70) Factuuradres E-mail
billing_address_first_name varchar2(150) Factuuradres Voornaam
billing_address_last_name varchar2(150) Factuuradres Achternaam
billing_address_line1 varchar2(150) Factuuradresregel 1
billing_address_line2 varchar2(150) Factuuradresregel 2
billing_address_line3 varchar2(150) Factuuradresregel 3
billing_address_phone varchar2(50) Factuuradres Telefoon
billing_address_state varchar2(50) Factuuradres Provincie
billing_address_state_code varchar2(50) itgen_cbe_billing_address_state_code
billing_address_validation_status varchar2(30) Validatiestatus Factuuradres
billing_address_zip varchar2(20) itgen_cbe_billing_address_zip
billing_date int64 Factuurdatum
billing_date_mode varchar2 Factuurdatummodus
billing_day_of_week varchar2 Facturering Weekdag
billing_day_of_week_mode varchar2 Facturatiedag van de Weekmodus
business_customer_without_vat_number char Zakelijke Klant zonder BTW Nummer
business_entity_id varchar2(50) itgen_cbe_business_entity_id The unique ID of the business entity of this subscription.This is always the same as the business entity of the customer.
channel varchar2(30) itgen_cbe_channel The subscription channel this object originated from and is maintained in.Possible values are: web, app_store or play_store.
child_account_access_portal_download_invoices varchar2 Toegangsportaal voor Kinderaccounts Facturen Downloaden
child_account_access_portal_edit_subscriptions varchar2 Toegangsportaal voor Kinderaccounts Abonnementen Bewerken
child_account_access_send_invoice_emails char Toegang tot Kinderaccount Factuur-e-mails Verzenden
child_account_access_send_payment_emails char Toegang tot Kinderaccount Betalings-e-mails Verzenden
child_account_access_send_subscription_emails char Toegang tot Kinderaccount Stuur Abonnements-e-mails
client_profile_id varchar2 Klantprofiel ID
company varchar2(250) Company Company name of the customer.
consolidated_invoicing char Geconsolideerde Facturatie
created_at datetime Aangemaakt op
created_from_ip varchar2 Gemaakt van IP
customer_type varchar2 Klanttype
deleted char Deleted
einvoicing_method varchar2(30) itgen_cbe_einvoicing_method Determines whether to send e-invoice manually or automatic.Possible values are: automatic, manual or site_default.
email varchar2(70) Email Email of the customer.Configured email notifications will be sent to this email.
entity_code varchar2(30) Entiteitscode
entity_identifier_scheme varchar2(50) itgen_cbe_entity_identifier_scheme The Peppol BIS scheme associated with the vat_number of the customer.This helps identify the specific type of customer entity.
entity_identifier_standard varchar2(50) itgen_cbe_entity_identifier_standard The standard used for specifying the entity_identifier_scheme.Currently only iso6523-actorid-upis is supported and is used by default when not provided.
excess_payments decimal Overtollige Betalingen
exempt_number varchar2(100) Vrijgesteld Nummer
first_name varchar2(150) Voornaam First name of the customer.
fraud_flag varchar2 Fraudevlag
id varchar2(50) ID The unique identifier of the customer resource.You have the option to specify this value when creating a customer.If not specified, Chargebee automatically generates a unique identifier.
invoice_notes varchar2(2000) Factuurnotities
is_einvoice_enabled char itgen_cbe_is_einvoice_enabled Determines whether the customer is e-invoiced.When set to true or not set to any value, the customer is e-invoiced so long as e-invoicing is enabled for their country (billing_address.country).When set to false, the customer is not e-invoiced even if e-invoicing is enabled for their country.
is_location_valid char Is Locatie Geldig
last_name varchar2(150) Achternaam Last name of the customer.
locale varchar2(50) Locale
meta_data varchar2 Metagegevens
net_term_days int32 Netto Termijn Dagen The number of days within which the customer has to make payment for the invoice.
offline_payment_method varchar2(30) Offline Betaalmethode
parent_account_access_portal_download_child_invoices varchar2 Toegangsportaal Ouderaccounts Download Facturen voor Kinderen
parent_account_access_portal_edit_child_subscriptions varchar2 Toegangsportaal Ouderaccount Bewerk Abonnementen voor Kinderen
parent_account_access_send_invoice_emails char Toegang tot Ouderaccount Factuur-e-mails Verzenden
parent_account_access_send_payment_emails char Toegang tot Ouderaccount Betalings-e-mails Verzenden
parent_account_access_send_subscription_emails char Toegang tot Ouderaccount Abonnement-e-mails Verzenden
payment_method_gateway varchar2 Betalingsmethode Gateway
payment_method_gateway_account_id varchar2 Betalingsmethode Gatewayaccount ID
payment_method_reference_id varchar2 Betalingsmethode Referentie ID
payment_method_status varchar2 Status Betalingsmethode
payment_method_type varchar2 Betalingsmethodesoort
phone varchar2(50) Phone Phone number of the customer.
pii_cleared varchar2 PII Gewist
preferred_currency_code varchar2 Gewenste Valutacode
primary_payment_source_id varchar2 Primaire Betalingsbron ID
promotional_credits decimal Promotiekredieten
refundable_credits decimal Terugbetaalbare Kredieten
registered_for_gst char Geregistreerd voor GST
relationship_invoice_owner_id varchar2 Relatie Factuur Eigenaar ID
relationship_parent_id varchar2 Relatie Ouder ID
relationship_payment_owner_id varchar2 Relatie Betaling Eigenaar ID
resource_version int64 Bronversie
taxability varchar2(30) Taxability
unbilled_charges decimal Niet-gefactureerde Kosten
updated_at datetime Bijgewerkt op
use_default_hierarchy_settings char Standaard Hiërarchie-instellingen Gebruiken
vat_number varchar2(20) BTW-nummer The VAT/tax registration number for the customer.For customers with billing_address country as XI (which is United Kingdom - Northern Ireland), the first two characters of the full VAT number can be overridden by setting vat_number_prefix.
vat_number_prefix varchar2(10) itgen_cbe_vat_number_prefix An overridden value for the first two characters of the full VAT number.Only applicable specifically for customers with billing_address country as XI (which is United Kingdom - Northern Ireland).
vat_number_status varchar2(30) BTW-nummer Status
vat_number_validated_time datetime BTW-nummer Gevalideerd Tijd Returns the recent VAT number validation time.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: