# ManufacturingTimeTransactions: Exact Online Manufacturing Time Transactions ## Documentation: Additional where-clause columns supported:chr(13) || chr(10) || chr(13) || chr(10)- divisionchr(13) || chr(10) || chr(13) || chr(10)- downloadidchr(13) || chr(10) || chr(13) || chr(10)- date_fromchr(13) || chr(10) || chr(13) || chr(10)- date_tochr(13) || chr(10) || chr(13) || chr(10)- status - Catalog: `ExactOnlineXML` - Schema: `XML` - Label: Manufacturing Time Transactions The data in this table is partitioned per value of the `Division` column. - Retrieve: True - Insert: True - Update: True - Delete: False - Filters on API Server: division - downloadid - date_from - date_to - status ## Table Columns The columns of the table `ManufacturingTimeTransactions` 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 | Documentation | |---|:---:|---|:---:|---| | `ACTIVITY` | `varchar2` | Activity | | 10=Setup, 20=Run | | `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_EMPLOYEEID` | `varchar2` | Employee Employee ID | | | | `EMPLOYEE_HID` | `varchar2` | Employee HID | | | | `EMPLOYEE_NAME` | `varchar2` | Employee Name | | | | `EMPLOYEE_PERSONID` | `varchar2` | Employee Person ID | | | | `ENTRYDATE` | `date` | Entry Date | | YYYY-MM-DD | | `HOURS` | `number` | Hours | | | | `ID_ATTR` | `varchar2` | ID | | | | `INTERFACE_URL` | `varchar2`(4000) | Interface URL | ☑ | URL used to interface this row with Exact Online. | | `ISOPERATIONFINISHED` | `boolean` | Is Operation Finished? | | | | `LABORHOURS` | `number` | Labor Hours | | | | `PERCENTCOMPLETE` | `number` | Percent Complete | | The percentage as a number from -1 to 1, for example 0.19 = 19% | | `QUANTITY` | `number` | Quantity | | | | `ROUTINGSTEPPLAN_ID_ATTR` | `varchar2` | Routing Step Plan ID | | | | `ROUTINGSTEPPLAN_LINENUMBER_ATTR` | `number` | Routing Step Plan Line Number | | | | `ROUTINGSTEPPLAN_OPERATION_CODE_ATTR` | `varchar2` | Routing Step Plan Operation Code | | | | `ROUTINGSTEPPLAN_OPERATION_ID_ATTR` | `varchar2` | Routing Step Plan Operation ID | | | | `ROUTINGSTEPPLAN_SUPPLIER_CODE_ATTR` | `varchar2` | | | | | `ROUTINGSTEPPLAN_SUPPLIER_ID_ATTR` | `varchar2` | | | | | `ROUTINGSTEPPLAN_SUPPLIER_NAME_ATTR` | `varchar2` | | | | | `ROUTINGSTEPPLAN_WORKCENTER_CODE_ATTR` | `varchar2` | Routing Step plan Workcentre Code | | | | `ROUTINGSTEPPLAN_WORKCENTER_ID_ATTR` | `varchar2` | Routing Step plan Workcentre ID | | | | `ROWNUM` | `int64` | Row Number | ☑ | Number of the row within the results, starting at 1. | | `SHOPORDER_ID_ATTR` | `varchar2` | Shop Orders ID | | | | `SHOPORDER_NUMBER_ATTR` | `number` | Shop Orders Number | | | | `STATUS` | `number` | Status | | 1=Draft, 2=Rejected, 10=Submitted, 11=Failed on approval, 14=Waiting to be approved, 16=Waiting to be unapproved, 19=Failed on unapproval, 20=Final. Only status 1 (Draft) and 10 (Submitted) are available for import, but status 10 (Submitted) can only be used when the administration setting 'Approve: entries' is checked. | | `WORKCENTER_CODE_ATTR` | `varchar2` | Workcentre Code | | | | `WORKCENTER_ID_ATTR` | `varchar2` | Workcentre ID | | |