Directo abi

Kasutaja tarvikud

Lehe tööriistad


et:xml_direct

Erinevused

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

Lõlita võrdlemise vaatele

Both sides previous revisionPrevious revision
Next revision		Previous revision
et:xml_direct [2026/03/26 08:36] – [Laekumised] toomaset: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  ]]                                         | | 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  ]]                                               | | 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  ]]                                     | | 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  ]]                                        | | 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  ]]                                               | | 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  ]]                                                   | | Kontod (account)                                           |                                         |  [[et:xml_direct#kontod_account| x  ]]                                                   |
-| Objektid (object)                                          |                                         |  [[et:xml_direct#objektid_object| x  ]]                                                  |+| Objektid (object)                                          |  [[et:xml_direct#objektid| x ]]         |  [[et:xml_direct#objektid_object| x  ]]                                                  |
 | Finantskanded (transaction)                                |  [[et:xml_direct#kanded| x  ]]          |  [[et:xml_direct#finantskanded_transactions_ja_finantskande_read_transactionrows| x  ]]  | | Finantskanded (transaction)                                |  [[et:xml_direct#kanded| x  ]]          |  [[et:xml_direct#finantskanded_transactions_ja_finantskande_read_transactionrows| x  ]]  |
 | Finantskanderead (transactionrow)                          |                                         |  [[et:xml_direct#finantskanded_transactions_ja_finantskande_read_transactionrows| x  ]]  | | Finantskanderead (transactionrow)                          |                                         |  [[et:xml_direct#finantskanded_transactions_ja_finantskande_read_transactionrows| x  ]]  |
Rida 529: Rida 532:
 |date2|aeg2| | | |date2|aeg2| | |
  
-====Lisaväljad: ====+==Lisaväljad: ==
 ^XML väli^SQL väli^UI väli^Selgitus^ ^XML väli^SQL väli^UI väli^Selgitus^
 |code|kood| | | |code|kood| | |
Rida 567: Rida 570:
 |project|projekt|Projekt| | |project|projekt|Projekt| |
 |rn|rn|Nr|row order number in document 1 - N ,  ALT.FROM: random | |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=== ===Kliendid===
Rida 1014: Rida 1117:
 |rn|rn| | | |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=== ===Liikumised===
Rida 1390: Rida 1542:
 | XML   | xd_confirm                | 0             | PURCHASE      | Automaatne dokumendi kinnitamine, seda saab ka juhtida XML väljaga "confirm"                                                      | | 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=== ===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   * 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) === === 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   * 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) === === 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   * 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
  
  
et/xml_direct.1774506978.txt.gz · Viimati muutnud: 2026/03/26 08:36 persoon toomas
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki