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/10/29 09:58] – [Artiklid (Items)] toomas | et:xml_direct [2025/11/19 09:18] (Hetkel kehtiv) – [Komponendid] toomas | ||
|---|---|---|---|
| Rida 55: | Rida 55: | ||
| =====Komponendid ===== | =====Komponendid ===== | ||
| **Valitavad komponendid** | **Valitavad komponendid** | ||
| - | ^ Komponent (what) | + | ^ Komponent (what) |
| - | |Pakkumised (quotation) | + | | Pakkumised (quotation) |
| - | |Tellimused (order) | [[et: | + | | Tellimused (order) |
| - | |Arved (invoice ) | [[et: | + | | Arved (invoice ) | [[et: |
| - | | Laekumised (receipt) | + | | Laekumised (receipt) |
| - | | Kliendid (customer) | + | | Kliendid (customer) |
| - | | Hankijad (supplier) | + | | Hankijad (supplier) |
| - | | Kontaktid (contact) | + | | Kontaktid (contact) |
| - | | Artiklid (item) | + | | Artiklid (item) |
| - | | Artiklid: | + | | Artiklid: |
| - | | Artiklid: | + | | Artiklid: |
| - | | Artiklid: | + | | Artiklid: |
| - | | Artikliklassid (itemclass) | + | | Artikliklassid (itemclass) |
| - | | Artikli ajalugu (itemhistoryrow) | + | | Artikli ajalugu (itemhistoryrow) |
| - | | Hinnavalemi read (priceformularow) | + | | Hinnavalemi read (priceformularow) |
| - | | Laoseis (stocklevel) | + | | Laoseis (stocklevel) |
| - | | Laoseis seerianumbritega (stocklevel_sn) | + | | Laoseis seerianumbritega (stocklevel_sn) |
| - | | Laoseis variantidega (stocklevel_variant) | + | | Laoseis variantidega (stocklevel_variant) |
| - | | Lähetused (delivery) | + | | Laoseis variantidega (stocklevel_variant_sn) |
| - | | Inventuurid (taking) | + | | Laoseisu vaba mõutavad kogused (allocation) |
| - | | Ostutellimused (purchaseorder) | + | | Lähetused (delivery) |
| - | | Sissetulekud (stockreceipt) | + | | Liikumised (movement) |
| - | | Ostuarved (purchase) | + | | Laotellimused(stockorder) |
| - | | Laekumised (receipt) | + | | Inventuurid (taking) |
| - | | Kontod (account) | + | | Ostutellimused (purchaseorder) |
| - | | Objektid (object) | + | | Sissetulekud (stockreceipt) |
| - | | Finantskanded (transaction) | + | | Ostuarved (purchase) |
| - | | Projektid (project) | + | | Laekumised (receipt) |
| - | | Ressursid (resource) | + | | Kontod (account) |
| - | | Kustutatud dokumendid (delete) | + | | Objektid (object) |
| + | | Finantskanded (transaction) | ||
| + | | Finantskanderead (transactionrow) | ||
| + | | Projektid (project) | ||
| + | | Ressursid (resource) | ||
| + | | Kasutajad(user) | ||
| + | | Kustutatud dokumendid (delete) | ||
| ====Sisendid ==== | ====Sisendid ==== | ||
| Rida 935: | Rida 941: | ||
| |rn|rn|Nr|row order number in document 1 - N | | |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| | | | ||
| Rida 1268: | Rida 1331: | ||
| |delete|kustuta| | | | |delete|kustuta| | | | ||
| |rn|rn| | | | |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| | | | ||
| + | |||
| ==== Väljundid ==== | ==== Väljundid ==== | ||
| Rida 1310: | Rida 1512: | ||
| * what= stocklevel_sn [[https:// | * what= stocklevel_sn [[https:// | ||
| * what=stocklevel_variant [[https:// | * what=stocklevel_variant [[https:// | ||
| - | | + | |
| + | **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) === | === Hinnavalemi read (Price formula rows) === | ||
| Rida 1354: | Rida 1562: | ||
| * what=movement[[https:// | * what=movement[[https:// | ||
| + | |||
| + | |||
| + | === Laotellimused(stockorder) === | ||
| + | |||
| + | * what=stockorder[[https:// | ||
| === Ostutellimused (purchaseorder) === | === Ostutellimused (purchaseorder) === | ||
| Rida 1391: | Rida 1604: | ||
| * Filtrid: number, | * Filtrid: number, | ||
| + | |||
| + | === Kasutajad(user) === | ||
| + | * what=user[[https:// | ||
| + | * Filtrid: code, | ||
| === Kustutatud dokumendid (Deleted documents ) === | === Kustutatud dokumendid (Deleted documents ) === | ||
et/xml_direct.1761724701.txt.gz · Viimati muutnud: 2025/10/29 09:58 persoon toomas