Hausing - Register Arved: erinevus redaktsioonide vahel
Mine navigeerimisribale
Mine otsikasti
Konstantin (arutelu | kaastöö) (→Päis: SerNr POSTitamine lisatud) |
|||
(ei näidata 3 kasutaja 21 vahepealset redaktsiooni) | |||
1. rida: | 1. rida: | ||
<blockquote>[[Hausing|Hausing - Pealeht]]</blockquote> | <blockquote>[[Hausing|Hausing - Pealeht]]</blockquote> | ||
== | == Register == | ||
*<nowiki><data> element peab sisaldama:</nowiki> | |||
**register="'''IVVc'''" | |||
[[Pilt:Arved hausing.png|raamita|445x445px]] | |||
== Toetatud väljad == | |||
=== Päis === | |||
{| class="wikitable" | {| class="wikitable" | ||
|'''Kood''' | |'''Kood''' | ||
|'''Kasutajaliidese nimi''' | |||
|'''Kirjeldus''' | |'''Kirjeldus''' | ||
|'''Pikkus, tüüp''' | |'''Pikkus, tüüp''' | ||
|'''Kohustuslik''' | |||
|'''Kommentaar''' | |'''Kommentaar''' | ||
|- | |||
|'''SerNr''' | |||
|Nr. | |||
|Arve programmi-sisene seerianumber | |||
|''0, Value with No Decimals'' | |||
| | |||
|Kui tühi, siis võetakse järgmine vaba seerianumber. Kui ei ole tühi, siis toimub kontroll, kas see number on vaba ja kuulub numbriseeriasse. | |||
|- | |- | ||
|'''InvDate''' | |'''InvDate''' | ||
|Arve kp. | |||
|Arve kuupäev | |Arve kuupäev | ||
|''0, In Dataformat Order'' | |''0, In Dataformat Order'' | ||
| + | |||
|Will connect the outer system invoice number with Hansa serial number | |Will connect the outer system invoice number with Hansa serial number | ||
|- | |- | ||
|'''TransDate''' | |'''TransDate''' | ||
|Kande kp. | |||
|Kande kp. | |Kande kp. | ||
|0, ''In Dataformat Order'' | |0, ''In Dataformat Order'' | ||
| + | |||
| | | | ||
|- | |- | ||
|'''CustCode''' | |'''CustCode''' | ||
|Klient | |||
|Kliendi kood | |Kliendi kood | ||
|''20, Code String'' | |''20, Code String'' | ||
| + | |||
|Hansa internal customer code, must be created in advance | |Hansa internal customer code, must be created in advance | ||
|- | |- | ||
|'''Sum1''' | |'''<s>Sum1</s>''' | ||
|Neto summa | |<s>Vahesumma</s> | ||
|''0, Value 2 or 3 Decimals'' | |<s>Neto summa</s> | ||
| | |''<s>0, Value 2 or 3 Decimals</s>'' | ||
| | |||
|''Standard Booksi loogika ei luba kirjutada antud väljale. Ümardamise probleemide vältimiseks kasutame ümardamise seadistust.'' | |||
|- | |- | ||
|'''Sum3''' | |'''<s>Sum3</s>''' | ||
|Käibemaksu summa | |<s>KM</s> | ||
|''0, Value 2 or 3 Decimals'' | |<s>Käibemaksu summa</s> | ||
| | |''<s>0, Value 2 or 3 Decimals</s>'' | ||
| | |||
|''Standard Booksi loogika ei luba kirjutada antud väljale. Ümardamise probleemide vältimiseks kasutame ümardamise seadistust.'' | |||
|- | |- | ||
|'''Sum4''' | |'''<s>Sum4</s>''' | ||
|Kokku | |<s>KOKKU</s> | ||
|''0, Value 2 or 3 Decimals'' | |<s>Kokku</s> | ||
| | |''<s>0, Value 2 or 3 Decimals</s>'' | ||
| | |||
|''Standard Booksi loogika ei luba kirjutada antud väljale. Ümardamise probleemide vältimiseks kasutame ümardamise seadistust.'' | |||
|- | |- | ||
|'''InvType' | |'''<u><s>InvType</s></u>''' | ||
| | | | ||
|<u><s>Arve tüüp (Tavaline, kreedit jne. 1=tavaline)</s></u> | |||
|''<u><s>0, Small Value with No Decimals</s></u>'' | |||
| <u><s>+</s></u> | |||
|Ei POSTita ikka seda välja enam, muutub automaatselt PayDeal asetamisel, kui on PayDeal Krediitarve tüüpi | |||
|- | |- | ||
|'''PayDeal''' | |'''PayDeal''' | ||
|Tasumistingimus | |||
|Tasumistingimuse kood | |Tasumistingimuse kood | ||
|''2, Code String'' | |''2, Code String'' | ||
| + | |||
| | | | ||
|- | |- | ||
| | |'''OKFlag''' | ||
|Kinnita | |||
|Kinnitatud. 0=ei, 1=jah | |||
|''0, As Bool but displayed as a Checkbox'' | |||
| + | |||
| | | | ||
|- | |||
|'''CurncyCode''' | |||
|Valuuta | |||
|Valuuta | |||
|''5, Code String'' | |||
| + | |||
| | | | ||
|- | |||
|'''Addr0''' | |||
|Kliendi nimi | |||
|Arve saaja aadressi 1. rida | |||
|''60, String'' | |||
| | | | ||
|Võetakse kliendikoodi aluses kontaktide registrist, kuid on võimalik päringuga saata eraldi ka. | |||
|- | |- | ||
|''' | |'''OfficialSerNr''' | ||
| | |Ametlik ser. nr. | ||
| | |Ametlik seerianumber | ||
|''100, String'' | |||
| | |||
|'' | |||
| | |||
| | | | ||
|- | |- | ||
|''' | |'''Objects''' | ||
| | |Objektid | ||
|'' | |Objektid. ''Läbiva suurtähega, eraldatud komaga.'' | ||
|''60, Capital Characters Only'' | |||
| | |||
| | | | ||
|- | |- | ||
|''' | |'''RefStr''' | ||
| | |Viide | ||
|'' | |Arve viitenumber | ||
|''60, String'' | |||
| | | | ||
| | | | ||
|} | |} | ||
=== | === Maatriks === | ||
{| class="wikitable" | |||
|'''Kood''' | |||
|'''Kasutajaliidese nimi''' | |||
|'''Kirjeldus''' | |||
|'''Pikkus, tüüp''' | |||
|'''Kohustuslik''' | |||
|'''Kommentaar''' | |||
{| class="wikitable" | |||
|- | |- | ||
|''' | |'''stp''' | ||
| | | | ||
| | |Rea tüüp (1=tavaline) | ||
|'' | |1, ''Integer'' | ||
| + | |||
|number defines the type of row in Hansa, must only be 1 for the moment (regular row) | |||
|- | |- | ||
|''' | |'''ArtCode''' | ||
| | |Artikkel | ||
| | |Artiklikood | ||
|''20, Code String'' | |''20, Code String'' | ||
| + | |||
|Hansa internal article code, must be created in advance | |||
|- | |- | ||
|''' | |'''Spec''' | ||
| | |Kirjeldus | ||
| | |Kirjeldus | ||
|'' | |''100, String'' | ||
| | |||
| | |||
|- | |- | ||
|''' | |'''Quant''' | ||
| | |Kogus | ||
| | |Kogus | ||
|'' | |''0, Value with minimum Decimals'' | ||
| + | |||
| | |||
|- | |- | ||
|''' | |'''Price''' | ||
| | |Ühikuhind | ||
| | |Hind | ||
|'' | |''0, Value with 2 or 3 Decimals'' | ||
| | | + | ||
| | | | ||
|- | |- | ||
|''' | |'''Sum''' | ||
|Summa | |||
|Kokku | |||
|''0, Value 2 or 3 Decimals'' | |||
| + | |||
| | | | ||
|- | |- | ||
|''' | |'''VATCode''' | ||
| | |KM kood | ||
| | |KM kood | ||
|'' | |''10, Code String'' | ||
| + | |||
| | |||
|- | |- | ||
|''' | |'''SalesAcc''' | ||
| | |Konto | ||
| | |Müügi konto | ||
|'' | |''10, Code String'' | ||
| | |||
| | |||
|- | |- | ||
|''' | |'''Objects''' | ||
|Objektid | |||
|Objekt(id) | |||
|''60, Capital Characters Only'' | |||
| | |||
| | | | ||
| | |} | ||
1 = | === Näidis XML päring === | ||
<syntaxhighlight lang="xml"> | |||
<?xml version="1.0" encoding="UTF-8"?> | |||
<data register="IVVc" sequence="106357" systemversion="8.4.20.504"> | |||
<IVVc> | |||
<RefStr>123456789</RefStr> | |||
<InvDate>2018-01-23</InvDate> | |||
<TransDate>2018-01-23</TransDate> | |||
<CustCode>101</CustCode> | |||
<Sum1>100</Sum1> | |||
<Sum3>20</Sum3> | |||
<Sum4>120</Sum4> | |||
<InvType>1</InvType> | |||
<PayDeal>5</PayDeal> | |||
<OKFlag>0</OKFlag> | |||
<rows> | |||
<row rownumber="0"><!-- required, number defines the row in Hansa, starts with 0 --> | |||
<stp>1</stp> | |||
<ArtCode>001</ArtCode> | |||
<Quant>15</Quant> | |||
<Price>15.64</Price> | |||
<Sum>234,6</Sum> | |||
<VATCode>1</VATCode> | |||
</row> | |||
</rows> | |||
</IVVc> | |||
</data> | |||
</syntaxhighlight> | |||
== Kõigi XML väljade kirjeldused == | |||
=== Päis === | |||
|'' | {| class="wikitable" | ||
!Kood | |||
!Kasutajaliidese nimi | |||
!'''Kirjeldus''' | |||
!''Pikkus, tüüp'' | |||
|- | |- | ||
|''' | |'''SerNr''' | ||
| | |Nr. | ||
| | |Arve number | ||
|''0, Value with No Decimals'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''InvDate''' | ||
| | |Arve kp. | ||
| | |Arve kuupäev | ||
|''0, | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''CustCode''' | ||
| | |Klient | ||
| | |Kliendi kood | ||
|'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''PayDate''' | ||
| | |Laekumistähtaeg | ||
| | |Maksetähtaeg | ||
|''0, | |''0, In Dataformat Order'' | ||
|- | |||
|'''Addr0''' | |||
|Kliendi nimi | |||
|Arve saaja aadressi 1. rida | |||
|''60, String'' | |||
|- | |||
|'''Addr1''' | |||
|Aadres | |||
|Arve saaja aadressi 2. rida | |||
|''60, String'' | |||
|- | |- | ||
|''' | |'''Addr2''' | ||
| | | | ||
| | |Arve saaja aadressi 3. rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''Addr3''' | ||
| | | | ||
| | |Arve saaja aadressi 4. rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''OurContact''' | ||
| | |Meie esindaja | ||
| | |Meie esindaja, arve koostaja | ||
|'' | |''20, String'' | ||
|- | |- | ||
|''' | |'''ClientContact''' | ||
| | |Nende esindaja | ||
| | |Kliendi esindaja | ||
|''60, String'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''ExportFlag''' | ||
| | | | ||
| | |Käibemaksutsoon | ||
0 = „Eesti“ | |||
1 = „EL“, | |||
2 = „EL (konteeri KM)“, | |||
3 = „Mitte EL“ | |||
4 = „Mitte EL (konteeri KM) | |||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''PayDeal''' | ||
|Tasumistingimus | |||
|Tasumistingimuse kood | |||
|''2, Code String'' | |||
|- | |||
|'''OrderNr''' | |||
|Tellimuse nr | |||
|Tellimuse nr (millest arve on koostatud) | |||
|''0, Value with No Decimals'' | |||
|- | |||
|'''Prntdf''' | |||
| | | | ||
| | |Saadetud. 0=ei, 1=jah | ||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''OKFlag''' | ||
| | |Kinnita | ||
| | |Kinnitatud. 0=ei, 1=jah | ||
|'' | |''0, As Bool but displayed as a Checkbox'' | ||
|- | |- | ||
|''' | |'''pdays''' | ||
| | | | ||
| | |Netopäevi (maksetähtaeg) | ||
|'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''pdvrebt''' | ||
| | | | ||
| | |Kassa-ale protsent | ||
|''0, | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|''' | |'''pdrdays''' | ||
| | | | ||
| | |Kassa-ale päevi | ||
|'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''CustCat''' | ||
| | | | ||
| | |Kliendiklass | ||
|'' | |''5, Code String'' | ||
|- | |- | ||
|''' | |'''pdComment''' | ||
| | | | ||
| | |Tekst ''(peidus)'' | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''x1''' | ||
| | | | ||
| | |''Ei kasutata'' | ||
|'' | |''0, Empty Field'' | ||
|- | |- | ||
|''' | |'''InvType''' | ||
| | | | ||
| | |Arve tüüp (Tavaline, kreedit jne. 1=tavaline) | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''xStatFlag''' | ||
| | | | ||
| | |''Ei kasutata, alati 0'' | ||
|''0, Value with | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''PriceList''' | ||
| | |Hinnakiri | ||
| | |Hinnakiri | ||
|''5, Code String'' | |''5, Code String'' | ||
|- | |- | ||
|''' | |'''Objects''' | ||
| | |Objektid | ||
| | |Objektid. ''Läbiva suurtähega, eraldatud komaga.'' | ||
|'' | |''60, Capital Characters Only'' | ||
|- | |- | ||
|''' | |'''InclVAT''' | ||
| | | | ||
| | |Hind KM-ga (0=ei; 1=jah) | ||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''ARAcc''' | ||
| | | | ||
| | |Ümberhindluskonto (finantskonto) | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''InvComment''' | ||
| | |Kommentaar | ||
| | |Arve kommentaar | ||
|'' | |''200, String'' | ||
|- | |- | ||
|''' | |'''CredInv''' | ||
| | | | ||
| | |Kreediteeritava arve nr | ||
|''0, Value | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''CredMark''' | ||
| | | | ||
| | |Kreeditarve (0=ei; 1=jah) | ||
|'' | |''1, String'' | ||
|- | |- | ||
|''' | |'''SalesMan''' | ||
| | |Isik | ||
| | |Meie esindaja | ||
|'' | |''60, Capital Characters Only'' | ||
|- | |- | ||
|''' | |'''ToRateB1''' | ||
| | |Baasvaluuta1 | ||
| | |Kurss B1 suhtes | ||
|'' | |''0, Value with 6 Decimals'' | ||
|- | |- | ||
|''' | |'''TransDate''' | ||
| | |Kande kp. | ||
| | |Kande kuupäev | ||
|'' | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''CurncyCode''' | ||
| | |Valuuta | ||
| | |Valuuta | ||
|'' | |''5, Code String'' | ||
|- | |- | ||
|''' | |'''LangCode''' | ||
| | |Keel | ||
| | |Keel | ||
|'' | |''5, Code String'' | ||
|- | |- | ||
|''' | |'''UpdStockFlag''' | ||
| | |Muuda ladu | ||
| | |Muuda ladu (0=ei; 1=jah) | ||
|''0, Value | |''0, Small Value with No Decimals'' | ||
|- | |||
|'''LastRemndr''' | |||
|Märgukirjatase | |||
|Märgukirjatase | |||
|''0, Value with No Decimals'' | |||
|- | |||
|'''LastRemDate''' | |||
|Viimane märguk. kp. | |||
|Viimase märgukirja kuupäev | |||
|''0, In Dataformat Order'' | |||
|- | |||
|'''Sign''' | |||
|Isik | |||
|Arve koostaja, allkiri | |||
|''10, Code String'' | |||
|- | |- | ||
|''' | |'''FrPrice''' | ||
| | | | ||
| | |Transpordi hind | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''FrBase''' | ||
| | | | ||
| | |''Ei kasutata, alati tühi'' | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''FrItem''' | ||
| | | | ||
| | |Transpordi artiklikood | ||
|'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''FrVATCode''' | ||
|KM | |Trans. KM-k | ||
| | |Transpordi käibemaksukood | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''FrObjects''' | ||
| | | | ||
| | |Transpordi objektid | ||
|'' | |''60, Capital Characters Only'' | ||
|- | |- | ||
|''' | |'''OrgCust''' | ||
| | | | ||
| | |Algne klient | ||
|''20, String'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''FrGP''' | ||
| | | | ||
| | |''Ei kasutata, alati tühi'' | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''FrGPPercent''' | ||
| | | | ||
| | |Müügikatte protsent hinnast | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''Sum0''' | ||
| | | | ||
| | |Ümardus | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''Sum1''' | ||
| | |Vahesumma | ||
| | |Neto summa | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''Sum2''' | ||
| | | | ||
| | |Kokku ''(Eestis tühi)'' | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''Sum3''' | ||
| | |KM | ||
| | |Käibemaksu summa | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''Sum4''' | ||
| | |KOKKU | ||
| | |Kokku | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''VATNr''' | ||
| | |KMKR nr. | ||
|Kliendi | |Kliendi KMKR number | ||
|'' | |''20, String'' | ||
|- | |- | ||
|''' | |'''ShipDeal''' | ||
| | | | ||
| | |Lähetustingimus | ||
|''5, Code String'' | |''5, Code String'' | ||
|- | |- | ||
|''' | |'''ShipAddr0''' | ||
| | |Lähetus- | ||
| | |Lähetusaadressi 1. rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''ShipAddr1''' | ||
| | |Aadress | ||
| | |Lähetusaadressi 2. rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''ShipAddr2''' | ||
| | | | ||
| | |Lähetusaadressi 3. rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''ShipAddr3''' | ||
| | | | ||
| | |Lähetusaadressi 4. rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''ShipMode''' | ||
| | |Lähetusviis | ||
| | |Lähetusviis | ||
|'' | |''5, Code String'' | ||
|- | |||
|'''Location''' | |||
|Ladu | |||
|Ladu | |||
|''10, Code String'' | |||
|- | |||
|'''PRCode''' | |||
|Projekt | |||
|Projekti kood | |||
|''20, Code String'' | |||
|- | |- | ||
|''' | |'''FrSalesAcc''' | ||
| | | | ||
| | |''Ei kasutata, alati tühi'' | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''TAX1Sum''' | ||
| | | | ||
| | |Lisamaks | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''CustVATCode''' | ||
| | | | ||
| | |Kliendi KM kood | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''RebCode''' | ||
| | | | ||
| | |Allahindlusmaatriksi kood (kliendilt) | ||
|'' | |''5, Code String'' | ||
|- | |- | ||
|''' | |'''CalcFinRef''' | ||
| | |Viide | ||
| | |Viide | ||
|'' | |''30, String'' | ||
|- | |- | ||
|''' | |'''Phone''' | ||
| | | | ||
| | |Telefon (kliendi) | ||
|'' | |''20, String with phone-number'' | ||
|- | |- | ||
|''' | |'''Fax''' | ||
| | | | ||
| | |Faks (kliendi) | ||
|''20, String'' | |''20, String'' | ||
|- | |- | ||
|''' | |'''IntCode''' | ||
| | | | ||
| | |Viivis | ||
|''0, Value with | |''10, String'' | ||
|- | |||
|'''ARonTR''' | |||
|Info kande E-osale | |||
|Info kande E-osale (0=ei; 1=jah) | |||
|''0, Small Value with No Decimals'' | |||
|- | |- | ||
|''' | |'''CustOrdNr''' | ||
| | | | ||
| | |Kliendi tellimuse number | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''ExportedFlag''' | ||
| | | | ||
| | |Eksporditud (0=ei; 1=jah) | ||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''BaseSum4''' | ||
| | |Suma | ||
| | |Summa | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''FrRate''' | ||
| | |Baasvaluuta1 | ||
| | |Kurss B1-te | ||
|'' | |''0, Value with 6 Decimals'' | ||
|- | |||
|'''ToRateB2''' | |||
|Baasvaluuta2 | |||
|Kurss B2-te | |||
|''0, Value with 6 Decimals'' | |||
|- | |- | ||
|''' | |'''BaseRate1''' | ||
| | |Baasvaluuta1 | ||
| | |B1 kurss | ||
|''0, Value | |''0, Value with 6 Decimals'' | ||
|- | |- | ||
|''' | |'''BaseRate2''' | ||
| | |Baasvaluuta2 | ||
| | |B2 kurss | ||
|''0, Value | |''0, Value with 6 Decimals'' | ||
|- | |- | ||
|''' | |'''InvoiceNr''' | ||
| | | | ||
| | |Hankija arve nr | ||
|''20, String'' | |''20, String'' | ||
|- | |- | ||
|''' | |'''DiscPerc''' | ||
| | | | ||
| | |Allahindlusprotsent | ||
|''0, Value with | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|''' | |'''DiscSum''' | ||
| | | | ||
| | |Allahindluse summa | ||
|''0, | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''TotGP''' | ||
| | |Kokku MK | ||
| | |Kokku MK (Müügikate) | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''LocOKNr''' | ||
| | | | ||
|Asukoha kin. nr. | |||
|''0, Value with minimum Decimals'' | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|''' | |'''Invalid''' | ||
| | | | ||
| | |Kehtetu, suletud. | ||
|''0, Value with | |''0, Small Value with No Decimals'' | ||
|- | |||
|'''CreditCard''' | |||
| | |||
|Krediitkaart | |||
|''20, Capital Characters Only'' | |||
|- | |- | ||
|''' | |'''AuthorizationCode''' | ||
| | | | ||
| | |Autoriseerimiskood | ||
|'' | |''10, Capital Characters Only'' | ||
|- | |- | ||
|''' | |'''RecValue''' | ||
| | | | ||
| | |Makstud (0=ei; 1=jah) | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''RetValue''' | ||
| | | | ||
| | |Sularaha tagasi | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''FromBUQT''' | ||
| | | | ||
| | |''Ei kasutata, alati tühi'' | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |||
|'''Sorting''' | |||
|Teekond | |||
|Teekond | |||
|''20, String'' | |||
|- | |||
|'''NoInterestFlag''' | |||
|Ära arvesta viivist | |||
|Ära arvesta viivist (0=ei; 1=jah) | |||
|''0, Small Value with No Decimals'' | |||
|- | |||
|'''NoRemndrFlag''' | |||
|Ära koosta masskirju | |||
|Ära koosta masskirju (0=ei; 1=jah) | |||
|''0, Small Value with No Decimals'' | |||
|- | |- | ||
|''' | |'''SVONr''' | ||
| | | | ||
| | |Teenindustellimuse nr | ||
|'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''InstallmentInv''' | ||
| | | | ||
|''Ei kasutata, alati tühi'' | |''Ei kasutata, alati tühi'' | ||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''OfficialSerNr''' | ||
| | |Ametlik ser. nr. | ||
| | |Ametlik seerianumber | ||
|'' | |''100, String'' | ||
|- | |- | ||
|''' | |'''OfficialSerNr2''' | ||
| | |Ametlik ser. nr. 2 | ||
| | |Ametlik seerianumber 2 | ||
|'' | |''100, String'' | ||
|- | |- | ||
|''' | |'''TotQty''' | ||
| | |Kogus kokku | ||
| | |Kokku kogus | ||
|''0, | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|''' | |'''TotWeight''' | ||
| | |Kaal Kokku | ||
| | |Kokku kaal | ||
|''0, Value with | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|''' | |'''TotVolume''' | ||
| | |Maht Kokku | ||
| | |Maht kokku | ||
|''0, | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|''' | |'''Commision''' | ||
| | |Teenustasu | ||
| | |Teenustasu | ||
|''0, Value | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''SumIncCom''' | ||
| | |Kokku teen.-ga | ||
| | |Kokku teenustasuga | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''InvAddr3''' | ||
| | | | ||
| | |Arve aadress 4. Rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''InvAddr4''' | ||
| | | | ||
| | |Arve aadress 5. Rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''DelAddr3''' | ||
| | | | ||
| | |Lähetusaadress 4. Rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''DelAddr4''' | ||
| | | | ||
| | |Lähetusaadress 5. Rida | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''DelAddrCode''' | ||
| | |Aadressi kood | ||
| | |Lähetusaadressi kood | ||
|'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''AutoGiro''' | ||
| | | | ||
|''Ei kasutata, alati tühi'' | |||
|'' | |||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''SalesGroup''' | ||
| | |Müügigrupp | ||
| | |Müügigrupp | ||
|''30, Capital Characters Only'' | |||
|- | |||
|'''DisputedFlag''' | |||
|Vaidlustatud | |||
|Vaidlustatud (0=ei; 1=jah) | |||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''NoColectionFlag''' | ||
| | | | ||
| | |Kogumiseta (0=ei; 1=jah) | ||
|''0, | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''QTNr''' | ||
| | | | ||
| | |Pakkumise nr | ||
|''0, Value with No Decimals'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''FiscalFlag''' | ||
| | | | ||
| | |Fiskaalarve (0=ei; 1=jah) | ||
|''0, | |''0, As Bool but displayed as a Checkbox'' | ||
|- | |- | ||
|''' | |'''JobNr''' | ||
| | | | ||
| | |Tellimuse nr | ||
|'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''RetnValue''' | ||
| | | | ||
| | |''Ei kasutata, alati tühi'' | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''MachineName''' | ||
| | | | ||
| | |Terminali kood | ||
|'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''TransTime''' | ||
| | |Aeg | ||
| | |Muutmise kellaaeg | ||
|''0, | |''0, Hour:Min:Secs'' | ||
|- | |- | ||
|''' | |'''DrawerCode''' | ||
| | | | ||
| | |Sahtel | ||
|'' | |''5, Code String'' | ||
|- | |- | ||
|''' | |'''SiteX''' | ||
| | | | ||
| | |''Ei kasutata, alati tühi'' | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''Colnr''' | ||
| | | | ||
| | |Värv | ||
|'' | |''46, Int represented by a Set of String'' | ||
|- | |- | ||
|''' | |'''StatVal''' | ||
| | | | ||
| | |Statistiline väärtus | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''EInvFunc''' | ||
| | | | ||
| | |E-arve funktsioon | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''EInvExpFlag''' | ||
| | | | ||
| | |E-arve eksporditud (0=ei; 1=jah) | ||
|''0, | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''EInvExpDate''' | ||
| | | | ||
| | |E-arve ekspordi kuupäev | ||
|''0, | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''EInvExpQty''' | ||
| | | | ||
| | |E-arve ekspordi kogus | ||
|''0, | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''ServiceDelDate''' | ||
| | | | ||
| | |Teenuse lähetamiskuupäev | ||
|'' | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''Region''' | ||
| | | | ||
| | |Regioon | ||
|''20, String'' | |''20, Code String'' | ||
|- | |||
|'''RefStr''' | |||
|Viide | |||
|Viide | |||
|''60, String'' | |||
|- | |- | ||
|''' | |'''TAX2Sum''' | ||
| | | | ||
| | |Maks 2 | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''pdvrebt2''' | ||
| | | | ||
| | |Kassa-ale protsent 2 | ||
|'' | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|''' | |'''pdrdays2''' | ||
| | | | ||
| | |Kassa-ale päevi 2 | ||
|''0, Value with No Decimals'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''NoTax1''' | ||
| | | | ||
| | |Lisamaksuta | ||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''NoTax2''' | ||
| | | | ||
| | |Lisamaksuta 2 | ||
|''0, Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |||
|'''FreightCode''' | |||
|Transport | |||
|Transpordi kood | |||
|''5, Code String'' | |||
|- | |- | ||
|''' | |'''BankCode''' | ||
| | | | ||
| | |Pangakood | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''InvalidDate''' | ||
| | | | ||
| | |''Ei kasutata, alati tühi'' | ||
|''0, | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''InvalidLocOKNr''' | ||
| | | | ||
|'' | |''Ei kasutata, alati tühi'' | ||
|''0, Value with | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|''' | |'''NoEInvoice''' | ||
| | | | ||
| | |Ära saada e-arvena (0=ei; 1=jah) | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''TaxAuthID''' | ||
| | | | ||
| | |Maksuameti ID | ||
|'' | |''200, String'' | ||
|- | |- | ||
|''' | |'''TaxAuthIDCC''' | ||
| | | | ||
| | |Kontrollkood | ||
|'' | |''20, String'' | ||
|- | |- | ||
|''' | |'''BranchID''' | ||
| | | | ||
| | |Filiaal | ||
|'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''Status''' | ||
| | | | ||
| | |Hetkeseis | ||
|'' | |''361, Int represented by a Set of String'' | ||
|- | |- | ||
|''' | |'''NoTAXonVAT''' | ||
| | | | ||
| | |Arvuta lisamaks summast koos käibemaksuga | ||
|''0, Value with No Decimals'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''TotalwoTAX''' | ||
| | | | ||
| | |Kokku ei sisalda lisamaksu | ||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''CredManNr''' | ||
| | | | ||
| | |Krediidilimiidi number | ||
|''0, | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''RegDate''' | ||
| | | | ||
| | |Registreerimise kuupäev | ||
|''0, | |''0, In Dataformat Order'' | ||
|- | |||
|'''RegTime''' | |||
|Aeg | |||
|Registreerimise kellaaeg | |||
|''0, Hour:Min:Secs'' | |||
|- | |- | ||
|''' | |'''COCUSerNr''' | ||
| | | | ||
|'' | |''Kasutatakse vaid HansaWorldi edasimüüjate poolt'' | ||
|''0, Value | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''CAE''' | ||
| | | | ||
| | |CAE | ||
|''20, | |''20, String'' | ||
|- | |- | ||
|''' | |'''CAEExpiry''' | ||
| | | | ||
| | |CAE kehtivus | ||
|'' | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''VINr''' | ||
| | | | ||
| | |Ostuarve number | ||
|''0, Value | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''TerminalID''' | ||
| | | | ||
| | |Terminali ID | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''OrderType''' | ||
| | | | ||
| | |Tellimuse tüüp | ||
|'' | |''433, Int represented by a Set of String'' | ||
|- | |- | ||
|''' | |'''FiscalDeviceSeqNr''' | ||
| | | | ||
|'' | |''Ei kasutata, alati tühi'' | ||
|'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''CCTransID''' | ||
| | | | ||
| | |CC kande ID | ||
|'' | |''50, Capital Characters Only'' | ||
|- | |- | ||
|''' | |'''AcceptanceStatus''' | ||
| | | | ||
| | |Kinnituse hetkeseis | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''TaxMatrix''' | ||
| | | | ||
| | |Maksu maatriks, ''Eestis ei kasutata'' | ||
|'' | |''0, Packed Matrix, base64 data'' | ||
|- | |- | ||
|''' | |'''CustTaxTemplateCode''' | ||
| | | | ||
| | |Kliendi maksu maatriks, ''Eestis ei kasutata'' | ||
|''0, Value with No Decimals'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''RoyaltyIVFlag''' | ||
| | | | ||
| | |''Eestis ei kasutata'' | ||
|''0, Value | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''LoyaltyCardNr''' | ||
| | |Kliendikaart | ||
| | |Kliendikaart | ||
|'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''LCMLevel''' | ||
| | | | ||
| | |Liikmekaardi tasemete struktuur | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''Points''' | ||
| | | | ||
| | |Kliendikaardi punkte | ||
|''0, | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''DepCode''' | ||
| | | | ||
|'' | |Osakond | ||
|''10, Code String'' | |||
|- | |||
|'''SelfBilling''' | |||
|Isearveldamine | |||
|Isearveldamine | |||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''Hash''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''255, String'' | ||
|- | |- | ||
|''' | |'''HashKeyVersion''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''InvCountry''' | ||
| | | | ||
| | |Arve saaja riigi kood | ||
|'' | |''5, Code String'' | ||
|- | |- | ||
|''' | |'''DelCountry''' | ||
| | | | ||
| | |Lähetusaadressi riigi kood | ||
|'' | |''5, Code String'' | ||
|- | |- | ||
|''' | |'''TREONr''' | ||
| | | | ||
| | |TREO number | ||
|'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''ORCONr''' | ||
| | |TREO nr. | ||
| | |Müügilepingu number | ||
|'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''CAEAStartDate''' | ||
| | | | ||
| | |CAEA alguskuupäev | ||
|'' | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''CAEAExpiryDate''' | ||
| | | | ||
| | |CAEA lõpukuupäev | ||
|'' | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''CAEAFlag''' | ||
| | | | ||
| | |CAEA kasutusel (0=ei; 1=jah) | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''FInvExpFlag''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |||
|'''GroupInv''' | |||
| | |||
|Konsolideeritud arveldamine | |||
|''0, Small Value with No Decimals'' | |||
|- | |- | ||
|''' | |'''Suspended''' | ||
| | | | ||
| | |Ootel | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''AcceptanceBy''' | ||
| | | | ||
| | |Kinnitaja(d) | ||
|'' | |''200, Comma separated List'' | ||
|- | |- | ||
|''' | |'''RetNr''' | ||
| | | | ||
|''Eestis ei kasutata, alati tühi'' | |''Eestis ei kasutata, alati tühi'' | ||
|''0, | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''TaxAdminServSeal''' | ||
| | | | ||
| | |Maksupisat | ||
|'' | |''250, String'' | ||
|- | |- | ||
|''' | |'''CredOfficialSerNr''' | ||
| | | | ||
|''Eestis ei kasutata, alati tühi'' | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''100, Capital Characters Only'' | ||
|- | |- | ||
|''' | |'''AcceptanceFYI''' | ||
| | | | ||
| | |Teadmiseks saajad | ||
|'' | |''200, Comma separated List'' | ||
|- | |- | ||
|''' | |'''PMCode''' | ||
| | | | ||
| | |Tasumisviis | ||
|'' | |''2, Code String'' | ||
|- | |- | ||
|''' | |'''PayAccNo''' | ||
| | | | ||
| | |Tasumise konto nr | ||
|'' | |''4, String'' | ||
|- | |- | ||
|''' | |'''BrazilEInvType''' | ||
| | | | ||
| | |Arve tüüp | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''TaxAdminReceiptNr''' | ||
| | | | ||
| | |E-arve. konf. nr. | ||
|'' | |''200, String'' | ||
|- | |- | ||
|''' | |'''TaxAuthReceiptDate''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''TaxAuthReceiptTime''' | ||
| | | | ||
|''Eestis ei kasutata, alati tühi'' | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''0, Hour:Min:Secs'' | ||
|- | |- | ||
|''' | |'''ReceiptInfo''' | ||
| | | | ||
| | |Laekumise info | ||
|'' | |''200, String'' | ||
|- | |- | ||
|''' | |'''InvalidTime''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''0, Hour:Min:Secs'' | ||
|- | |- | ||
|''' | |'''OKBy''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''PlanSendDate''' | ||
| | |Plan. saatmise kp. | ||
| | |Planeeritud lähetuse kuupäev | ||
|'' | |''0, In Dataformat Order'' | ||
|- | |- | ||
|''' | |'''PlanSendTime''' | ||
| | |Plan. saatmise aeg | ||
| | |Planeeritud saatmise kellaaeg | ||
|'' | |''0, Hour:Min:Secs'' | ||
|- | |- | ||
|''' | |'''PlanArrDate''' | ||
| | |Plan. saabumise kp. | ||
| | |Planeeritud saabumise kuupäev | ||
|''0, | |''0, In Dataformat Order'' | ||
|- | |||
|'''PlanArrTime''' | |||
|Plan. saabumise aeg | |||
|Planeeritud saabumise kellaaeg | |||
|''0, Hour:Min:Secs'' | |||
|- | |- | ||
|''' | |'''FedServCode''' | ||
| | | | ||
| | |Riiklik teenus (0=ei; 1=jah) | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''InvalidBy''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''Reason''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|''20, String'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''InvCountryName''' | ||
| | | | ||
| | |Arve saaja riigi nimi | ||
|'' | |''100, String'' | ||
|- | |- | ||
|''' | |'''DelCountryName''' | ||
| | | | ||
| | |Lähetusriigi nimi | ||
|'' | |''100, String'' | ||
|- | |- | ||
|''' | |'''OfficialSerNrSerie''' | ||
| | | | ||
| | |Seeria | ||
|'' | |''30, String'' | ||
|- | |- | ||
|''' | |'''OfficialSerNr2Serie''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''30, String'' | ||
|- | |- | ||
|''' | |'''IPBookVAT''' | ||
| | | | ||
| | |Konteeri laekumise KM (0=ei; 1=jah) | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''ThirdPartyBillMark''' | ||
| | | | ||
| | |''Eestis ei kasutata, alati tühi'' | ||
|'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''RecipientGLN''' | ||
| | | | ||
| | |GLN ''(Global Location Number)'' | ||
|'' | |''20, String'' | ||
|- | |- | ||
| | |'''DelRecipientGLN''' | ||
| | | | ||
|Lähetuse GLN | |||
|''20, String'' | |||
|- | |- | ||
|''' | |'''IntrastatTransCode''' | ||
| | |Intrastati kandekood | ||
| | |Intrastati kandekood | ||
|''20, Code String'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''GlobalTransportNr''' | ||
|Glob. transpordi nr. | |||
|Globaalne transpordinumber | |||
|''30, Capital Characters Only'' | |||
|- | |||
|'''GlobalTransportDate''' | |||
|Glob. transpordi kp. | |||
|Globaalne transpordikuupäev | |||
|''0, In Dataformat Order'' | |||
|- | |||
|'''DeliverySiteCode''' | |||
| | | | ||
| | |Lähetusaadressi kood | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''PrintDate''' | ||
| | |Printimise kuupäev | ||
| | |Printimise kuupäev | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''WorkSiteNumber''' | ||
| | | | ||
| | |Asukoha number | ||
|'' | |''60, String'' | ||
|- | |- | ||
|''' | |'''GPProc''' | ||
| | | | ||
| | |GP protsent | ||
|''0, Value with One Decimal'' | |''0, Value with One Decimal'' | ||
|} | |||
=== Maatriks === | |||
{| class="wikitable" | |||
|- | |- | ||
!Kood | |||
!Kasutajaliidese nimi | |||
!'''Kirjeldus''' | |||
!''Pikkus, tüüp'' | |||
|- | |- | ||
|''' | |'''ArtCode''' | ||
| | |Artikkel | ||
| | |Artiklikood | ||
|'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''Quant''' | ||
| | |Kogus | ||
| | |Kogus | ||
|''0, Value with | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|''' | |'''Price''' | ||
| | |Ühikuhind | ||
| | |Hind | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value with 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''Sum''' | ||
| | |Summa | ||
| | |Kokku | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''vRebate''' | ||
| | |% | ||
| | |Allahindlusprotsent | ||
|''0, Value with | |''0, Value with One Decimal'' | ||
|- | |- | ||
|''' | |'''SalesAcc''' | ||
| | |Konto | ||
| | |Müügi konto | ||
|''10, Code String'' | |''10, Code String'' | ||
|- | |- | ||
|''' | |'''Objects''' | ||
| | |Objektid | ||
| | |Objekt(id) | ||
|'' | |''60, Capital Characters Only'' | ||
|- | |- | ||
|''' | |'''OrdRow''' | ||
| | | | ||
| | |Tellimuse read | ||
|'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''BasePrice''' | ||
| | |Hind | ||
| | |Baashind | ||
|''0, Value | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''rowGP''' | ||
| | |Müügikate | ||
| | |Rea müügikate | ||
|'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|''' | |'''FIFO''' | ||
| | |FIFO | ||
| | |FIFO hind | ||
|''0, Value with All Decimals'' | |''0, Value with All Decimals'' | ||
|- | |- | ||
|''' | |'''Spec''' | ||
| | |Kirjeldus | ||
| | |Kirjeldus | ||
|'' | |''100, String'' | ||
|- | |- | ||
|''' | |'''VATCode''' | ||
| | |KM-k | ||
| | |KM kood | ||
|''10, Code String'' | |||
|- | |||
|'''Recepy''' | |||
|Retsept | |||
|Retsept | |||
|''20, Code String'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''SerialNr''' | ||
| | |Seerianr./Partii nr | ||
| | |Seerianumber | ||
|'' | |''60, String'' | ||
|- | |||
|'''PriceFactor''' | |||
|Hinna f. | |||
|Hinna faktor | |||
|''0, Value with All Decimals'' | |||
|- | |- | ||
|''' | |'''VARList''' | ||
| | | | ||
| | |VAR | ||
|'' | |''30, Capital Characters Only'' | ||
|- | |- | ||
|''' | |'''CUPNr''' | ||
| | | | ||
| | |Ettemaksu | ||
|'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|''' | |'''FIFORowVal''' | ||
| | |FIFO | ||
| | |Rea fifo | ||
|''0, Value with | |''0, Value with All Decimals'' | ||
|- | |- | ||
|''' | |'''Coefficient''' | ||
| | |Koef. | ||
| | |Koefitsent | ||
|''0, Value with | |''0, Value with All Decimals'' | ||
|- | |- | ||
|''' | |'''CuAccCode''' | ||
| | | | ||
| | |Kliendi konto? | ||
|'' | |''20, Code String'' | ||
|- | |- | ||
|''' | |'''ExciseNr''' | ||
| | | | ||
|Aktsiis | |||
|''20, String'' | |||
|- | |||
|'''PeriodCode''' | |||
|Per. Mudel | |||
|Periodiseerimise mudel | |||
|''10, Code String'' | |||
|- | |||
|'''UnitCode''' | |||
|Ühik | |||
|Ühiku kood | |||
|''5, Code String'' | |||
|- | |||
|'''UnitFactQuant''' | |||
|Üh. Kogus | |||
|Ühiku kogus | |||
|''0, Value with minimum Decimals'' | |||
|- | |||
|'''UnitFactPrice''' | |||
|Ühikuhind | |||
|Ühiku hind | |||
|''0, Value with 2 or 3 Decimals'' | |||
|- | |||
|'''UnitXval''' | |||
|Laius | |||
|Laius | |||
|''0, Value with minimum Decimals'' | |||
|- | |||
|'''UnitYval''' | |||
|Kõrgus | |||
|Kõrgus | |Kõrgus | ||
|''0, Value with minimum Decimals'' | |''0, Value with minimum Decimals'' | ||
|- | |- | ||
|'''UnitZval''' | |'''UnitZval''' | ||
| | |Sügavus | ||
|Sügavus | |Sügavus | ||
|''0, Value with minimum Decimals'' | |''0, Value with minimum Decimals'' | ||
1389. rida: | 1514. rida: | ||
|- | |- | ||
|'''RepaExVAT''' | |'''RepaExVAT''' | ||
| | |Tagatisraha | ||
|Tagatisraha | |Tagatisraha | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
|- | |- | ||
|'''BasePriceB2''' | |'''BasePriceB2''' | ||
| | |Ostuhind B2 | ||
|Ostuhind 2 | |Ostuhind 2 | ||
|''0, Value 2 or 3 Decimals'' | |''0, Value 2 or 3 Decimals'' | ||
1424. rida: | 1549. rida: | ||
|- | |- | ||
|'''CreditedRow''' | |'''CreditedRow''' | ||
| | | | ||
|Krediitarve rida | |Krediitarve rida | ||
|''0, Value with No Decimals'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|'''NotUpdStockFlag''' | |'''NotUpdStockFlag''' | ||
| | | | ||
|Ei muuda ladu (0=ei; 1=jah) | |Ei muuda ladu (0=ei; 1=jah) | ||
|''0, Small Value with No Decimals'' | |''0, Small Value with No Decimals'' | ||
|- | |- | ||
|'''CUServiceHistNr''' | |'''CUServiceHistNr''' | ||
| | | | ||
|Kliendi teeninduslepingu number | |Kliendi teeninduslepingu number | ||
|''0, Value with No Decimals'' | |''0, Value with No Decimals'' | ||
|- | |- | ||
|'''CUServiceUntilDate''' | |'''CUServiceUntilDate''' | ||
| | | | ||
|Kliendi teeninduslepingu kehtivus | |Kliendi teeninduslepingu kehtivus | ||
|''0, In Dataformat Order'' | |''0, In Dataformat Order'' | ||
|- | |- | ||
|'''ServiceDelDate''' | |'''ServiceDelDate''' | ||
| | | | ||
|Teenuse lähetuskuupäev | |Teenuse lähetuskuupäev | ||
|''0, In Dataformat Order'' | |''0, In Dataformat Order'' | ||
|- | |- | ||
|'''Location''' | |'''Location''' | ||
| | |Ladu | ||
|Ladu | |Ladu | ||
|''10, Code String'' | |''10, Code String'' | ||
1589. rida: | 1714. rida: | ||
|- | |- | ||
|'''Salesmen''' | |'''Salesmen''' | ||
| | |Müügimees | ||
|Müügimees | |Müügimees | ||
|''60, Capital Characters Only'' | |''60, Capital Characters Only'' |
Viimane redaktsioon: 25. september 2019, kell 06:39
Register
- <data> element peab sisaldama:
- register="IVVc"
Toetatud väljad
Päis
Kood | Kasutajaliidese nimi | Kirjeldus | Pikkus, tüüp | Kohustuslik | Kommentaar |
SerNr | Nr. | Arve programmi-sisene seerianumber | 0, Value with No Decimals | Kui tühi, siis võetakse järgmine vaba seerianumber. Kui ei ole tühi, siis toimub kontroll, kas see number on vaba ja kuulub numbriseeriasse. | |
InvDate | Arve kp. | Arve kuupäev | 0, In Dataformat Order | + | Will connect the outer system invoice number with Hansa serial number |
TransDate | Kande kp. | Kande kp. | 0, In Dataformat Order | + | |
CustCode | Klient | Kliendi kood | 20, Code String | + | Hansa internal customer code, must be created in advance |
Standard Booksi loogika ei luba kirjutada antud väljale. Ümardamise probleemide vältimiseks kasutame ümardamise seadistust. | |||||
Standard Booksi loogika ei luba kirjutada antud väljale. Ümardamise probleemide vältimiseks kasutame ümardamise seadistust. | |||||
Standard Booksi loogika ei luba kirjutada antud väljale. Ümardamise probleemide vältimiseks kasutame ümardamise seadistust. | |||||
Ei POSTita ikka seda välja enam, muutub automaatselt PayDeal asetamisel, kui on PayDeal Krediitarve tüüpi | |||||
PayDeal | Tasumistingimus | Tasumistingimuse kood | 2, Code String | + | |
OKFlag | Kinnita | Kinnitatud. 0=ei, 1=jah | 0, As Bool but displayed as a Checkbox | + | |
CurncyCode | Valuuta | Valuuta | 5, Code String | + | |
Addr0 | Kliendi nimi | Arve saaja aadressi 1. rida | 60, String | Võetakse kliendikoodi aluses kontaktide registrist, kuid on võimalik päringuga saata eraldi ka. | |
OfficialSerNr | Ametlik ser. nr. | Ametlik seerianumber | 100, String | ||
Objects | Objektid | Objektid. Läbiva suurtähega, eraldatud komaga. | 60, Capital Characters Only | ||
RefStr | Viide | Arve viitenumber | 60, String |
Maatriks
Kood | Kasutajaliidese nimi | Kirjeldus | Pikkus, tüüp | Kohustuslik | Kommentaar |
stp | Rea tüüp (1=tavaline) | 1, Integer | + | number defines the type of row in Hansa, must only be 1 for the moment (regular row) | |
ArtCode | Artikkel | Artiklikood | 20, Code String | + | Hansa internal article code, must be created in advance |
Spec | Kirjeldus | Kirjeldus | 100, String | ||
Quant | Kogus | Kogus | 0, Value with minimum Decimals | + | |
Price | Ühikuhind | Hind | 0, Value with 2 or 3 Decimals | + | |
Sum | Summa | Kokku | 0, Value 2 or 3 Decimals | + | |
VATCode | KM kood | KM kood | 10, Code String | + | |
SalesAcc | Konto | Müügi konto | 10, Code String | ||
Objects | Objektid | Objekt(id) | 60, Capital Characters Only |
Näidis XML päring
<?xml version="1.0" encoding="UTF-8"?>
<data register="IVVc" sequence="106357" systemversion="8.4.20.504">
<IVVc>
<RefStr>123456789</RefStr>
<InvDate>2018-01-23</InvDate>
<TransDate>2018-01-23</TransDate>
<CustCode>101</CustCode>
<Sum1>100</Sum1>
<Sum3>20</Sum3>
<Sum4>120</Sum4>
<InvType>1</InvType>
<PayDeal>5</PayDeal>
<OKFlag>0</OKFlag>
<rows>
<row rownumber="0"><!-- required, number defines the row in Hansa, starts with 0 -->
<stp>1</stp>
<ArtCode>001</ArtCode>
<Quant>15</Quant>
<Price>15.64</Price>
<Sum>234,6</Sum>
<VATCode>1</VATCode>
</row>
</rows>
</IVVc>
</data>
Kõigi XML väljade kirjeldused
Päis
Kood | Kasutajaliidese nimi | Kirjeldus | Pikkus, tüüp |
---|---|---|---|
SerNr | Nr. | Arve number | 0, Value with No Decimals |
InvDate | Arve kp. | Arve kuupäev | 0, In Dataformat Order |
CustCode | Klient | Kliendi kood | 20, Code String |
PayDate | Laekumistähtaeg | Maksetähtaeg | 0, In Dataformat Order |
Addr0 | Kliendi nimi | Arve saaja aadressi 1. rida | 60, String |
Addr1 | Aadres | Arve saaja aadressi 2. rida | 60, String |
Addr2 | Arve saaja aadressi 3. rida | 60, String | |
Addr3 | Arve saaja aadressi 4. rida | 60, String | |
OurContact | Meie esindaja | Meie esindaja, arve koostaja | 20, String |
ClientContact | Nende esindaja | Kliendi esindaja | 60, String |
ExportFlag | Käibemaksutsoon
0 = „Eesti“ 1 = „EL“, 2 = „EL (konteeri KM)“, 3 = „Mitte EL“ 4 = „Mitte EL (konteeri KM) |
0, Small Value with No Decimals | |
PayDeal | Tasumistingimus | Tasumistingimuse kood | 2, Code String |
OrderNr | Tellimuse nr | Tellimuse nr (millest arve on koostatud) | 0, Value with No Decimals |
Prntdf | Saadetud. 0=ei, 1=jah | 0, Small Value with No Decimals | |
OKFlag | Kinnita | Kinnitatud. 0=ei, 1=jah | 0, As Bool but displayed as a Checkbox |
pdays | Netopäevi (maksetähtaeg) | 0, Value with No Decimals | |
pdvrebt | Kassa-ale protsent | 0, Value with minimum Decimals | |
pdrdays | Kassa-ale päevi | 0, Value with No Decimals | |
CustCat | Kliendiklass | 5, Code String | |
pdComment | Tekst (peidus) | 60, String | |
x1 | Ei kasutata | 0, Empty Field | |
InvType | Arve tüüp (Tavaline, kreedit jne. 1=tavaline) | 0, Small Value with No Decimals | |
xStatFlag | Ei kasutata, alati 0 | 0, Small Value with No Decimals | |
PriceList | Hinnakiri | Hinnakiri | 5, Code String |
Objects | Objektid | Objektid. Läbiva suurtähega, eraldatud komaga. | 60, Capital Characters Only |
InclVAT | Hind KM-ga (0=ei; 1=jah) | 0, Small Value with No Decimals | |
ARAcc | Ümberhindluskonto (finantskonto) | 10, Code String | |
InvComment | Kommentaar | Arve kommentaar | 200, String |
CredInv | Kreediteeritava arve nr | 0, Value with No Decimals | |
CredMark | Kreeditarve (0=ei; 1=jah) | 1, String | |
SalesMan | Isik | Meie esindaja | 60, Capital Characters Only |
ToRateB1 | Baasvaluuta1 | Kurss B1 suhtes | 0, Value with 6 Decimals |
TransDate | Kande kp. | Kande kuupäev | 0, In Dataformat Order |
CurncyCode | Valuuta | Valuuta | 5, Code String |
LangCode | Keel | Keel | 5, Code String |
UpdStockFlag | Muuda ladu | Muuda ladu (0=ei; 1=jah) | 0, Small Value with No Decimals |
LastRemndr | Märgukirjatase | Märgukirjatase | 0, Value with No Decimals |
LastRemDate | Viimane märguk. kp. | Viimase märgukirja kuupäev | 0, In Dataformat Order |
Sign | Isik | Arve koostaja, allkiri | 10, Code String |
FrPrice | Transpordi hind | 0, Value 2 or 3 Decimals | |
FrBase | Ei kasutata, alati tühi | 0, Value 2 or 3 Decimals | |
FrItem | Transpordi artiklikood | 20, Code String | |
FrVATCode | Trans. KM-k | Transpordi käibemaksukood | 10, Code String |
FrObjects | Transpordi objektid | 60, Capital Characters Only | |
OrgCust | Algne klient | 20, Code String | |
FrGP | Ei kasutata, alati tühi | 0, Value 2 or 3 Decimals | |
FrGPPercent | Müügikatte protsent hinnast | 0, Value 2 or 3 Decimals | |
Sum0 | Ümardus | 0, Value 2 or 3 Decimals | |
Sum1 | Vahesumma | Neto summa | 0, Value 2 or 3 Decimals |
Sum2 | Kokku (Eestis tühi) | 0, Value 2 or 3 Decimals | |
Sum3 | KM | Käibemaksu summa | 0, Value 2 or 3 Decimals |
Sum4 | KOKKU | Kokku | 0, Value 2 or 3 Decimals |
VATNr | KMKR nr. | Kliendi KMKR number | 20, String |
ShipDeal | Lähetustingimus | 5, Code String | |
ShipAddr0 | Lähetus- | Lähetusaadressi 1. rida | 60, String |
ShipAddr1 | Aadress | Lähetusaadressi 2. rida | 60, String |
ShipAddr2 | Lähetusaadressi 3. rida | 60, String | |
ShipAddr3 | Lähetusaadressi 4. rida | 60, String | |
ShipMode | Lähetusviis | Lähetusviis | 5, Code String |
Location | Ladu | Ladu | 10, Code String |
PRCode | Projekt | Projekti kood | 20, Code String |
FrSalesAcc | Ei kasutata, alati tühi | 10, Code String | |
TAX1Sum | Lisamaks | 0, Value 2 or 3 Decimals | |
CustVATCode | Kliendi KM kood | 10, Code String | |
RebCode | Allahindlusmaatriksi kood (kliendilt) | 5, Code String | |
CalcFinRef | Viide | Viide | 30, String |
Phone | Telefon (kliendi) | 20, String with phone-number | |
Fax | Faks (kliendi) | 20, String | |
IntCode | Viivis | 10, String | |
ARonTR | Info kande E-osale | Info kande E-osale (0=ei; 1=jah) | 0, Small Value with No Decimals |
CustOrdNr | Kliendi tellimuse number | 60, String | |
ExportedFlag | Eksporditud (0=ei; 1=jah) | 0, Small Value with No Decimals | |
BaseSum4 | Suma | Summa | 0, Value 2 or 3 Decimals |
FrRate | Baasvaluuta1 | Kurss B1-te | 0, Value with 6 Decimals |
ToRateB2 | Baasvaluuta2 | Kurss B2-te | 0, Value with 6 Decimals |
BaseRate1 | Baasvaluuta1 | B1 kurss | 0, Value with 6 Decimals |
BaseRate2 | Baasvaluuta2 | B2 kurss | 0, Value with 6 Decimals |
InvoiceNr | Hankija arve nr | 20, String | |
DiscPerc | Allahindlusprotsent | 0, Value with minimum Decimals | |
DiscSum | Allahindluse summa | 0, Value 2 or 3 Decimals | |
TotGP | Kokku MK | Kokku MK (Müügikate) | 0, Value 2 or 3 Decimals |
LocOKNr | Asukoha kin. nr. | 0, Value with minimum Decimals | |
Invalid | Kehtetu, suletud. | 0, Small Value with No Decimals | |
CreditCard | Krediitkaart | 20, Capital Characters Only | |
AuthorizationCode | Autoriseerimiskood | 10, Capital Characters Only | |
RecValue | Makstud (0=ei; 1=jah) | 0, Value 2 or 3 Decimals | |
RetValue | Sularaha tagasi | 0, Value 2 or 3 Decimals | |
FromBUQT | Ei kasutata, alati tühi | 0, Small Value with No Decimals | |
Sorting | Teekond | Teekond | 20, String |
NoInterestFlag | Ära arvesta viivist | Ära arvesta viivist (0=ei; 1=jah) | 0, Small Value with No Decimals |
NoRemndrFlag | Ära koosta masskirju | Ära koosta masskirju (0=ei; 1=jah) | 0, Small Value with No Decimals |
SVONr | Teenindustellimuse nr | 0, Value with No Decimals | |
InstallmentInv | Ei kasutata, alati tühi | 0, Small Value with No Decimals | |
OfficialSerNr | Ametlik ser. nr. | Ametlik seerianumber | 100, String |
OfficialSerNr2 | Ametlik ser. nr. 2 | Ametlik seerianumber 2 | 100, String |
TotQty | Kogus kokku | Kokku kogus | 0, Value with minimum Decimals |
TotWeight | Kaal Kokku | Kokku kaal | 0, Value with minimum Decimals |
TotVolume | Maht Kokku | Maht kokku | 0, Value with minimum Decimals |
Commision | Teenustasu | Teenustasu | 0, Value 2 or 3 Decimals |
SumIncCom | Kokku teen.-ga | Kokku teenustasuga | 0, Value 2 or 3 Decimals |
InvAddr3 | Arve aadress 4. Rida | 60, String | |
InvAddr4 | Arve aadress 5. Rida | 60, String | |
DelAddr3 | Lähetusaadress 4. Rida | 60, String | |
DelAddr4 | Lähetusaadress 5. Rida | 60, String | |
DelAddrCode | Aadressi kood | Lähetusaadressi kood | 20, Code String |
AutoGiro | Ei kasutata, alati tühi | 0, Small Value with No Decimals | |
SalesGroup | Müügigrupp | Müügigrupp | 30, Capital Characters Only |
DisputedFlag | Vaidlustatud | Vaidlustatud (0=ei; 1=jah) | 0, Small Value with No Decimals |
NoColectionFlag | Kogumiseta (0=ei; 1=jah) | 0, Small Value with No Decimals | |
QTNr | Pakkumise nr | 0, Value with No Decimals | |
FiscalFlag | Fiskaalarve (0=ei; 1=jah) | 0, As Bool but displayed as a Checkbox | |
JobNr | Tellimuse nr | 0, Value with No Decimals | |
RetnValue | Ei kasutata, alati tühi | 0, Value 2 or 3 Decimals | |
MachineName | Terminali kood | 20, Code String | |
TransTime | Aeg | Muutmise kellaaeg | 0, Hour:Min:Secs |
DrawerCode | Sahtel | 5, Code String | |
SiteX | Ei kasutata, alati tühi | 10, Code String | |
Colnr | Värv | 46, Int represented by a Set of String | |
StatVal | Statistiline väärtus | 0, Value 2 or 3 Decimals | |
EInvFunc | E-arve funktsioon | 0, Small Value with No Decimals | |
EInvExpFlag | E-arve eksporditud (0=ei; 1=jah) | 0, Small Value with No Decimals | |
EInvExpDate | E-arve ekspordi kuupäev | 0, In Dataformat Order | |
EInvExpQty | E-arve ekspordi kogus | 0, Value with No Decimals | |
ServiceDelDate | Teenuse lähetamiskuupäev | 0, In Dataformat Order | |
Region | Regioon | 20, Code String | |
RefStr | Viide | Viide | 60, String |
TAX2Sum | Maks 2 | 0, Value 2 or 3 Decimals | |
pdvrebt2 | Kassa-ale protsent 2 | 0, Value with minimum Decimals | |
pdrdays2 | Kassa-ale päevi 2 | 0, Value with No Decimals | |
NoTax1 | Lisamaksuta | 0, Small Value with No Decimals | |
NoTax2 | Lisamaksuta 2 | 0, Small Value with No Decimals | |
FreightCode | Transport | Transpordi kood | 5, Code String |
BankCode | Pangakood | 10, Code String | |
InvalidDate | Ei kasutata, alati tühi | 0, In Dataformat Order | |
InvalidLocOKNr | Ei kasutata, alati tühi | 0, Value with minimum Decimals | |
NoEInvoice | Ära saada e-arvena (0=ei; 1=jah) | 0, Small Value with No Decimals | |
TaxAuthID | Maksuameti ID | 200, String | |
TaxAuthIDCC | Kontrollkood | 20, String | |
BranchID | Filiaal | 20, Code String | |
Status | Hetkeseis | 361, Int represented by a Set of String | |
NoTAXonVAT | Arvuta lisamaks summast koos käibemaksuga | 0, Value with No Decimals | |
TotalwoTAX | Kokku ei sisalda lisamaksu | 0, Small Value with No Decimals | |
CredManNr | Krediidilimiidi number | 0, Value with No Decimals | |
RegDate | Registreerimise kuupäev | 0, In Dataformat Order | |
RegTime | Aeg | Registreerimise kellaaeg | 0, Hour:Min:Secs |
COCUSerNr | Kasutatakse vaid HansaWorldi edasimüüjate poolt | 0, Value with No Decimals | |
CAE | CAE | 20, String | |
CAEExpiry | CAE kehtivus | 0, In Dataformat Order | |
VINr | Ostuarve number | 0, Value with No Decimals | |
TerminalID | Terminali ID | 60, String | |
OrderType | Tellimuse tüüp | 433, Int represented by a Set of String | |
FiscalDeviceSeqNr | Ei kasutata, alati tühi | 0, Value with No Decimals | |
CCTransID | CC kande ID | 50, Capital Characters Only | |
AcceptanceStatus | Kinnituse hetkeseis | 0, Small Value with No Decimals | |
TaxMatrix | Maksu maatriks, Eestis ei kasutata | 0, Packed Matrix, base64 data | |
CustTaxTemplateCode | Kliendi maksu maatriks, Eestis ei kasutata | 0, Value with No Decimals | |
RoyaltyIVFlag | Eestis ei kasutata | 0, Value 2 or 3 Decimals | |
LoyaltyCardNr | Kliendikaart | Kliendikaart | 20, Code String |
LCMLevel | Liikmekaardi tasemete struktuur | 10, Code String | |
Points | Kliendikaardi punkte | 0, Value 2 or 3 Decimals | |
DepCode | Osakond | 10, Code String | |
SelfBilling | Isearveldamine | Isearveldamine | 0, Small Value with No Decimals |
Hash | Eestis ei kasutata, alati tühi | 255, String | |
HashKeyVersion | Eestis ei kasutata, alati tühi | 0, Small Value with No Decimals | |
InvCountry | Arve saaja riigi kood | 5, Code String | |
DelCountry | Lähetusaadressi riigi kood | 5, Code String | |
TREONr | TREO number | 0, Value with No Decimals | |
ORCONr | TREO nr. | Müügilepingu number | 0, Value with No Decimals |
CAEAStartDate | CAEA alguskuupäev | 0, In Dataformat Order | |
CAEAExpiryDate | CAEA lõpukuupäev | 0, In Dataformat Order | |
CAEAFlag | CAEA kasutusel (0=ei; 1=jah) | 0, Small Value with No Decimals | |
FInvExpFlag | Eestis ei kasutata, alati tühi | 0, Small Value with No Decimals | |
GroupInv | Konsolideeritud arveldamine | 0, Small Value with No Decimals | |
Suspended | Ootel | 0, Small Value with No Decimals | |
AcceptanceBy | Kinnitaja(d) | 200, Comma separated List | |
RetNr | Eestis ei kasutata, alati tühi | 0, Value with No Decimals | |
TaxAdminServSeal | Maksupisat | 250, String | |
CredOfficialSerNr | Eestis ei kasutata, alati tühi | 100, Capital Characters Only | |
AcceptanceFYI | Teadmiseks saajad | 200, Comma separated List | |
PMCode | Tasumisviis | 2, Code String | |
PayAccNo | Tasumise konto nr | 4, String | |
BrazilEInvType | Arve tüüp | 10, Code String | |
TaxAdminReceiptNr | E-arve. konf. nr. | 200, String | |
TaxAuthReceiptDate | Eestis ei kasutata, alati tühi | 0, In Dataformat Order | |
TaxAuthReceiptTime | Eestis ei kasutata, alati tühi | 0, Hour:Min:Secs | |
ReceiptInfo | Laekumise info | 200, String | |
InvalidTime | Eestis ei kasutata, alati tühi | 0, Hour:Min:Secs | |
OKBy | Eestis ei kasutata, alati tühi | 10, Code String | |
PlanSendDate | Plan. saatmise kp. | Planeeritud lähetuse kuupäev | 0, In Dataformat Order |
PlanSendTime | Plan. saatmise aeg | Planeeritud saatmise kellaaeg | 0, Hour:Min:Secs |
PlanArrDate | Plan. saabumise kp. | Planeeritud saabumise kuupäev | 0, In Dataformat Order |
PlanArrTime | Plan. saabumise aeg | Planeeritud saabumise kellaaeg | 0, Hour:Min:Secs |
FedServCode | Riiklik teenus (0=ei; 1=jah) | 10, Code String | |
InvalidBy | Eestis ei kasutata, alati tühi | 10, Code String | |
Reason | Eestis ei kasutata, alati tühi | 20, Code String | |
InvCountryName | Arve saaja riigi nimi | 100, String | |
DelCountryName | Lähetusriigi nimi | 100, String | |
OfficialSerNrSerie | Seeria | 30, String | |
OfficialSerNr2Serie | Eestis ei kasutata, alati tühi | 30, String | |
IPBookVAT | Konteeri laekumise KM (0=ei; 1=jah) | 0, Small Value with No Decimals | |
ThirdPartyBillMark | Eestis ei kasutata, alati tühi | 0, Small Value with No Decimals | |
RecipientGLN | GLN (Global Location Number) | 20, String | |
DelRecipientGLN | Lähetuse GLN | 20, String | |
IntrastatTransCode | Intrastati kandekood | Intrastati kandekood | 20, Code String |
GlobalTransportNr | Glob. transpordi nr. | Globaalne transpordinumber | 30, Capital Characters Only |
GlobalTransportDate | Glob. transpordi kp. | Globaalne transpordikuupäev | 0, In Dataformat Order |
DeliverySiteCode | Lähetusaadressi kood | 60, String | |
PrintDate | Printimise kuupäev | Printimise kuupäev | 60, String |
WorkSiteNumber | Asukoha number | 60, String | |
GPProc | GP protsent | 0, Value with One Decimal |
Maatriks
Kood | Kasutajaliidese nimi | Kirjeldus | Pikkus, tüüp |
---|---|---|---|
ArtCode | Artikkel | Artiklikood | 20, Code String |
Quant | Kogus | Kogus | 0, Value with minimum Decimals |
Price | Ühikuhind | Hind | 0, Value with 2 or 3 Decimals |
Sum | Summa | Kokku | 0, Value 2 or 3 Decimals |
vRebate | % | Allahindlusprotsent | 0, Value with One Decimal |
SalesAcc | Konto | Müügi konto | 10, Code String |
Objects | Objektid | Objekt(id) | 60, Capital Characters Only |
OrdRow | Tellimuse read | 0, Value with No Decimals | |
BasePrice | Hind | Baashind | 0, Value 2 or 3 Decimals |
rowGP | Müügikate | Rea müügikate | 0, Value 2 or 3 Decimals |
FIFO | FIFO | FIFO hind | 0, Value with All Decimals |
Spec | Kirjeldus | Kirjeldus | 100, String |
VATCode | KM-k | KM kood | 10, Code String |
Recepy | Retsept | Retsept | 20, Code String |
SerialNr | Seerianr./Partii nr | Seerianumber | 60, String |
PriceFactor | Hinna f. | Hinna faktor | 0, Value with All Decimals |
VARList | VAR | 30, Capital Characters Only | |
CUPNr | Ettemaksu | 0, Value with No Decimals | |
FIFORowVal | FIFO | Rea fifo | 0, Value with All Decimals |
Coefficient | Koef. | Koefitsent | 0, Value with All Decimals |
CuAccCode | Kliendi konto? | 20, Code String | |
ExciseNr | Aktsiis | 20, String | |
PeriodCode | Per. Mudel | Periodiseerimise mudel | 10, Code String |
UnitCode | Ühik | Ühiku kood | 5, Code String |
UnitFactQuant | Üh. Kogus | Ühiku kogus | 0, Value with minimum Decimals |
UnitFactPrice | Ühikuhind | Ühiku hind | 0, Value with 2 or 3 Decimals |
UnitXval | Laius | Laius | 0, Value with minimum Decimals |
UnitYval | Kõrgus | Kõrgus | 0, Value with minimum Decimals |
UnitZval | Sügavus | Sügavus | 0, Value with minimum Decimals |
VECode | Hankija kood | 20, Code String | |
CreditCard | Krediitkaart | 20, Capital Characters Only | |
AuthorizationCode | Autoriseerimiskood | 10, Capital Characters Only | |
PosCode | Asukohast | 20, Code String | |
CurncyCode | Valuuta | 5, Code String | |
FrRate | Kurss | 0, Value with 6 Decimals | |
ToRateB1 | B.1 kursile | 0, Value with 6 Decimals | |
ToRateB2 | B.2 kursile | 0, Value with 6 Decimals | |
BaseRate1 | Baasvaluuta 1 | 0, Value with 6 Decimals | |
BaseRate2 | Baasvaluuta 2 | 0, Value with 6 Decimals | |
PayMode | Tasumisviis | 2, Code String | |
GCNr | GC number | 0, Value with No Decimals | |
CustOrdNr | Kliendi tellimuse number | 60, String | |
RepaExVAT | Tagatisraha | Tagatisraha | 0, Value 2 or 3 Decimals |
BasePriceB2 | Ostuhind B2 | Ostuhind 2 | 0, Value 2 or 3 Decimals |
TAX2Code | Eestis ei kasutata, alati tühi | 5, Code String | |
TAX2Prc | Eestis ei kasutata, alati tühi | 0, Value with 2 or 3 Decimals | |
TAX2Reb | Eestis ei kasutata, alati tühi | 0, Value 2 or 3 Decimals | |
TAX1Reb | Lisamaksud, kliendi allahindlused | 0, Value 2 or 3 Decimals | |
TAX2Acc | Eestis ei kasutata, alati tühi | 10, Code String | |
CreditedRow | Krediitarve rida | 0, Value with No Decimals | |
NotUpdStockFlag | Ei muuda ladu (0=ei; 1=jah) | 0, Small Value with No Decimals | |
CUServiceHistNr | Kliendi teeninduslepingu number | 0, Value with No Decimals | |
CUServiceUntilDate | Kliendi teeninduslepingu kehtivus | 0, In Dataformat Order | |
ServiceDelDate | Teenuse lähetuskuupäev | 0, In Dataformat Order | |
Location | Ladu | Ladu | 10, Code String |
Comment | Kommentaar | 100, String | |
DiscApprovedBy | Allahindluse kinnitaja | 10, Code String | |
Perceptions | Arvuta piirkondlikud maksud | 0, Small Value with No Decimals | |
VoidedRowNr | Eestis ei kasutata, alati tühi | 0, Value with No Decimals | |
VoidedSign | Allkiri | 10, Code String | |
ovst | Alati 0 | 0, Small Value with No Decimals | |
Withholdings | Arvuta kinnipidamismaksud | 0, Small Value with No Decimals | |
WHTax | Kinnipidamismaks | 2, Code String | |
CCTransID | CC kande ID | 50, Capital Characters Only | |
TaxMatrix | Maksumaatriks | 0, Packed Matrix, base64 data | |
TaxTemplateCode | Maksumalli kood | 60, Capital Characters Only | |
ResUsage | Pakett | 10, Code String | |
MBRCode | Eestis ei kasutata, alati tühi | 10, Code String | |
ChequeNr | Tšeki number | 0, Value with No Decimals | |
CheckNr | Tšeki number | 20, Capital Characters Only | |
Points | Punkte | 0, Value 2 or 3 Decimals | |
SalesAssistant | Müügiassistent | 10, Code String | |
CCTimestamp | Eestis ei kasutata, alati tühi | 20, String | |
MotherArtCode | Eestis ei kasutata, alati tühi | 20, Code String | |
RecipeQuant | Retsepti kogus | 0, Value with minimum Decimals | |
OrdNr | Kliendi tellimuse number | 0, Value with No Decimals | |
IVNr | Kliendi ostuarve number | 0, Value with No Decimals | |
RetRow | Eestis ei kasutata, alati tühi | 0, Value with No Decimals | |
QTRow | Pakkumise rida | 0, Value with No Decimals | |
SHNr | Lähetuse number | 0, Value with No Decimals | |
SHRow | Lähetuse rida | 0, Value with No Decimals | |
CustArtCode | Kliendi artiklikood | 20, Code String | |
Salesmen | Müügimees | Müügimees | 60, Capital Characters Only |
CredOfficialSerNr | Eestis ei kasutata, alati tühi | 100, String | |
MotherNr | Peaseeria number | 60, String | |
AEStatus | E-arve staatus real | 544, Int represented by a Set of String | |
CustomsNr | Tolli number | 30, String | |
CountryOfOrg | Pärit riigist (2kohaline riigi kood) | 5, Code String | |
SecondarySerialNr | Teine seerianumber | 60, String | |
AlternateDeviceID | Eestis ei kasutata, alati tühi | 30, String | |
MotherSecondarySerialNr | Eestis ei kasutata, alati tühi | 60, String | |
MotherAlternateDeviceID | Eestis ei kasutata, alati tühi | 30, String | |
UnitComment | Ühiko kommentaar | 200, String |
Näidis XML päring
<?xml version="1.0" encoding="UTF-8"?>
<data register="IVVc" method="create" sequence="106357" systemversion="8.4.20.504">
<IVVc>
<SerNr>181004</SerNr>
<InvDate>2018.05.28</InvDate>
<CustCode>0012</CustCode>
<PayDate>2018.06.03</PayDate>
<Addr0>Audio Kaubad Eesti AS</Addr0>
<Addr1>Virsiku tee 12-8</Addr1>
<Addr2>Virsiku tee 12-8</Addr2>
<Addr3>Virsiku tee 12-8</Addr3>
<OurContact>Annika Ainus</OurContact>
<ClientContact>Kaupo Kallas</ClientContact>
<ExportFlag>0</ExportFlag>
<PayDeal>5</PayDeal>
<OrderNr />
<Prntdf>1</Prntdf>
<OKFlag>0</OKFlag>
<pdays>5</pdays>
<pdvrebt>0</pdvrebt>
<pdrdays>0</pdrdays>
<CustCat />
<pdComment />
<x1 />
<InvType>1</InvType>
<xStatFlag>0</xStatFlag>
<PriceList />
<Objects />
<InclVAT>0</InclVAT>
<ARAcc>1210</ARAcc>
<InvComment>komm komm komm komm komm komm komm</InvComment>
<CredInv>21</CredInv>
<CredMark />
<SalesMan>SVEN</SalesMan>
<ToRateB1 />
<TransDate>2018.05.28</TransDate>
<CurncyCode>EUR</CurncyCode>
<LangCode>EST</LangCode>
<UpdStockFlag>0</UpdStockFlag>
<LastRemndr>2</LastRemndr>
<LastRemDate>02.12.2023</LastRemDate>
<Sign>AA</Sign>
<FrPrice />
<FrBase />
<FrItem />
<FrVATCode>1</FrVATCode>
<FrObjects />
<OrgCust />
<FrGP>0,00</FrGP>
<FrGPPercent />
<Sum0>-0,01</Sum0>
<Sum1>15,59</Sum1>
<Sum2 />
<Sum3>3,12</Sum3>
<Sum4>18,70</Sum4>
<VATNr>EE100100101</VATNr>
<ShipDeal>CFR</ShipDeal>
<ShipAddr0>Lähetus 1</ShipAddr0>
<ShipAddr1>Lähetus 2</ShipAddr1>
<ShipAddr2>Lähetus 3</ShipAddr2>
<ShipAddr3>Lähetus 4</ShipAddr3>
<ShipMode>12</ShipMode>
<Location>PL</Location>
<PRCode />
<FrSalesAcc />
<TAX1Sum />
<CustVATCode />
<RebCode />
<CalcFinRef>122 70000 01027</CalcFinRef>
<Phone>5566 7700</Phone>
<Fax />
<IntCode>12</IntCode>
<ARonTR>0</ARonTR>
<CustOrdNr>klienditell001</CustOrdNr>
<ExportedFlag>0</ExportedFlag>
<BaseSum4>18,70</BaseSum4>
<FrRate />
<ToRateB2 />
<BaseRate1 />
<BaseRate2 />
<InvoiceNr />
<DiscPerc />
<DiscSum />
<TotGP>2,59</TotGP>
<LocOKNr />
<Invalid>0</Invalid>
<CreditCard />
<AuthorizationCode />
<RecValue />
<RetValue>-18,70</RetValue>
<FromBUQT>0</FromBUQT>
<Sorting>ROUTE1</Sorting>
<NoInterestFlag>0</NoInterestFlag>
<NoRemndrFlag>0</NoRemndrFlag>
<SVONr />
<InstallmentInv>0</InstallmentInv>
<OfficialSerNr>ametlikser001</OfficialSerNr>
<OfficialSerNr2>212</OfficialSerNr2>
<TotQty>1</TotQty>
<TotWeight>1</TotWeight>
<TotVolume>0,5</TotVolume>
<Commision>22,00</Commision>
<SumIncCom>18,70</SumIncCom>
<InvAddr3>Virsiku tee 12-8</InvAddr3>
<InvAddr4>Virsiku tee 12-8</InvAddr4>
<DelAddr3>Lähetus 5</DelAddr3>
<DelAddr4>Lähetus 6</DelAddr4>
<DelAddrCode />
<AutoGiro>0</AutoGiro>
<SalesGroup />
<DisputedFlag>0</DisputedFlag>
<NoColectionFlag>0</NoColectionFlag>
<QTNr />
<FiscalFlag />
<JobNr />
<RetnValue>-18,70</RetnValue>
<MachineName />
<TransTime>13:58:40</TransTime>
<DrawerCode />
<SiteX />
<colnr>Black</colnr>
<StatVal>12121,00</StatVal>
<EInvFunc>0</EInvFunc>
<EInvExpFlag>0</EInvExpFlag>
<EInvExpDate />
<EInvExpQty />
<ServiceDelDate>28.09.2016</ServiceDelDate>
<Region />
<RefStr>viide001</RefStr>
<TAX2Sum />
<pdvrebt2 />
<pdrdays2 />
<NoTax1>0</NoTax1>
<NoTax2>0</NoTax2>
<FreightCode />
<BankCode />
<InvalidDate />
<InvalidLocOKNr />
<NoEInvoice>0</NoEInvoice>
<TaxAuthID />
<TaxAuthIDCC />
<BranchID />
<Status>-</Status>
<NoTAXonVAT>0</NoTAXonVAT>
<TotalwoTAX>0</TotalwoTAX>
<CredManNr />
<RegDate>28.05.2018</RegDate>
<RegTime>13:52:04</RegTime>
<COCUSerNr />
<CAE />
<CAEExpiry />
<VINr />
<TerminalID />
<OrderType>Normal</OrderType>
<FiscalDeviceSeqNr />
<CCTransID />
<AcceptanceStatus>0</AcceptanceStatus>
<TaxMatrix />
<CustTaxTemplateCode />
<RoyaltyIVFlag>0</RoyaltyIVFlag>
<LoyaltyCardNr />
<LCMLevel />
<Points />
<DepCode />
<SelfBilling>0</SelfBilling>
<Hash />
<HashKeyVersion>0</HashKeyVersion>
<InvCountry>EE</InvCountry>
<DelCountry>EE</DelCountry>
<TREONr />
<ORCONr />
<CAEAStartDate />
<CAEAExpiryDate />
<CAEAFlag>0</CAEAFlag>
<FInvExpFlag>0</FInvExpFlag>
<GroupInv>0</GroupInv>
<Suspended>0</Suspended>
<AcceptanceBy />
<RetNr />
<TaxAdminServSignatureTimeStamp />
<TaxAdminServCertificateNr />
<TaxAdminServSeal />
<CredOfficialSerNr />
<AcceptanceFYI />
<PMCode />
<PayAccNo />
<BrazilEInvType />
<TaxAdminReceiptNr />
<TaxAuthReceiptDate />
<TaxAuthReceiptTime />
<ReceiptInfo />
<InvalidTime />
<OKBy />
<PlanSendDate>05.10.2016</PlanSendDate>
<PlanSendTime>13:53:23</PlanSendTime>
<PlanArrDate>05.10.2016</PlanArrDate>
<PlanArrTime>13:55:27</PlanArrTime>
<FedServCode />
<InvalidBy />
<Reason />
<InvCountryName>EE</InvCountryName>
<DelCountryName>EE</DelCountryName>
<OfficialSerNrSerie />
<OfficialSerNr2Serie />
<IPBookVAT>0</IPBookVAT>
<ThirdPartyBillMark>0</ThirdPartyBillMark>
<RecipientGLN />
<DelRecipientGLN />
<IntrastatTransCode>INTRAST</IntrastatTransCode>
<GlobalTransportNr>GLOB01</GlobalTransportNr>
<GlobalTransportDate>21.09.2016</GlobalTransportDate>
<DeliverySiteCode />
<PrintDate />
<WorkSiteNumber />
<GPProc>16,6</GPProc>
<rows>
<row rownumber="0">
<stp>1</stp>
<ArtCode>TEST</ArtCode>
<Quant>1</Quant>
<Price>15,59</Price>
<Sum>15,59</Sum>
<vRebate />
<SalesAcc>3100</SalesAcc>
<Objects>ANNIKA,KAUPO,KONT</Objects>
<OrdRow />
<BasePrice>13,00</BasePrice>
<rowGP>2,59</rowGP>
<FIFO />
<Spec>Raadio "Multi"</Spec>
<VATCode>1</VATCode>
<Recepy />
<SerialNr />
<PriceFactor />
<VARList />
<CUPNr />
<FIFORowVal />
<Coefficient>1,00</Coefficient>
<CuAccCode />
<ExciseNr />
<PeriodCode />
<UnitCode>TK</UnitCode>
<UnitFactQuant />
<UnitFactPrice />
<UnitXval>11</UnitXval>
<UnitYval>12</UnitYval>
<UnitZval>13</UnitZval>
<VECode />
<CreditCard />
<AuthorizationCode />
<PosCode />
<CurncyCode />
<FrRate />
<ToRateB1 />
<ToRateB2 />
<BaseRate1 />
<BaseRate2 />
<PayMode />
<GCNr />
<CustOrdNr />
<RepaExVAT />
<BasePriceB2 />
<TAX2Code />
<TAX2Prc />
<TAX2Reb />
<TAX1Reb />
<TAX2Acc />
<CreditedRow />
<NotUpdStockFlag>0</NotUpdStockFlag>
<CUServiceHistNr />
<CUServiceUntilDate />
<ServiceDelDate />
<Location>PL</Location>
<Comment />
<DiscApprovedBy />
<Perceptions>0</Perceptions>
<VoidedRowNr />
<VoidedSign />
<ovst>0</ovst>
<Withholdings>0</Withholdings>
<WHTax />
<CCTransID />
<TaxMatrix />
<TaxTemplateCode />
<ResUsage />
<MBRCode />
<ChequeNr />
<CheckNr />
<Points />
<SalesAssistant />
<CCTimestamp />
<MotherArtCode />
<RecipeQuant />
<OrdNr />
<IVNr />
<RetRow />
<QTRow />
<SHNr />
<SHRow />
<CustArtCode>KLIARTNT</CustArtCode>
<Salesmen>AA</Salesmen>
<CredOfficialSerNr />
<MotherNr />
<AEStatus>Not Sent</AEStatus>
<CustomsNr>tollnr001</CustomsNr>
<CountryOfOrg>AU</CountryOfOrg>
<SecondarySerialNr />
<AlternateDeviceID />
<MotherSecondarySerialNr />
<MotherAlternateDeviceID />
<UnitComment>tükk</UnitComment>
</row>
<row rownumber="1">
<stp>1</stp>
<ArtCode>TEST</ArtCode>
<Quant>1</Quant>
<Price>15,59</Price>
<Sum>15,59</Sum>
<vRebate />
<SalesAcc>3100</SalesAcc>
<Objects>ANNIKA,KAUPO,KONT</Objects>
<OrdRow />
<BasePrice>13,00</BasePrice>
<rowGP>2,59</rowGP>
<FIFO />
<Spec>Raadio "Multi"</Spec>
<VATCode>1</VATCode>
<Recepy />
<SerialNr />
<PriceFactor />
<VARList />
<CUPNr />
<FIFORowVal />
<Coefficient>1,00</Coefficient>
<CuAccCode />
<ExciseNr />
<PeriodCode />
<UnitCode>TK</UnitCode>
<UnitFactQuant />
<UnitFactPrice />
<UnitXval>11</UnitXval>
<UnitYval>12</UnitYval>
<UnitZval>13</UnitZval>
<VECode />
<CreditCard />
<AuthorizationCode />
<PosCode />
<CurncyCode />
<FrRate />
<ToRateB1 />
<ToRateB2 />
<BaseRate1 />
<BaseRate2 />
<PayMode />
<GCNr />
<CustOrdNr />
<RepaExVAT />
<BasePriceB2 />
<TAX2Code />
<TAX2Prc />
<TAX2Reb />
<TAX1Reb />
<TAX2Acc />
<CreditedRow />
<NotUpdStockFlag>0</NotUpdStockFlag>
<CUServiceHistNr />
<CUServiceUntilDate />
<ServiceDelDate />
<Location>PL</Location>
<Comment />
<DiscApprovedBy />
<Perceptions>0</Perceptions>
<VoidedRowNr />
<VoidedSign />
<ovst>0</ovst>
<Withholdings>0</Withholdings>
<WHTax />
<CCTransID />
<TaxMatrix />
<TaxTemplateCode />
<ResUsage />
<MBRCode />
<ChequeNr />
<CheckNr />
<Points />
<SalesAssistant />
<CCTimestamp />
<MotherArtCode />
<RecipeQuant />
<OrdNr />
<IVNr />
<RetRow />
<QTRow />
<SHNr />
<SHRow />
<CustArtCode>KLIARTNT</CustArtCode>
<Salesmen>AA</Salesmen>
<CredOfficialSerNr />
<MotherNr />
<AEStatus>Not Sent</AEStatus>
<CustomsNr>tollnr001</CustomsNr>
<CountryOfOrg>AU</CountryOfOrg>
<SecondarySerialNr />
<AlternateDeviceID />
<MotherSecondarySerialNr />
<MotherAlternateDeviceID />
<UnitComment>tükk</UnitComment>
</row>
</rows>
</IVVc>
</data>