et:xml_direct
Erinevused
Siin näed erinevusi valitud versiooni ja hetkel kehtiva lehekülje vahel.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| et:xml_direct [2026/04/30 08:40] – [Table] toomas | et:xml_direct [2026/06/25 14:40] (Hetkel kehtiv) – toomas | ||
|---|---|---|---|
| Rida 1: | Rida 1: | ||
| - | ======XML Direct ====== | + | {{page> |
| - | =====Tutvustus ===== | + | |
| - | XML Direct on standardiseeritud liides, mis töötab ühispöördumispunkti kaudu ning koosneb komponentidest, | + | |
| - | + | ||
| - | Kõigi komponentide väljad on fikseeritud ehk „lukus“ – see tähendab, et andmevorming ja struktuur on ühtsed kõigis Directo kliendibaasides. Arendused tehakse jagatud lahenduse põhimõttel ja liidese aktiveerimine ei vaja Directo-poolset kohandamist. | + | |
| - | + | ||
| - | Liides võimaldab luua mitu erinevat API võtit, et pakkuda turvalist ligipääsu mitmele partnerile. Igal API võtmel võib olla ligipääs ainult valitud komponentidele, | + | |
| - | + | ||
| - | Enne kasutuselevõttu tuleb kokku leppida, millised komponendid on vajalikud. | + | |
| - | + | ||
| - | =====API võti ===== | + | |
| - | Et leida liidese XML võti ja edastada see arendajale: | + | |
| - | - Logi Directosse sisse kasutajaga kellel on '' | + | |
| - | - Kuna API võtmeid võib olla mitu, siis pead avama töötaja kaardi kellele on võti loodud. Näiteks ava töötaja kaart ' | + | |
| - | - Liigu '' | + | |
| - | - Liigu sektsioonini '' | + | |
| - | - Vajaliku liidese real vajuta nuppu {{: | + | |
| - | + | ||
| - | =====Ligipääs liidesele (URL) ===== | + | |
| - | Liidesele ligipääs käib POST meetodil, form/ | + | |
| - | + | ||
| - | Ligipääsuks tuleb kasutada token' | + | |
| - | + | ||
| - | {{page>et: | + | |
| - | + | ||
| - | + | ||
| - | ====curl näited ==== | + | |
| - | **get ** | + | |
| - | < | + | |
| - | curl --location ' | + | |
| - | --header ' | + | |
| - | --data-urlencode ' | + | |
| - | --data-urlencode ' | + | |
| - | --data-urlencode ' | + | |
| - | --data-urlencode ' | + | |
| - | </ | + | |
| - | :!: ts on siin näites filter, et pärida ainult muutunud andmeid | + | |
| - | + | ||
| - | **put** | + | |
| - | < | + | |
| - | url --location ' | + | |
| - | --header ' | + | |
| - | --data-urlencode ' | + | |
| - | --data-urlencode ' | + | |
| - | --data-urlencode ' | + | |
| - | --data-urlencode ' | + | |
| - | < | + | |
| - | <order number=" | + | |
| - | < | + | |
| - | <row item=" | + | |
| - | <row item=" | + | |
| - | </ | + | |
| - | < | + | |
| - | < | + | |
| - | < | + | |
| - | < | + | |
| - | </ | + | |
| - | </ | + | |
| - | </ | + | |
| - | </ | + | |
| - | </ | + | |
| - | =====Hind ====== | + | |
| - | **Hind sõltub valitud komponentidest.** \\ | + | |
| - | Kustutatud dokumentide väljund on hinna sees ja tasuta. | + | |
| - | + | ||
| - | **Lisa API võtme hind on 0 € kuus.** \\ | + | |
| - | Kui mitmel API võtmel on samad komponendid, | + | |
| - | + | ||
| - | **Näide: ** \\ | + | |
| - | * API võti A sisaldab väljundeid: | + | |
| - | * API võti B sisaldab väljundeid: | + | |
| - | → Sellisel juhul on tasu ainult kolme unikaalse komponendi eest: klient, artikkel ja tellimus. | + | |
| - | =====Testimine ====== | + | |
| - | XML Direct liidese testimise link | + | |
| - | https:// | + | |
| - | + | ||
| - | =====Üldine ====== | + | |
| - | * Väljundliidesed näitavad kõiki kirjeid ning piiranguid saab teha päringu filtritega! | + | |
| - | * Sisendliideste funktsionaalsust saab juhtida '' | + | |
| - | * Osadel sisenditel on toetatud ka vaikeväärtuste seadistamine. | + | |
| - | * Sisendliidesed võimaldavad uue dokumendi loomist ja vana muutmist. Erand on '' | + | |
| - | * Dokumendi muutmisel tuleb postitada tuleb tervik dokument!!! | + | |
| - | + | ||
| - | =====Komponendid ===== | + | |
| - | **Valitavad komponendid** | + | |
| - | ^ Komponent (what) | + | |
| - | | Pakkumised (quotation) | + | |
| - | | Tellimused (order) | + | |
| - | | Arved (invoice ) | + | |
| - | | Laekumised (receipt) | + | |
| - | | Kliendid (customer) | + | |
| - | | Hankijad (supplier) | + | |
| - | | Kontaktid (contact) | + | |
| - | | Artiklid (item) | + | |
| - | | Artiklid: | + | |
| - | | Artiklid: | + | |
| - | | Artiklid: | + | |
| - | | Artiklid: | + | |
| - | | Artikliklassid (itemclass) | + | |
| - | | Artikli ajalugu (itemhistoryrow) | + | |
| - | | Hinnavalemi read (priceformularow) | + | |
| - | | Laod (stock) | + | |
| - | | Laoseis (stocklevel) | + | |
| - | | Laoseis variantidega (stocklevel_variant_sn) | + | |
| - | | Laoseisu vaba mõutavad kogused (allocation) | + | |
| - | | Retseptid (recipe) | + | |
| - | | Lähetused (delivery) | + | |
| - | | Tagastused (stockreturn) | + | |
| - | | Liikumised (movement) | + | |
| - | | Laotellimused(stockorder) | + | |
| - | | Inventuurid (taking) | + | |
| - | | Mahakandmised (writeoff) | + | |
| - | | Ostutellimused (purchaseorder) | + | |
| - | | Sissetulekud (stockreceipt) | + | |
| - | | Ostuarved (purchase) | + | |
| - | | Tootmised (production) | + | |
| - | | Laekumised (receipt) | + | |
| - | | Kulutused (expense) | + | |
| - | | Kontod (account) | + | |
| - | | Objektid (object) | + | |
| - | | Varad (asset) | + | |
| - | | Finantskanded (transaction) | + | |
| - | | Finantskanderead (transactionrow) | + | |
| - | | Lepingud (contract) | + | |
| - | | Projektid (project) | + | |
| - | | Sündmused (event) | + | |
| - | | Ressursid (resource) | + | |
| - | | Kasutajad(user) | + | |
| - | | Puudumised (absence) | + | |
| - | | Asenduste logi (replacementlog) | + | |
| - | | Kustutatud dokumendid (delete) | + | |
| - | + | ||
| - | ====Sisendid ==== | + | |
| - | + | ||
| - | ===Pakkumised === | + | |
| - | what=quotation [[https:// | + | |
| - | + | ||
| - | + | ||
| - | == Päis: === | + | |
| - | ^ XML väli ^ SQL väli ^ UI väli ^ Selgitus | + | |
| - | | session_id | + | |
| - | | number | + | |
| - | | version | + | |
| - | | type | tyyp | | | | + | |
| - | | validity | + | |
| - | | ourrep | + | |
| - | | ordercomment | + | |
| - | | customercode | + | |
| - | | customername | + | |
| - | | date | aeg | + | |
| - | | address1 | + | |
| - | | address2 | + | |
| - | | address3 | + | |
| - | | deliveryaddress1 | + | |
| - | | deliveryaddress2 | + | |
| - | | deliveryaddress3 | + | |
| - | | paymentterm | + | |
| - | | deliverymethod | + | |
| - | | email | email | + | |
| - | | phone | telefon | + | |
| - | | fax | faks | | | | + | |
| - | | stock | ladu | | | | + | |
| - | | object | + | |
| - | | contact | + | |
| - | | datafield1 | + | |
| - | | datafield2 | + | |
| - | | datafield3 | + | |
| - | | datafield4 | + | |
| - | | datafield5 | + | |
| - | | datafield6 | + | |
| - | | datafield7 | + | |
| - | | text1 | tekst1 | + | |
| - | | text2 | tekst2 | + | |
| - | | deliveryname | + | |
| - | | vatzone | + | |
| - | | priceformula | + | |
| - | | salesman | + | |
| - | | currency | + | |
| - | | currencyrate | + | |
| - | | language | + | |
| - | | factoring | + | |
| - | | project | + | |
| - | | vatregno | + | |
| - | | country | + | |
| - | | status | + | |
| - | | confirm | + | |
| - | | deliverydate | + | |
| - | | deliveryterm | + | |
| - | | manager | + | |
| - | | nextcontact | + | |
| - | | timeclose | + | |
| - | | competitor | + | |
| - | | closeingcomment | + | |
| - | | statuschanged | + | |
| - | | budget | + | |
| - | | prepaymentpercentage | + | |
| - | | campaignnotallowed | + | |
| - | | contract | + | |
| - | | validitycomment | + | |
| - | | customer_type | + | |
| - | | customer_regno | + | |
| - | | customer_class | + | |
| - | | customer_loyaltycard | + | |
| - | + | ||
| - | == read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel| | | | + | |
| - | |description|nimetus| | | | + | |
| - | |price|yhikuhind| | | | + | |
| - | |quantity|kogus| | | | + | |
| - | |discount|ale| | | | + | |
| - | |purchaseprice|ostuhind| | | | + | |
| - | |account|konto| | | | + | |
| - | |vatcode|kmkood| | | | + | |
| - | |sn|sn| | | | + | |
| - | |project|projekt| | | | + | |
| - | |unit|yhik| | | | + | |
| - | |comment|r_kommentaar| | | | + | |
| - | |variant|variant| | | | + | |
| - | |salesman|r_myyja| | | | + | |
| - | |sum|summa| | | | + | |
| - | |package|pakis| | | | + | |
| - | |stock|r_ladu| | | | + | |
| - | |height|korgus| | | | + | |
| - | |width|laius| | | | + | |
| - | |depth|sygavus| | | | + | |
| - | |volume|maht| | | | + | |
| - | |weight|kaal| | | | + | |
| - | |deliverydate|lahetusaeg| | | | + | |
| - | |date1|r_aeg1| | | | + | |
| - | |date2|r_aeg2| | | | + | |
| - | |periods|perioodid| | | | + | |
| - | |text1|tekst1| | | | + | |
| - | |text2|tekst2| | | | + | |
| - | |text3|tekst3| | | | + | |
| - | |text4|tekst4| | | | + | |
| - | |constant1|konstant1| | | | + | |
| - | |constant2|konstant2| | | | + | |
| - | |constant3|konstant3| | | | + | |
| - | |constant4|konstant4| | | | + | |
| - | |rn|rn| | | | + | |
| - | |rr|rv| | | | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | ===Arved=== | + | |
| - | what=invoice [[https:// | + | |
| - | + | ||
| - | + | ||
| - | == Päis: === | + | |
| - | ^ XML väli ^ SQL väli ^ UI väli ^ Selgitus | + | |
| - | | session_id | + | |
| - | | number | + | |
| - | | date | aeg | Kuupäev | + | |
| - | | duedate | + | |
| - | | transactiondate | + | |
| - | | vatzone | + | |
| - | | paymentterm | + | |
| - | | ordernumber | + | |
| - | | latepaymentpenalty | + | |
| - | | object | + | |
| - | | project | + | |
| - | | account | + | |
| - | | country | + | |
| - | | currency | + | |
| - | | currencyrate | + | |
| - | | customercode | + | |
| - | | customername | + | |
| - | | orderer_code | + | |
| - | | contact | + | |
| - | | comment | + | |
| - | | intcomment | + | |
| - | | salesman | + | |
| - | | language | + | |
| - | | customerordernumber | + | |
| - | | email | email | meil | ALT.FROM: customer | + | |
| - | | address1 | + | |
| - | | address2 | + | |
| - | | address3 | + | |
| - | | phone | telefon | + | |
| - | | fax | faks | Faks | + | |
| - | | deliveryname | + | |
| - | | deliveryaddress1 | + | |
| - | | deliveryaddress2 | + | |
| - | | deliveryaddress3 | + | |
| - | | priceformula | + | |
| - | | vatregno | + | |
| - | | datafield1 | + | |
| - | | datafield2 | + | |
| - | | datafield3 | + | |
| - | | datafield4 | + | |
| - | | datafield5 | + | |
| - | | datafield6 | + | |
| - | | datafield7 | + | |
| - | | quotation | + | |
| - | | contractnumber | + | |
| - | | prepayment | + | |
| - | | type | tyyp | | | | + | |
| - | | status | + | |
| - | | paymenttotal | + | |
| - | | confirm | + | |
| - | | stock | ladu | Ladu | ALT.FROM: tr.params | + | |
| - | | creditedinvoice | + | |
| - | | asset | inventar | + | |
| - | | dealtype | + | |
| - | | delivery | + | |
| - | | deliveryterm | + | |
| - | | deliverytermcomment | + | |
| - | | deliverymethod | + | |
| - | | deliverymethodcomment | + | |
| - | | manager | + | |
| - | | changestock | + | |
| - | | customer_type | + | |
| - | | customer_regno | + | |
| - | | customer_class | + | |
| - | | customer_loyaltycard | + | |
| - | + | ||
| - | == read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel|Artikkel| | | + | |
| - | |description|seletus|Sisu| ALT.FROM: item | | + | |
| - | |variant|variant|Variant| | | + | |
| - | |price|hind|Ühikuhind| unit price without vat | | + | |
| - | |discount|pross|%| | | + | |
| - | |quantity|kogus|Kogus| | | + | |
| - | |unit|yhik|Ühik| ALT.FROM: item | | + | |
| - | |sum|summa|Summa| | | + | |
| - | |account|konto|Konto| ALT.FROM: item > item class (depending on vatregion) | | + | |
| - | |object|objektid|Objekt| ALT.FROM: item > item class | | + | |
| - | |project|projekt|Projekt| ALT.FROM: item > item class | | + | |
| - | |purchaseprice|kulu|Ostuhind| ALT.FROM: item | | + | |
| - | |vatcode|kmk|KMk| | + | |
| - | |comment|r_kommentaar|Kommentaar| | | + | |
| - | |date1|r_aeg1| | | | + | |
| - | |date2|r_aeg2| | | | + | |
| - | |salesman|r_myyja|Müüja| | | + | |
| - | |order|tellimus| | | | + | |
| - | |orderrow|trn| | | | + | |
| - | |stock|r_ladu|Ladu| | | + | |
| - | |sn|seerianumber|Seerianr| | | + | |
| - | |deliverytime|lahetusaeg|Lähetusaeg| | | + | |
| - | |customer|r_klient|Tellija| | | + | |
| - | |customername|r_klient_nimi|Tellija nimi| | | + | |
| - | |text1|tekst1|Tekst1| | | + | |
| - | |text2|tekst2|Tekst2| | | + | |
| - | |text3|tekst3|Tekst3| | | + | |
| - | |text4|tekst4|Tekst4| | | + | |
| - | |constant1|konstant1|Konstant1| | | + | |
| - | |constant2|konstant2|Konstant2| | | + | |
| - | |constant3|konstant3|Konstant3| | | + | |
| - | |constant4|konstant4|Konstant4| | | + | |
| - | |shelf|riiul|Riiul| | | + | |
| - | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | |
| - | |rr|rv|Rv|row reference for grouping, otherwise equals to rn , ALT.FROM: equals to rn | | + | |
| - | + | ||
| - | == Arvete transpordi parameetrid == | + | |
| - | + | ||
| - | ^ TÜÜP | + | |
| - | | XML | xd_changestock | + | |
| - | | XML | xd_autocustomer_autocode | + | |
| - | | XML | xd_update | + | |
| - | | XML | xd_customer_update | + | |
| - | | XML | xd_object | + | |
| - | | XML | xd_salesman | + | |
| - | | XML | xd_stock | + | |
| - | | XML | xd_confirm | + | |
| - | | XML | xd_posinvoice | + | |
| - | | XML | xd_autocustomer | + | |
| - | | XML | xd_paymentvatcode | + | |
| - | | XML | xd_confirmpayment | + | |
| - | + | ||
| - | Arve vaikimisi väärtuste seadistamiseks loe täpsemalt [[https:// | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | ===Tellimused === | + | |
| - | what=order | + | |
| - | [[https:// | + | |
| - | + | ||
| - | == Päis: === | + | |
| - | ^ XML väli ^ SQL väli ^ UI väli ^ Selgitus | + | |
| - | | session_id | + | |
| - | | number | + | |
| - | | customercode | + | |
| - | | customername | + | |
| - | | date | aeg | Kuupäev | + | |
| - | | address1 | + | |
| - | | address2 | + | |
| - | | address3 | + | |
| - | | deliveryaddress1 | + | |
| - | | deliveryaddress2 | + | |
| - | | deliveryaddress3 | + | |
| - | | paymentterm | + | |
| - | | deliverymethod | + | |
| - | | customerordernumber | + | |
| - | | email | email | meil | ALT.FROM: customer | + | |
| - | | phone | telefon | + | |
| - | | comment | + | |
| - | | stock | ladu | Ladu | ALT.FROM: tr.params | + | |
| - | | object | + | |
| - | | contact | + | |
| - | | datafield1 | + | |
| - | | datafield2 | + | |
| - | | datafield3 | + | |
| - | | datafield4 | + | |
| - | | datafield5 | + | |
| - | | datafield6 | + | |
| - | | datafield7 | + | |
| - | | paymenttotal | + | |
| - | | vatzone | + | |
| - | | priceformula | + | |
| - | | currency | + | |
| - | | currencyrate | + | |
| - | | vatregno | + | |
| - | | country | + | |
| - | | status | + | |
| - | | delivery | + | |
| - | | customer_type | + | |
| - | | customer_regno | + | |
| - | | customer_loyaltycard | + | |
| - | | salesman | + | |
| - | | project | + | |
| - | | deliveryname | + | |
| - | | factoring | + | |
| - | | deliveryterm | + | |
| - | | language | + | |
| - | + | ||
| - | == Read: == | + | |
| - | ^ XML väli ^ SQL väli ^ UI väli ^ Selgitus | + | |
| - | | item | artikkel | + | |
| - | | description | + | |
| - | | price | yhikuhind | + | |
| - | | quantity | + | |
| - | | discount | + | |
| - | | account | + | |
| - | | vatcode | + | |
| - | | unit | yhik | Ühik | ALT.FROM: item | | + | |
| - | | comment | + | |
| - | | variant | + | |
| - | | deliverytime | + | |
| - | | stock | r_ladu | + | |
| - | | project | + | |
| - | | ext_sum | + | |
| - | | ext_id | + | |
| - | | rn | rn | Nr | row order number in document 1 - N , ALT.FROM: random | + | |
| - | | rr | rv | Rv | row reference for grouping, otherwise equals to rn , ALT.FROM: equals to rn | | + | |
| - | + | ||
| - | + | ||
| - | ==Tellimuse transpordi parameetrid == | + | |
| - | ^ TÜÜP | + | |
| - | | XML | xd_stock | + | |
| - | | XML | xd_object | + | |
| - | | XML | xd_autocustomer | + | |
| - | | XML | xd_confirm | + | |
| - | | XML | xd_update | + | |
| - | | XML | xd_autocustomer_autocode | + | |
| - | | XML | xd_customer_update | + | |
| - | | XML | xd_salesman | + | |
| - | | XML | xd_confirmpayment | + | |
| - | | XML | xd_paymentvatcode | + | |
| - | | XML | xd_order_assemble | + | |
| - | | XML | xd_updateconfirmed | + | |
| - | + | ||
| - | Tellimuse vaikimisi väärtuste seadistamiseks loe täpsemalt [[https:// | + | |
| - | ===Laekumised === | + | |
| - | what=receipt | + | |
| - | [[https:// | + | |
| - | + | ||
| - | == 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|Laekumine| 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|Aeg| ALT.FROM: current time | | + | |
| - | |description|seletus|Kommentaar| | | + | |
| - | |paymentmode|tasumisviis|Tas. viis| | | + | |
| - | |user|kasutaja|Kasutaja| | | + | |
| - | |reference|viide|Viide| | | + | |
| - | |object|objekt|Objekt| ALT.FROM: tr.params | | + | |
| - | |project|projekt|Projekt| ALT.FROM: tr.params | | + | |
| - | |location|arvuti|Koht| | | + | |
| - | |confirm|kinnita| | confirm document = 1 | | + | |
| - | + | ||
| - | ==read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |invoice|arvenumber|Arve nr| | | + | |
| - | |aeg|raeg|Aeg| ALT.FROM: receipt header | | + | |
| - | |customer|klient_kood|Klient| ALT.FROM: invoice > order > customer by regno field | | + | |
| - | |order|ettemaks|Tellimuse nr| | | + | |
| - | |customername|klient_nimi|Tekst| ALT.FROM: invoice > order > customer by regno field | | + | |
| - | |payment|tasuti|Tasuti| ALT.FROM: in case of base currency = received field | | + | |
| - | |bankcurrency|valuuta_p|Val saadud| ALT.FROM: glob.settings > ' | + | |
| - | |received|summa_p|Summa S| | | + | |
| - | |currencyrate|kurss_p|Kurss S| ALT.FROM: ECB current published rates | | + | |
| - | |paymentfee|teenustasu|T-Tasu| | | + | |
| - | |vatcode|kmk|KMk| ALT.FROM: tr.params | | + | |
| - | |paymentfeecurrency|valuuta_teenus|T-Tasu val.| | | + | |
| - | |description|selgitus|Selgitus| | | + | |
| - | |regno|reg|Reg number/IK| ALT.FROM: customer | | + | |
| - | |bankaccount|arveldusarve|Arveldusarve| | | + | |
| - | |objects|objektid|Objekt| ALT.FROM: invoice > order | | + | |
| - | |account|r_konto|Konto| | | + | |
| - | |fine|viivis|Viivis| | | + | |
| - | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | |
| - | + | ||
| - | + | ||
| - | ===Objektid === | + | |
| - | what=receipt | + | |
| - | [[https:// | + | |
| - | + | ||
| - | == 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! | | + | |
| - | |code|kood| | | | + | |
| - | |name|nimi| | | | + | |
| - | |type|tyyp| | | | + | |
| - | |closed|suletud| | | | + | |
| - | |master|master| | | | + | |
| - | |info|lisainfo| | | | + | |
| - | |purchasevatcode|ostu_kmk| | | | + | |
| - | |address|aadress| | | | + | |
| - | |logo|logo| | | | + | |
| - | |sorted|so| | | | + | |
| - | |hierarchy|hierarhia| | | | + | |
| - | |hierarchies|hierarhiad| | | | + | |
| - | |level|tase| | | | + | |
| - | |date1|aeg1| | | | + | |
| - | |date2|aeg2| | | | + | |
| - | + | ||
| - | ==Lisaväljad: | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |content|sisu|Sisu| | | + | |
| - | |param|param|Parameeter| | | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | ===Varad === | + | |
| - | what=asset | + | |
| - | [[https:// | + | |
| - | + | ||
| - | == Päis: == | + | |
| - | ^ XML väli ^ SQL väli ^ UI väli ^ Selgitus | + | |
| - | | session_id | + | |
| - | | code | kood | Kontakt | + | |
| - | | comment | + | |
| - | | sn | seerianumber | + | |
| - | | department | + | |
| - | | customer | + | |
| - | | customername | + | |
| - | | project | + | |
| - | | user | kasutaja | + | |
| - | | name | nimetus | + | |
| - | | barcode | + | |
| - | | master | + | |
| - | | date | aeg | Vara: Arvestuse algus/Kl vara: Soetuse aeg | | + | |
| - | | date2 | aeg2 | + | |
| - | | purchaseprice | + | |
| - | | currentvalue | + | |
| - | | minvalue | + | |
| - | | item | artikkel | + | |
| - | | incharge | + | |
| - | | purchased | + | |
| - | | type | mis | | + | |
| - | | class | klass | | + | |
| - | | supplier | + | |
| - | | suppliername | + | |
| - | | closed | + | |
| - | | purchaseinvoice | + | |
| - | | amort | amort | | + | |
| - | | object | + | |
| - | | depreciation | + | |
| - | | address | + | |
| - | | phone | telefon | + | |
| - | | email | email | | + | |
| - | | valuecorrection | + | |
| - | | disposaltime | + | |
| - | | warranty | + | |
| - | | extwarranty | + | |
| - | | calcmethod | + | |
| - | | qty | kogus | | + | |
| - | | rentalasset | + | |
| - | | rentalitem | + | |
| - | | rentaltime1 | + | |
| - | | rentaltime2 | + | |
| - | | rentalunit | + | |
| - | | auto | auto_erisoodustus | + | |
| - | | endofdepreciation | + | |
| - | | unitprice | + | |
| - | | customtxtfield1 | + | |
| - | | customtxtfield2 | + | |
| - | + | ||
| - | ==lisaväljad: | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |content|sisu|Sisu| | | + | |
| - | |param|param|Parameeter| | | + | |
| - | + | ||
| - | ===Kanded === | + | |
| - | what=transaction | + | |
| - | [[https:// | + | |
| - | + | ||
| - | == 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; With combination of field " | + | |
| - | |date|aeg2|Aeg| | | + | |
| - | |reference|viide|Viide| | | + | |
| - | |comment|seletus|Seletus| | | + | |
| - | |type|tyyp|Tüüp| ALT.: FIN | | + | |
| - | + | ||
| - | ==read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |account|konto|Konto| | | + | |
| - | |object|objekt|Objektid| | | + | |
| - | |description|sisu|Sisu| | + | |
| - | |vatcode|kmkood|KM kood| | | + | |
| - | |quantity|kogus|Kogus| | | + | |
| - | |debitamount|baas1deebet|Deebet| | | + | |
| - | |creditamount|baas1kreedit|Kreedit| | | + | |
| - | |currencydebit|valuutadeebet|Val. deebet| | | + | |
| - | |currencycredit|valuutakreedit|Val. kreedit| | | + | |
| - | |currencyrate|b1kursile|Kurss| ALT.FROM: ECB current published rates | | + | |
| - | |currency|valuuta|Valuuta| ALT.FROM: glob.settings > ' | + | |
| - | |date|r_aeg|Aeg| | | + | |
| - | |supplier|hankija|Hankija| | | + | |
| - | |customer|klient|Klient| | | + | |
| - | |project|projekt|Projekt| | | + | |
| - | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | |
| - | + | ||
| - | + | ||
| - | ===Kulutused === | + | |
| - | what=transaction | + | |
| - | [[https:// | + | |
| - | + | ||
| - | == 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| | " | + | |
| - | + | ||
| - | ==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=== | + | |
| - | * Postitamisel ja muutmisel on alati nõutud code ja email! \\ | + | |
| - | what=customer | + | |
| - | [[https:// | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ==Kliendid == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | for internal use at Directo side, do not send this field! | | + | |
| - | |code|kood|Kood| 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 | | + | |
| - | |name|nimi|Nimi| | | + | |
| - | |object|objekt|Objekt| | | + | |
| - | |address1|aadress1|aadress, | + | |
| - | |address2|aadress2|aadress, | + | |
| - | |address3|aadress3|aadress, | + | |
| - | |deliveryaddress1|lahaadress1|aadress, | + | |
| - | |deliveryaddress2|lahaadress2|aadress, | + | |
| - | |deliveryaddress3|lahaadress3|aadress, | + | |
| - | |county|maakond|Maakond| | | + | |
| - | |country|asumaa|Asumaa| | | + | |
| - | |contact|kontakt|Esindaja| | | + | |
| - | |phone|telefon|Telefon| | | + | |
| - | |email|email|Meil| mandatory | | + | |
| - | |regno|regnr|Reg nr| | | + | |
| - | |vatregno|kmregnr|Km reg nr| | | + | |
| - | |notice|margukiri|Märgukirjad| yes = 1 | | + | |
| - | |birthday|klient_synnipaev|Sünnipäev| | | + | |
| - | |gender|klient_sugu|Sugu| female = 1, male = 0 | | + | |
| - | |class|klass|Klass| | | + | |
| - | |type|klient_tyyp|Tüüp| company = 0, private citizen = 1, government institution = 2 | | + | |
| - | |loyaltycard|kliendikaart|Kliendikaart| also used for personal ID code | | + | |
| - | |deliveryname|nimi_lahetusel|Nimi lähetusel| | | + | |
| - | |deliverymode|lahetusviis|Läh. viis| | | + | |
| - | |alert|hoiatus|Hoiatus| | | + | |
| - | |factoring|arvetasub|Arve tasub| | | + | |
| - | |fax|faks|Faks| | | + | |
| - | |comment|kommentaar|Kommentaar| | | + | |
| - | |payterm|tingimus|Tas. ting.| | | + | |
| - | |vatzone|maa|KM maa| local = 0, EU = 1, export = 2 | | + | |
| - | |language|keel|Keel| | | + | |
| - | |salesman|myyja|Müüja| | | + | |
| - | |bank|pank|Pank| | | + | |
| - | |bankaccount|arveldusarve|A/ | + | |
| - | |url|URL|Url| | | + | |
| - | |status|staatus|Staatus| | | + | |
| - | |accountmanager|kliendihaldur|Haldur| | | + | |
| - | |dealtype|tehinguliik|Tehinguliik| | | + | |
| - | |creditlimit|limiit|Limiit| | | + | |
| - | |priceformula|hinnakiri|Hinnavalem| | | + | |
| - | |specialpriceformula|hinnavalem_eri|Eripakkumised| | | + | |
| - | |discount|ale|Soodus %| | | + | |
| - | |destination|sihtriik|Sihtriik| | | + | |
| - | |firstname|eesnimi| | | | + | |
| - | |lastname|perenimi| | | | + | |
| - | |vatcode|kmkood|KM kood| | | + | |
| - | |extcode|valine_kood|Väline kood| | | + | |
| - | |deliveryinvoice|lah_arve|Lähetus| Lähetus ja Arve = 1, Lähetus = 0 | | + | |
| - | |currency|valuuta|Valuuta| | | + | |
| - | |closed|suletud| | | | + | |
| - | + | ||
| - | == Lisaväljad: | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |content|sisu|Sisu| | | + | |
| - | |param|param|Parameeter| | | + | |
| - | + | ||
| - | + | ||
| - | ==Kliendi transpordi parameetrid == | + | |
| - | ^ TÜÜP | + | |
| - | + | ||
| - | + | ||
| - | ===Hankijad === | + | |
| - | * Postitamisel ja muutmisel on alati nõutud code! \\ | + | |
| - | what=supplier | + | |
| - | [[https:// | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ==hankijad: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | for internal use at Directo side, do not send this field! | | + | |
| - | |code|kood|Kood| 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 | | + | |
| - | |name|nimi|Nimi| | | + | |
| - | |contact|kontakt| | | | + | |
| - | |address1|aadress1| | | | + | |
| - | |address2|aadress2| | | | + | |
| - | |address3|aadress3| | | | + | |
| - | |phone|telefon| | | | + | |
| - | |fax|faks| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |payment|tasumine| | | | + | |
| - | |vatregion|tasu| | | | + | |
| - | |bankaccount|pangakonto| | | | + | |
| - | |debtaccount|vkonto| | | | + | |
| - | |expenseaccount|kulukonto| | | | + | |
| - | |factoring|arvetasub| | | | + | |
| - | |currency|valuuta| | | | + | |
| - | |country|maa| | | | + | |
| - | |object|objekt| | | | + | |
| - | |language|keel| | | | + | |
| - | |class|klass| | | | + | |
| - | |deliveryterm|lahting| | | | + | |
| - | |deliverymode|lahviis| | | | + | |
| - | |vatregno|kmregnr| | | | + | |
| - | |alert|hoiatus| | | | + | |
| - | |vatcode|kmkood| | | | + | |
| - | |regno|regnr1| | | | + | |
| - | |ppaccount|ekonto| | | | + | |
| - | |bycustomer|klient| | | | + | |
| - | |lskonto|lskonto| | | | + | |
| - | |email|email| | | | + | |
| - | |reference|viide| | | | + | |
| - | |closed|suletud| | | | + | |
| - | |dealtype|tehinguliik| | | | + | |
| - | |origin|saatjariik| | | | + | |
| - | |normtime|norm_aeg| | | | + | |
| - | |trancost|transakulu| | | | + | |
| - | |skype|skype| | | | + | |
| - | |discount|ale| | | | + | |
| - | |proceeders|menetlejad| | | | + | |
| - | |prefilled|eeltaida| | | | + | |
| - | |stock|ladu| | | | + | |
| - | |proceedertempalte|menetlejad_mall| | | | + | |
| - | |referencemandatory|viide_kohustuslik| | | | + | |
| - | |type|hank_tyyp| | | | + | |
| - | |purchasinggroup|ostugrupp| | | | + | |
| - | |county|maakond| | | | + | |
| - | + | ||
| - | == hankijad lisaväljad: | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |content|sisu|Sisu| | | + | |
| - | |param|param|Parameeter| | | + | |
| - | + | ||
| - | + | ||
| - | ===Kontaktid=== | + | |
| - | * Postitamisel ja muutmisel on alati nõutud code! \\ | + | |
| - | what=supplier | + | |
| - | [[https:// | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ==kontaktid: | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | | | + | |
| - | |code|kood| | | | + | |
| - | |customercode|kl_kood| | | | + | |
| - | |customername|kl_nimi| | | | + | |
| - | |suppliercode|h_kood| | | | + | |
| - | |suppliername|h_nimi| | | | + | |
| - | |name|nimi| | | | + | |
| - | |address1|aadress1| | | | + | |
| - | |address2|aadress2| | | | + | |
| - | |address3|aadress3| | | | + | |
| - | |phone|telefon| | | | + | |
| - | |fax|faks| | | | + | |
| - | |email|email| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |comment2|komment2| | | | + | |
| - | |title|tiitel| | | | + | |
| - | |department|osakond| | | | + | |
| - | |occupation|amet| | | | + | |
| - | |mobile|mobiil| | | | + | |
| - | |county|maakond| | | | + | |
| - | |authorizationtime|volitus_aeg| | | | + | |
| - | |authorizationlimit|volitus_limiit| | | | + | |
| - | |officephone|telefon_too| | | | + | |
| - | |sex|sugu| | | | + | |
| - | |baseforauthorization|volitus_alus| | | | + | |
| - | |object|objekt| | | | + | |
| - | |skype|skype| | | | + | |
| - | |firstname|eesnimi| | | | + | |
| - | |lastname|perenimi| | | | + | |
| - | |birthday|synnipaev| | | | + | |
| - | |pid|isikukood| | | | + | |
| - | |closed|suletud| | | | + | |
| - | + | ||
| - | == kontaktid lisaväljad: | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |content|sisu|Sisu| | | + | |
| - | |param|param|Parameeter| | | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ===Artiklid=== | + | |
| - | * Artikli kaardi täitmisel liides täidab valjad vastavalt reeglitele [[et: | + | |
| - | + | ||
| - | what=item | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==Artiklid== | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | for internal use at Directo side, do not send this field! | | + | |
| - | |code|kood|Kood| 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 | | + | |
| - | |name|nimi|Nimi| | | + | |
| - | |class|klass|Klass| | | + | |
| - | |barcode|ribakood|Ribakood| | | + | |
| - | |areacode|piirkonnakood|Päritolu| | | + | |
| - | |unit|yhik|Ühik| | | + | |
| - | |salesprice|baashind|Müügihind| without VAT | | + | |
| - | |accountlocal|konto_myyk|Müük Siseriiklik| | | + | |
| - | |accounteu|konto_myyk_EU|Müük EU| | | + | |
| - | |accountexport|konto_myyk_eksport|Müük Eksp| | | + | |
| - | |vatcode|KMkood|KM Siseriiklik| | | + | |
| - | |vatcodeeu|KMkood_EU|KM EU| | | + | |
| - | |vatcodeexport|KMkood_eksport|KM mitte EU| | | + | |
| - | |type|tyyp|Tüüp| ALT.FROM: tr.params, cannot be updated. 0=service; 1=stock item; 2=rental item | | + | |
| - | |minlevel|minimaaltase|Min tase| | | + | |
| - | |shelf|riiulikood|Riiul| | | + | |
| - | |weight|kaal|Kaal| | | + | |
| - | |volume|maht|Maht| | | + | |
| - | |warranty|garantii|Garantii| | | + | |
| - | |package1|yhikumuut1|Pakis 1| | | + | |
| - | |package2|yhikumuut2|Pakis 2| | | + | |
| - | |sntracking|SN_jalgimine|Seeria nr| cannot be updated. 0=without sn tracking; 1=serial no tracking; 2=batch no tracking | | + | |
| - | |cost|ostuhind|Ostuhind| | | + | |
| - | |object|objekt|Objekt| | | + | |
| - | |recipe|retsept|Retsept| | | + | |
| - | |recipetorows|retsept_ridadeks|Retsept ei asetu| | | + | |
| - | |alert|hoiatus|Hoiatus| | | + | |
| - | |closed|suletud|Suletud| closed = 1, open = 0 | | + | |
| - | |description|pikktekst|Kirjeldus| | | + | |
| - | |vatprice1|hind_okonline|Lisahind 1 (customizable)| with local VAT | | + | |
| - | |vatprice2|hind_delfi|Lisahind 2 (customizable)| with local VAT | | + | |
| - | |vatprice3|soodus_hind1|Soodushind 1 (customizable)| with local VAT | | + | |
| - | |vatprice4|soodus_hind2|Soodushind 2 -customizable)| with local VAT | | + | |
| - | |vatprice|hind_tavaline|Tavahind| ALT.FROM: salesprice + local vat | | + | |
| - | |priority|prioriteet|Prioriteet| | | + | |
| - | |url|url|URL| | | + | |
| - | |supplier|hankija_kood|Hankija| | | + | |
| - | |supplieritem|hankija_artikkel|Hank. artikkel| | | + | |
| - | |maxlevel|maksimaaltase|Max tase| | | + | |
| - | |abc|abc|ABC klass| | | + | |
| - | |cn8code|cn8_kood|CN8 kood| | | + | |
| - | |cnkogus|cnkogus|CN kogus| | | + | |
| - | |vatcodeeu2|KMKood_EU2|KM EU 2| | | + | |
| - | |vatcodeeu3|KMKood_EU3|KM EU 3| | | + | |
| - | |vatcodeconcern|KMKood_kontsern|KM kontsern| | | + | |
| - | |accounteu2|konto_myyk_EU2|Müük EU 2| | | + | |
| - | |accounteu3|konto_myyk_EU3|Müük EU 3| | | + | |
| - | |accountconcern|konto_myyk_kontsern|Müük kontsern| | | + | |
| - | |snclass|sn_klass|SN klass| | | + | |
| - | |normarrivaltime|norm_aeg|Norm saabumisaeg| | | + | |
| - | |replacement|asendus|Asendus| | | + | |
| - | |snrule|sn_reegel|SN reegel| | | + | |
| - | |project|projekt|Projekt| | | + | |
| - | |variants|variandid|Variant| cannot be updated. 0=no; 1=yes | | + | |
| - | |autosn|auto_sn|Auto SN| | | + | |
| - | |specialprice1|kaibeta_hind1|Artikli käibeta lisahind1 (customizable)| | | + | |
| - | |specialprice2|kaibeta_hind2|Artikli käibeta lisahind2 (customizable)| | | + | |
| - | |specialprice3|kaibeta_hind3|Artikli käibeta lisahind3 (customizable)| | | + | |
| - | |specialprice4|kaibeta_hind4|Artikli käibeta lisahind4 (customizable)| | | + | |
| - | |specialprice5|kaibeta_hind5|Artikli käibeta lisahind5 (customizable)| | | + | |
| - | |specialprice6|kaibeta_hind6|Artikli käibeta lisahind6 (customizable)| | | + | |
| - | |specialprice7|kaibeta_hind7|Artikli käibeta lisahind7 (customizable)| | | + | |
| - | |specialprice8|kaibeta_hind8|Artikli käibeta lisahind8 (customizable)| | | + | |
| - | |height|korgus|Kõrgus| | | + | |
| - | |width|laius|Laius| | | + | |
| - | |depth|sygavus|Sügavus| | | + | |
| - | |grossweight|kaal_bruto|Bruto kaal| | | + | |
| - | |giftcert|kinkekaart|Kinkekaart| | | + | |
| - | |manufacturer|tootja|Tootja| | | + | |
| - | + | ||
| - | == Artiklid lisaväljad: | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |content|sisu|Sisu| | | + | |
| - | |param|param|Parameeter| | | + | |
| - | + | ||
| - | == Artiklid pakendid: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |class|pakendi_klass|Klass| | | + | |
| - | |type|pakendi_tyyp|Tüüp| | | + | |
| - | |height|korgus|Kõrgus| | | + | |
| - | |width|laius|Laius| | | + | |
| - | |length|pikkus|Pikkus| | | + | |
| - | |volume|maht|Maht| | | + | |
| - | |qty|kogus|Pak.kogus| | | + | |
| - | |packageweight|pakendi_kaal|Pakendi kaal| | | + | |
| - | |productweight|toote_kaal|Toote kaal| | | + | |
| - | |totalweight|kaal_kokku|KOKKU kaal| | | + | |
| - | |totalvolume|maht_kokku|KOKKU maht| | | + | |
| - | |barcode|ribakood|Ribakood| | | + | |
| - | |comment|kommentaar|Kommentaar| | | + | |
| - | |shelf|riiul|Riiul| | | + | |
| - | + | ||
| - | == Artiklid - hankija artiklid: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |supplier|hankija|Hankija| | | + | |
| - | |supplieritem|hankija_artikkel|Hank. artikkel| | | + | |
| - | |name|nimi|Nimi| | | + | |
| - | |price|hind|Ostuhind| | | + | |
| - | |normarrivaltime|norm_aeg|Norm saabumisaeg| | | + | |
| - | |object|objekt|Objekt| | | + | |
| - | |variant|variant|Variant| | | + | |
| - | |varianta|varianta|VariantA - (customizable)| | | + | |
| - | |variantb|variantb|VariantB - (customizable)| | | + | |
| - | |variantc|variantc|VariantC - (customizable)| | | + | |
| - | |variantd|variantd|VariantD - (customizable)| | | + | |
| - | |variante|variante|VariantE - (customizable)| | | + | |
| - | |variantf|variantf|VariantF - (customizable)| | | + | |
| - | |variantg|variantg|VariantG - (customizable)| | | + | |
| - | |varianth|varianth|VariantH - (customizable)| | | + | |
| - | |salesprice|myygihind|Müügihind| without VAT| | + | |
| - | |sales|myyk|| ALT.FROM: tr.params, cannot be updated , sales item = 1, supplier item = 0 | | + | |
| - | + | ||
| - | == Artiklid - minmax: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |stock|ladu|Ladu| | | + | |
| - | |shelf|riiul|Riiul| | | + | |
| - | |variant|variant|Variant| | | + | |
| - | |minlevel|min_kogus|MIN| | | + | |
| - | |maxlevel|max_kogus|MAX| | | + | |
| - | + | ||
| - | ==Artikli transpordi parameetrid == | + | |
| - | ^TÜÜP ^KOOD ^PARAMEETER 1 ^PARAMEETER 2 ^SELGITUS^ | + | |
| - | |XML |xd_supplieritemtype |0 |ITEM |0 = hankija artikkel; 1 = müügi artikkel | | + | |
| - | |XML |type |1 |ITEM |1 = laoartikkel | | + | |
| - | + | ||
| - | + | ||
| - | ===Hinnavalemid === | + | |
| - | + | ||
| - | what=priceformula | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==Hinnavalemid== | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | for internal use at Directo side, do not send this field! | | + | |
| - | |project|projekt|| | | + | |
| - | |code|kood|Kood| 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 | | + | |
| - | |name|nimi|Nimi (header)| | | + | |
| - | |text1|tekst1|| | | + | |
| - | |text2|tekst2|| | | + | |
| - | |currency|valuuta| | | | + | |
| - | |object|objekt| | | | + | |
| - | |order|so| | | | + | |
| - | + | ||
| - | == read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |class|klass|Klass| | | + | |
| - | |item|artikkel|Artikkel| | | + | |
| - | |name|nimi|Nimi (row)| | | + | |
| - | |type|mida|Mõjub| | | + | |
| - | |decimalplaces|kohad|Kohta| | | + | |
| - | |discount|ale|ALE| | | + | |
| - | |supplier|hankija|Hankija| | | + | |
| - | |data|data|Art.lisaväli| | | + | |
| - | |datacontent|datasisu|Sisu| | | + | |
| - | |date1|aeg1|Aeg1| | | + | |
| - | |date2|aeg2|Aeg2| | | + | |
| - | |time1|kell1|Kell1| | | + | |
| - | |time2|kell2|Kell2| | | + | |
| - | |rounding|ymardus|Korrektsioon| | | + | |
| - | |discountqty|ale_kogus|Alates kogusest| | | + | |
| - | |recipe|retsept|| | | + | |
| - | |rowproject|r_projekt|| | | + | |
| - | |rowobject|r_objekt|| | | + | |
| - | |variant|variant|Variant| | | + | |
| - | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | |
| - | |uuid|row_id|| Directo unique id for editing rows | | + | |
| - | + | ||
| - | + | ||
| - | ===Laohinna muutused=== | + | |
| - | + | ||
| - | what=pricechange | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==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| | | | + | |
| - | |stock|ladu| | | | + | |
| - | |date|aeg| | | | + | |
| - | |account|konto| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |confirm|kinnita| | " | + | |
| - | + | ||
| - | ==read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel| | | | + | |
| - | |description|seletus| | | | + | |
| - | |stockprice|hind1| | | | + | |
| - | |newstockprice|hind2| | | | + | |
| - | |quantity|kogus| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | + | ||
| - | ===Retseptid === | + | |
| - | + | ||
| - | what=recipe | + | |
| - | [[https:// | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ==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! | | + | |
| - | |code|kood| | | | + | |
| - | |name|nimetus| | | | + | |
| - | |date|aeg| | | | + | |
| - | + | ||
| - | ==Read == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel| | | | + | |
| - | |name|nimetus| | | | + | |
| - | |qty|kogus| | | | + | |
| - | |content|sisu| | | | + | |
| - | |unit|yhik| | | | + | |
| - | |option|valik| | | | + | |
| - | |value|value| | | | + | |
| - | |comment|r_kommentaar| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | + | ||
| - | ===Lähetused === | + | |
| - | + | ||
| - | what=delivery [[https:// | + | |
| - | + | ||
| - | ==Päis== | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | | | + | |
| - | |number|number| | | | + | |
| - | |status|staatus| | | | + | |
| - | |datafield1|lisa_field1| | | | + | |
| - | |datafield2|lisa_field2| | | | + | |
| - | |datafield3|lisa_field3| | | | + | |
| - | |datafield4|lisa_field4| | | | + | |
| - | |datafield5|lisa_field5| | | | + | |
| - | |datafield6|lisa_field6| | | | + | |
| - | |datafield7|lisa_field7| | | | + | |
| - | |text1|tekst1| | | | + | |
| - | |text2|tekst2| | | | + | |
| - | |confirm|kinnita| | | | + | |
| - | + | ||
| - | ==read == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel| | | | + | |
| - | |serialnumber|seerianumber| | | | + | |
| - | |variant|variant| | | | + | |
| - | |qty|kogus| | | | + | |
| - | |text1|tekst1| | | | + | |
| - | |text2|tekst2| | | | + | |
| - | |shelf|riiul| | | | + | |
| - | |stock|r_ladu| | | | + | |
| - | |rn|reanr| | | | + | |
| - | + | ||
| - | + | ||
| - | ===Tagastused === | + | |
| - | + | ||
| - | what=stockreturn [[https:// | + | |
| - | + | ||
| - | ==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 | | + | |
| - | |order|number_tellimus|Tellimuse nr | Mandatory | | + | |
| - | |date|aeg|Tagastuse aeg| Mandatory | | + | |
| - | |customercode|klient_kood|Kliendi kood| If missing customer code is taken from Sales order | | + | |
| - | |comment|tekst|Tekst| | | + | |
| - | |status|staatus|Staatus| | | + | |
| - | |object|objekt|Objekt| | | + | |
| - | |stock|ladu|Ladu| | | + | |
| - | |country|asumaa|Sihtriik| | | + | |
| - | |dealtype|tehinguliik|Tehinguliik| | | + | |
| - | |project|projekt|Projekt| | | + | |
| - | |customtxtfield1|customtxtfield1| | 255; customizable field| | + | |
| - | |customtxtfield2|customtxtfield2| | 255; customizable field| | + | |
| - | |confirm|kinnita| | confirm document = 1 | | + | |
| - | + | ||
| - | ==read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |itemcode|artikkel|Artikkel| Mandatory | | + | |
| - | |sn|seerianumber|SN/ | + | |
| - | |quantity|kogus|Kogus | Mandatory | | + | |
| - | |shelf|riiul|Riiul| | | + | |
| - | |object|objektid|Objekt| | | + | |
| - | |stock|r_ladu|Ladu| | | + | |
| - | |project|r_projekt|Projekt| | | + | |
| - | |customrowtxtfield1|customrowtxtfield1| | 255; customizable field| | + | |
| - | |customrowtxtfield2|customrowtxtfield2| | 255; customizable field| | + | |
| - | |customrowdecfield1|customrowdecfield1| | customizable field| | + | |
| - | |customrowdecfield2|customrowdecfield2| | customizable field| | + | |
| - | |rn|reanr|NR| Mandatory | | + | |
| - | ===Inventuurid === | + | |
| - | + | ||
| - | what=taking | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==Päis== | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | | | + | |
| - | |number|number| | | | + | |
| - | |date|aeg| | | | + | |
| - | |startdate|aeg_algus| | | | + | |
| - | |chain|kett| | | | + | |
| - | |stock|ladu| | | | + | |
| - | |project|projekt| | | | + | |
| - | |shelf|riiul| | | | + | |
| - | |object|objekt| | | | + | |
| - | |account|konto| | | | + | |
| - | |description|seletus| | | | + | |
| - | + | ||
| - | ==read == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |itemcode|artikkel| | | | + | |
| - | |sn|sn| | | | + | |
| - | |variant|variant| | | | + | |
| - | |quantity|kogus| | | | + | |
| - | |delete|kustuta| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | + | ||
| - | ===Mahakandmised === | + | |
| - | + | ||
| - | what=writeoff | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==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| | " | + | |
| - | + | ||
| - | ==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/ | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | ===Liikumised=== | + | |
| - | + | ||
| - | what=movement | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==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 | | + | |
| - | |date|aeg|Aeg| | | + | |
| - | |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| | | + | |
| - | |status|staatus|Staatus| | | + | |
| - | |fromstock|laost|Laost| | | + | |
| - | |tostock|lattu|Lattu| | | + | |
| - | |confirm|kinnita| | " | + | |
| - | |project|projekt|Projekt| | | + | |
| - | |toproject|projekti|Projekti| | | + | |
| - | |customer|kl_kood|Klient| | | + | |
| - | |contact|kl_kontakt|Kontaktisik| | | + | |
| - | |duedate|kl_aeg|Tähtaeg| | | + | |
| - | |deliveryterm|lahetustingimus|Läh. ting.| | | + | |
| - | |deliverymethod|lahetusviis|Lähetusviis| | | + | |
| - | |order|tellimus|Tell. nr.| | | + | |
| - | |productionorder|tootmistellimus|Tootmistellimus| | | + | |
| - | |comment|tekst|Tekst| | | + | |
| - | |type|liik_tyyp|Tüüp| | | + | |
| - | |user|kasutaja| | | | + | |
| - | |parentmovement|liikumine| | | | + | |
| - | |stockorder|laotellimus|Laotellimus| | | + | |
| - | |text1|tekst1| | | | + | |
| - | |text2|tekst2| | | | + | |
| - | + | ||
| - | ==read == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel|Artikkel| | | + | |
| - | |qty|kogus|Soovitud| | | + | |
| - | |receivedqty|kogus_saadud|Saadud| | | + | |
| - | |serialnumber|seerianumber|SN/ | + | |
| - | |variant|variant|| | | + | |
| - | |fromshelf|r_riiulist|Riiulist| | | + | |
| - | |toshelf|r_riiulisse|Riiulisse| | | + | |
| - | |comment|kommentaar|Kommentaar| | | + | |
| - | |project|r_projekt|Projektist| | | + | |
| - | |toproject|r_projekti|Projekti| | | + | |
| - | |rn|rn|Nr|row order number in document 1 - N | | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ===Laotellimused === | + | |
| - | + | ||
| - | what=stockorder | + | |
| - | [[https:// | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ==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|Ostutellimus| 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 | | + | |
| - | |text|tekst| | | | + | |
| - | |user|kasutaja| | | | + | |
| - | |fromstock|laost| | | | + | |
| - | |tostock|lattu| | | | + | |
| - | |date|aeg| | | | + | |
| - | |project|projekt| | | | + | |
| - | |toproject|projekti| | | | + | |
| - | |fromobject|objektist| | | | + | |
| - | |toobject|objekti| | | | + | |
| - | |fromaccount|kontolt| | | | + | |
| - | |toaccount|kontole| | | | + | |
| - | |account|konto| | | | + | |
| - | |status|staatus| | | | + | |
| - | |lisa_field1|lisa_field1| | | | + | |
| - | |lisa_field2|lisa_field2| | | | + | |
| - | |lisa_field3|lisa_field3| | | | + | |
| - | |lisa_field4|lisa_field4| | | | + | |
| - | |lisa_field5|lisa_field5| | | | + | |
| - | |lisa_field6|lisa_field6| | | | + | |
| - | |lisa_field7|lisa_field7| | | | + | |
| - | |deliverymode|lahetusviis| | | | + | |
| - | |type|tyyp| | | | + | |
| - | |order|tellimus| | | | + | |
| - | |reqduedate|soov_tahtaeg| | | | + | |
| - | + | ||
| - | ==read == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel| | | | + | |
| - | |qty|kogus| | | | + | |
| - | |name|nimetus| | | | + | |
| - | |sn|seerianumber| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |variant|variant| | | | + | |
| - | |fromstock|r_laost| | | | + | |
| - | |constant1|konstant1| | | | + | |
| - | |constant2|konstant2| | | | + | |
| - | |constant3|konstant3| | | | + | |
| - | |constant4|konstant4| | | | + | |
| - | |text1|tekst1| | | | + | |
| - | |text2|tekst2| | | | + | |
| - | |text3|tekst3| | | | + | |
| - | |text4|tekst4| | | | + | |
| - | |rn|rn| | | | + | |
| - | |rr|rv| | | | + | |
| - | + | ||
| - | + | ||
| - | ===Ostutellimused | + | |
| - | + | ||
| - | what=purchaseorder | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==Päis== | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | | | + | |
| - | |ext_unique_id|ext_unique_id| | | | + | |
| - | |number|number| | | | + | |
| - | |supplier|hankija_kood| | | | + | |
| - | |payterm|tingimus| | | | + | |
| - | |suppliername|hankija_nimi| | | | + | |
| - | |country|asumaa| | | | + | |
| - | |date|aeg| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |intcomment|sisekommentaar| | | | + | |
| - | |order|tellimus| | | | + | |
| - | |receivedate|lahetusaeg| | | | + | |
| - | |deliveryterm|lahetustingimus| | | | + | |
| - | |stock|ladu| | | | + | |
| - | |vatregion|maa| | | | + | |
| - | |language|keel| | | | + | |
| - | |supplier_regno|hankija_regnr1| | | | + | |
| - | |supplier_class|hankija_klass| | | | + | |
| - | |user|kasutaja| | | | + | |
| - | |type|tyyp| | | | + | |
| - | |status|staatus| | | | + | |
| - | |datafield1|lisa_field1| | | | + | |
| - | |datafield2|lisa_field2| | | | + | |
| - | |datafield3|lisa_field3| | | | + | |
| - | |datafield4|lisa_field4| | | | + | |
| - | |datafield5|lisa_field5| | | | + | |
| - | |datafield6|lisa_field6| | | | + | |
| - | |datafield7|lisa_field7| | | | + | |
| - | |address1|aadress1| | | | + | |
| - | |address2|aadress2| | | | + | |
| - | |address3|aadress3| | | | + | |
| - | |stockaddress1|laduaadress1| | | | + | |
| - | |stockaddress2|laduaadress2| | | | + | |
| - | |stockaddress3|laduaadress3| | | | + | |
| - | |phone|telefon| | | | + | |
| - | |tolerance|viga| | | | + | |
| - | |delivermode|lahetusviis| | | | + | |
| - | |origin|piirkonnakood| | | | + | |
| - | |dealtype|tehinguliik| | | | + | |
| - | |bankaccount|pangakonto| | | | + | |
| - | |reference|viide| | | | + | |
| - | |confirm|kinnita| | | | + | |
| - | + | ||
| - | ==read == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |unit|yhik| | | | + | |
| - | |price|yhikuhind| | | | + | |
| - | |qty|kogus| | | | + | |
| - | |name|nimi| | | | + | |
| - | |receivedate|saabumisaeg| | | | + | |
| - | |comment|r_kommentaar| | | | + | |
| - | |intcomment|r_sisekommentaar| | | | + | |
| - | |constant1|konstant1| | | | + | |
| - | |constant2|konstant2| | | | + | |
| - | |constant3|konstant3| | | | + | |
| - | |constant4|konstant4| | | | + | |
| - | |tekst1|tekst1| | | | + | |
| - | |tekst2|tekst2| | | | + | |
| - | |tekst3|tekst3| | | | + | |
| - | |tekst4|tekst4| | | | + | |
| - | |project|r_projekt| | | | + | |
| - | |stock|r_ladu| | | | + | |
| - | |purchaseprice|soetushind| | | | + | |
| - | |object|r_objekt| | | | + | |
| - | |variant|variant| | | | + | |
| - | |received1|saadud1| | | | + | |
| - | |received2|saadud2| | | | + | |
| - | |origin|piirkonnakood| | | | + | |
| - | |rr|rv| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | + | ||
| - | ==Tellimuse transpordi parameetrid == | + | |
| - | ^ TÜÜP | + | |
| - | | XML | xd_updateconfirmed | + | |
| - | + | ||
| - | + | ||
| - | ===Sissetulekud === | + | |
| - | + | ||
| - | what=stockreceipt | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==Päis== | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | | | + | |
| - | |number|number| | | | + | |
| - | |date|aeg| | | | + | |
| - | |supplier|hankija_kood| | | | + | |
| - | |suppliername|hankija_nimi| | | | + | |
| - | |purchaseorder|number_ostutellimus| | | | + | |
| - | |stock|ladu| | | | + | |
| - | |text|tekst| | | | + | |
| - | |currency|valuuta| | | | + | |
| - | |currencyrate|kurssbv1| | | | + | |
| - | |creditaccount|konto| | | | + | |
| - | |object|objekt| | | | + | |
| - | |project|projekt| | | | + | |
| - | |supplierinvoice|hankija_arve| | | | + | |
| - | |country|asumaa| | | | + | |
| - | |dealtype|tehinguliik| | | | + | |
| - | |deliverymode|lahetusviis| | | | + | |
| - | |deliveryterm|lahetustingimus| | | | + | |
| - | |paymentterm|tingimus| | | | + | |
| - | |status|staatus| | | | + | |
| - | |type|tyyp| | | | + | |
| - | |purchaseinvoicetime|aeg_oarve| | | | + | |
| - | |datafield1|lisa_field1| | | | + | |
| - | |datafield2|lisa_field2| | | | + | |
| - | |datafield3|lisa_field3| | | | + | |
| - | |datafield4|lisa_field4| | | | + | |
| - | |datafield5|lisa_field5| | | | + | |
| - | |datafield6|lisa_field6| | | | + | |
| - | |datafield7|lisa_field7| | | | + | |
| - | |user|kasutaja| | | | + | |
| - | |origin|piirkonnakood| | | | + | |
| - | |intcomment|sisekommentaar| | | | + | |
| - | |supplier_class|hankija_klass| | | | + | |
| - | |supplier_vatcountry|hankija_maa_tasu| | | | + | |
| - | |supplier_regno|hankija_regnr1| | | | + | |
| - | |supplier_vatregno|hankija_kmregnr| | | | + | |
| - | |supplier_email|hankija_email| | | | + | |
| - | |confirm|kinnita| | | | + | |
| - | + | ||
| - | ==read == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel| | | | + | |
| - | |qty|kogus| | | | + | |
| - | |content|sisu| | | | + | |
| - | |price|yhikuhind| | | | + | |
| - | |purchaseprice|soetushind| | | | + | |
| - | |serialnumber|seerianumber| | | | + | |
| - | |stock|ladu| | | | + | |
| - | |bestbefore|parimenne| | | | + | |
| - | |origin|piirkonnakood| | | | + | |
| - | |project|r_projekt| | | | + | |
| - | |object|r_objekt| | | | + | |
| - | |variant|variant| | | | + | |
| - | |comment|r_kommentaar| | | | + | |
| - | |intcomment|r_sisekommentaar| | | | + | |
| - | |purchaseorder|ostutellimus| | | | + | |
| - | |shelf|riiul| | | | + | |
| - | |orn|trn| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ===Ostuarved === | + | |
| - | + | ||
| - | what=purchase | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==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! | | + | |
| - | |ext_unique_id|ext_unique_id|! vastavalt seadetele| if Directo number/code is not used, this is alternative ID; It must be unique for each document and remain same if more than one transaction of the same document is necessary | | + | |
| - | |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 | | + | |
| - | |date|aeg|Arve aeg| ALT.FROM: current time | | + | |
| - | |duedate|tas_aeg|Tas. aeg| | | + | |
| - | |sum|summa|Tasuda| sum with vat | | + | |
| - | |supplierinvoiceno|hankija_arve|Hankija arve| | | + | |
| - | |paymentterm|tingimus|Tas. ting.| ALT.FROM: supplier | | + | |
| - | |suppliercode|hankija_kood|Hankija| | | + | |
| - | |suppliername|hankija_nimi|| ALT.FROM: supplier | | + | |
| - | |bankaccount|pangakonto| | ALT.FROM: supplier | | + | |
| - | |reference|viide|Viitenumber| ALT.FROM: supplier | | + | |
| - | |transactiontime|kande_aeg|Op. aeg| | | + | |
| - | |creditaccount|kred_konto|Kred. konto| ALT.FROM: supplier > glob.settings | | + | |
| - | |factoring|arve_tasub|Arve tasub| | | + | |
| - | |currency|valuuta|Valuuta| ALT.FROM: glob.settings > ' | + | |
| - | |currencyrate|kurssbv1|Kurss| ALT.FROM: ECB current published rates | | + | |
| - | |vatzone|maa|KM Maa (peidetud väli)| local = 0, EU = 1, export = 2 , ALT.FROM: supplier > 0 | | + | |
| - | |comment|kommentaar|Kommentaar| | | + | |
| - | |vat|arvestatudkm|KM kokku| | | + | |
| - | |object|objekt|Objekt| ALT.FROM: supplier > tr.params | | + | |
| - | |bankcode|pangakood|Pangakood| | | + | |
| - | |creditpurchase|kredost|Kred. ost| | | + | |
| - | |purchaseorder|ostutellimus|Ostutellimus| | | + | |
| - | |project|projekt|Projekt| | | + | |
| - | |email|email|meil| ALT.FROM: supplier | | + | |
| - | |stockreceipt|sissetulek|Sissetulek| | | + | |
| - | |country|asumaa|Saatjariik| ALT.FROM: supplier | | + | |
| - | |prepayment|ettemaks|Ettemaks| | | + | |
| - | |status|staatus|Staatus| | | + | |
| - | |type|tyyp|Tüüp| | | + | |
| - | |dividedsum|jagatav_summa|Jagatav summa| | | + | |
| - | |vatdate|km_aeg|KM aeg| ALT.FROM: date > current time | | + | |
| - | |reclamation|reklamatsioon|Reklamatsioon| | | + | |
| - | |reclamationcomment|rekl_selgitus|Rekl. selgitus| | | + | |
| - | |asset|inventar|Inventar| | | + | |
| - | |datafield1|lisa_field1|| | | + | |
| - | |datafield2|lisa_field2|| | | + | |
| - | |datafield3|lisa_field3|| | | + | |
| - | |datafield4|lisa_field4|| | | + | |
| - | |datafield5|lisa_field5|| | | + | |
| - | |datafield6|lisa_field6|| | | + | |
| - | |datafield7|lisa_field7|| | | + | |
| - | |intcomment|sisekommentaar|Sisekommentaar| | | + | |
| - | |supplier_class|hankija_klass|Klass| | | + | |
| - | |supplier_vatcountry|hankija_maa_tasu|KM-maa| local = 0, EU = 1, export = 2 , ALT.FROM: customer > 0 | | + | |
| - | |supplier_regno|hankija_regnr1|Reg nr 1| | | + | |
| - | |supplier_vatregno|hankija_kmregnr|Km reg nr| | | + | |
| - | |supplier_type|hankija_tyyp|Tüüp| | | + | |
| - | |confirm|kinnita|Olek| " | + | |
| - | + | ||
| - | ==read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |account|konto|Konto| | | + | |
| - | |object|objekt|Objekt| | + | |
| - | |name|sisu|Sisu| | + | |
| - | |linetotalwovat|summa|Summa| | | + | |
| - | |vatcode|kmkood|KMK| | + | |
| - | |project|projekt|Projekt| | | + | |
| - | |customer|klient_kood|Klient| | | + | |
| - | |item|artikkel|Artikkel| | | + | |
| - | |quantity|kogus|Kogus| | | + | |
| - | |date1|r_aeg1|Algus| | | + | |
| - | |date2|r_aeg2|Lõpp| | | + | |
| - | |contract|leping|Leping| | | + | |
| - | |user|kasutaja|Kasutaja| | | + | |
| - | |oid|oid|OID| | | + | |
| - | |orderrn|trn|| | | + | |
| - | |asset|r_inventar|Inventar| | | + | |
| - | |price|myygihind|Müügihind| | | + | |
| - | |constant1|konstant1| | | | + | |
| - | |constant2|konstant2| | | | + | |
| - | |constant3|konstant3| | | | + | |
| - | |constant4|konstant4| | | | + | |
| - | |text1|tekst1|| | | + | |
| - | |text2|tekst2|| | | + | |
| - | |text3|tekst3|| | | + | |
| - | |text4|tekst4|| | | + | |
| - | |intcomment|r_sisekommentaar|Sisekommentaar| | | + | |
| - | |vatsum|km|KM| | | + | |
| - | |rn|rn|Nr| | | + | |
| - | + | ||
| - | ==manused == | + | |
| - | ^ XML väli ^ SQL väli ^ UI väli ^ Selgitus | + | |
| - | | element: data | attachment | + | |
| - | | element: | + | |
| - | | attributes: | + | |
| - | | name | attachment_name | + | |
| - | | description | + | |
| - | | code | kood | | Only for updating excisting attachments, | + | |
| - | | sharepoint_link | + | |
| - | | gdrive_link | + | |
| - | | ext_link | + | |
| - | + | ||
| - | ==Ostuarve transpordi parameetrid == | + | |
| - | ^ TÜÜP | + | |
| - | | XML | xd_autosupplier | + | |
| - | | XML | xd_autosupplier_autocode | + | |
| - | | XML | xd_update | + | |
| - | | XML | xd_supplier_update | + | |
| - | | XML | xd_object | + | |
| - | | XML | xd_confirm | + | |
| - | + | ||
| - | ===Tootmised === | + | |
| - | + | ||
| - | what=production | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==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| | " | + | |
| - | + | ||
| - | ==read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel| | | | + | |
| - | |name|nimetus| | | | + | |
| - | |sn|SN|SN/ | + | |
| - | |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| | | | + | |
| - | + | ||
| - | ===Lepingud === | + | |
| - | + | ||
| - | what=contract [[https:// | + | |
| - | + | ||
| - | == Päis: == | + | |
| - | ^ XML väli ^ SQL väli ^ UI väli ^ Selgitus | + | |
| - | | session_id | + | |
| - | | number | + | |
| - | | salestart | + | |
| - | | salesperiod | + | |
| - | | salesperiodtype | + | |
| - | | purchasestart | + | |
| - | | purchaseperiod | + | |
| - | | purchaseperiodtype | + | |
| - | | salesterm | + | |
| - | | purchasterm | + | |
| - | | priceformula | + | |
| - | | salesobject | + | |
| - | | purchaseobject | + | |
| - | | salescurrency | + | |
| - | | purchasecurrency | + | |
| - | | customer | + | |
| - | | customername | + | |
| - | | supplier | + | |
| - | | suppliername | + | |
| - | | project | + | |
| - | | stock | ladu | Ladu | ALT.FROM: tr.setting | + | |
| - | | purchasestart2 | + | |
| - | | salesend | + | |
| - | | purchasecontract | + | |
| - | | salescontract | + | |
| - | | comment | + | |
| - | | relatedcontract | + | |
| - | | language | + | |
| - | | resource | + | |
| - | | fine | viivis | + | |
| - | | salescost | + | |
| - | | purchasecost | + | |
| - | | class | klass | Klass | + | |
| - | | salescomment | + | |
| - | | purchasecomment | + | |
| - | | salescontractend | + | |
| - | | purchasecontractend | + | |
| - | | salesman | + | |
| - | | employee | + | |
| - | | supervisor | + | |
| - | | vatcountry | + | |
| - | | datafield1 | + | |
| - | | datafield2 | + | |
| - | | datafield3 | + | |
| - | | datafield4 | + | |
| - | | datafield5 | + | |
| - | | datafield6 | + | |
| - | | datafield7 | + | |
| - | | salescontact | + | |
| - | | purchasecontact | + | |
| - | | salesmanager | + | |
| - | | purchasemanager | + | |
| - | | salescontractstart | + | |
| - | | purchasecontractstart | + | |
| - | | salesperiodtypeperiod | + | |
| - | | orderer | + | |
| - | | manager2 | + | |
| - | | asset | inventar | + | |
| - | | salesemail | + | |
| - | | adupinvoices | + | |
| - | | finepercent | + | |
| - | | nextcontrol | + | |
| - | | status | + | |
| - | | salesphone | + | |
| - | | closed | + | |
| - | | customer_type | + | |
| - | | customer_regno | + | |
| - | | customer_class | + | |
| - | | customer_loyaltycard | + | |
| - | | supplier_regno | + | |
| - | | customtxtfield1 | + | |
| - | | customtxtfield2 | + | |
| - | + | ||
| - | ==read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |type|tyyp|| sales = 0; purchase = 1; rent = 2 | | + | |
| - | |code|kood|Kood| | | + | |
| - | |name|nimi|Nimi| ALT.FROM: item | | + | |
| - | |qty|kogus|Kogus| | | + | |
| - | |price|hind|Hind| | | + | |
| - | |discount|ale|%| | | + | |
| - | |object|objekt|Objekt| ALT.FROM: item | | + | |
| - | |project|projekt|Projekt| ALT.FROM: item | | + | |
| - | |account|konto|Konto| ALT.FROM: item > item class (depending on vatregion) | | + | |
| - | |vatcode|kmk|KM kood| ALT.FROM: customer > item > item class (depending on vatregion)| | + | |
| - | |actionplan|tegevusplaan|Tegevusplaan| | | + | |
| - | |start|r_aeg1|Algus| | | + | |
| - | |end|r_aeg2|Lõpp või rendi puhul Tegelik lõpp| | | + | |
| - | |user|tegija|Tegija| | | + | |
| - | |unit|yhik|Ühik| ALT.FROM: item | | + | |
| - | |asset|r_inventar|Inventar| | | + | |
| - | |status|r_staatus|Staatus- ainult rent tüüpi lepingul| | | + | |
| - | |intcomment|r_sisekommentaar|Sisekommentaar| | | + | |
| - | |comment|r_kommentaar|Kommentaar| | | + | |
| - | |end2|r_lopp|Arvatav lõpp ainult rent tüüpi lepingul| | | + | |
| - | |initialstart|r_algne_aeg2|| | | + | |
| - | |extid|ext_id|| | | + | |
| - | |customrowtxtfield1|customrowtxtfield1| | 255; customizable field| | + | |
| - | |customrowtxtfield2|customrowtxtfield2| | 255; customizable field| | + | |
| - | |customrowdecfield1|customrowdecfield1| | customizable field| | + | |
| - | |customrowdecfield2|customrowdecfield2| | customizable field| | + | |
| - | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | |
| - | |rr|rv|Rv|row reference for grouping, otherwise equals to rn , ALT.FROM: equals to rn | | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ===Projektid=== | + | |
| - | + | ||
| - | what=project | + | |
| - | [[https:// | + | |
| - | + | ||
| - | == 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! | | + | |
| - | |code|kood|Kood| 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 | | + | |
| - | |name|nimi|Nimi| | | + | |
| - | |manager|juht|Juht| | | + | |
| - | |members|liikmed|Liikmed| | | + | |
| - | |start|aeg1|Algus| | | + | |
| - | |end|aeg2|Lõpp| | | + | |
| - | |currency|valuuta|Valuuta| | | + | |
| - | |master|master|Peaprojekt| | | + | |
| - | |customer|klient_kood|Kliendi kood| ALT.FROM: using " | + | |
| - | |customerregno|klient_regnr|Kliendi reg.nr| | | + | |
| - | |customername|klient_nimi|Kliendi nimi| ALT.FROM: customer | | + | |
| - | |customercontact|kl_kontakt|Kl.kontakt| ALT.FROM: customer | | + | |
| - | |customercontactphone|kl_kontakt_telefon|Kliendi telefon| ALT.FROM: customer | | + | |
| - | |customercontactemail|kl_kontakt_email|Kliendi e-mail| ALT.FROM: customer | | + | |
| - | |supplier|hankija_kood|Hankija kood| ALT.FROM: using " | + | |
| - | |supplierregno|hankija_regnr|Hankija reg.nr| | | + | |
| - | |suppliername|hankija_nimi|Hankija nimi| ALT.FROM: supplier | | + | |
| - | |suppliercontact|h_kontakt|H.kontakt| ALT.FROM: supplier | | + | |
| - | |suppliercontactphone|h_kontakt_telefon|Hankija telefon| ALT.FROM: supplier | | + | |
| - | |suppliercontactemail|h_kontakt_email|Hankija email| ALT.FROM: supplier | | + | |
| - | |memo|memo|Memo| | | + | |
| - | |memo2|memo2|Memo2| | | + | |
| - | |plannedprofit|pl_kate|Plan.kate| | | + | |
| - | |url|url|Url| | | + | |
| - | |object|objekt|objekt| | | + | |
| - | |customerinventory|kl_inventar|Kl. inventar| | | + | |
| - | |type|proj_tyyp|Tüüp| ALT.FROM: tr.params | | + | |
| - | |address1|aadress1|Tänav| ALT.FROM: customer | | + | |
| - | |address2|aadress2|Indeks, | + | |
| - | |address3|aadress3|Maa| ALT.FROM: customer | | + | |
| - | |country|asumaa|Asumaa| ALT.FROM: customer | | + | |
| - | |county|maakond|Maakond| ALT.FROM: customer | | + | |
| - | |sraccount|lskonto|LS konto| | | + | |
| - | |contract|leping|Leping| | | + | |
| - | |orderer|tellija_kood|Tellija kood| | | + | |
| - | |orderername|tellija_nimi|Tellija nimi| ALT.FROM: orderer | | + | |
| - | |orderercontact|tl_kontakt|Tl.kontakt| ALT.FROM: orderer | | + | |
| - | |orderercontactphone|tl_kontakt_telefon|Tellija telefon| ALT.FROM: orderer | | + | |
| - | |orderercontactemail|tl_kontakt_email|Tellija email| ALT.FROM: orderer | | + | |
| - | |ordereraddress1|tellija_aadress1|Tellija tänav| ALT.FROM: orderer | | + | |
| - | |ordereraddress2|tellija_aadress2|Tellija Indeks, linn| ALT.FROM: orderer | | + | |
| - | |ordereraddress3|tellija_aadress3|Tellija maa| ALT.FROM: orderer | | + | |
| - | |orderercountry|tellija_asumaa|Tellija asumaa| ALT.FROM: orderer | | + | |
| - | |orderercounty|tellija_maakond|Tellija maakond| ALT.FROM: orderer | | + | |
| - | |payterm|tingimus|Tas.ting| ALT.FROM: customer | | + | |
| - | |status|staatus|staatus| ALT.FROM: tr.params | | + | |
| - | |closed|suletud|suletud| closed = 1, open = 0 | | + | |
| - | |contractend|garantii|Garantii%| | | + | |
| - | |worth|maksumus|Maksumus| | | + | |
| - | |costbudget|summa_kulud|Kulude eelarve| | | + | |
| - | |customer_vatregno|klient_kmregnumber|Kliendikaardil: | + | |
| - | |customer_vatzone|klient_maa|Kliendikaardil: | + | |
| - | |customer_type|klient_tyyp|Kliendikaardil: | + | |
| - | |customer_class|klient_klass|Kliendikaardil: | + | |
| - | |customer_loyaltycard|klient_kliendikaart|Kliendikaardil: | + | |
| - | + | ||
| - | ==read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |action|tegevus|Tegevus| ALT.FROM: item | | + | |
| - | |start|algus|Algus| | | + | |
| - | |manager|juht|Juht| | | + | |
| - | |workers|tegijad|Tegijad| | | + | |
| - | |comment|kommentaar|Kommentaar| | | + | |
| - | |Preliminiaryend|oletatav_lopp|Oletatav valmimisaeg| | | + | |
| - | |done|valmis|Valmis| | | + | |
| - | |actualend|tegelik_lopp|Tegelik valmimisaeg | | | + | |
| - | |sum|summa|Summa| | | + | |
| - | |plannedtime|aeg_raha1|Planeeritud| | | + | |
| - | |actualtime|aeg_raha2|Tegelik| | | + | |
| - | |points|punktid|Punktid| | | + | |
| - | |after|peale|Peale| | | + | |
| - | |event|event|| | | + | |
| - | |object|objekt|| | | + | |
| - | |item|r_artikkel|| | | + | |
| - | |quotation|pakkumine|| | | + | |
| - | |costs|kulud|Kulud| | | + | |
| - | |worker|teostaja|Teostaja| | | + | |
| - | |budget|eelarve|| | | + | |
| - | |amount|rea_kogus|| | | + | |
| - | |invoice|arve|| | | + | |
| - | |text1|tekst1|| | | + | |
| - | |text2|tekst2|| | | + | |
| - | |constant1|konstant1|Konstant1| | | + | |
| - | |constant2|konstant2|Konstant2| | | + | |
| - | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | |
| - | + | ||
| - | ==lisaväljad: | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |content|sisu|Sisu| | | + | |
| - | |param|param|Parameeter| | | + | |
| - | + | ||
| - | + | ||
| - | ===Sündmused === | + | |
| - | + | ||
| - | what=project | + | |
| - | [[https:// | + | |
| - | + | ||
| - | == 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! | | + | |
| - | |ext_unique_id|ext_unique_id|! according to settings, default field is ext_id| Needed for creating new events. Transport parameter " | + | |
| - | |code|kood|Sündmus| document number/ID used for updating events; It must be unique for each document and remain same if more than one transaction of the same document is necessary | | + | |
| - | |type|tyyp| | 32; UI |Sündmuse tüüp| | | + | |
| - | |status|status|Staatus| | | + | |
| - | |startdate|aeg1| | UI |Algus| | | + | |
| - | |enddate|aeg2| | UI |Lõpp| | | + | |
| - | |eventcontacttype|k_tyyp| | KLIENT or HANKIJA (customer or supplier) | | + | |
| - | |eventcontactcode|k_kood| | 32; UI |Kood| | | + | |
| - | |eventcontactname|k_nimi| | ALT.FROM: customer | | + | |
| - | |eventcontactperson|k_kontakt| | ALT.FROM: customer | | + | |
| - | |phone|k_telefon| | ALT.FROM: customer | | + | |
| - | |email|k_email| | ALT.FROM: customer | | + | |
| - | |address|k_aadress| | ALT.FROM: customer | | + | |
| - | |fax|k_faks| | 64; UI |Faks| | | + | |
| - | |project|projekt| | 32; UI |Projekt| | | + | |
| - | |assignedby|kasutaja| | 32; UI |Kasutaja| | | + | |
| - | |assignedto|tegija| | 32; UI |Tegija| | | + | |
| - | |description|sisu| | 4000 or infinite (slower); UI |Sündmuse kirjeldus| | | + | |
| - | |feedback|feedback| | 4000 or infinite (slower); UI |Tagasiside| | | + | |
| - | |object|objekt| | 255; UI |Objekt| | | + | |
| - | |comment|markus| | 255; UI |Märkus| | | + | |
| - | |priceformula|hinnavalem| | 32; UI |Hinnavalem| | | + | |
| - | |contract|leping| | UI |Leping| | | + | |
| - | |asset|inventar| | 32; UI |Inventar| | | + | |
| - | |priority|prioriteet| | 32; UI |Prioriteet| | | + | |
| - | |extid|ext_id| | 32; UI | do not use it if ext_unique_id is already used as ext_id field | | | + | |
| - | |sourceunit|src_unit| | 32; UI | Source | | | + | |
| - | |sourcenumber|src_number| | 32; UI | | | | + | |
| - | |item|artikkel| | | | + | |
| - | |itemname|artikkel| | | | + | |
| - | |customtxtfield1|customtxtfield1| | 255; customizable field| | | + | |
| - | |customtxtfield2|customtxtfield2| | 255; customizable field| | | + | |
| - | + | ||
| - | ==lisaväljad == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |content|sisu|Sisu| | | + | |
| - | |param|param|Parameeter| | | + | |
| - | + | ||
| - | ==allikad == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |sourceunit|src_unit| | 32; UI | Source | | | + | |
| - | |sourcenumber|src_number| | 32; UI | | | | + | |
| - | + | ||
| - | + | ||
| - | ===Ressursid === | + | |
| - | + | ||
| - | what=resource | + | |
| - | [[https:// | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | == Päis: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | | | + | |
| - | |ext_unique_id|ext_unique_id| | | | + | |
| - | |number|number| | | | + | |
| - | |date|aeg| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |customer|vaik_klient_kood| | | | + | |
| - | |employee|vaik_tegija| | | | + | |
| - | |stock|ladu| | | | + | |
| - | |project|projekt| | | | + | |
| - | |asset|inventar| | | | + | |
| - | |datafield1|lisa_field1| | | | + | |
| - | |datafield2|lisa_field2| | | | + | |
| - | |datafield3|lisa_field3| | | | + | |
| - | |datafield4|lisa_field4| | | | + | |
| - | |datafield5|lisa_field5| | | | + | |
| - | |datafield6|lisa_field6| | | | + | |
| - | |datafield7|lisa_field7| | | | + | |
| - | |object|objekt| | | | + | |
| - | |confirm|kinnita| | | | + | |
| - | + | ||
| - | == Read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel| | | | + | |
| - | |quantity|kogus| | | | + | |
| - | |date|aeg| | | | + | |
| - | |description|nimetus| | | | + | |
| - | |price|hind| | | | + | |
| - | |discount|ale| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |event|event| | | | + | |
| - | |purchaseprice|fifo| | | | + | |
| - | |unit|yhik| | | | + | |
| - | |employee|tegija| | | | + | |
| - | |invoiced|arvega| | | | + | |
| - | |contract|leping| | | | + | |
| - | |timewindow1|aeg_aken1| | | | + | |
| - | |timewindow2|aeg_aken2| | | | + | |
| - | |project|projekt| | | | + | |
| - | |sum|summa| | | | + | |
| - | |customer|klient_kood| | | | + | |
| - | |customername|klient_nimi| | | | + | |
| - | |stock|r_ladu| | | | + | |
| - | |vatcode|kmk| | | | + | |
| - | |contact|kontakt| | | | + | |
| - | |object|objektid| | | | + | |
| - | |closed|suletud| | | | + | |
| - | |initialqty|kogus_alg| | | | + | |
| - | |finishedqty|kogus_tehtud| | | | + | |
| - | |stopped|peatutud| | | | + | |
| - | |customerqty|klient_kogus| | | | + | |
| - | |sn|sn| | | | + | |
| - | |constant1|konstant1| | | | + | |
| - | |constant2|konstant2| | | | + | |
| - | |constant3|konstant3| | | | + | |
| - | |constant4|konstant4| | | | + | |
| - | |asset|r_inventar| | | | + | |
| - | |capitalasset|pohivara| | | | + | |
| - | |shelf|riiul| | | | + | |
| - | |department|osakond| | | | + | |
| - | |text1|tekst1| | | | + | |
| - | |text2|tekst2| | | | + | |
| - | |text3|tekst3| | | | + | |
| - | |text4|tekst4| | | | + | |
| - | |delete|kustuta| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | ===Kasutajad === | + | |
| - | + | ||
| - | what=user | + | |
| - | [[https:// | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ==Kasutajad == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |session_id|x| | for internal use at Directo side, do not send this field! | | + | |
| - | |code|kood|Kood| 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 | | + | |
| - | |name|nimi| | | | + | |
| - | |group|grupp| | | | + | |
| - | |email|email| | | | + | |
| - | |stock|ladu| | | | + | |
| - | |series|Field19| | | | + | |
| - | |object|objekt| | | | + | |
| - | |priceformula|hinnavalem| | | | + | |
| - | |closed|suletud| | | | + | |
| - | |gender|sugu| | | | + | |
| - | |dateofbirth|synniaeg| | | | + | |
| - | |homeaddress|k_aadress| | | | + | |
| - | |homeaddress2|k_aadress2| | | | + | |
| - | |homeaddress3|k_aadress3| | | | + | |
| - | |county|k_maakond| | | | + | |
| - | |officeaddress|t_aadress| | | | + | |
| - | |bank|pank| | | | + | |
| - | |accountno|arveldusarve| | | | + | |
| - | |homephone|telefon_kodu| | | | + | |
| - | |officephone|telefon_too| | | | + | |
| - | |mobilephone|telefon_tasku| | | | + | |
| - | |incometaxfree|meetod_tulumaks| | | | + | |
| - | |vacation|meetod_puhkus| | | | + | |
| - | |socialtax|meetod_sotsmaks| | | | + | |
| - | |pid|isikukood| | | | + | |
| - | |livingplace|elukoht| | | | + | |
| - | |language|keel| | | | + | |
| - | |account|konto| | | | + | |
| - | |personnel|personal| | | | + | |
| - | |nameinbank|nimi_pangas| | | | + | |
| - | |resident|resident| | | | + | |
| - | |skype|skype| | | | + | |
| - | |intcode|int_kood| | | | + | |
| - | |extraobject|lisa_objekt| | | | + | |
| - | |payday|palgapaev| | | | + | |
| - | |healthinsurance|ravikindlustus| | | | + | |
| - | |salaryemail|email_palk| | | | + | |
| - | |pdfpassword|per_pass| | | | + | |
| - | |reservcost|reserv_kulu_konto| | | | + | |
| - | |reservliability|reserv_kohustus_konto| | | | + | |
| - | |pricegroup|hinnagrupp| | | | + | |
| - | |averagebaseinmonth|kesk_kuud| | | | + | |
| - | |sessiontime|session_time| | | | + | |
| - | |country|maa| | | | + | |
| - | |averagefee|kesk_alus| | | | + | |
| - | |workingtimecalc|tooaja_arvest| | | | + | |
| - | |toraddressid|t_aadress_id| | | | + | |
| - | + | ||
| - | ==lisaväljad == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |code|kood| | | | + | |
| - | |content|sisu|Sisu| | | + | |
| - | |param|param|Parameeter| | | + | |
| - | + | ||
| - | ==töösuhe == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |type|tyyp| | | | + | |
| - | |contract|leping| | | | + | |
| - | |started|aeg1| | | | + | |
| - | |finished|aeg2| | | | + | |
| - | |date|aeg| | | | + | |
| - | |signer|allkirjastaja| | | | + | |
| - | |department|osakond| | | | + | |
| - | |occupation|amet| | | | + | |
| - | |superior|ylemus| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |rn|rn| | | | + | |
| - | |stage|etapp| | | | + | |
| - | |workload|koormus| | | | + | |
| - | |endreason|lop_alus| | | | + | |
| - | |closed|suletud| | | | + | |
| - | |workscheduleitems|graafiku_artiklid| | | | + | |
| - | |personsubstituted|asendatav| | | | + | |
| - | |rr|rv| | | | + | |
| - | |arn|a_rn| | | | + | |
| - | + | ||
| - | ==haridus == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |type|tyyp| | | | + | |
| - | |code|tunnistus| | | | + | |
| - | |qualification|eriala| | | | + | |
| - | |issuedby|asutus| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |startdate|aeg1| | | | + | |
| - | |enddate|aeg2| | | | + | |
| - | |level|tase| | | | + | |
| - | |description|nimetus| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | ==dokumendid == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |type|tyyp| | | | + | |
| - | |code|dokument| | | | + | |
| - | |name|nimetus| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |startdate|aeg1| | | | + | |
| - | |enddate|aeg2| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | ==isikud == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |type|tyyp| | | | + | |
| - | |idnumber|isikukood| | | | + | |
| - | |name|nimi| | | | + | |
| - | |phone|telefon| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | ==valemid == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |formula|valem| | | | + | |
| - | |user|kasutaja| | | | + | |
| - | |price|hind| | | | + | |
| - | |comment|kirjeldus| | | | + | |
| - | |startdate|aeg1| | | | + | |
| - | |enddate|aeg2| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | ==kasutaja maksud == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |formula|valem| | | | + | |
| - | |startdate|algus| | | | + | |
| - | |enddate|lopp| | | | + | |
| - | |taxfree|maksuvaba| | | | + | |
| - | |taxfreestartdate|mv_algus| | | | + | |
| - | |taxfreeenddate|mv_lopp| | | | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | ===Puudumised === | + | |
| - | + | ||
| - | what=absence | + | |
| - | [[https:// | + | |
| - | + | ||
| - | ==Puudumised == | + | |
| - | ^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|Laekumine| 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 | | + | |
| - | |date1|aeg1| | | | + | |
| - | |date2|aeg2| | | | + | |
| - | |comment|selgitus| | | | + | |
| - | |employeecode|persoon| | | | + | |
| - | |delete|kustuta| | " | + | |
| - | |customtxtfield1|customtxtfield1| | 255; customizable field| | + | |
| - | |customtxtfield2|customtxtfield2| | 255; customizable field| | + | |
| - | + | ||
| - | ==read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |employeecode|persoon| | | | + | |
| - | |absencetype|r_liik| | | | + | |
| - | |date1|r_aeg1| | | | + | |
| - | |date2|r_aeg2| | | | + | |
| - | |newend|uus_lopp| | | | + | |
| - | |comment|kommentaar| | | | + | |
| - | |inadvance|ette| | | | + | |
| - | |substitute|asendaja| | | | + | |
| - | |customrowtxtfield1|customrowtxtfield1| | 255; customizable field| | + | |
| - | |customrowtxtfield2|customrowtxtfield2| | 255; customizable field| | + | |
| - | |customrowdecfield1|customrowdecfield1| | customizable field| | + | |
| - | |customrowdecfield2|customrowdecfield2| | customizable field| | + | |
| - | |rn|rn| | | | + | |
| - | + | ||
| - | ==== Väljundid ==== | + | |
| - | + | ||
| - | === Pakkumised (quotation) === | + | |
| - | * what=quotation [[https:// | + | |
| - | + | ||
| - | === Artiklid (Items) === | + | |
| - | * what=item | + | |
| - | + | ||
| - | == Artikli laolimiidid (Item stock limits) == | + | |
| - | * what=itemstocklimit [[https:// | + | |
| - | + | ||
| - | == Artikli pakendid (Item packages) == | + | |
| - | * what=itempackage [[https:// | + | |
| - | + | ||
| - | == Seotud artikli (Item relations) == | + | |
| - | * what=itemrelitem [[https:// | + | |
| - | + | ||
| - | == Artikli KM koodid ja kontod (Item VAT codes and Account codes) == | + | |
| - | * what=itemaccountvatcode [[https:// | + | |
| - | ws_artiklid_kontod_kmkoodid | + | |
| - | + | ||
| - | === Kliendid (Customers) === | + | |
| - | + | ||
| - | * what=customer [[https:// | + | |
| - | + | ||
| - | === Hankijad (Suppliers) === | + | |
| - | + | ||
| - | * what=supplier | + | |
| - | * [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | + | ||
| - | + | ||
| - | === Kontaktid (contact) === | + | |
| - | + | ||
| - | * what=contact | + | |
| - | * [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | + | ||
| - | === Laod(stock) === | + | |
| - | + | ||
| - | * what=stock | + | |
| - | * [[https:// | + | |
| - | * Filtrid: code | + | |
| - | === Laoseis (Stock levels) === | + | |
| - | * what=stocklevel [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | **Laoseis tegelik ilma vaba koguse arvutuseta ning vaba laoseisu mõjutavad kogused (allocations) ** | + | |
| - | * what=stocklevel_variant_sn [[https:// | + | |
| - | * Filtrid: | + | |
| - | * what=allocation [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | * **Info:** Sisaldab koguseid,et arvutada vaba laoseisu. Kasutamiseks juurde liita ja lahutada erinevatelt sisenenvatelt ja väljuvatelt dokumentidelt vaba laoseisu arvutuseks. Kasutada koos laoseisu väljundiga '' | + | |
| - | + | ||
| - | === Hinnavalemi read (Price formula rows) === | + | |
| - | + | ||
| - | * what=priceformularow [[https:// | + | |
| - | + | ||
| - | === Artikli klassid (Item classes) === | + | |
| - | + | ||
| - | * what=itemclass [[https:// | + | |
| - | + | ||
| - | + | ||
| - | === Artikliajalugu (itemhistoryrow) === | + | |
| - | + | ||
| - | * what=itemhistoryrow [[https:// | + | |
| - | + | ||
| - | === Retseptid (recipe) === | + | |
| - | + | ||
| - | * what=recipe[[https:// | + | |
| - | + | ||
| - | + | ||
| - | === Arved (Invoices) === | + | |
| - | + | ||
| - | * what=invoice [[https:// | + | |
| - | === Tellimused (Orders) === | + | |
| - | + | ||
| - | * what=order [[https:// | + | |
| - | + | ||
| - | === Finantskanded (Transactions) ja Finantskande read (Transactionrows) === | + | |
| - | + | ||
| - | * what=transaction [[https:// | + | |
| - | * what=transactionrow [[https:// | + | |
| - | + | ||
| - | === Laekumised (Receipts) === | + | |
| - | + | ||
| - | * what=receipt [[https:// | + | |
| - | + | ||
| - | === Kulutused (expense) === | + | |
| - | + | ||
| - | * what=expense[[https:// | + | |
| - | + | ||
| - | + | ||
| - | === Lähetused (delivery) === | + | |
| - | + | ||
| - | * what=delivery[[https:// | + | |
| - | + | ||
| - | + | ||
| - | === Tagastused (stockreturn) === | + | |
| - | + | ||
| - | * what=delivery[[https:// | + | |
| - | + | ||
| - | === Inventuurid (taking) === | + | |
| - | + | ||
| - | * what=taking[[https:// | + | |
| - | + | ||
| - | + | ||
| - | === Mahakandmised (writeoff) === | + | |
| - | + | ||
| - | * what=taking[[https:// | + | |
| - | + | ||
| - | === Liikumised(movement) === | + | |
| - | + | ||
| - | * what=movement[[https:// | + | |
| - | + | ||
| - | + | ||
| - | === Laotellimused(stockorder) === | + | |
| - | + | ||
| - | * what=stockorder[[https:// | + | |
| - | === Ostutellimused (purchaseorder) === | + | |
| - | + | ||
| - | * what=purchaseorder [[https:// | + | |
| - | + | ||
| - | === Sissetulekud (stockreceipt) === | + | |
| - | + | ||
| - | * what=stockreceipt [[https:// | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | === Ostuarved (Purchase) === | + | |
| - | + | ||
| - | * what=purchase [[https:// | + | |
| - | + | ||
| - | === Tootmised (production) === | + | |
| - | + | ||
| - | * what=purchase [[https:// | + | |
| - | + | ||
| - | + | ||
| - | === Kontod (account) === | + | |
| - | + | ||
| - | * what=account[[https:// | + | |
| - | === Objektid (object) === | + | |
| - | + | ||
| - | * what=object [[https:// | + | |
| - | + | ||
| - | + | ||
| - | === Varad (asset) === | + | |
| - | + | ||
| - | * what=object [[https:// | + | |
| - | + | ||
| - | === Lepingud(contract) === | + | |
| - | * what=project [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | === Projektid (project) === | + | |
| - | * what=project [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | + | ||
| - | === Sündmused(event) === | + | |
| - | * what=event [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | + | ||
| - | + | ||
| - | === Ressursid (resource) === | + | |
| - | * what=resource [[https:// | + | |
| - | * Filtrid: number, | + | |
| - | + | ||
| - | + | ||
| - | === Kasutajad(user) === | + | |
| - | * what=user[[https:// | + | |
| - | * Filtrid: code, | + | |
| - | + | ||
| - | === Puudumised (absence) === | + | |
| - | * what=absence[[https:// | + | |
| - | * Filtrid: number, | + | |
| - | + | ||
| - | === Asenduste log (Replacement log ) === | + | |
| - | Customer code replacements | + | |
| - | * what=replacementlog [[https:// | + | |
| - | + | ||
| - | === Kustutatud dokumendid (Deleted documents ) === | + | |
| - | + | ||
| - | * what=delete [[https:// | + | |
| - | + | ||
et/xml_direct.1777527605.txt.gz · Viimati muutnud: 2026/04/30 08:40 persoon toomas