invantive documentation
Invantive Support ForumsLog In / Sign Up

PayrollEntriesEx: Exact Online Payroll Entries

insert update per partition XML

  • Catalog: ExactOnlineXML
  • Schema: XML
  • Label: Payroll Entries

The data in this table is partitioned per value of the Division column.

Can retrieve data and change data using insert and update.

Summary

Additional where-clause columns supported:

  • division
  • payrollyear_from
  • payrollyear_to
  • period_from
  • period_to

API Source

  • XML service: PayrollEntries
  • XML topic: PayrollEntries
  • XML path: /

Parameters

Name Data Type Required Default Documentation
division int32 Company code.
Params_PayrollYear_From int32 Payroll year (from).
Params_PayrollYear_To int32 Payroll year (through).
Params_Period_From int32 Period (from).
Params_Period_To int32 Period (through).

Table Columns

The columns of the table PayrollEntriesEx 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
CODE_ATTR varchar2 Code /eExact/PayrollEntries/PayrollEntry/code
DESCRIPTION varchar2 Description /eExact/PayrollEntries/PayrollEntry/Description/
DIVISION_CODE varchar2 Administration ID Internal unique number of the Exact Online administration.
DIVISION_HID int64 Administration Number of the Exact Online administration. Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Administration Name Name of the Exact Online administration. Not guaranteed to be unique.
EMPLOYEEHID number Employee HID /eExact/PayrollEntries/PayrollEntry/EmployeeHID/
ENTRYFIELDTYPE varchar2 Entry Field Type /eExact/PayrollEntries/PayrollEntry/EntryFieldType/
INTERFACE_URL varchar2(4000) Interface URL URL used to interface this row with Exact Online.
NOTES varchar2 Notes /eExact/PayrollEntries/PayrollEntry/Notes/
PAYROLLCOMPONENT varchar2 Payroll Component /eExact/PayrollEntries/PayrollEntry/PayrollComponent/
PAYROLLPERIOD number Payroll Period /eExact/PayrollEntries/PayrollEntry/PayrollPeriod/
PAYROLLYEAR number Payroll Year /eExact/PayrollEntries/PayrollEntry/PayrollYear/
ROWNUM int64 Row Number Number of the row within the results, starting at 1.
TYPE varchar2 Type /eExact/PayrollEntries/PayrollEntry/Type/
VALUE number Value /eExact/PayrollEntries/PayrollEntry/Value/

Release Notes

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