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 [2025/01/08 15:00] – [Komponendid] toomas | et:xml_direct [2025/03/18 09:09] (Hetkel kehtiv) – [Ressursid] toomas | ||
---|---|---|---|
Rida 41: | Rida 41: | ||
=====Komponendid ===== | =====Komponendid ===== | ||
**Valitavad komponendid** | **Valitavad komponendid** | ||
- | ^ Komponent (what) | + | ^ Komponent (what) |
- | | Tellimused (order) | + | | Tellimused (order) |
- | | Arved (invoice ) | + | | Arved (invoice ) |
- | | Laekumised (receipt) | + | | Laekumised (receipt) |
- | | Kliendid (customer) | + | | Kliendid (customer) |
- | | Artiklid (item) | + | | Hankijad (supplier) |
- | | Artikliklassid (itemclass) | + | | Hankijad (supplier_x) |
- | | Laoseis (stocklevel) | + | | Hankijad (supplier_m) |
- | | Hinnavalemi read (priceformularow) | + | | Artiklid (item) |
- | | Ostuarved (purchase) | + | | Artiklid: |
- | | Finantskanded (transaction) | + | | Artiklid: |
- | | Kustutatud dokumendid | + | | 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 ==== | ====Sisendid ==== | ||
Rida 170: | Rida 179: | ||
^TÜÜP^KOOD^PARAMEETER 1^PARAMEETER 2^SELGITUS^ | ^TÜÜP^KOOD^PARAMEETER 1^PARAMEETER 2^SELGITUS^ | ||
|XML|xd_changestock|0|INVOICE|Ladumuutev arve (Param.1 =1 on muuda ladu)| | |XML|xd_changestock|0|INVOICE|Ladumuutev arve (Param.1 =1 on muuda ladu)| | ||
- | |XML|xd_uniqueid|lisa_field1|INVOICE|Andmebaasi väli, kuhu panna väline unikaalne identifikaator (Nt. kliendi_tellimus, | ||
|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_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_update|1|INVOICE|Luba dokumendi update, kui puuduvad seotud dokumendid| | ||
- | |XML|xd_series|DOK|INVOICE|Seeria, | ||
|XML|xd_customer_update|0|INVOICE|Kliendi andmete osaline update, (nimi, email, telefon) või vastavalt spekile| | |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_object|TEST_OBJEKT|INVOICE|Vaikimisi objekt, kui ei saadeta| | ||
Rida 241: | Rida 248: | ||
== Read: == | == Read: == | ||
- | ^XML väli^SQL väli^UI väli^Selgitus^ | + | ^ XML väli ^ SQL väli ^ UI väli |
- | |item|artikkel|Artikkel| | | + | | item | artikkel |
- | |description|nimetus|Sisu| ALT.FROM: item | | + | | description |
- | |price|yhikuhind|Ühikuhind| unit price without vat | | + | | price |
- | |quantity|kogus|Kogus| | | + | | quantity |
- | |discount|pross|%| | | + | | discount |
- | |account|konto|Konto| ALT.FROM: item > item class (depending on vatregion) | | + | | account |
- | |vatcode|kmkood|KMk| | + | | vatcode |
- | |unit|yhik|Ühik| ALT.FROM: item | | + | | unit | yhik | Ühik | ALT.FROM: item | |
- | |comment|r_kommentaar|Kommentaar| | | + | | comment |
- | |variant|variant|Variant| | + | | variant |
- | |rsum|rsum|RSKM (kui on saadetud price/ | + | | deliverytime |
- | |deliverytime|lahetusaeg|Lähetusaeg| | | + | | stock |
- | |stock|r_ladu|Ladu| | | + | | project |
- | |project|projekt|Projekt| ALT.FROM: item > item class | | + | | ext_sum |
- | |ext_sum|ext_sum| | | | + | | ext_id |
- | |ext_id|ext_id| | | | + | | rn | rn | Nr | row order number in document 1 - N , ALT.FROM: random |
- | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | | rr | rv | Rv | row reference for grouping, otherwise equals to rn , ALT.FROM: equals to rn | |
- | |rr|rv|Rv|row reference for grouping, otherwise equals to rn , ALT.FROM: equals to rn | | + | |
Rida 269: | Rida 275: | ||
|XML|xd_confirm|0|ORDER|Automaatne dokumendi kinnitamine, | |XML|xd_confirm|0|ORDER|Automaatne dokumendi kinnitamine, | ||
|XML|xd_update|1|ORDER|Luba dokumendi update, kui puuduvad seotud dokumendid| | |XML|xd_update|1|ORDER|Luba dokumendi update, kui puuduvad seotud dokumendid| | ||
- | |XML|xd_series|DOK|ORDER|Seeria, | ||
|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_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_customer_update|0|ORDER|Kliendi andmete osaline update, (nimi, email, telefon) või vastavalt spekile| | ||
- | |XML|xd_uniqueid|kliendi_tellimus|ORDER|Andmebaasi väli, kuhu panna väline unikaalne identifikaator (Nt. kliendi_tellimus, | ||
|XML|xd_salesman|XML|ORDER|Vaikimisi müüja|x | |XML|xd_salesman|XML|ORDER|Vaikimisi müüja|x | ||
|XML|xd_confirmpayment|1|ORDER|Automaatne laekumise kinnitamine| | |XML|xd_confirmpayment|1|ORDER|Automaatne laekumise kinnitamine| | ||
Rida 422: | Rida 426: | ||
==Kliendi transpordi parameetrid == | ==Kliendi transpordi parameetrid == | ||
- | ^TÜÜP ^KOOD ^PARAMEETER 1 ^PARAMEETER 2 ^SELGITUS^ | + | ^ TÜÜP |
- | |XML |xd_uniqueid |email |CUSTOMER |Andmebaasi väli, kuhu panna väline unikaalne identifikaator (Nt. kliendi_tellimus, | + | |
+ | |||
+ | ===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=== | ===Artiklid=== | ||
* Artikli kaardi täitmisel liides täidab valjad vastavalt reeglitele [[et: | * Artikli kaardi täitmisel liides täidab valjad vastavalt reeglitele [[et: | ||
- | * | + | |
- | what=customer | + | what=item |
[[https:// | [[https:// | ||
Rida 555: | Rida 623: | ||
|maxlevel|max_kogus|MAX| | | |maxlevel|max_kogus|MAX| | | ||
- | ==Kliendi | + | ==Artikli |
^TÜÜP ^KOOD ^PARAMEETER 1 ^PARAMEETER 2 ^SELGITUS^ | ^TÜÜP ^KOOD ^PARAMEETER 1 ^PARAMEETER 2 ^SELGITUS^ | ||
- | |XML |xd_uniqueid |ribakood |ITEM |Andmebaasi väli, kuhu panna väline unikaalne identifikaator (Nt. kliendi_tellimus, | ||
|XML |xd_supplieritemtype |0 |ITEM |0 = hankija artikkel; 1 = müügi artikkel | | |XML |xd_supplieritemtype |0 |ITEM |0 = hankija artikkel; 1 = müügi artikkel | | ||
|XML |type |1 |ITEM |1 = laoartikkel | | |XML |type |1 |ITEM |1 = laoartikkel | | ||
- | ====Väljundid ==== | + | ===Ostuarved === |
- | ==Artiklid (Items) == | + | |
- | * what=item | + | what=purchase |
- | ==Kliendid (Customers) == | + | [[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:// | * what=customer [[https:// | ||
- | == Laoseis (Stock levels) == | + | |
- | * what=stocklevel [[https:// | + | === Hankijad (Suppliers) === |
- | == Hinnavalemi read (Price formula rows) == | + | |
+ | * what=supplier_x [[https:// | ||
+ | * what= supplier_m [[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:// | * what=priceformularow [[https:// | ||
- | == Artikli klassid (Item classes) == | + | |
+ | === Artikli klassid (Item classes) === | ||
* what=itemclass [[https:// | * what=itemclass [[https:// | ||
- | == Arved (Invoices) == | + | |
+ | === Arved (Invoices) === | ||
* what=invoice [[https:// | * what=invoice [[https:// | ||
- | == Tellimused (Orders) == | + | |
+ | === Tellimused (Orders) === | ||
* what=order [[https:// | * what=order [[https:// | ||
- | == Finantskanded (Transactions) == | + | |
+ | === Finantskanded (Transactions) === | ||
* what=transaction [[https:// | * what=transaction [[https:// | ||
- | == Laekumised (Receipts) == | + | |
+ | === Laekumised (Receipts) === | ||
* what=receipt [[https:// | * what=receipt [[https:// | ||
- | == Kustutatud dokumendid (Deleted documents ) == | + | |
+ | === Ostuarved (Purchase) === | ||
+ | |||
+ | * what=purchase [[https:// | ||
+ | |||
+ | === Ressursid (Resources) === | ||
+ | * what=resource [[https:// | ||
+ | * Filtrid: number, | ||
+ | |||
+ | === Kustutatud dokumendid (Deleted documents ) === | ||
* what=delete [[https:// | * what=delete [[https:// | ||
+ | |||
et/xml_direct.1736341253.txt.gz · Viimati muutnud: 2025/01/08 15:00 persoon toomas