Hausing - Register Arved: erinevus redaktsioonide vahel
Mine navigeerimisribale
Mine otsikasti
Resümee puudub |
|||
| 1340. rida: | 1340. rida: | ||
=== Näidis XML päring === | === Näidis XML päring === | ||
<syntaxhighlight lang="xml" line="1"> | <syntaxhighlight lang="xml" line="1"> | ||
<?xml version= | <?xml version="1.0" encoding="UTF-8"?> | ||
<data | <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> | |||
</rows> | |||
</IVVc> | |||
</data> | </data> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Redaktsioon: 24. mai 2018, kell 09:47
Kohustuslikud väljad
| Kood | Kirjeldus | Pikkus, tüüp | Kommentaar |
| InvDate | Arve kuupäev | 0, In Dataformat Order | Will connect the outer system invoice number with Hansa serial number |
| TransDate | Kande kp. | 0, In Dataformat Order | |
| CustCode | Kliendi kood | 20, Code String | Hansa internal customer code, must be created in advance |
| Sum1 | Neto summa | 0, Value 2 or 3 Decimals | Hansa sum without VAT |
| Sum3 | Käibemaksu summa | 0, Value 2 or 3 Decimals | Hansa VAT sum |
| Sum4 | Kokku | 0, Value 2 or 3 Decimals | Hansa sum with VAT |
| InvType | Arve tüüp (Tavaline, kreedit jne. 1=tavaline) | 0, Small Value with No Decimals | |
| PayDeal | Tasumistingimuse kood | 2, Code String | |
| Rows: | |||
| 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 | Artiklikood | 20, Code String | Hansa internal article code, must be created in advance |
| Quant | Kogus | 0, Value with minimum Decimals | |
| Price | Hind | 0, Value with 2 or 3 Decimals | |
| Sum | Kokku | 0, Value 2 or 3 Decimals | |
| VATCode | KM kood | 10, Code String |
Minimaalse XML päringu näide
<?xml version="1.0" encoding="UTF-8"?>
<data register="IVVc" sequence="106357" systemversion="8.4.20.504">
<IVVc>
<RefStr>1289</RefStr>
<CustCode>101</CustCode>
<Sum1>100</Sum1>
<Sum3>20</Sum3>
<Sum4>120</Sum4>
<OKFlag>0</OKFlag>
<rows>
<row rownumber="0"><!-- required, number defines the row in Hansa, starts with 0 -->
<stp>1</stp>
<ArtCode>001</ArtCode>
</row>
</rows>
</IVVc>
</data>
Kõigi XML väljade kirjeldused
| Kood | Kirjeldus | Pikkus, tüüp |
|---|---|---|
| SerNr | Arve number | 0, Value with No Decimals |
| InvDate | Arve kuupäev | 0, In Dataformat Order |
| CustCode | Kliendi kood | 20, Code String |
| PayDate | Maksetähtaeg | 0, In Dataformat Order |
| Addr0 | Arve saaja aadressi 1. rida | 60, String |
| Addr1 | 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, arve koostaja | 20, String |
| ClientContact | 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 | Tasumistingimuse kood | 2, Code String |
| OrderNr | Tellimuse nr (millest arve on koostatud) | 0, Value with No Decimals |
| Prntdf | Saadetud. 0=ei, 1=jah | 0, Small Value with No Decimals |
| OKFlag | 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 | 5, Code String |
| Objects | 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 | Arve kommentaar | 200, String |
| CredInv | Kreediteeritava arve nr | 0, Value with No Decimals |
| CredMark | Kreeditarve (0=ei; 1=jah) | 1, String |
| SalesMan | Meie esindaja | 60, Capital Characters Only |
| ToRateB1 | Kurss B1 suhtes | 0, Value with 6 Decimals |
| TransDate | Kande kuupäev | 0, In Dataformat Order |
| CurncyCode | Valuuta | 5, Code String |
| LangCode | Keel | 5, Code String |
| UpdStockFlag | Muuda ladu (0=ei; 1=jah) | 0, Small Value with No Decimals |
| LastRemndr | Märgukirjatase | 0, Value with No Decimals |
| LastRemDate | Viimase märgukirja kuupäev | 0, In Dataformat Order |
| Sign | 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 | 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 | Neto summa | 0, Value 2 or 3 Decimals |
| Sum2 | Kokku (Eestis tühi) | 0, Value 2 or 3 Decimals |
| Sum3 | Käibemaksu summa | 0, Value 2 or 3 Decimals |
| Sum4 | Kokku | 0, Value 2 or 3 Decimals |
| VATNr | Kliendi KMKR number | 20, String |
| ShipDeal | Lähetustingimus | 5, Code String |
| ShipAddr0 | Lähetusaadressi 1. rida | 60, String |
| ShipAddr1 | Lähetusaadressi 2. rida | 60, String |
| ShipAddr2 | Lähetusaadressi 3. rida | 60, String |
| ShipAddr3 | Lähetusaadressi 4. rida | 60, String |
| ShipMode | Lähetusviis | 5, Code String |
| Location | Ladu | 10, Code String |
| PRCode | 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 | 30, String |
| Phone | Telefon (kliendi) | 20, String with phone-number |
| Fax | Faks (kliendi) | 20, String |
| IntCode | Viivis | 10, String |
| ARonTR | 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 | Summa | 0, Value 2 or 3 Decimals |
| FrRate | Kurss B1-te | 0, Value with 6 Decimals |
| ToRateB2 | Kurss B2-te | 0, Value with 6 Decimals |
| BaseRate1 | B1 kurss | 0, Value with 6 Decimals |
| BaseRate2 | 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 (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 | 20, String |
| NoInterestFlag | Ära arvesta viivist (0=ei; 1=jah) | 0, Small Value with No Decimals |
| NoRemndrFlag | Ä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 seerianumber | 100, String |
| OfficialSerNr2 | Ametlik seerianumber 2 | 100, String |
| TotQty | Kokku kogus | 0, Value with minimum Decimals |
| TotWeight | Kokku kaal | 0, Value with minimum Decimals |
| TotVolume | Maht kokku | 0, Value with minimum Decimals |
| Commision | Teenustasu | 0, Value 2 or 3 Decimals |
| SumIncCom | 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 | Lähetusaadressi kood | 20, Code String |
| AutoGiro | Ei kasutata, alati tühi | 0, Small Value with No Decimals |
| SalesGroup | Müügigrupp | 30, Capital Characters Only |
| DisputedFlag | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | Planeeritud lähetuse kuupäev | 0, In Dataformat Order |
| PlanSendTime | Planeeritud saatmise kellaaeg | 0, Hour:Min:Secs |
| PlanArrDate | Planeeritud saabumise kuupäev | 0, In Dataformat Order |
| PlanArrTime | 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 | 20, Code String |
| GlobalTransportNr | Globaalne transpordinumber | 30, Capital Characters Only |
| GlobalTransportDate | Globaalne transpordikuupäev | 0, In Dataformat Order |
| DeliverySiteCode | Lähetusaadressi kood | 60, String |
| PrintDate | Printimise kuupäev | 60, String |
| WorkSiteNumber | Asukoha number | 60, String |
| GPProc | GP protsent | 0, Value with One Decimal |
| Rows: | ||
| ArtCode | Artiklikood | 20, Code String |
| Quant | Kogus | 0, Value with minimum Decimals |
| Price | Hind | 0, Value with 2 or 3 Decimals |
| Sum | Kokku | 0, Value 2 or 3 Decimals |
| vRebate | Allahindlusprotsent | 0, Value with One Decimal |
| SalesAcc | Müügi konto | 10, Code String |
| Objects | Objekt(id) | 60, Capital Characters Only |
| OrdRow | Tellimuse read | 0, Value with No Decimals |
| BasePrice | Baashind | 0, Value 2 or 3 Decimals |
| rowGP | Rea müügikate | 0, Value 2 or 3 Decimals |
| FIFO | FIFO hind | 0, Value with All Decimals |
| Spec | Kirjeldus | 100, String |
| VATCode | KM kood | 10, Code String |
| Recepy | Retsept | 20, Code String |
| SerialNr | Seerianumber | 60, String |
| PriceFactor | Hinna faktor | 0, Value with All Decimals |
| VARList | VAR | 30, Capital Characters Only |
| CUPNr | Ettemaksu | 0, Value with No Decimals |
| FIFORowVal | Rea fifo | 0, Value with All Decimals |
| Coefficient | Koefitsent | 0, Value with All Decimals |
| CuAccCode | Kliendi konto? | 20, Code String |
| ExciseNr | Aktsiis | 20, String |
| PeriodCode | Periodiseerimise mudel | 10, Code String |
| UnitCode | Ühiku kood | 5, Code String |
| UnitFactQuant | Ühiku kogus | 0, Value with minimum Decimals |
| UnitFactPrice | Ühiku hind | 0, Value with 2 or 3 Decimals |
| UnitXval | Laius | 0, Value with minimum Decimals |
| UnitYval | Kõrgus | 0, Value with minimum Decimals |
| UnitZval | 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 | 0, Value 2 or 3 Decimals |
| BasePriceB2 | 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 | 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 | 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>
</rows>
</IVVc>
</data>