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:13] – [Kliendid] 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 443: | Line 467: | ||
| ==Customer transport parameters == | ==Customer transport parameters == | ||
| ^ TYPE ^ CODE ^ PARAMETER 1 ^ PARAMETER 2 ^ EXPLANATION | ^ TYPE ^ CODE ^ PARAMETER 1 ^ PARAMETER 2 ^ EXPLANATION | ||
| - | ===Hankijad | + | ===Suppliers |
| - | * Postitamisel ja muutmisel on alati nõutud | + | * When posting and modifying, |
| what=supplier | what=supplier | ||
| - | [[https:// | + | [[https:// |
| - | ==hankijad: == | + | ==suppliers: == |
| - | ^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! | | ||
| - | |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|Code| 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|Name| | |
| |contact|kontakt| | | | |contact|kontakt| | | | ||
| |address1|aadress1| | | | |address1|aadress1| | | | ||
| Line 499: | Line 523: | ||
| |purchasinggroup|ostugrupp| | | | |purchasinggroup|ostugrupp| | | | ||
| |county|maakond| | | | |county|maakond| | | | ||
| - | + | == suppliers additional fields: == | |
| - | == hankijad lisaväljad: == | + | ^XML field^SQL field^UI field^Explanation^ |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| |code|kood| | | | |code|kood| | | | ||
| - | |content|sisu|Sisu| | | + | |content|sisu|Content| | |
| - | |param|param|Parameeter| | | + | |param|param|Parameter| | |
| - | + | ===Items=== | |
| - | + | * When filling out the item card, the interface fills the fields according to the rules [[en:mandatory|]] | |
| - | ===Artiklid=== | + | |
| - | * Artikli kaardi täitmisel liides täidab valjad vastavalt reeglitele | + | |
| what=item | what=item | ||
| - | [[https:// | + | [[https:// |
| - | ==Artiklid== | + | ==Items== |
| - | ^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! | | ||
| - | |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|Code| 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|Name| | |
| - | |class|klass|Klass| | | + | |class|klass|Class| | |
| - | |barcode|ribakood|Ribakood| | | + | |barcode|ribakood|Barcode| | |
| - | |areacode|piirkonnakood|Päritolu| | | + | |areacode|piirkonnakood|Origin| | |
| - | |unit|yhik|Ühik| | | + | |unit|yhik|Unit| | |
| - | |salesprice|baashind|Müügihind| without VAT | | + | |salesprice|baashind|Sales price| without VAT | |
| - | |accountlocal|konto_myyk|Müük Siseriiklik| | | + | |accountlocal|konto_myyk|Sales Domestic| | |
| - | |accounteu|konto_myyk_EU|Müük | + | |accounteu|konto_myyk_EU|Sales EU| | |
| - | |accountexport|konto_myyk_eksport|Müük Eksp| | | + | |accountexport|konto_myyk_eksport|Sales Exp| | |
| - | |vatcode|KMkood|KM Siseriiklik| | | + | |vatcode|KMkood|VAT Domestic| | |
| - | |vatcodeeu|KMkood_EU|KM EU| | | + | |vatcodeeu|KMkood_EU|VAT EU| | |
| - | |vatcodeexport|KMkood_eksport|KM mitte EU| | | + | |vatcodeexport|KMkood_eksport|VAT non-EU| | |
| - | |type|tyyp|Tüüp| ALT.FROM: tr.params, cannot be updated. 0=service; 1=stock item; 2=rental item | | + | |type|tyyp|Type| ALT.FROM: tr.params, cannot be updated. 0=service; 1=stock item; 2=rental item | |
| - | |minlevel|minimaaltase|Min | + | |minlevel|minimaaltase|Min |
| - | |shelf|riiulikood|Riiul| | | + | |shelf|riiulikood|Shelf| | |
| - | |weight|kaal|Kaal| | | + | |weight|kaal|Weight| | |
| - | |volume|maht|Maht| | | + | |volume|maht|Volume| | |
| - | |warranty|garantii|Garantii| | | + | |warranty|garantii|Warranty| | |
| - | |package1|yhikumuut1|Pakis 1| | | + | |package1|yhikumuut1|In package |
| - | |package2|yhikumuut2|Pakis 2| | | + | |package2|yhikumuut2|In package |
| - | |sntracking|SN_jalgimine|Seeria nr| cannot be updated. 0=without sn tracking; 1=serial no tracking; 2=batch no tracking | | + | |sntracking|SN_jalgimine|Serial no.| cannot be updated. 0=without sn tracking; 1=serial no tracking; 2=batch no tracking | |
| - | |cost|ostuhind|Ostuhind| | | + | |cost|ostuhind|Purchase price| | |
| - | |object|objekt|Objekt| | | + | |object|objekt|Object| | |
| - | |recipe|retsept|Retsept| | | + | |recipe|retsept|Recipe| | |
| - | |recipetorows|retsept_ridadeks|Retsept ei asetu| | | + | |recipetorows|retsept_ridadeks|Recipe does not apply| | |
| - | |alert|hoiatus|Hoiatus| | | + | |alert|hoiatus|Warning| | |
| - | |closed|suletud|Suletud| closed = 1, open = 0 | | + | |closed|suletud|Closed| closed = 1, open = 0 | |
| - | |description|pikktekst|Kirjeldus| | | + | |description|pikktekst|Description| | |
| - | |vatprice1|hind_okonline|Lisahind | + | |vatprice1|hind_okonline|Add. price 1 (customizable)| with local VAT | |
| - | |vatprice2|hind_delfi|Lisahind | + | |vatprice2|hind_delfi|Add. price 2 (customizable)| with local VAT | |
| - | |vatprice3|soodus_hind1|Soodushind | + | |vatprice3|soodus_hind1|Discount price 1 (customizable)| with local VAT | |
| - | |vatprice4|soodus_hind2|Soodushind | + | |vatprice4|soodus_hind2|Discount price 2 -customizable)| with local VAT | |
| - | |vatprice|hind_tavaline|Tavahind| ALT.FROM: salesprice + local vat | | + | |vatprice|hind_tavaline|Regular price| ALT.FROM: salesprice + local vat | |
| - | |priority|prioriteet|Prioriteet| | | + | |priority|prioriteet|Priority| | |
| |url|url|URL| | | |url|url|URL| | | ||
| - | |supplier|hankija_kood|Hankija| | | + | |supplier|hankija_kood|Supplier| | |
| - | |supplieritem|hankija_artikkel|Hank. artikkel| | | + | |supplieritem|hankija_artikkel|Supp. item| | |
| - | |maxlevel|maksimaaltase|Max | + | |maxlevel|maksimaaltase|Max |
| - | |abc|abc|ABC | + | |abc|abc|ABC |
| - | |cn8code|cn8_kood|CN8 | + | |cn8code|cn8_kood|CN8 |
| - | |cnkogus|cnkogus|CN | + | |cnkogus|cnkogus|CN |
| - | |vatcodeeu2|KMKood_EU2|KM EU 2| | | + | |vatcodeeu2|KMKood_EU2|VAT EU 2| | |
| - | |vatcodeeu3|KMKood_EU3|KM EU 3| | | + | |vatcodeeu3|KMKood_EU3|VAT EU 3| | |
| - | |vatcodeconcern|KMKood_kontsern|KM kontsern| | | + | |vatcodeconcern|KMKood_kontsern|VAT concern| | |
| - | |accounteu2|konto_myyk_EU2|Müük | + | |accounteu2|konto_myyk_EU2|Sales EU 2| | |
| - | |accounteu3|konto_myyk_EU3|Müük | + | |accounteu3|konto_myyk_EU3|Sales EU 3| | |
| - | |accountconcern|konto_myyk_kontsern|Müük kontsern| | | + | |accountconcern|konto_myyk_kontsern|Sales concern| | |
| - | |snclass|sn_klass|SN | + | |snclass|sn_klass|SN |
| - | |normarrivaltime|norm_aeg|Norm saabumisaeg| | | + | |normarrivaltime|norm_aeg|Normal arrival time| | |
| - | |replacement|asendus|Asendus| | | + | |replacement|asendus|Replacement| | |
| - | |snrule|sn_reegel|SN | + | |snrule|sn_reegel|SN |
| - | |project|projekt|Projekt| | | + | |project|projekt|Project| | |
| |variants|variandid|Variant| cannot be updated. 0=no; 1=yes | | |variants|variandid|Variant| cannot be updated. 0=no; 1=yes | | ||
| |autosn|auto_sn|Auto SN| | | |autosn|auto_sn|Auto SN| | | ||
| - | |specialprice1|kaibeta_hind1|Artikli käibeta lisahind1 | + | |specialprice1|kaibeta_hind1|Item add. price w/o VAT 1 (customizable)| | |
| - | |specialprice2|kaibeta_hind2|Artikli käibeta lisahind2 | + | |specialprice2|kaibeta_hind2|Item add. price w/o VAT 2 (customizable)| | |
| - | |specialprice3|kaibeta_hind3|Artikli käibeta lisahind3 | + | |specialprice3|kaibeta_hind3|Item add. price w/o VAT 3 (customizable)| | |
| - | |specialprice4|kaibeta_hind4|Artikli käibeta lisahind4 | + | |specialprice4|kaibeta_hind4|Item add. price w/o VAT 4 (customizable)| | |
| - | |specialprice5|kaibeta_hind5|Artikli käibeta lisahind5 | + | |specialprice5|kaibeta_hind5|Item add. price w/o VAT 5 (customizable)| | |
| - | |specialprice6|kaibeta_hind6|Artikli käibeta lisahind6 | + | |specialprice6|kaibeta_hind6|Item add. price w/o VAT 6 (customizable)| | |
| - | |specialprice7|kaibeta_hind7|Artikli käibeta lisahind7 | + | |specialprice7|kaibeta_hind7|Item add. price w/o VAT 7 (customizable)| | |
| - | |specialprice8|kaibeta_hind8|Artikli käibeta lisahind8 | + | |specialprice8|kaibeta_hind8|Item add. price w/o VAT 8 (customizable)| | |
| - | |height|korgus|Kõrgus| | | + | |height|korgus|Height| | |
| - | |width|laius|Laius| | | + | |width|laius|Width| | |
| - | |depth|sygavus|Sügavus| | | + | |depth|sygavus|Depth| | |
| - | |grossweight|kaal_bruto|Bruto kaal| | | + | |grossweight|kaal_bruto|Gross weight| | |
| - | |giftcert|kinkekaart|Kinkekaart| | | + | |giftcert|kinkekaart|Gift card| | |
| - | |manufacturer|tootja|Tootja| | | + | |manufacturer|tootja|Manufacturer| | |
| - | + | == Items additional fields: == | |
| - | == Artiklid lisaväljad: == | + | ^XML field^SQL field^UI field^Explanation^ |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| |code|kood| | | | |code|kood| | | | ||
| - | |content|sisu|Sisu| | | + | |content|sisu|Content| | |
| - | |param|param|Parameeter| | | + | |param|param|Parameter| | |
| - | == Artiklid pakendid: == | + | == Items packages: == |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | ^XML field^SQL field^UI field^Explanation^ |
| - | |class|pakendi_klass|Klass| | | + | |class|pakendi_klass|Class| | |
| - | |type|pakendi_tyyp|Tüüp| | | + | |type|pakendi_tyyp|Type| | |
| - | |height|korgus|Kõrgus| | | + | |height|korgus|Height| | |
| - | |width|laius|Laius| | | + | |width|laius|Width| | |
| - | |length|pikkus|Pikkus| | | + | |length|pikkus|Length| | |
| - | |volume|maht|Maht| | | + | |volume|maht|Volume| | |
| - | |qty|kogus|Pak.kogus| | | + | |qty|kogus|Pack. qty| | |
| - | |packageweight|pakendi_kaal|Pakendi kaal| | | + | |packageweight|pakendi_kaal|Package weight| | |
| - | |productweight|toote_kaal|Toote kaal| | | + | |productweight|toote_kaal|Product weight| | |
| - | |totalweight|kaal_kokku|KOKKU kaal| | | + | |totalweight|kaal_kokku|TOTAL weight| | |
| - | |totalvolume|maht_kokku|KOKKU maht| | | + | |totalvolume|maht_kokku|TOTAL volume| | |
| - | |barcode|ribakood|Ribakood| | | + | |barcode|ribakood|Barcode| | |
| - | |comment|kommentaar|Kommentaar| | | + | |comment|kommentaar|Comment| | |
| - | |shelf|riiul|Riiul| | | + | |shelf|riiul|Shelf| | |
| - | + | == Items - supplier items: == | |
| - | == Artiklid | + | ^XML field^SQL field^UI field^Explanation^ |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |supplier|hankija|Supplier| | |
| - | |supplier|hankija|Hankija| | | + | |supplieritem|hankija_artikkel|Supp. item| | |
| - | |supplieritem|hankija_artikkel|Hank. artikkel| | | + | |name|nimi|Name| | |
| - | |name|nimi|Nimi| | | + | |price|hind|Purchase price| | |
| - | |price|hind|Ostuhind| | | + | |normarrivaltime|norm_aeg|Normal arrival time| | |
| - | |normarrivaltime|norm_aeg|Norm saabumisaeg| | | + | |object|objekt|Object| | |
| - | |object|objekt|Objekt| | | + | |
| |variant|variant|Variant| | | |variant|variant|Variant| | | ||
| |varianta|varianta|VariantA - (customizable)| | | |varianta|varianta|VariantA - (customizable)| | | ||
| Line 626: | Line 645: | ||
| |variantg|variantg|VariantG - (customizable)| | | |variantg|variantg|VariantG - (customizable)| | | ||
| |varianth|varianth|VariantH - (customizable)| | | |varianth|varianth|VariantH - (customizable)| | | ||
| - | |salesprice|myygihind|Müügihind| without VAT| | + | |salesprice|myygihind|Sales price| without VAT| |
| |sales|myyk|| ALT.FROM: tr.params, cannot be updated , sales item = 1, supplier item = 0 | | |sales|myyk|| ALT.FROM: tr.params, cannot be updated , sales item = 1, supplier item = 0 | | ||
| - | + | == Items - minmax: == | |
| - | == Artiklid | + | ^XML field^SQL field^UI field^Explanation^ |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |stock|ladu|Stock| | |
| - | |stock|ladu|Ladu| | | + | |shelf|riiul|Shelf| | |
| - | |shelf|riiul|Riiul| | | + | |
| |variant|variant|Variant| | | |variant|variant|Variant| | | ||
| |minlevel|min_kogus|MIN| | | |minlevel|min_kogus|MIN| | | ||
| |maxlevel|max_kogus|MAX| | | |maxlevel|max_kogus|MAX| | | ||
| - | + | ==Item transport parameters | |
| - | ==Artikli transpordi parameetrid | + | ^TYPE ^CODE ^PARAMETER |
| - | ^TÜÜP ^KOOD ^PARAMEETER | + | |XML |xd_supplieritemtype |0 |ITEM |0 = supplier item; 1 = sales item | |
| - | |XML |xd_supplieritemtype |0 |ITEM |0 = hankija artikkel; 1 = müügi artikkel | + | |XML |type |1 |ITEM |1 = stock item | |
| - | |XML |type |1 |ITEM |1 = laoartikkel | + | ===Purchase Invoices |
| - | + | ||
| - | + | ||
| - | ===Ostuarved | + | |
| 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 692: | 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 727: | 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 779: | 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 824: | 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.1754287991.txt.gz · Last modified: 2025/08/04 09:13 by toomas