Siin näed erinevusi valitud versiooni ja hetkel kehtiva lehekülje vahel.
Next revision | Previous revision | ||
et:xml_direct [2024/01/04 11:00] toomas tekitatud |
et:xml_direct [2024/03/22 11:44] (Hetkel kehtiv) toomas [Ligipääs liidesele (URL)] |
||
---|---|---|---|
Rida 1: | Rida 1: | ||
======XML Direct ====== | ======XML Direct ====== | ||
=====Tutvustus ===== | =====Tutvustus ===== | ||
- | XML Direct on ühispöördumispunkitga liides kus iga komponent on eraldi valitav. Liidese kompondite väljad on "lukus" ning alati ühesugused kõikides baasides. Arendused toimuvad jagatud lahenduse põhimõttel. Liides on aktiveeritav ning ei vaja Directo poolset arendust. Kokku on vaja leppida vajalikud komponendid. | + | XML Direct on ühispöördumispunkitga liides, mille iga komponent on eraldi valitav. Liidese komponentide väljad on "lukus" ning alati ühesugused kõikides baasides. Arendused toimuvad jagatud lahenduse põhimõttel. Liides on aktiveeritav ning ei vaja Directo poolset arendust. Kokku on vaja leppida vajalikud komponendid. |
=====Ligipääs liidesele (URL) ===== | =====Ligipääs liidesele (URL) ===== | ||
Rida 18: | Rida 18: | ||
</code> | </code> | ||
+ | **Postman näide ** \\ | ||
+ | Väljund ja Sisend [[https://www.postman.com/|Postman]] keskkonna jaoks saab alla laadida {{:et:directoxmlcoretest.postman_collection.json|siit }}ning siis importida Collectionina Postmani ning seal testida. | ||
=====Hind ====== | =====Hind ====== | ||
Hind vastavalt valitud komponentidele. Kustutatud dokumentide väljund on tasuta komplektis kaasas. | Hind vastavalt valitud komponentidele. Kustutatud dokumentide väljund on tasuta komplektis kaasas. | ||
Rida 170: | Rida 172: | ||
|datafield6|lisa_field6|Lisaväli 6, ! või vastavalt seadetele| | | |datafield6|lisa_field6|Lisaväli 6, ! või vastavalt seadetele| | | ||
|datafield7|lisa_field7|Lisaväli 7, ! või vastavalt seadetele| | | |datafield7|lisa_field7|Lisaväli 7, ! või vastavalt seadetele| | | ||
- | |paymenttotal|laekumine_summa| | positive number will create receipt with same doc. number | | + | |paymenttotal|laekumine_summa| | Nullist suurema summa puhul luuakse laekumin sama dokumendi numbriga ning KM kood võetakse tellimuse ridadelt. Vajalik et | |
|vatzone|maa|Maa| local = 0, EU = 1, export = 2 , ALT.FROM: customer > 0 | | |vatzone|maa|Maa| local = 0, EU = 1, export = 2 , ALT.FROM: customer > 0 | | ||
|priceformula|hinnakiri|Hinnavalem| | | |priceformula|hinnakiri|Hinnavalem| | | ||
Rida 179: | Rida 181: | ||
|status|staatus|Staatus| | | |status|staatus|Staatus| | | ||
|delivery|lahetusaeg|Lähetusaeg| | | |delivery|lahetusaeg|Lähetusaeg| | | ||
- | |customer_type|klient_tyyp|Kliendikaardil: Tüüp| company = 0, private citizen = 1, government institution = 2 | | + | |customer_type|klient_tyyp|Kliendikaardil: Tüüp| ettevõte = 0, eraisik = 1, government institution = 2 | |
|customer_regno|klient_regnr|Kliendikaardil: Reg nr| | | |customer_regno|klient_regnr|Kliendikaardil: Reg nr| | | ||
|customer_loyaltycard|klient_kliendikaart|Kliendikaardil: Kliendikaart| | | |customer_loyaltycard|klient_kliendikaart|Kliendikaardil: Kliendikaart| | | ||
+ | |salesman|myyja|Müügiagent| ALT.FROM: tr.params > 'XML' | | ||
== Read: == | == Read: == | ||
Rida 187: | Rida 190: | ||
|item|artikkel|Artikkel| | | |item|artikkel|Artikkel| | | ||
|description|nimetus|Sisu|ALT.FROM: item | | |description|nimetus|Sisu|ALT.FROM: item | | ||
- | |price|yhikuhind|Ühikuhind|unit price without vat | | + | |price|yhikuhind|Ühikuhind| ühikuhind ilma KM-ta | |
|quantity|kogus|Kogus| | | |quantity|kogus|Kogus| | | ||
|discount|pross|%| | | |discount|pross|%| | | ||
- | |account|konto|Konto|ALT.FROM: item > item class (depending on vatregion) | | + | |account|konto|Konto|ALT.FROM: item > item class (sõltuvalt KM maast) | |
|vatcode|kmkood|KMk|ALT.FROM: customer > item > item class (depending on vatregion) | | |vatcode|kmkood|KMk|ALT.FROM: customer > item > item class (depending on vatregion) | | ||
|unit|yhik|Ühik| ALT.FROM: item | | |unit|yhik|Ühik| ALT.FROM: item | | ||
Rida 213: | Rida 216: | ||
|XML|xd_confirmpayment|1|ORDER|Automaatne laekumise kinnitamine| | |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_paymentvatcode|11|ORDER|Loodava seotud laekumise rea km kood, laekumine tekib välja „paymentamount“ saatmisel, mis peab skeemis olemas olema | | ||
+ | |||
+ | ===Laekumised === | ||
+ | what=receipt | ||
+ | [[https://login.directo.ee/xmlcore/cap_xml_direct/xml_IN_laekumised.xsd|Skeem ]] | ||
+ | |||
+ | == Päis: == | ||
+ | |||
+ | ^XML väli^SQL väli^UI väli^Selgitus^ | ||
+ | |session_id|x| | for internal use at Directo side, do not send this field! | | ||
+ | |number|number|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 > 'EUR' | | ||
+ | |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://login.directo.ee/xmlcore/cap_xml_direct/xml_IN_kanded.xsd|Skeem ]] | ||
+ | |||
+ | == Päis: == | ||
+ | |||
+ | ^XML väli^SQL väli^UI väli^Selgitus^ | ||
+ | |session_id|x| | for internal use at Directo side, do not send this field! | | ||
+ | |number|number|Number| document number/ID, mandatory; With combination of field "type" it must be unique for each document and remain same if more than one transaction of the same document is necessary | | ||
+ | |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| ALT.FROM: account | | ||
+ | |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 > 'EUR' | | ||
+ | |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=== | ===Kliendid=== | ||
Rida 224: | Rida 301: | ||
^XML väli^SQL väli^UI väli^Selgitus^ | ^XML väli^SQL väli^UI väli^Selgitus^ | ||
|session_id|x| | for internal use at Directo side, do not send this field! | | |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 | | ||
|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 | | |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| | | |name|nimi|Nimi| | | ||
Rida 272: | Rida 348: | ||
|vatcode|kmkood|KM kood| | | |vatcode|kmkood|KM kood| | | ||
|extcode|valine_kood|Väline 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| | | | |closed|suletud| | | | ||
- | ==Lisaväljad: == | + | == Lisaväljad: ==== |
^XML väli^SQL väli^UI väli^Selgitus^ | ^XML väli^SQL väli^UI väli^Selgitus^ | ||
|code|kood| | | | |code|kood| | | | ||
|content|sisu|Sisu| | | |content|sisu|Sisu| | | ||
|param|param|Parameeter| | | |param|param|Parameeter| | | ||
+ | |||
==Kliendi transpordi parameetrid == | ==Kliendi transpordi parameetrid == | ||
Rida 292: | Rida 371: | ||
* Item classes what=itemclass [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_artikliklassid.xsd|Skeem ]] \\ Filtrid: code,master | * Item classes what=itemclass [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_artikliklassid.xsd|Skeem ]] \\ Filtrid: code,master | ||
* Invoices what=invoice [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_arved.xsd|Skeem ]] \\ Filtrid: number,customercode,transactiondate,date1,date2,ts | * Invoices what=invoice [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_arved.xsd|Skeem ]] \\ Filtrid: number,customercode,transactiondate,date1,date2,ts | ||
+ | * Orders what=order [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_tellimused.xsd|Skeem ]] \\ Filtrid: number,date1,date2,ts | ||
+ | * Transactions what=transaction [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_kanded.xsd|Skeem ]] \\ Filtrid: number,date1,date2,ts | ||
+ | * Receipts what=receipt [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_laekumised.xsd|Skeem ]] \\ Filtrid: number,date1,date2,ts | ||
* Deleted documents what=delete [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_kustutamised.xsd|Skeem ]] \\ Filtrid: number,code,document,ts | * Deleted documents what=delete [[https://login.directo.ee/xmlcore/cap_xml_direct/ws_kustutamised.xsd|Skeem ]] \\ Filtrid: number,code,document,ts | ||