Hausing - Register Ostuarved: erinevus redaktsioonide vahel

Allikas: Excellent || Opendoc
Mine navigeerimisribale Mine otsikasti
(VATVal lisatud ja kommentaar)
 
(ei näidata 3 kasutaja 5 vahepealset redaktsiooni)
8. rida: 8. rida:
== Toetatud väljad ==
== Toetatud väljad ==


=== Minimaalse XML päringu näide ===
=== Päis ===
{| class="wikitable"
!Kood
!Kasutajaliides väli
!'''Kirjeldus'''
!Kohustuslik
!''Tüüp''
!Kommentaar
|-
|'''InvDate'''
|Ostuarve kuupäev
|Purchase invoice date
| +
|In Dataformat Order
|
|-
|'''PayVal'''
|Summa kokku
|Sum total
| +
|Value 2 or 3 Decimals
|Koos KM
|-
|'''InvoiceNr'''
|Hankija arve number
|Supplier invoice number
|
|String
|Ei ole lubatud sama tarnija arve number erinevatel ostuarvetel, kui on Ostuarved - Seadistused - Lausendamine, ostud - linnuke "Ära luba sama tarnija arvenr-ga arveid". Toimub RecordCheck error.
|-
|'''OKFlag'''
|Kinnitatud. 0=ei, 1=jah
|OKed flag. 0=No; 1=Yes.
| +
|As Bool but displayed as a Checkbox
|
|-
|'''PayDeal'''
|Tasumistingimus
|Payment terms
| +
|Code String
|
|-
|'''VECode'''
|Hankija
|Supplier
| +
|Code String
|
|-
|'''VEName'''
|Nimi
|Name (Supplier)
|
|String
|Täidetakse automaatselt VECode asetamisel, asendatakse kui väli on XMLis antud.
|-
|'''DueDate'''
|Tähtaeg
|Due date
|
|In Dataformat Order
|Arvutatakse automaatselt PayDeal asetamisel, asendatakse kui väli on XMLis antud.
|-
|'''BankAcc'''
|Pangakonto, IBAN
|Bank Account
| +
|String
|
|-
|'''TransDate'''
|Kande kuupäev
|Transaction date
|
|In Dataformat Order
|Arvutatakse automaatselt InvDate asetamisel, asendatakse kui väli on XMLis antud.
|-
|'''<s>InvType</s>'''
|<s>Arve tüüp (Tavaline, kreedit jne. 1=tavaline)</s>
|<s>Invoice type flag</s>
|
|<s>Small Value with No Decimals</s>
|Ei POSTita seda välja enam, muutub automaatselt
|-
|'''VATVal'''
|Käibemaks
|VAT sum
|
|Value 2 or 3 Decimals
|Käibemaksu summa, arvutatakse automaatselt vastavalt seadistusele Ostuarved - Seadistused - Ostuarvete seadistus - KM %. Kui kasutusel erinevad KM koodid teiste %-ga, siis vaja päringus saata vastav väärtus, mis kirtjuab automaatselt arvutatud väärtust üle (vastasel juhul ei luba programm salvestada kuna Kandes on vahe)
|}
 
=== Maatriks ===
{| class="wikitable"
!Kood
!Kasutajaliides väli
!'''Kirjeldus'''
!Kohustuslik
!''Tüüp''
!Kommentaar
|-
|'''stp'''
|
|Rea tüüp (1=tavaline)
| +
|Small Value with No Decimals
|
|-
|'''ovst'''
|
|Tühistatud rida jah=1/ei=0
|
|Small Value with No Decimals
|ei ole kohustuslik, vaikimisi alati 0
|-
|'''AccNumber'''
|Konto number
|A/C
| +
|Code String
|
|-
|'''Comment'''
|Kommentaar
|Comment
|
|String
|Täidetakse automaatselt AccNumber asetamisel, asendatakse kui väli on XMLis antud.
|-
|'''Sum'''
|Summa
|Sum
| +
|Value 2 or 3 Decimals
|Ilma KM-ta
|-
|'''Item'''
|artikkel
|Item
|
|Code String
|
|-
|'''qty'''
|Kogus
|Quantity
|
|Value with minimum Decimals
|
|-
|'''VATCode'''
|Käibemaksukood
|VAT Code
| +
|Code String
|
|}
 
=== Näidis XML päring ===
<syntaxhighlight lang="xml" line="1">
<?xml version="1.0" encoding="UTF-8"?>
<data register="VIVc" method="create" sequence="106357" systemversion="8.4.20.504">
  <VIVc>
    <TransDate>2018-08-20</TransDate> <!-- note - here TransDate is overridden, not similar to InvDate -->
    <InvDate>2018-08-22</InvDate>
    <PayVal>120.00</PayVal>
    <PayDeal>5</PayDeal>
    <VECode>102</VECode>
    <BankAcc>EE123456789</BankAcc>
    <OKFlag>0</OKFlag>
    <InvoiceNr>45655665</InvoiceNr>
    <VEName>Override default vendor name</VEName>
    <DueDate>2018-09-22</DueDate> <!-- note - here DueDate is overridden, 5 days given by PayDeal -->
    <rows>
      <row rownumber="0">
        <stp>1</stp>
        <AccNumber>1010</AccNumber>
        <Sum>100</Sum>
        <VATCode>1</VATCode>
        <Comment>Override default account comment</Comment>
        <Item>001</Item>
        <qty>3</qty>
      </row>
    </rows>
  </VIVc>
</data>
</syntaxhighlight>


== Kõigi XML väljade kirjeldused ==
== Kõigi XML väljade kirjeldused ==
18. rida: 206. rida:
|-
|-
|'''SerNr'''
|'''SerNr'''
|
|Ostuarve number
|Purchase invoice number ''(Ostuarve number)''
|Purchase invoice number
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''InvDate'''
|'''InvDate'''
|
|Ostuarve kuupäev
|Purchase invoice date ''(Ostuarve kuupäev)''
|Purchase invoice date
|In Dataformat Order
|In Dataformat Order
|-
|-
|'''PayVal'''
|'''PayVal'''
|
|Summa kokku
|Sum total ''(Summa kokku)''
|Sum total
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''RegDate'''
|'''RegDate'''
|
|Koostatud kuupäeval
|Created date ''(Koostatud kuupäeval)''
|Created date
|In Dataformat Order
|In Dataformat Order
|-
|-
|'''InvoiceNr'''
|'''InvoiceNr'''
|
|Hankija arve number
|Supplier invoice number ''(Hankija arve number)''
|Supplier invoice number
|String
|String
|-
|-
|'''OKFlag'''
|'''OKFlag'''
|
|Kinnita linnuke
|OKed flag. 0=No; 1=Yes. ''(Kinnita linnuke)''
|OKed flag. 0=No; 1=Yes.
|As Bool but displayed as a Checkbox
|As Bool but displayed as a Checkbox
|-
|-
|'''PayDeal'''
|'''PayDeal'''
|
|Tasumistingimus
|Payment terms ''(Tasumistingimus)''
|Payment terms
|Code String
|Code String
|-
|-
|'''VECode'''
|'''VECode'''
|
|Hankija
|Supplier ''(Hankija)''
|Supplier
|Code String
|Code String
|-
|-
|'''VEName'''
|'''VEName'''
|
|Nimi
|Name (Supplier). ''(Nimi)''
|Name (Supplier)
|String
|String
|-
|-
|'''DueDate'''
|'''DueDate'''
|
|Tähtaeg
|Due date ''(Tähtaeg)''
|Due date
|In Dataformat Order
|In Dataformat Order
|-
|-
|'''RebDate'''
|'''RebDate'''
|
|Kassa-ale kuupäev
|Discount date ''(Kassa-ale kuupäev)''
|Discount date
|In Dataformat Order
|In Dataformat Order
|-
|-
|'''RefStr'''
|'''RefStr'''
|
|Viide
|Reference ''(Viide)''
|Reference
|String
|String
|-
|-
|'''BankAcc'''
|'''BankAcc'''
|
|Pangakonto, IBAN
|Bank Account ''(Pangakonto, IBAN)''
|Bank Account
|String
|String
|-
|-
|'''Sign'''
|'''Sign'''
|
|Müügimees
|Salesman / Creator name. ''(Müügimees)''
|Salesman / Creator name
|Code String
|Code String
|-
|-
|'''RebVal'''
|'''RebVal'''
|
|Kassa-ale summa
|Discount ''(Kasa-ale summa)''
|Discount
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''TransDate'''
|'''TransDate'''
|
|Kande kuupäev
|Transaction date ''(Kande kuupäev)''
|Transaction date
|In Dataformat Order
|In Dataformat Order
|-
|-
|'''InvType'''
|'''InvType'''
|
|Arve tüüp
|Invoice type flag ''(Arve tüüp)''
|Invoice type flag
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''VATVal'''
|'''VATVal'''
|
|Käibemaks
|VAT ''(Käibemaks)''
|VAT
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''APAcc'''
|'''APAcc'''
|
|Ostuvõlgade konto
|Creditors AC ''(Ostuvõlgade konto)''
|Creditors AC
|Code String
|Code String
|-
|-
|'''VEFactoring'''
|'''VEFactoring'''
|
|Faktooring
|Factoring ''(Faktooring)''
|Factoring
|Code String
|Code String
|-
|-
|'''BankName'''
|'''BankName'''
|
|Panga nimi
|Bank Name (Panga nimi)
|Bank Name
|String
|String
|-
|-
|'''OKPersons'''
|'''OKPersons'''
|
|Kinnitajad
|Signers ''(Kinnitajad)''
|Signers
|Capital Characters Only
|Capital Characters Only
|-
|-
|'''CurncyCode'''
|'''CurncyCode'''
|
|Valuuta
|Currency ''(Valuuta)''
|Currency
|Code String
|Code String
|-
|-
|'''ToRateB1'''
|'''ToRateB1'''
|
|B1 kurss
|B1 rate ''(B1 kurss)''
|B1 rate
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''ExportFlag'''
|'''ExportFlag'''
|
|Käibemaksutsoon
|VAT zone (Käibemaksutsoon)
|VAT zone
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''VEVatCode'''
|'''VEVatCode'''
|
|Tarnija VAT number
|Vendor VAT code ''(Tarnija VAT number)''
|Vendor VAT code
|Code String
|Code String
|-
|-
|'''Comment'''
|'''Comment'''
|
|Kirjeldus
|Comment
|Comment
|String
|String
|-
|-
|'''CalcVATVal'''
|'''CalcVATVal'''
|
|VAT arvutatud
|VAT, calculated ''(VAT arvutatud)''
|VAT, calculated
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''Closed'''
|'''Closed'''
|
|Suletud linnuke
|Closed flag ''(Suletud linnuke)''
|Closed flag
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''Objects'''
|'''Objects'''
|
|Objektid
|Objects (Objektid)
|Objects
|Capital Characters Only
|Capital Characters Only
|-
|-
|'''PrelBook'''
|'''PrelBook'''
|
|Eelkonteeritud
|Pre Booked ''(Eelkonteeritud)''
|Pre Booked
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''BankCode'''
|'''BankCode'''
|
|Pangakood
|Bank code ''(Pangakood)''
|Bank code
|String
|String
|-
|-
|'''CredInv'''
|'''CredInv'''
|
|Krediteeritud arve number
|Credited invoice number ''(Krediteeritud arve number)''
|Credited invoice number
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''xStatFlag'''
|'''xStatFlag'''
|
|
|''Not used. Always empty''
|Not used. Always empty
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''CORefStr'''
|'''CORefStr'''
|
|Ettevõtte viide, kasutavad riigiasutused
|Company`s Reference ''(Ettevõtte viide, kasutavad riigiasutused)''
|Company`s Reference
|String
|String
|-
|-
|'''ExportedFlag'''
|'''ExportedFlag'''
|
|
|Exported flag. 0=no; 1=yes ''(Ostuarve eksporditud, jah, ei.)''
|Exported flag. 0=no; 1=yes
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''POSerNr'''
|'''POSerNr'''
|
|Ostutellimuse number
|Purchase Order number ''(Ostutellimuse number)''
|Purchase Order number
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''FrRate'''
|'''FrRate'''
|
|Kurss
|Rate ''(Kurss)''
|Rate
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''ToRateB2'''
|'''ToRateB2'''
|
|Kurss baasvaluuta 2 suhtes
|Rate to Base currency 2 ''(Kurss baasvaluuta 2 suhtes)''
|Rate to Base currency 2
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''BaseRate1'''
|'''BaseRate1'''
|
|Baasvaluuta 1
|Base currency 1 ''(Baasvaluuta 1)''
|Base currency 1
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''BaseRate2'''
|'''BaseRate2'''
|
|Baasvaluuta 2
|Base currency 2 ''(Baasvaluuta 2)''
|Base currency 2
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''CredMark'''
|'''CredMark'''
|
|
|Credit invoice flag. 0=no; 1=yes ''(Kreeditarve. ei/jah)''
|Credit invoice flag. 0=no; 1=yes
|String
|String
|-
|-
|'''APonTR'''
|'''APonTR'''
|
|Info kande E osale
|Supplier info on transit flag. . 0=no; 1=yes ''(Info kande E osale)''
|Supplier info on transit flag. . 0=no; 1=yes
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''Invalid'''
|'''Invalid'''
|
|
|Invalid flag. 0=no; 1=yes ''(Kehtetu. Ei/jah)''
|Invalid flag. 0=no; 1=yes
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''VATNr'''
|'''VATNr'''
|
|KMKR nr
|VAT no. ''(KMKR nr)''
|VAT no.
|String
|String
|-
|-
|'''LangCode'''
|'''LangCode'''
|
|Keel
|Language code ''(Keel)''
|Language code
|Code String
|Code String
|-
|-
|'''InstallmentInv'''
|'''InstallmentInv'''
|
|Osalise makes nr
|Partial payment no ''(Osalise makes nr)''
|Partial payment no
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''POCQStatNr'''
|'''POCQStatNr'''
|
|Ostuprotsess
|P/O Process No ''(Ostuprotsess)''
|P/O Process No
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''SortCode'''
|'''SortCode'''
|
|Sorteerimiskood
|Sort code ''(Sorteerimiskood)''
|Sort code
|String
|String
|-
|-
|'''SalesGroup'''
|'''SalesGroup'''
|
|Müügigrupp
|Sales Group ''(Müügigrupp)''
|Sales Group
|Code String
|Code String
|-
|-
|'''SalesMan'''
|'''SalesMan'''
|
|Meie esindaja, müügimees
|Sales Person ''(Meie esindaja, müügimees)''
|Sales Person
|Code String
|Code String
|-
|-
|'''POCOSerNr'''
|'''POCOSerNr'''
|
|Ostuleping
|Purchase contract no ''(Ostuleping)''
|Purchase contract no
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''HoldSum'''
|'''HoldSum'''
|
|Ootel summa
|Hold amount ''(Ootel summa)''
|Hold amount
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''DiffVal'''
|'''DiffVal'''
|
|B1 erinevus
|Base 1 Difference ''(B1 erinevus)''
|Base 1 Difference
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''BarCode'''
|'''BarCode'''
|
|ribakood
|Bar code ''(ribakood)''
|Bar code
|String
|String
|-
|-
|'''StatVal'''
|'''StatVal'''
|
|Stat. väärtus
|Stat. Value ''(Stat. väärtus)''
|Stat. Value
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''xAcceptanceState'''
|'''xAcceptanceState'''
|
|
|''Not used. Always empty''
|Not used. Always empty
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''xAcceptanceGroup'''
|'''xAcceptanceGroup'''
|
|
|''Not used. Always empty''
|Not used. Always empty
|Code String
|Code String
|-
|-
|'''WithHoldingTax'''
|'''WithHoldingTax'''
|
|Kin.maks
|Withh. Tax ''(Kin.maks)''
|Withh. Tax
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''SupCurVal'''
|'''SupCurVal'''
|
|Ostuval. Summa
|Cur. Sum ''(Ostuval. Summa)''
|Cur. Sum
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''RcvDate'''
|'''RcvDate'''
|
|Vastuvõtmiskuupäev
|Receiving Date ''(Vastuvõtmiskuupäev)''
|Receiving Date
|In Dataformat Order
|In Dataformat Order
|-
|-
|'''TAX1Sum'''
|'''TAX1Sum'''
|
|Maksu summa
|Tax  sum ''(Maksu summa)''
|Tax  sum
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''ServiceDelDate'''
|'''ServiceDelDate'''
|
|Teenuse lähetamiskuupäev
|Service Del. Date ''(Teenuse lähetamiskuupäev)''
|Service Del. Date
|In Dataformat Order
|In Dataformat Order
|-
|-
|'''OfficialSerNr'''
|'''OfficialSerNr'''
|
|Ametlik seerianumber
|Official serial number ''(Ametlik seerianumber)''
|Official serial number
|String
|String
|-
|-
|'''TAX2Sum'''
|'''TAX2Sum'''
|
|Maks2
|Tax2 ''(Maks2)''
|Tax2
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''RebDate2'''
|'''RebDate2'''
|
|Kassa-ale 2 kuupäev
|Discount 2 date ''(Kassa-ale 2 kuupäev)''
|Discount 2 date
|In Dataformat Order
|In Dataformat Order
|-
|-
|'''TaxAuthID'''
|'''TaxAuthID'''
|
|Maksuameti  ID
|Tax Auth. ID ''(Maksuameti  ID)''
|Tax Auth. ID
|String
|String
|-
|-
|'''TaxAuthIDCC'''
|'''TaxAuthIDCC'''
|
|Kontrollkood
|Control code ''(Kontrollkood)''
|Control code
|String
|String
|-
|-
|'''BranchID'''
|'''BranchID'''
|
|Filiaal
|Branch ''(Filiaal)''
|Branch
|Code String
|Code String
|-
|-
|'''NoTAXonVAT'''
|'''NoTAXonVAT'''
|
|Arvuta lisamaks summast ilma käibemaksuta
|Calculate Ext. Tax on Sum incl ''(Arvuta lisamaks summast ilma kŠibemaksuta)''
|Calculate Ext. Tax on Sum incl
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''IVNr'''
|'''IVNr'''
|
|Arve number
|Invoice No. ''(Arve number)''
|Invoice No.
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''CAE'''
|'''CAE'''
|
|CAE
|CAE (''CAE'')
|CAE
|String
|String
|-
|-
|'''CAEExpiry'''
|'''CAEExpiry'''
|
|CAE kehtivuskuupäev
|CAE exp date ''(CAE kehtivuskuupäev)''
|CAE exp date
|In Dataformat Order
|In Dataformat Order
|-
|-
|'''Region'''
|'''Region'''
|
|Regioon
|Region ''(Regioon)''
|Region
|Code String
|Code String
|-
|-
|'''OrderType'''
|'''OrderType'''
|
|tellimuse tüüp
|Order type ''(tellimuse tüüp)''
|Order type
|Int represented by a Set of String
|Int represented by a Set of String
|-
|-
|'''RebVal2'''
|'''RebVal2'''
|
|Kassa-ale 2 väärtus
|Discount 2 value ''(Kassa-ale 2 väärtus)''
|Discount 2 value
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''AcceptanceStatus'''
|'''AcceptanceStatus'''
|
|Vastuvõtmise staatus
|Acceptance Status ''(Vastuvõtmise staatus)''
|Acceptance Status
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''VETaxTemplateCode'''
|'''VETaxTemplateCode'''
|
|Tarnija maksumall
|Vendor tax template ''(Tarnija maksumall)''
|Vendor tax template
|Code String
|Code String
|-
|-
|'''SelfBilling'''
|'''SelfBilling'''
|
|Isearveldus
|Self billing ''(Isearveldus)''
|Self billing
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''FiscalFlag'''
|'''FiscalFlag'''
|
|Fiskaalarve
|Fiscal invoice ''(Fiskaalarve)''
|Fiscal invoice
|As Bool but displayed as a Checkbox
|As Bool but displayed as a Checkbox
|-
|-
|'''VATFrRate'''
|'''VATFrRate'''
|
|VAT kurss
|VAT rate ''(VAT kurss)''
|VAT rate
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''VATToRateB1'''
|'''VATToRateB1'''
|
|VAT kurss Baasvaluuta 1 suhtes
|VAT rate to B1 ''(VAT kurss Baasvaluuta 1 suhtes)''
|VAT rate to B1
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''VATToRateB2'''
|'''VATToRateB2'''
|
|VAT kurss Baasvaluuta 2 suhtes
|VAT rate to B2 ''(VAT kurss Baasvaluuta 2 suhtes)''
|VAT rate to B2
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''VATBaseRate1'''
|'''VATBaseRate1'''
|
|Baasvaluuta 1
|B1 rate ''(Baasvaluuta 1)''
|B1 rate
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''VATBaseRate2'''
|'''VATBaseRate2'''
|
|Baasvaluuta 2
|B2 rate ''(Baasvaluuta 2)''
|B2 rate
|Value with 6 Decimals
|Value with 6 Decimals
|-
|-
|'''Addr1'''
|'''Addr1'''
|
|Aadress rida 1
|Address line 1 ''(Aadress rida 1)''
|Address line 1
|String
|String
|-
|-
|'''Addr2'''
|'''Addr2'''
|
|Address line 2
|Address line 2 (''Address line 2)''
|Address line 2
|String
|String
|-
|-
|'''Addr3'''
|'''Addr3'''
|
|Address line 3
|Address line 3 (''Address line 3)''
|Address line 3
|String
|String
|-
|-
|'''InvAddr3'''
|'''InvAddr3'''
|
|Arveaadressi rida 3
|Invoice address line 3 ''(Arveaadressi rida 3)''
|Invoice address line 3
|String
|String
|-
|-
|'''InvAddr4'''
|'''InvAddr4'''
|
|Arveaadressi rida 4
|Invoice address line 4 ''(Arveaadressi rida 4)''
|Invoice address line 4
|String
|String
|-
|-
|'''InvCountry'''
|'''InvCountry'''
|
|Arve riik
|Invpice country ''(Arve riik)''
|Invpice country
|Code String
|Code String
|-
|-
|'''Phone'''
|'''Phone'''
|
|Telefon
|Phone ''(Telefon)''
|Phone
|String with phone-number
|String with phone-number
|-
|-
|'''Fax'''
|'''Fax'''
|
|Faks
|Fax ''(Faks)''
|Fax
|String
|String
|-
|-
|'''CAEAFlag'''
|'''CAEAFlag'''
|
|CAEA
|CAEA flag. 0=no; 1=yes. ''(CAEA ei/jah)''
|CAEA flag. 0=no; 1=yes.
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''PRCode'''
|'''PRCode'''
|
|Projekti kood
|Project code ''(Projekti kood)''
|Project code
|Code String
|Code String
|-
|-
|'''OrgVE'''
|'''OrgVE'''
|
|Org. hankija
|Org. Supp. ''(Org. hankija)''
|Org. Supp.
|Code String
|Code String
|-
|-
|'''AcceptanceBy'''
|'''AcceptanceBy'''
|
|Kinnitaja(d
|Approval By ''(Kinnitaja(d))''
|Approval By
|Comma separated List
|Comma separated List
|-
|-
|'''AcceptanceFYI'''
|'''AcceptanceFYI'''
|
|Teadmiseks
|Acceptance FYI ''(Teadmiseks)''
|Acceptance FYI
|Comma separated List
|Comma separated List
|-
|-
|'''PaymentCode'''
|'''PaymentCode'''
|
|Tasumise kood
|Payment Code ''(Tasumise kood)''
|Payment Code
|Code String
|Code String
|-
|-
|'''VELegalForm'''
|'''VELegalForm'''
|
|Juriidiline vorm
|Legal Form ''(Juriidiline vorm)''
|Legal Form
|Code String
|Code String
|-
|-
|'''pdays'''
|'''pdays'''
|
|Neto päevi
|Net Days ''(Neto päevi)''
|Net Days
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''Attach'''
|'''Attach'''
|Manus
|Attachment
|
|-
!Maatriks
|
|
|Attachment ''(Manus)''
|
|
|-
!
! colspan="4" |Maatriks
|-
|-
|'''stp'''
|'''stp'''
|
|
|Row type ''(rea tüüp)''
|Row type
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''ovst'''
|'''ovst'''
|
|
|Row deleted, red line ''(rida kustutatud, punane joon peal)''
|Row deleted, red line
|Small Value with No Decimals
|Small Value with No Decimals
|-
|-
|'''AccNumber'''
|'''AccNumber'''
|
|Konto number
|A/C ''(Konto number)''
|A/C
|Code String
|Code String
|-
|-
|'''Objects'''
|'''Objects'''
|
|Objektid
|Objects ''(Objektid)''
|Objects
|Capital Characters Only
|Capital Characters Only
|-
|-
|'''Comment'''
|'''Comment'''
|
|Kommentaar
|Comment ''(Kommentaar)''
|Comment
|String
|String
|-
|-
|'''Sum'''
|'''Sum'''
|
|Summa
|Sum ''(Summa)''
|Sum
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''Item'''
|'''Item'''
|
|artikkel
|Item ''(artikkel)''
|Item
|Code String
|Code String
|-
|-
|'''qty'''
|'''qty'''
|
|Kogus
|Quantity ''(Kogus)''
|Quantity
|Value with minimum Decimals
|Value with minimum Decimals
|-
|-
|'''PRCode'''
|'''PRCode'''
|
|Projekti kood
|Project ''(Projekti kood)''
|Project
|Code String
|Code String
|-
|-
|'''VATCode'''
|'''VATCode'''
|
|Käibemaksukood
|VAT Code ''(Käibemaksukood)''
|VAT Code
|Code String
|Code String
|-
|-
|'''VEPNr'''
|'''VEPNr'''
|
|
|Prepayment flag. 0=no; 1=yes ''(Ettemaksu jah/ei)''
|Prepayment flag. 0=no; 1=yes
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''PrepayNr'''
|'''PrepayNr'''
|
|ettemaksu nr
|Prepayment no. ''(ettemaksu nr)''
|Prepayment no.
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''PrepayAmount'''
|'''PrepayAmount'''
|
|Ettemaksu summa
|Prepayment amount ''(Ettemaksu summa)''
|Prepayment amount
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''OrdRow'''
|'''OrdRow'''
|
|
|Ord. Row. (Hidden) ''(Tellimuse rida, peidetud)''
|Ord. Row. (Hidden)
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''VATVal'''
|'''VATVal'''
|
|KM summa
|VAT amount ''(KM summa)''
|VAT amount
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
|'''PeriodCode'''
|'''PeriodCode'''
|
|Periodiseerimise mudel
|Accrual ''(Periodiseerimise mudel)''
|Accrual
|Code String
|Code String
|-
|-
|'''ACShort'''
|'''ACShort'''
|
|Konto lühikood
|Short code (A/C) ''(Konto lühikood)''
|Short code (A/C)
|Code String
|Code String
|-
|-
|'''PUNr'''
|'''PUNr'''
|
|Laosissetuleku nr
|GR No. ''(Laosissetuleku nr)''
|GR No.
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''PURow'''
|'''PURow'''
|
|
|GR Row ''(Laosissetuleku rida)''
|GR Row
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''VarianceAmount'''
|'''VarianceAmount'''
|
|Erinevus
|Price Var. ''(Erinevus)''
|Price Var.
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|-
|-
635. rida: 826. rida:
|-
|-
|'''TAX2Prc'''
|'''TAX2Prc'''
|
|Piirkonnapõhine maks
|Perception Tax ''(Piirkonnapõhine maks)''
|Perception Tax
|Value with 2 or 3 Decimals
|Value with 2 or 3 Decimals
|-
|-
|'''PONr'''
|'''PONr'''
|
|Ostutellimuse nr
|Purch. Ord. No. ''(Ostutellimuse nr)''
|Purch. Ord. No.
|Value with No Decimals
|Value with No Decimals
|-
|-
|'''StockType'''
|'''StockType'''
|
|Ladu
|Stock ''(Ladu)''
|Stock
|Int represented by a Set of String
|Int represented by a Set of String
|-
|-
|'''SerialNr'''
|'''SerialNr'''
|
|Seerianumber
|Serial no. ''(Seerianumber)''
|Serial no.
|String
|String
|-
|-
|'''WHTax'''
|'''WHTax'''
|
|Kinnipidamismaks
|Withh. Tax ''(Kinnipidamismaks)''
|Withh. Tax
|Code String
|Code String
|-
|-
|'''TaxTemplateCode'''
|'''TaxTemplateCode'''
|
|maksumall
|Tax template code ''(maksumall)''
|Tax template code
|Capital Characters Only
|Capital Characters Only
|-
|-
|'''InventoryNr'''
|'''InventoryNr'''
|
|Inventaarinumber
|Inventory No. ''(Inventaarinumber)''
|Inventory No.
|String
|String
|-
|-
|'''AssetTransType'''
|'''AssetTransType'''
|
|PV kande tüüp
|Asset transaction type ''(PV kande tüüp)''
|Asset transaction type
|Int represented by a Set of String
|Int represented by a Set of String
|-
|-
|'''OrderType'''
|'''OrderType'''
|
|Order type (Tellimuse tüüp
|Order type ''(Tellimuse tüüp)''
|Order type
|Int represented by a Set of String
|Int represented by a Set of String
|}
|}

Viimane redaktsioon: 18. september 2018, kell 11:26

Hausing - Pealeht

Register

<data> element peab sisaldama:

  • register="VIVc"

Ostuarved hausing.png

Toetatud väljad

Päis

Kood Kasutajaliides väli Kirjeldus Kohustuslik Tüüp Kommentaar
InvDate Ostuarve kuupäev Purchase invoice date + In Dataformat Order
PayVal Summa kokku Sum total + Value 2 or 3 Decimals Koos KM
InvoiceNr Hankija arve number Supplier invoice number String Ei ole lubatud sama tarnija arve number erinevatel ostuarvetel, kui on Ostuarved - Seadistused - Lausendamine, ostud - linnuke "Ära luba sama tarnija arvenr-ga arveid". Toimub RecordCheck error.
OKFlag Kinnitatud. 0=ei, 1=jah OKed flag. 0=No; 1=Yes. + As Bool but displayed as a Checkbox
PayDeal Tasumistingimus Payment terms + Code String
VECode Hankija Supplier + Code String
VEName Nimi Name (Supplier) String Täidetakse automaatselt VECode asetamisel, asendatakse kui väli on XMLis antud.
DueDate Tähtaeg Due date In Dataformat Order Arvutatakse automaatselt PayDeal asetamisel, asendatakse kui väli on XMLis antud.
BankAcc Pangakonto, IBAN Bank Account + String
TransDate Kande kuupäev Transaction date In Dataformat Order Arvutatakse automaatselt InvDate asetamisel, asendatakse kui väli on XMLis antud.
InvType Arve tüüp (Tavaline, kreedit jne. 1=tavaline) Invoice type flag Small Value with No Decimals Ei POSTita seda välja enam, muutub automaatselt
VATVal Käibemaks VAT sum Value 2 or 3 Decimals Käibemaksu summa, arvutatakse automaatselt vastavalt seadistusele Ostuarved - Seadistused - Ostuarvete seadistus - KM %. Kui kasutusel erinevad KM koodid teiste %-ga, siis vaja päringus saata vastav väärtus, mis kirtjuab automaatselt arvutatud väärtust üle (vastasel juhul ei luba programm salvestada kuna Kandes on vahe)

Maatriks

Kood Kasutajaliides väli Kirjeldus Kohustuslik Tüüp Kommentaar
stp Rea tüüp (1=tavaline) + Small Value with No Decimals
ovst Tühistatud rida jah=1/ei=0 Small Value with No Decimals ei ole kohustuslik, vaikimisi alati 0
AccNumber Konto number A/C + Code String
Comment Kommentaar Comment String Täidetakse automaatselt AccNumber asetamisel, asendatakse kui väli on XMLis antud.
Sum Summa Sum + Value 2 or 3 Decimals Ilma KM-ta
Item artikkel Item Code String
qty Kogus Quantity Value with minimum Decimals
VATCode Käibemaksukood VAT Code + Code String

Näidis XML päring

<?xml version="1.0" encoding="UTF-8"?>
<data register="VIVc" method="create" sequence="106357" systemversion="8.4.20.504">
  <VIVc>
    <TransDate>2018-08-20</TransDate> <!-- note - here TransDate is overridden, not similar to InvDate -->
    <InvDate>2018-08-22</InvDate>
    <PayVal>120.00</PayVal>
    <PayDeal>5</PayDeal>
    <VECode>102</VECode>
    <BankAcc>EE123456789</BankAcc>
    <OKFlag>0</OKFlag>
    <InvoiceNr>45655665</InvoiceNr>
    <VEName>Override default vendor name</VEName>
    <DueDate>2018-09-22</DueDate> <!-- note - here DueDate is overridden, 5 days given by PayDeal -->
    <rows>
      <row rownumber="0">
        <stp>1</stp>
        <AccNumber>1010</AccNumber>
        <Sum>100</Sum>
        <VATCode>1</VATCode>
        <Comment>Override default account comment</Comment>
        <Item>001</Item>
        <qty>3</qty>
      </row>
    </rows>
  </VIVc>
</data>

Kõigi XML väljade kirjeldused

Kood Kasutajaliides väli Kirjeldus Tüüp
SerNr Ostuarve number Purchase invoice number Value with No Decimals
InvDate Ostuarve kuupäev Purchase invoice date In Dataformat Order
PayVal Summa kokku Sum total Value 2 or 3 Decimals
RegDate Koostatud kuupäeval Created date In Dataformat Order
InvoiceNr Hankija arve number Supplier invoice number String
OKFlag Kinnita linnuke OKed flag. 0=No; 1=Yes. As Bool but displayed as a Checkbox
PayDeal Tasumistingimus Payment terms Code String
VECode Hankija Supplier Code String
VEName Nimi Name (Supplier) String
DueDate Tähtaeg Due date In Dataformat Order
RebDate Kassa-ale kuupäev Discount date In Dataformat Order
RefStr Viide Reference String
BankAcc Pangakonto, IBAN Bank Account String
Sign Müügimees Salesman / Creator name Code String
RebVal Kassa-ale summa Discount Value 2 or 3 Decimals
TransDate Kande kuupäev Transaction date In Dataformat Order
InvType Arve tüüp Invoice type flag Small Value with No Decimals
VATVal Käibemaks VAT Value 2 or 3 Decimals
APAcc Ostuvõlgade konto Creditors AC Code String
VEFactoring Faktooring Factoring Code String
BankName Panga nimi Bank Name String
OKPersons Kinnitajad Signers Capital Characters Only
CurncyCode Valuuta Currency Code String
ToRateB1 B1 kurss B1 rate Value with 6 Decimals
ExportFlag Käibemaksutsoon VAT zone Small Value with No Decimals
VEVatCode Tarnija VAT number Vendor VAT code Code String
Comment Kirjeldus Comment String
CalcVATVal VAT arvutatud VAT, calculated Value 2 or 3 Decimals
Closed Suletud linnuke Closed flag Small Value with No Decimals
Objects Objektid Objects Capital Characters Only
PrelBook Eelkonteeritud Pre Booked Small Value with No Decimals
BankCode Pangakood Bank code String
CredInv Krediteeritud arve number Credited invoice number Value with No Decimals
xStatFlag Not used. Always empty Small Value with No Decimals
CORefStr Ettevõtte viide, kasutavad riigiasutused Company`s Reference String
ExportedFlag Exported flag. 0=no; 1=yes Small Value with No Decimals
POSerNr Ostutellimuse number Purchase Order number Value with No Decimals
FrRate Kurss Rate Value with 6 Decimals
ToRateB2 Kurss baasvaluuta 2 suhtes Rate to Base currency 2 Value with 6 Decimals
BaseRate1 Baasvaluuta 1 Base currency 1 Value with 6 Decimals
BaseRate2 Baasvaluuta 2 Base currency 2 Value with 6 Decimals
CredMark Credit invoice flag. 0=no; 1=yes String
APonTR Info kande E osale Supplier info on transit flag. . 0=no; 1=yes Small Value with No Decimals
Invalid Invalid flag. 0=no; 1=yes Small Value with No Decimals
VATNr KMKR nr VAT no. String
LangCode Keel Language code Code String
InstallmentInv Osalise makes nr Partial payment no Small Value with No Decimals
POCQStatNr Ostuprotsess P/O Process No Value with No Decimals
SortCode Sorteerimiskood Sort code String
SalesGroup Müügigrupp Sales Group Code String
SalesMan Meie esindaja, müügimees Sales Person Code String
POCOSerNr Ostuleping Purchase contract no Value with No Decimals
HoldSum Ootel summa Hold amount Value 2 or 3 Decimals
DiffVal B1 erinevus Base 1 Difference Value 2 or 3 Decimals
BarCode ribakood Bar code String
StatVal Stat. väärtus Stat. Value Value 2 or 3 Decimals
xAcceptanceState Not used. Always empty Small Value with No Decimals
xAcceptanceGroup Not used. Always empty Code String
WithHoldingTax Kin.maks Withh. Tax Value 2 or 3 Decimals
SupCurVal Ostuval. Summa Cur. Sum Value 2 or 3 Decimals
RcvDate Vastuvõtmiskuupäev Receiving Date In Dataformat Order
TAX1Sum Maksu summa Tax  sum Value 2 or 3 Decimals
ServiceDelDate Teenuse lähetamiskuupäev Service Del. Date In Dataformat Order
OfficialSerNr Ametlik seerianumber Official serial number String
TAX2Sum Maks2 Tax2 Value 2 or 3 Decimals
RebDate2 Kassa-ale 2 kuupäev Discount 2 date In Dataformat Order
TaxAuthID Maksuameti  ID Tax Auth. ID String
TaxAuthIDCC Kontrollkood Control code String
BranchID Filiaal Branch Code String
NoTAXonVAT Arvuta lisamaks summast ilma käibemaksuta Calculate Ext. Tax on Sum incl Value with No Decimals
IVNr Arve number Invoice No. Value with No Decimals
CAE CAE CAE String
CAEExpiry CAE kehtivuskuupäev CAE exp date In Dataformat Order
Region Regioon Region Code String
OrderType tellimuse tüüp Order type Int represented by a Set of String
RebVal2 Kassa-ale 2 väärtus Discount 2 value Value 2 or 3 Decimals
AcceptanceStatus Vastuvõtmise staatus Acceptance Status Small Value with No Decimals
VETaxTemplateCode Tarnija maksumall Vendor tax template Code String
SelfBilling Isearveldus Self billing Small Value with No Decimals
FiscalFlag Fiskaalarve Fiscal invoice As Bool but displayed as a Checkbox
VATFrRate VAT kurss VAT rate Value with 6 Decimals
VATToRateB1 VAT kurss Baasvaluuta 1 suhtes VAT rate to B1 Value with 6 Decimals
VATToRateB2 VAT kurss Baasvaluuta 2 suhtes VAT rate to B2 Value with 6 Decimals
VATBaseRate1 Baasvaluuta 1 B1 rate Value with 6 Decimals
VATBaseRate2 Baasvaluuta 2 B2 rate Value with 6 Decimals
Addr1 Aadress rida 1 Address line 1 String
Addr2 Address line 2 Address line 2 String
Addr3 Address line 3 Address line 3 String
InvAddr3 Arveaadressi rida 3 Invoice address line 3 String
InvAddr4 Arveaadressi rida 4 Invoice address line 4 String
InvCountry Arve riik Invpice country Code String
Phone Telefon Phone String with phone-number
Fax Faks Fax String
CAEAFlag CAEA CAEA flag. 0=no; 1=yes. Small Value with No Decimals
PRCode Projekti kood Project code Code String
OrgVE Org. hankija Org. Supp. Code String
AcceptanceBy Kinnitaja(d Approval By Comma separated List
AcceptanceFYI Teadmiseks Acceptance FYI Comma separated List
PaymentCode Tasumise kood Payment Code Code String
VELegalForm Juriidiline vorm Legal Form Code String
pdays Neto päevi Net Days Value with No Decimals
Attach Manus Attachment
Maatriks
stp Row type Small Value with No Decimals
ovst Row deleted, red line Small Value with No Decimals
AccNumber Konto number A/C Code String
Objects Objektid Objects Capital Characters Only
Comment Kommentaar Comment String
Sum Summa Sum Value 2 or 3 Decimals
Item artikkel Item Code String
qty Kogus Quantity Value with minimum Decimals
PRCode Projekti kood Project Code String
VATCode Käibemaksukood VAT Code Code String
VEPNr Prepayment flag. 0=no; 1=yes Value with No Decimals
PrepayNr ettemaksu nr Prepayment no. Value with No Decimals
PrepayAmount Ettemaksu summa Prepayment amount Value 2 or 3 Decimals
OrdRow Ord. Row. (Hidden) Value with No Decimals
VATVal KM summa VAT amount Value 2 or 3 Decimals
PeriodCode Periodiseerimise mudel Accrual Code String
ACShort Konto lühikood Short code (A/C) Code String
PUNr Laosissetuleku nr GR No. Value with No Decimals
PURow GR Row Value with No Decimals
VarianceAmount Erinevus Price Var. Value 2 or 3 Decimals
POCORow Value with No Decimals
TAX2Prc Piirkonnapõhine maks Perception Tax Value with 2 or 3 Decimals
PONr Ostutellimuse nr Purch. Ord. No. Value with No Decimals
StockType Ladu Stock Int represented by a Set of String
SerialNr Seerianumber Serial no. String
WHTax Kinnipidamismaks Withh. Tax Code String
TaxTemplateCode maksumall Tax template code Capital Characters Only
InventoryNr Inventaarinumber Inventory No. String
AssetTransType PV kande tüüp Asset transaction type Int represented by a Set of String
OrderType Order type (Tellimuse tüüp Order type Int represented by a Set of String

Näidis XML päring

<?xml version="1.0" encoding="UTF-8"?>
<data>
   <register name="VIVc">
      <record>
         <head>
            <SerNr />
            <InvDate />
            <PayVal />
            <RegDate />
            <InvoiceNr />
            <OKFlag />
            <PayDeal />
            <VECode />
            <VEName />
            <DueDate />
            <RebDate />
            <RefStr />
            <BankAcc />
            <Sign />
            <RebVal />
            <TransDate />
            <InvType />
            <VATVal />
            <APAcc />
            <VEFactoring />
            <BankName />
            <OKPersons />
            <CurncyCode />
            <ToRateB1 />
            <ExportFlag />
            <VEVatCode />
            <Comment />
            <CalcVATVal />
            <Closed />
            <Objects />
            <PrelBook />
            <BankCode />
            <CredInv />
            <xStatFlag />
            <CORefStr />
            <ExportedFlag />
            <POSerNr />
            <FrRate />
            <ToRateB2 />
            <BaseRate1 />
            <BaseRate2 />
            <CredMark />
            <APonTR />
            <Invalid />
            <VATNr />
            <LangCode />
            <InstallmentInv />
            <POCQStatNr />
            <SortCode />
            <SalesGroup />
            <SalesMan />
            <POCOSerNr />
            <HoldSum />
            <DiffVal />
            <BarCode />
            <StatVal />
            <xAcceptanceState />
            <xAcceptanceGroup />
            <WithHoldingTax />
            <SupCurVal />
            <RcvDate />
            <TAX1Sum />
            <ServiceDelDate />
            <OfficialSerNr />
            <TAX2Sum />
            <RebDate2 />
            <TaxAuthID />
            <TaxAuthIDCC />
            <BranchID />
            <NoTAXonVAT />
            <IVNr />
            <CAE />
            <CAEExpiry />
            <Region />
            <OrderType />
            <RebVal2 />
            <AcceptanceStatus />
            <VETaxTemplateCode />
            <SelfBilling />
            <FiscalFlag />
            <VATFrRate />
            <VATToRateB1 />
            <VATToRateB2 />
            <VATBaseRate1 />
            <VATBaseRate2 />
            <Addr1 />
            <Addr2 />
            <Addr3 />
            <InvAddr3 />
            <InvAddr4 />
            <InvCountry />
            <Phone />
            <Fax />
            <CAEAFlag />
            <PRCode />
            <OrgVE />
            <AcceptanceBy />
            <AcceptanceFYI />
            <PaymentCode />
            <VELegalForm />
            <pdays />
            <Attach />
         </head>
         <rows>
            <row>
               <stp />
               <ovst />
               <AccNumber />
               <Objects />
               <Comment />
               <Sum />
               <Item />
               <qty />
               <PRCode />
               <VATCode />
               <VEPNr />
               <PrepayNr />
               <PrepayAmount />
               <OrdRow />
               <VATVal />
               <PeriodCode />
               <ACShort />
               <PUNr />
               <PURow />
               <VarianceAmount />
               <POCORow />
               <TAX2Prc />
               <PONr />
               <StockType />
               <SerialNr />
               <WHTax />
               <TaxTemplateCode />
               <InventoryNr />
               <AssetTransType />
               <OrderType />
            </row>
         </rows>
      </record>
   </register>
</data>
Pärit leheküljelt "https://kaust.excellent.ee/opendoc/index.php?title=Hausing_-_Register_Ostuarved&oldid=525"