Erinevused

Siin näed erinevusi valitud versiooni ja hetkel kehtiva lehekülje vahel.

--- et:xml_direct [2026/03/26 08:37] – [Table] toomas
+++ et:xml_direct [2026/03/27 09:09] (Hetkel kehtiv) – [Kulutused (expense)] toomas
@@ Rida 108: / Rida 108: @@
 | Laotellimused(stockorder)                                  |  [[et:xml_direct#laotellimused| x  ]]   |  [[et:xml_direct#laotellimused_stockorder| x  ]]                                         |
 | Inventuurid (taking)                                       |  [[et:xml_direct#inventuurid| x  ]]     |  [[et:xml_direct#inventuurid_taking| x  ]]                                               |
+| Mahakandmised (writeoff)                                   |  [[et:xml_direct#mahakandmised| x ]]    |  [[et:xml_direct#mahakandmised_writeoff| x ]]                                            |
 | Ostutellimused (purchaseorder)                             |  [[et:xml_direct#ostutellimused| x  ]]  |  [[et:xml_direct#ostutellimused_purchaseorder| x  ]]                                     |
 | Sissetulekud (stockreceipt)                                |  [[et:xml_direct#sissetulekud| x  ]]    |  [[et:xml_direct#sissetulekud_stockreceipt| x  ]]                                        |
 | Ostuarved (purchase)                                       |  [[et:xml_direct#ostuarved| x  ]]       |  [[et:xml_direct#ostuarved_purchase| x  ]]                                               |
-| Laekumised (receipt)                                       |  [[et:xml_direct#laekumised| x  ]]      |  [[et:xml_direct#laekumised_receipt| x  ]]                                               |
+| Tootmised (production)                                     |  [[et:xml_direct#tootmised| x ]]        |  [[et:xml_direct#tootmised_production| x ]]                                              |
+| Laekumised (receipt)                                       |  [[et:xml_direct#laekumised| x  ]]      |  [[et:xml_direct#laekumised_receipts| x  ]]                                              |
+| Kulutused (expense)                                        |  [[et:xml_direct#kulutused| x ]]        |  [[et:xml_direct#kulutused_expense| x ]]                                                 |
 | Kontod (account)                                           |                                         |  [[et:xml_direct#kontod_account| x  ]]                                                   |
 | Objektid (object)                                          |  [[et:xml_direct#objektid| x ]]         |  [[et:xml_direct#objektid_object| x  ]]                                                  |
@@ Rida 529: / Rida 532: @@
 |date2|aeg2| | |
-====Lisaväljad: ====
+==Lisaväljad: ==
 ^XML väli^SQL väli^UI väli^Selgitus^
 |code|kood| | |
@@ Rida 567: / Rida 570: @@
 |project|projekt|Projekt| |
 |rn|rn|Nr|row order number in document 1 - N ,  ALT.FROM: random |
+===Kulutused ===
+what=transaction
+[[https://login.directo.ee/xmlcore/cap_xml_direct/xml_IN_kulutused.xsd|Skeem ]]
+== Päis: ==
+^XML väli^SQL väli^UI väli^Selgitus^
+|session_id|x| | for internal use at Directo side, do not send this field! |
+|number|number| | |
+|date|aeg| | |
+|expender|kulutaja| | |
+|comment|kommentaar| | |
+|datafield1|lisa_field1| | |
+|total|summakokku| | |
+|expenderidnumber|kulutaja_isikukood| | |
+|expendername|nimi| | |
+|user|kasutaja| | |
+|transactiondate|kande_aeg| | |
+|confirmer|kinnitaja| | |
+|currency|valuuta| | |
+|currencyrate|kurssbv1| | |
+|vat|kmkokku| | |
+|type|tyyp| | |
+|object|objekt| | |
+|project|projekt| | |
+|asset|inventar| | |
+|customer|klient_kood| | |
+|customername|klient_nimi| | |
+|status|staatus| | |
+|datafield2|lisa_field2| | |
+|datafield3|lisa_field3| | |
+|datafield4|lisa_field4| | |
+|datafield5|lisa_field5| | |
+|datafield6|lisa_field6| | |
+|datafield7|lisa_field7| | |
+|start|alates| | |
+|end|kuni| | |
+|country|asumaa| | |
+|city|linn| | |
+|account|konto| | |
+|startmileage|alg_nait| | |
+|endmileage|lopp_nait| | |
+|language|keel| | |
+|ordinance|korraldus| | |
+|extid|ext_id| | |
+|intcomment|sisekommentaar| | |
+|customtxtfield1|customtxtfield1| | 255; customizable field|
+|customtxtfield2|customtxtfield2| | 255; customizable field|
+|confirm|kinnita| | "1" - confirm document |
+==read: ==
+^XML väli^SQL väli^UI väli^Selgitus^
+|date|aeg| | |
+|documentnumber|dokument| | |
+|supplier|hankija_kood| | |
+|suppliername|hankija_nimi| | |
+|account|konto| | |
+|object|objekt| | |
+|project|projekt| | |
+|description|selgitus| | |
+|currency|r_valuuta| | |
+|currencyrate|r_kurss| | |
+|qty|kogus| | |
+|price|hind| | |
+|total|summa| | |
+|totalwithvat|rskm| | |
+|vatcode|kmkood| | |
+|type|tyyp| | |
+|item|artikkel| | |
+|vat|reakm| | |
+|route|marsruut| | |
+|customer|klient_kood| | |
+|customername|klient_nimi| | |
+|mileage|vahemaa| | |
+|purpose|otstarve| | |
+|sumt|summa_t| | |
+|resource|ressurss| | |
+|irn|a_rn| | |
+|start|r_aeg1| | |
+|end|r_aeg2| | |
+|customrowtxtfield1|customrowtxtfield1| | 255; customizable field|
+|customrowtxtfield2|customrowtxtfield2| | 255; customizable field|
+|customrowdecfield1|customrowdecfield1| | customizable field|
+|customrowdecfield2|customrowdecfield2| | customizable field|
+|rn|rn| | |
+== manused: ==
+^XML väli^SQL väli^UI väli^Selgitus^
+|data|attachment| |unlimited, but whole XML size limit is 19 Mb |
+|name|attachment_name| | |
+== menetlused: ==
+^XML väli^SQL väli^UI väli^Selgitus^
+|employee|kasutaja| | |
+|signature|allkiri_cu| | |
+|signaturetime|allkiri_ts| | |
+|signaturestatus|vastatud| | |
+|comment|kommentaar| | |
+|role|roll| | |
 ===Kliendid===
@@ Rida 1014: / Rida 1117: @@
 |rn|rn| | |
+===Mahakandmised ===
+what=writeoff
+[[https://login.directo.ee/xmlcore/cap_xml_direct/xml_IN_mahakandmised.xsd|Skeem ]]
+==Päis==
+^XML väli^SQL väli^UI väli^Selgitus^
+|session_id|x| | for internal use at Directo side, do not send this field! |
+|number|number|| document number/ID, mandatory; It must be unique for each document and remain same if more than one transaction of the same document is necessary |
+|date|aeg| | |
+|comment|tekst| | |
+|account|konto| | Vaikimisi Directost? Skanner ei tea|
+|object|objekt| | Vaikimisi Directost? Skanner ei tea|
+|stock|laost| | |
+|type|tyyp| | |
+|status|staatus| | |
+|project|projekt| | |
+|datafield1|lisa_field1|Lisaväli 1| |
+|datafield2|lisa_field2|Lisaväli 2| |
+|datafield3|lisa_field3|Lisaväli 3| |
+|datafield4|lisa_field4|Lisaväli 4| |
+|datafield5|lisa_field5|Lisaväli 5| |
+|datafield6|lisa_field6|Lisaväli 6| |
+|datafield7|lisa_field7|Lisaväli 7| |
+|customtxtfield1|customtxtfield1| | 255; customizable field|
+|customtxtfield2|customtxtfield2| | 255; customizable field|
+|confirm|kinnita| | "1" - confirm document |
+==read: ==
+^XML väli^SQL väli^UI väli^Selgitus^
+|item|artikkel| | |
+|name|nimetus| | |
+|qty|kogus| | |
+|price|baashind| | Peab tulema vaikimisi: Skanner ei tea |
+|comment|kommentaar| | |
+|variant|variant| | |
+|shelf|riiul|Riiul| |
+|project|projekt| | |
+|object|objekt| | |
+|stock|ladu| | |
+|account|konto| | |
+|asset|r_inventar| | |
+|customrowtxtfield1|customrowtxtfield1| | 255; customizable field|
+|customrowtxtfield2|customrowtxtfield2| | 255; customizable field|
+|customrowdecfield1|customrowdecfield1| | customizable field|
+|customrowdecfield2|customrowdecfield2| | customizable field|
+|sn|seerianumber|SN/Mudel| |
+|rn|rn| | |
 ===Liikumised===
@@ Rida 1390: / Rida 1542: @@
 | XML   | xd_confirm                | 0             | PURCHASE      | Automaatne dokumendi kinnitamine, seda saab ka juhtida XML väljaga "confirm"                                                      |
+===Tootmised ===
+what=production
+[[https://login.directo.ee/xmlcore/cap_xml_direct/xml_IN_tootmised.xsd|Skeem ]]
+==Päis ==
+^XML väli^SQL väli^UI väli^Selgitus^
+|session_id|x| | for internal use at Directo side, do not send this field! |
+|number|number|Number| document number/ID, mandatory; It must be unique for each document and remain same if more than one transaction of the same document is necessary |
+|stock|ladu|Ladu| |
+|date|aeg|Aeg| |
+|productiondate|aeg2|Toot. aeg| |
+|orderno|tellimuse_nr| | |
+|project|projekt| | |
+|customer|klient_kood| | |
+|customername|klient_nimi| | |
+|initialproduction|algne_tootmine| | |
+|name|nimetus| | |
+|recipe|juhend| | |
+|worker|tegija| | |
+|quantity|kogus| | |
+|initialquantity|alg_kogus| | |
+|delivery|lahetusaeg| | |
+|comment|kommentaar| | |
+|stockorder|laotellimuse_nr| | |
+|quotation|pakkumise_nr| | |
+|datafield1|lisa_field1| | |
+|datafield2|lisa_field2| | |
+|datafield3|lisa_field3| | |
+|datafield4|lisa_field4| | |
+|datafield5|lisa_field5| | |
+|datafield6|lisa_field6| | |
+|datafield7|lisa_field7| | |
+|account|konto| | konto |
+|bestbefore|parimenne| | parimenne |
+|priority|jarjestus| | prioriteet |
+|tolerance|viga| | tootmise nihe |
+|object|objekt| | objekt |
+|user|kasutaja| | kasutaja |
+|status|staatus|Staatus| |
+|customtxtfield1|customtxtfield1| | 255; customizable field| |
+|customtxtfield2|customtxtfield2| | 255; customizable field| |
+|confirm|kinnita| | "1" - confirm document |
+==read: ==
+^XML väli^SQL väli^UI väli^Selgitus^
+|item|artikkel| | |
+|name|nimetus| | |
+|sn|SN|SN/Mudel| |
+|totalqty|arv_kogus| | |
+|mexpense|mkulu| | |
+|inputquantity|Skogus| | |
+|outputquantity|Vkogus| | |
+|stock|ladu| | |
+|labourcost|Tkulu| | |
+|date|r_aeg| | |
+|worker|r_tegija| | |
+|normquantity|norm_kogus| | |
+|worktime|aeg_kulunud| | |
+|workcenter|tookeskus| | |
+|workercount|mitu_tegijat| | |
+|skill|oskus| | |
+|how|kuidas| | |
+|scrap|praak_kogus| | |
+|comment|kommentaar| | |
+|production|r_tootmine| | |
+|movement|liikumine| | |
+|order|jrk| | |
+|inprogress|starditud| | |
+|sales|myyk| | |
+|done|valmis| | |
+|confirmation|kinnitus| | |
+|lockworkcenter|lukusta_tookeskus| | |
+|shelf|riiul| | |
+|object|r_objekt| | |
+|startdate|aeg_algus| | |
+|semiqty|pkogus| | |
+|unit|yhikb| | |
+|semiproduct|pooltoode| | |
+|variant|variant| | |
+|bestbefore|parimenne| | parimenne |
+|points|punktid| | |
+|lockedqty|lukustub_arv_kogusena| | |
+|reciperow|retsept_rida| | |
+|text1|tekst1|| |
+|text2|tekst2|| |
+|text3|tekst3|| |
+|text4|tekst4|| |
+|constant1|konstant1|| |
+|constant2|konstant2|| |
+|constant3|konstant3|| |
+|constant4|konstant4|| |
+|customrowtxtfield1|customrowtxtfield1| | 255; customizable field| |
+|customrowtxtfield2|customrowtxtfield2| | 255; customizable field| |
+|customrowdecfield1|customrowdecfield1| | customizable field| |
+|customrowdecfield2|customrowdecfield2| | customizable field| |
+|orn|trn| | |
+|rn|rn| | |
 ===Projektid===
@@ Rida 1877: / Rida 2127: @@
   * what=receipt [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_laekumised.xsd|Skeem ]] \\ Filtrid: number,date1,date2,paymentmode,confirmed,ts
+=== Kulutused (expense) ===
+  * what=expense[[https://login.directo.ee/xmlcore/cap_xml_direct/ws_kulutused.xsd|Skeem ]] \\ Filtrid: number,date1,date2,expender,confirmed,status,ts
 === Lähetused (delivery) ===
@@ Rida 1891: / Rida 2146: @@
   * what=taking[[https://login.directo.ee/xmlcore/cap_xml_direct/ws_inventuurid.xsd|Skeem ]] \\ Filtrid: number,date1,date2,supplier,confirmed,status,ts
+=== Mahakandmised (writeoff) ===
+  * what=taking[[https://login.directo.ee/xmlcore/cap_xml_direct/ws_mahakandmised.xsd|Skeem ]] \\ Filtrid: number,status,project,stock,confirmed,ts
 === Liikumised(movement) ===
@@ Rida 1915: / Rida 2174: @@
   * what=purchase [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_oarved.xsd|Skeem ]] \\ Filtrid: number,date1,date2,supplier,confirmed,status,ts
+=== Tootmised (production) ===
+  * what=purchase [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_tootmised.xsd|Skeem ]] \\ Filtrid:number,status,confirmed,ts,productiondate