Laosissetulekud

Allikas: Excellent || Opendoc
Redaktsioon seisuga 1. veebruar 2023, kell 12:47 kasutajalt Kaupo (arutelu | kaastöö)
(erin) ←Vanem redaktsioon | Viimane redaktsiooni (erin) | Uuem redaktsioon→ (erin)
Mine navigeerimisribale Mine otsikasti

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 N/A
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 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 CMR value 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 ExraSUM 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 N/A 10, Code String
TaxMatrix N/A N/A 0, Packed Matrix, base64 data
BranchID N/A N/A 20, Code String
AcceptanceBy N/A N/A 200, Comma separated List
ExtraCostsCalculation N/A N/A 0, Small Value with No Decimals
AcceptanceFYI N/A N/A 200, VETaxTemplateCode
DispatchNumber N/A N/A 60, VETaxTemplateCode
CustomsNr Tolli nr CustomsNo 30, String
Sign Koostaja Compiler 10, Code String
SalesGroup N/A N/A 5, Code String
MAATRIKS
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 N/A N/A 30, Capital Characters Only
ShipCost Transpordi kulu rea kohta Transport cost per row 0, Value with All Decimals
CustomsCost Toll rea kohta Customs per row 0, Value with minimum Decimals
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 N/A N/A 0, Small Value with No Decimals
ovst Tühistatud flag Invalidated flag 0, Small Value with No Decimals
Sign Koostaja Compiler 10, Code String
UpdDate N/A N/A 0, In Dataformat Order
PORecon N/A N/A 0, Value with minimum Decimals
POReconComment N/A N/A 100, String
VIRecon N/A N/A 0, Value with minimum Decimals
VIReconComment N/A N/A 100, String
PONr8 N/A N/A 0, Value with No Decimals
BarCode Vöötkood BarCode 20, String
PrelPUNr9 N/A N/A 0, Value with No Decimals
PrelPURow N/A N/A 0, Value with No Decimals
ToPosCode Asukohta To location 20, Code String
UnitCode Ühik Unit 5, Code String
VarianceAmount N/A N/A 0, Value 2 or 3 Decimals
TAX2Code N/A N/A 5, Code String
TAX2Prc N/A N/A 0, Value with 2 or 3 Decimals
TAX2Reb N/A N/A 0, Value 2 or 3 Decimals
TAX1Reb N/A N/A 0, Value 2 or 3 Decimals
TAX2Acc N/A N/A 10, Code String
Location Ladu (ridadelt) Stock row 10, Code String
ChargeNumber N/A N/A 0, Value with No Decimals
VEQuant H.kogus supplier quantity 0, Value with minimum Decimals
PIFactor N/A N/A 0, Value with minimum Decimals
VEUnit H.Ühik Supplier Unit 5, Code String
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 N/A N/A 20, String
MajStoneDet N/A N/A 20, String
Colour N/A N/A 20, String
Clarity N/A N/A 20, String
Cert N/A N/A 20, String
MinStoneDet N/A N/A 20, String
Metal N/A N/A 20, String
RowWeight N/A N/A 20, String
Size N/A N/A 20, String
Length N/A N/A 20, String
WatchBrand N/A N/A 20, String
StyleName N/A N/A 20, String
WatchMetal N/A N/A 20, String
Movement N/A N/A 20, String
BrcStr N/A N/A 20, String
Gender N/A N/A 20, String
Other N/A N/A 20, String
Other2 N/A N/A 20, String
MotherPURow N/A N/A 0, Value with No Decimals
TaxTemplateCode N/A N/A 60, Capital Characters Only
TaxMatrix11 N/A N/A 0, Packed Matrix, base64 data
TREO TREO (Non-TREO) N/A 509, Int represented by a Set of String
DispatchNumber12 N/A N/A 60, String
CustomsDate Tolli kuupäev CustomsDate 0, In Dataformat Order