PayrollTransactionsAll: Exact Online Payroll Transactions
read only
- Katalog:
ExactOnlineREST - Schema:
Payroll - Label: Payroll Transactions
Payroll transactions across all payroll years.
Es können nur Daten abgerufen werden.
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 432 |
| Anzahl der Vollscan-Zeilen pro Minute | 50,300 |
| Anzahl der Query-Zeilen pro Minute | 138 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Tabellenspalten
Die Spalten der Tabelle PayrollTransactionsAll 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 |
|---|---|---|---|---|---|
Calculated |
double |
Berechneter Betrag | writable | Calculated amount. | |
Calculated |
double |
Berechneter Basiswert | writable | Calculated base value. | |
Calculated |
double |
Berechnete Franchise | writable | Calculated franchise. | |
Calculated |
double |
Berechnetes Maximum | writable | Calculated maximum. | |
Calculated |
double |
Berechnete Zahl | writable | Calculated number. | |
Cost |
varchar2 |
Kostenstelle | writable | Cost center. | |
Cost |
varchar2 |
Kostenstelle-Code | writable | Cost center code. | |
Cost |
varchar2 |
Kostenstelle Beschreibung | writable | Cost center description. | |
Cost |
varchar2 |
Kostenträger | writable | Cost unit. | |
Cost |
varchar2 |
Kostenträgercode | writable | Cost unit code. | |
Cost |
varchar2 |
Kostenträgerbeschreibung | writable | Cost unit description. | |
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Angelegt | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | Creator. | |
Creator |
varchar2 |
Ersteller vollständiger Name | writable | Creator full name. | |
Date |
datetime |
Date | writable | Date. | |
Department |
guid |
Department | writable | Department. | |
Department |
varchar2 |
Abteilungscode | writable | Department code. | |
Department |
varchar2 |
Beschreibung der Abteilung | writable | Department description. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Nummer der Handelskammer des Bezirks | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Abteilung IBAN-Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Geschäftsbereich Firmenname | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Abteilung RSIN-Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Umsatzsteuer-Identifikationsnummer der Abteilung | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Nummer der Lohnsteuerabteilung | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Abteilungsbezeichnung | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Verwaltung Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Name des Abonnenten | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnentennummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Kurzbezeichnung der Abteilung | writable | Short name of the Exact Online division. | |
Employee |
guid |
Employee | writable | Employee. | |
Employee |
int32 |
Mitarbeiter HID | writable | Employee number. | |
Employment |
guid |
Employment | filters on the platform, writable | Employment. | |
Employment |
guid |
Gruppe der Beschäftigungsbedingungen | writable | Employment condition group. | |
Employment |
varchar2 |
Code für die Beschäftigungsbedingungengruppe | writable | Employment condition group code. | |
Employment |
varchar2 |
Beschreibung der Beschäftigungsbedingungen-Gruppe | writable | Employment condition group description. | |
Entry |
double |
Einzahlungsbetrag | writable | Entry amount. | |
Entry |
double |
Einstiegsbasis | writable | Entry base. | |
Entry |
double |
Eingabe Nummer | writable | Entry number. | |
Entry |
double |
Anteil der Einträge | writable | Entry percentage. | |
Entry |
double |
Einstiegsprozentsatz 2 | Filter auf der Plattform | Second entry percentage. | |
Entry |
int16 |
Eintragstyp | writable | Entry type. | |
Entry |
varchar2 |
Eintragstyp Beschreibung | 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 |
Vollständiger Name | writable | Name of employee. | |
ID |
guid |
ID | writable | Transaction. | |
Modified |
datetime |
Modified | writable | Last modified date. | |
Modifier |
guid |
Modifier | writable | Modifier. | |
Modifier |
varchar2 |
Geänderter vollständiger Name | writable | Modifier full name. | |
Payroll |
guid |
Personalabrechnung | filters on the platform, writable | Payroll component. | |
Payroll |
varchar2 |
Lohn- und Gehaltskomponentencode | writable | Payroll component code. | |
Payroll |
varchar2 |
Beschreibung der Lohn- und Gehaltskomponente | writable | Payroll component description. | |
Payroll |
int32 |
Art der Abrechnungskomponente | writable | Payroll component type. | |
Payroll |
varchar2 |
Art der Abrechnungskomponente – Beschreibung | writable | Payroll component type description. | |
Payroll |
guid |
Lohn- und Gehaltsabrechnung | writable | Payroll run. | |
Payroll |
varchar2 |
Abrechnungslauf-Code | writable | Payroll run code. | |
Payroll |
int16 |
Gehaltsliste Jahr | 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 |
Typ Beschreibung | writable | Transaction type description. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: