OrganizationSbiCodes: Simplicate Organisation SBI Codes
read only REST
- Catalog:
Simplicate - Schema:
CRM - Label: Organisation SBI Codes
Fetches all organizations
Can only retrieve data.
API Source
- Endpoint:
/crm/organization - Operation:
get /crm/organization
Table Columns
The columns of the table OrganizationSbiCodes 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 |
|---|---|---|---|---|---|
accountancy_ |
char |
Accountancy - Is Tax Unit VAT | |||
accountancy_ |
char |
Accountancy - Is Tax Unit VPB | |||
accountancy_ |
varchar2 |
Accountancy - Is Tax Unit VAT Role | |||
accountancy_ |
varchar2 |
Accountancy - Is Tax Unit VPB Role | |||
accountancy_ |
varchar2 |
Accountancy - VAT Number Fiscal Unit | |||
allow_ |
char |
Auto Collect | |||
bank_ |
varchar2 |
Bank Account | |||
bank_ |
varchar2 |
Bank BIC | |||
coc_ |
varchar2 |
CoC Code | |||
code |
int64 |
Code | |||
created |
varchar2 |
Created | |||
created_ |
varchar2 |
Created at | |||
customer_ |
varchar2 |
itgen_spe_customer_group_id | |||
customer_ |
varchar2 |
itgen_spe_customer_group_name | |||
debtor_ |
varchar2 |
Debtor Attention to | |||
debtor_ |
varchar2 |
Debtor Attention to (fixed) | |||
debtor_ |
varchar2 |
Debtor Attention to Person ID | See /crm/person | ||
debtor_ |
char |
Debtor Auto Collect | |||
debtor_ |
char |
itgen_spe_debtor_autosend_subscription_invoice | |||
debtor_ |
varchar2 |
Debtor Invoice Template ID | |||
debtor_ |
int64 |
Debtor Payment Term (days) | |||
debtor_ |
varchar2 |
Debtor Payment Term ID | |||
debtor_ |
varchar2 |
Debtor Payment Term Method | |||
debtor_ |
varchar2 |
Debtor Payment Term Name | |||
debtor_ |
varchar2 |
itgen_spe_debtor_provision_contactperson_id | See /crm/person | ||
debtor_ |
varchar2 |
Provision Method | |||
debtor_ |
char |
Reminders | |||
debtor_ |
varchar2 |
Send Email | |||
debtor_ |
varchar2 |
Send Email Type | |||
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 | |||
description |
varchar2 |
Description | |||
email |
varchar2 |
||||
has_ |
char |
Different Postal Address | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
industry_ |
varchar2 |
Industry ID | |||
industry_ |
varchar2 |
Industry Name | |||
invoice_ |
varchar2 |
Invoice Receiver | |||
is_ |
char |
itgen_spe_is_active | |||
linkedin_ |
varchar2 |
LinkedIn URL | |||
modified |
varchar2 |
Modified | |||
name |
varchar2 |
Name | |||
note |
varchar2 |
Note | |||
organizationsize_ |
varchar2 |
Organisation Size ID | |||
organizationsize_ |
varchar2 |
Organisation Size Name | |||
phone |
varchar2 |
Phone | |||
postal_ |
varchar2 |
Postal Address Country | |||
postal_ |
varchar2 |
Postal Address Country Code | |||
postal_ |
varchar2 |
Postal Address Country ID | |||
postal_ |
varchar2 |
Postal Address ID | |||
postal_ |
varchar2 |
Postal Address Line 1 | |||
postal_ |
varchar2 |
Postal Address Line 2 | |||
postal_ |
varchar2 |
Postal Address Locality | |||
postal_ |
varchar2 |
Postal Address Postal Code | |||
postal_ |
varchar2 |
Postal Address Province | |||
postal_ |
varchar2 |
Postal Address Type | |||
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 |
Relationship Manager 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 |
Relationship Manager Name | |||
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 |
Relationship Manager Email | |||
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 |
Relation Number | |||
relation_ |
varchar2 |
Relation Type Colour | |||
relation_ |
varchar2 |
Relation Type ID | |||
relation_ |
varchar2 |
Relation Type Label | |||
relation_ |
varchar2 |
Relation Type | |||
simplicate_ |
varchar2 |
Simplicate URL | |||
timeline_ |
varchar2 |
Timeline Email Address | |||
updated_ |
varchar2 |
Updated at | |||
url |
varchar2 |
URL | |||
vat_ |
varchar2 |
VAT Number | |||
visiting_ |
varchar2 |
Visiting Address Country | |||
visiting_ |
varchar2 |
Visiting Address Country Code | |||
visiting_ |
varchar2 |
Visiting Address Country ID | |||
visiting_ |
varchar2 |
Visiting Address ID | |||
visiting_ |
varchar2 |
Visiting Address Address Line 1 | |||
visiting_ |
varchar2 |
Visiting Address Address Line 2 | |||
visiting_ |
varchar2 |
Visiting Address Locality | |||
visiting_ |
varchar2 |
Visiting Address Postal Code | |||
visiting_ |
varchar2 |
Visiting Address Province | |||
visiting_ |
varchar2 |
Visiting Address Type |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: