OrganizationCustomFields: Simplicate benutzerdefinierte Organisationsfelder
read only REST
- Katalog:
Simplicate - Schema:
CRM - Bezeichnung: Benutzerdefinierte Organisationsfelder
Ruft alle Organisationen ab
Es können nur Daten abgerufen werden.
API-Quelle
- Endpunkt:
/crm/organization - Operation:
get /crm/organization
Tabellenspalten
Die Spalten der Tabelle OrganizationCustomFields sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
accountancy_ |
char |
Rechnungswesen – Ist die Steuerabteilung für die Mehrwertsteuer zuständig? | |||
accountancy_ |
char |
Rechnungswesen – Steuerabteilung VPB | |||
accountancy_ |
varchar2 |
Buchhaltung – Welche Rolle spielt die Steuerabteilung bei der Mehrwertsteuer? | |||
accountancy_ |
varchar2 |
Rechnungswesen – Welche Rolle spielt der VPB im Steuerbereich? | |||
accountancy_ |
varchar2 |
Rechnungswesen – Umsatzsteuer-Identifikationsnummer – Steuerliche Einheit | |||
allow_ |
char |
Automatische Abbuchung | |||
bank_ |
varchar2 |
Bankkonto | |||
bank_ |
varchar2 |
Bank BIC | |||
coc_ |
varchar2 |
CoC-Kodex | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Erstellt bei | |||
custom_ |
varchar2 |
ID der benutzerdefinierten Feldgruppe | |||
custom_ |
varchar2 |
ID des Modells für benutzerdefinierte Feldgruppen | |||
custom_ |
varchar2 |
Bezeichnung des Modells für benutzerdefinierte Feldgruppen | |||
custom_ |
varchar2 |
Name der benutzerdefinierten Feldgruppe | |||
custom_ |
varchar2 |
Position der benutzerdefinierten Feldgruppe | |||
custom_ |
varchar2 |
Typ der benutzerdefinierten Feldgruppe | |||
customer_ |
varchar2 |
itgen_spe_customer_group_id | |||
customer_ |
varchar2 |
itgen_spe_customer_group_name | |||
debtor_ |
varchar2 |
Hinweis für den Schuldner: | |||
debtor_ |
varchar2 |
Hinweis für den Schuldner (fest) | |||
debtor_ |
varchar2 |
Hinweis für den Schuldner zur Personen-ID | Siehe /crm/person | ||
debtor_ |
char |
Automatisches Inkasso bei Schuldnern | |||
debtor_ |
char |
itgen_spe_debtor_autosend_subscription_invoice | |||
debtor_ |
varchar2 |
ID der Schablone für Debitoren | |||
debtor_ |
int64 |
Zahlungsfrist des Schuldners (Tage) | |||
debtor_ |
varchar2 |
ID der Zahlungsfrist des Schuldners | |||
debtor_ |
varchar2 |
Methode zur Ermittlung der Zahlungsfrist des Schuldners | |||
debtor_ |
varchar2 |
Name der Zahlungsfrist des Schuldners | |||
debtor_ |
varchar2 |
itgen_spe_debtor_provision_contactperson_id | Siehe /crm/person | ||
debtor_ |
varchar2 |
Bewertungsmethode | |||
debtor_ |
char |
Reminders | |||
debtor_ |
varchar2 |
Sende Email | |||
debtor_ |
varchar2 |
E-Mail-Typ senden | |||
debtor_ |
char |
itgen_spe_debtor_send_invoice_email_to_cc | |||
debtor_ |
char |
itgen_spe_debtor_send_invoice_email_to_contact | |||
debtor_ |
char |
itgen_spe_debtor_send_invoice_email_to_fixed_email | |||
debtor_ |
char |
itgen_spe_debtor_send_invoice_email_to_project_contact | |||
email |
varchar2 |
||||
filterable |
char |
Filterable | |||
has_ |
char |
Andere Postanschrift | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
industry_ |
varchar2 |
Branchen-ID | |||
industry_ |
varchar2 |
Branchenbezeichnung | |||
invoice_ |
varchar2 |
Rechnungsempfänger | |||
is_ |
char |
itgen_spe_is_active | |||
label |
varchar2 |
Label | |||
linkedin_ |
varchar2 |
LinkedIn-URL | |||
mandatory |
char |
itgen_spe_mandatory | |||
modified |
varchar2 |
Modified | |||
name |
varchar2 |
Name | |||
name_2 |
varchar2 |
itgen_spe_name_2 | |||
note |
varchar2 |
Note | |||
organizationsize_ |
varchar2 |
ID der Unternehmensgröße | |||
organizationsize_ |
varchar2 |
Größe der Organisation Name | |||
phone |
varchar2 |
Phone | |||
position |
int64 |
Position | |||
postal_ |
varchar2 |
Postanschrift Land | |||
postal_ |
varchar2 |
Postanschrift Ländercode | |||
postal_ |
varchar2 |
Postanschrift Ländercode | |||
postal_ |
varchar2 |
Postanschrift-ID | |||
postal_ |
varchar2 |
Postanschrift, Zeile 1 | |||
postal_ |
varchar2 |
Postanschrift, Zeile 2 | |||
postal_ |
varchar2 |
Postanschrift Ort | |||
postal_ |
varchar2 |
Postanschrift Postleitzahl | |||
postal_ |
varchar2 |
Postanschrift Bundesland | |||
postal_ |
varchar2 |
Art der Postanschrift | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_avatar_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_avatar_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_avatar_url_large | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_avatar_url_small | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_civil_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_created | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_employment_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_function | |||
relation_ |
double |
itgen_spe_relation_manager_hourly_cost_tariff | |||
relation_ |
double |
itgen_spe_relation_manager_hourly_sales_tariff | |||
relation_ |
varchar2 |
Kundenbetreuer-ID | |||
relation_ |
char |
itgen_spe_relation_manager_is_user | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_marital_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_modified | |||
relation_ |
varchar2 |
Name des Kundenbetreuers | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_country | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_country_code | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_country_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_line_1 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_line_2 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_locality | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_postal_code | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_province | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_address_type | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_avatar_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_avatar_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_avatar_url_large | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_avatar_url_small | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_bank_bic | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_custom_salutation | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_date_of_birth | |||
relation_ |
varchar2 |
E-Mail-Adresse des Kundenbetreuers | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_facebook_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_family_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_family_name_prefix | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_first_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_full_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_gender | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_gender_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_id_2 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_invoice_receiver | |||
relation_ |
char |
itgen_spe_relation_manager_person_is_active | |||
relation_ |
int64 |
itgen_spe_relation_manager_person_is_employee | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_linkedin_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_mailing_list_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_note | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_phone | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_avatar_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_avatar_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_avatar_url_large | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_avatar_url_small | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_civil_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_created | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_employment_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_function | |||
relation_ |
double |
itgen_spe_relation_manager_person_relation_manager_hourly_cost_tariff | |||
relation_ |
double |
itgen_spe_relation_manager_person_relation_manager_hourly_sales_tariff | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_id | |||
relation_ |
char |
itgen_spe_relation_manager_person_relation_manager_is_user | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_marital_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_modified | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_country | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_country_code | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_country_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_line_1 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_line_2 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_locality | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_postal_code | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_province | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_address_type | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_avatar_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_avatar_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_avatar_url_large | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_avatar_url_small | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_bank_bic | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_custom_salutation | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_date_of_birth | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_facebook_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_family_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_family_name_prefix | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_first_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_full_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_gender | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_gender_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_id_2 | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_initials | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_invoice_receiver | |||
relation_ |
char |
itgen_spe_relation_manager_person_relation_manager_person_is_active | |||
relation_ |
int64 |
itgen_spe_relation_manager_person_relation_manager_person_is_employee | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_linkedin_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_mailing_list_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_note | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_phone | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_bank_account | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_civil_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_created | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_created_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_employment_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_function | |||
relation_ |
double |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_hourly_cost_tariff | |||
relation_ |
double |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_hourly_sales_tariff | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_id | |||
relation_ |
char |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_is_user | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_marital_status | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_modified | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_name | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_person_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_social_security_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_updated_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_work_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_work_mobile | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_manager_work_phone | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_type_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_type_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_type_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_relation_type_type | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_twitter_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_updated_at | |||
relation_ |
char |
itgen_spe_relation_manager_person_relation_manager_person_use_custom_salutation | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_person_website_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_social_security_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_status_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_status_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_type_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_type_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_updated_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_work_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_work_mobile | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_manager_work_phone | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_type_color | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_type_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_type_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_relation_type_type | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_twitter_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_updated_at | |||
relation_ |
char |
itgen_spe_relation_manager_person_use_custom_salutation | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_person_website_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_simplicate_url | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_social_security_number | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_status_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_status_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_timeline_email_address | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_type_id | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_type_label | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_updated_at | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_work_email | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_work_mobile | |||
relation_ |
varchar2 |
itgen_spe_relation_manager_work_phone | |||
relation_ |
varchar2 |
Beziehungsnummer | |||
relation_ |
varchar2 |
Beziehungstyp Farbe | |||
relation_ |
varchar2 |
Beziehungstyp-ID | |||
relation_ |
varchar2 |
Beziehungstyp-Bezeichnung | |||
relation_ |
varchar2 |
Beziehungstyp | |||
render_ |
varchar2 |
Render-Typ | |||
searchable |
char |
Searchable | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
timeline_ |
varchar2 |
Zeitleiste E-Mail-Adresse | |||
type |
varchar2 |
Type | |||
updated_ |
varchar2 |
Aktualisiert am | |||
url |
varchar2 |
URL | |||
value |
varchar2 |
Value | |||
value_ |
varchar2 |
Wert Typ | |||
vat_ |
varchar2 |
Umsatzsteuer-Nummer | |||
visiting_ |
varchar2 |
Besuchsadresse Land | |||
visiting_ |
varchar2 |
Besuchsadresse Ländercode | |||
visiting_ |
varchar2 |
Besuchsadresse Ländercode | |||
visiting_ |
varchar2 |
Besuchsadresse-ID | |||
visiting_ |
varchar2 |
Besuchsadresse, Adressezeile 1 | |||
visiting_ |
varchar2 |
Besuchsadresse, Adressezeile 2 | |||
visiting_ |
varchar2 |
Besuchsadresse, Ort | |||
visiting_ |
varchar2 |
Besuchsadresse Postleitzahl | |||
visiting_ |
varchar2 |
Besuchsadresse Provinz | |||
visiting_ |
varchar2 |
Art der Besuchsadresse |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: