invantive documentation
Invantive Support ForumsLog In / Sign Up

PayrollTransactionsAll: Exact Online Payroll Transactions

read only

  • Catalog: ExactOnlineREST
  • Schema: Payroll
  • Label: Payroll Transactions

Payroll transactions across all payroll years.

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 432
Full scan rows per minute 50,300
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table PayrollTransactionsAll are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
CalculatedAmount double Calculated Amount writable Calculated amount.
CalculatedBaseValue double Calculated Base Value writable Calculated base value.
CalculatedFranchise double Calculated Franchise writable Calculated franchise.
CalculatedMaximum double Calculated Maximum writable Calculated maximum.
CalculatedNumber double Calculated Number writable Calculated number.
CostCenter varchar2 Cost Centre writable Cost center.
CostCenterCode varchar2 Cost Centre Code writable Cost center code.
CostCenterDescription varchar2 Cost Centre Description writable Cost center description.
CostUnit varchar2 Cost Unit writable Cost unit.
CostUnitCode varchar2 Cost Unit Code writable Cost unit code.
CostUnitDescription varchar2 Cost Unit Description writable Cost unit description.
Created datetime Created writable Creation date.
CreatedUtc datetime Created (UTC) writable Creation date in UTC.
Creator guid Creator writable Creator.
CreatorFullName varchar2 Creator Full Name writable Creator full name.
Date datetime Date writable Date.
Department guid Department writable Department.
DepartmentCode varchar2 Department Code writable Department code.
DepartmentDescription varchar2 Department Description writable Department description.
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Division Chamber of Commerce Number writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Division IBAN Number writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division Company Name writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Division RSIN Number writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Division VAT Number writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Division Wage Tax Number writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Division Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administration Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Subscription Holder Name writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Subscription Holder Number writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Division Short Name writable Short name of the Exact Online division.
Employee guid Employee writable Employee.
EmployeeHID int32 Employee HID writable Employee number.
Employment guid Employment filters on the platform, writable Employment.
EmploymentConditionGroup guid Employment Condition Group writable Employment condition group.
EmploymentConditionGroupCode varchar2 Employment Condition Group Code writable Employment condition group code.
EmploymentConditionGroupDescription varchar2 Employment Condition Group Description writable Employment condition group description.
EntryAmount double Entry Amount writable Entry amount.
EntryBase double Entry Base writable Entry base.
EntryNumber double Entry Number writable Entry number.
EntryPercentage double Entry Percentage writable Entry percentage.
EntryPercentage2 double Entry Percentage 2 filters on the platform Second entry percentage.
EntryType int16 Entry Type writable Entry type.
EntryTypeDescription varchar2 Entry Type Description 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 Full Name writable Name of employee.
ID guid ID writable Transaction.
ModifiedDate datetime Modified writable Last modified date.
Modifier guid Modifier writable Modifier.
ModifierFullName varchar2 Modified Full Name writable Modifier full name.
PayrollComponent guid Payroll Component filters on the platform, writable Payroll component.
PayrollComponentCode varchar2 Payroll Component Code writable Payroll component code.
PayrollComponentDescription varchar2 Payroll Component Description writable Payroll component description.
PayrollComponentType int32 Payroll Component Type writable Payroll component type.
PayrollComponentTypeDescription varchar2 Payroll Component Type Description writable Payroll component type description.
PayrollRun guid Payroll Run writable Payroll run.
PayrollRunCode varchar2 Payroll Run Code writable Payroll run code.
PayrollYear int16 Payroll Year 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 Type Description writable Transaction type description.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: