Hausing - Register Laekumised: erinevus redaktsioonide vahel
(→Päis) |
|||
(ei näidata 4 kasutaja 14 vahepealset redaktsiooni) | |||
1. rida: | 1. rida: | ||
<blockquote>[[Hausing|Hausing - Pealeht]]</blockquote> | <blockquote>[[Hausing|Hausing - Pealeht]]</blockquote> | ||
== | == Register == | ||
<nowiki><data> element peab sisaldama:</nowiki> | |||
*register="'''IPVc'''" | |||
[[Pilt:Laekumised hausing.png|raamita|522x522px]] | |||
== Toetatud väljad == | |||
=== Päis === | |||
{| class="wikitable" | {| class="wikitable" | ||
!Field Name | !Field Name | ||
|'''Kasutajaliidese nimi''' | |||
!Description | !Description | ||
!Kirjeldus | !Kirjeldus | ||
!Kohustuslik | |||
!Field type | !Field type | ||
!Max Length | !Max Length | ||
!Kommentaar | |||
|- | |- | ||
| | |Comment | ||
| | |Kommentaar | ||
| | |String | ||
| | |kirjeldus | ||
| | | | ||
|M4Str | |||
|60 | |||
| | |||
|- | |- | ||
|PayMode | |PayMode | ||
|Tasumisviis | |||
|Code String | |Code String | ||
|Tasumisviis | |Tasumisviis | ||
| + | |||
|M4Code | |M4Code | ||
|2 | |2 | ||
| | |||
|- | |- | ||
| | |PayCurCode | ||
|Valuuta | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|Valuuta | |Valuuta | ||
| | |||
|M4Val | |M4Val | ||
|0 | |0 | ||
|Kui on antud, kirjutab üle kõikide ridade valuutad | |||
|- | |- | ||
|TransDate | |TransDate | ||
|Kande kp. | |||
|In Dataformat Order | |In Dataformat Order | ||
|kande kuupäev | |kande kuupäev | ||
| | |||
|M4Date | |M4Date | ||
|0 | |0 | ||
|Kui puudub siis tänane kuupäev. | |||
NB! Peab sobima arvele, ehk ei tohi arvest varasemat kuupäeva sisestada. | |||
|- | |- | ||
| | |OKFlag | ||
| | |Kinnita | ||
| | |Small Value with No Decimals | ||
| | |Kinnitatud linnuke | ||
| + | |||
|M4Int | |||
|0 | |||
| | | | ||
|} | |||
=== Maatriks === | |||
{| class="wikitable" | |||
!Field Name | |||
|'''Kasutajaliidese nimi''' | |||
!Description | |||
!Kirjeldus | |||
!Kohustuslik | |||
!Field type | |||
!Max Length | |||
!Kommentaar | |||
|- | |- | ||
|stp | |stp | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
|Rea tüüp: | |Rea tüüp: | ||
47. rida: | 86. rida: | ||
3 = parandusmärk | 3 = parandusmärk | ||
|<nowiki>+</nowiki> | |||
|M4Int | |M4Int | ||
|0 | |0 | ||
|Hetkel ainult 1 = tavaline on toetatud | |||
|- | |- | ||
|ovst | |ovst | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
|Tühistatud rida jah/ei | |Tühistatud rida jah=1/ei=0 | ||
| | |||
|M4Int | |M4Int | ||
|0 | |0 | ||
|Ei ole kohustuslik, vaikimisi alati 0 | |||
|- | |- | ||
|InvoiceNr | |InvoiceNr | ||
|Arve nr. | |||
|Value with No Decimals | |Value with No Decimals | ||
|Arve nr | |Arve nr | ||
| + | |||
|M4Long | |M4Long | ||
|0 | |0 | ||
|Peab olema täidetud siis kui puudub Ettemaksu nr. ja vastupidi. | |||
|- | |- | ||
|PayDate | |PayDate | ||
|Tasumise kp. | |||
|In Dataformat Order | |In Dataformat Order | ||
|Laekumise kuupäev | |Laekumise kuupäev | ||
| | |||
|M4Date | |M4Date | ||
|0 | |0 | ||
| | |||
|- | |- | ||
|CustCode | |CustCode | ||
|Klient | |||
|Code String | |Code String | ||
|kliendikood | |kliendikood | ||
| + | |||
|M4Code | |M4Code | ||
|20 | |20 | ||
|Peab vastama antud arvele. | |||
|- | |||
|RecVal | |||
|Saadud summa | |||
|Value 2 or 3 Decimals | |||
|Saadud summa | |||
| | |||
|M4Val | |||
|0 | |||
|Kui puudub, võetakse arve kogu summa. Ridade asetamisel arvutatakse ka Laekumise "Kokku" summat automaatselt. | |||
|- | |||
|CUPNr | |||
|Ettemaksu nr. | |||
|Value with No Decimals | |||
|Ettemaksu nr | |||
| | |||
|M4Long | |||
| | |||
|Peab olema täidetud siis kui puudub Arve nr. ja vastupidi. | |||
|- | |||
|VATCode | |||
|KM-k | |||
|Code String | |||
|Käibemaksukood | |||
| | |||
|M4Code | |||
| | |||
|Peab olema täidetud siis kui antud Ettemaksu nr. | |||
|} | |} | ||
=== | === Näidis XML päring === | ||
<syntaxhighlight lang="xml"> | <syntaxhighlight lang="xml" line="1"> | ||
<?xml version="1.0" encoding="UTF-8"?> | <?xml version="1.0" encoding="UTF-8"?> | ||
<data register="IPVc" sequence=" | <data register="IPVc" method="create" sequence="106357" systemversion="8.4.20.504"> | ||
<IPVc> | |||
<PayMode>P</PayMode> | |||
<OKFlag>0</OKFlag> | |||
<Comment>This is comment</Comment> | |||
<PayCurCode>USD</PayCurCode> | |||
<rows> | |||
<row rownumber="0"> | |||
<stp>1</stp> | |||
<ovst>0</ovst> | |||
<InvoiceNr>180010</InvoiceNr> | |||
<CustCode>101</CustCode> | |||
<RecVal>20</RecVal> | |||
<PayDate>2018-08-17</PayDate> | |||
</row> | |||
</rows> | |||
</IPVc> | |||
</data> | </data> | ||
100. rida: | 181. rida: | ||
== Kõigi XML väljade kirjeldused == | == Kõigi XML väljade kirjeldused == | ||
=== Päis === | === Päis ''(Header)'' === | ||
{| class="wikitable" | {| class="wikitable" | ||
!Field Name | !Field Name | ||
|'''Kasutajaliidese nimi''' | |||
!Description | !Description | ||
!Kirjeldus | !Kirjeldus | ||
109. rida: | 191. rida: | ||
|- | |- | ||
|SerNr | |SerNr | ||
|Nr. | |||
|Value with No Decimals | |Value with No Decimals | ||
|Kande number | |Kande number | ||
115. rida: | 198. rida: | ||
|- | |- | ||
|Comment | |Comment | ||
|Kommentaar | |||
|String | |String | ||
|kirjeldus | |kirjeldus | ||
121. rida: | 205. rida: | ||
|- | |- | ||
|PayMode | |PayMode | ||
|Tasumisviis | |||
|Code String | |Code String | ||
|Tasumisviis | |Tasumisviis | ||
127. rida: | 212. rida: | ||
|- | |- | ||
|OKFlag | |OKFlag | ||
|Kinnita | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
|Kinnitatud linnuke | |Kinnitatud linnuke | ||
133. rida: | 219. rida: | ||
|- | |- | ||
|CurPayVal | |CurPayVal | ||
|Valuuta | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|Valuuta | |Valuuta | ||
139. rida: | 226. rida: | ||
|- | |- | ||
|RegDate | |RegDate | ||
|Kande kp. | |||
|In Dataformat Order | |In Dataformat Order | ||
|Kande kuupäev | |Kande kuupäev | ||
145. rida: | 233. rida: | ||
|- | |- | ||
|OKMark | |OKMark | ||
| | |||
|As Bool but displayed as a Checkbox | |As Bool but displayed as a Checkbox | ||
|Sirvi akna kinnituse märk | |Sirvi akna kinnituse märk | ||
151. rida: | 240. rida: | ||
|- | |- | ||
|TransDate | |TransDate | ||
|Kande kuupäev | |||
|In Dataformat Order | |In Dataformat Order | ||
|kande kuupäev | |kande kuupäev | ||
157. rida: | 247. rida: | ||
|- | |- | ||
|Sign | |Sign | ||
| | |||
|Code String | |Code String | ||
|isik | |isik | ||
163. rida: | 254. rida: | ||
|- | |- | ||
|ARonTR | |ARonTR | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
| | | | ||
169. rida: | 261. rida: | ||
|- | |- | ||
|ExportedFlag | |ExportedFlag | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
|eksporditud | |eksporditud | ||
175. rida: | 268. rida: | ||
|- | |- | ||
|ReceivedFlag | |ReceivedFlag | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
|n/a | |n/a | ||
181. rida: | 275. rida: | ||
|- | |- | ||
|RejectedFlag | |RejectedFlag | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
|n/a | |n/a | ||
187. rida: | 282. rida: | ||
|- | |- | ||
|RecNumber | |RecNumber | ||
| | |||
|String | |String | ||
| | | | ||
193. rida: | 289. rida: | ||
|- | |- | ||
|Invalid | |Invalid | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
|tühistatud | |tühistatud | ||
199. rida: | 296. rida: | ||
|- | |- | ||
|PayCurCode | |PayCurCode | ||
| | |||
|Code String | |Code String | ||
|valuuta | |valuuta | ||
205. rida: | 303. rida: | ||
|- | |- | ||
|Objects | |Objects | ||
| | |||
|Capital Characters Only | |Capital Characters Only | ||
|objektid | |objektid | ||
211. rida: | 310. rida: | ||
|- | |- | ||
|Prntdf | |Prntdf | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
| | | | ||
217. rida: | 317. rida: | ||
|- | |- | ||
|AuthorizationCode | |AuthorizationCode | ||
| | |||
|Capital Characters Only | |Capital Characters Only | ||
|n/a | |n/a | ||
223. rida: | 324. rida: | ||
|- | |- | ||
|MachineName | |MachineName | ||
| | |||
|Code String | |Code String | ||
|n/a | |n/a | ||
229. rida: | 331. rida: | ||
|- | |- | ||
|DrawerCode | |DrawerCode | ||
| | |||
|Code String | |Code String | ||
|n/a | |n/a | ||
235. rida: | 338. rida: | ||
|- | |- | ||
|RegTime | |RegTime | ||
| | |||
|Hour:Min:Secs | |Hour:Min:Secs | ||
|salvestamise kellaaeg | |salvestamise kellaaeg | ||
241. rida: | 345. rida: | ||
|- | |- | ||
|IPBookVAT | |IPBookVAT | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
| | | | ||
247. rida: | 352. rida: | ||
|- | |- | ||
|OfficialSerNr | |OfficialSerNr | ||
| | |||
|String | |String | ||
|ametlik numbriseeria | |ametlik numbriseeria | ||
253. rida: | 359. rida: | ||
|- | |- | ||
|OfficialSerNr2 | |OfficialSerNr2 | ||
| | |||
|String | |String | ||
|ametlik numbriseeria | |ametlik numbriseeria | ||
259. rida: | 366. rida: | ||
|- | |- | ||
|Status | |Status | ||
| | |||
|Int represented by a Set of String | |Int represented by a Set of String | ||
|hetkeseis | |hetkeseis | ||
265. rida: | 373. rida: | ||
|- | |- | ||
|BranchID | |BranchID | ||
| | |||
|Code String | |Code String | ||
|n/a | |n/a | ||
271. rida: | 380. rida: | ||
|- | |- | ||
|TerminalID | |TerminalID | ||
| | |||
|String | |String | ||
|n/a | |n/a | ||
277. rida: | 387. rida: | ||
|- | |- | ||
|OfficialSerNrSerie | |OfficialSerNrSerie | ||
| | |||
|String | |String | ||
|ametliku numbri numbriseeria | |ametliku numbri numbriseeria | ||
283. rida: | 394. rida: | ||
|} | |} | ||
=== Maatriks === | === Maatriks ''(Rows)'' === | ||
{| class="wikitable" | {| class="wikitable" | ||
!Field Name | !Field Name | ||
|'''Kasutajaliidese nimi''' | |||
!Description | !Description | ||
!Kirjeldus | !Kirjeldus | ||
292. rida: | 404. rida: | ||
|- | |- | ||
|stp | |stp | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
|Rea tüüp: | |Rea tüüp: | ||
303. rida: | 416. rida: | ||
|- | |- | ||
|ovst | |ovst | ||
| | |||
|Small Value with No Decimals | |Small Value with No Decimals | ||
|Tühistatud rida jah/ei | |Tühistatud rida jah/ei | ||
309. rida: | 423. rida: | ||
|- | |- | ||
|InvoiceNr | |InvoiceNr | ||
|Arve nr. | |||
|Value with No Decimals | |Value with No Decimals | ||
|Arve nr | |Arve nr | ||
315. rida: | 430. rida: | ||
|- | |- | ||
|PayDate | |PayDate | ||
|Tasumise kp. | |||
|In Dataformat Order | |In Dataformat Order | ||
|Laekumise kuupäev | |Laekumise kuupäev | ||
321. rida: | 437. rida: | ||
|- | |- | ||
|CustCode | |CustCode | ||
|Klient | |||
|Code String | |Code String | ||
|kliendikood | |kliendikood | ||
327. rida: | 444. rida: | ||
|- | |- | ||
|latedays | |latedays | ||
| | |||
|Value with No Decimals | |Value with No Decimals | ||
|hilinenud päevi | |hilinenud päevi | ||
333. rida: | 451. rida: | ||
|- | |- | ||
|CustName | |CustName | ||
|Tekst | |||
|String | |String | ||
|kliendi nimi | |kliendi nimi | ||
339. rida: | 458. rida: | ||
|- | |- | ||
|CUPNr | |CUPNr | ||
|Ettemaksu number | |||
|Value with No Decimals | |Value with No Decimals | ||
| | |Ettemaksu number | ||
|M4Long | |M4Long | ||
|0 | |0 | ||
|- | |- | ||
|ChequeNr | |ChequeNr | ||
|Tsheki number | |||
|Value with No Decimals | |Value with No Decimals | ||
| | |Tsheki number | ||
|M4Long | |M4Long | ||
|0 | |0 | ||
|- | |- | ||
|VATVal | |VATVal | ||
| | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|KM valuuta | |KM valuuta | ||
357. rida: | 479. rida: | ||
|- | |- | ||
|VATCode | |VATCode | ||
|KM-k | |||
|Code String | |Code String | ||
|KM kood | |KM kood | ||
363. rida: | 486. rida: | ||
|- | |- | ||
|InvOutstand | |InvOutstand | ||
|Tasumata summa | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|Arve tasumata summa | |Arve tasumata summa | ||
369. rida: | 493. rida: | ||
|- | |- | ||
|InvCurncy | |InvCurncy | ||
|A.val | |||
|Code String | |Code String | ||
|Arve valuuta | |Arve valuuta | ||
375. rida: | 500. rida: | ||
|- | |- | ||
|InvVal | |InvVal | ||
|Arve summa | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|Arve summa | |Arve summa | ||
381. rida: | 507. rida: | ||
|- | |- | ||
|PayMode | |PayMode | ||
|Tas. viis | |||
|Code String | |Code String | ||
|Tasumisviis | |Tasumisviis | ||
387. rida: | 514. rida: | ||
|- | |- | ||
|BankCurncy | |BankCurncy | ||
|P. val. | |||
|Code String | |Code String | ||
|Panga valuuta | |Panga valuuta | ||
393. rida: | 521. rida: | ||
|- | |- | ||
|BankVal | |BankVal | ||
|Panga sum. | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|Panga summa | |Panga summa | ||
399. rida: | 528. rida: | ||
|- | |- | ||
|RecCurncy | |RecCurncy | ||
|S.val | |||
|Code String | |Code String | ||
|Saadud valuuta | |Saadud valuuta | ||
405. rida: | 535. rida: | ||
|- | |- | ||
|RecVal | |RecVal | ||
|Saadud summa | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|Saadud summa | |Saadud summa | ||
411. rida: | 542. rida: | ||
|- | |- | ||
|BankFeeVal | |BankFeeVal | ||
| | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|Panga teenustasu valuuta | |Panga teenustasu valuuta | ||
417. rida: | 549. rida: | ||
|- | |- | ||
|RoundOff | |RoundOff | ||
| | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|ümardamine | |ümardamine | ||
423. rida: | 556. rida: | ||
|- | |- | ||
|RoundOffAcc | |RoundOffAcc | ||
| | |||
|Code String | |Code String | ||
|Ümardamise konto | |Ümardamise konto | ||
429. rida: | 563. rida: | ||
|- | |- | ||
|Objects | |Objects | ||
|Objektid | |||
|Capital Characters Only | |Capital Characters Only | ||
|objektid | |objektid | ||
435. rida: | 570. rida: | ||
|- | |- | ||
|Coef | |Coef | ||
| | |||
|Value with 6 Decimals | |Value with 6 Decimals | ||
|n/a | |n/a | ||
441. rida: | 577. rida: | ||
|- | |- | ||
|BankFeePrc | |BankFeePrc | ||
| | |||
| | | | ||
|n/a | |n/a | ||
447. rida: | 584. rida: | ||
|- | |- | ||
|TAX1Sum | |TAX1Sum | ||
| | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
| | | | ||
453. rida: | 591. rida: | ||
|- | |- | ||
|OrderNr | |OrderNr | ||
|Tellimuse nr. | |||
|Value with No Decimals | |Value with No Decimals | ||
|tellimuse nr | |tellimuse nr | ||
459. rida: | 598. rida: | ||
|- | |- | ||
|Comment | |Comment | ||
| | |||
|String | |String | ||
|kirjeldus | |kirjeldus | ||
465. rida: | 605. rida: | ||
|- | |- | ||
|B1BankVal | |B1BankVal | ||
|Panga summa BV 1 | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|baasvaluuta 1 summa | |baasvaluuta 1 summa | ||
471. rida: | 612. rida: | ||
|- | |- | ||
|B2BankVal | |B2BankVal | ||
|Panga summa BV 2 | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
|baasvaluuta 2 summa | |baasvaluuta 2 summa | ||
477. rida: | 619. rida: | ||
|- | |- | ||
|ToRateB1BankVal | |ToRateB1BankVal | ||
|Baaskurss 1 | |||
|Value with 6 Decimals | |Value with 6 Decimals | ||
|baasvaluuta kurss | |baasvaluuta kurss | ||
483. rida: | 626. rida: | ||
|- | |- | ||
|ToRateB2BankVal | |ToRateB2BankVal | ||
|Baaskurss 2 | |||
|Value with 6 Decimals | |Value with 6 Decimals | ||
|baasvaluuta kurss | |baasvaluuta kurss | ||
489. rida: | 633. rida: | ||
|- | |- | ||
|rkRecNumber | |rkRecNumber | ||
| | |||
|String | |String | ||
|riigikassa | |riigikassa | ||
495. rida: | 640. rida: | ||
|- | |- | ||
|ARAcc | |ARAcc | ||
| | |||
|Code String | |Code String | ||
| | | | ||
501. rida: | 647. rida: | ||
|- | |- | ||
|TAX2Prc | |TAX2Prc | ||
| | |||
|Value with 2 or 3 Decimals | |Value with 2 or 3 Decimals | ||
| | | | ||
507. rida: | 654. rida: | ||
|- | |- | ||
|CredManNr | |CredManNr | ||
| | |||
|Value with No Decimals | |Value with No Decimals | ||
| | | | ||
513. rida: | 661. rida: | ||
|- | |- | ||
|SuggestVal | |SuggestVal | ||
| | |||
|Value 2 or 3 Decimals | |Value 2 or 3 Decimals | ||
| | | | ||
519. rida: | 668. rida: | ||
|- | |- | ||
|InstNr | |InstNr | ||
| | |||
|Value with No Decimals | |Value with No Decimals | ||
| | | | ||
525. rida: | 675. rida: | ||
|- | |- | ||
|WriteOffAcc | |WriteOffAcc | ||
| | |||
|Code String | |Code String | ||
|lootusetult laekuvate arvete konto | |lootusetult laekuvate arvete konto | ||
531. rida: | 682. rida: | ||
|- | |- | ||
|FrRateBankVal | |FrRateBankVal | ||
| | |||
|Value with 6 Decimals | |Value with 6 Decimals | ||
| | | | ||
537. rida: | 689. rida: | ||
|- | |- | ||
|BaseRate1BankVal | |BaseRate1BankVal | ||
|BV-e 1 | |||
|Value with 6 Decimals | |Value with 6 Decimals | ||
|baasvaluuta summa | |baasvaluuta summa | ||
543. rida: | 696. rida: | ||
|- | |- | ||
|BaseRate2BankVal | |BaseRate2BankVal | ||
|BV-e 2 | |||
|Value with 6 Decimals | |Value with 6 Decimals | ||
|baasvaluuta summa | |baasvaluuta summa | ||
549. rida: | 703. rida: | ||
|- | |- | ||
|TaxTemplateCode | |TaxTemplateCode | ||
| | |||
|Capital Characters Only | |Capital Characters Only | ||
|maksumaatriksi kood | |maksumaatriksi kood | ||
555. rida: | 710. rida: | ||
|- | |- | ||
|TaxMatrix | |TaxMatrix | ||
| | |||
|Packed Matrix, base64 data | |Packed Matrix, base64 data | ||
|maksumaatriks | |maksumaatriks | ||
649. rida: | 805. rida: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
== Ettemaks == | |||
Juhul kui laekunud summat ei seota konkreetse arvega, või laekub rohkem kui arve summa on, saadetakse arvega mitteseotav summa eraldi laekumise reana. | |||
Ettemaksunumber võib olla kliendikood, st see ei pea olema iga kord erinev. | |||
Standard Booksi sees ei tohi olla '''Moodul Müügiarved > Seadistused > Lausendamine''', Müük peal linnukest “''Kohustuslikud unikaalsed ettemaksunumbrid'' (vaikimisi see peal ei ole). | |||
Laekumise real peavad Ettemaksu korral olema minimaalselt täidetud: | |||
{| class="wikitable" | |||
!Field Name | |||
!Kasutajaliidese nimi | |||
!Kirjeldus | |||
|- | |||
|stp | |||
| | |||
|Reatüüp. Ettemaksu puhul väärtuseks: 0 | |||
|- | |||
|CustCode | |||
|Klient | |||
|Kliendikood | |||
|- | |||
|RecVal | |||
|Summa | |||
|Ette makstud summa | |||
|- | |||
|CUPNr | |||
|Ettemaksu nr. | |||
|Kokkuleppeliselt kliendi kood | |||
|- | |||
|VATCode | |||
|KM-kood | |||
|Käibemaksukood | |||
|} | |||
Kui arve seotakse ettemaksuga, siis saadetakse see info Standard Booksi Laekumiste registrisse kahe reana: | |||
{| class="wikitable" | |||
!Row | |||
!Field Name | |||
!Kasutajaliidese nimi | |||
!Kirjeldus | |||
|- | |||
|1 | |||
|stp | |||
| | |||
|Reatüüp. Ettemaksu puhul väärtuseks: 0 | |||
|- | |||
|1 | |||
|InvoiceNr | |||
|Arve nr. | |||
|Arve, mis seotakse ettemaksuga. | |||
|- | |||
|1 | |||
|CustCode | |||
|Klient | |||
|Kliendikood | |||
|- | |||
|1 | |||
|RecVal | |||
|Summa | |||
|Kinni kantav summa (Positiivse märgiga) | |||
|- | |||
|2 | |||
|stp | |||
| | |||
|Reatüüp. Ettemaksu puhul väärtuseks: 0 | |||
|- | |||
|2 | |||
|CustCode | |||
|Klient | |||
|Kliendikood | |||
|- | |||
|2 | |||
|RecVal | |||
|Summa | |||
|Kinni kantav summa (Negatiivse märgiga) | |||
|- | |||
|2 | |||
|CUPNr | |||
|Ettemaksu nr. | |||
|Kokkuleppeliselt kliendi kood | |||
|- | |||
|2 | |||
|VATCode | |||
|KM-kood | |||
|Käibemaksukood | |||
|} | |||
Tulemuseks on see, et arvele tekib laekumine ja ettemaksu saldot vähendatakse kinnikantava summa ulatuses. Ettemaksu võib kinni kanda ka osaliselt, nt kui ettemaks on 100 eurot, arve summa aga ainult 80. Nii jääb 20 veel ettemaksuna üles. |
Viimane redaktsioon: 5. mai 2023, kell 10:58
Register
<data> element peab sisaldama:
- register="IPVc"
Toetatud väljad
Päis
Field Name | Kasutajaliidese nimi | Description | Kirjeldus | Kohustuslik | Field type | Max Length | Kommentaar |
---|---|---|---|---|---|---|---|
Comment | Kommentaar | String | kirjeldus | M4Str | 60 | ||
PayMode | Tasumisviis | Code String | Tasumisviis | + | M4Code | 2 | |
PayCurCode | Valuuta | Value 2 or 3 Decimals | Valuuta | M4Val | 0 | Kui on antud, kirjutab üle kõikide ridade valuutad | |
TransDate | Kande kp. | In Dataformat Order | kande kuupäev | M4Date | 0 | Kui puudub siis tänane kuupäev.
NB! Peab sobima arvele, ehk ei tohi arvest varasemat kuupäeva sisestada. | |
OKFlag | Kinnita | Small Value with No Decimals | Kinnitatud linnuke | + | M4Int | 0 |
Maatriks
Field Name | Kasutajaliidese nimi | Description | Kirjeldus | Kohustuslik | Field type | Max Length | Kommentaar |
---|---|---|---|---|---|---|---|
stp | Small Value with No Decimals | Rea tüüp:
1 = tavaline 2 = Muutusmärk 3 = parandusmärk |
+ | M4Int | 0 | Hetkel ainult 1 = tavaline on toetatud | |
ovst | Small Value with No Decimals | Tühistatud rida jah=1/ei=0 | M4Int | 0 | Ei ole kohustuslik, vaikimisi alati 0 | ||
InvoiceNr | Arve nr. | Value with No Decimals | Arve nr | + | M4Long | 0 | Peab olema täidetud siis kui puudub Ettemaksu nr. ja vastupidi. |
PayDate | Tasumise kp. | In Dataformat Order | Laekumise kuupäev | M4Date | 0 | ||
CustCode | Klient | Code String | kliendikood | + | M4Code | 20 | Peab vastama antud arvele. |
RecVal | Saadud summa | Value 2 or 3 Decimals | Saadud summa | M4Val | 0 | Kui puudub, võetakse arve kogu summa. Ridade asetamisel arvutatakse ka Laekumise "Kokku" summat automaatselt. | |
CUPNr | Ettemaksu nr. | Value with No Decimals | Ettemaksu nr | M4Long | Peab olema täidetud siis kui puudub Arve nr. ja vastupidi. | ||
VATCode | KM-k | Code String | Käibemaksukood | M4Code | Peab olema täidetud siis kui antud Ettemaksu nr. |
Näidis XML päring
<?xml version="1.0" encoding="UTF-8"?>
<data register="IPVc" method="create" sequence="106357" systemversion="8.4.20.504">
<IPVc>
<PayMode>P</PayMode>
<OKFlag>0</OKFlag>
<Comment>This is comment</Comment>
<PayCurCode>USD</PayCurCode>
<rows>
<row rownumber="0">
<stp>1</stp>
<ovst>0</ovst>
<InvoiceNr>180010</InvoiceNr>
<CustCode>101</CustCode>
<RecVal>20</RecVal>
<PayDate>2018-08-17</PayDate>
</row>
</rows>
</IPVc>
</data>
Kõigi XML väljade kirjeldused
Päis (Header)
Field Name | Kasutajaliidese nimi | Description | Kirjeldus | Field type | Max Length |
---|---|---|---|---|---|
SerNr | Nr. | Value with No Decimals | Kande number | M4Long | 0 |
Comment | Kommentaar | String | kirjeldus | M4Str | 60 |
PayMode | Tasumisviis | Code String | Tasumisviis | M4Code | 2 |
OKFlag | Kinnita | Small Value with No Decimals | Kinnitatud linnuke | M4Int | 0 |
CurPayVal | Valuuta | Value 2 or 3 Decimals | Valuuta | M4Val | 0 |
RegDate | Kande kp. | In Dataformat Order | Kande kuupäev | M4Date | 0 |
OKMark | As Bool but displayed as a Checkbox | Sirvi akna kinnituse märk | M4Mark | 0 | |
TransDate | Kande kuupäev | In Dataformat Order | kande kuupäev | M4Date | 0 |
Sign | Code String | isik | M4Code | 10 | |
ARonTR | Small Value with No Decimals | M4Int | 0 | ||
ExportedFlag | Small Value with No Decimals | eksporditud | M4Int | 0 | |
ReceivedFlag | Small Value with No Decimals | n/a | M4Int | 0 | |
RejectedFlag | Small Value with No Decimals | n/a | M4Int | 0 | |
RecNumber | String | M4Str | 20 | ||
Invalid | Small Value with No Decimals | tühistatud | M4Int | 0 | |
PayCurCode | Code String | valuuta | M4Code | 5 | |
Objects | Capital Characters Only | objektid | M4UStr | 60 | |
Prntdf | Small Value with No Decimals | M4Int | 0 | ||
AuthorizationCode | Capital Characters Only | n/a | M4UStr | 20 | |
MachineName | Code String | n/a | M4Code | 20 | |
DrawerCode | Code String | n/a | M4Code | 5 | |
RegTime | Hour:Min:Secs | salvestamise kellaaeg | M4Time | 0 | |
IPBookVAT | Small Value with No Decimals | M4Int | 0 | ||
OfficialSerNr | String | ametlik numbriseeria | M4Str | 100 | |
OfficialSerNr2 | String | ametlik numbriseeria | M4Str | 100 | |
Status | Int represented by a Set of String | hetkeseis | M4Set | 361 | |
BranchID | Code String | n/a | M4Code | 20 | |
TerminalID | String | n/a | M4Str | 60 | |
OfficialSerNrSerie | String | ametliku numbri numbriseeria | M4Str | 30 |
Maatriks (Rows)
Field Name | Kasutajaliidese nimi | Description | Kirjeldus | Field type | Max Length |
---|---|---|---|---|---|
stp | Small Value with No Decimals | Rea tüüp:
1 = tavaline 2 = Muutusmärk 3 = parandusmärk |
M4Int | 0 | |
ovst | Small Value with No Decimals | Tühistatud rida jah/ei | M4Int | 0 | |
InvoiceNr | Arve nr. | Value with No Decimals | Arve nr | M4Long | 0 |
PayDate | Tasumise kp. | In Dataformat Order | Laekumise kuupäev | M4Date | 0 |
CustCode | Klient | Code String | kliendikood | M4Code | 20 |
latedays | Value with No Decimals | hilinenud päevi | M4Long | 0 | |
CustName | Tekst | String | kliendi nimi | M4Str | 200 |
CUPNr | Ettemaksu number | Value with No Decimals | Ettemaksu number | M4Long | 0 |
ChequeNr | Tsheki number | Value with No Decimals | Tsheki number | M4Long | 0 |
VATVal | Value 2 or 3 Decimals | KM valuuta | M4Val | 0 | |
VATCode | KM-k | Code String | KM kood | M4Code | 10 |
InvOutstand | Tasumata summa | Value 2 or 3 Decimals | Arve tasumata summa | M4Val | 0 |
InvCurncy | A.val | Code String | Arve valuuta | M4Code | 5 |
InvVal | Arve summa | Value 2 or 3 Decimals | Arve summa | M4Val | 0 |
PayMode | Tas. viis | Code String | Tasumisviis | M4Code | 2 |
BankCurncy | P. val. | Code String | Panga valuuta | M4Code | 5 |
BankVal | Panga sum. | Value 2 or 3 Decimals | Panga summa | M4Val | 0 |
RecCurncy | S.val | Code String | Saadud valuuta | M4Code | 5 |
RecVal | Saadud summa | Value 2 or 3 Decimals | Saadud summa | M4Val | 0 |
BankFeeVal | Value 2 or 3 Decimals | Panga teenustasu valuuta | M4Val | 0 | |
RoundOff | Value 2 or 3 Decimals | ümardamine | M4Val | 0 | |
RoundOffAcc | Code String | Ümardamise konto | M4Code | 10 | |
Objects | Objektid | Capital Characters Only | objektid | M4UStr | 60 |
Coef | Value with 6 Decimals | n/a | M4Rate | 0 | |
BankFeePrc | n/a | 20 | |||
TAX1Sum | Value 2 or 3 Decimals | M4Val | 0 | ||
OrderNr | Tellimuse nr. | Value with No Decimals | tellimuse nr | M4Long | 0 |
Comment | String | kirjeldus | M4Str | 60 | |
B1BankVal | Panga summa BV 1 | Value 2 or 3 Decimals | baasvaluuta 1 summa | M4Val | 0 |
B2BankVal | Panga summa BV 2 | Value 2 or 3 Decimals | baasvaluuta 2 summa | M4Val | 0 |
ToRateB1BankVal | Baaskurss 1 | Value with 6 Decimals | baasvaluuta kurss | M4Rate | 0 |
ToRateB2BankVal | Baaskurss 2 | Value with 6 Decimals | baasvaluuta kurss | M4Rate | 0 |
rkRecNumber | String | riigikassa | M4Str | 40 | |
ARAcc | Code String | M4Code | 10 | ||
TAX2Prc | Value with 2 or 3 Decimals | M423Val | 0 | ||
CredManNr | Value with No Decimals | M4Long | 0 | ||
SuggestVal | Value 2 or 3 Decimals | M4Val | 0 | ||
InstNr | Value with No Decimals | M4Long | 0 | ||
WriteOffAcc | Code String | lootusetult laekuvate arvete konto | M4Code | 10 | |
FrRateBankVal | Value with 6 Decimals | M4Rate | 0 | ||
BaseRate1BankVal | BV-e 1 | Value with 6 Decimals | baasvaluuta summa | M4Rate | 0 |
BaseRate2BankVal | BV-e 2 | Value with 6 Decimals | baasvaluuta summa | M4Rate | 0 |
TaxTemplateCode | Capital Characters Only | maksumaatriksi kood | M4UStr | 60 | |
TaxMatrix | Packed Matrix, base64 data | maksumaatriks | M4PackedMatrix | 0 |
Näidis XML päring
<?xml version="1.0" encoding="UTF-8"?>
<data register="IPVc" sequence="5949" systemversion="8.4.21.1518">
<IPVc>
<SerNr>180001</SerNr>
<Comment>Arveldusarve</Comment>
<PayMode>P</PayMode>
<OKFlag>1</OKFlag>
<CurPayVal>36.00</CurPayVal>
<RegDate>2018-01-23</RegDate>
<OKMark>1</OKMark>
<TransDate>2018-01-23</TransDate>
<Math />
<Sign>TANEL</Sign>
<ARonTR>0</ARonTR>
<ExportedFlag>0</ExportedFlag>
<ReceivedFlag>0</ReceivedFlag>
<RejectedFlag>0</RejectedFlag>
<RecNumber />
<Invalid>0</Invalid>
<PayCurCode>EUR</PayCurCode>
<Objects />
<Prntdf>0</Prntdf>
<AuthorizationCode />
<MachineName />
<DrawerCode />
<RegTime>09:45:18</RegTime>
<IPBookVAT>1</IPBookVAT>
<OfficialSerNr />
<OfficialSerNr2 />
<Status>-</Status>
<BranchID />
<TerminalID />
<OfficialSerNrSerie />
<rows>
<row rownumber="0">
<stp>1</stp>
<ovst>0</ovst>
<InvoiceNr>180001</InvoiceNr>
<PayDate>2018-01-23</PayDate>
<CustCode>2</CustCode>
<latedays />
<CustName>Uus kontakt, Kostja testib</CustName>
<CUPNr />
<ChequeNr />
<VATVal>6.00</VATVal>
<VATCode>1</VATCode>
<InvOutstand>36.00</InvOutstand>
<InvCurncy>EUR</InvCurncy>
<InvVal>36.00</InvVal>
<PayMode />
<BankCurncy>EUR</BankCurncy>
<BankVal>36.00</BankVal>
<RecCurncy>EUR</RecCurncy>
<RecVal>36.00</RecVal>
<BankFeeVal />
<RoundOff />
<RoundOffAcc />
<Objects />
<Coef />
<BankFeePrc />
<TAX1Sum />
<OrderNr />
<Comment />
<B1BankVal />
<B2BankVal />
<ToRateB1BankVal />
<ToRateB2BankVal />
<rkRecNumber />
<ARAcc>1210</ARAcc>
<TAX2Prc />
<CredManNr />
<SuggestVal />
<InstNr />
<WriteOffAcc />
<FrRateBankVal />
<BaseRate1BankVal />
<BaseRate2BankVal />
<TaxTemplateCode />
<TaxMatrix />
<InvoiceOfficialSerNr />
</row>
</rows>
</IPVc>
</data>
Ettemaks
Juhul kui laekunud summat ei seota konkreetse arvega, või laekub rohkem kui arve summa on, saadetakse arvega mitteseotav summa eraldi laekumise reana.
Ettemaksunumber võib olla kliendikood, st see ei pea olema iga kord erinev.
Standard Booksi sees ei tohi olla Moodul Müügiarved > Seadistused > Lausendamine, Müük peal linnukest “Kohustuslikud unikaalsed ettemaksunumbrid (vaikimisi see peal ei ole).
Laekumise real peavad Ettemaksu korral olema minimaalselt täidetud:
Field Name | Kasutajaliidese nimi | Kirjeldus |
---|---|---|
stp | Reatüüp. Ettemaksu puhul väärtuseks: 0 | |
CustCode | Klient | Kliendikood |
RecVal | Summa | Ette makstud summa |
CUPNr | Ettemaksu nr. | Kokkuleppeliselt kliendi kood |
VATCode | KM-kood | Käibemaksukood |
Kui arve seotakse ettemaksuga, siis saadetakse see info Standard Booksi Laekumiste registrisse kahe reana:
Row | Field Name | Kasutajaliidese nimi | Kirjeldus |
---|---|---|---|
1 | stp | Reatüüp. Ettemaksu puhul väärtuseks: 0 | |
1 | InvoiceNr | Arve nr. | Arve, mis seotakse ettemaksuga. |
1 | CustCode | Klient | Kliendikood |
1 | RecVal | Summa | Kinni kantav summa (Positiivse märgiga) |
2 | stp | Reatüüp. Ettemaksu puhul väärtuseks: 0 | |
2 | CustCode | Klient | Kliendikood |
2 | RecVal | Summa | Kinni kantav summa (Negatiivse märgiga) |
2 | CUPNr | Ettemaksu nr. | Kokkuleppeliselt kliendi kood |
2 | VATCode | KM-kood | Käibemaksukood |
Tulemuseks on see, et arvele tekib laekumine ja ettemaksu saldot vähendatakse kinnikantava summa ulatuses. Ettemaksu võib kinni kanda ka osaliselt, nt kui ettemaks on 100 eurot, arve summa aga ainult 80. Nii jääb 20 veel ettemaksuna üles.