invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

EmploymentSalariesEx: Exact Online Employment Salaries

insert update per partition XML

  • Catálogo: ExactOnlineXML
  • Esquema: XML
  • Label: Employment Salaries

Los datos de esta tabla están divididos por el valor de la columna Division.

Permite recuperar y modificar datos mediante insert y update.

Resumen

Additional where-clause columns supported:

  • division
  • employeehid

Fuente de la API

  • Servicio XML: Employments
  • Tema XML: Employments
  • Ruta XML: /EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary

Parámetros

Name Tipo de Datos Required Default Documentation
division int32 Company code.
Params_EmployeeHID int32 Employee human identifier.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla EmploymentSalariesEx. 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
AMOUNTTYPE number Tipo de Cantidad /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/AmountType/
AVERAGEDAYSPERWEEK number Número medio de días por semana /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/AverageDaysPerWeek/
AVERAGEHOURSPERWEEK number Número medio de horas por semana /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/AverageHoursPerWeek/
DIVISION_CODE varchar2 Identificación de la Administración Número único Interno de la administración de Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nombre de la Adminisración Name of the Exact Online administration.Not guaranteed to be unique.
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYEE_EMPLOYEEHID_ATTR number itgen_eol_employments_employment_employee Employee HID /eExact/Employments/Employment/Employee/EmployeeHID
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTCONTRACTS varchar2 itgen_eol_employments_employment Employment Contracts /eExact/Employments/Employment/EmploymentContracts/
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTNUMBER_ATTR number itgen_eol_employments_employment Employment Number /eExact/Employments/Employment/EmploymentNumber
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTORGANIZATIONS varchar2 itgen_eol_employments_employment Employment Organisations /eExact/Employments/Employment/EmploymentOrganizations/
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_ENDDATE date itgen_eol_employments_employment End Date /eExact/Employments/Employment/EndDate/ End date: YYYY-MM-DD
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_HID_ATTR number itgen_eol_employments_employment HID /eExact/Employments/Employment/HID
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_REASONEND number itgen_eol_employments_employment Reason End /eExact/Employments/Employment/ReasonEnd/
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_STARTDATE date itgen_eol_employments_employment Start Date /eExact/Employments/Employment/StartDate/ Start date: YYYY-MM-DD
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_STARTDATEORGANIZATION date itgen_eol_employments_employment Start Date Organisation /eExact/Employments/Employment/StartDateOrganization/
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCOMPONENTS varchar2 itgen_eol_employments_employment_employment_clas_employment_cla Employment Components /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentComponents/
EMPLOYMENTSALARIES_EMPLOYMENTCLA_ENDDATE date itgen_eol_employments_employment_employment_clas_employment_cla End Date /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EndDate/ End date: YYYY-MM-DD
EMPLOYMENTSALARIES_EMPLOYMENTCLA_NOTES varchar2 itgen_eol_employments_employment_employment_clas_employment_cla Notes /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/Notes/
EMPLOYMENTSALARIES_EMPLOYMENTCLA_PAYROLLCOMPONENTGROUP_CODE_ATTR varchar2 itgen_eol_employments_employment_employment_clas_employment_cla_payroll_component_group Code /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/PayrollComponentGroup/code
EMPLOYMENTSALARIES_EMPLOYMENTCLA_PAYROLLCOMPONENTGROUP_STARTDATE date itgen_eol_employments_employment_employment_clas_employment_cla_payroll_component_group Start Date /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/PayrollComponentGroup/StartDate/ Start date: YYYY-MM-DD
EMPLOYMENTSALARIES_EMPLOYMENTCLA_STARTDATE date itgen_eol_employments_employment_employment_clas_employment_cla Start Date /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/StartDate/ Start date: YYYY-MM-DD
EMPLOYMENTSALARYTYPE number Tipo de Salario del Empleo /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/EmploymentSalaryType/
ENDDATE date Fecha Final /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/EndDate/ End date: YYYY-MM-DD
FULLTIMEAMOUNT number Cantidad a Tiempo Completo /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/FulltimeAmount/
HOURLYWAGE number Salario por Hora /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/HourlyWage/
INTERFACE_URL varchar2(4000) URL de Interfaz URL utilizada para que interactúe esta fila con Exact Online.
INTERNALRATE number Tasa interna /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/InternalRate/
JOBLEVEL number Nivel de Trabajo /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/JobLevel/
NOTES varchar2 Notes /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/Notes/
PARTTIMEAMOUNT number Cantidad a Tiempo Parcial /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/ParttimeAmount/
PARTTIMEFACTOR number Factor a Tiempo Parcial /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/ParttimeFactor/
PAYROLLPERIODFREQUENCY number Frecuencia del Período de la Nómina /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/PayrollPeriodFrequency/
PAYROLLTABLE_CODE_ATTR varchar2 itgen_eol_payroll_table Code /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/PayrollTable/code
PAYROLLTABLE_STARTDATE date itgen_eol_payroll_table Start Date /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/PayrollTable/StartDate/ Start date: YYYY-MM-DD
ROWNUM int64 Número de la Fila Número de fila dentro de los resultados, empezando por el 1.
SALARYBASEDTYPE number itgen_eol_salary_based_type /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/SalaryBasedType/
SCALE varchar2 Scale /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/Scale/
STARTDATE date Fecha Inicial /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/StartDate/ Start date: YYYY-MM-DD
WAGESCALECODE varchar2 itgen_eol_wage_scale_code /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/WageScaleCode/
WAGESCALEPERIOD number itgen_eol_wage_scale_period /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/WageScalePeriod/
WAGESCALESTARTDATE varchar2 itgen_eol_wage_scale_start_date /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/WageScaleStartDate/
WAGESCALESTEP varchar2 itgen_eol_wage_scale_step /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/WageScaleStep/

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: