Employees: Exact Online Employees
popular insert update delete per partition REST
- Catálogo:
ExactOnlineREST - Esquema:
Payroll - Llaves Primarias:
ID - Label: Employees
Los datos de esta tabla están divididos por el valor de la columna Division.
Permite recuperar y modificar datos utilizando insert, update y delete.
Fuente de la API
- Punto final:
/api/v1/{division}/payroll/Employees - Metadatos:
/api/v1/{division}/payroll/$metadata
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 5 |
| Número de filas escaneadas por minuto | 7,200 |
| Número de filas de queries puntuales por minuto | 300 |
| Escribir filas por minuto | 300 |
El resultado se puede almacenar en la Caché del cliente.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla Employees. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Active |
int16 |
Empleo activo | filters on the platform, writable | Obsolete. | |
Address |
varchar2 |
Línea de la Dirección 2 | filters on the platform, writable | Second address line. | |
Address |
varchar2 |
Línea de la Dirección 3 | filters on the platform, writable | Third address line. | |
Address |
varchar2 |
Direeción Calle | filters on the platform, writable | Street of address. | |
Address |
varchar2 |
Número de la Calle en la Dirección | filters on the platform, writable | Street number of address. | |
Address |
varchar2 |
Sufijo dell Número de la Calle en la Dirección | filters on the platform, writable | Street number suffix of address. | |
Birth |
datetime |
Fecha de Nacimiento | filters on the platform, writable | Birth date. | |
Birth |
varchar2 |
Nombre de Nacimiento | filters on the platform, writable | Birth name. | |
Birth |
varchar2 |
Prefijo del Nombre de Nacimiento | filters on the platform, writable | Birth middle name. | |
Birth |
varchar2 |
Lugar de nacimiento | filters on the platform, writable | Birth place. | |
Business |
varchar2 |
Dirección de Correo Electrónico | filters on the platform, writable | Email of the employee at the office. | |
Business |
varchar2 |
Número de Fax en el Trabajo | filters on the platform, writable | Fax number of the employee at the office. | |
Business |
varchar2 |
Número de Teléfono Móvil en el Trabajo | filters on the platform, writable | Office mobile number of the employee. | |
Business |
varchar2 |
Número de Teléfono en el Trabajo | filters on the platform, writable | Phone number of the employee at the office. | |
Business |
varchar2 |
Extensión del Teléfono del Trabajo | 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 |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nombre Completo del Creador | 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 |
Número de la Cámara de Comercio de la División | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Número IBAN de la división | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
División: Nombre de la empresa | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Número de la división RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Número de IVA de la división | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Número de identificación fiscal de la división en materia de impuestos sobre los salarios | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etiqueta de división | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nombre de la Adminisración | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nombre del titular de la suscripción | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Número de titular de la suscripción | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nombre abreviado de la división | writable | Short name of the Exact Online division. | |
Email |
varchar2 |
filters on the platform, writable | Dirección de correo electrónico. | ||
Employee |
int32 |
HID del Empleado | filters on the platform, writable | Employee number. | |
End |
datetime |
Fecha Final | filters on the platform, writable | End date of the employee. | |
First |
varchar2 |
Primer Nombre | filters on the platform, writable | Nombre del empleado. | |
Full |
varchar2 |
Nombre Completo | 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 |
Está activo | filters on the platform, writable | IsActive. | |
Is |
int16 |
Es anónimo | filters on the platform, writable | Indicates whether the employee is anonymised. | |
Language |
varchar2 |
Language | filters on the platform, writable | Código de idioma. | |
Last |
varchar2 |
Apellido | filters on the platform, writable | Apellido. | |
Location |
varchar2 |
Descripción de la Ubicación | 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 |
Fecha Marital | filters on the platform, writable | Date of marriage. | |
Marital |
int16 |
Estado Civil | filters on the platform, writable | Marital status. | |
Middle |
varchar2 |
Segundo Nombre | filters on the platform, writable | Segundo nombre. | |
Mobile |
varchar2 |
Mobile | filters on the platform, writable | Mobile phone. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificado (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nombre completo modificado | filters on the platform, writable | Name of modifier. | |
Municipality |
varchar2 |
Municipality | filters on the platform, writable | Municipality. | |
Name |
int16 |
Composición del Nombre | 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 |
Nombre del socio | filters on the platform, writable | Name of partner. | |
Partner |
varchar2 |
Prefijo del Nombre del Socio | 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 | Número de teléfono. | |
Phone |
varchar2 |
Extensión Telefónica | filters on the platform, writable | Phone number extension. | |
Picture |
blob |
Picture | writable | ||
Picture |
varchar2 |
Nombre del archivo de imagen | filters on the platform, writable | Filename of picture. | |
Picture |
varchar2 |
Miniatura de la imagen (URL) | filtros de la plataforma | ||
Picture |
varchar2 |
Imagen (URL) | writable | Url of picture. | |
Postcode |
varchar2 |
Código Postal | filters on the platform, writable | Postcode. | |
Private |
varchar2 |
Correo electrónico privado | filters on the platform, writable | Private email address. | |
Social |
varchar2 |
Número de Seguro Social | filters on the platform, writable | Social security number. | |
Start |
datetime |
Fecha Inicial | 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 |
Nombre completo del usuario | filters on the platform, writable | Name of user. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Employees_ |
Creator |
Users. |
Key | |
Employees_ |
Customer |
Accounts.ID |
Key | |
Employees_ |
Modifier |
Users. |
Key |
Referenciado por
- 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)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: