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/08/04 09:14] – [Artiklid] toomas | en:xml_direct [2025/12/18 12:50] (current) – [Access to the Interface (URL)] 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)// | ||
| - | |||
| ======XML Direct ====== | ======XML Direct ====== | ||
| =====Introduction ===== | =====Introduction ===== | ||
| Line 39: | Line 37: | ||
| A token must be used for access (see the '' | A token must be used for access (see the '' | ||
| - | **curl example | + | {{page> |
| + | |||
| + | ====curl example | ||
| < | < | ||
| curl --location ' | curl --location ' | ||
| Line 49: | Line 49: | ||
| </ | </ | ||
| + | |||
| + | **put** | ||
| + | < | ||
| + | url --location ' | ||
| + | --header ' | ||
| + | --data-urlencode ' | ||
| + | --data-urlencode ' | ||
| + | --data-urlencode ' | ||
| + | --data-urlencode ' | ||
| + | < | ||
| + | <order number=" | ||
| + | < | ||
| + | <row item=" | ||
| + | <row item=" | ||
| + | </ | ||
| + | < | ||
| + | < | ||
| + | < | ||
| + | < | ||
| + | </ | ||
| + | </ | ||
| + | </ | ||
| + | </ | ||
| + | </ | ||
| =====Price ====== | =====Price ====== | ||
| Line 634: | Line 658: | ||
| |XML |xd_supplieritemtype |0 |ITEM |0 = supplier item; 1 = sales item | | |XML |xd_supplieritemtype |0 |ITEM |0 = supplier item; 1 = sales item | | ||
| |XML |type |1 |ITEM |1 = stock item | | |XML |type |1 |ITEM |1 = stock item | | ||
| - | ===Ostuarved | + | ===Purchase Invoices |
| what=purchase | what=purchase | ||
| - | [[https:// | + | [[https:// |
| - | ==Päis== | + | ==Header== |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | ^XML field^SQL field^UI field^Explanation^ |
| |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! | | ||
| |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 | | |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 | | + | |date|aeg|Invoice time| ALT.FROM: current time | |
| - | |duedate|tas_aeg|Tas. aeg| | | + | |duedate|tas_aeg|Due time| | |
| - | |sum|summa|Tasuda| sum with vat | | + | |sum|summa|To be paid| sum with vat | |
| - | |supplierinvoiceno|hankija_arve|Hankija arve| | | + | |supplierinvoiceno|hankija_arve|Supplier invoice| | |
| - | |paymentterm|tingimus|Tas. ting.| ALT.FROM: supplier | | + | |paymentterm|tingimus|Pay. term.| ALT.FROM: supplier | |
| - | |suppliercode|hankija_kood|Hankija| | | + | |suppliercode|hankija_kood|Supplier| | |
| |suppliername|hankija_nimi|| ALT.FROM: supplier | | |suppliername|hankija_nimi|| ALT.FROM: supplier | | ||
| |bankaccount|pangakonto| | ALT.FROM: supplier | | |bankaccount|pangakonto| | ALT.FROM: supplier | | ||
| - | |reference|viide|Viitenumber| ALT.FROM: supplier | | + | |reference|viide|Reference number| ALT.FROM: supplier | |
| - | |transactiontime|kande_aeg|Op. aeg| | | + | |transactiontime|kande_aeg|Oper. time| | |
| - | |creditaccount|kred_konto|Kred. konto| ALT.FROM: supplier > glob.settings | | + | |creditaccount|kred_konto|Cred. account| ALT.FROM: supplier > glob.settings | |
| - | |factoring|arve_tasub|Arve tasub| | | + | |factoring|arve_tasub|Invoice paid by| | |
| - | |currency|valuuta|Valuuta| ALT.FROM: glob.settings > ' | + | |currency|valuuta|Currency| ALT.FROM: glob.settings > ' |
| - | |currencyrate|kurssbv1|Kurss| ALT.FROM: ECB current published rates | | + | |currencyrate|kurssbv1|Rate| ALT.FROM: ECB current published rates | |
| - | |vatzone|maa|KM Maa (peidetud väli)| local = 0, EU = 1, export = 2 , ALT.FROM: supplier > 0 | | + | |vatzone|maa|VAT Zone (hidden field)| local = 0, EU = 1, export = 2 , ALT.FROM: supplier > 0 | |
| - | |comment|kommentaar|Kommentaar| | | + | |comment|kommentaar|Comment| | |
| - | |vat|arvestatudkm|KM kokku| | | + | |vat|arvestatudkm|VAT total| | |
| - | |object|objekt|Objekt| ALT.FROM: supplier > tr.params | | + | |object|objekt|Object| ALT.FROM: supplier > tr.params | |
| - | |bankcode|pangakood|Pangakood| | | + | |bankcode|pangakood|Bank code| | |
| - | |creditpurchase|kredost|Kred. ost| | | + | |creditpurchase|kredost|Cred. purch.| | |
| - | |purchaseorder|ostutellimus|Ostutellimus| | | + | |purchaseorder|ostutellimus|Purchase order| | |
| - | |project|projekt|Projekt| | | + | |project|projekt|Project| | |
| - | |email|email|meil| ALT.FROM: supplier | | + | |email|email|e-mail| ALT.FROM: supplier | |
| - | |stockreceipt|sissetulek|Sissetulek| | | + | |stockreceipt|sissetulek|Stock receipt| | |
| - | |country|asumaa|Saatjariik| ALT.FROM: supplier | | + | |country|asumaa|Origin country| ALT.FROM: supplier | |
| - | |prepayment|ettemaks|Ettemaks| | | + | |prepayment|ettemaks|Prepayment| | |
| - | |status|staatus|Staatus| | | + | |status|staatus|Status| | |
| - | |type|tyyp|Tüüp| | | + | |type|tyyp|Type| | |
| - | |dividedsum|jagatav_summa|Jagatav summa| | | + | |dividedsum|jagatav_summa|Divisible sum| | |
| - | |vatdate|km_aeg|KM aeg| ALT.FROM: date > current time | | + | |vatdate|km_aeg|VAT time| ALT.FROM: date > current time | |
| - | |reclamation|reklamatsioon|Reklamatsioon| | | + | |reclamation|reklamatsioon|Reclamation| | |
| - | |reclamationcomment|rekl_selgitus|Rekl. selgitus| | | + | |reclamationcomment|rekl_selgitus|Recl. explanation| | |
| - | |asset|inventar|Inventar| | | + | |asset|inventar|Asset| | |
| |datafield1|lisa_field1|| | | |datafield1|lisa_field1|| | | ||
| |datafield2|lisa_field2|| | | |datafield2|lisa_field2|| | | ||
| Line 683: | Line 707: | ||
| |datafield6|lisa_field6|| | | |datafield6|lisa_field6|| | | ||
| |datafield7|lisa_field7|| | | |datafield7|lisa_field7|| | | ||
| - | |intcomment|sisekommentaar|Sisekommentaar| | | + | |intcomment|sisekommentaar|Internal comment| | |
| - | |supplier_class|hankija_klass|Klass| | | + | |supplier_class|hankija_klass|Class| | |
| - | |supplier_vatcountry|hankija_maa_tasu|KM-maa| local = 0, EU = 1, export = 2 , ALT.FROM: customer > 0 | | + | |supplier_vatcountry|hankija_maa_tasu|VAT-zone| local = 0, EU = 1, export = 2 , ALT.FROM: customer > 0 | |
| - | |supplier_regno|hankija_regnr1|Reg | + | |supplier_regno|hankija_regnr1|Reg |
| - | |supplier_vatregno|hankija_kmregnr|Km reg nr| | | + | |supplier_vatregno|hankija_kmregnr|VAT reg no| | |
| - | |supplier_type|hankija_tyyp|Tüüp| | | + | |supplier_type|hankija_tyyp|Type| | |
| - | |confirm|kinnita|Olek| " | + | |confirm|kinnita|State| " |
| - | ==read == | + | ==rows == |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | ^XML field^SQL field^UI field^Explanation^ |
| - | |account|konto|Konto| | | + | |account|konto|Account| | |
| - | |object|objekt|Objekt| ALT.FROM: project | | + | |object|objekt|Object| ALT.FROM: project | |
| - | |name|sisu|Sisu| ALT.FROM: account | | + | |name|sisu|Content| ALT.FROM: account | |
| - | |linetotalwovat|summa|Summa| | | + | |linetotalwovat|summa|Sum| | |
| - | |vatcode|kmkood|KMK| ALT.FROM: supplier > account > object | | + | |vatcode|kmkood|VAT code| ALT.FROM: supplier > account > object | |
| - | |project|projekt|Projekt| | | + | |project|projekt|Project| | |
| - | |customer|klient_kood|Klient| | | + | |customer|klient_kood|Customer| | |
| - | |item|artikkel|Artikkel| | | + | |item|artikkel|Item| | |
| - | |quantity|kogus|Kogus| | | + | |quantity|kogus|Quantity| | |
| - | |date1|r_aeg1|Algus| | | + | |date1|r_aeg1|Start| | |
| - | |date2|r_aeg2|Lõpp| | | + | |date2|r_aeg2|End| | |
| - | |contract|leping|Leping| | | + | |contract|leping|Contract| | |
| - | |user|kasutaja|Kasutaja| | | + | |user|kasutaja|User| | |
| |oid|oid|OID| | | |oid|oid|OID| | | ||
| |orderrn|trn|| | | |orderrn|trn|| | | ||
| - | |asset|r_inventar|Inventar| | | + | |asset|r_inventar|Asset| | |
| - | |price|myygihind|Müügihind| | | + | |price|myygihind|Sales price| | |
| |constant1|konstant1| | | | |constant1|konstant1| | | | ||
| |constant2|konstant2| | | | |constant2|konstant2| | | | ||
| Line 718: | Line 742: | ||
| |text3|tekst3|| | | |text3|tekst3|| | | ||
| |text4|tekst4|| | | |text4|tekst4|| | | ||
| - | |intcomment|r_sisekommentaar|Sisekommentaar| | | + | |intcomment|r_sisekommentaar|Internal comment| | |
| - | |vatsum|km|KM| | | + | |vatsum|km|VAT| | |
| - | |rn|rn|Nr| | | + | |rn|rn|No.| | |
| - | ==manused | + | ==attachments |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | ^XML field^SQL field^UI field^Explanation^ |
| |name |attachment_name | | | | |name |attachment_name | | | | ||
| |description |attachment_kirjeldus | | | | |description |attachment_kirjeldus | | | | ||
| - | |code |kood| | for updating | + | |code |kood| | for updating |
| |sharepoint_link |cloud_preview_query| | external Sharepoint attachment link | | |sharepoint_link |cloud_preview_query| | external Sharepoint attachment link | | ||
| |gdrive_link |cloud_gdrive| | external Google Drive 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 < | |ext_link|cloud_ext_link | | external attachment link, must be full external link starting with < | ||
| - | + | ==Purchase invoice transport parameters | |
| - | ==Ostuarve transpordi parameetrid | + | ^ TYPE |
| - | ^ TÜÜP | + | | XML | xd_autosupplier |
| - | | XML | xd_autosupplier | + | | XML | xd_autosupplier_autocode |
| - | | XML | xd_autosupplier_autocode | + | | XML | xd_update |
| - | | XML | xd_update | + | | XML | supplier_update |
| - | | XML | supplier_update | + | | XML | xd_object |
| - | | XML | xd_object | + | | XML | xd_confirm |
| - | | XML | xd_confirm | + | ===Resources |
| - | + | ||
| - | + | ||
| - | ===Ressursid | + | |
| what=resource | what=resource | ||
| - | [[https:// | + | [[https:// |
| - | == Päis: == | + | == Header: == |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | ^XML field^SQL field^UI field^Explanation^ |
| |session_id|x| | | | |session_id|x| | | | ||
| |ext_unique_id|ext_unique_id| | | | |ext_unique_id|ext_unique_id| | | | ||
| Line 770: | Line 791: | ||
| |confirm|kinnita| | | | |confirm|kinnita| | | | ||
| - | == Read: == | + | == Rows: == |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | ^XML field^SQL field^UI field^Explanation^ |
| |item|artikkel| | | | |item|artikkel| | | | ||
| |quantity|kogus| | | | |quantity|kogus| | | | ||
| Line 815: | Line 836: | ||
| |delete|kustuta| | | | |delete|kustuta| | | | ||
| |rn|rn| | | | |rn|rn| | | | ||
| + | ==== Outputs ==== | ||
| - | ==== Väljundid ==== | + | === Items (Items) |
| - | === Artiklid (Items) === | + | * what=item [[https:// |
| - | | + | == Item stock limits (Item stock limits) == |
| + | | ||
| - | == Artikli laolimiidid | + | == Item packages |
| - | * what=itemstocklimit | + | * what=itempackage |
| - | == Artikli pakendid | + | == Item relations |
| - | * what=itempackage | + | * what=itemrelitem |
| - | == Seotud artikli | + | === Customers |
| - | * what=itemrelitem [[https:// | + | |
| - | === Kliendid (Customers) === | + | * what=customer [[https:// |
| - | * what=customer [[https:// | + | === Suppliers |
| - | + | ||
| - | === Hankijad | + | |
| * what=supplier | * what=supplier | ||
| - | * [[https:// | + | * [[https:// |
| - | * Filtrid: code, | + | * Filters: code, |
| - | + | ||
| - | === Laoseis (Stock levels) === | + | |
| - | * what=stocklevel [[https:// | + | |
| - | * what= stocklevel_sn [[https:// | + | |
| - | * what=stocklevel_variant [[https:// | + | |
| - | * Filtrid: code, | + | |
| - | + | ||
| - | === Hinnavalemi read (Price formula rows) === | + | |
| - | | + | === Stock levels (Stock levels) === |
| + | | ||
| + | * what= stocklevel_sn [[https:// | ||
| + | * what=stocklevel_variant [[https:// | ||
| + | * Filters: code,stock,ts | ||
| - | === Artikli klassid | + | === Price formula rows (Price formula rows) === |
| - | * what=itemclass [[https:// | + | * what=priceformularow [[https:// |
| - | === Arved (Invoices) === | + | === Item classes |
| - | * what=invoice | + | * what=itemclass [[https:// |
| - | === Tellimused | + | === Invoices |
| - | * what=order [[https:// | + | * what=invoice |
| - | === Finantskanded | + | === Orders |
| - | * what=transaction | + | * what=order [[https:// |
| - | === Laekumised | + | === Financial transactions |
| - | * what=receipt | + | * what=transaction |
| - | === Ostuarved | + | === Receipts |
| - | * what=purchase | + | * what=receipt |
| - | === Ressursid | + | === Purchase Invoices |
| - | * what=resource [[https:// | + | |
| - | * Filtrid: number, | + | |
| - | === Kustutatud dokumendid (Deleted documents ) === | + | * what=purchase [[https:// |
| - | | + | === Resources (Resources) === |
| + | | ||
| + | * Filters: number,confirmed,ts | ||
| + | === Deleted documents (Deleted documents ) === | ||
| + | * what=delete [[https:// | ||
en/xml_direct.1754288087.txt.gz · Last modified: 2025/08/04 09:14 by toomas