Kaupo: Uus lehekülg: 'Antud dokumendis on kirjeldatud, kuidas toimib Standard Booksis Telema vaates tarnija roll. Standard Booksis loome lahenduse, kus kasutaja saab Telemasse saata Ostutellimuse. Te...'

2019-04-16T10:24:18Z

Uus lehekülg: 'Antud dokumendis on kirjeldatud, kuidas toimib Standard Booksis Telema vaates tarnija roll. Standard Booksis loome lahenduse, kus kasutaja saab Telemasse saata Ostutellimuse. Te...'

Uus lehekülg

Antud dokumendis on kirjeldatud, kuidas toimib Standard Booksis Telema vaates tarnija roll.

Standard Booksis loome lahenduse, kus kasutaja saab Telemasse saata Ostutellimuse. Telema portaalist tuleb vastu EDI Ostuarve (See ei ole Eesti E-arve formaat, mida kasutab e-arve operaatorina Telema E-Flow).
===Telema Ostutellimus===
====Seadistused====
======Moodul Logistika > Registrid > Ostutellimuse kaart======
Ostutellimuse kaardile lisame Operatsioonide valiku alla:
*Saada ostutellimus Telemasse (Loob ostutellimusest XML faili ja edastab selle Telema APIga Telema teenusesse)
*E-ostutellimuse hetkeseis (annab teada oleku, mis on saanud Ostutellimuse eksportimisest - Eksportimata, Saatmisel, Saadetud jms. Samad staatused, mis Telemasse edastatud Lähetuse ja Arve peal)
======Moodul Üldine > Seadistused > Telema 4doc seadistused======
*Valik - "Saada kinnitatud dokumendi Telemasse automaatselt". Kui see valik on peal ning Tarnija kaardil on e-arve vahelehel operaatoriks märgitud Telema, siis saadetakse Ostutellimus telemasse kinnitamise hetkel.
======Moodul Logistika > Seadistused > Telema API ekspordi järjekord======
Kui Ostutellimus eksporditakse, lisatakse kirje siia registrisse, sarnaselt Lähetustele ja Arvetele
====Telema Ostutellimuse väljad====
{| class="wikitable"
!Väli Telema ostutellimuse XMLis
!Milliselt Standard Booksi väljalt info võtame
!Näide
!Kommentaar
|-
|E-Document > Header > DateIssued
|''Current Date''
|2019-02-19
|
|-
|E-Document > Header > SenderID
|Ladu
|NRV
|Ostutellimuselt Lao kood
|-
|E-Document > Header > ReceiverID
|Tarnija Reg Nr
|22446688
|
|-
|E-Document > Header > ReceiverRegNum
|Tarnija Reg Nr
|22446688
|
|-
|E-Document > Header > ReceiverCountryCode
|Tarnija kaardilt riigi kood
|EE
|
|-
|E-Document > Document > DocumentType
|''order''
|order
|Hardcode
|-
|E-Document > Document > DocumentParties > BuyerParty > PartyCode
|Meie reg nr
|10877000
|Üldine > Ettevõtte andmetest
|-
|E-Document > Document > DocumentParties > BuyerParty > Name
|Meie nimi
|Hulgiladu Exc AS
|Üldine > Ettevõtte andmetest
|-
|E-Document > Document > DocumentParties > BuyerParty > RegNum
|Meie reg nr
|10877000
|Üldine > Ettevõtte andmetest
|-
|E-Document > Document > DocumentParties > BuyerParty > VATRegNum
|Meie KMKR number
|EE32165487
|Üldine > Ettevõtte andmetest
|-
|E-Document > Document > DocumentParties > BuyerParty > ContactData > ActualAddress > Address1
|Meie aadress rida 1
|Lõõtsa 2a
|Üldine > Ettevõtte andmetest
|-
|'''Mis nendega teha? Kõikjal, kus kasutusel "ActualAddress"'''
<City>Tallinn</City>

<PostalCode>11111</PostalCode>

<County>Harjumaa</County>

<CountryCode>EE</CountryCode>
|
|
|
|-
|E-Document > Document > DocumentParties > DeliveryParty > PartyCode
|Ladu
|NRV
|Ostutellimuselt Lao kood
|-
|E-Document > Document > DocumentParties > DeliveryParty > Name
|Lao nimi
|Narva Ladu
|Ostutellimusele asetatud Lao kaardilt Nimi
|-
|E-Document > Document > DocumentParties > DeliveryParty > ContactData > ActualAddress > Address1
|Lao aadress 1
|Kevade 3
|Ostutellimusele asetatud Lao kaardilt Aadress 1
|-
|E-Document > Document > DocumentParties > SellerParty > PartyCode
|Tarnija Reg Nr
|22446688
|Ostutellimusele asetatud Tarnija kaardilt Reg Nr
|-
|E-Document > Document > DocumentParties > SellerParty > Name
|Tarnija nimi
|Supplier OÜ
|Ostutellimuselt Tarnija nimi
|-
|E-Document > Document > DocumentParties > SellerParty > RegNum
|Tarnija Reg Nr
|22446688
|Ostutellimusele asetatud Tarnija kaardilt Reg Nr
|-
|E-Document > Document > DocumentParties > SellerParty > VATRegNum
|Tarnija KMKR Nr
|EE987987987
|Ostutellimusele asetatud Tarnija kaardilt KMKR Nr
|-
|E-Document > Document > DocumentParties > SellerParty > ContactData > ActualAddress > Address1
|Tarnija Aadress 1
|Juhtme 22
|Ostutellimusele asetatud Tarnija aadress 1
|-
|E-Document > Document > DocumentInfo > DocumentNum
|Nr
|1900088
|Ostutellimuse nr
|-
|E-Document > Document > DocumentInfo > DateInfo > OrderDate
|Kuupäev
|2019-02-18
|Ostutellimuselt kuupäev
|-
|E-Document > Document > DocumentInfo > DateInfo > DeliveryDateRequested
|Planeeritud lähetus
|2019-02-21
|Ostutellimuse planeeritud lähetuse kuupäev
|-
|E-Document > Document > DocumentInfo > CreatedByContact > ContactFirstName
|Meie esindaja
|Ele-Riin Raudsepp
|Ostutellimuse meie esindaja
|-
|E-Document > Document > DocumentInfo > CreatedByContact > PhoneNum
|Müügimehe telefon
|55884421
|Telefon müügimehe kaardilt
|-
|E-Document > Document > DocumentInfo > CreatedByContact > EmailAddress
|Müügimehe email
|ele@riin.ee
|Email müügimehe kaardilt
|-
|E-Document > Document > DocumentItem > ItemEntry > LineItemNum
|Ostutellimuse rea nr
|1
|Algab 1-st.
|-
|E-Document > Document > DocumentItem > ItemEntry > SellerItemCode
|Maatriksist Ostuartikkel kood
|321654987
|Maatriksist ostuartikli väli. Kui tühi, siis siia korrata GTIN
|-
|E-Document > Document > DocumentItem > ItemEntry > GTIN
|Artikli kaardilt Vöötkood. Kui tühi, siis EAN kood
|23656598512574
|
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemDescription
|Rea Kirjeldus
|Lenovo Thinkpad P51
|Kirjeldus Ostutellimuse realt
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemUnitRecord > ItemUnit
|Ühik
|TK
|Ühiku kood realt
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemUnitRecord > UnitNumerator
|alati 1
|1
|Vist alati 1
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemUnitRecord > UnitDenumerator
|alati 1
|1
|Vist alati 1
|-
|E-Document > Document > DocumentItem > ItemEntry > BaseUnit
|Ühik
|TK
|Ühiku kood realt
|-
|E-Document > Document > DocumentItem > ItemEntry > AmountOrdered
|Kogus
|4
|Kogus realt
|-
|E-Document > Document >AdditionalInfo > Extension > InfoName
|''märkuse tüüp''
|remarks
|alati Remarks
|-
|E-Document > Document >AdditionalInfo > Extension > InfoContent
|Kommentaar
|Tarnida ilma pakendita
|Kommentaar teellimuselt
|}
====Telema Ostutellimuse XML näidis====
<syntaxhighlight lang="xml">
<?xml version="1.0" encoding="UTF-8"?>
<E-Document>
<Header>
<DateIssued>2019-02-19</DateIssued>
<SenderID>NRV</SenderID>
<ReceiverID>22446688</ReceiverID>
<ReceiverRegNum>22446688</ReceiverRegNum>
<ReceiverCountryCode>EE</ReceiverCountryCode>
</Header>
<Document>
<DocumentType>order</DocumentType>
<DocumentParties>
<BuyerParty>
<PartyCode>10877000</PartyCode>
<Name>EXCELLENT BUSINESS SOLUTIONS EESTI AS</Name>
<RegNum>10877000</RegNum>
<VATRegNum>EE100777660</VATRegNum>
<ContactData>
<ActualAddress>
<Address1>Lõõtsa 2A</Address1>
<City>Tallinn</City>
<PostalCode>11111</PostalCode>
<County>Harjumaa</County>
<CountryCode>EE</CountryCode>
</ActualAddress>
</ContactData>
</BuyerParty>
<DeliveryParty>
<PartyCode>NRV</PartyCode>
<Name>Narva ladu</Name>
<ContactData>
<ActualAddress>
<Address1>Kevade 3</Address1>
<City>Narva</City>
<PostalCode>11111</PostalCode>
<County>Ida-Virumaa</County>
<CountryCode>EE</CountryCode>
</ActualAddress>
</ContactData>
</DeliveryParty>
<SellerParty>
<PartyCode>22446688</PartyCode>
<Name>Supplier OÜ</Name>
<RegNum>22446688</RegNum>
<VATRegNum>EE224466889</VATRegNum>
<ContactData>
<ActualAddress>
<Address1>Address</Address1>
<City>City</City>
<PostalCode>LV-1111</PostalCode>
<County>County</County>
<CountryCode>LV</CountryCode>
</ActualAddress>
</ContactData>
</SellerParty>
</DocumentParties>
<DocumentInfo>
<DocumentNum>TEST-OT9003</DocumentNum>
<DateInfo>
<OrderDate>2019-02-19</OrderDate>
<DeliveryDateRequested>2019-02-20</DeliveryDateRequested>
</DateInfo>
<CreatedByContact>
<ContactFirstName>John Smith</ContactFirstName>
<PhoneNum>123654789</PhoneNum>
<EmailAddress>j.s@email.com</EmailAddress>
</CreatedByContact>
</DocumentInfo>
<DocumentItem>
<ItemEntry>
<LineItemNum>1</LineItemNum>
<SellerItemCode>20001</SellerItemCode>
<GTIN>656598512574</GTIN>
<ItemDescription>Lenovo ThinkPad P51</ItemDescription>
<ItemUnitRecord>
<ItemUnit>tk</ItemUnit>
<UnitNumerator>1</UnitNumerator>
<UnitDenumerator>1</UnitDenumerator>
</ItemUnitRecord>
<BaseUnit>tk</BaseUnit>
<AmountOrdered>2</AmountOrdered>
</ItemEntry>
<ItemEntry>
<LineItemNum>2</LineItemNum>
<SellerItemCode>20002</SellerItemCode>
<GTIN>78965123547</GTIN>
<ItemDescription>Lenovo ThinkPad P50</ItemDescription>
<ItemUnitRecord>
<ItemUnit>tk</ItemUnit>
<UnitNumerator>1</UnitNumerator>
<UnitDenumerator>1</UnitDenumerator>
</ItemUnitRecord>
<BaseUnit>tk</BaseUnit>
<AmountOrdered>3</AmountOrdered>
</ItemEntry>
<ItemEntry>
<LineItemNum>3</LineItemNum>
<SellerItemCode>20003</SellerItemCode>
<GTIN>4564568231478</GTIN>
<ItemDescription>Lenovo ThinkPad X1 Yoga 2017 4G OLED</ItemDescription>
<ItemUnitRecord>
<ItemUnit>tk</ItemUnit>
<UnitNumerator>1</UnitNumerator>
<UnitDenumerator>1</UnitDenumerator>
</ItemUnitRecord>
<BaseUnit>tk</BaseUnit>
<AmountOrdered>6</AmountOrdered>
</ItemEntry>
</DocumentItem>
<AdditionalInfo>
<Extension extensionId='remarks'>
<InfoName>remarks</InfoName>
<InfoContent>Tarnida ilma pakendita</InfoContent>
</Extension>
</AdditionalInfo>
</Document>
</E-Document>

</syntaxhighlight>
===EDI Ostuarve===
Kui saadame Ostutellimuse välja Tarnijale, koostab ühel hetkel Tarnija enda süsteemis arve ja saadab meile tagasi. Loeme selle sisse Tarnija e-arvete registrisse. Sealt edasi käitub arve nagu iga muu Tarnija e-arve, täidetud on lisaks vaid Ostutellimuse number. Kontakti, tasumistingimuste, KM protsentide/koodide, kõikide muude reeglite puhul kehtivad samad reeglmid mis täna tarnija e-arvete puhul.

NB: Telemas tulnud E-Flow e-arve ja käesolev EDI ostuarve formaadid on erinevad! Ehk pigem meenutab EDI ostuarve EDI tellimust.
====EDI ostuarve väljad====
{| class="wikitable"
!Väli Telema EDI ostuarve XMLis
!Milliselt Standard Booksi Tarnija e-arve väljale info asetame
!Näide
!Kommentaar
|-
|E-Document > Header > DateIssued
|''Ignoreerime ostuarve impordil''
|2019-02-19
|''Current Date''
|-
|E-Document > Header > Charset
|''Ignoreerime ostuarve impordil''
|UTF-8
|''Kodeering''
|-
|E-Document > Header > Channel
|''Ignoreerime ostuarve impordil''
|WEB
|''Kanalduse kood''
|-
|E-Document > Header > SenderID
|''Ignoreerime ostuarve impordil''
|11228700
|Tarnija Reg Nr
|-
|E-Document > Header > ReceiverID
|''Ignoreerime ostuarve impordil''
|22446688
|Meie reg nr
|-
|E-Document > Document > DocumentType
|''Ignoreerime ostuarve impordil''
|invoice
|Saame teada, et tegu on Arvega. Ehm meie mõistes Tarnija e-arve
|-
|E-Document > Document > DocumentFunction
|''Ignoreerime ostuarve impordil''
|ORIGINAL
|ORIGINAL
|-
|E-Document > Document > DocumentParties > BuyerParty > PartyCode
|''Ignoreerime ostuarve impordil''
|10877000
|Üldine > Ettevõtte andmetest > Reg nr
|-
|E-Document > Document > DocumentParties > BuyerParty > Name
|''Ignoreerime ostuarve impordil''
|Hulgiladu Exc AS
|Üldine > Ettevõtte andmetest > Nimi
|-
|E-Document > Document > DocumentParties > BuyerParty > RegNum
|''Ignoreerime ostuarve impordil''
|10877000
|Üldine > Ettevõtte andmetest > Reg nr
|-
|E-Document > Document > DocumentParties > BuyerParty > VATRegNum
|''Ignoreerime ostuarve impordil''
|EE32165487
|Üldine > Ettevõtte andmetest > KMKR
|-
|E-Document > Document > DocumentParties > BuyerParty > ContactData > PhoneNum
|''Ignoreerime ostuarve impordil''
|669 1113
|Müügimehe isiku kaardilt telefon
|-
|E-Document > Document > DocumentParties > BuyerParty > ContactData > EmailAddress
|''Ignoreerime ostuarve impordil''
|eleriin@excellent.ee
|Müügimehe isiku kaardilt email
|-
|E-Document > Document > DocumentParties > BuyerParty > ContactData > ActualAddress > Address1
|''Ignoreerime ostuarve impordil''
|Lõõtsa 2a
|Üldine > Ettevõtte andmetest
|-
|'''Mis nendega teha? Kõikjal, kus kasutusel "ActualAddress"'''
<City>Tallinn</City>

<PostalCode>11111</PostalCode>

<County>Harjumaa</County>

<CountryCode>EE</CountryCode>
|
|
|
|-
|E-Document > Document > DocumentParties > DeliveryParty > PartyCode
|''Ignoreerime ostuarve impordil''
|NRV
|Ostutellimuselt Lao kood
|-
|E-Document > Document > DocumentParties > DeliveryParty > Name
|''Ignoreerime ostuarve impordil''
|Narva Ladu
|Ostutellimusele asetatud Lao kaardilt Nimi
|-
|E-Document > Document > DocumentParties > DeliveryParty > ContactData > EmailAddress
|''Ignoreerime ostuarve impordil''
|narva@excellent.ee
|Ostutellimusele asetatud Lao kaardilt email
|-
|E-Document > Document > DocumentParties > DeliveryParty > ContactData > PhoneNum
|''Ignoreerime ostuarve impordil''
|662441121
|Ostutellimusele asetatud Lao kaardilt Telefon
|-
|E-Document > Document > DocumentParties > DeliveryParty > ContactData > ActualAddress > Address1
|Tarnija e-arve > Läh aadress vahelelht > Aadress 1
|Kevade 3
|Ostutellimusele asetatud Lao kaardilt Aadress 1
|-
|'''Mis nendega teha? Kõikjal, kus kasutusel "ActualAddress"'''
<City>Tallinn</City>

<PostalCode>11111</PostalCode>

<County>Harjumaa</County>

<CountryCode>EE</CountryCode>
|
|
|
|-
|E-Document > Document > DocumentParties > SellerParty > PartyCode
|''Ignoreerime ostuarve impordil''
|22446688
|Ostutellimusele asetatud Tarnija kaardilt Reg Nr
|-
|E-Document > Document > DocumentParties > SellerParty > Name
|Tarnija e-arve > Tarnija andmed vahelelht > Nimi
|Supplier OÜ
|Ostutellimuselt Tarnija nimi
|-
|E-Document > Document > DocumentParties > SellerParty > RegNum
|Tarnija e-arve > Meie andmed vahelelht > Tarn. Reg. nr
|22446688
|Ostutellimusele asetatud Tarnija kaardilt Reg Nr
|-
|E-Document > Document > DocumentParties > SellerParty > VATRegNum
|Tarnija e-arve > Meie andmed vahelelht > Tarn. KMKR. nr
|EE987987987
|Ostutellimusele asetatud Tarnija kaardilt KMKR Nr
|-
|E-Document > Document > DocumentParties > SellerParty > ContactData > PhoneNum
|Tarnija e-arve > Tarnija andmed vahelelht > Telefon
|654456654
|Ostutellimusele asetatud Tarnija kaardilt Telefon
|-
|E-Document > Document > DocumentParties > SellerParty > ContactData > EmailAddress
|Tarnija e-arve > Tarnija andmed vahelelht > E-mail
|info@excellent.ee
|Ostutellimusele asetatud Tarnija kaardilt email
|-
|E-Document > Document > DocumentParties > SellerParty > ContactData > ActualAddress > Address1
|Tarnija e-arve > Tarnija andmed vahelelht > Aadress (1. rida)
|Juhtme 22
|Ostutellimusele asetatud Tarnija aadress 1
|-
|'''Mis nendega teha? Kõikjal, kus kasutusel "ActualAddress"'''
<City>Tallinn</City>

<PostalCode>11111</PostalCode>

<County>Harjumaa</County>

<CountryCode>EE</CountryCode>
|
|
|
|-
|E-Document > Document > DocumentInfo > DocumentSubType
|DEB või CRED
|DEB
|Kas tavaline (Deb) või kreeditarve
|-
|E-Document > Document > DocumentInfo > DocumentName
|''Ignoreerime ostuarve impordil''
|invoice
|Dokumendi nimi. Lihtsalt.
|-
|E-Document > Document > DocumentInfo > DocumentNum
|Tarnija e-arve > Meie andmed vahelelht > Tarn. arve nr
|3563635645
|Arve nr
|-
|E-Document > Document > DocumentInfo > DateInfo > IssueDate
|''Ignoreerime ostuarve impordil''
|2019-04-04T10:58:24
|Current Date ja time dokumendi saatmisel
|-
|E-Document > Document > DocumentInfo > DateInfo > InvoiceDate
|Tarnija e-arve > Tingimused > Arve Kuupäev
Tarnija e-arve > Tingimused > Kande kp
|2019-04-04
|Arve kuupäev
|-
|E-Document > Document > DocumentInfo > DateInfo > DueDate
|Tarnija e-arve > Tingimused > Laekumistähtaeg
|2019-04-25
|Arve tähtaeg
|-
|E-Document > Document > DocumentInfo > DateInfo > DeliveryDateRequested
|''Ignoreerime ostuarve impordil''
|2019-04-09
|Planeeritud lähetuse kuupäev ostutellimuselt
|-
|E-Document > Document > DocumentInfo > DateInfo > DeliveryDateActual
|''Ignoreerime ostuarve impordil''
|2019-04-09
|Aga kui on mitu? Oeh... Võime ka välja jätta selle
|-
|E-Document > Document > DocumentInfo > RefInfo > SourceDocument (NB: type) > SourceDocumentNum
|Tarnija e-arve > Meie andmed vahelelht > Meie ostutell. nr.
|TEST-OT9003
|Seotud ostutellimuse nr
|-
|E-Document > Document > DocumentInfo > RefInfo > SourceDocument (NB: type) > SourceDocumentDate
|''Ignoreerime ostuarve impordil''
|2019-02-19T00:00:00
|Seotud ostutellimuse kuupäev
|-
|E-Document > Document > DocumentInfo > CreatedBy
|Tarnija e-arve > Tingimused > Tarnija esindaja
|Ele-Riin Raudsepp
|Müügimehe nimi
|-
|E-Document > Document > DocumentInfo > CreatedByContact > ContactFirstName
|''Ignoreerime ostuarve impordil''
|Ele-Riin Raudsepp
|Ostutellimuse meie esindaja
|-
|E-Document > Document > DocumentInfo > CreatedByContact > PhoneNum
|''Ignoreerime ostuarve impordil''
|55884421
|Telefon müügimehe kaardilt
|-
|E-Document > Document > DocumentInfo > CreatedByContact > EmailAddress
|''Ignoreerime ostuarve impordil''
|ele@riin.ee
|Email müügimehe kaardilt
|-
|E-Document > Document > DocumentInfo > Attachments > File > FileName
|Manuse Faili nimi
|invoice-3563635645.pdf
|Faili nimi. See läheb Ostuarve manusesse
|-
|E-Document > Document > DocumentInfo > Attachments > File > FileType
|Manuse Faili tüüp
|application/pdf
|Faili tüüp
|-
|E-Document > Document > DocumentInfo > Attachments > File > FileBase64
|Manuse Faili sisu base64 formaadis
|VBEBv...oKPDwKL==
|Faili sisu base64 formaadis
|-
|E-Document > Document > DocumentInfo > Attachments > File > FileEncryption
|''Ignoreerime ostuarve impordil''
|no
|Krüpteeritud? enamati no
|-
|E-Document > Document > DocumentInfo > Attachments > File > FileSize
|Manuse Faili suurus
|50609
|Faili suuris
|-
|E-Document > Document > DocumentSumGroup > DocumentSum
|Tarnija e-arve > Summa
|497.00
|Dokumendi summa ilma KMita
|-
|E-Document > Document > DocumentSumGroup > PenaltySum
|''Ignoreerime ostuarve impordil''
|0.00
|Trahvi summa
|-
|E-Document > Document > DocumentSumGroup > Rounding
|''Ignoreerime ostuarve impordil''
|0.00
|Ümardus
|-
|E-Document > Document > DocumentSumGroup > <VAT vatID="TAX"> > SumBeforeVAT
|''Ignoreerime ostuarve impordil''
|9.00
|selle maksuga maksustatav summa, ilma KMiyta
|-
|E-Document > Document > DocumentSumGroup > <VAT vatID="TAX"> > VATRate
|''Ignoreerime ostuarve impordil''
|9
|Maksu protsent
|-
|E-Document > Document > DocumentSumGroup > <VAT vatID="TAX"> > VATSum
|''Ignoreerime ostuarve impordil''
|0.81
|Maksu summa
|-
|E-Document > Document > DocumentSumGroup > <VAT vatID="TAX"> > Currency
|''Ignoreerime ostuarve impordil''
|EUR
|Valuuta
|-
|E-Document > Document > DocumentSumGroup > <VAT vatID="TAX"> > SumBeforeVAT
|''Ignoreerime ostuarve impordil''
|488.00
|selle maksuga maksustatav summa, ilma KMiyta
|-
|E-Document > Document > DocumentSumGroup > <VAT vatID="TAX"> > VATRate
|''Ignoreerime ostuarve impordil''
|20
|Maksu protsent
|-
|E-Document > Document > DocumentSumGroup > <VAT vatID="TAX"> > VATSum
|''Ignoreerime ostuarve impordil''
|97.60
|Maksu summa
|-
|E-Document > Document > DocumentSumGroup > <VAT vatID="TAX"> > Currency
|''Ignoreerime ostuarve impordil''
|EUR
|Valuuta
|-
|E-Document > Document > DocumentSumGroup > TotalVATSum
|Tarnija e-arve > KM
|98.41
|Kokku arve KM summa
|-
|E-Document > Document > DocumentSumGroup > TotalSum
|Tarnija e-arve > KOKKU
|595.41
|Kõik kokku
|-
|E-Document > Document > DocumentSumGroup > Currency
|Tarnija e-arve > Valuuta
|EUR
|Arve summa valuuta
|-
|E-Document > Document > DocumentItem > ItemEntry > LineItemNum
|Tarnija e-arve maatriksi rea nr
|1
|Algab 1-st.
|-
|E-Document > Document > DocumentItem > ItemEntry > SellerItemCode
|Tarnija e-arve maatriksis rea Tarn. Art.
|321654987
|Maatriksist Ostuartikkel kood
|-
|E-Document > Document > DocumentItem > ItemEntry > BuyerItemCode
|Tarnija e-arve maatriksis rea Artikkel
|buyer code 1
|
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemDescription
|Tarnija e-arve maatriksis Nimetus
|Lenovo Thinkpad P51
|Kirjeldus Ostutellimuse realt
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemUnitRecord > ItemUnit
|''Ignoreerime ostuarve impordil''
|TK
|Ühiku kood realt
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemUnitRecord > UnitNumerator
|''Ignoreerime ostuarve impordil''
|1
|Vist alati 1
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemUnitRecord > UnitDenumerator
|''Ignoreerime ostuarve impordil''
|1
|Vist alati 1
|-
|E-Document > Document > DocumentItem > ItemEntry > BaseUnit
|''Ignoreerime ostuarve impordil''
|TK
|Ühiku kood realt
|-
|E-Document > Document > DocumentItem > ItemEntry > AmountOrdered
|Tarnija e-arve maatriksis rea T. kogus
|4
|Kogus realt
|-
|E-Document > Document > DocumentItem > ItemEntry > AmountInvoiced
|''Ignoreerime ostuarve impordil''
|2
|
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemPrice
|''Ignoreerime ostuarve impordil''
|4.00
|
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemBasePrice
|''Ignoreerime ostuarve impordil''
|4.00
|
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemSum
|Tarnija e-arve maatriksis rea Summa
|8.00
|
|-
|E-Document > Document > DocumentItem > ItemEntry > VAT vatID="TAX" > SumBeforeVAT
|''Ignoreerime ostuarve impordil''
|8.00
|
|-
|E-Document > Document > DocumentItem > ItemEntry > VAT vatID="TAX" > VATRate
|Tarnija e-arve maatriksis rea KM %
|20
|
|-
|E-Document > Document > DocumentItem > ItemEntry > VAT vatID="TAX" > VATSum
|''Ignoreerime ostuarve impordil''
|1.60
|
|-
|E-Document > Document > DocumentItem > ItemEntry > VAT vatID="TAX" > Currency
|''Ignoreerime ostuarve impordil''
|EUR
|
|-
|E-Document > Document > DocumentItem > ItemEntry > ItemTotal
|''Ignoreerime ostuarve impordil''
|9.60
|
|-
|E-Document > Document > DocumentItem > ItemEntry > RefInfo
|''Ignoreerime ostuarve impordil, kogus eda vahemikku''
|
|
|-
|E-Document > Document >AdditionalInfo > Extension > InfoName
|''märkuse tüüp''
|remarks
|alati Remarks
|-
|E-Document > Document >AdditionalInfo > Extension > InfoContent
|Tarnija e-arve > Tunnused vaheleht > Kommentaar
|Tarnida ilma pakendita
|Kommentaar teellimuselt
|}
====Telema Ostuarve XML näidis====
<syntaxhighlight lang="xml">
<?xml version="1.0" encoding="utf-8"?>
<E-Document>
<Header>
<DateIssued>2019-04-04T10:58:24</DateIssued>
<Charset>UTF-8</Charset>
<Channel>WEB</Channel>
<SenderID>6000</SenderID>
<ReceiverID>NRV111</ReceiverID>
</Header>
<Document>
<DocumentType>invoice</DocumentType>
<DocumentFunction>ORIGINAL</DocumentFunction>
<DocumentParties>
<BuyerParty context="partner">
<PartyCode>10877000</PartyCode>
<Name>EXCELLENT BUSINESS SOLUTIONS EESTI AS</Name>
<RegNum>10877000</RegNum>
<VATRegNum>EE100777660</VATRegNum>
<PartyGroupName>EXCELLENT BUSINESS SOLUTIONS EESTI AS</PartyGroupName>
<ContactData>
<PhoneNum>669 1113</PhoneNum>
<EmailAddress>eleriin@excellent.ee</EmailAddress>
<ActualAddress>
<Address1>Lõõtsa 2A</Address1>
<City>Tallinn</City>
<PostalCode>13522</PostalCode>
<County>Harjumaa</County>
<Country>Estonia</Country>
<CountryCode>EE</CountryCode>
</ActualAddress>
</ContactData>
</BuyerParty>
<DeliveryParty context="partner">
<PartyCode>NRV</PartyCode>
<Name>Narva ladu</Name>
<PartyGroupName>EXCELLENT BUSINESS SOLUTIONS EESTI AS</PartyGroupName>
<ContactData>
<EmailAddress>raul.silde@telema.com</EmailAddress>
<ActualAddress>
<Address1>Kevade 3</Address1>
<City>Narva</City>
<Country>Estonia</Country>
<CountryCode>EE</CountryCode>
</ActualAddress>
</ContactData>
</DeliveryParty>
<SellerParty context="self">
<PartyCode>22446688</PartyCode>
<Name>HULGIKAUPMEES AS (TEST COMPANY FOR EXCELLENT)</Name>
<RegNum>22446688</RegNum>
<VATRegNum>EE224466889</VATRegNum>
<PartyGroupName>HULGIKAUPMEES AS (TEST COMPANY FOR EXCELLENT)</PartyGroupName>
<ContactData>
<PhoneNum>654456654</PhoneNum>
<EmailAddress>info@excellent.ee</EmailAddress>
<ActualAddress>
<Address1>Lõõtsa 8</Address1>
<City>Tallinn</City>
<Country>Estonia</Country>
<CountryCode>EE</CountryCode>
</ActualAddress>
</ContactData>
</SellerParty>
</DocumentParties>
<DocumentInfo>
<DocumentSubType>DEB</DocumentSubType>
<DocumentName>invoice</DocumentName>
<DocumentNum>3563635645</DocumentNum>
<DateInfo>
<IssueDate>2019-04-04T10:58:24</IssueDate>
<InvoiceDate>2019-04-04</InvoiceDate>
<DueDate>2019-04-25</DueDate>
<DeliveryDateRequested>2019-02-20</DeliveryDateRequested>
<DeliveryDateActual>2019-04-08</DeliveryDateActual>
</DateInfo>
<RefInfo>
<SourceDocument type="order">
<SourceDocumentNum>TEST-OT9003</SourceDocumentNum>
<SourceDocumentDate>2019-02-19T00:00:00</SourceDocumentDate>
</SourceDocument>
</RefInfo>
<CreatedBy>Aaaa.1111</CreatedBy>
<CreatedByContact>
<ContactFirstName>AAAA</ContactFirstName>
<ContactLastName>1111</ContactLastName>
<PhoneNum>353453453245</PhoneNum>
<EmailAddress>kadri.lenk@telema.com</EmailAddress>
</CreatedByContact>
<Attachments>
<File>
<FileName>invoice-3563635645.pdf</FileName>
<FileType>application/pdf</FileType>
<FileBase64>JVBERi0.......xLjQ=</FileBase64>
<FileEncryption>no</FileEncryption>
<FileSize>50609</FileSize>
</File>
</Attachments>
</DocumentInfo>
<DocumentSumGroup>
<DocumentSum>497.00</DocumentSum>
<PenaltySum>0.00</PenaltySum>
<Rounding>0.00</Rounding>
<VAT vatID="TAX">
<SumBeforeVAT>9.00</SumBeforeVAT>
<VATRate>9</VATRate>
<VATSum>0.81</VATSum>
<Currency>EUR</Currency>
</VAT>
<VAT vatID="TAX">
<SumBeforeVAT>488.00</SumBeforeVAT>
<VATRate>20</VATRate>
<VATSum>97.60</VATSum>
<Currency>EUR</Currency>
</VAT>
<TotalVATSum>98.41</TotalVATSum>
<TotalSum>595.41</TotalSum>
<Currency>EUR</Currency>
</DocumentSumGroup>
<DocumentItem>
<ItemEntry>
<LineItemNum>1</LineItemNum>
<SellerItemCode>20001</SellerItemCode>
<BuyerItemCode>buyer code 1</BuyerItemCode>
<ItemDescription lang="EN">Lenovo ThinkPad P51</ItemDescription>
<ItemUnitRecord>
<ItemUnit>tk</ItemUnit>
<AmountActual>2</AmountActual>
<UnitNumerator>1</UnitNumerator>
<UnitDenumerator>1</UnitDenumerator>
</ItemUnitRecord>
<BaseUnit>tk</BaseUnit>
<AmountOrdered>2</AmountOrdered>
<AmountInvoiced>2</AmountInvoiced>
<ItemPrice>4.00</ItemPrice>
<ItemBasePrice>4.00</ItemBasePrice>
<ItemSum>8.00</ItemSum>
<VAT vatID="TAX">
<SumBeforeVAT>8.00</SumBeforeVAT>
<VATRate>20</VATRate>
<VATSum>1.60</VATSum>
<Currency>EUR</Currency>
</VAT>
<ItemTotal>9.60</ItemTotal>
<RefInfo>
<AdditionalInfo>
<Extension extensionId="remarks">
<InfoContent>reakohane märkus</InfoContent>
</Extension>
</AdditionalInfo>
</RefInfo>
</ItemEntry>
<ItemEntry>
<LineItemNum>2</LineItemNum>
<SellerItemCode>20002</SellerItemCode>
<BuyerItemCode>buyer code 2</BuyerItemCode>
<ItemDescription lang="EN">Lenovo ThinkPad P50</ItemDescription>
<ItemUnitRecord>
<ItemUnit>tk</ItemUnit>
<AmountActual>3</AmountActual>
<UnitNumerator>1</UnitNumerator>
<UnitDenumerator>1</UnitDenumerator>
</ItemUnitRecord>
<BaseUnit>tk</BaseUnit>
<AmountOrdered>3</AmountOrdered>
<AmountInvoiced>3</AmountInvoiced>
<ItemPrice>3.00</ItemPrice>
<ItemBasePrice>3.00</ItemBasePrice>
<ItemSum>9.00</ItemSum>
<VAT vatID="TAX">
<SumBeforeVAT>9.00</SumBeforeVAT>
<VATRate>9</VATRate>
<VATSum>0.81</VATSum>
<Currency>EUR</Currency>
</VAT>
<ItemTotal>9.81</ItemTotal>
</ItemEntry>
<ItemEntry>
<LineItemNum>3</LineItemNum>
<SellerItemCode>20003</SellerItemCode>
<GTIN>4564568231478</GTIN>
<ItemDescription lang="EN">Lenovo ThinkPad X1 Yoga 2017 4G OLED</ItemDescription>
<ItemUnitRecord>
<ItemUnit>tk</ItemUnit>
<AmountActual>6</AmountActual>
<UnitNumerator>1</UnitNumerator>
<UnitDenumerator>1</UnitDenumerator>
</ItemUnitRecord>
<BaseUnit>tk</BaseUnit>
<AmountOrdered>6</AmountOrdered>
<AmountInvoiced>6</AmountInvoiced>
<ItemPrice>80.00</ItemPrice>
<ItemBasePrice>80.00</ItemBasePrice>
<ItemSum>480.00</ItemSum>
<VAT vatID="TAX">
<SumBeforeVAT>480.00</SumBeforeVAT>
<VATRate>20</VATRate>
<VATSum>96.00</VATSum>
<Currency>EUR</Currency>
</VAT>
<ItemTotal>576.00</ItemTotal>
</ItemEntry>
</DocumentItem>
<AdditionalInfo>
<Extension extensionId="remarks">
<InfoName>remarks</InfoName>
<InfoContent>Arve kohane märkus</InfoContent>
</Extension>
<Extension extensionId="deliveryDetails">
<InfoName>deliveryDetails</InfoName>
<InfoContent>Tarne lisamärkus</InfoContent>
</Extension>
</AdditionalInfo>
</Document>
<Footer>
<TotalNumDocuments>1</TotalNumDocuments>
</Footer>
</E-Document>
</syntaxhighlight>
===EDI Ostu-kreeditarve===
Telemast saabunud EDI Ostuarvet ja Kreeditarvet eristab vaid üks väli.
{| class="wikitable"
!Väli Telema EDI ostuarve XMLis
!Milliselt Standard Booksi Tarnija e-arve väljale info asetame
!Näide
!Kommentaar
|-
|E-Document > Document > DocumentInfo > DocumentSubType
|kui CRED, siis tasumistingimus tarnija e-arvel = tuleb leida Kreeditarve tüüpi tasumistingimus
|Cred
|Kas tavaline (Deb) või kreeditarve
|}
<span> </span>

DocumentSumGroup osas ja ItemEntrt osas on aga kõik summad ja kogused negatiivsed, - märgiga. Need palun muuta ära, lihtsalt korjame miinus märgid eest ära.

TelemaOstuKoopiaAvalik - Redigeerimiste ajalugu

Kaupo: Uus lehekülg: 'Antud dokumendis on kirjeldatud, kuidas toimib Standard Booksis Telema vaates tarnija roll. Standard Booksis loome lahenduse, kus kasutaja saab Telemasse saata Ostutellimuse. Te...'