Pakkumised kirjeldus: erinevus redaktsioonide vahel
Mine navigeerimisribale
Mine otsikasti
(Uus lehekülg: 'Registri') |
Resümee puudub |
||
| (ei näidata sama kasutaja 7 vahepealset redaktsiooni) | |||
| 1. rida: | 1. rida: | ||
Registri | * Registri nimi eesti keeles: Pakkumised | ||
* Register name in English: Quotations | |||
* funktsioon API päringus: '''/api/1/QTVc''' | |||
=== Väljade kirjeldus === | |||
{| class="wikitable" | |||
!Välja kood | |||
!Kirjeldus | |||
!Description | |||
!Tüüp, pikkus (Type, lenght) | |||
|- | |||
|SerNr | |||
|Nr | |||
|No | |||
|Value with No Decimals, 0 | |||
|- | |||
|QTDate | |||
|Kuupäev | |||
| | |||
|In Dataformat Order, 0 | |||
|- | |||
|CustCode | |||
|Klient | |||
| | |||
|Code String, 20 | |||
|- | |||
|Addr0 | |||
|Nimi | |||
| | |||
|String, 60 | |||
|- | |||
|Addr1 | |||
|Tänav/Maja | |||
| | |||
|String, 60 | |||
|- | |||
|Addr2 | |||
|Küla/Linnaosa | |||
| | |||
|String, 60 | |||
|- | |||
|Addr3 | |||
|Linn/Vald | |||
| | |||
|String, 60 | |||
|- | |||
|OurContact | |||
|Meie Esindaja | |||
| | |||
|String, 20 | |||
|- | |||
|CustContact | |||
|Nende Esindaja | |||
| | |||
|String, 60 | |||
|- | |||
|ExportFlag | |||
|Käibemaksutsoon | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|PayDeal | |||
|Tasumistingimus | |||
| | |||
|Code String, 2 | |||
|- | |||
|CustCat | |||
|Kliendi klass | |||
| | |||
|Code String, 5 | |||
|- | |||
|Objects | |||
|Objektid | |||
| | |||
|Capital Characters Only, 60 | |||
|- | |||
|ShipMode | |||
|Lähtusviis | |||
| | |||
|Code String, 5 | |||
|- | |||
|PlanShip | |||
|Planeeritud lähetuse kuupäev | |||
| | |||
|String, 10 | |||
|- | |||
|SalesMan | |||
|Müügimees | |||
| | |||
|Capital Characters Only, 60 | |||
|- | |||
|Sign | |||
|Pakkumise koostaja | |||
| | |||
|Code String, 10 | |||
|- | |||
|ShipDeal | |||
|Lähetustingimus | |||
| | |||
|Code String, 5 | |||
|- | |||
|ShipAddr0 | |||
|Lähetusaadress 1 | |||
| | |||
|String, 60 | |||
|- | |||
|ShipAddr1 | |||
|Lähetusaadress 2 | |||
| | |||
|String, 60 | |||
|- | |||
|ShipAddr2 | |||
|Lähetusaadress 3 | |||
| | |||
|String, 60 | |||
|- | |||
|ShipAddr3 | |||
|Lähetusaadress 4 | |||
| | |||
|String, 60 | |||
|- | |||
|CurncyCode | |||
|Valuuta | |||
| | |||
|Code String, 5 | |||
|- | |||
|LangCode | |||
|Keel | |||
| | |||
|Code String, 5 | |||
|- | |||
|InvoiceToCode | |||
|Arve Saaja | |||
| | |||
|Code String, 20 | |||
|- | |||
|ToRateB1 | |||
| | |||
| | |||
|Value with 6 Decimals, 0 | |||
|- | |||
|Closed | |||
|Suletud | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|BuildOn | |||
|''Eestis ei kasutata'' | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|PRCode | |||
|Projekti kood | |||
| | |||
|Code String, 20 | |||
|- | |||
|Comment | |||
|Kommentaar | |||
| | |||
|String, 100 | |||
|- | |||
|OrderNr | |||
|Tellimuse nr | |||
| | |||
|Value with No Decimals, 0 | |||
|- | |||
|ValidUntilDate | |||
|Kehtiv kuni | |||
| | |||
|String, 20 | |||
|- | |||
|InvOnlyOnFull | |||
|Ära luba arveldada rohkem kui pakutud | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|PriceList | |||
|Hinnakiri | |||
| | |||
|Code String, 20 | |||
|- | |||
|InclVAT | |||
|Hinnad koos KMiga | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|Sum0 | |||
|Ümardus | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|Sum1 | |||
|Vahesumma | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|Sum2 | |||
|''Eestis ei kasutata'' | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|Sum3 | |||
|KM summa | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|Sum4 | |||
|KOKKU | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|QuoteClass | |||
|Pakkumise klass | |||
| | |||
|Code String, 5 | |||
|- | |||
|CustVATCode | |||
|Kliendi KM kood | |||
| | |||
|Code String, 10 | |||
|- | |||
|RebCode | |||
|Hinnaalandusmaatriksi kood | |||
| | |||
|Code String, 5 | |||
|- | |||
|VATNr | |||
|KMKR number | |||
| | |||
|String, 20 | |||
|- | |||
|Phone | |||
|Telefon | |||
| | |||
|String with phone-number, 20 | |||
|- | |||
|Fax | |||
|Faks | |||
| | |||
|String, 20 | |||
|- | |||
|MakeContactDate | |||
|Võta Ühendust | |||
| | |||
|String, 20 | |||
|- | |||
|BaseSum4 | |||
|KOKKU baasvaluutas | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|FrRate | |||
|Kurss | |||
| | |||
|Value with 6 Decimals, 0 | |||
|- | |||
|ToRateB2 | |||
|Baasvaluuta 1 | |||
| | |||
|Value with 6 Decimals, 0 | |||
|- | |||
|BaseRate1 | |||
|Baasvaluuta 1 | |||
| | |||
|Value with 6 Decimals, 0 | |||
|- | |||
|BaseRate2 | |||
|Baasvaluuta 2 | |||
| | |||
|Value with 6 Decimals, 0 | |||
|- | |||
|DiscPerc | |||
|Allahindluse protsent (peidetud väli päises) | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|DiscSum | |||
|Allahindluse summa (peidetud väli päises) | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|TotGP | |||
|Müügikate kokku | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|DaysToDelivery | |||
|Päevi tarnimiseks | |||
| | |||
|Value with No Decimals, 0 | |||
|- | |||
|Probability | |||
|Tõenäosus | |||
| | |||
|Value with One Decimal, 0 | |||
|- | |||
|GPProc | |||
|Müügikatte protsent | |||
| | |||
|Value with One Decimal, 0 | |||
|- | |||
|SalesGroup | |||
|Müügigrupp | |||
| | |||
|Capital Characters Only, 30 | |||
|- | |||
|Sorting | |||
|Teekond | |||
| | |||
|String, 20 | |||
|- | |||
|Location | |||
|Ladu | |||
| | |||
|Code String, 10 | |||
|- | |||
|TotQty | |||
|Kogus kokku | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|TotWeight | |||
|Kaal kokku | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|TotVolume | |||
|Maht kokku | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|FrPrice | |||
|Transport | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|FrBase | |||
|Transpordi baashind | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|FrItem | |||
|Transpordi artikkel | |||
| | |||
|Code String, 20 | |||
|- | |||
|FrVATCode | |||
|Transpordi KM kood | |||
| | |||
|Code String, 10 | |||
|- | |||
|FrObjects | |||
|Transpordi objekt | |||
| | |||
|Capital Characters Only, 60 | |||
|- | |||
|InvAddr3 | |||
|Arve aadress rida 4 | |||
| | |||
|String, 60 | |||
|- | |||
|InvAddr4 | |||
|Arve aadress rida 5 | |||
| | |||
|String, 60 | |||
|- | |||
|DelAddr3 | |||
|Lähetusaadress rida 4 | |||
| | |||
|String, 60 | |||
|- | |||
|DelAddr4 | |||
|Lähetusaadress rida 5 | |||
| | |||
|String, 60 | |||
|- | |||
|DelAddrCode | |||
|Lähetusaadressi kood | |||
| | |||
|Code String, 20 | |||
|- | |||
|Rejected | |||
|Tagasi lükatud | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|RejectDate | |||
|Tagasilükkamise kuupäev | |||
| | |||
|In Dataformat Order, 0 | |||
|- | |||
|Markup | |||
|Juurdehindlus | |||
| | |||
|, 10 | |||
|- | |||
|BudTime | |||
|Aeg Arvel: Tegelik / Nagu pakutud | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|SumTime | |||
|Kokku aeg | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|BudOther | |||
|Ostud Arvel: Tegelik / Nagu pakutud | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|SumOther | |||
|Kokku ostud | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|BudStocked | |||
|Laoartiklid Arvel: Tegelik / Nagu pakutud | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|SumStocked | |||
|Kokku laoartiklid | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|BudMaterial | |||
|Materjal Arvel: Tegelik / Nagu pakutud | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|SumMaterial | |||
|Kokku materjal | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|TAX1Sum | |||
|Maksud kokku baasvaluutas 1 | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|AcceptDate | |||
|Akstepteeritud kp | |||
| | |||
|In Dataformat Order, 0 | |||
|- | |||
|Priority | |||
|Tähtsus | |||
| | |||
|Value with No Decimals, 0 | |||
|- | |||
|PlanShipDate | |||
|Planeeritud lähetus | |||
| | |||
|In Dataformat Order, 0 | |||
|- | |||
|Region | |||
|Regioon | |||
| | |||
|Code String, 20 | |||
|- | |||
|RefStr | |||
|Viide | |||
| | |||
|String, 60 | |||
|- | |||
|TAX2Sum | |||
|Maksu summa baasvaluutas 2 | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|NoTax1 | |||
|Ilma lisamaksuta summa, baasvaluutas 1 | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|NoTax2 | |||
|Ilma lisamaksuta summa, baasvaluutas 2 | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|BranchID | |||
|Filiaal | |||
| | |||
|Code String, 20 | |||
|- | |||
|NoTAXonVAT | |||
|KM ilma lisamaksuta | |||
| | |||
|Value with No Decimals, 0 | |||
|- | |||
|TotalwoTAX | |||
|Kokku ilma lisamaksuta | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|OrgCust | |||
|Orginaalklient | |||
| | |||
|Code String, 20 | |||
|- | |||
|AcceptanceStatus | |||
|Aktsepteerimise staatus | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|CustTaxTemplateCode | |||
|''Eestis ei kasutata'' | |||
| | |||
|Code String, 10 | |||
|- | |||
|InvCountry | |||
|Arve riik | |||
| | |||
|Code String, 5 | |||
|- | |||
|DelCountry | |||
|Lähetuse riik | |||
| | |||
|Code String, 5 | |||
|- | |||
|AcceptanceBy | |||
|Aktsepteerija | |||
| | |||
|Comma separated List, 200 | |||
|- | |||
|DisallowInvoicemorethanQuoted | |||
|Keela arveldada rohkem kui pakutud | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|ProformaOfficialSerNr | |||
|Proforma ametlik seerianumber | |||
| | |||
|String, 100 | |||
|- | |||
|Hash | |||
|Kontrollväli, ''peidetud'' | |||
| | |||
|String, 255 | |||
|- | |||
|HashKeyVersion | |||
|Kontrollväli, ''peidetud'' | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|RegDate | |||
|Kaardi koostamise kp | |||
| | |||
|In Dataformat Order, 0 | |||
|- | |||
|RegTime | |||
|Kaardi koostamise kellaaeg | |||
| | |||
|Hour:Min:Secs, 0 | |||
|- | |||
|LocalMachineCode | |||
|Terminali kood | |||
| | |||
|Code String, 20 | |||
|- | |||
|AcceptanceFYI | |||
|Infoks | |||
| | |||
|Comma separated List, 200 | |||
|- | |||
|BankCode | |||
|Panga kood | |||
| | |||
|Code String, 10 | |||
|- | |||
|SVOSerNr | |||
| | |||
| | |||
|Value with No Decimals, 0 | |||
|- | |||
|Comment2 | |||
|Kommentaar rida 2 | |||
| | |||
|String, 100 | |||
|- | |||
|Comment3 | |||
|Kommentaar rida 3 | |||
| | |||
|String, 100 | |||
|- | |||
|Comment4 | |||
|Kommentaar rida 4 | |||
| | |||
|String, 100 | |||
|- | |||
|InvCountryName | |||
|Arve Riigi nimi | |||
| | |||
|String, 100 | |||
|- | |||
|DelCountryName | |||
|Lähetusriigi nimi | |||
| | |||
|String, 100 | |||
|- | |||
|ProformaOfficialSerNrSerie | |||
|Proforma ametliku seerianumbri numbriseeria | |||
| | |||
|String, 30 | |||
|- | |||
|RecipientGLN | |||
|Arve saaja GLN | |||
| | |||
|String, 20 | |||
|- | |||
|DelRecipientGLN | |||
|Lähetusaadressi GLN | |||
| | |||
|String, 20 | |||
|- | |||
|IntrastatTransCode | |||
|Intrastati transpordi kood | |||
| | |||
|Code String, 20 | |||
|- | |||
|ContractStartDate | |||
|Lepingu alguskuupäev | |||
| | |||
|In Dataformat Order, 0 | |||
|- | |||
|OYNr | |||
|''Eestis ei kasutata'' | |||
| | |||
|Value with No Decimals, 0 | |||
|- | |||
|OYDescription | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 200 | |||
|- | |||
|RvrsVAT | |||
|Pöördkäibemaks | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|PromotionCodes | |||
|''Eestis ei kasutata'' | |||
| | |||
|Comma separated List, 200 | |||
|- | |||
|AccountDimension | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 255 | |||
|- | |||
|TenderReference | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 255 | |||
|- | |||
|ContractNr | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 255 | |||
|- | |||
|ProcessOrigin | |||
|''Eestis ei kasutata'' | |||
| | |||
|Int represented by a Set of String, 700 | |||
|- | |||
|AvalaraCityCode | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 15 | |||
|- | |||
|AvalaraCountryCode | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 15 | |||
|- | |||
|AvalaraStateCode | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 15 | |||
|- | |||
|DelAvalaraCityCode | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 15 | |||
|- | |||
|DelAvalaraCountryCode | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 15 | |||
|- | |||
|DelAvalaraStateCode | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 15 | |||
|- | |||
|DelPhone | |||
|Lähetusaadressi telefon | |||
| | |||
|String, 255 | |||
|- | |||
|DelEmail | |||
|Lähetusaadressi e-mail | |||
| | |||
|String, 255 | |||
|- | |||
|WithholdingMode | |||
|''Eestis ei kasutata'' | |||
| | |||
|Internal Set of Strings, 701 | |||
|- | |||
|WithholdingTax | |||
|''Eestis ei kasutata'' | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|SpecSituation | |||
|''Eestis ei kasutata'' | |||
| | |||
|Internal Set of Strings, 703 | |||
|- | |||
|AdminProcessNo | |||
|''Eestis ei kasutata'' | |||
| | |||
|String, 30 | |||
|- | |||
|PubHighwayServ | |||
|''Eestis ei kasutata'' | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|AddedTax | |||
|''Eestis ei kasutata'' | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|SubstractedTax | |||
|''Eestis ei kasutata'' | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
! colspan="4" |<nowiki>!!!!!!!!Maatriks!!!!!!!!!</nowiki> | |||
|- | |||
|stp | |||
|Rea tüüp. Enamasti 1, aga on olemas [[Ridade tüübid ehk võimalikud "stp" väärtused|STP koodide spec]] | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|ArtCode | |||
|Artikli kood | |||
| | |||
|Code String, 20 | |||
|- | |||
|Quant | |||
|Kogus | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|Price | |||
|Ühikuhind | |||
| | |||
|Value with 2 or 3 Decimals, 0 | |||
|- | |||
|Sum | |||
|Rea summa | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|vRebate | |||
|Allahindlusprotsent | |||
| | |||
|Value with One Decimal, 0 | |||
|- | |||
|SalesAcc | |||
|Müügi konto | |||
| | |||
|Code String, 10 | |||
|- | |||
|Objects | |||
|Objektid | |||
| | |||
|Capital Characters Only, 60 | |||
|- | |||
|BasePrice | |||
|Baashind | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|rowGP | |||
|rea müügikate | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|VATCode | |||
|KM kood | |||
| | |||
|Code String, 10 | |||
|- | |||
|PlanShip | |||
|Planeeritud lähetus | |||
| | |||
|String, 10 | |||
|- | |||
|SerialNr | |||
|Seerianumber | |||
| | |||
|String, 60 | |||
|- | |||
|PriceFactor | |||
|Hinnafaktor | |||
| | |||
|Value with All Decimals, 0 | |||
|- | |||
|Spec | |||
|Kirjeldus | |||
| | |||
|String, 100 | |||
|- | |||
|VARList | |||
|''Eestis ei kasutata'' | |||
| | |||
|Capital Characters Only, 30 | |||
|- | |||
|Recepy | |||
|Retsept | |||
| | |||
|Code String, 20 | |||
|- | |||
|UnitCode | |||
|Ühiku kood | |||
| | |||
|Code String, 5 | |||
|- | |||
|UnitFactQuant | |||
|Ühiku Fakt Kogus | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|UnitFactPrice | |||
|Ühiku Fakt Hind | |||
| | |||
|Value with 2 or 3 Decimals, 0 | |||
|- | |||
|UnitXval | |||
|Ühiku laius | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|UnitYval | |||
|Ühiku kõrgus | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|UnitZval | |||
|Ühiku sügavus | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|VECode | |||
|Tarnija kood | |||
| | |||
|Code String, 20 | |||
|- | |||
|EMCode | |||
|''Eestis ei kasutata'' | |||
| | |||
|Code String, 10 | |||
|- | |||
|Markup | |||
|Juurdehindlus | |||
| | |||
|, 10 | |||
|- | |||
|TimeClass | |||
|Ajaklass | |||
| | |||
|Code String, 5 | |||
|- | |||
|InvAfter | |||
|Arve Peale | |||
| | |||
|In Dataformat Order, 0 | |||
|- | |||
|Invoiced | |||
|Arveldatud | |||
| | |||
|Value with No Decimals, 0 | |||
|- | |||
|InvDate | |||
|Arve kuupäev | |||
| | |||
|In Dataformat Order, 0 | |||
|- | |||
|ItemType | |||
|Artikli tüüp | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|RowType | |||
|Reatüüp | |||
| | |||
|Int represented by a Set of String, 12 | |||
|- | |||
|BudType | |||
|Lepingu tüüp | |||
| | |||
|Int represented by a Set of String, 13 | |||
|- | |||
|JobGroup | |||
|Töötaja klass | |||
| | |||
|Code String, 5 | |||
|- | |||
|TAX2Code | |||
| | |||
| | |||
|Code String, 5 | |||
|- | |||
|TAX2Prc | |||
| | |||
| | |||
|Value with 2 or 3 Decimals, 0 | |||
|- | |||
|TAX2Reb | |||
| | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|TAX1Reb | |||
| | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|TAX2Acc | |||
| | |||
| | |||
|Code String, 10 | |||
|- | |||
|PRStage | |||
| | |||
| | |||
|Code String, 10 | |||
|- | |||
|TaxTemplateCode | |||
| | |||
| | |||
|Capital Characters Only, 60 | |||
|- | |||
|TaxMatrix | |||
| | |||
| | |||
|Packed Matrix, base64 data, 0 | |||
|- | |||
|VATCode | |||
| | |||
| | |||
|Code String, 10 | |||
|- | |||
|VATSum | |||
| | |||
| | |||
|Value with All Decimals, 0 | |||
|- | |||
|VATRate | |||
| | |||
| | |||
|Value with 2 or 3 Decimals, 0 | |||
|- | |||
|BaseSum | |||
| | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|CalcBase | |||
| | |||
| | |||
|Int represented by a Set of String, 453 | |||
|- | |||
|TaxDesc | |||
| | |||
| | |||
|String, 255 | |||
|- | |||
|Jurisdiction | |||
| | |||
| | |||
|String, 255 | |||
|- | |||
|TaxType | |||
| | |||
| | |||
|Internal Set of Strings, 719 | |||
|- | |||
|TaxImpact | |||
| | |||
| | |||
|Int represented by a Set of String, 721 | |||
|- | |||
|Region | |||
| | |||
| | |||
|Code String, 20 | |||
|- | |||
|Perceptions | |||
| | |||
| | |||
|Small Value with No Decimals, 0 | |||
|- | |||
|MotherArtCode | |||
| | |||
| | |||
|Code String, 20 | |||
|- | |||
|RecipeQuant | |||
| | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|Invd | |||
| | |||
| | |||
|Value with minimum Decimals, 0 | |||
|- | |||
|CustArtCode | |||
| | |||
| | |||
|Code String, 20 | |||
|- | |||
|Salesmen | |||
| | |||
| | |||
|Capital Characters Only, 60 | |||
|- | |||
|UnitComment | |||
| | |||
| | |||
|String, 200 | |||
|- | |||
|DiscApprovedBy | |||
| | |||
| | |||
|Code String, 10 | |||
|- | |||
|ServiceDelDate | |||
| | |||
| | |||
|In Dataformat Order, 0 | |||
|- | |||
|RvrsVATCode | |||
| | |||
| | |||
|Code String, 10 | |||
|- | |||
|OtherCost | |||
| | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|FreightCost | |||
| | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|Insurance | |||
| | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|- | |||
|UntaxedOtherCost | |||
| | |||
| | |||
|Value 2 or 3 Decimals, 0 | |||
|} | |||
=== Kaart === | |||
[[Fail:Pakkumise kaart.png|tühi|pisi|842x842px]] | |||
Viimane redaktsioon: 13. veebruar 2024, kell 08:08
- Registri nimi eesti keeles: Pakkumised
- Register name in English: Quotations
- funktsioon API päringus: /api/1/QTVc
Väljade kirjeldus
| Välja kood | Kirjeldus | Description | Tüüp, pikkus (Type, lenght) |
|---|---|---|---|
| SerNr | Nr | No | Value with No Decimals, 0 |
| QTDate | Kuupäev | In Dataformat Order, 0 | |
| CustCode | Klient | Code String, 20 | |
| Addr0 | Nimi | String, 60 | |
| Addr1 | Tänav/Maja | String, 60 | |
| Addr2 | Küla/Linnaosa | String, 60 | |
| Addr3 | Linn/Vald | String, 60 | |
| OurContact | Meie Esindaja | String, 20 | |
| CustContact | Nende Esindaja | String, 60 | |
| ExportFlag | Käibemaksutsoon | Small Value with No Decimals, 0 | |
| PayDeal | Tasumistingimus | Code String, 2 | |
| CustCat | Kliendi klass | Code String, 5 | |
| Objects | Objektid | Capital Characters Only, 60 | |
| ShipMode | Lähtusviis | Code String, 5 | |
| PlanShip | Planeeritud lähetuse kuupäev | String, 10 | |
| SalesMan | Müügimees | Capital Characters Only, 60 | |
| Sign | Pakkumise koostaja | Code String, 10 | |
| ShipDeal | Lähetustingimus | Code String, 5 | |
| ShipAddr0 | Lähetusaadress 1 | String, 60 | |
| ShipAddr1 | Lähetusaadress 2 | String, 60 | |
| ShipAddr2 | Lähetusaadress 3 | String, 60 | |
| ShipAddr3 | Lähetusaadress 4 | String, 60 | |
| CurncyCode | Valuuta | Code String, 5 | |
| LangCode | Keel | Code String, 5 | |
| InvoiceToCode | Arve Saaja | Code String, 20 | |
| ToRateB1 | Value with 6 Decimals, 0 | ||
| Closed | Suletud | Small Value with No Decimals, 0 | |
| BuildOn | Eestis ei kasutata | Small Value with No Decimals, 0 | |
| PRCode | Projekti kood | Code String, 20 | |
| Comment | Kommentaar | String, 100 | |
| OrderNr | Tellimuse nr | Value with No Decimals, 0 | |
| ValidUntilDate | Kehtiv kuni | String, 20 | |
| InvOnlyOnFull | Ära luba arveldada rohkem kui pakutud | Small Value with No Decimals, 0 | |
| PriceList | Hinnakiri | Code String, 20 | |
| InclVAT | Hinnad koos KMiga | Small Value with No Decimals, 0 | |
| Sum0 | Ümardus | Value 2 or 3 Decimals, 0 | |
| Sum1 | Vahesumma | Value 2 or 3 Decimals, 0 | |
| Sum2 | Eestis ei kasutata | Value 2 or 3 Decimals, 0 | |
| Sum3 | KM summa | Value 2 or 3 Decimals, 0 | |
| Sum4 | KOKKU | Value 2 or 3 Decimals, 0 | |
| QuoteClass | Pakkumise klass | Code String, 5 | |
| CustVATCode | Kliendi KM kood | Code String, 10 | |
| RebCode | Hinnaalandusmaatriksi kood | Code String, 5 | |
| VATNr | KMKR number | String, 20 | |
| Phone | Telefon | String with phone-number, 20 | |
| Fax | Faks | String, 20 | |
| MakeContactDate | Võta Ühendust | String, 20 | |
| BaseSum4 | KOKKU baasvaluutas | Value 2 or 3 Decimals, 0 | |
| FrRate | Kurss | Value with 6 Decimals, 0 | |
| ToRateB2 | Baasvaluuta 1 | Value with 6 Decimals, 0 | |
| BaseRate1 | Baasvaluuta 1 | Value with 6 Decimals, 0 | |
| BaseRate2 | Baasvaluuta 2 | Value with 6 Decimals, 0 | |
| DiscPerc | Allahindluse protsent (peidetud väli päises) | Value with minimum Decimals, 0 | |
| DiscSum | Allahindluse summa (peidetud väli päises) | Value 2 or 3 Decimals, 0 | |
| TotGP | Müügikate kokku | Value 2 or 3 Decimals, 0 | |
| DaysToDelivery | Päevi tarnimiseks | Value with No Decimals, 0 | |
| Probability | Tõenäosus | Value with One Decimal, 0 | |
| GPProc | Müügikatte protsent | Value with One Decimal, 0 | |
| SalesGroup | Müügigrupp | Capital Characters Only, 30 | |
| Sorting | Teekond | String, 20 | |
| Location | Ladu | Code String, 10 | |
| TotQty | Kogus kokku | Value with minimum Decimals, 0 | |
| TotWeight | Kaal kokku | Value with minimum Decimals, 0 | |
| TotVolume | Maht kokku | Value with minimum Decimals, 0 | |
| FrPrice | Transport | Value 2 or 3 Decimals, 0 | |
| FrBase | Transpordi baashind | Value 2 or 3 Decimals, 0 | |
| FrItem | Transpordi artikkel | Code String, 20 | |
| FrVATCode | Transpordi KM kood | Code String, 10 | |
| FrObjects | Transpordi objekt | Capital Characters Only, 60 | |
| InvAddr3 | Arve aadress rida 4 | String, 60 | |
| InvAddr4 | Arve aadress rida 5 | String, 60 | |
| DelAddr3 | Lähetusaadress rida 4 | String, 60 | |
| DelAddr4 | Lähetusaadress rida 5 | String, 60 | |
| DelAddrCode | Lähetusaadressi kood | Code String, 20 | |
| Rejected | Tagasi lükatud | Small Value with No Decimals, 0 | |
| RejectDate | Tagasilükkamise kuupäev | In Dataformat Order, 0 | |
| Markup | Juurdehindlus | , 10 | |
| BudTime | Aeg Arvel: Tegelik / Nagu pakutud | Small Value with No Decimals, 0 | |
| SumTime | Kokku aeg | Value 2 or 3 Decimals, 0 | |
| BudOther | Ostud Arvel: Tegelik / Nagu pakutud | Small Value with No Decimals, 0 | |
| SumOther | Kokku ostud | Value 2 or 3 Decimals, 0 | |
| BudStocked | Laoartiklid Arvel: Tegelik / Nagu pakutud | Small Value with No Decimals, 0 | |
| SumStocked | Kokku laoartiklid | Value 2 or 3 Decimals, 0 | |
| BudMaterial | Materjal Arvel: Tegelik / Nagu pakutud | Small Value with No Decimals, 0 | |
| SumMaterial | Kokku materjal | Value 2 or 3 Decimals, 0 | |
| TAX1Sum | Maksud kokku baasvaluutas 1 | Value 2 or 3 Decimals, 0 | |
| AcceptDate | Akstepteeritud kp | In Dataformat Order, 0 | |
| Priority | Tähtsus | Value with No Decimals, 0 | |
| PlanShipDate | Planeeritud lähetus | In Dataformat Order, 0 | |
| Region | Regioon | Code String, 20 | |
| RefStr | Viide | String, 60 | |
| TAX2Sum | Maksu summa baasvaluutas 2 | Value 2 or 3 Decimals, 0 | |
| NoTax1 | Ilma lisamaksuta summa, baasvaluutas 1 | Small Value with No Decimals, 0 | |
| NoTax2 | Ilma lisamaksuta summa, baasvaluutas 2 | Small Value with No Decimals, 0 | |
| BranchID | Filiaal | Code String, 20 | |
| NoTAXonVAT | KM ilma lisamaksuta | Value with No Decimals, 0 | |
| TotalwoTAX | Kokku ilma lisamaksuta | Small Value with No Decimals, 0 | |
| OrgCust | Orginaalklient | Code String, 20 | |
| AcceptanceStatus | Aktsepteerimise staatus | Small Value with No Decimals, 0 | |
| CustTaxTemplateCode | Eestis ei kasutata | Code String, 10 | |
| InvCountry | Arve riik | Code String, 5 | |
| DelCountry | Lähetuse riik | Code String, 5 | |
| AcceptanceBy | Aktsepteerija | Comma separated List, 200 | |
| DisallowInvoicemorethanQuoted | Keela arveldada rohkem kui pakutud | Small Value with No Decimals, 0 | |
| ProformaOfficialSerNr | Proforma ametlik seerianumber | String, 100 | |
| Hash | Kontrollväli, peidetud | String, 255 | |
| HashKeyVersion | Kontrollväli, peidetud | Small Value with No Decimals, 0 | |
| RegDate | Kaardi koostamise kp | In Dataformat Order, 0 | |
| RegTime | Kaardi koostamise kellaaeg | Hour:Min:Secs, 0 | |
| LocalMachineCode | Terminali kood | Code String, 20 | |
| AcceptanceFYI | Infoks | Comma separated List, 200 | |
| BankCode | Panga kood | Code String, 10 | |
| SVOSerNr | Value with No Decimals, 0 | ||
| Comment2 | Kommentaar rida 2 | String, 100 | |
| Comment3 | Kommentaar rida 3 | String, 100 | |
| Comment4 | Kommentaar rida 4 | String, 100 | |
| InvCountryName | Arve Riigi nimi | String, 100 | |
| DelCountryName | Lähetusriigi nimi | String, 100 | |
| ProformaOfficialSerNrSerie | Proforma ametliku seerianumbri numbriseeria | String, 30 | |
| RecipientGLN | Arve saaja GLN | String, 20 | |
| DelRecipientGLN | Lähetusaadressi GLN | String, 20 | |
| IntrastatTransCode | Intrastati transpordi kood | Code String, 20 | |
| ContractStartDate | Lepingu alguskuupäev | In Dataformat Order, 0 | |
| OYNr | Eestis ei kasutata | Value with No Decimals, 0 | |
| OYDescription | Eestis ei kasutata | String, 200 | |
| RvrsVAT | Pöördkäibemaks | Value 2 or 3 Decimals, 0 | |
| PromotionCodes | Eestis ei kasutata | Comma separated List, 200 | |
| AccountDimension | Eestis ei kasutata | String, 255 | |
| TenderReference | Eestis ei kasutata | String, 255 | |
| ContractNr | Eestis ei kasutata | String, 255 | |
| ProcessOrigin | Eestis ei kasutata | Int represented by a Set of String, 700 | |
| AvalaraCityCode | Eestis ei kasutata | String, 15 | |
| AvalaraCountryCode | Eestis ei kasutata | String, 15 | |
| AvalaraStateCode | Eestis ei kasutata | String, 15 | |
| DelAvalaraCityCode | Eestis ei kasutata | String, 15 | |
| DelAvalaraCountryCode | Eestis ei kasutata | String, 15 | |
| DelAvalaraStateCode | Eestis ei kasutata | String, 15 | |
| DelPhone | Lähetusaadressi telefon | String, 255 | |
| DelEmail | Lähetusaadressi e-mail | String, 255 | |
| WithholdingMode | Eestis ei kasutata | Internal Set of Strings, 701 | |
| WithholdingTax | Eestis ei kasutata | Value 2 or 3 Decimals, 0 | |
| SpecSituation | Eestis ei kasutata | Internal Set of Strings, 703 | |
| AdminProcessNo | Eestis ei kasutata | String, 30 | |
| PubHighwayServ | Eestis ei kasutata | Small Value with No Decimals, 0 | |
| AddedTax | Eestis ei kasutata | Value 2 or 3 Decimals, 0 | |
| SubstractedTax | Eestis ei kasutata | Value 2 or 3 Decimals, 0 | |
| !!!!!!!!Maatriks!!!!!!!!! | |||
| stp | Rea tüüp. Enamasti 1, aga on olemas STP koodide spec | Small Value with No Decimals, 0 | |
| ArtCode | Artikli kood | Code String, 20 | |
| Quant | Kogus | Value with minimum Decimals, 0 | |
| Price | Ühikuhind | Value with 2 or 3 Decimals, 0 | |
| Sum | Rea summa | Value 2 or 3 Decimals, 0 | |
| vRebate | Allahindlusprotsent | Value with One Decimal, 0 | |
| SalesAcc | Müügi konto | Code String, 10 | |
| Objects | Objektid | Capital Characters Only, 60 | |
| BasePrice | Baashind | Value 2 or 3 Decimals, 0 | |
| rowGP | rea müügikate | Value 2 or 3 Decimals, 0 | |
| VATCode | KM kood | Code String, 10 | |
| PlanShip | Planeeritud lähetus | String, 10 | |
| SerialNr | Seerianumber | String, 60 | |
| PriceFactor | Hinnafaktor | Value with All Decimals, 0 | |
| Spec | Kirjeldus | String, 100 | |
| VARList | Eestis ei kasutata | Capital Characters Only, 30 | |
| Recepy | Retsept | Code String, 20 | |
| UnitCode | Ühiku kood | Code String, 5 | |
| UnitFactQuant | Ühiku Fakt Kogus | Value with minimum Decimals, 0 | |
| UnitFactPrice | Ühiku Fakt Hind | Value with 2 or 3 Decimals, 0 | |
| UnitXval | Ühiku laius | Value with minimum Decimals, 0 | |
| UnitYval | Ühiku kõrgus | Value with minimum Decimals, 0 | |
| UnitZval | Ühiku sügavus | Value with minimum Decimals, 0 | |
| VECode | Tarnija kood | Code String, 20 | |
| EMCode | Eestis ei kasutata | Code String, 10 | |
| Markup | Juurdehindlus | , 10 | |
| TimeClass | Ajaklass | Code String, 5 | |
| InvAfter | Arve Peale | In Dataformat Order, 0 | |
| Invoiced | Arveldatud | Value with No Decimals, 0 | |
| InvDate | Arve kuupäev | In Dataformat Order, 0 | |
| ItemType | Artikli tüüp | Small Value with No Decimals, 0 | |
| RowType | Reatüüp | Int represented by a Set of String, 12 | |
| BudType | Lepingu tüüp | Int represented by a Set of String, 13 | |
| JobGroup | Töötaja klass | Code String, 5 | |
| TAX2Code | Code String, 5 | ||
| TAX2Prc | Value with 2 or 3 Decimals, 0 | ||
| TAX2Reb | Value 2 or 3 Decimals, 0 | ||
| TAX1Reb | Value 2 or 3 Decimals, 0 | ||
| TAX2Acc | Code String, 10 | ||
| PRStage | Code String, 10 | ||
| TaxTemplateCode | Capital Characters Only, 60 | ||
| TaxMatrix | Packed Matrix, base64 data, 0 | ||
| VATCode | Code String, 10 | ||
| VATSum | Value with All Decimals, 0 | ||
| VATRate | Value with 2 or 3 Decimals, 0 | ||
| BaseSum | Value 2 or 3 Decimals, 0 | ||
| CalcBase | Int represented by a Set of String, 453 | ||
| TaxDesc | String, 255 | ||
| Jurisdiction | String, 255 | ||
| TaxType | Internal Set of Strings, 719 | ||
| TaxImpact | Int represented by a Set of String, 721 | ||
| Region | Code String, 20 | ||
| Perceptions | Small Value with No Decimals, 0 | ||
| MotherArtCode | Code String, 20 | ||
| RecipeQuant | Value with minimum Decimals, 0 | ||
| Invd | Value with minimum Decimals, 0 | ||
| CustArtCode | Code String, 20 | ||
| Salesmen | Capital Characters Only, 60 | ||
| UnitComment | String, 200 | ||
| DiscApprovedBy | Code String, 10 | ||
| ServiceDelDate | In Dataformat Order, 0 | ||
| RvrsVATCode | Code String, 10 | ||
| OtherCost | Value 2 or 3 Decimals, 0 | ||
| FreightCost | Value 2 or 3 Decimals, 0 | ||
| Insurance | Value 2 or 3 Decimals, 0 | ||
| UntaxedOtherCost | Value 2 or 3 Decimals, 0 | ||
