Hausing - Register Tasumised: erinevus redaktsioonide vahel
Mine navigeerimisribale
Mine otsikasti
(päise kirjeldus) |
|||
2. rida: | 2. rida: | ||
== Kohustuslikud väljad == | == Kohustuslikud väljad == | ||
{| class="wikitable" | {| class="wikitable" | ||
!Field Name | |||
!Description | |||
!Kirjeldus | |||
!Field Type | |||
!Max Length | |||
|- | |||
|SerNr | |||
|SerNr | |||
|Kande number | |||
|M4Long | |||
|0 | |||
|- | |||
|BankAcc | |||
|BankAcc | |||
|pangakonto | |||
|M4Str | |||
|60 | |||
|- | |||
|Sign | |||
|Sign | |||
|isik | |||
|M4Code | |||
|10 | |||
|- | |||
|RegDate | |||
|RegDate | |||
|kuupäev | |||
|M4Date | |||
|0 | |||
|- | |||
|TransDate | |||
|TransDate | |||
|kande kuupäev | |||
|M4Date | |||
|0 | |||
|- | |||
|PayMode | |||
|PayMode | |||
|tasumisviis | |||
|M4Code | |||
|2 | |||
|- | |||
|BankName | |||
|BankName | |||
|panganimi | |||
|M4Str | |||
|60 | |||
|- | |||
|OrderedFlag | |||
|OrderedFlag | |||
|tellitud | |||
|M4Mark | |||
|0 | |||
|- | |||
|SentFlag | |||
|SentFlag | |||
|saadetud | |||
|M4Int | |||
|0 | |||
|- | |||
|DoneFlag | |||
|DoneFlag | |||
|kinnitatud | |||
|M4Mark | |||
|0 | |||
|- | |||
|PayDate | |||
|PayDate | |||
|maksmise kuupäev | |||
|M4Date | |||
|0 | |||
|- | |||
|PayMethod | |||
|PayMethod | |||
|makseviis | |||
|M4Int | |||
|0 | |||
|- | |||
|rows: | |||
| | |||
| | | | ||
| | | | ||
| | | | ||
|- | |- | ||
| | | | ||
| | |||
| | |||
| | | | ||
| | | | ||
|- | |- | ||
| | | | ||
| | |||
| | |||
| | | | ||
| | | | ||
|- | |- | ||
| | | | ||
| | |||
| | |||
| | | | ||
| | | | ||
|- | |- | ||
| | | | ||
| | |||
| | |||
| | | | ||
| | | | ||
|- | |- | ||
| | | | ||
| | | | ||
| | |||
| | |||
| | |||
|} | |||
=== Minimaalse XML päringu näide === | |||
== Kõigi XML väljade kirjeldused == | |||
{| class="wikitable" | |||
!Field Name | |||
!Description | |||
!Kirjeldus | |||
!Field Type | |||
!Max Length | |||
|- | |||
|SerNr | |||
|SerNr | |||
|Kande number | |||
|M4Long | |||
|0 | |||
|- | |- | ||
|BankAcc | |||
|BankAcc | |||
|pangakonto | |||
|M4Str | |||
|60 | |||
|- | |||
|Sign | |||
|Sign | |||
|isik | |||
|M4Code | |||
|10 | |||
|- | |||
|RegDate | |||
|RegDate | |||
|kuupäev | |||
|M4Date | |||
|0 | |||
|- | |||
|TransDate | |||
|TransDate | |||
|kande kuupäev | |||
|M4Date | |||
|0 | |||
|- | |||
|PayMode | |||
|PayMode | |PayMode | ||
| | |tasumisviis | ||
| | |M4Code | ||
|2 | |||
|- | |- | ||
|BankName | |BankName | ||
| | |BankName | ||
| | |panganimi | ||
|M4Str | |||
|60 | |||
|- | |- | ||
|OrderedFlag | |OrderedFlag | ||
| | |OrderedFlag | ||
| | |tellitud | ||
|M4Mark | |||
|0 | |||
|- | |- | ||
|SentFlag | |SentFlag | ||
| | |SentFlag | ||
| | |saadetud | ||
|M4Int | |||
|0 | |||
|- | |- | ||
|DoneFlag | |DoneFlag | ||
| | |DoneFlag | ||
| | |kinnitatud | ||
|M4Mark | |||
|0 | |||
|- | |- | ||
|PayDate | |PayDate | ||
| | |PayDate | ||
| | |maksmise kuupäev | ||
|M4Date | |||
|0 | |||
|- | |- | ||
|StatFlag | |||
|StatFlag | |StatFlag | ||
| | | | ||
| | |M4Int | ||
|0 | |||
|- | |- | ||
|ExportedFlag | |ExportedFlag | ||
| | |ExportedFlag | ||
| | |eksporditud | ||
|M4Int | |||
|0 | |||
|- | |- | ||
|PayNumber | |||
|PayNumber | |PayNumber | ||
| | | | ||
| | |M4Str | ||
|20 | |||
|- | |- | ||
|RejectedFlag | |RejectedFlag | ||
| | |RejectedFlag | ||
| | |tagasi lükatud | ||
|M4Int | |||
|0 | |||
|- | |- | ||
|Invalid | |Invalid | ||
| | |Invalid | ||
| | |tühistatud | ||
|M4Int | |||
|0 | |||
|- | |- | ||
|APonTR | |||
|APonTR | |APonTR | ||
| | | | ||
| | |M4Int | ||
|0 | |||
|- | |- | ||
|PayCurCode | |PayCurCode | ||
| | |PayCurCode | ||
| | |valuuta | ||
|M4Code | |||
|5 | |||
|- | |- | ||
|CurPayVal | |CurPayVal | ||
| | |CurPayVal | ||
| | |valuuta | ||
|M4Val | |||
|0 | |||
|- | |- | ||
|Objects | |Objects | ||
| | |Objects | ||
| | |objektid | ||
|M4UStr | |||
|60 | |||
|- | |- | ||
|SortCode | |||
|SortCode | |SortCode | ||
| | | | ||
|M4Str | |||
|10 | |||
|- | |||
|LangCode | |||
|LangCode | |||
|keelekood | |||
|M4Code | |||
|5 | |||
|- | |||
|PayperSupplier | |||
|PayperSupplier | |||
| | | | ||
|M4Int | |||
|0 | |||
|- | |||
|PayMethod | |||
|PayMethod | |||
|makseviis | |||
|M4Int | |||
|0 | |||
|- | |||
|Bankfees | |||
|Bankfees | |||
|pangatasud | |||
|M4Int | |||
|0 | |||
|- | |||
|ForeignPayment | |||
|ForeignPayment | |||
|välismakse | |||
|M4Int | |||
|0 | |||
|- | |||
|AcceptanceStatus | |||
|AcceptanceStatus | |||
|kinnitusringi hetkeseis | |||
|M4Set | |||
|443 | |||
|- | |||
|AcceptanceBy | |||
|AcceptanceBy | |||
|Kinnitatud kelle poolt | |||
|M4List | |||
|200 | |||
|- | |||
|AcceptanceFYI | |||
|AcceptanceFYI | |||
|kinnitusringi CC | |||
|M4List | |||
|200 | |||
|- | |||
|OKBy | |||
|OKBy | |||
|Kinnituse kuupäev | |||
|M4Code | |||
|10 | |||
|} | |} | ||
Redaktsioon: 3. august 2018, kell 12:02
Kohustuslikud väljad
Field Name | Description | Kirjeldus | Field Type | Max Length |
---|---|---|---|---|
SerNr | SerNr | Kande number | M4Long | 0 |
BankAcc | BankAcc | pangakonto | M4Str | 60 |
Sign | Sign | isik | M4Code | 10 |
RegDate | RegDate | kuupäev | M4Date | 0 |
TransDate | TransDate | kande kuupäev | M4Date | 0 |
PayMode | PayMode | tasumisviis | M4Code | 2 |
BankName | BankName | panganimi | M4Str | 60 |
OrderedFlag | OrderedFlag | tellitud | M4Mark | 0 |
SentFlag | SentFlag | saadetud | M4Int | 0 |
DoneFlag | DoneFlag | kinnitatud | M4Mark | 0 |
PayDate | PayDate | maksmise kuupäev | M4Date | 0 |
PayMethod | PayMethod | makseviis | M4Int | 0 |
rows: | ||||
Minimaalse XML päringu näide
Kõigi XML väljade kirjeldused
Field Name | Description | Kirjeldus | Field Type | Max Length |
---|---|---|---|---|
SerNr | SerNr | Kande number | M4Long | 0 |
BankAcc | BankAcc | pangakonto | M4Str | 60 |
Sign | Sign | isik | M4Code | 10 |
RegDate | RegDate | kuupäev | M4Date | 0 |
TransDate | TransDate | kande kuupäev | M4Date | 0 |
PayMode | PayMode | tasumisviis | M4Code | 2 |
BankName | BankName | panganimi | M4Str | 60 |
OrderedFlag | OrderedFlag | tellitud | M4Mark | 0 |
SentFlag | SentFlag | saadetud | M4Int | 0 |
DoneFlag | DoneFlag | kinnitatud | M4Mark | 0 |
PayDate | PayDate | maksmise kuupäev | M4Date | 0 |
StatFlag | StatFlag | M4Int | 0 | |
ExportedFlag | ExportedFlag | eksporditud | M4Int | 0 |
PayNumber | PayNumber | M4Str | 20 | |
RejectedFlag | RejectedFlag | tagasi lükatud | M4Int | 0 |
Invalid | Invalid | tühistatud | M4Int | 0 |
APonTR | APonTR | M4Int | 0 | |
PayCurCode | PayCurCode | valuuta | M4Code | 5 |
CurPayVal | CurPayVal | valuuta | M4Val | 0 |
Objects | Objects | objektid | M4UStr | 60 |
SortCode | SortCode | M4Str | 10 | |
LangCode | LangCode | keelekood | M4Code | 5 |
PayperSupplier | PayperSupplier | M4Int | 0 | |
PayMethod | PayMethod | makseviis | M4Int | 0 |
Bankfees | Bankfees | pangatasud | M4Int | 0 |
ForeignPayment | ForeignPayment | välismakse | M4Int | 0 |
AcceptanceStatus | AcceptanceStatus | kinnitusringi hetkeseis | M4Set | 443 |
AcceptanceBy | AcceptanceBy | Kinnitatud kelle poolt | M4List | 200 |
AcceptanceFYI | AcceptanceFYI | kinnitusringi CC | M4List | 200 |
OKBy | OKBy | Kinnituse kuupäev | M4Code | 10 |
Näidis XML päring
<?xml version="1.0" encoding="UTF-8"?>
<data register="OPVc" sequence="157419" systemversion="8.4.21.1518">
<OPVc>
<SerNr>1</SerNr>
<BankAcc>IBAN</BankAcc>
<Sign>AA</Sign>
<RegDate>2015-03-05</RegDate>
<TransDate>2014-02-02</TransDate>
<PayMode>P</PayMode>
<BankName>KOMMENTAAR</BankName>
<OrderedFlag>0</OrderedFlag>
<SentFlag>0</SentFlag>
<DoneFlag>0</DoneFlag>
<PayDate>2014-02-02</PayDate>
<StatFlag>0</StatFlag>
<Math />
<ExportedFlag>0</ExportedFlag>
<PayNumber>VIIDE</PayNumber>
<RejectedFlag>0</RejectedFlag>
<Invalid>0</Invalid>
<APonTR>0</APonTR>
<PayCurCode>EUR</PayCurCode>
<CurPayVal>30219.80</CurPayVal>
<Objects />
<SortCode>HARUKONTOR</SortCode>
<LangCode>KEEL</LangCode>
<PayperSupplier>0</PayperSupplier>
<PayMethod>0</PayMethod>
<Bankfees>0</Bankfees>
<ForeignPayment>0</ForeignPayment>
<AcceptanceStatus>Pole vajalik</AcceptanceStatus>
<AcceptanceBy />
<AcceptanceFYI />
<OKBy />
<rows>
<row rownumber="0">
<stp>1</stp>
<ovst>0</ovst>
<VISerNr>1</VISerNr>
<BankAcc />
<Comment>KohviUba OÜ</Comment>
<VECode>103</VECode>
<Objects />
<VATVal />
<VATCode />
<ChequeNr />
<PrepayNr />
<PayMode />
<PInvOutstand>336.00</PInvOutstand>
<PInvCurncy>EUR</PInvCurncy>
<PInvVal>336.00</PInvVal>
<BankCurncy>EUR</BankCurncy>
<BankVal>336.00</BankVal>
<RecCurncy>EUR</RecCurncy>
<RecVal>336.00</RecVal>
<BankFeeVal />
<RoundOff />
<RoundOffAcc />
<SortCode />
<Coef />
<BankFeePrc />
<OrderNr />
<B1BankVal />
<B2BankVal />
<ToRateB1BankVal />
<ToRateB2BankVal />
<BankRefStr />
<rkPayNumber />
<WHTax />
<WHTaxBase />
<TAX1Sum />
<APAcc>2310</APAcc>
<InstNr />
<FrRateBankVal />
<BaseRate1BankVal />
<BaseRate2BankVal />
<WHTaxPrc />
<PaymentCode />
<WHTaxAccumBase />
</row>
<row rownumber="1">
<stp>1</stp>
<ovst>0</ovst>
<VISerNr>2</VISerNr>
<BankAcc />
<Comment>True Electronics Co</Comment>
<VECode>107</VECode>
<Objects />
<VATVal />
<VATCode />
<ChequeNr />
<PrepayNr />
<PayMode />
<PInvOutstand>29883.80</PInvOutstand>
<PInvCurncy>EUR</PInvCurncy>
<PInvVal>29883.80</PInvVal>
<BankCurncy>EUR</BankCurncy>
<BankVal>29883.80</BankVal>
<RecCurncy>EUR</RecCurncy>
<RecVal>29883.80</RecVal>
<BankFeeVal />
<RoundOff />
<RoundOffAcc />
<SortCode />
<Coef />
<BankFeePrc />
<OrderNr />
<B1BankVal />
<B2BankVal />
<ToRateB1BankVal />
<ToRateB2BankVal />
<BankRefStr />
<rkPayNumber />
<WHTax />
<WHTaxBase />
<TAX1Sum />
<APAcc>2310</APAcc>
<InstNr />
<FrRateBankVal />
<BaseRate1BankVal />
<BaseRate2BankVal />
<WHTaxPrc />
<PaymentCode />
<WHTaxAccumBase />
</row>
</rows>
</OPVc>
</data>