invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

ManufacturingTimeTransactionsEx: Exact Online Manufacturing Time Transactions

insert update per partition XML

  • Catalogue : ExactOnlineXML
  • Schéma : XML
  • Label: Manufacturing Time Transactions

Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.

Permet de récupérer et de modifier des données à l'aide de insert et update.

Résumé

Additional where-clause columns supported:

  • division
  • downloadid
  • date_from
  • date_to
  • Statut

Source de l'API

  • Service XML : ManufacturingTimeTransactions
  • Rubrique XML : ManufacturingTimeTransactions
  • Chemin XML : /

Paramètres

Name Type de données 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.

Colonnes de table

Les colonnes de la table ManufacturingTimeTransactionsEx sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
ACTIVITY varchar2 Activity /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Activity/ 10=Setup, 20=Run
DIVISION_CODE varchar2 Identifiant d'administration Numéro unique interne de l'administration d'Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nom de l'administration 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 HID (l’employé) /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/HID/
EMPLOYEE_NAME varchar2 Nom de l’employé /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/Name/
EMPLOYEE_PERSONID varchar2 Numéro d'identification de l’employé /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Employee/PersonId/
ENTRYDATE date Date d'entrée /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 de l'interface URL utilisée pour relier cette ligne à Exact Online.
ISOPERATIONFINISHED boolean L'opération est-elle terminée ? /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/IsOperationFinished/
LABORHOURS number Heures de travail /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/LaborHours/
PERCENTCOMPLETE number Pourcentage d'avancement /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 Identifiant 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 Numéro de ligne Numéro de la ligne dans les résultats, en commençant par 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 Code du centre de travail /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Workcenter/code
WORKCENTER_ID_ATTR varchar2 Workcentre ID /eExact/ManufacturingTimeTransactions/ManufacturingTimeTransaction/Workcenter/ID

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :