invantive documentation
Invantive Support ForumsLog In / Sign Up

TimeTransactionsExtended: Exact Online Time Transactions Extended

read only per partition XML

  • Catalog: ExactOnlineXML
  • Schema: XML
  • Primary Keys: number_attr
  • Label: Time Transactions Extended

Time Transactions Extended

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

Can only retrieve data.

Summary

Time transactions extended by various characteristics of the employee.

Additional where-clause columns supported:

  • division

Example

The time transaction of Joe yesterday was on the department Sales.

API Source

  • XML topic: TimeTransactionsExtended

Performance Characteristics

Characteristic Value
Estimated rows 5,000
Estimated size (bytes) 0

The result can be cached on the client.

Table Columns

The columns of the table TimeTransactionsExtended 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
ACCOUNT_CODE_ATTR varchar2 Account Code /eExact/TimeTransactions/TimeTransaction/Account/code
COSTCENTER_CODE_ATTR varchar2 Cost Centre Code /eExact/Employments/Employment/EmploymentOrganizations/EmploymentOrganization/Costcenter/code
DATE date Date /eExact/TimeTransactions/TimeTransaction/Date/ YYYY-MM-DD
DEPARTMENT_CODE_ATTR varchar2 Department Code /eExact/Employments/Employment/EmploymentOrganizations/EmploymentOrganization/Department/code
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.
EMPLOYEE_EMPLOYEEHID_ATTR number Employee Employee HID /eExact/TimeTransactions/TimeTransaction/Employee/EmployeeHID
INTERFACE_URL varchar2(4000) Interface URL URL used to interface this row with Exact Online.
JOBTITLE_CODE_ATTR varchar2 Job Title Code /eExact/Employments/Employment/EmploymentOrganizations/EmploymentOrganization/JobTitle/code
JOBTITLE_JOBGROUP_CODE_ATTR varchar2 Job Title Job Group Code /eExact/Employments/Employment/EmploymentOrganizations/EmploymentOrganization/JobTitle/JobGroup/code
NUMBER_ATTR number Number /eExact/TimeTransactions/TimeTransaction/number Unique number indentifying the entry
PRICE_CURRENCY_CODE_ATTR varchar2 Price Currency Code /eExact/TimeTransactions/TimeTransaction/Price/Currency/code
PRICE_TOTAL_VALUE number Total Value
PRICE_VALUE number Price Value /eExact/TimeTransactions/TimeTransaction/Price/Value/
PROJECT_CODE_ATTR varchar2 Project Code /eExact/TimeTransactions/TimeTransaction/Project/code Unique number indentifying the entry
PROJECT_DESCRIPTION varchar2 Project Description /eExact/TimeTransactions/TimeTransaction/Project/Description/
PROJECT_TYPE_ATTR varchar2 Project Type /eExact/TimeTransactions/TimeTransaction/Project/type 1=Campaign, 2=Fixed price, 3=Time and Material, 4=Non billable, 5=Prepaid
PROJECT_TYPE_DESCRIPTION varchar2 Project Type Description
QUANTITY number Quantity /eExact/TimeTransactions/TimeTransaction/Quantity/
ROWNUM int64 Row Number Number of the row within the results, starting at 1.
STATUS_ATTR number Status /eExact/TimeTransactions/TimeTransaction/status Status codes for import: 1=Draft, 10=Submitted (only applicable if administration setting 'Approve: entries' is enabled). Status codes for export: 1=Draft, -1=Submitted, 2=Rejected, -2=Contains errors, -3=Approved.

Release Notes

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