Laosissetulekud: erinevus redaktsioonide vahel

Allikas: Excellent || Opendoc
Mine navigeerimisribale Mine otsikasti
Resümee puudub
Resümee puudub
217. rida: 217. rida:
|-
|-
|PrelPUNr
|PrelPUNr
|
|N/A
|
|N/A
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
253. rida: 253. rida:
|xBookVariance
|xBookVariance
|N/A
|N/A
|
|N/A
|0, As Bool but displayed as a Checkbox
|0, As Bool but displayed as a Checkbox
|-
|-
|xVarTransDate
|xVarTransDate
|N/A
|N/A
|
|N/A
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
273. rida: 273. rida:
|TAX2Sum
|TAX2Sum
|N/A
|N/A
|
|N/A
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|ShipCostRound
|ShipCostRound
|N/A
|N/A
|
|N/A
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|CustomsCostRound
|CustomsCostRound
|N/A
|N/A
|
|N/A
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|Cost1Round
|Cost1Round
|N/A
|N/A
|
|N/A
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|Cost2Round
|Cost2Round
|N/A
|N/A
|
|N/A
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|Cost3Round
|Cost3Round
|N/A
|N/A
|
|N/A
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|Cost4Round
|Cost4Round
|N/A
|N/A
|
|N/A
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|Cost5Round
|Cost5Round
|N/A
|N/A
|
|N/A
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|Sorting
|Sorting
|N/A
|N/A
|
|N/A
|20, String
|20, String
|-
|-
|InvalidDate
|InvalidDate
|N/A
|N/A
|
|N/A
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|NoTAXonVAT
|NoTAXonVAT
|N/A
|N/A
|
|N/A
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
337. rida: 337. rida:
|-
|-
|TotUPrice
|TotUPrice
|
|Summa KM-ta (ilma transport, tool)
|
|Total without customs, tranasport
|
|0, Value 2 or 3 Decimals
|-
|-
|VETaxTemplateCode
|VETaxTemplateCode
|N/A
|
|
|
|10, Code String
|
|-
|-
|TaxMatrix
|TaxMatrix
|N/A
|
|
|
|0, Packed Matrix, base64 data
|
|-
|-
|BranchID
|BranchID
|N/A
|
|
|
|20, Code String
|
|-
|-
|AcceptanceBy
|AcceptanceBy
|N/A
|
|
|
|200, Comma separated List
|
|-
|-
|ExtraCostsCalculation
|ExtraCostsCalculation
|N/A
|
|
|
|0, Small Value with No Decimals
|
|-
|-
|AcceptanceFYI
|AcceptanceFYI
|N/A
|
|
|
|200, VETaxTemplateCode
|
|-
|-
|DispatchNumber
|DispatchNumber
|N/A
|
|
|
|60, VETaxTemplateCode
|
|-
|-
|CustomsNr
|CustomsNr
387. rida: 387. rida:
|-
|-
|SalesGroup
|SalesGroup
|N/A
|
|
|
|5, Code String
|
|-
|-
|rownumber
|rownumber

Redaktsioon: 1. veebruar 2019, kell 09:43

PUVc

https://s003.excellent.ee:1402/api/1/PUVc?sort=SerNr&range=190003
Kood Kirjeldus Description Pikkus, formaat
SerNr Laosissetuleku kood Stock reciept code 0, Value with No Decimals
RegDate Sisestamise kuupäev Posting Date 0, In Dataformat Order
TransDate Kande kuupäev Transaction date 0, In Dataformat Order
Comment Kommentaar Comments 60, String
Math Ei kasutata, alati tühi
VECode Tarnija kood Supplier code 20, Code String
VEName Tarnija nimi Supplier name 60, String
PONr Ostutellimuse nr Purchase Order No 0, Value with No Decimals
Location Ladu Warehouse 10, Code string
OKFlag Kinnitatud (0=ei; 1=jah) Approved (0=ei; 1=jah) 0, As Bool but displayed as a Checkbox
CurncyCode Valuuta Currency 5, Code string
ToRateB1 Kurss B1 suhtes Course B1 0, Value with 6 Decimals
InclVAT Hind KM-ga (0=ei; 1=jah) Price with VAT (0 = no; 1 = yes) 0, Small Value with No Decimals
SumCostPrice Vahesumma Subtotal 0, Value with All Decimals
SumQuant Kogus kokku Total amount 0, Value with minimum Decimals
ShipCost Transport Transport 0, Value with minimum Decimals
CustomsCost Toll Custom 0, Value with minimum Decimals
ExtraCost Lisakulu Additional cost 0, Value with minimum Decimals
ExportedFlag Eksporditud (0=ei; 1=jah) Exported (0 = no; 1 = yes) 0, Small Value with No Decimals
FrRate Kurss B1-te Course B1 0, Value with 6 Decimals
ToRateB2 Kurss B2-te Course B2 0, Value with 6 Decimals
BaseRate1 B1 kurss Course B1 0, Value with 6 Decimals
BaseRate2 B2 kurss Course B2 0, Value with 6 Decimals
LocOKNr N/A N/A 0, Value with minimum Decimals
Objects Objekt Object 60, Capital Characters Only
PUClass Ostutellimuse klass Purchase Order Class 10, Code string
POCOSerNr Ostuleping Purchase Agreement 0, Value with No Decimals
Cost1 Lisakulu 1 Additional cost 1 0, Value with minimum Decimals
Cost2 Lisakulu 2 Additional cost 2 0, Value with minimum Decimals
Cost3 Lisakulu 3 Additional cost 3 0, Value with minimum Decimals
Cost4 Lisakulu 4 Additional cost 4 0, Value with minimum Decimals
Cost5 Lisakulu 5 Additional cost 5 0, Value with minimum Decimals
VATVal Käibemaksusumma Amount of VAT 0, Value 2 or 3 Decimals
SubTotal Vahesumma Subtotal 0, Value 2 or 3 Decimals
PayVal Kokku summa Total amount 0, Value 2 or 3 Decimals
VEVATCode Tarnija KMKR nr Supplier VAT no 10, Code string
Invalid N/A 0, Small Value with No Decimals
ExportFlag Käibemaksutsoon

0 = „Eesti“

1 = „EL“,

2 = „EL (konteeri KM)“,

3 = „Mitte EL“

4 = „Mitte EL (konteeri KM)

VAT zone

0 = „Estonia“

1 = „EL“,

2 = „EL (konvert VAT)“,

3 = „NOT EL“

4 = „NOT EL (konvert KM)

0, Small Value with No Decimals
PrelPUNr N/A N/A 0, Value with No Decimals
FreightCode Transp.firma Transport company 5, Code string
FreightCompanyRegNr Transpordifirma Reg nr Transport Company Registration No 60, String
FreightCompany Transp.firma nimi The name of the transport company 60, String
TruckInfo Veoauto info Truck info 60, String
Driver Autojuht Driver 60, String
CMRText CMR väli 60, String
xBookVariance N/A N/A 0, As Bool but displayed as a Checkbox
xVarTransDate N/A N/A 0, In Dataformat Order
LangCode Keel Language 5, Code string
TAX1Sum Lisamaks 0, Value 2 or 3 Decimals
TAX2Sum N/A N/A 0, Value 2 or 3 Decimals
ShipCostRound N/A N/A 0, Value with minimum Decimals
CustomsCostRound N/A N/A 0, Value with minimum Decimals
Cost1Round N/A N/A 0, Value with minimum Decimals
Cost2Round N/A N/A 0, Value with minimum Decimals
Cost3Round N/A N/A 0, Value with minimum Decimals
Cost4Round N/A N/A 0, Value with minimum Decimals
Cost5Round N/A N/A 0, Value with minimum Decimals
Sorting N/A N/A 20, String
InvalidDate N/A N/A 0, In Dataformat Order
NoTAXonVAT N/A N/A 0, Value with No Decimals
AcceptanceStatus Kinnituse hetkeseis Confirmation status 443, Int represented by a Set of String
PUFromPORate Laosissetulek koostatud Ostutellimusest Inventory income is made from Purchase Order 460, Int represented by a Set of String
TotUPrice Summa KM-ta (ilma transport, tool) Total without customs, tranasport 0, Value 2 or 3 Decimals
VETaxTemplateCode N/A 10, Code String
TaxMatrix N/A 0, Packed Matrix, base64 data
BranchID N/A 20, Code String
AcceptanceBy N/A 200, Comma separated List
ExtraCostsCalculation N/A 0, Small Value with No Decimals
AcceptanceFYI N/A 200, VETaxTemplateCode
DispatchNumber N/A 60, VETaxTemplateCode
CustomsNr Tolli nr CustomsNo 30, String
Sign Koostaja Compiler 10, Code String
SalesGroup N/A 5, Code String
rownumber Rida 0 Row = 0
ArtCode Artiklikood Article code 20, Code String
Quant Kogus Amount 0, Value with minimum Decimals
Spec Nimetus Specification 100, String
UPrice Ühikuhind Price per unit 0, Value with All Decimals
SerialNr Seerianumber Serial number 60, String
OrdRow Ostutellimuse rida Purchase Order Line 0, Value with No Decimals
Extra Lisakulu (realt) 20
CostPrice Ostuhind/FIFO Purchase price / FIFO 0, Value with All Decimals
VEItemCode Hankija artiklikood (Hank.art) Supplier article code 20, String
VARList
ShipCost Transpordi kulu rea kohta Transport cost per row 0, Value with All Decimals
CustomsCost Toll rea kohta Customs per row
BestBefore Parim enne Best before 0, In Dataformat Order
Coefficient Koefitsent Coefficient 0, Value with All Decimals
BasePrice Baashind Base Price 0, Value with 2 or 3 Decimals
Sum Summa Total 0, Value with All Decimals
Comment Kommentaar Comments row 30, String
Objects Objekt Object row 60, Capital Characters Only
CostAcc Laokonto Stockaccount 10, Capital Characters Only
CredAcc Laovahekonto Stock 10, Capital Characters Only
CustomsNr Tolli nr CustomsNo 30, String
CountryOfOrg Päritolumaa Country of origin 5, Code String
PosCode Asukohast Location 20, Code String
BatchStatus Partii hetkeseis Batch Current Status 20, Code String
UnitXval Laius Width 0, Value with minimum Decimals
UnitYval Kõrgus Height 0, Value with minimum Decimals
UnitZval Sügavus Depth 0, Value with minimum Decimals
RowCost1 Kulu 1 Cost 1 0, Value with minimum Decimals
RowCost2 Kulu 2 Cost 2 0, Value with minimum Decimals
RowCost3 Kulu 3 Cost 3 0, Value with minimum Decimals
RowCost4 Kulu 4 Cost 4 0, Value with minimum Decimals
RowCost5 Kulu 5 Cost 5 0, Value with minimum Decimals
VATCode Käibemaksukood (KM-k) VATCode 10, Code String
stp
ovst
Sign7
UpdDate
PORecon
POReconComment
VIRecon
VIReconComment
PONr8
BarCode
PrelPUNr9
PrelPURow
ToPosCode Asukohta To location 20, Code String
UnitCode Ühik Unit 5, Code String
VarianceAmount
TAX2Code
TAX2Prc
TAX2Reb
TAX1Reb
TAX2Acc
Location Ladu (ridadelt) Stock row 10, Code String
ChargeNumber
VEQuant H.kogus 0, Value with minimum Decimals
PIFactor
VEUnit
StockType Lao tüüp StockType 359, Int represented by a Set of String
InPrice Artikli kulu (Art.kulu) Article cost 0, Value with All Decimals
SuppSerialNr
MajStoneDet
Colour
Clarity
Cert
MinStoneDet
Metal
RowWeight
Size
Length
WatchBrand
StyleName
WatchMetal
Movement
BrcStr
Gender
Other
Other2
MotherPURow
TaxTemplateCode
TaxMatrix11
TREO TREO (Non-TREO) 509, Int represented by a Set of String
DispatchNumber12
CustomsDate Tolli kuupäev CustomsDate 0, In Dataformat Order