Ostuarved XML: erinevus redaktsioonide vahel

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

Redaktsioon: 7. märts 2019, kell 09:10

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

XML näidis:

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