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/07/30 14:58] – [Hind] toomas | en:xml_direct [2025/08/04 09:16] (current) – 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 ===== | ||
| - | XML Direct is a standardized interface | + | Introduction |
| + | **XML Direct** is a standardized | ||
| + | |||
| + | All components within the XML Direct interface follow a **fixed field structure**, | ||
| - | The fields of all components are fixed – this means that the data format | + | =====Key Features ===== |
| + | * **Modular Architecture**: | ||
| + | * **Uniform Data Format**: Field definitions | ||
| + | * **Shared Development Model**: Enhancements and updates | ||
| + | * **Secure Access via API Keys**: | ||
| + | * Multiple API keys can be generated and assigned to different partners. | ||
| + | * Each API key can be restricted to access only specific components. | ||
| + | * This provides enhanced **flexibility** and **data security**. | ||
| - | The interface allows for the creation of multiple different API keys to provide secure access | + | =====Implementation Considerations ===== |
| + | Prior to implementation, | ||
| + | * Define the **scope of integration**. | ||
| + | * Identify the **required components**. | ||
| + | * Ensure the technical partner has access to the necessary documentation | ||
| - | Before implementation, | + | Once agreed upon, activating the XML Direct interface is straightforward and does not require any Directo-side development or configuration. |
| =====API Key ===== | =====API Key ===== | ||
| Line 48: | Line 60: | ||
| * API key B contains outputs: customer and order | * API key B contains outputs: customer and order | ||
| → In this case, the fee is only for three unique components: customer, item, and order. | → In this case, the fee is only for three unique components: customer, item, and order. | ||
| - | =====Testimine | + | =====Testing |
| - | XML Direct | + | XML Direct |
| https:// | https:// | ||
| + | =====General ====== | ||
| - | =====Üldine ====== | + | |
| - | | + | * The functionality of input interfaces can be controlled with '' |
| - | * Sisendliideste funktsionaalsust saab juhtida | + | * Some inputs also support setting default values. |
| - | * Osadel sisenditel toetab ka vaikeväärtuste seadistamist. | + | =====Components ===== |
| + | Selectable components | ||
| + | ^ Component (what) | ||
| + | | Orders (order) | ||
| + | | Invoices (invoice ) | x | ||
| + | | Receipts (receipt) | ||
| + | | Customers (customer) | ||
| + | | Suppliers (supplier) | ||
| + | | Items (item) | ||
| + | | Items:Stock Limits (itemstocklimit) | ||
| + | | Items: | ||
| + | | Items: | ||
| + | | Item classes (itemclass) | ||
| + | | Stock level (stocklevel) | ||
| + | | Stock level with serial numbers (stocklevel_sn) | | x | | ||
| + | | Stock level with variants (stocklevel_variant) | | ||
| + | | Price formula rows (priceformularow) | ||
| + | | Purchase invoices (purchase) | ||
| + | | Financial transactions (transaction) | ||
| + | | Resources (resource) | ||
| + | | Deleted documents | ||
| - | =====Komponendid | + | ====Inputs |
| - | **Valitavad komponendid** | + | ===Invoices=== |
| - | ^ Komponent (what) | + | what=invoice |
| - | | Tellimused (order) | + | |
| - | | Arved (invoice | + | |
| - | | Laekumised (receipt) | + | |
| - | | Kliendid (customer) | + | |
| - | | Hankijad (supplier) | + | |
| - | | Artiklid (item) | + | |
| - | | Artiklid:Laolimiidid (itemstocklimit) | + | |
| - | | Artiklid: | + | |
| - | | 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 | + | == Header: |
| + | ^ XML field ^ SQL field ^ UI field ^ Explanation | ||
| + | | session_id | ||
| + | | number | ||
| + | | date | aeg | Date | ALT.FROM: current time | | ||
| + | | duedate | ||
| + | | transactiondate | ||
| + | | vatzone | ||
| + | | paymentterm | ||
| + | | ordernumber | ||
| + | | latepaymentpenalty | ||
| + | | object | ||
| + | | project | ||
| + | | account | ||
| + | | country | ||
| + | | currency | ||
| + | | currencyrate | ||
| + | | customercode | ||
| + | | customername | ||
| + | | orderer_code | ||
| + | | contact | ||
| + | | comment | ||
| + | | intcomment | ||
| + | | salesman | ||
| + | | language | ||
| + | | customerordernumber | ||
| + | | email | email | e-mail | ||
| + | | address1 | ||
| + | | address2 | ||
| + | | address3 | ||
| + | | phone | telefon | ||
| + | | fax | faks | Fax | | | ||
| + | | deliveryname | ||
| + | | deliveryaddress1 | ||
| + | | deliveryaddress2 | ||
| + | | deliveryaddress3 | ||
| + | | priceformula | ||
| + | | vatregno | ||
| + | | datafield1 | ||
| + | | datafield2 | ||
| + | | datafield3 | ||
| + | | datafield4 | ||
| + | | datafield5 | ||
| + | | datafield6 | ||
| + | | datafield7 | ||
| + | | quotation | ||
| + | | contractnumber | ||
| + | | prepayment | ||
| + | | type | tyyp | | | | ||
| + | | status | ||
| + | | paymenttotal | ||
| + | | confirm | ||
| + | | stock | ladu | Stock | ALT.FROM: tr.params | ||
| + | | creditedinvoice | ||
| + | | asset | inventar | ||
| + | | dealtype | ||
| + | | delivery | ||
| + | | deliveryterm | ||
| + | | deliverytermcomment | ||
| + | | deliverymethod | ||
| + | | deliverymethodcomment | lahetusviis_komm | ||
| + | | manager | ||
| + | | changestock | ||
| + | | customer_type | ||
| + | | customer_regno | ||
| + | | customer_class | ||
| + | | customer_loyaltycard | ||
| - | ===Arved=== | + | == rows: == |
| - | what=invoice [[https:// | + | ^XML field^SQL field^UI field^Explanation^ |
| - | + | |item|artikkel|Item| | | |
| - | + | |description|seletus|Content| ALT.FROM: item | | |
| - | == Päis: === | + | |
| - | ^ XML väli ^ SQL väli | + | |
| - | | session_id | + | |
| - | | number | + | |
| - | | date | aeg | Kuupäev | + | |
| - | | duedate | + | |
| - | | transactiondate | + | |
| - | | vatzone | + | |
| - | | paymentterm | + | |
| - | | ordernumber | + | |
| - | | latepaymentpenalty | + | |
| - | | object | + | |
| - | | project | + | |
| - | | account | + | |
| - | | country | + | |
| - | | currency | + | |
| - | | currencyrate | + | |
| - | | customercode | + | |
| - | | customername | + | |
| - | | orderer_code | + | |
| - | | contact | + | |
| - | | comment | + | |
| - | | intcomment | + | |
| - | | salesman | + | |
| - | | language | + | |
| - | | customerordernumber | + | |
| - | | email | email | meil | ALT.FROM: customer | + | |
| - | | address1 | + | |
| - | | address2 | + | |
| - | | address3 | + | |
| - | | phone | telefon | + | |
| - | | fax | faks | Faks | + | |
| - | | deliveryname | + | |
| - | | deliveryaddress1 | + | |
| - | | deliveryaddress2 | + | |
| - | | deliveryaddress3 | + | |
| - | | priceformula | + | |
| - | | vatregno | + | |
| - | | datafield1 | + | |
| - | | datafield2 | + | |
| - | | datafield3 | + | |
| - | | datafield4 | + | |
| - | | datafield5 | + | |
| - | | datafield6 | + | |
| - | | datafield7 | + | |
| - | | quotation | + | |
| - | | contractnumber | + | |
| - | | prepayment | + | |
| - | | type | tyyp | | | | + | |
| - | | status | + | |
| - | | paymenttotal | + | |
| - | | confirm | + | |
| - | | stock | ladu | Ladu | ALT.FROM: tr.params | + | |
| - | | creditedinvoice | + | |
| - | | asset | inventar | + | |
| - | | dealtype | + | |
| - | | delivery | + | |
| - | | deliveryterm | + | |
| - | | deliverytermcomment | + | |
| - | | deliverymethod | + | |
| - | | deliverymethodcomment | + | |
| - | | manager | + | |
| - | | changestock | + | |
| - | | customer_type | + | |
| - | | customer_regno | + | |
| - | | customer_class | + | |
| - | | customer_loyaltycard | + | |
| - | + | ||
| - | == read: == | + | |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | |
| - | |item|artikkel|Artikkel| | | + | |
| - | |description|seletus|Sisu| ALT.FROM: item | | + | |
| |variant|variant|Variant| | | |variant|variant|Variant| | | ||
| - | |price|hind|Ühikuhind| unit price without vat | | + | |price|hind|Unit price| unit price without vat | |
| |discount|pross|%| | | |discount|pross|%| | | ||
| - | |quantity|kogus|Kogus| | | + | |quantity|kogus|Quantity| | |
| - | |unit|yhik|Ühik| ALT.FROM: item | | + | |unit|yhik|Unit| ALT.FROM: item | |
| - | |sum|summa|Summa| | | + | |sum|summa|Sum| | |
| - | |account|konto|Konto| ALT.FROM: item > item class (depending on vatregion) | | + | |account|konto|Account| ALT.FROM: item > item class (depending on vatregion) | |
| - | |object|objektid|Objekt| ALT.FROM: item > item class | | + | |object|objektid|Object| ALT.FROM: item > item class | |
| - | |project|projekt|Projekt| ALT.FROM: item > item class | | + | |project|projekt|Project| ALT.FROM: item > item class | |
| - | |purchaseprice|kulu|Ostuhind| ALT.FROM: item | | + | |purchaseprice|kulu|Purchase price| ALT.FROM: item | |
| - | |vatcode|kmk|KMk| ALT.FROM: customer > item > item class (depending on vatregion)| | + | |vatcode|kmk|VAT code| ALT.FROM: customer > item > item class (depending on vatregion)| |
| - | |comment|r_kommentaar|Kommentaar| | | + | |comment|r_kommentaar|Comment| | |
| |date1|r_aeg1| | | | |date1|r_aeg1| | | | ||
| |date2|r_aeg2| | | | |date2|r_aeg2| | | | ||
| - | |salesman|r_myyja|Müüja| | | + | |salesman|r_myyja|Salesperson| | |
| |order|tellimus| | | | |order|tellimus| | | | ||
| |orderrow|trn| | | | |orderrow|trn| | | | ||
| - | |stock|r_ladu|Ladu| | | + | |stock|r_ladu|Stock| | |
| - | |sn|seerianumber|Seerianr| | | + | |sn|seerianumber|Serial no.| | |
| - | |deliverytime|lahetusaeg|Lähetusaeg| | | + | |deliverytime|lahetusaeg|Delivery time| | |
| - | |customer|r_klient|Tellija| | | + | |customer|r_klient|Customer| | |
| - | |customername|r_klient_nimi|Tellija nimi| | | + | |customername|r_klient_nimi|Customer name| | |
| - | |text1|tekst1|Tekst1| | | + | |text1|tekst1|Text1| | |
| - | |text2|tekst2|Tekst2| | | + | |text2|tekst2|Text2| | |
| - | |text3|tekst3|Tekst3| | | + | |text3|tekst3|Text3| | |
| - | |text4|tekst4|Tekst4| | | + | |text4|tekst4|Text4| | |
| - | |constant1|konstant1|Konstant1| | | + | |constant1|konstant1|Constant1| | |
| - | |constant2|konstant2|Konstant2| | | + | |constant2|konstant2|Constant2| | |
| - | |constant3|konstant3|Konstant3| | | + | |constant3|konstant3|Constant3| | |
| - | |constant4|konstant4|Konstant4| | | + | |constant4|konstant4|Constant4| | |
| - | |shelf|riiul|Riiul| | | + | |shelf|riiul|Shelf| | |
| - | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | |rn|rn|No.|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|Rr|row reference for grouping, otherwise equals to rn , ALT.FROM: equals to rn | |
| - | == Arvete transpordi parameetrid | + | == Invoice transport parameters |
| - | ^TÜÜP^KOOD^PARAMEETER | + | ^TYPE^CODE^PARAMETER |
| - | |XML|xd_changestock|0|INVOICE|Ladumuutev arve (Param.1 =1 on muuda ladu)| | + | |XML|xd_changestock|0|INVOICE|Stock changing invoice |
| - | |XML|xd_autocustomer_autocode|0|INVOICE|Seotud kliendi loomisel luuakse kood liideses, unikaalne | + | |XML|xd_autocustomer_autocode|0|INVOICE|When creating a related customer, the code is created in the interface, a unique |
| - | |XML|xd_update|1|INVOICE|Luba dokumendi | + | |XML|xd_update|1|INVOICE|Allow document |
| - | |XML|xd_customer_update|0|INVOICE|Kliendi andmete osaline | + | |XML|xd_customer_update|0|INVOICE|Partial |
| - | |XML|xd_object|TEST_OBJEKT|INVOICE|Vaikimisi objekt, kui ei saadeta| | + | |XML|xd_object|TEST_OBJECT|INVOICE|Default object if not sent| |
| - | |XML|xd_salesman|XML|INVOICE|Vaikimisi müüja| | + | |XML|xd_salesman|XML|INVOICE|Default salesperson| |
| - | |XML|xd_stock|PL|INVOICE|Vaikimisi ladu, kui ei saadeta| | + | |XML|xd_stock|PL|INVOICE|Default stock if not sent| |
| - | |XML|xd_confirm|0|INVOICE|Automaatne dokumendi kinnitamine, seda saab ka juhtida XML väljaga | + | |XML|xd_confirm|0|INVOICE|Automatic document confirmation, can also be controlled with the " |
| - | |XML|xd_posinvoice|0|INVOICE|1 = kassaarve| | + | |XML|xd_posinvoice|0|INVOICE|1 = POS invoice| |
| - | |XML|xd_autocustomer|0|INVOICE|Automaatne seotud kliendi loomine, kui kliendi koodi ei eksisteeri| | + | |XML|xd_autocustomer|0|INVOICE|Automatic creation of a related customer if the customer code does not exist| |
| - | Arve vaikimisi väärtuste seadistamiseks loe täpsemalt | + | To configure default invoice values, read more [[https:// |
| - | + | ===Orders | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | ===Tellimused | + | |
| what=order | what=order | ||
| - | [[https:// | + | [[https:// |
| - | + | ||
| - | == Päis: === | + | |
| - | ^ XML väli ^ SQL väli ^ UI väli ^ Selgitus | + | |
| - | | session_id | + | |
| - | | number | + | |
| - | | customercode | + | |
| - | | customername | + | |
| - | | date | aeg | Kuupäev | + | |
| - | | address1 | + | |
| - | | address2 | + | |
| - | | address3 | + | |
| - | | deliveryaddress1 | + | |
| - | | deliveryaddress2 | + | |
| - | | deliveryaddress3 | + | |
| - | | paymentterm | + | |
| - | | deliverymethod | + | |
| - | | customerordernumber | + | |
| - | | email | email | meil | ALT.FROM: customer | + | |
| - | | phone | telefon | + | |
| - | | comment | + | |
| - | | stock | ladu | Ladu | ALT.FROM: tr.params | + | |
| - | | object | + | |
| - | | contact | + | |
| - | | datafield1 | + | |
| - | | datafield2 | + | |
| - | | datafield3 | + | |
| - | | datafield4 | + | |
| - | | datafield5 | + | |
| - | | datafield6 | + | |
| - | | datafield7 | + | |
| - | | paymenttotal | + | |
| - | | vatzone | + | |
| - | | priceformula | + | |
| - | | currency | + | |
| - | | currencyrate | + | |
| - | | vatregno | + | |
| - | | country | + | |
| - | | status | + | |
| - | | delivery | + | |
| - | | customer_type | + | |
| - | | customer_regno | + | |
| - | | customer_loyaltycard | + | |
| - | | salesman | + | |
| - | | project | + | |
| - | | deliveryname | + | |
| - | | factoring | + | |
| - | | deliveryterm | + | |
| - | | language | + | |
| - | + | ||
| - | == Read: == | + | |
| - | ^ XML väli ^ SQL väli ^ UI väli ^ Selgitus | + | |
| - | | item | artikkel | + | |
| - | | description | + | |
| - | | price | yhikuhind | + | |
| - | | quantity | + | |
| - | | discount | + | |
| - | | account | + | |
| - | | vatcode | + | |
| - | | unit | yhik | Ühik | ALT.FROM: item | | + | |
| - | | comment | + | |
| - | | variant | + | |
| - | | deliverytime | + | |
| - | | stock | r_ladu | + | |
| - | | project | + | |
| - | | ext_sum | + | |
| - | | ext_id | + | |
| - | | 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 | | + | |
| - | ==Tellimuse transpordi parameetrid | + | == Header: === |
| - | ^TÜÜP^KOOD^PARAMEETER | + | ^ XML field ^ SQL field ^ UI field ^ Explanation |
| - | |XML|xd_stock|PL|ORDER|Vaikimisi ladu, kui ei saadeta| | + | | session_id |
| - | |XML|xd_object|VEEB|ORDER|Vaikimisi objekt, kui ei saadeta| | + | | number |
| - | |XML|xd_autocustomer|1|ORDER|Automaatne seotud kliendi loomine, kui kliendi koodi ei eksisteeri| | + | | customercode |
| - | |XML|xd_confirm|0|ORDER|Automaatne dokumendi kinnitamine, seda saab ka juhtida | + | | customername |
| - | |XML|xd_update|1|ORDER|Luba dokumendi | + | | date | aeg | Date | ALT.FROM: current time | |
| - | |XML|xd_autocustomer_autocode|0|ORDER|Seotud kliendi loomisel luuakse kood liideses, unikaalne | + | | address1 |
| - | |XML|xd_customer_update|0|ORDER|Kliendi andmete osaline | + | | address2 |
| - | |XML|xd_salesman|XML|ORDER|Vaikimisi müüja|x | + | | address3 |
| - | |XML|xd_confirmpayment|1|ORDER|Automaatne laekumise kinnitamine| | + | | deliveryaddress1 |
| - | |XML|xd_paymentvatcode|11|ORDER|Loodava seotud laekumise rea km kood, laekumine tekib välja „paymentamount“ saatmisel, mis peab skeemis olemas olema | | + | | deliveryaddress2 |
| - | |XML|xd_order_assemble|1|ORDER|Käivitab tellimuse komplekteerija retseptidega artiklitele | + | | deliveryaddress3 |
| + | | paymentterm | ||
| + | | deliverymethod | ||
| + | | customerordernumber | ||
| + | | email | email | e-mail | ||
| + | | phone | telefon | ||
| + | | comment | ||
| + | | stock | ladu | Stock | ALT.FROM: tr.params | ||
| + | | object | ||
| + | | contact | ||
| + | | datafield1 | ||
| + | | datafield2 | ||
| + | | datafield3 | ||
| + | | datafield4 | ||
| + | | datafield5 | ||
| + | | datafield6 | ||
| + | | datafield7 | ||
| + | | paymenttotal | ||
| + | | vatzone | ||
| + | | priceformula | ||
| + | | currency | ||
| + | | currencyrate | ||
| + | | vatregno | ||
| + | | country | ||
| + | | status | ||
| + | | delivery | ||
| + | | customer_type | ||
| + | | customer_regno | ||
| + | | customer_loyaltycard | ||
| + | | salesman | ||
| + | | project | ||
| + | | deliveryname | ||
| + | | factoring | ||
| + | | deliveryterm | ||
| + | | language | ||
| + | == Rows: == | ||
| + | ^ XML field ^ SQL field ^ UI field ^ Explanation | ||
| + | | item | artikkel | ||
| + | | description | ||
| + | | price | yhikuhind | ||
| + | | quantity | ||
| + | | discount | ||
| + | | account | ||
| + | | vatcode | ||
| + | | unit | yhik | Unit | ALT.FROM: item | | ||
| + | | comment | ||
| + | | variant | ||
| + | | deliverytime | ||
| + | | stock | r_ladu | ||
| + | | project | ||
| + | | ext_sum | ||
| + | | ext_id | ||
| + | | rn | rn | No. | row order number in document 1 - N , ALT.FROM: random | ||
| + | | rr | rv | Rr | row reference for grouping, otherwise equals to rn , ALT.FROM: equals to rn | | ||
| + | ==Order transport parameters | ||
| + | ^TYPE^CODE^PARAMETER | ||
| + | |XML|xd_stock|PL|ORDER|Default stock, if not sent| | ||
| + | |XML|xd_object|VEEB|ORDER|Default object, if not sent| | ||
| + | |XML|xd_autocustomer|1|ORDER|Automatic creation of a related customer if the customer code does not exist| | ||
| + | |XML|xd_confirm|0|ORDER|Automatic document confirmation, this can also be controlled with the XML field " | ||
| + | |XML|xd_update|1|ORDER|Allow document | ||
| + | |XML|xd_autocustomer_autocode|0|ORDER|When creating a related customer, the code is created in the interface, a unique | ||
| + | |XML|xd_customer_update|0|ORDER|Partial | ||
| + | |XML|xd_salesman|XML|ORDER|Default salesperson|x | ||
| + | |XML|xd_confirmpayment|1|ORDER|Automatic receipt confirmation| | ||
| + | |XML|xd_paymentvatcode|11|ORDER|VAT code for the created related receipt row, receipt is generated upon sending the "paymentamount" field, which must exist in the schema | ||
| + | |XML|xd_order_assemble|1|ORDER|Triggers the order assembler for items with recipes | ||
| - | Tellimuse vaikimisi väärtuste seadistamiseks loe täpsemalt | + | To configure default order values, read more [[https:// |
| - | ===Laekumised | + | ===Receipts |
| what=receipt | what=receipt | ||
| - | [[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|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 | | + | |number|number|Receipt| 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 | | + | |date|aeg|Time| ALT.FROM: current time | |
| - | |description|seletus|Kommentaar| | | + | |description|seletus|Comment| | |
| - | |paymentmode|tasumisviis|Tas. viis| | | + | |paymentmode|tasumisviis|Paym. method| | |
| - | |user|kasutaja|Kasutaja| | | + | |user|kasutaja|User| | |
| - | |reference|viide|Viide| | | + | |reference|viide|Reference| | |
| - | |object|objekt|Objekt| ALT.FROM: tr.params | | + | |object|objekt|Object| ALT.FROM: tr.params | |
| - | |project|projekt|Projekt| ALT.FROM: tr.params | | + | |project|projekt|Project| ALT.FROM: tr.params | |
| - | |location|arvuti|Koht| | | + | |location|arvuti|Location| | |
| |confirm|kinnita| | confirm document = 1 | | |confirm|kinnita| | confirm document = 1 | | ||
| - | ==read: == | + | ==rows: == |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | ^XML field^SQL field^UI field^Explanation^ |
| - | |invoice|arvenumber|Arve nr| | | + | |invoice|arvenumber|Invoice no| | |
| - | |aeg|raeg|Aeg| ALT.FROM: receipt header | | + | |aeg|raeg|Time| ALT.FROM: receipt header | |
| - | |customer|klient_kood|Klient| ALT.FROM: invoice > order > customer by regno field | | + | |customer|klient_kood|Customer| ALT.FROM: invoice > order > customer by regno field | |
| - | |order|ettemaks|Tellimuse nr| | | + | |order|ettemaks|Order No.| | |
| - | |customername|klient_nimi|Tekst| ALT.FROM: invoice > order > customer by regno field | | + | |customername|klient_nimi|Text| ALT.FROM: invoice > order > customer by regno field | |
| - | |payment|tasuti|Tasuti| ALT.FROM: in case of base currency = received field | | + | |payment|tasuti|Paid| ALT.FROM: in case of base currency = received field | |
| - | |bankcurrency|valuuta_p|Val saadud| ALT.FROM: glob.settings > ' | + | |bankcurrency|valuuta_p|Curr. received| ALT.FROM: glob.settings > ' |
| - | |received|summa_p|Summa S| | | + | |received|summa_p|Amount R| | |
| - | |currencyrate|kurss_p|Kurss S| ALT.FROM: ECB current published rates | | + | |currencyrate|kurss_p|Rate R| ALT.FROM: ECB current published rates | |
| - | |paymentfee|teenustasu|T-Tasu| | | + | |paymentfee|teenustasu|S-Fee| | |
| - | |vatcode|kmk|KMk| ALT.FROM: tr.params | | + | |vatcode|kmk|VAT code| ALT.FROM: tr.params | |
| - | |paymentfeecurrency|valuuta_teenus|T-Tasu val.| | | + | |paymentfeecurrency|valuuta_teenus|S-Fee curr.| | |
| - | |description|selgitus|Selgitus| | | + | |description|selgitus|Explanation| | |
| - | |regno|reg|Reg number/IK| ALT.FROM: customer | | + | |regno|reg|Reg number/PC| ALT.FROM: customer | |
| - | |bankaccount|arveldusarve|Arveldusarve| | | + | |bankaccount|arveldusarve|Bank account| | |
| - | |objects|objektid|Objekt| ALT.FROM: invoice > order | | + | |objects|objektid|Object| ALT.FROM: invoice > order | |
| - | |account|r_konto|Konto| | | + | |account|r_konto|Account| | |
| - | |fine|viivis|Viivis| | | + | |fine|viivis|Penalty| | |
| - | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | |rn|rn|No.|row order number in document 1 - N , ALT.FROM: random | |
| - | + | ===Transactions | |
| - | ===Kanded | + | |
| what=transaction | what=transaction | ||
| - | [[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; With combination of field " | |number|number|Number| document number/ID, mandatory; With combination of field " | ||
| - | |date|aeg2|Aeg| | | + | |date|aeg2|Time| | |
| - | |reference|viide|Viide| | | + | |reference|viide|Reference| | |
| - | |comment|seletus|Seletus| | | + | |comment|seletus|Explanation| | |
| - | |type|tyyp|Tüüp| ALT.: FIN | | + | |type|tyyp|Type| ALT.: FIN | |
| - | ==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|Objektid| | | + | |object|objekt|Objects| | |
| - | |description|sisu|Sisu| ALT.FROM: account | | + | |description|sisu|Content| ALT.FROM: account | |
| - | |vatcode|kmkood|KM kood| | | + | |vatcode|kmkood|VAT code| | |
| - | |quantity|kogus|Kogus| | | + | |quantity|kogus|Quantity| | |
| - | |debitamount|baas1deebet|Deebet| | | + | |debitamount|baas1deebet|Debit| | |
| - | |creditamount|baas1kreedit|Kreedit| | | + | |creditamount|baas1kreedit|Credit| | |
| - | |currencydebit|valuutadeebet|Val. deebet| | | + | |currencydebit|valuutadeebet|Curr. debit| | |
| - | |currencycredit|valuutakreedit|Val. kreedit| | | + | |currencycredit|valuutakreedit|Curr. credit| | |
| - | |currencyrate|b1kursile|Kurss| ALT.FROM: ECB current published rates | | + | |currencyrate|b1kursile|Rate| ALT.FROM: ECB current published rates | |
| - | |currency|valuuta|Valuuta| ALT.FROM: glob.settings > ' | + | |currency|valuuta|Currency| ALT.FROM: glob.settings > ' |
| - | |date|r_aeg|Aeg| | | + | |date|r_aeg|Time| | |
| - | |supplier|hankija|Hankija| | | + | |supplier|hankija|Supplier| | |
| - | |customer|klient|Klient| | | + | |customer|klient|Customer| | |
| - | |project|projekt|Projekt| | | + | |project|projekt|Project| | |
| - | |rn|rn|Nr|row order number in document 1 - N , ALT.FROM: random | | + | |rn|rn|No.|row order number in document 1 - N , ALT.FROM: random | |
| - | + | ===Customers=== | |
| - | ===Kliendid=== | + | * When posting and modifying, |
| - | * Postitamisel ja muutmisel on alati nõutud | + | |
| what=customer | what=customer | ||
| - | [[https:// | + | [[https:// |
| - | ==Kliendid | + | ==Customers |
| - | ^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| | |
| - | |object|objekt|Objekt| | | + | |object|objekt|Object| | |
| - | |address1|aadress1|aadress, ! vastavalt seadetele| | | + | |address1|aadress1|address, ! according to settings| | |
| - | |address2|aadress2|aadress, ! vastavalt seadetele| | | + | |address2|aadress2|address, ! according to settings| | |
| - | |address3|aadress3|aadress, ! vastavalt seadetele| | | + | |address3|aadress3|address, ! according to settings| | |
| - | |deliveryaddress1|lahaadress1|aadress, ! vastavalt seadetele| | | + | |deliveryaddress1|lahaadress1|address, ! according to settings| | |
| - | |deliveryaddress2|lahaadress2|aadress, ! vastavalt seadetele| | | + | |deliveryaddress2|lahaadress2|address, ! according to settings| | |
| - | |deliveryaddress3|lahaadress3|aadress, ! vastavalt seadetele| | | + | |deliveryaddress3|lahaadress3|address, ! according to settings| | |
| - | |county|maakond|Maakond| | | + | |county|maakond|County| | |
| - | |country|asumaa|Asumaa| | | + | |country|asumaa|Country| | |
| - | |contact|kontakt|Esindaja| | | + | |contact|kontakt|Representative| | |
| - | |phone|telefon|Telefon| | | + | |phone|telefon|Phone| | |
| - | |email|email|Meil| mandatory | | + | |email|email|E-mail| mandatory | |
| - | |regno|regnr|Reg | + | |regno|regnr|Reg |
| - | |vatregno|kmregnr|Km reg nr| | | + | |vatregno|kmregnr|VAT reg no| | |
| - | |notice|margukiri|Märgukirjad| yes = 1 | | + | |notice|margukiri|Notices| yes = 1 | |
| - | |birthday|klient_synnipaev|Sünnipäev| | | + | |birthday|klient_synnipaev|Birthday| | |
| - | |gender|klient_sugu|Sugu| female = 1, male = 0 | | + | |gender|klient_sugu|Gender| female = 1, male = 0 | |
| - | |class|klass|Klass| | | + | |class|klass|Class| | |
| - | |type|klient_tyyp|Tüüp| company = 0, private citizen = 1, government institution = 2 | | + | |type|klient_tyyp|Type| company = 0, private citizen = 1, government institution = 2 | |
| - | |loyaltycard|kliendikaart|Kliendikaart| also used for personal ID code | | + | |loyaltycard|kliendikaart|Loyalty card| also used for personal ID code | |
| - | |deliveryname|nimi_lahetusel|Nimi lähetusel| | | + | |deliveryname|nimi_lahetusel|Name on delivery| | |
| - | |deliverymode|lahetusviis|Läh. viis| | | + | |deliverymode|lahetusviis|Deliv. method| | |
| - | |alert|hoiatus|Hoiatus| | | + | |alert|hoiatus|Warning| | |
| - | |factoring|arvetasub|Arve tasub| | | + | |factoring|arvetasub|Invoice paid by| | |
| - | |fax|faks|Faks| | | + | |fax|faks|Fax| | |
| - | |comment|kommentaar|Kommentaar| | | + | |comment|kommentaar|Comment| | |
| - | |payterm|tingimus|Tas. ting.| | | + | |payterm|tingimus|Pay. term.| | |
| - | |vatzone|maa|KM maa| local = 0, EU = 1, export = 2 | | + | |vatzone|maa|VAT zone| local = 0, EU = 1, export = 2 | |
| - | |language|keel|Keel| | | + | |language|keel|Language| | |
| - | |salesman|myyja|Müüja| | | + | |salesman|myyja|Salesperson| | |
| - | |bank|pank|Pank| | | + | |bank|pank|Bank| | |
| - | |bankaccount|arveldusarve|A/a | | | + | |bankaccount|arveldusarve|Acct. no | | |
| |url|URL|Url| | | |url|URL|Url| | | ||
| - | |status|staatus|Staatus| | | + | |status|staatus|Status| | |
| - | |accountmanager|kliendihaldur|Haldur| | | + | |accountmanager|kliendihaldur|Manager| | |
| - | |dealtype|tehinguliik|Tehinguliik| | | + | |dealtype|tehinguliik|Transaction type| | |
| - | |creditlimit|limiit|Limiit| | | + | |creditlimit|limiit|Limit| | |
| - | |priceformula|hinnakiri|Hinnavalem| | | + | |priceformula|hinnakiri|Price formula| | |
| - | |specialpriceformula|hinnavalem_eri|Eripakkumised| | | + | |specialpriceformula|hinnavalem_eri|Special offers| | |
| - | |discount|ale|Soodus | + | |discount|ale|Discount |
| - | |destination|sihtriik|Sihtriik| | | + | |destination|sihtriik|Destination| | |
| |firstname|eesnimi| | | | |firstname|eesnimi| | | | ||
| |lastname|perenimi| | | | |lastname|perenimi| | | | ||
| - | |vatcode|kmkood|KM kood| | | + | |vatcode|kmkood|VAT code| | |
| - | |extcode|valine_kood|Väline kood| | | + | |extcode|valine_kood|External code| | |
| - | |deliveryinvoice|lah_arve|Lähetus| Lähetus ja Arve = 1, Lähetus | + | |deliveryinvoice|lah_arve|Shipment| Shipment and Invoice |
| - | |currency|valuuta|Valuuta| | | + | |currency|valuuta|Currency| | |
| |closed|suletud| | | | |closed|suletud| | | | ||
| - | == Lisaväljad: ==== | + | == Additional fields: ==== |
| - | ^XML väli^SQL väli^UI väli^Selgitus^ | + | ^XML field^SQL field^UI field^Explanation^ |
| |code|kood| | | | |code|kood| | | | ||
| - | |content|sisu|Sisu| | | + | |content|sisu|Content| | |
| - | |param|param|Parameeter| | | + | |param|param|Parameter| | |
| - | + | ==Customer transport parameters | |
| - | + | ^ TYPE | |
| - | ==Kliendi transpordi parameetrid | + | ===Suppliers |
| - | ^ TÜÜP | + | * When posting and modifying, |
| - | + | ||
| - | + | ||
| - | ===Hankijad | + | |
| - | * Postitamisel ja muutmisel on alati nõutud | + | |
| 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 501: | Line 497: | ||
| |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 628: | Line 619: | ||
| |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 694: | Line 681: | ||
| |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 729: | Line 716: | ||
| |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 781: | Line 765: | ||
| |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 826: | Line 810: | ||
| |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.1753876738.txt.gz · Last modified: 2025/07/30 14:58 by toomas