ProjectPlanningLinesExtended: Exact Online Project Planning Lines Extended
read only per partition XML
- Catalog:
ExactOnlineXML - Schema:
XML - Label: Project Planning Lines Extended
Project Planning Lines Extended
The data in this table is partitioned per value of the Division column.
Can only retrieve data.
Summary
Time project planning lines extended by various characteristics of the employee.
Additional where-clause columns supported:
- division
Example
The project planning of Joe yesterday was on the department Sales.
API Source
- XML topic:
ProjectPlanningLinesExtended
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 ProjectPlanningLinesExtended 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_ |
varchar2 |
Account Code | / |
||
ACCOUNT_ |
varchar2 |
Account Name | / |
||
COSTCENTER_ |
varchar2 |
Cost Centre Code | / |
||
DEPARTMENT_ |
varchar2 |
Department Code | / |
||
DESCRIPTION |
varchar2 |
Description | / |
||
DIVISION_ |
varchar2 |
Administration ID | Internal unique number of the Exact Online administration. | ||
DIVISION_ |
int64 |
Administration | Number of the Exact Online administration. Not guaranteed to be unique. | ||
DIVISION_ |
varchar2 |
Administration Name | Name of the Exact Online administration. Not guaranteed to be unique. | ||
EMPLOYEE_ |
number |
Employee Employee HID | / |
||
ENDDATE |
date |
End Date | / |
||
INTERFACE_ |
varchar2 |
Interface URL | URL used to interface this row with Exact Online. | ||
ITEM_ |
varchar2 |
Item Code | / |
||
ITEM_ |
varchar2 |
Item Description | / |
||
JOBTITLE_ |
varchar2 |
Job Title Code | / |
||
JOBTITLE_ |
varchar2 |
Job Title Job Group Code | / |
||
OVERALLOCATE |
boolean |
Over Allocate | / |
||
PROJECT_ |
varchar2 |
Project Code | / |
Unique number indentifying the entry | |
QUANTITY |
number |
Quantity | / |
||
ROWNUM |
int64 |
Row Number | Number of the row within the results, starting at 1. | ||
STARTDATE |
date |
Start Date | / |
||
STATUS_ |
number |
Status | / |
1:Reservation, 2:Planning |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: