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_ |
varchar2 |
itgen_cbe_active_id | Represents the id of the active version of the customer resource. | ||
allow_ |
char |
Sta Automatische Incasso toe | Whether the customer can pay via Direct Debit. | ||
auto_ |
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_ |
varchar2 |
Automatische Verzameling | |||
backup_ |
varchar2 |
Back-up Betalingsbron ID | |||
billing_ |
varchar2 |
Factuuradres Stad | |||
billing_ |
varchar2 |
Factuuradres Bedrijf | |||
billing_ |
varchar2 |
Factuuradres Land | |||
billing_ |
varchar2 |
Factuuradres E-mail | |||
billing_ |
varchar2 |
Factuuradres Voornaam | |||
billing_ |
varchar2 |
Factuuradres Achternaam | |||
billing_ |
varchar2 |
Factuuradresregel 1 | |||
billing_ |
varchar2 |
Factuuradresregel 2 | |||
billing_ |
varchar2 |
Factuuradresregel 3 | |||
billing_ |
varchar2 |
Factuuradres Telefoon | |||
billing_ |
varchar2 |
Factuuradres Provincie | |||
billing_ |
varchar2 |
itgen_cbe_billing_address_state_code | |||
billing_ |
varchar2 |
Validatiestatus Factuuradres | |||
billing_ |
varchar2 |
itgen_cbe_billing_address_zip | |||
billing_ |
int64 |
Factuurdatum | |||
billing_ |
varchar2 |
Factuurdatummodus | |||
billing_ |
varchar2 |
Facturering Weekdag | |||
billing_ |
varchar2 |
Facturatiedag van de Weekmodus | |||
business_ |
char |
Zakelijke Klant zonder BTW Nummer | |||
business_ |
varchar2 |
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 |
itgen_cbe_channel | The subscription channel this object originated from and is maintained in.Possible values are: web, app_store or play_store. | ||
child_ |
varchar2 |
Toegangsportaal voor Kinderaccounts Facturen Downloaden | |||
child_ |
varchar2 |
Toegangsportaal voor Kinderaccounts Abonnementen Bewerken | |||
child_ |
char |
Toegang tot Kinderaccount Factuur-e-mails Verzenden | |||
child_ |
char |
Toegang tot Kinderaccount Betalings-e-mails Verzenden | |||
child_ |
char |
Toegang tot Kinderaccount Stuur Abonnements-e-mails | |||
client_ |
varchar2 |
Klantprofiel ID | |||
company |
varchar2 |
Company | Company name of the customer. | ||
consolidated_ |
char |
Geconsolideerde Facturatie | |||
created_ |
datetime |
Aangemaakt op | |||
created_ |
varchar2 |
Gemaakt van IP | |||
customer_ |
varchar2 |
Klanttype | |||
deleted |
char |
Deleted | |||
einvoicing_ |
varchar2 |
itgen_cbe_einvoicing_method | Determines whether to send e-invoice manually or automatic.Possible values are: automatic, manual or site_default. | ||
email |
varchar2 |
Email of the customer.Configured email notifications will be sent to this email. | |||
entity_ |
varchar2 |
Entiteitscode | |||
entity_ |
varchar2 |
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_ |
varchar2 |
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_ |
decimal |
Overtollige Betalingen | |||
exempt_ |
varchar2 |
Vrijgesteld Nummer | |||
first_ |
varchar2 |
Voornaam | First name of the customer. | ||
fraud_ |
varchar2 |
Fraudevlag | |||
id |
varchar2 |
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_ |
varchar2 |
Factuurnotities | |||
is_ |
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_ |
char |
Is Locatie Geldig | |||
last_ |
varchar2 |
Achternaam | Last name of the customer. | ||
locale |
varchar2 |
Locale | |||
meta_ |
varchar2 |
Metagegevens | |||
net_ |
int32 |
Netto Termijn Dagen | The number of days within which the customer has to make payment for the invoice. | ||
offline_ |
varchar2 |
Offline Betaalmethode | |||
parent_ |
varchar2 |
Toegangsportaal Ouderaccounts Download Facturen voor Kinderen | |||
parent_ |
varchar2 |
Toegangsportaal Ouderaccount Bewerk Abonnementen voor Kinderen | |||
parent_ |
char |
Toegang tot Ouderaccount Factuur-e-mails Verzenden | |||
parent_ |
char |
Toegang tot Ouderaccount Betalings-e-mails Verzenden | |||
parent_ |
char |
Toegang tot Ouderaccount Abonnement-e-mails Verzenden | |||
payment_ |
varchar2 |
Betalingsmethode Gateway | |||
payment_ |
varchar2 |
Betalingsmethode Gatewayaccount ID | |||
payment_ |
varchar2 |
Betalingsmethode Referentie ID | |||
payment_ |
varchar2 |
Status Betalingsmethode | |||
payment_ |
varchar2 |
Betalingsmethodesoort | |||
phone |
varchar2 |
Phone | Phone number of the customer. | ||
pii_ |
varchar2 |
PII Gewist | |||
preferred_ |
varchar2 |
Gewenste Valutacode | |||
primary_ |
varchar2 |
Primaire Betalingsbron ID | |||
promotional_ |
decimal |
Promotiekredieten | |||
refundable_ |
decimal |
Terugbetaalbare Kredieten | |||
registered_ |
char |
Geregistreerd voor GST | |||
relationship_ |
varchar2 |
Relatie Factuur Eigenaar ID | |||
relationship_ |
varchar2 |
Relatie Ouder ID | |||
relationship_ |
varchar2 |
Relatie Betaling Eigenaar ID | |||
resource_ |
int64 |
Bronversie | |||
taxability |
varchar2 |
Taxability | |||
unbilled_ |
decimal |
Niet-gefactureerde Kosten | |||
updated_ |
datetime |
Bijgewerkt op | |||
use_ |
char |
Standaard Hiërarchie-instellingen Gebruiken | |||
vat_ |
varchar2 |
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_ |
varchar2 |
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_ |
varchar2 |
BTW-nummer Status | |||
vat_ |
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: