invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

ManufacturingTimeTransactions: Exact Online Manufacturing Time Transactions

insert update per partition XML

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

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.

Je kunt gegevens ophalen en wijzigen met insert en update.

Samenvatting

Additional where-clause columns supported:

  • division
  • downloadid
  • date_from
  • date_to
  • status

API-bron

  • XML-service: ManufacturingTimeTransactions
  • XML-onderwerp: ManufacturingTimeTransactions
  • XML-pad: /

Tabelkolommen

De kolommen van de tabel ManufacturingTimeTransactions worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
ACTIVITY varchar2 Activity /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Activity/ 10=Setup, 20=Run
DIVISION_CODE varchar2 Administratie ID Intern uniek nummer van de Exact Online administratie.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Administratie Naam 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 Medewerker HID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/HID/
EMPLOYEE_NAME varchar2 Naam Werknemer /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/Name/
EMPLOYEE_PERSONID varchar2 Werknemer Persoon ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/PersonId/
ENTRYDATE date Boekdatum /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 gebruikt om deze rij uit te wisselen met Exact Online.
ISOPERATIONFINISHED boolean Is Bewerking Voltooid? /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/IsOperationFinished/
LABORHOURS number Werkuren /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/LaborHours/
PERCENTCOMPLETE number Percentage Voltooid /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 Rijnummer Nummer van de regel binnen de resultaten, te beginnen bij 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 Workcentercode /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Workcenter/code
WORKCENTER_ID_ATTR varchar2 Workcentre ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Workcenter/ID

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: