2019-01-24T12:06:51Z

Kristel:

PUVc
https://s003.excellent.ee:1402/api/1/PUVc?sort=SerNr&range=190003
{| class="wikitable"
!Kood
!Kirjeldus
!Description
!Pikkus, formaat
|-
|SerNr
|Laosissetuleku kood
|Stock reciept code
|20, Code
|-
|RegDate
|Sisestamise kuupäev
|
|
|-
|TransDate
|Kande kuupäev
|
|
|-
|Comment
|Kommentaar
|
|
|-
|Math
|
|
|
|-
|VECode
|Tarnija kood
|
|
|-
|VEName
|Tarnija nimi
|
|
|-
|PONr
|Ostutellimuse nr
|
|
|-
|Location
|Ladu
|
|
|-
|OKFlag
|Kinnitatud
|
|
|-
|CurncyCode
|Valuuta
|
|
|-
|ToRateB1
|
|
|
|-
|InclVAT
|
|
|
|-
|SumCostPrice
|Vahesumma
|
|
|-
|SumQuant
|Kogus kokku
|
|
|-
|ShipCost
|Transport
|
|
|-
|CustomsCost
|Toll
|
|
|-
|ExtraCost
|Lisakulu
|
|
|-
|ExportedFlag
|Eksporditud
|
|
|-
|FrRate
|
|
|
|-
|ToRateB2
|
|
|
|-
|BaseRate1
|
|
|
|-
|BaseRate2
|
|
|
|-
|LocOKNr
|
|
|
|-
|Objects
|Objekt
|
|
|-
|PUClass
|Ostutellimuse klass
|
|
|-
|POCOSerNr
|Ostuleping
|
|
|-
|Cost1
|Lisakulu 1
|
|
|-
|Cost2
|Lisakulu 2
|
|
|-
|Cost3
|Lisakulu 3
|
|
|-
|Cost4
|Lisakulu 4
|
|
|-
|Cost5
|Lisakulu 5
|
|
|-
|VATVal
|Käibemaksusumma
|
|
|-
|SubTotal
|Vahesumma
|
|
|-
|PayVal
|Kokku summa
|
|
|-
|VEVATCode
|Tarnija KMKR nr
|
|
|-
|Invalid
|
|
|
|-
|ExportFlag
|
|
|
|-
|PrelPUNr
|
|
|
|-
|FreightCode
|Tran.p.firma
|
|
|-
|FreightCompanyRegNr
|Transpordifirma Reg nr
|
|
|-
|FreightCompany
|Transp.firma nimi
|
|
|-
|TruckInfo
|Veoauto info
|
|
|-
|Driver
|Autojuht
|
|
|-
|CMRText
|
|
|
|-
|xBookVariance
|
|
|
|-
|xVarTransDate
|
|
|
|-
|LangCode
|
|
|
|-
|TAX1Sum
|
|
|
|-
|TAX2Sum
|
|
|
|-
|ShipCostRound
|
|
|
|-
|CustomsCostRound
|
|
|
|-
|Cost1Round
|
|
|
|-
|Cost2Round
|
|
|
|-
|Cost3Round
|
|
|
|-
|Cost4Round
|
|
|
|-
|Cost5Round
|
|
|
|-
|Sorting
|
|
|
|-
|InvalidDate
|
|
|
|-
|NoTAXonVAT
|
|
|
|-
|AcceptanceStatus
|
|
|
|-
|PUFromPORate
|
|
|
|-
|TotUPrice
|
|
|
|-
|VETaxTemplateCode
|
|
|
|-
|TaxMatrix
|
|
|
|-
|BranchID
|
|
|
|-
|AcceptanceBy
|
|
|
|-
|ExtraCostsCalculation
|
|
|
|-
|AcceptanceFYI
|
|
|
|-
|DispatchNumber
|
|
|
|-
|CustomsNr
|
|
|
|-
|Sign
|
|
|
|-
|SalesGroup
|
|
|
|-
|rownumber
|
|
|
|-
|ArtCode
|
|
|
|-
|Quant
|
|
|
|-
|Spec
|
|
|
|-
|UPrice
|
|
|
|-
|SerialNr
|
|
|
|-
|OrdRow
|
|
|
|-
|Extra
|
|
|
|-
|CostPrice
|
|
|
|-
|VEItemCode
|
|
|
|-
|VARList
|
|
|
|-
|ShipCost2
|
|
|
|-
|CustomsCost3
|
|
|
|-
|BestBefore
|
|
|
|-
|Coefficient
|
|
|
|-
|BasePrice
|
|
|
|-
|Sum
|
|
|
|-
|Comment4
|
|
|
|-
|Objects5
|
|
|
|-
|CostAcc
|
|
|
|-
|CredAcc
|
|
|
|-
|CustomsNr6
|
|
|
|-
|CountryOfOrg
|
|
|
|-
|PosCode
|
|
|
|-
|BatchStatus
|
|
|
|-
|UnitXval
|
|
|
|-
|UnitYval
|
|
|
|-
|UnitZval
|
|
|
|-
|RowCost1
|
|
|
|-
|RowCost2
|
|
|
|-
|RowCost3
|
|
|
|-
|RowCost4
|
|
|
|-
|RowCost5
|
|
|
|-
|VATCode
|
|
|
|-
|stp
|
|
|
|-
|ovst
|
|
|
|-
|Sign7
|
|
|
|-
|UpdDate
|
|
|
|-
|PORecon
|
|
|
|-
|POReconComment
|
|
|
|-
|VIRecon
|
|
|
|-
|VIReconComment
|
|
|
|-
|PONr8
|
|
|
|-
|BarCode
|
|
|
|-
|PrelPUNr9
|
|
|
|-
|PrelPURow
|
|
|
|-
|ToPosCode
|
|
|
|-
|UnitCode
|
|
|
|-
|VarianceAmount
|
|
|
|-
|TAX2Code
|
|
|
|-
|TAX2Prc
|
|
|
|-
|TAX2Reb
|
|
|
|-
|TAX1Reb
|
|
|
|-
|TAX2Acc
|
|
|
|-
|Location10
|
|
|
|-
|ChargeNumber
|
|
|
|-
|VEQuant
|
|
|
|-
|PIFactor
|
|
|
|-
|VEUnit
|
|
|
|-
|StockType
|
|
|
|-
|InPrice
|
|
|
|-
|SuppSerialNr
|
|
|
|-
|MajStoneDet
|
|
|
|-
|Colour
|
|
|
|-
|Clarity
|
|
|
|-
|Cert
|
|
|
|-
|MinStoneDet
|
|
|
|-
|Metal
|
|
|
|-
|RowWeight
|
|
|
|-
|Size
|
|
|
|-
|Length
|
|
|
|-
|WatchBrand
|
|
|
|-
|StyleName
|
|
|
|-
|WatchMetal
|
|
|
|-
|Movement
|
|
|
|-
|BrcStr
|
|
|
|-
|Gender
|
|
|
|-
|Other
|
|
|
|-
|Other2
|
|
|
|-
|MotherPURow
|
|
|
|-
|TaxTemplateCode
|
|
|
|-
|TaxMatrix11
|
|
|
|-
|TREO
|
|
|
|-
|DispatchNumber12
|
|
|
|-
|CustomsDate
|
|
|
|}

Laosissetulekud

2019-01-24T12:02:30Z

Kristel:

PUVc
https://s003.excellent.ee:1402/api/1/PUVc?sort=SerNr&range=190003
{| class="wikitable"
!Kood
!Kirjeldus
!Description
!Pikkus, formaat
|-
|SerNr
|Laosissetuleku kood
|Stock reciept code
|20, Code
|-
|RegDate
|Sisestamise kuupäev
|
|
|-
|TransDate
|Kande kuupäev
|
|
|-
|Comment
|Kommentaar
|
|
|-
|Math
|
|
|
|-
|VECode
|Tarnija kood
|
|
|-
|VEName
|Tarnija nimi
|
|
|-
|PONr
|Ostutellimuse nr
|
|
|-
|Location
|Ladu
|
|
|-
|OKFlag
|Kinnitatud
|
|
|-
|CurncyCode
|Valuuta
|
|
|-
|ToRateB1
|
|
|
|-
|InclVAT
|
|
|
|-
|SumCostPrice
|Vahesumma
|
|
|-
|SumQuant
|Kogus kokku
|
|
|-
|ShipCost
|Transport
|
|
|-
|CustomsCost
|Toll
|
|
|-
|ExtraCost
|Lisakulu
|
|
|-
|ExportedFlag
|Eksporditud
|
|
|-
|FrRate
|
|
|
|-
|ToRateB2
|
|
|
|-
|BaseRate1
|
|
|
|-
|BaseRate2
|
|
|
|-
|LocOKNr
|
|
|
|-
|Objects
|Objekt
|
|
|-
|PUClass
|Ostutellimuse klass
|
|
|-
|POCOSerNr
|Ostuleping
|
|
|-
|Cost1
|
|
|
|-
|Cost2
|
|
|
|-
|Cost3
|
|
|
|-
|Cost4
|
|
|
|-
|Cost5
|
|
|
|-
|VATVal
|
|
|
|-
|SubTotal
|
|
|
|-
|PayVal
|
|
|
|-
|VEVATCode
|
|
|
|-
|Invalid
|
|
|
|-
|ExportFlag
|
|
|
|-
|PrelPUNr
|
|
|
|-
|FreightCode
|
|
|
|-
|FreightCompanyRegNr
|
|
|
|-
|FreightCompany
|
|
|
|-
|TruckInfo
|
|
|
|-
|Driver
|
|
|
|-
|CMRText
|
|
|
|-
|xBookVariance
|
|
|
|-
|xVarTransDate
|
|
|
|-
|LangCode
|
|
|
|-
|TAX1Sum
|
|
|
|-
|TAX2Sum
|
|
|
|-
|ShipCostRound
|
|
|
|-
|CustomsCostRound
|
|
|
|-
|Cost1Round
|
|
|
|-
|Cost2Round
|
|
|
|-
|Cost3Round
|
|
|
|-
|Cost4Round
|
|
|
|-
|Cost5Round
|
|
|
|-
|Sorting
|
|
|
|-
|InvalidDate
|
|
|
|-
|NoTAXonVAT
|
|
|
|-
|AcceptanceStatus
|
|
|
|-
|PUFromPORate
|
|
|
|-
|TotUPrice
|
|
|
|-
|VETaxTemplateCode
|
|
|
|-
|TaxMatrix
|
|
|
|-
|BranchID
|
|
|
|-
|AcceptanceBy
|
|
|
|-
|ExtraCostsCalculation
|
|
|
|-
|AcceptanceFYI
|
|
|
|-
|DispatchNumber
|
|
|
|-
|CustomsNr
|
|
|
|-
|Sign
|
|
|
|-
|SalesGroup
|
|
|
|-
|rownumber
|
|
|
|-
|ArtCode
|
|
|
|-
|Quant
|
|
|
|-
|Spec
|
|
|
|-
|UPrice
|
|
|
|-
|SerialNr
|
|
|
|-
|OrdRow
|
|
|
|-
|Extra
|
|
|
|-
|CostPrice
|
|
|
|-
|VEItemCode
|
|
|
|-
|VARList
|
|
|
|-
|ShipCost2
|
|
|
|-
|CustomsCost3
|
|
|
|-
|BestBefore
|
|
|
|-
|Coefficient
|
|
|
|-
|BasePrice
|
|
|
|-
|Sum
|
|
|
|-
|Comment4
|
|
|
|-
|Objects5
|
|
|
|-
|CostAcc
|
|
|
|-
|CredAcc
|
|
|
|-
|CustomsNr6
|
|
|
|-
|CountryOfOrg
|
|
|
|-
|PosCode
|
|
|
|-
|BatchStatus
|
|
|
|-
|UnitXval
|
|
|
|-
|UnitYval
|
|
|
|-
|UnitZval
|
|
|
|-
|RowCost1
|
|
|
|-
|RowCost2
|
|
|
|-
|RowCost3
|
|
|
|-
|RowCost4
|
|
|
|-
|RowCost5
|
|
|
|-
|VATCode
|
|
|
|-
|stp
|
|
|
|-
|ovst
|
|
|
|-
|Sign7
|
|
|
|-
|UpdDate
|
|
|
|-
|PORecon
|
|
|
|-
|POReconComment
|
|
|
|-
|VIRecon
|
|
|
|-
|VIReconComment
|
|
|
|-
|PONr8
|
|
|
|-
|BarCode
|
|
|
|-
|PrelPUNr9
|
|
|
|-
|PrelPURow
|
|
|
|-
|ToPosCode
|
|
|
|-
|UnitCode
|
|
|
|-
|VarianceAmount
|
|
|
|-
|TAX2Code
|
|
|
|-
|TAX2Prc
|
|
|
|-
|TAX2Reb
|
|
|
|-
|TAX1Reb
|
|
|
|-
|TAX2Acc
|
|
|
|-
|Location10
|
|
|
|-
|ChargeNumber
|
|
|
|-
|VEQuant
|
|
|
|-
|PIFactor
|
|
|
|-
|VEUnit
|
|
|
|-
|StockType
|
|
|
|-
|InPrice
|
|
|
|-
|SuppSerialNr
|
|
|
|-
|MajStoneDet
|
|
|
|-
|Colour
|
|
|
|-
|Clarity
|
|
|
|-
|Cert
|
|
|
|-
|MinStoneDet
|
|
|
|-
|Metal
|
|
|
|-
|RowWeight
|
|
|
|-
|Size
|
|
|
|-
|Length
|
|
|
|-
|WatchBrand
|
|
|
|-
|StyleName
|
|
|
|-
|WatchMetal
|
|
|
|-
|Movement
|
|
|
|-
|BrcStr
|
|
|
|-
|Gender
|
|
|
|-
|Other
|
|
|
|-
|Other2
|
|
|
|-
|MotherPURow
|
|
|
|-
|TaxTemplateCode
|
|
|
|-
|TaxMatrix11
|
|
|
|-
|TREO
|
|
|
|-
|DispatchNumber12
|
|
|
|-
|CustomsDate
|
|
|
|}

Laosissetulekud

2019-01-24T12:01:41Z

Kristel:

PUVc
https://IPadress:PORT/api/compcode/PUVc
{| class="wikitable"
!Kood
!Kirjeldus
!Description
!Pikkus, formaat
|-
|SerNr
|Laosissetuleku kood
|Stock reciept code
|20, Code
|-
|RegDate
|Sisestamise kuupäev
|
|
|-
|TransDate
|Kande kuupäev
|
|
|-
|Comment
|Kommentaar
|
|
|-
|Math
|
|
|
|-
|VECode
|Tarnija kood
|
|
|-
|VEName
|Tarnija nimi
|
|
|-
|PONr
|Ostutellimuse nr
|
|
|-
|Location
|Ladu
|
|
|-
|OKFlag
|Kinnitatud
|
|
|-
|CurncyCode
|Valuuta
|
|
|-
|ToRateB1
|
|
|
|-
|InclVAT
|
|
|
|-
|SumCostPrice
|Vahesumma
|
|
|-
|SumQuant
|Kogus kokku
|
|
|-
|ShipCost
|Transport
|
|
|-
|CustomsCost
|Toll
|
|
|-
|ExtraCost
|Lisakulu
|
|
|-
|ExportedFlag
|Eksporditud
|
|
|-
|FrRate
|
|
|
|-
|ToRateB2
|
|
|
|-
|BaseRate1
|
|
|
|-
|BaseRate2
|
|
|
|-
|LocOKNr
|
|
|
|-
|Objects
|Objekt
|
|
|-
|PUClass
|Ostutellimuse klass
|
|
|-
|POCOSerNr
|Ostuleping
|
|
|-
|Cost1
|
|
|
|-
|Cost2
|
|
|
|-
|Cost3
|
|
|
|-
|Cost4
|
|
|
|-
|Cost5
|
|
|
|-
|VATVal
|
|
|
|-
|SubTotal
|
|
|
|-
|PayVal
|
|
|
|-
|VEVATCode
|
|
|
|-
|Invalid
|
|
|
|-
|ExportFlag
|
|
|
|-
|PrelPUNr
|
|
|
|-
|FreightCode
|
|
|
|-
|FreightCompanyRegNr
|
|
|
|-
|FreightCompany
|
|
|
|-
|TruckInfo
|
|
|
|-
|Driver
|
|
|
|-
|CMRText
|
|
|
|-
|xBookVariance
|
|
|
|-
|xVarTransDate
|
|
|
|-
|LangCode
|
|
|
|-
|TAX1Sum
|
|
|
|-
|TAX2Sum
|
|
|
|-
|ShipCostRound
|
|
|
|-
|CustomsCostRound
|
|
|
|-
|Cost1Round
|
|
|
|-
|Cost2Round
|
|
|
|-
|Cost3Round
|
|
|
|-
|Cost4Round
|
|
|
|-
|Cost5Round
|
|
|
|-
|Sorting
|
|
|
|-
|InvalidDate
|
|
|
|-
|NoTAXonVAT
|
|
|
|-
|AcceptanceStatus
|
|
|
|-
|PUFromPORate
|
|
|
|-
|TotUPrice
|
|
|
|-
|VETaxTemplateCode
|
|
|
|-
|TaxMatrix
|
|
|
|-
|BranchID
|
|
|
|-
|AcceptanceBy
|
|
|
|-
|ExtraCostsCalculation
|
|
|
|-
|AcceptanceFYI
|
|
|
|-
|DispatchNumber
|
|
|
|-
|CustomsNr
|
|
|
|-
|Sign
|
|
|
|-
|SalesGroup
|
|
|
|-
|rownumber
|
|
|
|-
|ArtCode
|
|
|
|-
|Quant
|
|
|
|-
|Spec
|
|
|
|-
|UPrice
|
|
|
|-
|SerialNr
|
|
|
|-
|OrdRow
|
|
|
|-
|Extra
|
|
|
|-
|CostPrice
|
|
|
|-
|VEItemCode
|
|
|
|-
|VARList
|
|
|
|-
|ShipCost2
|
|
|
|-
|CustomsCost3
|
|
|
|-
|BestBefore
|
|
|
|-
|Coefficient
|
|
|
|-
|BasePrice
|
|
|
|-
|Sum
|
|
|
|-
|Comment4
|
|
|
|-
|Objects5
|
|
|
|-
|CostAcc
|
|
|
|-
|CredAcc
|
|
|
|-
|CustomsNr6
|
|
|
|-
|CountryOfOrg
|
|
|
|-
|PosCode
|
|
|
|-
|BatchStatus
|
|
|
|-
|UnitXval
|
|
|
|-
|UnitYval
|
|
|
|-
|UnitZval
|
|
|
|-
|RowCost1
|
|
|
|-
|RowCost2
|
|
|
|-
|RowCost3
|
|
|
|-
|RowCost4
|
|
|
|-
|RowCost5
|
|
|
|-
|VATCode
|
|
|
|-
|stp
|
|
|
|-
|ovst
|
|
|
|-
|Sign7
|
|
|
|-
|UpdDate
|
|
|
|-
|PORecon
|
|
|
|-
|POReconComment
|
|
|
|-
|VIRecon
|
|
|
|-
|VIReconComment
|
|
|
|-
|PONr8
|
|
|
|-
|BarCode
|
|
|
|-
|PrelPUNr9
|
|
|
|-
|PrelPURow
|
|
|
|-
|ToPosCode
|
|
|
|-
|UnitCode
|
|
|
|-
|VarianceAmount
|
|
|
|-
|TAX2Code
|
|
|
|-
|TAX2Prc
|
|
|
|-
|TAX2Reb
|
|
|
|-
|TAX1Reb
|
|
|
|-
|TAX2Acc
|
|
|
|-
|Location10
|
|
|
|-
|ChargeNumber
|
|
|
|-
|VEQuant
|
|
|
|-
|PIFactor
|
|
|
|-
|VEUnit
|
|
|
|-
|StockType
|
|
|
|-
|InPrice
|
|
|
|-
|SuppSerialNr
|
|
|
|-
|MajStoneDet
|
|
|
|-
|Colour
|
|
|
|-
|Clarity
|
|
|
|-
|Cert
|
|
|
|-
|MinStoneDet
|
|
|
|-
|Metal
|
|
|
|-
|RowWeight
|
|
|
|-
|Size
|
|
|
|-
|Length
|
|
|
|-
|WatchBrand
|
|
|
|-
|StyleName
|
|
|
|-
|WatchMetal
|
|
|
|-
|Movement
|
|
|
|-
|BrcStr
|
|
|
|-
|Gender
|
|
|
|-
|Other
|
|
|
|-
|Other2
|
|
|
|-
|MotherPURow
|
|
|
|-
|TaxTemplateCode
|
|
|
|-
|TaxMatrix11
|
|
|
|-
|TREO
|
|
|
|-
|DispatchNumber12
|
|
|
|-
|CustomsDate
|
|
|
|}

Laosissetulekud

2019-01-24T11:04:39Z

Kristel: Uus lehekülg: 'PUVc <nowiki>https://IPadress:PORT/api/compcode/PUVc</nowiki>'

PUVc
<nowiki>https://IPadress:PORT/api/compcode/PUVc</nowiki>

Esileht

2019-01-24T10:54:31Z

Kristel:

=== Standard Books ===
{| class="wikitable"
!Dokument
!Dokumnendi nimi
!Kommentaar
|-
|Rest Api kasutamine, sissejuhatus
|[https://partners.hansaworld.com/restapi-docs HansaWorldi loodud dok, ENG]
|
|-
|Rest Api registrite loetelu
|[[Rest Api registrite loetelu|Kõik registrid Standard Booksis]]
|Kõik StandardBooksi registrid ja seadistused, mis on päritavad veebiliidese kaudu.
[[Päringute näidislingid|Päringute näidislingid demo pihta]]
|-
|Registrite kirjeldused
|[[Arved XML|Arved]]
|
|-
|
|[[Ostuarved XML|Ostuarved]]
|
|-
|
|[[Kontaktid XML|Kontaktid]]
|
|-
|
|[[Objektid XML|Objektid]]
|
|-
|
|[[Kontod XML|Kontod]]
|
|-
|
|[[Artiklid XML|Artiklid]]
|
|-
|
|[[Müügitellimused|Tellimused]]
|
|-
|
|[[Laoseis XML|Laoseis]]
|
|-
|
|[[Ostutellimused XML|Ostutellimused]]
|
|-
|
|Lepingud (to do)
|
|-
|
|[[Tasumistingimused XML|Tasumistingimused]]
|
|-
|
|[[Käibemaksukoodid]]
|
|-
|
|Kliendiklassid (to do)
|
|-
|
|Artikliklassid (to do)
|
|-
|
|[[Artikli klassifikaatorid]]
|
|-
|
|[[Hausing - Register Kanded|Kanded]]
|
|-
|
|Lähetusaadressid (to do)
|
|-
|
|[[Laekumata arvete nimekiri|Laekumata arvete nimekiri (Müügirestkontro aruanne XMLis)]]
|
|-
|
|[[Hausing - Register Isikud|Isikud]]
|
|-
|
|[[Hausing - Register Laekumised|Laekumised]]
|
|-
|
|[[Hausing - Register Tasumised|Tasumised]]
|
|-
|
|[[Hausing - Ettevõtte andmed|Ettevõtte andmed]]
|
|-
|
|[[Ettevõtete register]]
|
|-
|
|[[Laosissetulekud]]
|
|}
Valik Booksiga liidestatud süsteemide andmete formaatidest
{| class="wikitable"
!Liidestuse arendused
|-
|[[Hausing|Hausing - GET/POST päringute kirjeldused]]
|-
|[[UKU & Standard Books'i API]]
|}
{| class="wikitable"
!Dokumendimallid
|-
|[[POS tshekk. 80 mm printerile]]
|-
|
|}