invantive documentation
Forum di supporto InvantiveAccedi / Registrati

ManufacturingTimeTransactionsEx: Exact Online Manufacturing Time Transactions

insert update per partition XML

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

I dati in questa tabella sono partizionati per valore della colonna Division.

È possibile recuperare e modificare i dati utilizzando insert e update.

Additional where-clause columns supported:

  • division
  • downloadid
  • date_from
  • date_to
  • stato

Codice sorgente dell'API

  • Servizio XML: ManufacturingTimeTransactions
  • Argomento XML: ManufacturingTimeTransactions
  • Percorso XML: /

Parametri

Name Tipo di dati Required Default Documentation
division int32 Company code.
Params_Date_From date Date (from).
Params_Date_To date Date (through).
Params_DownloadID varchar2 Data subscription token.
Params_Status varchar2 Multi-select; 1: draft, 2: rejected, -1: submitted, -2: contains errors, -3: approved.

Colonne della tabella

Di seguito sono riportate le colonne della tabella ManufacturingTimeTransactionsEx. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
ACTIVITY varchar2 Activity /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Activity/ 10=Setup, 20=Run
DIVISION_CODE varchar2 ID amministrativo Numero univoco interno dell'amministrazione di Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nome dell'amministrazione 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 Dipendente HID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/HID/
EMPLOYEE_NAME varchar2 Nome del dipendente /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/Name/
EMPLOYEE_PERSONID varchar2 ID persona dipendente /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/PersonId/
ENTRYDATE date Data di ingresso /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) URL dell'interfaccia URL utilizzato per collegare questa riga a Exact Online.
ISOPERATIONFINISHED boolean L'operazione è terminata? /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/IsOperationFinished/
LABORHOURS number Ore di lavoro /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/LaborHours/
PERCENTCOMPLETE number Percentuale di completamento /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 ID itgen_eol_routing_step_plan_supplier /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 Numero di riga Numero della riga all'interno dei risultati, a partire da 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 Codice del centro di lavoro /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Workcenter/code
WORKCENTER_ID_ATTR varchar2 Workcentre ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Workcenter/ID

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: