Müügitellimused: erinevus redaktsioonide vahel
Mine navigeerimisribale
Mine otsikasti
Resümee puudub |
|||
| (ei näidata sama kasutaja 5 vahepealset redaktsiooni) | |||
| 39. rida: | 39. rida: | ||
|- | |- | ||
|'''Addr0''' | |'''Addr0''' | ||
|Kliendi | |Kliendi nimi | ||
| | |Customer name | ||
|60, String | |60, String | ||
|- | |- | ||
| 84. rida: | 84. rida: | ||
|'''InvFlag''' | |'''InvFlag''' | ||
|Arve tehtud? Linnuke sirvi aknas | |Arve tehtud? Linnuke sirvi aknas | ||
|Invoice created ( | |Invoice created (Hidden field) | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''ShipFlag''' | |'''ShipFlag''' | ||
|Lähetus tehtud? Linnuke sirvi aknas | |Lähetus tehtud? Linnuke sirvi aknas | ||
|Delivery created ( | |Delivery created (Hidden field) | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
| 109. rida: | 109. rida: | ||
|'''InvMark''' | |'''InvMark''' | ||
|Arve | |Arve | ||
|Invoice created ( | |Invoice created (visible in browse window) | ||
|0, As Bool but displayed as a Checkbox | |0, As Bool but displayed as a Checkbox | ||
|- | |- | ||
|'''ShipMark''' | |'''ShipMark''' | ||
|Lähetus | |Lähetus | ||
|Delivery created ( | |Delivery created (visible in browse window) | ||
|0, As Bool but displayed as a Checkbox | |0, As Bool but displayed as a Checkbox | ||
|- | |- | ||
| 424. rida: | 424. rida: | ||
|'''FrPrice''' | |'''FrPrice''' | ||
|Transpordi hind | |Transpordi hind | ||
| | |Freight | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''FrBase''' | |'''FrBase''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''FrItem''' | |'''FrItem''' | ||
|Transpordi artiklikood | |Transpordi artiklikood | ||
| | |Freight item code | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''FrVATCode''' | |'''FrVATCode''' | ||
|Transpordi KM kood | |Transpordi KM kood | ||
| | |Freight VAT code | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|'''FrObjects''' | |'''FrObjects''' | ||
|Transpordi objektid (aknas peidetud) | |Transpordi objektid (aknas peidetud) | ||
| | |Freight objects (hidden in window) | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|'''InvAddr3''' | |'''InvAddr3''' | ||
|Arve aadress rida 4 | |Arve aadress rida 4 | ||
| | |Invoice address line 4 | ||
|60, String | |60, String | ||
|- | |- | ||
|'''InvAddr4''' | |'''InvAddr4''' | ||
|Arve aadress rida 5 | |Arve aadress rida 5 | ||
| | |Invoice address line 5 | ||
|60, String | |60, String | ||
|- | |- | ||
|'''DelAddr3''' | |'''DelAddr3''' | ||
|Lähetusaadress rida 4 | |Lähetusaadress rida 4 | ||
| | |Delivery address line 4 | ||
|60, String | |60, String | ||
|- | |- | ||
|'''DelAddr4''' | |'''DelAddr4''' | ||
|Lähetusaadress rida 5 | |Lähetusaadress rida 5 | ||
| | |Delivery address line 5 | ||
|60, String | |60, String | ||
|- | |- | ||
|'''DelAddrCode''' | |'''DelAddrCode''' | ||
|Lähetusaadresssi kood | |Lähetusaadresssi kood | ||
| | |Delivery address code | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''TAX1Sum''' | |'''TAX1Sum''' | ||
|Lisamaks | |Lisamaks | ||
| | |Ext. Tax | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''QuoteNr''' | |'''QuoteNr''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''InvBeforeShip''' | |'''InvBeforeShip''' | ||
|Arve enne lähetus linnuke | |Arve enne lähetus linnuke | ||
| | |Invoice Before Delivery flag | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''colnr''' | |'''colnr''' | ||
| | |''N/A'' | ||
| | |''N/A'' | ||
|46, Int represented by a Set of String | |46, Int represented by a Set of String | ||
|- | |- | ||
|'''OKFlag''' | |'''OKFlag''' | ||
|Kinnita linnuke | |Kinnita linnuke | ||
| | |OK (flag) | ||
|0, As Bool but displayed as a Checkbox | |0, As Bool but displayed as a Checkbox | ||
|- | |- | ||
|'''PlanShipDate''' | |'''PlanShipDate''' | ||
|Planeeritud lähetuse kuupäev | |Planeeritud lähetuse kuupäev | ||
| | |Planned Delivery | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|'''PrepaidAmount''' | |'''PrepaidAmount''' | ||
|Ettemakstud summa | |Ettemakstud summa | ||
| | |Prepaid Amount | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''Region''' | |'''Region''' | ||
|Regioon | |Regioon | ||
| | |Region | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''RefStr''' | |'''RefStr''' | ||
|Viide | |Viide | ||
| | |Reference | ||
|60, String | |60, String | ||
|- | |- | ||
|'''GroupOrdNr''' | |'''GroupOrdNr''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''NoDelivery''' | |'''NoDelivery''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''NoInvoice''' | |'''NoInvoice''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''TAX2Sum''' | |'''TAX2Sum''' | ||
|Maks 2 | |Maks 2 | ||
| | |Tax2 | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''NoTax1''' | |'''NoTax1''' | ||
|Lisamaksuta (aknas peidetud) | |Lisamaksuta (aknas peidetud) | ||
| | |Without extra tax (hidden in window) | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''NoTax2''' | |'''NoTax2''' | ||
|Masuta 2 (aknas peidetud) | |Masuta 2 (aknas peidetud) | ||
| | |Without tax2 (hidden in window) | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''BranchID''' | |'''BranchID''' | ||
|Filiaal | |Filiaal | ||
| | |Branch | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''NoTAXonVAT''' | |'''NoTAXonVAT''' | ||
|Arvuta lisamaks summast koos käibemaksuga (aknas peidetud) | |Arvuta lisamaks summast koos käibemaksuga (aknas peidetud) | ||
| | |Calc extra tax on sum without VAT (flag, hidden in window) | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''TotalwoTAX''' | |'''TotalwoTAX''' | ||
|Kokku ei sisalda lisamaksu (aknas peidetud) | |Kokku ei sisalda lisamaksu (aknas peidetud) | ||
| | |Total does not incl extra tax (flag, hidden in window) | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''OrderType''' | |'''OrderType''' | ||
|Tellimuse tüüp (aknas peidetud) | |Tellimuse tüüp (aknas peidetud) | ||
| | |Order type (flag, hidden in window) | ||
|433, Int represented by a Set of String | |433, Int represented by a Set of String | ||
|- | |- | ||
|'''AcceptanceStatus''' | |'''AcceptanceStatus''' | ||
|Kinnitamise staatus (aknas peidetud) | |Kinnitamise staatus (aknas peidetud) | ||
| | |Acceptance status (hidden in window) | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''CustTaxTemplateCode''' | |'''CustTaxTemplateCode''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|'''TaxMatrix''' | |'''TaxMatrix''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Packed Matrix, base64 data | |0, Packed Matrix, base64 data | ||
|- | |- | ||
|'''TerminalID''' | |'''TerminalID''' | ||
|Terminali ID (aknas peidetud) | |Terminali ID (aknas peidetud) | ||
| | |Terminal ID (hidden in window) | ||
|60, String | |60, String | ||
|- | |- | ||
|'''OfficialSerNr''' | |'''OfficialSerNr''' | ||
|Ametlik seerianumber | |Ametlik seerianumber | ||
| | |Official no. | ||
|100, String | |100, String | ||
|- | |- | ||
|'''Hash''' | |'''Hash''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|255, String | |255, String | ||
|- | |- | ||
|'''HashKeyVersion''' | |'''HashKeyVersion''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''RegDate''' | |'''RegDate''' | ||
|Kuupäev | |Kuupäev | ||
| | |Reg date (hidden in window) | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|'''RegTime''' | |'''RegTime''' | ||
|Kellaaeg | |Kellaaeg | ||
| | |Reg time (hidden in window) | ||
|0, Hour:Min:Secs | |0, Hour:Min:Secs | ||
|- | |- | ||
|'''LocalMachineCode''' | |'''LocalMachineCode''' | ||
|Terminalikoha kood (aknas peidetud) | |Terminalikoha kood (aknas peidetud) | ||
| | |Local machine Code (hidden in window) | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''InvCountry''' | |'''InvCountry''' | ||
|Arve saaja riigi kood 2kohaline | |Arve saaja riigi kood 2kohaline | ||
| | |Invice country ID (2-letter) | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|'''DelCountry''' | |'''DelCountry''' | ||
|Lähetuse saaja riigi kood 2kohaline | |Lähetuse saaja riigi kood 2kohaline | ||
| | |Delivery country ID (2-letter) | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|'''TREONr''' | |'''TREONr''' | ||
|TREO nr, | |TREO nr, | ||
| | |Treo no | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''TREOExpDate''' | |'''TREOExpDate''' | ||
|TREO kehtivuse kuupäev | |TREO kehtivuse kuupäev | ||
| | |Treo date | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|'''ORCONr''' | |'''ORCONr''' | ||
|Müügilepingu nr | |Müügilepingu nr | ||
| | |Sales Contract | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''AcceptanceBy''' | |'''AcceptanceBy''' | ||
|Kinnitaja(d) (aknas peidetud) | |Kinnitaja(d) (aknas peidetud) | ||
| | |Acceptance user list (hidden in window) | ||
|200, Comma separated List | |200, Comma separated List | ||
|- | |- | ||
|'''AcceptanceFYI''' | |'''AcceptanceFYI''' | ||
|Infoks isikud (aknas peidetud) | |Infoks isikud (aknas peidetud) | ||
| | |FYI user list (hidden in window) | ||
|200, Comma separated List | |200, Comma separated List | ||
|- | |- | ||
|'''BankCode''' | |'''BankCode''' | ||
|Pangakood (aknas peidetud) | |Pangakood (aknas peidetud) | ||
| | |Bank code (hidden in window) | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|'''InvCountryName''' | |'''InvCountryName''' | ||
|Arve saaja riigi nimi | |Arve saaja riigi nimi | ||
| | |Invice country Name | ||
|100, String | |100, String | ||
|- | |- | ||
|'''DelCountryName''' | |'''DelCountryName''' | ||
|Lähetuse saaja riigi nimi | |Lähetuse saaja riigi nimi | ||
| | |Delivery country Name | ||
|100, String | |100, String | ||
|- | |- | ||
|'''OfficialSerNrSerie''' | |'''OfficialSerNrSerie''' | ||
|Seeria (aknas peidetud) | |Seeria (aknas peidetud) | ||
| | |Official number series (hidden in window) | ||
|30, String | |30, String | ||
|- | |- | ||
|'''RecipientGLN''' | |'''RecipientGLN''' | ||
|Saaja GLN | |Saaja GLN | ||
| | |Invoice GLN | ||
|20, String | |20, String | ||
|- | |- | ||
|'''DelRecipientGLN''' | |'''DelRecipientGLN''' | ||
|Kauba Saaja GLN | |Kauba Saaja GLN | ||
| | |Delivery GLN | ||
|20, String | |20, String | ||
|- | |- | ||
|'''IntrastatTransCode''' | |'''IntrastatTransCode''' | ||
|Intrastati kandekood | |Intrastati kandekood | ||
| | |Intrastat code | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''Comment2''' | |'''Comment2''' | ||
|Kommentaar (rida 3) | |Kommentaar (rida 3) | ||
| | |Comment line 3 | ||
|100, String | |100, String | ||
|- | |- | ||
|'''Comment3''' | |'''Comment3''' | ||
|Kommentaar (rida 4) | |Kommentaar (rida 4) | ||
| | |Comment line 4 | ||
|100, String | |100, String | ||
|- | |- | ||
|'''Comment4''' | |'''Comment4''' | ||
|Kommentaar (rida 5) | |Kommentaar (rida 5) | ||
| | |Comment line 5 | ||
|100, String | |100, String | ||
|- | |- | ||
|'''PONr''' | |'''PONr''' | ||
|Ostutellimuse nr | |Ostutellimuse nr | ||
| | |Purchase order no | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''CompNr''' | |'''CompNr''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''OYNr''' | |'''OYNr''' | ||
| | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''OYDescription''' | |'''OYDescription''' | ||
| | |''N/A'' | ||
| | |''N/A'' | ||
|200, String | |200, String | ||
|- | |- | ||
|'''SHShipSetToZero''' | |'''SHShipSetToZero''' | ||
|Lähetatud kogus 0 | |Lähetatud kogus 0 | ||
| | |Delivery quantity to 0 | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''RvrsVAT''' | |'''RvrsVAT''' | ||
| | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''PromotionCodes''' | |'''PromotionCodes''' | ||
|N/A | |N/A | ||
| | |''N/A'' | ||
|200, Comma separated List | |200, Comma separated List | ||
|- | |- | ||
! colspan="4" |<big>↓↓↓ '''Maatriksi read korduvad tühja reani ↓↓↓'''</big> | |||
|- | |- | ||
|'''stp''' | |'''stp''' | ||
| | |Rea tüüp. Enamasti 1, aga on olemas [[Ridade tüübid ehk võimalikud "stp" väärtused|STP koodide spec]] | ||
| | |Mostly 1, but possible [[Ridade tüübid ehk võimalikud "stp" väärtused|STP values are described]] | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''ArtCode''' | |'''ArtCode''' | ||
|Artiklikood | |Artiklikood | ||
| | |Item code | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''Quant''' | |'''Quant''' | ||
|Kogus | |Kogus | ||
| | |Qty | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|'''Price''' | |'''Price''' | ||
|Ühikuhind | |Ühikuhind | ||
| | |Unit Price | ||
|0, Value with 2 or 3 Decimals | |0, Value with 2 or 3 Decimals | ||
|- | |- | ||
|'''Sum''' | |'''Sum''' | ||
|Summa | |Summa | ||
| | |Sum | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''vRebate''' | |'''vRebate''' | ||
|Allah % | |Allah % | ||
| | |Discount % | ||
|0, Value with One Decimal | |0, Value with One Decimal | ||
|- | |- | ||
|'''SalesAcc''' | |'''SalesAcc''' | ||
|Müügikonto | |Müügikonto | ||
| | |A/C | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|'''Shipd1''' | |'''Shipd1''' | ||
|Läh. 1 | |Läh. 1 | ||
| | |Del | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|'''Shipd2''' | |'''Shipd2''' | ||
|Läh. 2 | |Läh. 2 | ||
| | |Del. Ok | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|'''Invd''' | |'''Invd''' | ||
|Arveldatud | |Arveldatud | ||
| | |Invoiced | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|'''Objects''' | |'''Objects''' | ||
|Objektid | |Objektid | ||
| | |Tag/Object | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|'''BasePrice''' | |'''BasePrice''' | ||
| | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value with 2 or 3 Decimals | |0, Value with 2 or 3 Decimals | ||
|- | |- | ||
|'''rowGP''' | |'''rowGP''' | ||
|Rea müügikate | |Rea müügikate | ||
| | |GP | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''Spec''' | |'''Spec''' | ||
|Kirjeldus | |Kirjeldus | ||
| | |Description | ||
|100, String | |100, String | ||
|- | |- | ||
|'''VATCode''' | |'''VATCode''' | ||
|KM kood | |KM kood | ||
| | |V-Cd | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|'''Recepy''' | |'''Recepy''' | ||
|Retsept | |Retsept | ||
| | |Recepy | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''SerialNr''' | |'''SerialNr''' | ||
|Seerianumber | |Seerianumber | ||
| | |Serial No. | ||
|60, String | |60, String | ||
|- | |- | ||
|'''PriceFactor''' | |'''PriceFactor''' | ||
|Hinnafaktor | |Hinnafaktor | ||
| | |Price factor | ||
|0, Value with All Decimals | |0, Value with All Decimals | ||
|- | |- | ||
|'''VARList''' | |'''VARList''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|30, Capital Characters Only | |30, Capital Characters Only | ||
|- | |- | ||
|'''Location''' | |'''Location''' | ||
|Ladu | |Ladu | ||
| | |Location | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|'''Source''' | |'''Source''' | ||
|Allikas | |Allikas | ||
| | |Source | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|'''PickingDate''' | |'''PickingDate''' | ||
|Rea noppe kuupäev (YYYY-MM-DD) | |Rea noppe kuupäev (YYYY-MM-DD) | ||
| | |Pick Date | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|'''PickingTime''' | |'''PickingTime''' | ||
|Rea noppe aeg (HH:MM:SS) | |Rea noppe aeg (HH:MM:SS) | ||
| | |Pick Time | ||
|20, String | |20, String | ||
|- | |- | ||
|'''InloadingDate''' | |'''InloadingDate''' | ||
|Rea laadimise kuupäev (YYYY-MM-DD) | |Rea laadimise kuupäev (YYYY-MM-DD) | ||
| | |Inl Date | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|'''InloadingTime''' | |'''InloadingTime''' | ||
|Rea laadimise aeg (HH:MM:SS) | |Rea laadimise aeg (HH:MM:SS) | ||
| | |Inl Time | ||
|20, String | |20, String | ||
|- | |- | ||
|'''DespatchRowDate''' | |'''DespatchRowDate''' | ||
|Rea saatmise kuupäev (YYYY-MM-DD) | |Rea saatmise kuupäev (YYYY-MM-DD) | ||
| | |Desp. Date | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|'''DespatchRowTime''' | |'''DespatchRowTime''' | ||
|Rea saatmise aeg (HH:MM:SS) | |Rea saatmise aeg (HH:MM:SS) | ||
| | |Desp Time | ||
|20, String | |20, String | ||
|- | |- | ||
|'''PlanShipRow''' | |'''PlanShipRow''' | ||
|Rea planeeritud lähetus | |Rea planeeritud lähetus | ||
| | |Plan Del | ||
|10, String | |10, String | ||
|- | |- | ||
|'''ShipNote''' | |'''ShipNote''' | ||
|Saateleht | |Saateleht | ||
| | |Delivery note | ||
|60, String | |60, String | ||
|- | |- | ||
|'''UnitCode''' | |'''UnitCode''' | ||
|Ühik | |Ühik | ||
| | |Uni | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|'''UnitFactQuant''' | |'''UnitFactQuant''' | ||
|Ühiku kogus | |Ühiku kogus | ||
| | |Unit quantity | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|'''UnitFactPrice''' | |'''UnitFactPrice''' | ||
|Ühiku hind | |Ühiku hind | ||
| | |Unit price | ||
|0, Value with 2 or 3 Decimals | |0, Value with 2 or 3 Decimals | ||
|- | |- | ||
|'''UnitXval''' | |'''UnitXval''' | ||
|Ühiku laius | |Ühiku laius | ||
| | |Wight | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|'''UnitYval''' | |'''UnitYval''' | ||
|Ühiku kõrgus | |Ühiku kõrgus | ||
| | |Hight | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|'''UnitZval''' | |'''UnitZval''' | ||
|Ühiku sügavus | |Ühiku sügavus | ||
| | |Depth | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|'''Coefficient''' | |'''Coefficient''' | ||
|Koefitsent | |Koefitsent | ||
| | |Coefficent | ||
|0, Value with All Decimals | |0, Value with All Decimals | ||
|- | |- | ||
|'''VECode''' | |'''VECode''' | ||
|Tarnija kood | |Tarnija kood | ||
| | |Cust item code | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''Production''' | |'''Production''' | ||
|Tootmine | |Tootmine (aknas peidetud) | ||
| | |Production (hidden in window) | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''GroupOrdRow''' | |'''GroupOrdRow''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''TAX2Code''' | |'''TAX2Code''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|'''TAX2Prc''' | |'''TAX2Prc''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value with 2 or 3 Decimals | |0, Value with 2 or 3 Decimals | ||
|- | |- | ||
|'''TAX2Reb''' | |'''TAX2Reb''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''TAX1Reb''' | |'''TAX1Reb''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''TAX2Acc''' | |'''TAX2Acc''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|'''PlanShipRowDate''' | |'''PlanShipRowDate''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|'''CUServiceHistNr''' | |'''CUServiceHistNr''' | ||
|Kl.teen.lep.nr. | |Kl.teen.lep.nr. | ||
| | |Customer service contact no | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''CUServiceUntilDate''' | |'''CUServiceUntilDate''' | ||
|Kl.teen.lep. kehtivuse aeg | |Kl.teen.lep. kehtivuse aeg | ||
| | |Customer service contact end date | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|'''Position''' | |'''Position''' | ||
|Asukoht | |Asukoht | ||
| | |Position | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''RowOrderType''' | |'''RowOrderType''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|433, Int represented by a Set of String | |433, Int represented by a Set of String | ||
|- | |- | ||
|'''TaxTemplateCode''' | |'''TaxTemplateCode''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|'''TaxMatrix''' | |'''TaxMatrix''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Packed Matrix, base64 data | |0, Packed Matrix, base64 data | ||
|- | |- | ||
|'''SerNr''' | |'''SerNr''' | ||
|Seerianumber | |Seerianumber | ||
| | |Serial no | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|'''RoundVal''' | |'''RoundVal''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|'''Region''' | |'''Region''' | ||
|Regioon | |Regioon | ||
| | |Region | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''Perceptions''' | |'''Perceptions''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|'''MotherArtCode''' | |'''MotherArtCode''' | ||
|N/A | |''N/A'' | ||
| | |''N/A'' | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''RecipeQuant''' | |'''RecipeQuant''' | ||
|Retsepti kogus | |Retsepti kogus | ||
| | |Recepie quantity | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|'''CustArtCode''' | |'''CustArtCode''' | ||
|Kliendi artiklikood | |Kliendi artiklikood | ||
| | |Customer item code | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|'''Salesmen''' | |'''Salesmen''' | ||
|Müügimees (real) | |Müügimees (real) | ||
| | |Salesman | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|'''OrderType''' | |'''OrderType''' | ||
|Tellimuse tüüp (real) | |Tellimuse tüüp (real) | ||
| | |Order type | ||
|626, Int represented by a Set of String | |626, Int represented by a Set of String | ||
|- | |- | ||
|'''UnitComment''' | |'''UnitComment''' | ||
|Ühiku kommentaar | |Ühiku kommentaar | ||
| | |Unit comment | ||
|200, String | |200, String | ||
|- | |- | ||
|'''DiscApprovedBy''' | |'''DiscApprovedBy''' | ||
|N/A | |N/A | ||
| | |''N/A'' | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|'''ServiceDelDate''' | |'''ServiceDelDate''' | ||
|N/A | |N/A | ||
| | |''N/A'' | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|'''RvrsVATCode''' | |'''RvrsVATCode''' | ||
|N/A | |N/A | ||
| | |''N/A'' | ||
|10, Code String | |10, Code String | ||
|} | |} | ||
Viimane redaktsioon: 8. aprill 2025, kell 06:31
Ühe täidetud müügitellimuse saab pärida siit:
https://mars.excellent.ee:4455/api/1/orvc?sort=SerNr&range=103
window ORDClass:2
Väljade loetelu
| Kood | Kirjeldus | Description in ENG | Max pikkus, andme tüüp |
|---|---|---|---|
| UUID | Tehnilised väljad | Technical fields, not available in GUI | 0, Universally unique identifier |
| ServerSequence | 0, Unsigned 64-bit value | ||
| SyncFlags | 0, Value with No Decimals | ||
| SerNr | Tellimuse nr | Order no | 0, Value with No Decimals |
| OrdDate | Tellimuse kuupäev | Order date | 0, In Dataformat Order |
| CustCode | Kliendi kood | Customer code | 20, Code String |
| Addr0 | Kliendi nimi | Customer name | 60, String |
| Addr1 | Kliendi arveaadressi 2. rida | Invoice address line 2 | 60, String |
| Addr2 | Kliendi arveaadressi 3. rida | Invoice address line 3 | 60, String |
| Addr3 | Kliendi arveaadressi 4. rida | Invoice address line 4 | 60, String |
| OurContact | Meie esindaja | Our reference | 20, String |
| CustContact | Kliendi esindaja | Attention (Customer reference) | 60, String |
| ExportFlag | Käibemaksutsoon
0 = „Eesti“ 1 = „EL“, 2 = „EL (konteeri KM)“, 3 = „Mitte EL“ 4 = „Mitte EL (konteeri KM) |
VAT zone | 0, Small Value with No Decimals |
| InvFlag | Arve tehtud? Linnuke sirvi aknas | Invoice created (Hidden field) | 0, Small Value with No Decimals |
| ShipFlag | Lähetus tehtud? Linnuke sirvi aknas | Delivery created (Hidden field) | 0, Small Value with No Decimals |
| Prntdf | Saadetud? Peidetud väli | Sent? (Hidden field) | 0, Small Value with No Decimals |
| PayDeal | Tasumistingimus | Pyment term | 2, Code String |
| CustCat | Kliendiklass | Customer category code | 5, Code String |
| InvMark | Arve | Invoice created (visible in browse window) | 0, As Bool but displayed as a Checkbox |
| ShipMark | Lähetus | Delivery created (visible in browse window) | 0, As Bool but displayed as a Checkbox |
| Objects | Objektid | Objects | 60, Capital Characters Only |
| ShipMode | Lähetusviis | Delivery mode | 5, Code String |
| OrderStatus | Eksporditud linnuke (0=ei; 1=jah) | Exported flag (0=no; 1=yes) | 0, Small Value with No Decimals |
| PlanShip | Planeeritud lähetus | Planned delivery | 10, String |
| SalesMan | Müügimees | Salesman | 60, Capital Characters Only |
| Sign | Tellimuse koostaja (peidetud väli, programmi sisse logitud kasutaja, kes tellimuse koostas) | Order creator (Hidden field, username who created order) | 10, Code String |
| ShipDeal | Lähtustingimus | Delivery terms | 5, Code String |
| ShipAddr0 | Lähetusaadressi 1. rida | Delivery address line 1 | 60, String |
| ShipAddr1 | Lähetusaadressi 2. rida | Delivery address line 2 | 60, String |
| ShipAddr2 | Lähetusaadressi 3. rida | Delivery address line 3 | 60, String |
| ShipAddr3 | Lähetusaadressi 4. rida | Delivery address line 4 | 60, String |
| CurncyCode | Valuuta | Currency code | 5, Code String |
| LangCode | Keele | Language | 5, Code String |
| InvoiceToCode | Arve saaja | Invoice to | 20, Code String |
| Closed | Suletud | Closed flag ((0=no; 1=yes) | 0, As Bool but displayed as a Checkbox |
| ToRateB1 | Baasvaluuta 1 (kurss) | Base currency 1 | 0, Value with 6 Decimals |
| BuildOn | N/A | N/A | 0, Small Value with No Decimals |
| PRCode | Projekti kood | Project | 20, Code String |
| Comment | Kommentaar | Comment | 60, String |
| InvOnlyOnFull | N/A | N/A | 0, Small Value with No Decimals |
| DownPaySent | Ettemakstud (Aknas peidetud) | Prepayment sent (Hidden in GUI) | 0, Value 2 or 3 Decimals |
| DownPayRedcd | Ettemaks laekunud (Aknas peidetud) | Prepayment recieved (Hidden in GUI) | 0, Value 2 or 3 Decimals |
| OrderClass | Tellimuse klass | Order class | 5, Code String |
| CustOrdNr | Kliendi tellimuse number | Customer order no | 60, String |
| PriceList | Hinnakiri | Price list | 5, Code String |
| InclVAT | K.a. käibemaks (Aknas peidetud) | Includes VAT (Hidden in GUI) | 0, Small Value with No Decimals |
| Sum0 | Ümardus (Aknas peidetud) | Rounding (Hidden in GUI) | 0, Value 2 or 3 Decimals |
| Sum1 | Vahesumma | Subtotal | 0, Value 2 or 3 Decimals |
| Sum2 | (Aknas peidetud) | (Hidden in GUI) | 0, Value 2 or 3 Decimals |
| Sum3 | KM summa | VAT | 0, Value 2 or 3 Decimals |
| Sum4 | Kokku | TOTAL | 0, Value 2 or 3 Decimals |
| Reserved | Reserveeritud linnuke | Reserveed flag | 0, Small Value with No Decimals |
| OSFlag | N/A | N/A | 0, Small Value with No Decimals |
| Location | Ladu | Location | 10, Code String |
| CustVATCode | Kliendi müügi KM kood (Aknas peidetud, tuleb kontaktikaardilt) | Customer VAT code (hidden in GUI) | 10, Code String |
| RebCode | Hinnaalandusmaatriks | Discount matrix | 5, Code String |
| VATNr | N/A | N/A | 20, String |
| Phone | Kliendi telefon | Customer phone | 20, String with phone-number |
| Fax | Kliendi faks | Customer fax | 20, String |
| ExportedFlag | N/A | N/A | 0, Small Value with No Decimals |
| BaseSum4 | Kokku (Baasvaluutas) | TOTAL in Base 1 | 0, Value 2 or 3 Decimals |
| FrRate | Kurss | Rate | 0, Value with 6 Decimals |
| ToRateB2 | Baasvaluuta 2 | 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 |
| DiscPerc | Allahindlusprotsent (aknas peidetud. NB: päise väli) | Discount % (hidden in GUI) | 0, Value with minimum Decimals |
| DiscSum | Allahindluse summa (aknas peidetud. NB: päise väli) | Discount sum (hidden in GUI) | 0, Value 2 or 3 Decimals |
| TotGP | Kokku müügikatte summa | Total GP | 0, Value 2 or 3 Decimals |
| Probability | Tõnäosuse protsent (aknas peidetud, seotud pakkumisega) | Probability (Hidden in GUI, comes from Quotation) | 0, Value with One Decimal |
| CreditCard | Krediitkaardi kood | Credi Card code | 20, Capital Characters Only |
| AuthorizationCode | Isikutuvastus | Authorization Code | 10, Capital Characters Only |
| GPProc | Müügikate % | GP % | 0, Value with One Decimal |
| DespatchDate | Saatmise kuupäev | Dispatch date | 0, In Dataformat Order |
| DespatchTime | Saatmise aeg (kellaaeg) | Dispatch time | 0, Hour:Min:Secs |
| SalesGroup | Müügigrupp | Sales Group | 30, Capital Characters Only |
| Sorting | Teekond | Route | 20, String |
| TotQty | Kogus kokku | Total quantity | 0, Value with minimum Decimals |
| TotWeight | Kaal kokku | Total weight | 0, Value with minimum Decimals |
| TotVolume | Maht kokku | Total volume | 0, Value with minimum Decimals |
| Commision | Komisjonitasu | Comission | 0, Value 2 or 3 Decimals |
| SumIncCom | Kokku koos teenustasuga | Total Incl. Com. | 0, Value 2 or 3 Decimals |
| FrPrice | Transpordi hind | Freight | 0, Value 2 or 3 Decimals |
| FrBase | N/A | N/A | 0, Value 2 or 3 Decimals |
| FrItem | Transpordi artiklikood | Freight item code | 20, Code String |
| FrVATCode | Transpordi KM kood | Freight VAT code | 10, Code String |
| FrObjects | Transpordi objektid (aknas peidetud) | Freight objects (hidden in window) | 60, Capital Characters Only |
| InvAddr3 | Arve aadress rida 4 | Invoice address line 4 | 60, String |
| InvAddr4 | Arve aadress rida 5 | Invoice address line 5 | 60, String |
| DelAddr3 | Lähetusaadress rida 4 | Delivery address line 4 | 60, String |
| DelAddr4 | Lähetusaadress rida 5 | Delivery address line 5 | 60, String |
| DelAddrCode | Lähetusaadresssi kood | Delivery address code | 20, Code String |
| TAX1Sum | Lisamaks | Ext. Tax | 0, Value 2 or 3 Decimals |
| QuoteNr | N/A | N/A | 0, Value with No Decimals |
| InvBeforeShip | Arve enne lähetus linnuke | Invoice Before Delivery flag | 0, Small Value with No Decimals |
| colnr | N/A | N/A | 46, Int represented by a Set of String |
| OKFlag | Kinnita linnuke | OK (flag) | 0, As Bool but displayed as a Checkbox |
| PlanShipDate | Planeeritud lähetuse kuupäev | Planned Delivery | 0, In Dataformat Order |
| PrepaidAmount | Ettemakstud summa | Prepaid Amount | 0, Value 2 or 3 Decimals |
| Region | Regioon | Region | 20, Code String |
| RefStr | Viide | Reference | 60, String |
| GroupOrdNr | N/A | N/A | 0, Value with No Decimals |
| NoDelivery | N/A | N/A | 0, Small Value with No Decimals |
| NoInvoice | N/A | N/A | 0, Small Value with No Decimals |
| TAX2Sum | Maks 2 | Tax2 | 0, Value 2 or 3 Decimals |
| NoTax1 | Lisamaksuta (aknas peidetud) | Without extra tax (hidden in window) | 0, Small Value with No Decimals |
| NoTax2 | Masuta 2 (aknas peidetud) | Without tax2 (hidden in window) | 0, Small Value with No Decimals |
| BranchID | Filiaal | Branch | 20, Code String |
| NoTAXonVAT | Arvuta lisamaks summast koos käibemaksuga (aknas peidetud) | Calc extra tax on sum without VAT (flag, hidden in window) | 0, Value with No Decimals |
| TotalwoTAX | Kokku ei sisalda lisamaksu (aknas peidetud) | Total does not incl extra tax (flag, hidden in window) | 0, Small Value with No Decimals |
| OrderType | Tellimuse tüüp (aknas peidetud) | Order type (flag, hidden in window) | 433, Int represented by a Set of String |
| AcceptanceStatus | Kinnitamise staatus (aknas peidetud) | Acceptance status (hidden in window) | 0, Small Value with No Decimals |
| CustTaxTemplateCode | N/A | N/A | 10, Code String |
| TaxMatrix | N/A | N/A | 0, Packed Matrix, base64 data |
| TerminalID | Terminali ID (aknas peidetud) | Terminal ID (hidden in window) | 60, String |
| OfficialSerNr | Ametlik seerianumber | Official no. | 100, String |
| Hash | N/A | N/A | 255, String |
| HashKeyVersion | N/A | N/A | 0, Small Value with No Decimals |
| RegDate | Kuupäev | Reg date (hidden in window) | 0, In Dataformat Order |
| RegTime | Kellaaeg | Reg time (hidden in window) | 0, Hour:Min:Secs |
| LocalMachineCode | Terminalikoha kood (aknas peidetud) | Local machine Code (hidden in window) | 20, Code String |
| InvCountry | Arve saaja riigi kood 2kohaline | Invice country ID (2-letter) | 5, Code String |
| DelCountry | Lähetuse saaja riigi kood 2kohaline | Delivery country ID (2-letter) | 5, Code String |
| TREONr | TREO nr, | Treo no | 0, Value with No Decimals |
| TREOExpDate | TREO kehtivuse kuupäev | Treo date | 0, In Dataformat Order |
| ORCONr | Müügilepingu nr | Sales Contract | 0, Value with No Decimals |
| AcceptanceBy | Kinnitaja(d) (aknas peidetud) | Acceptance user list (hidden in window) | 200, Comma separated List |
| AcceptanceFYI | Infoks isikud (aknas peidetud) | FYI user list (hidden in window) | 200, Comma separated List |
| BankCode | Pangakood (aknas peidetud) | Bank code (hidden in window) | 10, Code String |
| InvCountryName | Arve saaja riigi nimi | Invice country Name | 100, String |
| DelCountryName | Lähetuse saaja riigi nimi | Delivery country Name | 100, String |
| OfficialSerNrSerie | Seeria (aknas peidetud) | Official number series (hidden in window) | 30, String |
| RecipientGLN | Saaja GLN | Invoice GLN | 20, String |
| DelRecipientGLN | Kauba Saaja GLN | Delivery GLN | 20, String |
| IntrastatTransCode | Intrastati kandekood | Intrastat code | 20, Code String |
| Comment2 | Kommentaar (rida 3) | Comment line 3 | 100, String |
| Comment3 | Kommentaar (rida 4) | Comment line 4 | 100, String |
| Comment4 | Kommentaar (rida 5) | Comment line 5 | 100, String |
| PONr | Ostutellimuse nr | Purchase order no | 0, Value with No Decimals |
| CompNr | N/A | N/A | 0, Value with No Decimals |
| OYNr | N/A | N/A | 0, Value with No Decimals |
| OYDescription | N/A | N/A | 200, String |
| SHShipSetToZero | Lähetatud kogus 0 | Delivery quantity to 0 | 0, Small Value with No Decimals |
| RvrsVAT | N/A | N/A | 0, Value 2 or 3 Decimals |
| PromotionCodes | N/A | N/A | 200, Comma separated List |
| ↓↓↓ Maatriksi read korduvad tühja reani ↓↓↓ | |||
| stp | Rea tüüp. Enamasti 1, aga on olemas STP koodide spec | Mostly 1, but possible STP values are described | 0, Small Value with No Decimals |
| ArtCode | Artiklikood | Item code | 20, Code String |
| Quant | Kogus | Qty | 0, Value with minimum Decimals |
| Price | Ühikuhind | Unit Price | 0, Value with 2 or 3 Decimals |
| Sum | Summa | Sum | 0, Value 2 or 3 Decimals |
| vRebate | Allah % | Discount % | 0, Value with One Decimal |
| SalesAcc | Müügikonto | A/C | 10, Code String |
| Shipd1 | Läh. 1 | Del | 0, Value with minimum Decimals |
| Shipd2 | Läh. 2 | Del. Ok | 0, Value with minimum Decimals |
| Invd | Arveldatud | Invoiced | 0, Value with minimum Decimals |
| Objects | Objektid | Tag/Object | 60, Capital Characters Only |
| BasePrice | N/A | N/A | 0, Value with 2 or 3 Decimals |
| rowGP | Rea müügikate | GP | 0, Value 2 or 3 Decimals |
| Spec | Kirjeldus | Description | 100, String |
| VATCode | KM kood | V-Cd | 10, Code String |
| Recepy | Retsept | Recepy | 20, Code String |
| SerialNr | Seerianumber | Serial No. | 60, String |
| PriceFactor | Hinnafaktor | Price factor | 0, Value with All Decimals |
| VARList | N/A | N/A | 30, Capital Characters Only |
| Location | Ladu | Location | 10, Code String |
| Source | Allikas | Source | 10, Code String |
| PickingDate | Rea noppe kuupäev (YYYY-MM-DD) | Pick Date | 0, In Dataformat Order |
| PickingTime | Rea noppe aeg (HH:MM:SS) | Pick Time | 20, String |
| InloadingDate | Rea laadimise kuupäev (YYYY-MM-DD) | Inl Date | 0, In Dataformat Order |
| InloadingTime | Rea laadimise aeg (HH:MM:SS) | Inl Time | 20, String |
| DespatchRowDate | Rea saatmise kuupäev (YYYY-MM-DD) | Desp. Date | 0, In Dataformat Order |
| DespatchRowTime | Rea saatmise aeg (HH:MM:SS) | Desp Time | 20, String |
| PlanShipRow | Rea planeeritud lähetus | Plan Del | 10, String |
| ShipNote | Saateleht | Delivery note | 60, String |
| UnitCode | Ühik | Uni | 5, Code String |
| UnitFactQuant | Ühiku kogus | Unit quantity | 0, Value with minimum Decimals |
| UnitFactPrice | Ühiku hind | Unit price | 0, Value with 2 or 3 Decimals |
| UnitXval | Ühiku laius | Wight | 0, Value with minimum Decimals |
| UnitYval | Ühiku kõrgus | Hight | 0, Value with minimum Decimals |
| UnitZval | Ühiku sügavus | Depth | 0, Value with minimum Decimals |
| Coefficient | Koefitsent | Coefficent | 0, Value with All Decimals |
| VECode | Tarnija kood | Cust item code | 20, Code String |
| Production | Tootmine (aknas peidetud) | Production (hidden in window) | 20, Code String |
| GroupOrdRow | N/A | N/A | 0, Value with No 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 |
| PlanShipRowDate | N/A | N/A | 0, In Dataformat Order |
| CUServiceHistNr | Kl.teen.lep.nr. | Customer service contact no | 0, Value with No Decimals |
| CUServiceUntilDate | Kl.teen.lep. kehtivuse aeg | Customer service contact end date | 0, In Dataformat Order |
| Position | Asukoht | Position | 20, Code String |
| RowOrderType | N/A | N/A | 433, Int represented by a Set of String |
| TaxTemplateCode | N/A | N/A | 60, Capital Characters Only |
| TaxMatrix | N/A | N/A | 0, Packed Matrix, base64 data |
| SerNr | Seerianumber | Serial no | 0, Value with No Decimals |
| RoundVal | N/A | N/A | 0, Value 2 or 3 Decimals |
| Region | Regioon | Region | 20, Code String |
| Perceptions | N/A | N/A | 0, Small Value with No Decimals |
| MotherArtCode | N/A | N/A | 20, Code String |
| RecipeQuant | Retsepti kogus | Recepie quantity | 0, Value with minimum Decimals |
| CustArtCode | Kliendi artiklikood | Customer item code | 20, Code String |
| Salesmen | Müügimees (real) | Salesman | 60, Capital Characters Only |
| OrderType | Tellimuse tüüp (real) | Order type | 626, Int represented by a Set of String |
| UnitComment | Ühiku kommentaar | Unit comment | 200, String |
| DiscApprovedBy | N/A | N/A | 10, Code String |
| ServiceDelDate | N/A | N/A | 0, In Dataformat Order |
| RvrsVATCode | N/A | N/A | 10, Code String |
XMLi näidis, Tellimus 4 reaga
<data register="ORVc" sequence="228949" sort="SerNr" key="SerNr" range="103:103" systemversion="8.4.21.1414">
<ORVc>
<UUID>285C241E-54503B44-A87EAF55-5BCE971D-BC7F9434</UUID>
<ServerSequence>0</ServerSequence>
<SyncFlags>1</SyncFlags>
<SerNr>103</SerNr>
<OrdDate>2018-04-09</OrdDate>
<CustCode>104</CustCode>
<Math/>
<Addr0>Creame Ltd.</Addr0>
<Addr1>Dream Str. 55</Addr1>
<Addr2>KL902 Chicago</Addr2>
<Addr3>United States</Addr3>
<OurContact>Grete Põdder</OurContact>
<CustContact>Jim Cox</CustContact>
<ExportFlag>2</ExportFlag>
<InvFlag>0</InvFlag>
<ShipFlag>0</ShipFlag>
<Prntdf>0</Prntdf>
<PayDeal>30</PayDeal>
<CustCat>VMAA</CustCat>
<InvMark>0</InvMark>
<ShipMark>0</ShipMark>
<Objects>10010,ANNIKA</Objects>
<ShipMode>12</ShipMode>
<OrderStatus>0</OrderStatus>
<PlanShip>10.04.2018</PlanShip>
<SalesMan>MA</SalesMan>
<Sign>KAUPO</Sign>
<ShipDeal>CFR</ShipDeal>
<ShipAddr0>Läh 1</ShipAddr0>
<ShipAddr1>Läh 2</ShipAddr1>
<ShipAddr2>Läh 3</ShipAddr2>
<ShipAddr3>Läh 4</ShipAddr3>
<CurncyCode>EUR</CurncyCode>
<LangCode/>
<InvoiceToCode>1063</InvoiceToCode>
<Closed>0</Closed>
<ToRateB1/>
<BuildOn>0</BuildOn>
<PRCode>10010</PRCode>
<Comment>...avastasin, et mul on Tsukerbergi imelises delikaatsete an</Comment>
<InvOnlyOnFull>0</InvOnlyOnFull>
<DownPaySent/>
<DownPayRedcd/>
<OrderClass>PROJ</OrderClass>
<CustOrdNr>KT876456734521</CustOrdNr>
<PriceList>DIMA</PriceList>
<InclVAT>0</InclVAT>
<Sum0>-0.13</Sum0>
<Sum1>3955.27</Sum1>
<Sum2/>
<Sum3/>
<Sum4>3955.25</Sum4>
<Reserved>0</Reserved>
<OSFlag>1</OSFlag>
<Location>PL</Location>
<CustVATCode/>
<RebCode/>
<VATNr>USEdf</VATNr>
<Phone>+190 234 4324</Phone>
<Fax>+190 234 2133</Fax>
<ExportedFlag>0</ExportedFlag>
<BaseSum4>3955.25</BaseSum4>
<FrRate/>
<ToRateB2/>
<BaseRate1>1</BaseRate1>
<BaseRate2>2</BaseRate2>
<DiscPerc/>
<DiscSum/>
<TotGP>1194.90</TotGP>
<Probability/>
<CreditCard/>
<AuthorizationCode/>
<GPProc>30.2</GPProc>
<DespatchDate>2018-04-11</DespatchDate>
<DespatchTime>15:13:06</DespatchTime>
<SalesGroup/>
<Sorting>TEK1</Sorting>
<TotQty>6</TotQty>
<TotWeight>9</TotWeight>
<TotVolume>210.5</TotVolume>
<Commision/>
<SumIncCom>3955.25</SumIncCom>
<FrPrice/>
<FrBase/>
<FrItem/>
<FrVATCode/>
<FrObjects/>
<InvAddr3>Ellmviivmane rida</InvAddr3>
<InvAddr4>Viimane rida</InvAddr4>
<DelAddr3>Läh 5</DelAddr3>
<DelAddr4>Läh 6</DelAddr4>
<DelAddrCode/>
<TAX1Sum>791.05</TAX1Sum>
<QuoteNr/>
<InvBeforeShip>1</InvBeforeShip>
<colnr>Must</colnr>
<OKFlag>0</OKFlag>
<PlanShipDate/>
<PrepaidAmount/>
<Region>G-POINT</Region>
<RefStr>VV2212113321231</RefStr>
<GroupOrdNr/>
<NoDelivery>0</NoDelivery>
<NoInvoice>0</NoInvoice>
<TAX2Sum/>
<NoTax1>0</NoTax1>
<NoTax2>0</NoTax2>
<BranchID/>
<NoTAXonVAT>1</NoTAXonVAT>
<TotalwoTAX>1</TotalwoTAX>
<OrderType>Tavaline</OrderType>
<AcceptanceStatus>0</AcceptanceStatus>
<CustTaxTemplateCode/>
<TaxMatrix/>
<TerminalID/>
<OfficialSerNr/>
<Hash/>
<HashKeyVersion>0</HashKeyVersion>
<RegDate>2018-04-09</RegDate>
<RegTime>15:14:05</RegTime>
<LocalMachineCode/>
<InvCountry>US</InvCountry>
<DelCountry/>
<TREONr/>
<TREOExpDate/>
<ORCONr/>
<AcceptanceBy/>
<AcceptanceFYI/>
<BankCode/>
<InvCountryName>Ameerika ?0?5hendriigid</InvCountryName>
<DelCountryName/>
<OfficialSerNrSerie/>
<RecipientGLN/>
<DelRecipientGLN/>
<IntrastatTransCode/>
<Comment2>andmete kogumise puhvetis ehk Facebook'is 800+ rahuldamata sõbrataotlust.</Comment2>
<Comment3>Ma päriselt ei kipu teadma, kes need inimesed on ja soovitan neile kõigile kasutada võimalust mind n</Comment3>
<Comment4> mida tõkestamatult keskeale lähenev meesolevus piiratud infot ja piiramatuid emotsioone evides maai</Comment4>
<PONr/>
<CompNr/>
<OYNr/>
<OYDescription/>
<SHShipSetToZero>0</SHShipSetToZero>
<RvrsVAT/>
<PromotionCodes/>
<rows>
<row rownumber="0">
<stp>1</stp>
<ArtCode>8960001101020</ArtCode>
<Quant>1</Quant>
<Price>39999.00</Price>
<Sum>3636.27</Sum>
<vRebate/>
<SalesAcc>1020</SalesAcc>
<Shipd1/>
<Shipd2/>
<Invd/>
<Objects>KONT,ANNIKA</Objects>
<BasePrice>27299.00</BasePrice>
<rowGP>1154.54</rowGP>
<Spec>FT20 main module</Spec>
<VATCode>20</VATCode>
<Recepy/>
<SerialNr/>
<PriceFactor>11.00</PriceFactor>
<VARList/>
<Location/>
<Source>IMP1</Source>
<PickingDate/>
<PickingTime/>
<InloadingDate/>
<InloadingTime/>
<DespatchRowDate/>
<DespatchRowTime/>
<PlanShipRow/>
<ShipNote/>
<UnitCode>KG</UnitCode>
<UnitFactQuant/>
<UnitFactPrice/>
<UnitXval>5</UnitXval>
<UnitYval>6</UnitYval>
<UnitZval>7</UnitZval>
<Coefficient/>
<VECode/>
<Production/>
<GroupOrdRow/>
<TAX2Code/>
<TAX2Prc/>
<TAX2Reb/>
<TAX1Reb/>
<TAX2Acc/>
<PlanShipRowDate/>
<CUServiceHistNr/>
<CUServiceUntilDate/>
<Position/>
<RowOrderType>Tavaline</RowOrderType>
<TaxTemplateCode/>
<TaxMatrix/>
<Region/>
<Perceptions>1</Perceptions>
<MotherArtCode/>
<RecipeQuant/>
<CustArtCode/>
<Salesmen/>
<OrderType>Drop Ship</OrderType>
<UnitComment>kilogramm</UnitComment>
<DiscApprovedBy/>
<ServiceDelDate/>
<RvrsVATCode/>
</row>
<row rownumber="1">
<stp>1</stp>
<ArtCode>0033001300002</ArtCode>
<Quant>1</Quant>
<Price>199.00</Price>
<Sum>199.00</Sum>
<vRebate/>
<SalesAcc/>
<Shipd1/>
<Shipd2/>
<Invd/>
<Objects/>
<BasePrice>199.00</BasePrice>
<rowGP>0.00</rowGP>
<Spec>680x1150 mm</Spec>
<VATCode>2</VATCode>
<Recepy/>
<SerialNr/>
<PriceFactor/>
<VARList/>
<Location/>
<Source/>
<PickingDate/>
<PickingTime/>
<InloadingDate/>
<InloadingTime/>
<DespatchRowDate/>
<DespatchRowTime/>
<PlanShipRow/>
<ShipNote/>
<UnitCode/>
<UnitFactQuant/>
<UnitFactPrice/>
<UnitXval/>
<UnitYval/>
<UnitZval/>
<Coefficient/>
<VECode/>
<Production/>
<GroupOrdRow/>
<TAX2Code/>
<TAX2Prc/>
<TAX2Reb/>
<TAX1Reb/>
<TAX2Acc/>
<PlanShipRowDate/>
<CUServiceHistNr/>
<CUServiceUntilDate/>
<Position/>
<RowOrderType>Tavaline</RowOrderType>
<TaxTemplateCode/>
<TaxMatrix/>
<Region/>
<Perceptions>0</Perceptions>
<MotherArtCode/>
<RecipeQuant/>
<CustArtCode/>
<Salesmen/>
<OrderType>Normaalne</OrderType>
<UnitComment/>
<DiscApprovedBy/>
<ServiceDelDate/>
<RvrsVATCode/>
</row>
<row rownumber="2">
<stp>1</stp>
<ArtCode>003</ArtCode>
<Quant>2</Quant>
<Price>49.00</Price>
<Sum>98.00</Sum>
<vRebate/>
<SalesAcc>3610</SalesAcc>
<Shipd1/>
<Shipd2/>
<Invd/>
<Objects/>
<BasePrice>39.819</BasePrice>
<rowGP>18.36</rowGP>
<Spec>"MP3-8 GB"</Spec>
<VATCode>2</VATCode>
<Recepy/>
<SerialNr/>
<PriceFactor/>
<VARList/>
<Location/>
<Source/>
<PickingDate/>
<PickingTime/>
<InloadingDate/>
<InloadingTime/>
<DespatchRowDate/>
<DespatchRowTime/>
<PlanShipRow/>
<ShipNote/>
<UnitCode>TK</UnitCode>
<UnitFactQuant/>
<UnitFactPrice/>
<UnitXval/>
<UnitYval/>
<UnitZval/>
<Coefficient/>
<VECode/>
<Production/>
<GroupOrdRow/>
<TAX2Code/>
<TAX2Prc/>
<TAX2Reb/>
<TAX1Reb/>
<TAX2Acc/>
<PlanShipRowDate/>
<CUServiceHistNr/>
<CUServiceUntilDate/>
<Position/>
<RowOrderType>Tavaline</RowOrderType>
<TaxTemplateCode/>
<TaxMatrix/>
<Region/>
<Perceptions>0</Perceptions>
<MotherArtCode/>
<RecipeQuant/>
<CustArtCode/>
<Salesmen/>
<OrderType>Normaalne</OrderType>
<UnitComment>tükk</UnitComment>
<DiscApprovedBy/>
<ServiceDelDate/>
<RvrsVATCode/>
</row>
<row rownumber="3">
<stp>1</stp>
<ArtCode>TOOKULU</ArtCode>
<Quant>2</Quant>
<Price>11.00</Price>
<Sum>22.00</Sum>
<vRebate/>
<SalesAcc/>
<Shipd1/>
<Shipd2/>
<Invd/>
<Objects/>
<BasePrice/>
<rowGP>22.00</rowGP>
<Spec>Töökulu</Spec>
<VATCode>2</VATCode>
<Recepy/>
<SerialNr/>
<PriceFactor/>
<VARList/>
<Location/>
<Source/>
<PickingDate/>
<PickingTime/>
<InloadingDate/>
<InloadingTime/>
<DespatchRowDate/>
<DespatchRowTime/>
<PlanShipRow/>
<ShipNote/>
<UnitCode/>
<UnitFactQuant/>
<UnitFactPrice/>
<UnitXval/>
<UnitYval/>
<UnitZval/>
<Coefficient/>
<VECode/>
<Production/>
<GroupOrdRow/>
<TAX2Code/>
<TAX2Prc/>
<TAX2Reb/>
<TAX1Reb/>
<TAX2Acc/>
<PlanShipRowDate/>
<CUServiceHistNr/>
<CUServiceUntilDate/>
<Position/>
<RowOrderType>Tavaline</RowOrderType>
<TaxTemplateCode/>
<TaxMatrix/>
<Region/>
<Perceptions>0</Perceptions>
<MotherArtCode/>
<RecipeQuant/>
<CustArtCode/>
<Salesmen/>
<OrderType>Normaalne</OrderType>
<UnitComment/>
<DiscApprovedBy/>
<ServiceDelDate/>
<RvrsVATCode/>
</row>
</rows>
</ORVc>
</data>
