EmploymentSalaries: Exact Online Employment Salaries
insert update per partition XML
- Katalog:
ExactOnlineXML - Schema:
XML - Label: Employment Salaries
Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.
Mit insert und update können Daten abgerufen und geändert werden.
Zusammenfassung
Additional where-clause columns supported:
- division
- employeehid
API-Quelle
- XML-Dienst:
Employments - XML-Thema:
Employments - XML-Pfad:
/EmploymentCLAs/EmploymentCLA/EmploymentSalaries/EmploymentSalary
Tabellenspalten
Die Spalten der Tabelle EmploymentSalaries sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
AMOUNTTYPE |
number |
Summe Typ | / |
||
AVERAGEDAYSPERWEEK |
number |
Durchschnitt Tage pro Woche | / |
||
AVERAGEHOURSPERWEEK |
number |
Durchschnitt Stunden pro Woche | / |
||
DIVISION_ |
varchar2 |
Verwaltung ID | Interne einzigartige Nummer der Exact Online-Verwaltung. | ||
DIVISION_ |
int64 |
Administration | Number of the Exact Online administration.Not guaranteed to be unique. | ||
DIVISION_ |
varchar2 |
Verwaltung Name | Name of the Exact Online administration.Not guaranteed to be unique. | ||
EMPLOYMENTSALARIES_ |
number |
itgen_eol_employments_employment_employee Employee HID | / |
||
EMPLOYMENTSALARIES_ |
varchar2 |
itgen_eol_employments_employment Employment Contracts | / |
||
EMPLOYMENTSALARIES_ |
number |
itgen_eol_employments_employment Employment Number | / |
||
EMPLOYMENTSALARIES_ |
varchar2 |
itgen_eol_employments_employment Employment Organisations | / |
||
EMPLOYMENTSALARIES_ |
number |
itgen_eol_employments_employment itgen_eol_employment_type | / |
||
EMPLOYMENTSALARIES_ |
date |
itgen_eol_employments_employment End Date | / |
End date: YYYY-MM-DD | |
EMPLOYMENTSALARIES_ |
number |
itgen_eol_employments_employment HID | / |
||
EMPLOYMENTSALARIES_ |
boolean |
itgen_eol_employments_employment Main | / |
||
EMPLOYMENTSALARIES_ |
number |
itgen_eol_employments_employment Reason End | / |
||
EMPLOYMENTSALARIES_ |
date |
itgen_eol_employments_employment Start Date | / |
Start date: YYYY-MM-DD | |
EMPLOYMENTSALARIES_ |
date |
itgen_eol_employments_employment Start Date Organisation | / |
||
EMPLOYMENTSALARIES_ |
varchar2 |
itgen_eol_employments_employment_employment_clas_employment_cla Employment Components | / |
||
EMPLOYMENTSALARIES_ |
date |
itgen_eol_employments_employment_employment_clas_employment_cla End Date | / |
End date: YYYY-MM-DD | |
EMPLOYMENTSALARIES_ |
varchar2 |
itgen_eol_employments_employment_employment_clas_employment_cla Notes | / |
||
EMPLOYMENTSALARIES_ |
varchar2 |
itgen_eol_employments_employment_employment_clas_employment_cla_payroll_component_group Code | / |
||
EMPLOYMENTSALARIES_ |
date |
itgen_eol_employments_employment_employment_clas_employment_cla_payroll_component_group Start Date | / |
Start date: YYYY-MM-DD | |
EMPLOYMENTSALARIES_ |
date |
itgen_eol_employments_employment_employment_clas_employment_cla Start Date | / |
Start date: YYYY-MM-DD | |
EMPLOYMENTSALARYTYPE |
number |
Arbeitsverhältnis Gehaltstyp | / |
||
ENDDATE |
date |
Enddatum | / |
End date: YYYY-MM-DD | |
FULLTIMEAMOUNT |
number |
Vollzeit Summe | / |
||
HOURLYWAGE |
number |
Stundenlohn | / |
||
INTERFACE_ |
varchar2 |
Schnittstelle URL | URL, die zum Verbinden dieser Reihe mit Exact Online verwendet wird. | ||
INTERNALRATE |
number |
Interne Quote | / |
||
JOBLEVEL |
number |
Job-Level | / |
||
NOTES |
varchar2 |
Notes | / |
||
PARTTIMEAMOUNT |
number |
Teilzeitkonto | / |
||
PARTTIMEFACTOR |
number |
Teilzeitfaktor | / |
||
PAYROLLPERIODFREQUENCY |
number |
Personalabrechnung Periode Frequenz | / |
||
PAYROLLTABLE_ |
varchar2 |
itgen_eol_payroll_table Code | / |
||
PAYROLLTABLE_ |
date |
itgen_eol_payroll_table Start Date | / |
Start date: YYYY-MM-DD | |
ROWNUM |
int64 |
Zeilennummer | Nummer der Reihe innerhalb der Ergebnisse, startend bei 1. | ||
SALARYBASEDTYPE |
number |
itgen_eol_salary_based_type | / |
||
SCALE |
varchar2 |
Scale | / |
||
STARTDATE |
date |
Anfangsdatum | / |
Start date: YYYY-MM-DD | |
WAGESCALECODE |
varchar2 |
itgen_eol_wage_scale_code | / |
||
WAGESCALEPERIOD |
number |
itgen_eol_wage_scale_period | / |
||
WAGESCALESTARTDATE |
varchar2 |
itgen_eol_wage_scale_start_date | / |
||
WAGESCALESTEP |
varchar2 |
itgen_eol_wage_scale_step | / |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:
Änderungen an dieser Tabelle, 26.0 bis 27.0
+EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTTYPE(number)+EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_MAIN(boolean)