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": "6999cf93-501c-455e-8221-e045438404c9", "is_client": true, "is_supplier": true, "archived": true, "name": "sample string 5", "notes": "sample string 6", "create_date": "2024-12-21T14:27:27.4091539+00:00", "sales_territory_id": "c6e26615-7e04-43a3-b87e-b56e3b11ca2b", "sales_territory_code": "sample string 9", "sales_territory": { "id": "81d8002d-26f0-42f0-9170-7d6c74c7ff1f", "code": "sample string 2", "description": "sample string 3", "sales_organization_id": "114ff3b0-a824-47ba-9f72-2e30ed6c4dbd", "sales_organization_code": "sample string 5", "sales_organization": { "id": "6ade3525-a919-47a3-ad03-d374dd8e56fd", "code": "sample string 2", "name": "sample string 3", "description": "sample string 4", "db_country_id": "145bbadb-8665-46fc-a5fa-812f8f697ead", "db_currency_id": "ee7e7d64-b654-454b-a381-2337574439b9", "db_language_id": "53f9e9c1-605d-4af4-8940-f1fc58bd2ff3", "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": "2024-12-21T14:27:27.4091539+00:00" }, "modified_dateutc": "2024-12-21T14:27:27.4091539+00:00" }, "marketing_segment_id": "f8d29fab-3367-48e5-8efa-9d7bc7cb638e", "marketing_segment_code": "sample string 11", "sales_organization_id": "ce40d043-df66-4695-b7b2-8573efdb7fff", "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": "ed5ccd72-3610-494a-a992-fd9a5b818f9e", "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": "56e66fa6-06e5-4a1b-9414-1423271057f3", "db_country_code": "sample string 28", "feelist_id": "5141bea5-d594-46aa-b258-a2de84daf2f8", "feelist_reference_back_office": "sample string 30", "feelist": { "id": "c1ad7fc4-10c3-4e45-a30a-646465675e0f", "name": "sample string 2", "description": "sample string 3", "is_default": true, "default_price": 1.0, "sales_organization_id": "29234160-5f2c-47fc-a9ce-912dcee9930d", "sales_organization_code": "sample string 6", "reference_back_office": "sample string 7", "modified_dateutc": "2024-12-21T14:27:27.4091539+00:00", "db_currency_id": "d0b94ad0-c302-4517-bf46-7e890b898a5a", "db_currency_code": "sample string 10" }, "company_type_id": "8591c1e3-7a05-48c6-b94a-de19562e5e9b", "company_type_name": "sample string 32", "company_type": { "id": "c5c88f76-f34c-4b05-a79c-17ea61386ad1", "name": "sample string 2", "description": "sample string 3", "sales_organization_id": "56921dee-93d1-4137-ac7a-96a97c0c90d6", "sales_organization_code": "sample string 5" }, "db_language_id": "f4a9ef2d-f471-4c8b-bcec-5f1ca40b4234", "db_language_code": "sample string 34", "code": "sample string 35", "article_price_label_id": "ef84adec-00ff-4836-a677-dc8a61ddc599", "article_price_label_code": "sample string 37", "db_payment_method_id": "954e69ab-885e-4d4f-a8ab-827a38b48e87", "db_payment_method_reference_back_office": "sample string 39", "db_payment_methods": { "id": "b5436452-4bb6-4871-a0f2-a59cf42688c3", "name": "sample string 2", "description": "sample string 3", "reference_back_office": "sample string 4", "activated": true, "modified_dateutc": "2024-12-21T14:27:27.4091539+00:00" }, "company_sector_id": "c36d6bf7-2604-4b34-990a-a5653c0551be", "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": "a29f7625-629c-49ca-b0c1-7a0518ab4d10", "service_manager_user_code": "sample string 52", "finance_manager_user_id": "22abec36-f83a-4fa1-b0b9-b18bcc9f2e9e", "finance_manager_user_code": "sample string 54", "account_manager_user_id": "64c4adfa-3bd0-4ffd-b2a8-1c76124f1e18", "account_manager_user_code": "sample string 56", "company_status_id": "1d8be4c6-78cb-48d8-8790-7bb0e2ab65bf", "invoice_email_to": "sample string 58", "modified_dateutc": "2024-12-21T14:27:27.4091539+00:00", "id2": 60 }