invantive documentation
Invantive Support ForumsLog In / Sign Up

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_CODE_ATTR varchar2 Account Code /eExact/ProjectPlanning/ProjectPlanningLine/Account/code
ACCOUNT_NAME varchar2 Account Name /eExact/ProjectPlanning/ProjectPlanningLine/Account/Name/
COSTCENTER_CODE_ATTR varchar2 Cost Centre Code /eExact/Employments/Employment/EmploymentOrganizations/EmploymentOrganization/Costcenter/code
DEPARTMENT_CODE_ATTR varchar2 Department Code /eExact/Employments/Employment/EmploymentOrganizations/EmploymentOrganization/Department/code
DESCRIPTION varchar2 Description /eExact/ProjectPlanning/ProjectPlanningLine/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.
EMPLOYEE_EMPLOYEEHID_ATTR number Employee Employee HID /eExact/ProjectPlanning/ProjectPlanningLine/Employee/EmployeeHID
ENDDATE date End Date /eExact/ProjectPlanning/ProjectPlanningLine/EndDate/
INTERFACE_URL varchar2(4000) Interface URL URL used to interface this row with Exact Online.
ITEM_CODE_ATTR varchar2 Item Code /eExact/ProjectPlanning/ProjectPlanningLine/Item/code
ITEM_DESCRIPTION varchar2(255) Item Description /eExact/ProjectPlanning/ProjectPlanningLine/Item/Description/
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
OVERALLOCATE boolean Over Allocate /eExact/ProjectPlanning/ProjectPlanningLine/OverAllocate/
PROJECT_CODE_ATTR varchar2 Project Code /eExact/ProjectPlanning/ProjectPlanningLine/Project/code Unique number indentifying the entry
QUANTITY number Quantity /eExact/ProjectPlanning/ProjectPlanningLine/Quantity/
ROWNUM int64 Row Number Number of the row within the results, starting at 1.
STARTDATE date Start Date /eExact/ProjectPlanning/ProjectPlanningLine/StartDate/
STATUS_ATTR number Status /eExact/ProjectPlanning/ProjectPlanningLine/status 1:Reservation, 2:Planning

Release Notes

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