invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

PayrollTransactionsAll: Exact Online Payroll Transactions

read only

  • Catalogus: ExactOnlineREST
  • Schema: Payroll
  • Label: Payroll Transactions

Payroll transactions across all payroll years.

Kan alleen gegevens ophalen.

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 432
Aantal rijen per minuut bij volledige scan 50,300
Aantal rijen per minuut in een Query 138

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel PayrollTransactionsAll 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.

Name Datatype Label Required Marks Documentation
CalculatedAmount double Berekend Bedrag writable Calculated amount.
CalculatedBaseValue double Berekende Basiswaarde writable Calculated base value.
CalculatedFranchise double Berekende Franchise writable Calculated franchise.
CalculatedMaximum double Berekend Maximum writable Calculated maximum.
CalculatedNumber double Berekend Nummer writable Calculated number.
CostCenter varchar2 Kostenplaats writable Cost center.
CostCenterCode varchar2 Kostenplaatscode writable Cost center code.
CostCenterDescription varchar2 Kostenplaats Omschrijving writable Cost center description.
CostUnit varchar2 Kostendrager writable Cost unit.
CostUnitCode varchar2 Kostendragercode writable Cost unit code.
CostUnitDescription varchar2 Kostendrager Omschrijving writable Cost unit description.
Created datetime Created writable Creation date.
CreatedUtc datetime Aangemaakt (UTC) writable Creation date in UTC.
Creator guid Creator writable Creator.
CreatorFullName varchar2 Aanmaker Volledige Naam writable Creator full name.
Date datetime Date writable Date.
Department guid Department writable Department.
DepartmentCode varchar2 Afdelingscode writable Department code.
DepartmentDescription varchar2 Afdelingsomschrijving writable Department description.
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Divisie Kamer van Koophandel Nummer writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Divisie IBAN Nummer writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisie Bedrijfsnaam writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Divisie RSIN Nummer writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Divisie BTW Nummer writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Divisie Loonbelastingnummer writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Divisie Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administratie Naam writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Naam Abonnementhouder writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Abonnementhoudernummer writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Divisie Korte Naam writable Short name of the Exact Online division.
Employee guid Employee writable Employee.
EmployeeHID int32 Medewerker HID writable Employee number.
Employment guid Employment filters on the platform, writable Employment.
EmploymentConditionGroup guid Arbeidsvoorwaardegroep writable Employment condition group.
EmploymentConditionGroupCode varchar2 Arbeidsvoorwaardegroepcode writable Employment condition group code.
EmploymentConditionGroupDescription varchar2 Arbeidsvoorwaardegroepomschrijving writable Employment condition group description.
EntryAmount double Boekstukbedrag writable Entry amount.
EntryBase double Boekingsbasis writable Entry base.
EntryNumber double Boekingnummer writable Entry number.
EntryPercentage double Invoerpercentage writable Entry percentage.
EntryPercentage2 double Instappercentage 2 filters op het platform Second entry percentage.
EntryType int16 Boekstuksoort writable Entry type.
EntryTypeDescription varchar2 Boekstuksoort Omschrijving 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).
FullName varchar2 Volledige Naam writable Name of employee.
ID guid ID writable Transaction.
ModifiedDate datetime Modified writable Last modified date.
Modifier guid Modifier writable Modifier.
ModifierFullName varchar2 Gewijzigd Volledige Naam writable Modifier full name.
PayrollComponent guid Salaris Component filters on the platform, writable Payroll component.
PayrollComponentCode varchar2 Salariscomponentcode writable Payroll component code.
PayrollComponentDescription varchar2 Looncomponentomschrijving writable Payroll component description.
PayrollComponentType int32 Salariscomponentsoort writable Payroll component type.
PayrollComponentTypeDescription varchar2 Salariscomponentsoortomschrijving writable Payroll component type description.
PayrollRun guid Salarisrun writable Payroll run.
PayrollRunCode varchar2 Salarisruncode writable Payroll run code.
PayrollYear int16 Loonjaar 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.
TypeDescription varchar2 Soort Omschrijving writable Transaction type description.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: