Retrieves all the companies
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult
companyName | Description | Type | Additional information |
---|---|---|---|
id |
Primary Key |
globally unique identifier |
Required |
is_client |
SALES : Indicate if can be used for ordering |
boolean | |
is_supplier |
SERVICES : indicate if this company is a supplier |
boolean | |
archived |
Archive this company to not have it anymore on the search |
boolean | |
name | string |
Required Max length: 64 |
|
notes |
Notes/Remark field |
string | |
create_date |
Creation date+time |
date | |
sales_territory_id |
Territory of the company (Sales+Services).If more than one sales_territory exists, then it must be filled |
globally unique identifier | |
sales_territory_code |
Embedded entity "sales_territory" using ERP PK when adding/updating company |
string | |
sales_territory |
Embedded entity "sales_territory" using node when adding/updating company |
sales_territory | |
marketing_segment_id |
Marketing Segment of the company (Sales (Visit frequency logic) +Services (Planning Jobs To Be Planned) ) |
globally unique identifier | |
marketing_segment_code |
Embedded entity "marketing_segment" using ERP PK when adding/updating company |
string | |
marketing_segment |
Embedded entity "marketing_segment" using node when adding/updating company |
marketing_segment | |
sales_organization_id |
Organization on which belongs the company.If more than one sales_organization exists, then it must be filled |
globally unique identifier | |
sales_organization_code |
Embedded entity "sales_organization" using ERP PK when adding/updating company |
string | |
sales_organization |
Embedded entity "sales_organization" using node when adding/updating company |
sales_organization | |
company_sales_status_code |
Foreign key of company_sales_status using code. Use "Normal,CreditRisk, BlockedbyCM or OrderBlocked" |
string | |
vat_reg_code |
VAT number |
string |
Max length: 50 |
is_working_address |
Services : If False, you cannot create project/installation on this company.Default=true |
boolean | |
parent_id |
Reference to a parent company (in case of Child/Parent) when adding/updating company |
globally unique identifier | |
parent_company_code |
Embedded entity "company" for parent (in case of Child/Parent) using ERP PK when adding/updating company |
string | |
parent_company |
Embedded entity "company" for parent (in case of Child/Parent) when adding/updating company |
company | |
phone |
Phone number of the company |
string |
Max length: 50 |
fax |
Fax number of the company |
string |
Max length: 50 |
url |
URL of the company website |
string |
Max length: 255 |
|
string |
Max length: 250 |
|
street |
Address:Street |
string |
Max length: 100 |
street_number |
Address:Street Number. If your ERP doesn't have this field, then only use field "street" and disable the street number on Odyssee/Admin/Impl Settings/Global Settings:Hide Street Number |
string |
Max length: 50 |
city |
Address:City |
string |
Max length: 50 |
zip |
Address:Zip |
string |
Max length: 50 |
db_country_id |
Address:Country |
globally unique identifier | |
db_country_code |
Address:CountryCode entity using international code when adding/updating company |
string | |
feelist_id |
FeeList activated for the company (On Service, Feelist determines the price of the invoicable timesheets) |
globally unique identifier | |
feelist_reference_back_office |
Embedded entity "feelist" using ERP PK when adding/updating company |
string | |
feelist |
Embedded entity "feelist" using node when adding/updating company |
feelist | |
company_type_id |
Company Type |
globally unique identifier | |
company_type_name |
Embedded entity "company_type" using ERP PK when adding/updating company |
string | |
company_type |
Embedded entity "company_type" using node when adding/updating company |
company_type | |
db_language_id |
Language of the company.If empty, will use the default on the system |
globally unique identifier | |
db_language_code |
Language code entity using international isocode when adding/updating company |
string | |
code |
Field used for Embedded entity (store there your ERP PK) |
string |
Max length: 50 |
article_price_label_id |
Foreign key of article price label |
globally unique identifier | |
article_price_label_code |
Embedded entity "article price label" using ERP PK when adding/updating |
string | |
article_price_label |
Embedded entity "article price label" when adding/updating |
article_price_label | |
db_payment_method_id |
Embedded entity "db payment methods" using ERP PK when adding/updating company |
globally unique identifier | |
db_payment_method_reference_back_office |
Embedded entity "db payment methods" using ERP PK when adding/updating company |
string | |
db_payment_methods |
Embedded entity "db payment methods" using ERP PK when adding/updating company |
db_payment_methods | |
company_sector_id |
Foreign key to company_sector |
globally unique identifier | |
company_sector_code |
Embedded code for the company_sector using ERP PK when adding/updating |
string | |
company_sector |
Embedded entity for the company_sector using the key from an external system when adding/updating object |
company_sector | |
is_lead |
Indicate that company is not already a customer |
boolean | |
is_subcontractor |
For Service, that company is one of your subcontractors |
boolean | |
latitude |
Decimal coordonate for the latitude. (-1;-1) means invalid and (0;0) means not already geo-encoded |
decimal number | |
longitude |
Decimal coordonate for the longitude. (-1;-1) means invalid and (0;0) means not already geo-encoded |
decimal number | |
street2 |
Additional information on the address not part of the postal address |
string | |
bic_code |
bic code |
string | |
specialities |
specialities |
string | |
register_number |
register_number |
string | |
register_city |
register_city |
string | |
bankaccount |
Bank account of the company. |
string | |
mobile |
Mobile number of the company |
string |
Max length: 50 |
service_manager_user_id |
ID of the service manager. Auto selected user when creating location, installation. Used also inside communication and tags |
globally unique identifier | |
service_manager_user_code |
Embedded code of the service manager. Auto selected user when creating location, installation. Used also inside communication and tags |
string | |
service_manager_user |
Embedded entity of the service manager. Auto selected user when creating location, installation. Used also inside communication and tags |
user | |
finance_manager_user_id |
ID of the finance manager. Only used inside communication and tags |
globally unique identifier | |
finance_manager_user_code |
Embedded code of the finance manager. Only used inside communication and tags |
string | |
finance_manager_user |
Embedded entity of the finance manager. Only used inside communication and tags |
user | |
account_manager_user_id |
ID of the account manager. Only used inside communication and tags |
globally unique identifier | |
account_manager_user_code |
Embedded code of the account manager. Only used inside communication and tags |
string | |
account_manager_user |
Embedded entity of the account manager. Only used inside communication and tags |
user | |
company_status_id |
Company Status |
globally unique identifier | |
invoice_email_to |
Email to send invoice |
string | |
modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
id2 |
Internal ID (numeric) |
integer |
Response Formats
application/json, text/json
{ "id": "41b101af-51b4-434b-8c6d-30e7367c6ae9", "is_client": true, "is_supplier": true, "archived": true, "name": "sample string 5", "notes": "sample string 6", "create_date": "2025-01-22T01:18:40.8885079+00:00", "sales_territory_id": "177bbfb3-b915-4bff-ad1a-3daf4ae7478d", "sales_territory_code": "sample string 9", "sales_territory": { "id": "5367d344-cf01-472c-8f5a-4bb48d9420be", "code": "sample string 2", "description": "sample string 3", "sales_organization_id": "69532002-880d-4015-98f7-5ae663462d7b", "sales_organization_code": "sample string 5", "sales_organization": { "id": "e935ac82-35c8-45d6-aa84-a3d866ae4465", "code": "sample string 2", "name": "sample string 3", "description": "sample string 4", "db_country_id": "6449708e-00d2-464b-8906-5400c0d918c9", "db_currency_id": "c5a4ac7e-fce0-47aa-b0d2-0d7b100103af", "db_language_id": "afcbd50e-2d1d-4532-977e-09b5bdc1f21e", "accountancy_code": "sample string 8", "archived": true, "default_unit_of_measure_system_type": "sample string 10", "street": "sample string 11", "street2": "sample string 12", "street_number": "sample string 13", "zip": "sample string 14", "city": "sample string 15", "email": "sample string 16", "phone": "sample string 17", "fax": "sample string 18", "url": "sample string 19", "vat_reg_code": "sample string 20", "modified_dateutc": "2025-01-22T01:18:40.8885079+00:00" }, "modified_dateutc": "2025-01-22T01:18:40.8885079+00:00" }, "marketing_segment_id": "9fa94237-6768-43a5-acfa-7704cb165578", "marketing_segment_code": "sample string 11", "sales_organization_id": "cd44c1da-0264-452f-80b8-5f0d2f18aa65", "sales_organization_code": "sample string 13", "company_sales_status_code": "sample string 14", "vat_reg_code": "sample string 15", "is_working_address": true, "parent_id": "eda2ae75-1cde-4f41-afa1-8251d13a2917", "parent_company_code": "sample string 18", "phone": "sample string 19", "fax": "sample string 20", "url": "sample string 21", "email": "sample string 22", "street": "sample string 23", "street_number": "sample string 24", "city": "sample string 25", "zip": "sample string 26", "db_country_id": "38c6085e-6f0d-49d0-b7a5-1a1eae763360", "db_country_code": "sample string 28", "feelist_id": "0d64caf7-ba97-4da8-a9c0-2e23e13660d8", "feelist_reference_back_office": "sample string 30", "feelist": { "id": "ad520e1d-f4b6-4f5f-be85-b3eeb4913c04", "name": "sample string 2", "description": "sample string 3", "is_default": true, "default_price": 1.0, "sales_organization_id": "33af9a95-5c97-4577-aff8-9e793cd30c99", "sales_organization_code": "sample string 6", "reference_back_office": "sample string 7", "modified_dateutc": "2025-01-22T01:18:40.8885079+00:00", "db_currency_id": "d10a9906-b7e4-4b75-aa83-4c610d87d4ff", "db_currency_code": "sample string 10" }, "company_type_id": "807046fc-aa9a-47d6-b675-caae185593a4", "company_type_name": "sample string 32", "company_type": { "id": "95f1c1c2-a9a2-45ea-9101-85ea79c466e4", "name": "sample string 2", "description": "sample string 3", "sales_organization_id": "89e9865a-760d-45f7-9ccb-6e5df20442e2", "sales_organization_code": "sample string 5" }, "db_language_id": "b6d7da72-6e1e-438d-8e9e-3569b960ca70", "db_language_code": "sample string 34", "code": "sample string 35", "article_price_label_id": "70d409ed-a419-4b67-b655-7cd3aff091bf", "article_price_label_code": "sample string 37", "db_payment_method_id": "0893e826-0fc4-4d1d-9c83-1f2308f52328", "db_payment_method_reference_back_office": "sample string 39", "db_payment_methods": { "id": "00ff5022-e74b-4e3c-a582-6d38077b67c6", "name": "sample string 2", "description": "sample string 3", "reference_back_office": "sample string 4", "activated": true, "modified_dateutc": "2025-01-22T01:18:40.8885079+00:00" }, "company_sector_id": "9452c0a0-9774-459d-995f-0068413238e1", "company_sector_code": "sample string 41", "is_lead": true, "is_subcontractor": true, "latitude": 1.0, "longitude": 1.0, "street2": "sample string 44", "bic_code": "sample string 45", "specialities": "sample string 46", "register_number": "sample string 47", "register_city": "sample string 48", "bankaccount": "sample string 49", "mobile": "sample string 50", "service_manager_user_id": "0185d85e-ca31-4873-a6e3-fce1619a09b4", "service_manager_user_code": "sample string 52", "finance_manager_user_id": "43ca7a9a-ebf2-4e5a-9f76-10ae72b027a1", "finance_manager_user_code": "sample string 54", "account_manager_user_id": "c1b0c8c9-6de8-4a57-8bd2-559c77d27300", "account_manager_user_code": "sample string 56", "company_status_id": "9117eaa6-e8cc-4cb1-90c1-9eefd92a66ef", "invoice_email_to": "sample string 58", "modified_dateutc": "2025-01-22T01:18:40.8885079+00:00", "id2": 60 }