EmploymentSalaries: Exact Online Dienstverband Salarissen |
Catalogus: ExactOnlineXML
Schema: XML
Label: Dienstverband Salarissen
Documentatie:
Ondersteunde extra where-clause kolommen:
- division
- employeehid
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Ophalen: true
Invoegen: true
Bijwerken: true
Verwijderen: false
Filters op API-server: division- employeehid
View Kolommen
De kolommen van de view EmploymentSalaries worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
AMOUNTTYPE |
int64 |
Soort Bedrag |
|
|
AVERAGEDAYSPERWEEK |
decimal |
Gemiddeld Dagen per Week |
|
|
AVERAGEHOURSPERWEEK |
decimal |
Gemiddeld Uren per Week |
|
|
DIVISION_CODE |
string |
Administratie ID |
☑ |
Intern uniek nummer van de Exact Online administratie. |
DIVISION_HID |
int64 |
Administratie |
☑ |
Nummer van de Exact Online administratie. Niet gegarandeerd uniek. |
DIVISION_NAME |
string(240) |
Administratie Naam |
☑ |
Naam van de Exact Online administratie. Niet gegarandeerd uniek. |
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYEE_EMPLOYEEHID_ATTR |
int64 |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTCONTRACTS |
string |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTNUMBER_ATTR |
int64 |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTORGANIZATIONS |
string |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_ENDDATE |
datetime |
|
|
End date: YYYY-MM-DD |
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_HID_ATTR |
int64 |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_REASONEND |
int64 |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_STARTDATE |
datetime |
|
|
Start date: YYYY-MM-DD |
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_STARTDATEORGANIZATION |
datetime |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCOMPONENTS |
string |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_ENDDATE |
datetime |
|
|
End date: YYYY-MM-DD |
EMPLOYMENTSALARIES_EMPLOYMENTCLA_NOTES |
string |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_PAYROLLCOMPONENTGROUP_CODE_ATTR |
string |
|
|
|
EMPLOYMENTSALARIES_EMPLOYMENTCLA_PAYROLLCOMPONENTGROUP_STARTDATE |
datetime |
|
|
Start date: YYYY-MM-DD |
EMPLOYMENTSALARIES_EMPLOYMENTCLA_STARTDATE |
datetime |
|
|
Start date: YYYY-MM-DD |
EMPLOYMENTSALARYTYPE |
int64 |
Dienstverband Salarissoort |
|
|
ENDDATE |
datetime |
Einddatum |
|
End date: YYYY-MM-DD |
FULLTIMEAMOUNT |
decimal |
Fulltime Bedrag |
|
|
HOURLYWAGE |
decimal |
Uurloon |
|
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
URL gebruikt om deze rij uit te wisselen met Exact Online. |
INTERNALRATE |
decimal |
Intern Tarief |
|
|
JOBLEVEL |
int64 |
Job Niveau |
|
|
NOTES |
string |
Notities |
|
|
PARTTIMEAMOUNT |
decimal |
Parttime Bedrag |
|
|
PARTTIMEFACTOR |
decimal |
Parttime Factor |
|
|
PAYROLLPERIODFREQUENCY |
int64 |
Salarisboekingfrequentie |
|
|
PAYROLLTABLE_CODE_ATTR |
string |
|
|
|
PAYROLLTABLE_STARTDATE |
datetime |
|
|
Start date: YYYY-MM-DD |
ROWNUM |
int64 |
Rijnummer |
☑ |
Nummer van de regel binnen de resultaten, te beginnen bij 1. |
SALARYBASEDTYPE |
int64 |
|
|
|
SCALE |
string |
Nauwkeurigheid |
|
|
STARTDATE |
datetime |
Startdatum |
|
Start date: YYYY-MM-DD |
WAGESCALECODE |
string |
|
|
|
WAGESCALEPERIOD |
int16 |
|
|
|
WAGESCALESTARTDATE |
string |
|
|
|
WAGESCALESTEP |
string |
|
|
|
30-05-2024 10:44 Versie 24.1.3-BETA+4689