# ProjectPlanningLinesExtended: Exact Online Project Planning Lines Extended Project Planning Lines Extended ## Documentation: Time project planning lines extended by various characteristics of the employee.chr(13) || chr(10) || chr(13) || chr(10)chr(13) || chr(10) || chr(13) || chr(10)Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- division - Catalog: `ExactOnlineXML` - Schema: `XML` - Alias: `ppd` - Label: Project Planning Lines Extended Example: The project planning of Joe yesterday was on the department Sales. The data in this table is partitioned per value of the `Division` column. This is a read-only view. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. - Filters on API Server: division ## View Columns The columns of the view `ProjectPlanningLinesExtended` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCOUNT_CODE_ATTR` | `varchar2` | Account Code | | | | `ACCOUNT_NAME` | `varchar2` | Account Name | | | | `COSTCENTER_CODE_ATTR` | `varchar2` | Cost Centre Code | | | | `DEPARTMENT_CODE_ATTR` | `varchar2` | Department Code | | | | `DESCRIPTION` | `varchar2` | 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 | ☑ | | | `ENDDATE` | `date` | End Date | | | | `INTERFACE_URL` | `varchar2`(4000) | Interface URL | ☑ | URL used to interface this row with Exact Online. | | `ITEM_CODE_ATTR` | `varchar2` | Item Code | | | | `ITEM_DESCRIPTION` | `varchar2`(255) | Item Description | | | | `JOBTITLE_CODE_ATTR` | `varchar2` | Job Title Code | | | | `JOBTITLE_JOBGROUP_CODE_ATTR` | `varchar2` | Job Title Job Group Code | | | | `OVERALLOCATE` | `boolean` | Over Allocate | | | | `PROJECT_CODE_ATTR` | `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_ATTR` | `number` | Status | ☑ | 1:Reservation, 2:Planning |