invantive documentation
Invantive Support ForumsLog In / Sign Up

ManufacturingTimeTransactions: Exact Online Manufacturing Time Transactions

insert update per partition XML

  • Catalog: ExactOnlineXML
  • Schema: XML
  • Label: Manufacturing Time Transactions

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

Can retrieve data and change data using insert and update.

Summary

Additional where-clause columns supported:

  • division
  • downloadid
  • date_from
  • date_to
  • status

API Source

  • XML service: ManufacturingTimeTransactions
  • XML topic: ManufacturingTimeTransactions
  • XML path: /

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 Marks Documentation
ACTIVITY varchar2 Activity /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/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 /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/EmployeeId/
EMPLOYEE_HID varchar2 Employee HID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/HID/
EMPLOYEE_NAME varchar2 Employee Name /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/Name/
EMPLOYEE_PERSONID varchar2 Employee Person ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/PersonId/
ENTRYDATE date Entry Date /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/EntryDate/ YYYY-MM-DD
HOURS number Hours /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Hours/
ID_ATTR varchar2 ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/ID
INTERFACE_URL varchar2(4000) Interface URL URL used to interface this row with Exact Online.
ISOPERATIONFINISHED boolean Is Operation Finished? /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/IsOperationFinished/
LABORHOURS number Labor Hours /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/LaborHours/
PERCENTCOMPLETE number Percent Complete /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/PercentComplete/ The percentage as a number from -1 to 1, for example 0.19 = 19%
QUANTITY number Quantity /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Quantity/
ROUTINGSTEPPLAN_ID_ATTR varchar2 Routing Step Plan ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/RoutingStepPlan/ID
ROUTINGSTEPPLAN_LINENUMBER_ATTR number Routing Step Plan Line Number /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/RoutingStepPlan/linenumber
ROUTINGSTEPPLAN_OPERATION_CODE_ATTR varchar2 Routing Step Plan Operation Code /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/RoutingStepPlan/Operation/code
ROUTINGSTEPPLAN_OPERATION_ID_ATTR varchar2 Routing Step Plan Operation ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/RoutingStepPlan/Operation/ID
ROUTINGSTEPPLAN_SUPPLIER_CODE_ATTR varchar2 itgen_eol_routing_step_plan_supplier Code /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/RoutingStepPlan/Supplier/code
ROUTINGSTEPPLAN_SUPPLIER_ID_ATTR varchar2 itgen_eol_routing_step_plan_supplier ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/RoutingStepPlan/Supplier/ID
ROUTINGSTEPPLAN_SUPPLIER_NAME_ATTR varchar2 itgen_eol_routing_step_plan_supplier Name /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/RoutingStepPlan/Supplier/name
ROUTINGSTEPPLAN_WORKCENTER_CODE_ATTR varchar2 Routing Step plan Workcentre Code /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/RoutingStepPlan/Workcenter/code
ROUTINGSTEPPLAN_WORKCENTER_ID_ATTR varchar2 Routing Step plan Workcentre ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/RoutingStepPlan/Workcenter/ID
ROWNUM int64 Row Number Number of the row within the results, starting at 1.
SHOPORDER_ID_ATTR varchar2 Shop Orders ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/ShopOrder/ID
SHOPORDER_NUMBER_ATTR number Shop Orders Number /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/ShopOrder/number
STATUS number Status /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/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 /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Workcenter/code
WORKCENTER_ID_ATTR varchar2 Workcentre ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Workcenter/ID

Release Notes

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