invantive documentation
Forum di supporto InvantiveAccedi / Registrati

EmploymentSalaries: Exact Online Employment Salaries

insert update per partition XML

  • Catalogo: ExactOnlineXML
  • Schema: XML
  • Label: Employment Salaries

I dati in questa tabella sono partizionati per valore della colonna Division.

È possibile recuperare e modificare i dati utilizzando insert e update.

Additional where-clause columns supported:

  • division
  • employeehid

Codice sorgente dell'API

  • Servizio XML: Employments
  • Argomento XML: Employments
  • Percorso XML: /EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary

Colonne della tabella

Di seguito sono riportate le colonne della tabella EmploymentSalaries. 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
AMOUNTTYPE number Tipo di importo /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/AmountType/
AVERAGEDAYSPERWEEK number Media di giorni alla settimana /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/AverageDaysPerWeek/
AVERAGEHOURSPERWEEK number Ore medie a settimana /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/AverageHoursPerWeek/
DIVISION_CODE varchar2 ID amministrativo Numero univoco interno dell'amministrazione di Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nome dell'amministrazione 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_EMPLOYMENTTYPE number itgen_eol_employments_employment itgen_eol_employment_type /eExact/Employments/Employment/EmploymentType/
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_MAIN boolean itgen_eol_employments_employment Main /eExact/Employments/Employment/Main/
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 di salario da lavoro /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/EmploymentSalaryType/
ENDDATE date Data di fine /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/EndDate/ End date: YYYY-MM-DD
FULLTIMEAMOUNT number Importo a tempo pieno /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/FulltimeAmount/
HOURLYWAGE number Retribuzione oraria /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/HourlyWage/
INTERFACE_URL varchar2(4000) URL dell'interfaccia URL utilizzato per collegare questa riga a Exact Online.
INTERNALRATE number Tasso interno /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/InternalRate/
JOBLEVEL number Livello di lavoro /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/JobLevel/
NOTES varchar2 Notes /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/Notes/
PARTTIMEAMOUNT number Importo a tempo parziale /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/ParttimeAmount/
PARTTIMEFACTOR number Fattore a tempo parziale /eExact/Employments/Employment/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary/ParttimeFactor/
PAYROLLPERIODFREQUENCY number Frequenza del periodo di retribuzione /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 Numero di riga Numero della riga all'interno dei risultati, a partire da 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 Data di inizio /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/

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

Modifiche apportate a questa tabella, da 26.0 a 27.0

  • + EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTTYPE (number)
  • + EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_MAIN (boolean)

Tutte le sostituzioni del conducente, da 26.0 a 27.0