PayrollTransactionsAll: Exact Online Payroll Transactions
read only
- Catálogo:
ExactOnlineREST - Esquema:
Payroll - Label: Payroll Transactions
Payroll transactions across all payroll years.
Solo puede recuperar datos.
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 432 |
| Número de filas escaneadas por minuto | 50,300 |
| Número de filas de queries puntuales por minuto | 138 |
El resultado se puede almacenar en la Caché del cliente.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla PayrollTransactionsAll. 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 |
|---|---|---|---|---|---|
Calculated |
double |
Cantidad Calculada | writable | Calculated amount. | |
Calculated |
double |
Valor base calculado | writable | Calculated base value. | |
Calculated |
double |
Franquicia calculada | writable | Calculated franchise. | |
Calculated |
double |
Máximo calculado | writable | Calculated maximum. | |
Calculated |
double |
Número calculado | writable | Calculated number. | |
Cost |
varchar2 |
Centro de Costo | writable | Cost center. | |
Cost |
varchar2 |
Código de Centro de Costo | writable | Cost center code. | |
Cost |
varchar2 |
Descripción del Centro de Costo | writable | Cost center description. | |
Cost |
varchar2 |
Unidad de Costo | writable | Cost unit. | |
Cost |
varchar2 |
Código de la Unidad de Costo | writable | Cost unit code. | |
Cost |
varchar2 |
Descripción de la Unidad de Costo | writable | Cost unit description. | |
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | Creator. | |
Creator |
varchar2 |
Nombre Completo del Creador | writable | Creator full name. | |
Date |
datetime |
Date | writable | Date. | |
Department |
guid |
Department | writable | Department. | |
Department |
varchar2 |
Código de departamento | writable | Department code. | |
Department |
varchar2 |
Descripción del departamento | writable | Department description. | |
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. | |
Employee |
guid |
Employee | writable | Employee. | |
Employee |
int32 |
HID del Empleado | writable | Employee number. | |
Employment |
guid |
Employment | filters on the platform, writable | Employment. | |
Employment |
guid |
Grupo de condiciones laborales | writable | Employment condition group. | |
Employment |
varchar2 |
Código de grupo de condiciones laborales | writable | Employment condition group code. | |
Employment |
varchar2 |
Descripción del grupo de condiciones laborales | writable | Employment condition group description. | |
Entry |
double |
Importe de la participación | writable | Entry amount. | |
Entry |
double |
Base de entrada | writable | Entry base. | |
Entry |
double |
Número de Entrada | writable | Entry number. | |
Entry |
double |
Porcentaje de participación | writable | Entry percentage. | |
Entry |
double |
Porcentaje de participación 2 | filtros de la plataforma | Second entry percentage. | |
Entry |
int16 |
Tipo de entrada | writable | Entry type. | |
Entry |
varchar2 |
Tipo de entrada Descripción | writable | Entry type description. | |
Frequency |
int32 |
Frequency | filters on the platform, writable | Frequency: 1 - Yearly, 2 - Quarterly, 3 - Monthly, 4 - 4-weekly, 5 - Weekly, 11 - Yearly (Pro forma), 12 - Quarterly (Pro forma), 13 - Monthly (Pro forma), 14 - 4-Weekly (Pro forma), 15 - Weekly (Pro forma). | |
Full |
varchar2 |
Nombre Completo | writable | Name of employee. | |
ID |
guid |
ID | writable | Transaction. | |
Modified |
datetime |
Modified | writable | Last modified date. | |
Modifier |
guid |
Modifier | writable | Modifier. | |
Modifier |
varchar2 |
Nombre completo modificado | writable | Modifier full name. | |
Payroll |
guid |
Componente de la Nómina | filters on the platform, writable | Payroll component. | |
Payroll |
varchar2 |
Código de componente de nómina | writable | Payroll component code. | |
Payroll |
varchar2 |
Descripción de los componentes de la nómina | writable | Payroll component description. | |
Payroll |
int32 |
Tipo de componente de nómina | writable | Payroll component type. | |
Payroll |
varchar2 |
Tipo de componente de nómina Descripción | writable | Payroll component type description. | |
Payroll |
guid |
Procesamiento de nóminas | writable | Payroll run. | |
Payroll |
varchar2 |
Código de ejecución de nóminas | writable | Payroll run code. | |
Payroll |
int16 |
Año de la Nómina | filters on the platform, writable | Payroll year. | |
Period |
int16 |
Period | filters on the platform, writable | Payroll period. | |
Status |
int16 |
Status | filters on the platform, writable | Transaction status: 1 - Not entered, 2 - Entered, 3 - Open, 4 - Calculated, 5 - Approved, 6 - Finalized, 7 - Deleted. | |
Type |
int16 |
Type | writable | Transaction type. | |
Type |
varchar2 |
Descripción del Tipo | writable | Transaction type description. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: