Departments |
Catalog: Freshservice
Schema: Freshservice
Primary Keys: id
This is a read-only table. The Freshservice API may not support changing the data or the Invantive UniversalSQL driver for Freshservice does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Freshservice API.
Table Columns
The columns of the table Departments are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
aantal_users |
string |
Aantal users |
☐ |
Custom field #0 of type custom_text. |
adres |
string |
Adres |
☐ |
Custom field #0 of type custom_text. |
asp_klant |
string |
AZURE klant |
☐ |
Custom field #0 of type custom_text. |
asp_klantcode |
string |
Nocore online URL |
☐ |
Custom field #0 of type custom_text. |
created_at |
datetime |
|
☐ |
Date/time at which the record was created. |
datum_aangemaakt |
string |
Datum aangemaakt |
☐ |
Custom field #0 of type custom_text. |
debiteur_nummer |
string |
Debiteur nummer |
☐ |
Custom field #0 of type custom_text. |
description_custom_field |
string |
Omschrijving |
☐ |
Custom field #0 of type custom_text. |
description |
string |
|
☐ |
|
domain_names |
string |
Domeinen voor deze afdeling |
☐ |
Custom field #0 of type custom_text. |
einddatum |
string |
Einddatum |
☐ |
Custom field #0 of type custom_text. |
facility_apps_gegevens |
string |
Facility Apps gegevens |
☐ |
Custom field #0 of type custom_text. |
geblokkeerd |
string |
Geblokkeerd |
☐ |
Custom field #0 of type custom_text. |
head_name_custom_field |
string |
Afdelingshoofd |
☐ |
Custom field #0 of type custom_text. |
head_name |
string |
|
☐ |
|
head_user_id |
int64 |
|
☐ |
|
id |
int64 |
|
☑ |
|
loonbureau |
string |
Loonbureau |
☐ |
Custom field #0 of type custom_text. |
name_custom_field |
string |
Afdelingsnaam |
☐ |
Custom field #0 of type custom_text. |
name |
string |
|
☐ |
|
nocore_online |
string |
Nocore Online |
☐ |
Custom field #0 of type custom_text. |
plaats |
string |
Plaats |
☐ |
Custom field #0 of type custom_text. |
prime_user_id |
int64 |
|
☐ |
|
prime_user_name_custom_field |
string |
Primaire gebruiker |
☐ |
Custom field #0 of type custom_text. |
prime_user_name |
string |
|
☐ |
|
sla |
string |
SLA |
☐ |
Custom field #0 of type custom_text. |
systeembeheerder |
string |
Systeembeheerder |
☐ |
Custom field #0 of type custom_text. |
telefoonnummer |
string |
Telefoonnummer |
☐ |
Custom field #0 of type custom_text. |
updated_at |
datetime |
|
☐ |
Date/time at which the record was last updated. |
zoeknaam |
string |
Zoeknaam |
☐ |
Custom field #0 of type custom_text. |
11-12-2024 09:11 Version 24.0.491-PROD+5130