en:xml_direct
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| en:xml_direct [2025/07/30 14:58] – [Hind] toomas | en:xml_direct [2026/08/19 10:43] (current) – toomas | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | FIXME **This page is not fully translated, yet. Please help completing the translation.**\\ //(remove this paragraph once the translation is finished)// | + | {{page>en:xml_direct:start}} |
| - | + | ||
| - | ======XML Direct ====== | + | |
| - | =====Introduction ===== | + | |
| - | XML Direct is a standardized interface that operates through a common access point and consists of components that can be selected individually as needed. | + | |
| - | + | ||
| - | The fields of all components are fixed – this means that the data format and structure are uniform across all Directo customer bases. Developments are made based on the principle of a shared solution, and activating the interface does not require any customization from Directo. | + | |
| - | + | ||
| - | The interface allows for the creation of multiple different API keys to provide secure access to multiple partners. Each API key can have access only to selected components, which increases flexibility and information security. | + | |
| - | + | ||
| - | Before implementation, | + | |
| - | + | ||
| - | =====API Key ===== | + | |
| - | To find the interface XML key and provide it to the developer: | + | |
| - | + | ||
| - | - Log in to Directo with a user who has '' | + | |
| - | - Since there can be multiple API keys, you need to open the employee card for whom the key has been created. For example, open the employee card ' | + | |
| - | - Go to the '' | + | |
| - | - Go to the '' | + | |
| - | - On the line of the required interface, press the button {{: | + | |
| - | + | ||
| - | =====Access to the Interface (URL) ===== | + | |
| - | Access to the interface is via the POST method, form/ | + | |
| - | + | ||
| - | A token must be used for access (see the '' | + | |
| - | + | ||
| - | **curl example ** | + | |
| - | < | + | |
| - | curl --location ' | + | |
| - | --header ' | + | |
| - | --data-urlencode ' | + | |
| - | --data-urlencode ' | + | |
| - | --data-urlencode ' | + | |
| - | --data-urlencode ' | + | |
| - | </ | + | |
| - | + | ||
| - | + | ||
| - | =====Price ====== | + | |
| - | The price depends on the selected components. \\ | + | |
| - | The output of deleted documents is included in the price and is free of charge. | + | |
| - | + | ||
| - | The price for an additional API key is €0 per month. \\ | + | |
| - | If multiple API keys have the same components, the fee for them is charged only once. | + | |
| - | + | ||
| - | **Example: ** \\ | + | |
| - | + | ||
| - | * API key A contains outputs: customer and item | + | |
| - | * API key B contains outputs: customer and order | + | |
| - | → In this case, the fee is only for three unique components: customer, item, and order. | + | |
| - | =====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 toetab ka vaikeväärtuste seadistamist. | + | |
| - | + | ||
| - | =====Komponendid ===== | + | |
| - | **Valitavad komponendid** | + | |
| - | ^ Komponent (what) | + | |
| - | | Tellimused (order) | + | |
| - | | Arved (invoice ) | + | |
| - | | Laekumised (receipt) | + | |
| - | | Kliendid (customer) | + | |
| - | | Hankijad (supplier) | + | |
| - | | Artiklid (item) | + | |
| - | | Artiklid: | + | |
| - | | Artiklid: | + | |
| - | | Artiklid: | + | |
| - | | Artikliklassid (itemclass) | + | |
| - | | Laoseis (stocklevel) | + | |
| - | | Laoseis seerianumbritega (stocklevel_sn) | + | |
| - | | Laoseis variantidega (stocklevel_variant) | + | |
| - | | Hinnavalemi read (priceformularow) | + | |
| - | | Ostuarved (purchase) | + | |
| - | | Finantskanded (transaction) | + | |
| - | | Ressursid (resource) | + | |
| - | | Kustutatud dokumendid | + | |
| - | + | ||
| - | ====Sisendid ==== | + | |
| - | + | ||
| - | ===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^KOOD^PARAMEETER 1^PARAMEETER 2^SELGITUS^ | + | |
| - | |XML|xd_changestock|0|INVOICE|Ladumuutev arve (Param.1 =1 on muuda ladu)| | + | |
| - | |XML|xd_autocustomer_autocode|0|INVOICE|Seotud kliendi loomisel luuakse kood liideses, unikaalne email on vajalik ja kliendi koodi süsteemiseadistused on vajalikud| | + | |
| - | |XML|xd_update|1|INVOICE|Luba dokumendi update, kui puuduvad seotud dokumendid| | + | |
| - | |XML|xd_customer_update|0|INVOICE|Kliendi andmete osaline update, (nimi, email, telefon) või vastavalt spekile| | + | |
| - | |XML|xd_object|TEST_OBJEKT|INVOICE|Vaikimisi objekt, kui ei saadeta| | + | |
| - | |XML|xd_salesman|XML|INVOICE|Vaikimisi müüja| | + | |
| - | |XML|xd_stock|PL|INVOICE|Vaikimisi ladu, kui ei saadeta| | + | |
| - | |XML|xd_confirm|0|INVOICE|Automaatne dokumendi kinnitamine, | + | |
| - | |XML|xd_posinvoice|0|INVOICE|1 = kassaarve| | + | |
| - | |XML|xd_autocustomer|0|INVOICE|Automaatne seotud kliendi loomine, kui kliendi koodi ei eksisteeri| | + | |
| - | + | ||
| - | 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^KOOD^PARAMEETER 1^PARAMEETER 2^SELGITUS^ | + | |
| - | |XML|xd_stock|PL|ORDER|Vaikimisi ladu, kui ei saadeta| | + | |
| - | |XML|xd_object|VEEB|ORDER|Vaikimisi objekt, kui ei saadeta| | + | |
| - | |XML|xd_autocustomer|1|ORDER|Automaatne seotud kliendi loomine, kui kliendi koodi ei eksisteeri| | + | |
| - | |XML|xd_confirm|0|ORDER|Automaatne dokumendi kinnitamine, | + | |
| - | |XML|xd_update|1|ORDER|Luba dokumendi update, kui puuduvad seotud dokumendid| | + | |
| - | |XML|xd_autocustomer_autocode|0|ORDER|Seotud kliendi loomisel luuakse kood liideses, unikaalne email on vajalik ja kliendi koodi süsteemiseadistused on vajalikud| | + | |
| - | |XML|xd_customer_update|0|ORDER|Kliendi andmete osaline update, (nimi, email, telefon) või vastavalt spekile| | + | |
| - | |XML|xd_salesman|XML|ORDER|Vaikimisi müüja|x | + | |
| - | |XML|xd_confirmpayment|1|ORDER|Automaatne laekumise kinnitamine| | + | |
| - | |XML|xd_paymentvatcode|11|ORDER|Loodava seotud laekumise rea km kood, laekumine tekib välja „paymentamount“ saatmisel, mis peab skeemis olemas olema | | + | |
| - | |XML|xd_order_assemble|1|ORDER|Käivitab tellimuse komplekteerija retseptidega artiklitele | | + | |
| - | + | ||
| - | 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 | | + | |
| - | + | ||
| - | ===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 | | + | |
| - | + | ||
| - | ===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| | | + | |
| - | + | ||
| - | + | ||
| - | ===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 | | + | |
| - | + | ||
| - | + | ||
| - | ===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! | | + | |
| - | |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^ | + | |
| - | |name |attachment_name | | | | + | |
| - | |description |attachment_kirjeldus | | | | + | |
| - | |code |kood| | for updating excisting attachments, | + | |
| - | |sharepoint_link |cloud_preview_query| | external Sharepoint attachment link | | + | |
| - | |gdrive_link |cloud_gdrive| | external Google Drive attachment link | | + | |
| - | |ext_link|cloud_ext_link | | external attachment link, must be full external link starting with < | + | |
| - | + | ||
| - | ==Ostuarve transpordi parameetrid == | + | |
| - | ^ TÜÜP | + | |
| - | | XML | xd_autosupplier | + | |
| - | | XML | xd_autosupplier_autocode | + | |
| - | | XML | xd_update | + | |
| - | | XML | supplier_update | + | |
| - | | XML | xd_object | + | |
| - | | XML | xd_confirm | + | |
| - | + | ||
| - | + | ||
| - | ===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| | | | + | |
| - | + | ||
| - | ==== Väljundid ==== | + | |
| - | + | ||
| - | === 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:// | + | |
| - | + | ||
| - | === Kliendid (Customers) === | + | |
| - | + | ||
| - | * what=customer [[https:// | + | |
| - | + | ||
| - | === Hankijad (Suppliers) === | + | |
| - | + | ||
| - | * what=supplier | + | |
| - | * [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | + | ||
| - | === Laoseis (Stock levels) === | + | |
| - | * what=stocklevel [[https:// | + | |
| - | * what= stocklevel_sn [[https:// | + | |
| - | * what=stocklevel_variant [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | + | ||
| - | === Hinnavalemi read (Price formula rows) === | + | |
| - | + | ||
| - | * what=priceformularow [[https:// | + | |
| - | + | ||
| - | === Artikli klassid (Item classes) === | + | |
| - | + | ||
| - | * what=itemclass [[https:// | + | |
| - | + | ||
| - | === Arved (Invoices) === | + | |
| - | + | ||
| - | * what=invoice [[https:// | + | |
| - | + | ||
| - | === Tellimused (Orders) === | + | |
| - | + | ||
| - | * what=order [[https:// | + | |
| - | + | ||
| - | === Finantskanded (Transactions) === | + | |
| - | + | ||
| - | * what=transaction [[https:// | + | |
| - | + | ||
| - | === Laekumised (Receipts) === | + | |
| - | + | ||
| - | * what=receipt [[https:// | + | |
| - | + | ||
| - | === Ostuarved (Purchase) === | + | |
| - | + | ||
| - | * what=purchase [[https:// | + | |
| - | + | ||
| - | === Ressursid (Resources) === | + | |
| - | * what=resource [[https:// | + | |
| - | * Filtrid: number, | + | |
| - | + | ||
| - | === Kustutatud dokumendid (Deleted documents ) === | + | |
| - | + | ||
| - | * what=delete [[https:// | + | |
| - | + | ||
en/xml_direct.1753876738.txt.gz · Last modified: 2025/07/30 14:58 by toomas