Employees: Exact Online Employees
popular insert update delete per partition REST
- Catalogo:
ExactOnlineREST - Schema:
Payroll - Chiavi primarie:
ID - Label: Employees
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/payroll/Employees - Metadati:
/api/v1/{division}/payroll/$metadata
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 7,200 |
| Numero di righe di Query al minuto | 300 |
| Scrittura di righe al minuto | 300 |
Il risultato può essere memorizzato nella memoria cache sul client.
Colonne della tabella
Di seguito sono riportate le colonne della tabella Employees. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Active |
int16 |
Occupazione attiva | filters on the platform, writable | Obsolete. | |
Address |
varchar2 |
Indirizzo 2 | filters on the platform, writable | Second address line. | |
Address |
varchar2 |
Indirizzo 3 | filters on the platform, writable | Third address line. | |
Address |
varchar2 |
Indirizzo: Via | filters on the platform, writable | Street of address. | |
Address |
varchar2 |
Indirizzo numero civico | filters on the platform, writable | Street number of address. | |
Address |
varchar2 |
Suffisso del numero civico dell'indirizzo | filters on the platform, writable | Street number suffix of address. | |
Birth |
datetime |
Data di nascita | filters on the platform, writable | Birth date. | |
Birth |
varchar2 |
Nome di nascita | filters on the platform, writable | Birth name. | |
Birth |
varchar2 |
Prefisso del nome di nascita | filters on the platform, writable | Birth middle name. | |
Birth |
varchar2 |
Luogo di nascita | filters on the platform, writable | Birth place. | |
Business |
varchar2 |
Indirizzo e-mail | filters on the platform, writable | Email of the employee at the office. | |
Business |
varchar2 |
Fax aziendale | filters on the platform, writable | Fax number of the employee at the office. | |
Business |
varchar2 |
Mobile aziendale | filters on the platform, writable | Office mobile number of the employee. | |
Business |
varchar2 |
Telefono aziendale | filters on the platform, writable | Phone number of the employee at the office. | |
Business |
varchar2 |
Interno telefonico aziendale | filters on the platform, writable | Phone extension of the employee at the office. | |
CASO |
varchar2 |
itgen_eol_casonumber | writable | Obsolete. | |
City |
varchar2 |
City | filters on the platform, writable | City. | |
Code |
varchar2 |
Code | filters on the platform, writable | Code of the employee. | |
Country |
varchar2 |
Country | filters on the platform, writable | Country code. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creato | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nome completo del creatore | filters on the platform, writable | Name of creator. | |
Customer |
guid |
Customer | filters on the platform, writable | Customer ID. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Numero di iscrizione alla Camera di Commercio della Divisione | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Codice IBAN della divisione | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisione - Nome dell'azienda | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numero di divisione RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Partita IVA della divisione | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Codice fiscale salariale della divisione | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etichetta della divisione | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nome dell'amministrazione | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nome del titolare dell'abbonamento | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numero di abbonato | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nome abbreviato della divisione | writable | Short name of the Exact Online division. | |
Email |
varchar2 |
filters on the platform, writable | Indirizzo e-mail. | ||
Employee |
int32 |
Dipendente HID | filters on the platform, writable | Employee number. | |
End |
datetime |
Data di fine | filters on the platform, writable | End date of the employee. | |
First |
varchar2 |
Nome | filters on the platform, writable | Nome del dipendente. | |
Full |
varchar2 |
Nome completo per l'uso nelle liste | filters on the platform, writable | Full name of the employee. | |
Gender |
varchar2 |
Gender | filters on the platform, writable | Gender. | |
HID |
int32 |
HID | filters on the platform, writable | Numeric ID of the employee. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Initials |
varchar2 |
Initials | filters on the platform, writable | Initials. | |
Is |
char |
È attivo | filters on the platform, writable | IsActive. | |
Is |
int16 |
È anonimizzato | filters on the platform, writable | Indicates whether the employee is anonymised. | |
Language |
varchar2 |
Language | filters on the platform, writable | Codice lingua. | |
Last |
varchar2 |
Cognome | filters on the platform, writable | Cognome. | |
Location |
varchar2 |
Descrizione della posizione | filters on the platform, writable | Description of the location of the employee (where am I?). | |
Manager |
guid |
Manager | filters on the platform, writable | Direct manager of the employee. | |
Marital |
datetime |
Data del matrimonio | filters on the platform, writable | Date of marriage. | |
Marital |
int16 |
Stato civile | filters on the platform, writable | Marital status. | |
Middle |
varchar2 |
Secondo nome | filters on the platform, writable | Secondo nome. | |
Mobile |
varchar2 |
Mobile | filters on the platform, writable | Mobile phone. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificato (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nome completo modificato | filters on the platform, writable | Name of modifier. | |
Municipality |
varchar2 |
Municipality | filters on the platform, writable | Municipality. | |
Name |
int16 |
Composizione del nome | filters on the platform, writable | ||
Nationality |
varchar2 |
Nationality | filters on the platform, writable | Nationality. | |
Nick |
varchar2 |
Nickname | filters on the platform, writable | Nick name. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Additional notes. | |
Partner |
varchar2 |
Nome partner | filters on the platform, writable | Name of partner. | |
Partner |
varchar2 |
Prefisso del nome del partner | filters on the platform, writable | Middle name of partner. | |
Person |
guid |
Person | filters on the platform, writable | Reference to the persons table in which the personal data of the employee is stored. | |
Phone |
varchar2 |
Phone | filters on the platform, writable | Numero di telefono. | |
Phone |
varchar2 |
Estensione del telefono | filters on the platform, writable | Phone number extension. | |
Picture |
blob |
Picture | writable | ||
Picture |
varchar2 |
Nome del file immagine | filters on the platform, writable | Filename of picture. | |
Picture |
varchar2 |
Miniatura dell'immagine (URL) | filtri sulla piattaforma | ||
Picture |
varchar2 |
Immagine (URL) | writable | Url of picture. | |
Postcode |
varchar2 |
Codice postale | filters on the platform, writable | Postcode. | |
Private |
varchar2 |
E-mail privata | filters on the platform, writable | Private email address. | |
Social |
varchar2 |
Numero della sicurezza sociale | filters on the platform, writable | Social security number. | |
Start |
datetime |
Data di inizio | filters on the platform, writable | Start date of the employee. | |
State |
varchar2 |
State | filters on the platform, writable | State/Province code. | |
Title |
varchar2 |
Title | filters on the platform, writable | Title. | |
User |
guid |
User | filters on the platform, writable | User ID of employee. | |
User |
varchar2 |
Nome completo dell'utente | filters on the platform, writable | Name of user. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Employees_ |
Creator |
Users. |
Key | |
Employees_ |
Customer |
Accounts.ID |
Key | |
Employees_ |
Modifier |
Users. |
Key |
Riferito da
- AbsenceRegistrations
Employee(Key) - EmploymentCompanyCars
Employee(Key) - LeaveBuildUpRegistrations
Employee(Key) - LeaveRegistrations
Employee(Key) - MfgTimeTransactions
Employee(Key) - ActiveEmployments
Employee(Key) - EmploymentContracts
Employee(Key) - EmploymentOrganizations
Employee(Key) - EmploymentSalaries
Employee(Key) - Employments
Employee(Key) - VariableMutations
EmployeeID(Key) - CostTransactions
Employee(Key) - EmployeeRestrictionItems
Employee(Key) - EmploymentInternalRates
Employee(Key) - PjtTimeTransactions
Employee(Key) - ProjectPlanning
Employee(Key) - ProjectPlanningRecurring
Employee(Key) - ProjectRestrictionEmployeeItems
Employee(Key) - ProjectRestrictionEmployees
Employee(Key) - SalesInvoiceLines
Employee(Key) - SalesInvoiceLinesBulk
Employee(Key) - SubscriptionRestrictionEmployees
Employee(Key) - Me
EmployeeID(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: