Müügitellimused: erinevus redaktsioonide vahel

Allikas: Excellent || Opendoc
Mine navigeerimisribale Mine otsikasti
Resümee puudub
9. rida: 9. rida:
!Kood
!Kood
!Kirjeldus
!Kirjeldus
!Description in ENG
!Max pikkus, andme tüüp
!Max pikkus, andme tüüp
|-
|-
|'''UUID'''
|'''UUID'''
| rowspan="3" |Tehnilised väljad
| rowspan="3" |Tehnilised väljad
| rowspan="3" |Technical fields, not available in GUI
|0, Universally unique identifier
|0, Universally unique identifier
|-
|-
23. rida: 25. rida:
|'''SerNr'''
|'''SerNr'''
|Tellimuse nr
|Tellimuse nr
|Order no
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''OrdDate'''
|'''OrdDate'''
|Tellimuse kuupäev
|Tellimuse kuupäev
|Order date
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''CustCode'''
|'''CustCode'''
|Kliendi kood
|Kliendi kood
|Customer code
|20, Code String
|20, Code String
|-
|-
|'''Addr0'''
|'''Addr0'''
|Kliendi arveaadressi 1. rida
|Kliendi arveaadressi 1. rida
|Invoice address line 1
|60, String
|60, String
|-
|-
|'''Addr1'''
|'''Addr1'''
|Kliendi arveaadressi 2. rida
|Kliendi arveaadressi 2. rida
|Invoice address line 2
|60, String
|60, String
|-
|-
|'''Addr2'''
|'''Addr2'''
|Kliendi arveaadressi 3. rida
|Kliendi arveaadressi 3. rida
|Invoice address line 3
|60, String
|60, String
|-
|-
|'''Addr3'''
|'''Addr3'''
|Kliendi arveaadressi 4. rida
|Kliendi arveaadressi 4. rida
|Invoice address line 4
|60, String
|60, String
|-
|-
|'''OurContact'''
|'''OurContact'''
|Meie esindaja
|Meie esindaja
|Our reference
|20, String
|20, String
|-
|-
|'''CustContact'''
|'''CustContact'''
|Kliendi esindaja
|Kliendi esindaja
|Attention (Customer reference)
|60, String
|60, String
|-
|-
68. rida: 79. rida:


4 = „Mitte EL (konteeri KM)
4 = „Mitte EL (konteeri KM)
|VAT zone
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''InvFlag'''
|'''InvFlag'''
|Arve tehtud? Linnuke sirvi aknas
|Arve tehtud? Linnuke sirvi aknas
|
|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
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''Prntdf'''
|'''Prntdf'''
|Saadetud? Peidetud väli
|Saadetud? Peidetud väli
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''PayDeal'''
|'''PayDeal'''
|Tasumistingimus
|Tasumistingimus
|
|2, Code String
|2, Code String
|-
|-
|'''CustCat'''
|'''CustCat'''
|Kliendiklass
|Kliendiklass
|
|5, Code String
|5, Code String
|-
|-
|'''InvMark'''
|'''InvMark'''
|Arve
|Arve
|
|0, As Bool but displayed as a Checkbox
|0, As Bool but displayed as a Checkbox
|-
|-
|'''ShipMark'''
|'''ShipMark'''
|Läh
|Läh
|
|0, As Bool but displayed as a Checkbox
|0, As Bool but displayed as a Checkbox
|-
|-
|'''Objects'''
|'''Objects'''
|Objektid
|Objektid
|
|60, Capital Characters Only
|60, Capital Characters Only
|-
|-
|'''ShipMode'''
|'''ShipMode'''
|Lähetusviis
|Lähetusviis
|
|5, Code String
|5, Code String
|-
|-
|'''OrderStatus'''
|'''OrderStatus'''
|Eksporditud linnuke (0=ei; 1=jah)
|Eksporditud linnuke (0=ei; 1=jah)
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''PlanShip'''
|'''PlanShip'''
|Planeeritud lähetus
|Planeeritud lähetus
|
|10, String
|10, String
|-
|-
|'''SalesMan'''
|'''SalesMan'''
|Müügimees
|Müügimees
|
|60, Capital Characters Only
|60, Capital Characters Only
|-
|-
|'''Sign'''
|'''Sign'''
|Tellimuse koostaja (peidetud väli, programmi sisse logitud kasutaja, kes tellimuse koostas)
|Tellimuse koostaja (peidetud väli, programmi sisse logitud kasutaja, kes tellimuse koostas)
|
|10, Code String
|10, Code String
|-
|-
|'''ShipDeal'''
|'''ShipDeal'''
|Lähtustingimus
|Lähtustingimus
|
|5, Code String
|5, Code String
|-
|-
|'''ShipAddr0'''
|'''ShipAddr0'''
|Lähetusaadressi 1. rida
|Lähetusaadressi 1. rida
|
|60, String
|60, String
|-
|-
|'''ShipAddr1'''
|'''ShipAddr1'''
|Lähetusaadressi 2. rida
|Lähetusaadressi 2. rida
|
|60, String
|60, String
|-
|-
|'''ShipAddr2'''
|'''ShipAddr2'''
|Lähetusaadressi 3. rida
|Lähetusaadressi 3. rida
|
|60, String
|60, String
|-
|-
|'''ShipAddr3'''
|'''ShipAddr3'''
|Lähetusaadressi 4. rida
|Lähetusaadressi 4. rida
|
|60, String
|60, String
|-
|-
|'''CurncyCode'''
|'''CurncyCode'''
|Valuuta
|Valuuta
|
|5, Code String
|5, Code String
|-
|-
|'''LangCode'''
|'''LangCode'''
|Keele
|Keele
|
|5, Code String
|5, Code String
|-
|-
|'''InvoiceToCode'''
|'''InvoiceToCode'''
|Arve saaja
|Arve saaja
|
|20, Code String
|20, Code String
|-
|-
|'''Closed'''
|'''Closed'''
|Suletud
|Suletud
|
|0, As Bool but displayed as a Checkbox
|0, As Bool but displayed as a Checkbox
|-
|-
|'''ToRateB1'''
|'''ToRateB1'''
|Baasvaluuta 1 (kurss)
|Baasvaluuta 1 (kurss)
|
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''BuildOn'''
|'''BuildOn'''
|N/A
|N/A
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''PRCode'''
|'''PRCode'''
|Projekti kood
|Projekti kood
|
|20, Code String
|20, Code String
|-
|-
|'''Comment'''
|'''Comment'''
|Kommentaar
|Kommentaar
|
|60, String
|60, String
|-
|-
|'''InvOnlyOnFull'''
|'''InvOnlyOnFull'''
|N/A
|N/A
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''DownPaySent'''
|'''DownPaySent'''
|Ettemakstud (Aknas peidetud)
|Ettemakstud (Aknas peidetud)
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''DownPayRedcd'''
|'''DownPayRedcd'''
|Ettemaks laekunud (Aknas peidetud)
|Ettemaks laekunud (Aknas peidetud)
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''OrderClass'''
|'''OrderClass'''
|Tellimuse klass
|Tellimuse klass
|
|5, Code String
|5, Code String
|-
|-
|'''CustOrdNr'''
|'''CustOrdNr'''
|Kliendi tellimuse number
|Kliendi tellimuse number
|
|60, String
|60, String
|-
|-
|'''PriceList'''
|'''PriceList'''
|Hinnakiri
|Hinnakiri
|
|5, Code String
|5, Code String
|-
|-
|'''InclVAT'''
|'''InclVAT'''
|K.a. käibemaks (Aknas peidetud)
|K.a. käibemaks (Aknas peidetud)
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''Sum0'''
|'''Sum0'''
|Ümardus (Aknas peidetud)
|Ümardus (Aknas peidetud)
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Sum1'''
|'''Sum1'''
|Vahesumma
|Vahesumma
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Sum2'''
|'''Sum2'''
|(Aknas peidetud)
|(Aknas peidetud)
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Sum3'''
|'''Sum3'''
|KM summa
|KM summa
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Sum4'''
|'''Sum4'''
|Kokku
|Kokku
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Reserved'''
|'''Reserved'''
|Reserveeritud linnuke
|Reserveeritud linnuke
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''OSFlag'''
|'''OSFlag'''
|N/A
|N/A
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''Location'''
|'''Location'''
|Ladu
|Ladu
|
|10, Code String
|10, Code String
|-
|-
|'''CustVATCode'''
|'''CustVATCode'''
|Kliendi müügi KM kood (Aknas peidetud, tuleb kontaktikaardilt)
|Kliendi müügi KM kood (Aknas peidetud, tuleb kontaktikaardilt)
|
|10, Code String
|10, Code String
|-
|-
|'''RebCode'''
|'''RebCode'''
|Hinnaalandusmaatriks
|Hinnaalandusmaatriks
|
|5, Code String
|5, Code String
|-
|-
|'''VATNr'''
|'''VATNr'''
|N/A
|N/A
|
|20, String
|20, String
|-
|-
|'''Phone'''
|'''Phone'''
|Kliendi telefon
|Kliendi telefon
|
|20, String with phone-number
|20, String with phone-number
|-
|-
|'''Fax'''
|'''Fax'''
|Kliendi faks
|Kliendi faks
|
|20, String
|20, String
|-
|-
|'''ExportedFlag'''
|'''ExportedFlag'''
|N/A
|N/A
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''BaseSum4'''
|'''BaseSum4'''
|Kokku (Baasvaluutas)
|Kokku (Baasvaluutas)
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''FrRate'''
|'''FrRate'''
|Kurss
|Kurss
|
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''ToRateB2'''
|'''ToRateB2'''
|Baasvaluuta 2
|Baasvaluuta 2
|
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''BaseRate1'''
|'''BaseRate1'''
|Baasvaluuta 1
|Baasvaluuta 1
|
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''BaseRate2'''
|'''BaseRate2'''
|Baasvaluuta 2
|Baasvaluuta 2
|
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''DiscPerc'''
|'''DiscPerc'''
|Allahindlusprotsent (aknas peidetud. NB: päise väli)
|Allahindlusprotsent (aknas peidetud. NB: päise väli)
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''DiscSum'''
|'''DiscSum'''
|Allahindluse summa (aknas peidetud. NB: päise väli)
|Allahindluse summa (aknas peidetud. NB: päise väli)
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''TotGP'''
|'''TotGP'''
|Kokku müügikatte summa
|Kokku müügikatte summa
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Probability'''
|'''Probability'''
|Tõnäosuse protsent (aknas peidetud, seotud pakkumisega)
|Tõnäosuse protsent (aknas peidetud, seotud pakkumisega)
|
|0, Value with One Decimal
|0, Value with One Decimal
|-
|-
|'''CreditCard'''
|'''CreditCard'''
|Krediitkaardi kood
|Krediitkaardi kood
|
|20, Capital Characters Only
|20, Capital Characters Only
|-
|-
|'''AuthorizationCode'''
|'''AuthorizationCode'''
|Isikutuvastus
|Isikutuvastus
|
|10, Capital Characters Only
|10, Capital Characters Only
|-
|-
|'''GPProc'''
|'''GPProc'''
|Müügikate %
|Müügikate %
|
|0, Value with One Decimal
|0, Value with One Decimal
|-
|-
|'''DespatchDate'''
|'''DespatchDate'''
|Saatmise kuupäev
|Saatmise kuupäev
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''DespatchTime'''
|'''DespatchTime'''
|Saatmise aeg (kellaaeg)
|Saatmise aeg (kellaaeg)
|
|0, Hour:Min:Secs
|0, Hour:Min:Secs
|-
|-
|'''SalesGroup'''
|'''SalesGroup'''
|Müügigrupp
|Müügigrupp
|
|30, Capital Characters Only
|30, Capital Characters Only
|-
|-
|'''Sorting'''
|'''Sorting'''
|Teekond
|Teekond
|
|20, String
|20, String
|-
|-
|'''TotQty'''
|'''TotQty'''
|Kogus kokku
|Kogus kokku
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''TotWeight'''
|'''TotWeight'''
|Kaal kokku
|Kaal kokku
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''TotVolume'''
|'''TotVolume'''
|Maht kokku
|Maht kokku
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Commision'''
|'''Commision'''
|Komisjonitasu
|Komisjonitasu
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''SumIncCom'''
|'''SumIncCom'''
|Kokku koos teenustasuga
|Kokku koos teenustasuga
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''FrPrice'''
|'''FrPrice'''
|Transpordi hind
|Transpordi hind
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''FrBase'''
|'''FrBase'''
|N/A
|N/A
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''FrItem'''
|'''FrItem'''
|Transpordi artiklikood
|Transpordi artiklikood
|
|20, Code String
|20, Code String
|-
|-
|'''FrVATCode'''
|'''FrVATCode'''
|Transpordi KM kood
|Transpordi KM kood
|
|10, Code String
|10, Code String
|-
|-
|'''FrObjects'''
|'''FrObjects'''
|Transpordi objektid (aknas peidetud)
|Transpordi objektid (aknas peidetud)
|
|60, Capital Characters Only
|60, Capital Characters Only
|-
|-
|'''InvAddr3'''
|'''InvAddr3'''
|Arve aadress rida 4
|Arve aadress rida 4
|
|60, String
|60, String
|-
|-
|'''InvAddr4'''
|'''InvAddr4'''
|Arve aadress rida 5
|Arve aadress rida 5
|
|60, String
|60, String
|-
|-
|'''DelAddr3'''
|'''DelAddr3'''
|Lähetusaadress rida 4
|Lähetusaadress rida 4
|
|60, String
|60, String
|-
|-
|'''DelAddr4'''
|'''DelAddr4'''
|Lähetusaadress rida 5
|Lähetusaadress rida 5
|
|60, String
|60, String
|-
|-
|'''DelAddrCode'''
|'''DelAddrCode'''
|Lähetusaadresssi kood
|Lähetusaadresssi kood
|
|20, Code String
|20, Code String
|-
|-
|'''TAX1Sum'''
|'''TAX1Sum'''
|Lisamaks
|Lisamaks
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''QuoteNr'''
|'''QuoteNr'''
|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
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''colnr'''
|'''colnr'''
|värv (aknas peidetud)
|värv (aknas peidetud)
|
|46, Int represented by a Set of String
|46, Int represented by a Set of String
|-
|-
|'''OKFlag'''
|'''OKFlag'''
|Kinnita linnuke
|Kinnita linnuke
|
|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
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''PrepaidAmount'''
|'''PrepaidAmount'''
|Ettemakstud summa
|Ettemakstud summa
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Region'''
|'''Region'''
|Regioon
|Regioon
|
|20, Code String
|20, Code String
|-
|-
|'''RefStr'''
|'''RefStr'''
|Viide
|Viide
|
|60, String
|60, String
|-
|-
|'''GroupOrdNr'''
|'''GroupOrdNr'''
|N/A
|N/A
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''NoDelivery'''
|'''NoDelivery'''
|N/A
|N/A
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''NoInvoice'''
|'''NoInvoice'''
|N/A
|N/A
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''TAX2Sum'''
|'''TAX2Sum'''
|Maks 2
|Maks 2
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''NoTax1'''
|'''NoTax1'''
|Lisamaksuta (aknas peidetud)
|Lisamaksuta (aknas peidetud)
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''NoTax2'''
|'''NoTax2'''
|Masuta 2 (aknas peidetud)
|Masuta 2 (aknas peidetud)
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''BranchID'''
|'''BranchID'''
|Filiaal
|Filiaal
|
|20, Code String
|20, Code String
|-
|-
|'''NoTAXonVAT'''
|'''NoTAXonVAT'''
|Arvuta lisamaks summast koos käibemaksuga (aknas peidetud)
|Arvuta lisamaks summast koos käibemaksuga (aknas peidetud)
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''TotalwoTAX'''
|'''TotalwoTAX'''
|Kokku ei sisalda lisamaksu (aknas peidetud)
|Kokku ei sisalda lisamaksu (aknas peidetud)
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''OrderType'''
|'''OrderType'''
|Tellimuse tüüp (aknas peidetud)
|Tellimuse tüüp (aknas peidetud)
|
|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)
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''CustTaxTemplateCode'''
|'''CustTaxTemplateCode'''
|N/A
|N/A
|
|10, Code String
|10, Code String
|-
|-
|'''TaxMatrix'''
|'''TaxMatrix'''
|N/A
|N/A
|
|0, Packed Matrix, base64 data
|0, Packed Matrix, base64 data
|-
|-
|'''TerminalID'''
|'''TerminalID'''
|Terminali ID (aknas peidetud)
|Terminali ID (aknas peidetud)
|
|60, String
|60, String
|-
|-
|'''OfficialSerNr'''
|'''OfficialSerNr'''
|Ametlik seerianumber
|Ametlik seerianumber
|
|100, String
|100, String
|-
|-
|'''Hash'''
|'''Hash'''
|N/A
|N/A
|
|255, String
|255, String
|-
|-
|'''HashKeyVersion'''
|'''HashKeyVersion'''
|N/A
|N/A
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''RegDate'''
|'''RegDate'''
|Kuupäev
|Kuupäev
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''RegTime'''
|'''RegTime'''
|Kellaaeg
|Kellaaeg
|
|0, Hour:Min:Secs
|0, Hour:Min:Secs
|-
|-
|'''LocalMachineCode'''
|'''LocalMachineCode'''
|Terminalikoha kood (aknas peidetud)
|Terminalikoha kood (aknas peidetud)
|
|20, Code String
|20, Code String
|-
|-
|'''InvCountry'''
|'''InvCountry'''
|Arve saaja riigi kood 2kohaline
|Arve saaja riigi kood 2kohaline
|
|5, Code String
|5, Code String
|-
|-
|'''DelCountry'''
|'''DelCountry'''
|Lähetuse saaja riigi kood 2kohaline
|Lähetuse saaja riigi kood 2kohaline
|
|5, Code String
|5, Code String
|-
|-
|'''TREONr'''
|'''TREONr'''
|TREO nr,
|TREO nr,
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''TREOExpDate'''
|'''TREOExpDate'''
|TREO kehtivuse kuupäev
|TREO kehtivuse kuupäev
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''ORCONr'''
|'''ORCONr'''
|Müügilepingu nr
|Müügilepingu nr
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''AcceptanceBy'''
|'''AcceptanceBy'''
|Kinnitaja(d) (aknas peidetud)
|Kinnitaja(d) (aknas peidetud)
|
|200, Comma separated List
|200, Comma separated List
|-
|-
|'''AcceptanceFYI'''
|'''AcceptanceFYI'''
|Infoks isikud (aknas peidetud)
|Infoks isikud (aknas peidetud)
|
|200, Comma separated List
|200, Comma separated List
|-
|-
|'''BankCode'''
|'''BankCode'''
|Pangakood (aknas peidetud)
|Pangakood (aknas peidetud)
|
|10, Code String
|10, Code String
|-
|-
|'''InvCountryName'''
|'''InvCountryName'''
|Arve saaja riigi nimi
|Arve saaja riigi nimi
|
|100, String
|100, String
|-
|-
|'''DelCountryName'''
|'''DelCountryName'''
|Lähetuse saaja riigi nimi
|Lähetuse saaja riigi nimi
|
|100, String
|100, String
|-
|-
|'''OfficialSerNrSerie'''
|'''OfficialSerNrSerie'''
|Seeria (aknas peidetud)
|Seeria (aknas peidetud)
|
|30, String
|30, String
|-
|-
|'''RecipientGLN'''
|'''RecipientGLN'''
|Saaja GLN
|Saaja GLN
|
|20, String
|20, String
|-
|-
|'''DelRecipientGLN'''
|'''DelRecipientGLN'''
|Kauba Saaja GLN
|Kauba Saaja GLN
|
|20, String
|20, String
|-
|-
|'''IntrastatTransCode'''
|'''IntrastatTransCode'''
|Intrastati kandekood
|Intrastati kandekood
|
|20, Code String
|20, Code String
|-
|-
|'''Comment2'''
|'''Comment2'''
|Kommentaar (rida 3)
|Kommentaar (rida 3)
|
|100, String
|100, String
|-
|-
|'''Comment3'''
|'''Comment3'''
|Kommentaar (rida 4)
|Kommentaar (rida 4)
|
|100, String
|100, String
|-
|-
|'''Comment4'''
|'''Comment4'''
|Kommentaar (rida 5)
|Kommentaar (rida 5)
|
|100, String
|100, String
|-
|-
|'''PONr'''
|'''PONr'''
|Ostutellimuse nr
|Ostutellimuse nr
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''CompNr'''
|'''CompNr'''
|N/A
|N/A
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''OYNr'''
|'''OYNr'''
|Võimalus
|Võimalus
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''OYDescription'''
|'''OYDescription'''
|Võimaluse kommentaar
|Võimaluse kommentaar
|
|200, String
|200, String
|-
|-
|'''SHShipSetToZero'''
|'''SHShipSetToZero'''
|Lähetatud kogus 0
|Lähetatud kogus 0
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''RvrsVAT'''
|'''RvrsVAT'''
|Tagatisraha
|Tagatisraha
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''PromotionCodes'''
|'''PromotionCodes'''
|N/A
|N/A
|
|200, Comma separated List
|200, Comma separated List
|-
|-
| colspan="3" |<big>↓↓↓ '''Maatriksi  read korduvad tühja reani ↓↓↓'''</big>
| colspan="4" |<big>↓↓↓ '''Maatriksi  read korduvad tühja reani ↓↓↓'''</big>
|-
|-
|'''stp'''
|'''stp'''
|Alati 1
|Alati 1
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''ArtCode'''
|'''ArtCode'''
|Artiklikood
|Artiklikood
|
|20, Code String
|20, Code String
|-
|-
|'''Quant'''
|'''Quant'''
|Kogus
|Kogus
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Price'''
|'''Price'''
|Ühikuhind
|Ühikuhind
|
|0, Value with 2 or 3 Decimals
|0, Value with 2 or 3 Decimals
|-
|-
|'''Sum'''
|'''Sum'''
|Summa
|Summa
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''vRebate'''
|'''vRebate'''
|Allah %
|Allah %
|
|0, Value with One Decimal
|0, Value with One Decimal
|-
|-
|'''SalesAcc'''
|'''SalesAcc'''
|Müügikonto
|Müügikonto
|
|10, Code String
|10, Code String
|-
|-
|'''Shipd1'''
|'''Shipd1'''
|Läh. 1
|Läh. 1
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Shipd2'''
|'''Shipd2'''
|Läh. 2
|Läh. 2
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Invd'''
|'''Invd'''
|Arveldatud
|Arveldatud
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Objects'''
|'''Objects'''
|Objektid
|Objektid
|
|60, Capital Characters Only
|60, Capital Characters Only
|-
|-
|'''BasePrice'''
|'''BasePrice'''
|Baasmüügihind
|Baasmüügihind
|
|0, Value with 2 or 3 Decimals
|0, Value with 2 or 3 Decimals
|-
|-
|'''rowGP'''
|'''rowGP'''
|Rea müügikate
|Rea müügikate
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Spec'''
|'''Spec'''
|Kirjeldus
|Kirjeldus
|
|100, String
|100, String
|-
|-
|'''VATCode'''
|'''VATCode'''
|KM kood
|KM kood
|
|10, Code String
|10, Code String
|-
|-
|'''Recepy'''
|'''Recepy'''
|Retsept
|Retsept
|
|20, Code String
|20, Code String
|-
|-
|'''SerialNr'''
|'''SerialNr'''
|Seerianumber
|Seerianumber
|
|60, String
|60, String
|-
|-
|'''PriceFactor'''
|'''PriceFactor'''
|Hinnafaktor
|Hinnafaktor
|
|0, Value with All Decimals
|0, Value with All Decimals
|-
|-
|'''VARList'''
|'''VARList'''
|N/A
|N/A
|
|30, Capital Characters Only
|30, Capital Characters Only
|-
|-
|'''Location'''
|'''Location'''
|Ladu
|Ladu
|
|10, Code String
|10, Code String
|-
|-
|'''Source'''
|'''Source'''
|Allikas
|Allikas
|
|10, Code String
|10, Code String
|-
|-
|'''PickingDate'''
|'''PickingDate'''
|Rea noppe kuupäev (YYYY-MM-DD)
|Rea noppe kuupäev (YYYY-MM-DD)
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''PickingTime'''
|'''PickingTime'''
|Rea noppe aeg (HH:MM:SS)
|Rea noppe aeg (HH:MM:SS)
|
|20, String
|20, String
|-
|-
|'''InloadingDate'''
|'''InloadingDate'''
|Rea laadimise kuupäev (YYYY-MM-DD)
|Rea laadimise kuupäev (YYYY-MM-DD)
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''InloadingTime'''
|'''InloadingTime'''
|Rea laadimise  aeg (HH:MM:SS)
|Rea laadimise  aeg (HH:MM:SS)
|
|20, String
|20, String
|-
|-
|'''DespatchRowDate'''
|'''DespatchRowDate'''
|Rea saatmise kuupäev (YYYY-MM-DD)
|Rea saatmise kuupäev (YYYY-MM-DD)
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''DespatchRowTime'''
|'''DespatchRowTime'''
|Rea saatmise aeg (HH:MM:SS)
|Rea saatmise aeg (HH:MM:SS)
|
|20, String
|20, String
|-
|-
|'''PlanShipRow'''
|'''PlanShipRow'''
|Rea planeeritud lähetus
|Rea planeeritud lähetus
|
|10, String
|10, String
|-
|-
|'''ShipNote'''
|'''ShipNote'''
|Saateleht
|Saateleht
|
|60, String
|60, String
|-
|-
|'''UnitCode'''
|'''UnitCode'''
|Ühik
|Ühik
|
|5, Code String
|5, Code String
|-
|-
|'''UnitFactQuant'''
|'''UnitFactQuant'''
|Ühiku kogus
|Ühiku kogus
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''UnitFactPrice'''
|'''UnitFactPrice'''
|Ühiku hind
|Ühiku hind
|
|0, Value with 2 or 3 Decimals
|0, Value with 2 or 3 Decimals
|-
|-
|'''UnitXval'''
|'''UnitXval'''
|Ühiku laius
|Ühiku laius
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''UnitYval'''
|'''UnitYval'''
|Ühiku kõrgus
|Ühiku kõrgus
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''UnitZval'''
|'''UnitZval'''
|Ühiku sügavus
|Ühiku sügavus
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Coefficient'''
|'''Coefficient'''
|Koefitsent
|Koefitsent
|
|0, Value with All Decimals
|0, Value with All Decimals
|-
|-
|'''VECode'''
|'''VECode'''
|Tarnija kood
|Tarnija kood
|
|20, Code String
|20, Code String
|-
|-
|'''Production'''
|'''Production'''
|Tootmine  
|Tootmine  
|
|20, Code String
|20, Code String
|-
|-
|'''GroupOrdRow'''
|'''GroupOrdRow'''
|N/A
|N/A
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''TAX2Code'''
|'''TAX2Code'''
|N/A
|N/A
|
|5, Code String
|5, Code String
|-
|-
|'''TAX2Prc'''
|'''TAX2Prc'''
|N/A
|N/A
|
|0, Value with 2 or 3 Decimals
|0, Value with 2 or 3 Decimals
|-
|-
|'''TAX2Reb'''
|'''TAX2Reb'''
|N/A
|N/A
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''TAX1Reb'''
|'''TAX1Reb'''
|N/A
|N/A
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''TAX2Acc'''
|'''TAX2Acc'''
|N/A
|N/A
|
|10, Code String
|10, Code String
|-
|-
|'''PlanShipRowDate'''
|'''PlanShipRowDate'''
|N/A
|N/A
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''CUServiceHistNr'''
|'''CUServiceHistNr'''
|Kl.teen.lep.nr.
|Kl.teen.lep.nr.
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''CUServiceUntilDate'''
|'''CUServiceUntilDate'''
|Kl.teen.lep. kehtivuse aeg
|Kl.teen.lep. kehtivuse aeg
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''Position'''
|'''Position'''
|Asukoht
|Asukoht
|
|20, Code String
|20, Code String
|-
|-
|'''RowOrderType'''
|'''RowOrderType'''
|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
|
|60, Capital Characters Only
|60, Capital Characters Only
|-
|-
|'''TaxMatrix'''
|'''TaxMatrix'''
|N/A
|N/A
|
|0, Packed Matrix, base64 data
|0, Packed Matrix, base64 data
|-
|-
|'''SerNr'''
|'''SerNr'''
|Seerianumber
|Seerianumber
|
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''RoundVal'''
|'''RoundVal'''
|N/A
|N/A
|
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Region'''
|'''Region'''
|Regioon
|Regioon
|
|20, Code String
|20, Code String
|-
|-
|'''Perceptions'''
|'''Perceptions'''
|N/A
|N/A
|
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''MotherArtCode'''
|'''MotherArtCode'''
|N/A
|N/A
|
|20, Code String
|20, Code String
|-
|-
|'''RecipeQuant'''
|'''RecipeQuant'''
|Retsepti kogus
|Retsepti kogus
|
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''CustArtCode'''
|'''CustArtCode'''
|Kliendi artiklikood
|Kliendi artiklikood
|
|20, Code String
|20, Code String
|-
|-
|'''Salesmen'''
|'''Salesmen'''
|Müügimees (real)
|Müügimees (real)
|
|60, Capital Characters Only
|60, Capital Characters Only
|-
|-
|'''OrderType'''
|'''OrderType'''
|Tellimuse tüüp (real)
|Tellimuse tüüp (real)
|
|626, Int represented by a Set of String
|626, Int represented by a Set of String
|-
|-
|'''UnitComment'''
|'''UnitComment'''
|Ühiku kommentaar
|Ühiku kommentaar
|
|200, String
|200, String
|-
|-
|'''DiscApprovedBy'''
|'''DiscApprovedBy'''
|N/A
|N/A
|
|10, Code String
|10, Code String
|-
|-
|'''ServiceDelDate'''
|'''ServiceDelDate'''
|N/A
|N/A
|
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''RvrsVATCode'''
|'''RvrsVATCode'''
|N/A
|N/A
|
|10, Code String
|10, Code String
|}
|}

Redaktsioon: 1. aprill 2019, kell 12:26

Ü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 arveaadressi 1. rida Invoice address line 1 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 0, Small Value with No Decimals
ShipFlag Lähetus tehtud? Linnuke sirvi aknas 0, Small Value with No Decimals
Prntdf Saadetud? Peidetud väli 0, Small Value with No Decimals
PayDeal Tasumistingimus 2, Code String
CustCat Kliendiklass 5, Code String
InvMark Arve 0, As Bool but displayed as a Checkbox
ShipMark Läh 0, As Bool but displayed as a Checkbox
Objects Objektid 60, Capital Characters Only
ShipMode Lähetusviis 5, Code String
OrderStatus Eksporditud linnuke (0=ei; 1=jah) 0, Small Value with No Decimals
PlanShip Planeeritud lähetus 10, String
SalesMan Müügimees 60, Capital Characters Only
Sign Tellimuse koostaja (peidetud väli, programmi sisse logitud kasutaja, kes tellimuse koostas) 10, Code String
ShipDeal Lähtustingimus 5, Code String
ShipAddr0 Lähetusaadressi 1. rida 60, String
ShipAddr1 Lähetusaadressi 2. rida 60, String
ShipAddr2 Lähetusaadressi 3. rida 60, String
ShipAddr3 Lähetusaadressi 4. rida 60, String
CurncyCode Valuuta 5, Code String
LangCode Keele 5, Code String
InvoiceToCode Arve saaja 20, Code String
Closed Suletud 0, As Bool but displayed as a Checkbox
ToRateB1 Baasvaluuta 1 (kurss) 0, Value with 6 Decimals
BuildOn N/A 0, Small Value with No Decimals
PRCode Projekti kood 20, Code String
Comment Kommentaar 60, String
InvOnlyOnFull N/A 0, Small Value with No Decimals
DownPaySent Ettemakstud (Aknas peidetud) 0, Value 2 or 3 Decimals
DownPayRedcd Ettemaks laekunud (Aknas peidetud) 0, Value 2 or 3 Decimals
OrderClass Tellimuse klass 5, Code String
CustOrdNr Kliendi tellimuse number 60, String
PriceList Hinnakiri 5, Code String
InclVAT K.a. käibemaks (Aknas peidetud) 0, Small Value with No Decimals
Sum0 Ümardus (Aknas peidetud) 0, Value 2 or 3 Decimals
Sum1 Vahesumma 0, Value 2 or 3 Decimals
Sum2 (Aknas peidetud) 0, Value 2 or 3 Decimals
Sum3 KM summa 0, Value 2 or 3 Decimals
Sum4 Kokku 0, Value 2 or 3 Decimals
Reserved Reserveeritud linnuke 0, Small Value with No Decimals
OSFlag N/A 0, Small Value with No Decimals
Location Ladu 10, Code String
CustVATCode Kliendi müügi KM kood (Aknas peidetud, tuleb kontaktikaardilt) 10, Code String
RebCode Hinnaalandusmaatriks 5, Code String
VATNr N/A 20, String
Phone Kliendi telefon 20, String with phone-number
Fax Kliendi faks 20, String
ExportedFlag N/A 0, Small Value with No Decimals
BaseSum4 Kokku (Baasvaluutas) 0, Value 2 or 3 Decimals
FrRate Kurss 0, Value with 6 Decimals
ToRateB2 Baasvaluuta 2 0, Value with 6 Decimals
BaseRate1 Baasvaluuta 1 0, Value with 6 Decimals
BaseRate2 Baasvaluuta 2 0, Value with 6 Decimals
DiscPerc Allahindlusprotsent (aknas peidetud. NB: päise väli) 0, Value with minimum Decimals
DiscSum Allahindluse summa (aknas peidetud. NB: päise väli) 0, Value 2 or 3 Decimals
TotGP Kokku müügikatte summa 0, Value 2 or 3 Decimals
Probability Tõnäosuse protsent (aknas peidetud, seotud pakkumisega) 0, Value with One Decimal
CreditCard Krediitkaardi kood 20, Capital Characters Only
AuthorizationCode Isikutuvastus 10, Capital Characters Only
GPProc Müügikate % 0, Value with One Decimal
DespatchDate Saatmise kuupäev 0, In Dataformat Order
DespatchTime Saatmise aeg (kellaaeg) 0, Hour:Min:Secs
SalesGroup Müügigrupp 30, Capital Characters Only
Sorting Teekond 20, String
TotQty Kogus kokku 0, Value with minimum Decimals
TotWeight Kaal kokku 0, Value with minimum Decimals
TotVolume Maht kokku 0, Value with minimum Decimals
Commision Komisjonitasu 0, Value 2 or 3 Decimals
SumIncCom Kokku koos teenustasuga 0, Value 2 or 3 Decimals
FrPrice Transpordi hind 0, Value 2 or 3 Decimals
FrBase N/A 0, Value 2 or 3 Decimals
FrItem Transpordi artiklikood 20, Code String
FrVATCode Transpordi KM kood 10, Code String
FrObjects Transpordi objektid (aknas peidetud) 60, Capital Characters Only
InvAddr3 Arve aadress rida 4 60, String
InvAddr4 Arve aadress rida 5 60, String
DelAddr3 Lähetusaadress rida 4 60, String
DelAddr4 Lähetusaadress rida 5 60, String
DelAddrCode Lähetusaadresssi kood 20, Code String
TAX1Sum Lisamaks 0, Value 2 or 3 Decimals
QuoteNr N/A 0, Value with No Decimals
InvBeforeShip Arve enne lähetus linnuke 0, Small Value with No Decimals
colnr värv (aknas peidetud) 46, Int represented by a Set of String
OKFlag Kinnita linnuke 0, As Bool but displayed as a Checkbox
PlanShipDate Planeeritud lähetuse kuupäev 0, In Dataformat Order
PrepaidAmount Ettemakstud summa 0, Value 2 or 3 Decimals
Region Regioon 20, Code String
RefStr Viide 60, String
GroupOrdNr N/A 0, Value with No Decimals
NoDelivery N/A 0, Small Value with No Decimals
NoInvoice N/A 0, Small Value with No Decimals
TAX2Sum Maks 2 0, Value 2 or 3 Decimals
NoTax1 Lisamaksuta (aknas peidetud) 0, Small Value with No Decimals
NoTax2 Masuta 2 (aknas peidetud) 0, Small Value with No Decimals
BranchID Filiaal 20, Code String
NoTAXonVAT Arvuta lisamaks summast koos käibemaksuga (aknas peidetud) 0, Value with No Decimals
TotalwoTAX Kokku ei sisalda lisamaksu (aknas peidetud) 0, Small Value with No Decimals
OrderType Tellimuse tüüp (aknas peidetud) 433, Int represented by a Set of String
AcceptanceStatus Kinnitamise staatus (aknas peidetud) 0, Small Value with No Decimals
CustTaxTemplateCode N/A 10, Code String
TaxMatrix N/A 0, Packed Matrix, base64 data
TerminalID Terminali ID (aknas peidetud) 60, String
OfficialSerNr Ametlik seerianumber 100, String
Hash N/A 255, String
HashKeyVersion N/A 0, Small Value with No Decimals
RegDate Kuupäev 0, In Dataformat Order
RegTime Kellaaeg 0, Hour:Min:Secs
LocalMachineCode Terminalikoha kood (aknas peidetud) 20, Code String
InvCountry Arve saaja riigi kood 2kohaline 5, Code String
DelCountry Lähetuse saaja riigi kood 2kohaline 5, Code String
TREONr TREO nr, 0, Value with No Decimals
TREOExpDate TREO kehtivuse kuupäev 0, In Dataformat Order
ORCONr Müügilepingu nr 0, Value with No Decimals
AcceptanceBy Kinnitaja(d) (aknas peidetud) 200, Comma separated List
AcceptanceFYI Infoks isikud (aknas peidetud) 200, Comma separated List
BankCode Pangakood (aknas peidetud) 10, Code String
InvCountryName Arve saaja riigi nimi 100, String
DelCountryName Lähetuse saaja riigi nimi 100, String
OfficialSerNrSerie Seeria (aknas peidetud) 30, String
RecipientGLN Saaja GLN 20, String
DelRecipientGLN Kauba Saaja GLN 20, String
IntrastatTransCode Intrastati kandekood 20, Code String
Comment2 Kommentaar (rida 3) 100, String
Comment3 Kommentaar (rida 4) 100, String
Comment4 Kommentaar (rida 5) 100, String
PONr Ostutellimuse nr 0, Value with No Decimals
CompNr N/A 0, Value with No Decimals
OYNr Võimalus 0, Value with No Decimals
OYDescription Võimaluse kommentaar 200, String
SHShipSetToZero Lähetatud kogus 0 0, Small Value with No Decimals
RvrsVAT Tagatisraha 0, Value 2 or 3 Decimals
PromotionCodes N/A 200, Comma separated List
↓↓↓ Maatriksi read korduvad tühja reani ↓↓↓
stp Alati 1 0, Small Value with No Decimals
ArtCode Artiklikood 20, Code String
Quant Kogus 0, Value with minimum Decimals
Price Ühikuhind 0, Value with 2 or 3 Decimals
Sum Summa 0, Value 2 or 3 Decimals
vRebate Allah % 0, Value with One Decimal
SalesAcc Müügikonto 10, Code String
Shipd1 Läh. 1 0, Value with minimum Decimals
Shipd2 Läh. 2 0, Value with minimum Decimals
Invd Arveldatud 0, Value with minimum Decimals
Objects Objektid 60, Capital Characters Only
BasePrice Baasmüügihind 0, Value with 2 or 3 Decimals
rowGP Rea müügikate 0, Value 2 or 3 Decimals
Spec Kirjeldus 100, String
VATCode KM kood 10, Code String
Recepy Retsept 20, Code String
SerialNr Seerianumber 60, String
PriceFactor Hinnafaktor 0, Value with All Decimals
VARList N/A 30, Capital Characters Only
Location Ladu 10, Code String
Source Allikas 10, Code String
PickingDate Rea noppe kuupäev (YYYY-MM-DD) 0, In Dataformat Order
PickingTime Rea noppe aeg (HH:MM:SS) 20, String
InloadingDate Rea laadimise kuupäev (YYYY-MM-DD) 0, In Dataformat Order
InloadingTime Rea laadimise aeg (HH:MM:SS) 20, String
DespatchRowDate Rea saatmise kuupäev (YYYY-MM-DD) 0, In Dataformat Order
DespatchRowTime Rea saatmise aeg (HH:MM:SS) 20, String
PlanShipRow Rea planeeritud lähetus 10, String
ShipNote Saateleht 60, String
UnitCode Ühik 5, Code String
UnitFactQuant Ühiku kogus 0, Value with minimum Decimals
UnitFactPrice Ühiku hind 0, Value with 2 or 3 Decimals
UnitXval Ühiku laius 0, Value with minimum Decimals
UnitYval Ühiku kõrgus 0, Value with minimum Decimals
UnitZval Ühiku sügavus 0, Value with minimum Decimals
Coefficient Koefitsent 0, Value with All Decimals
VECode Tarnija kood 20, Code String
Production Tootmine 20, Code String
GroupOrdRow N/A 0, Value with No Decimals
TAX2Code N/A 5, Code String
TAX2Prc N/A 0, Value with 2 or 3 Decimals
TAX2Reb N/A 0, Value 2 or 3 Decimals
TAX1Reb N/A 0, Value 2 or 3 Decimals
TAX2Acc N/A 10, Code String
PlanShipRowDate N/A 0, In Dataformat Order
CUServiceHistNr Kl.teen.lep.nr. 0, Value with No Decimals
CUServiceUntilDate Kl.teen.lep. kehtivuse aeg 0, In Dataformat Order
Position Asukoht 20, Code String
RowOrderType N/A 433, Int represented by a Set of String
TaxTemplateCode N/A 60, Capital Characters Only
TaxMatrix N/A 0, Packed Matrix, base64 data
SerNr Seerianumber 0, Value with No Decimals
RoundVal N/A 0, Value 2 or 3 Decimals
Region Regioon 20, Code String
Perceptions N/A 0, Small Value with No Decimals
MotherArtCode N/A 20, Code String
RecipeQuant Retsepti kogus 0, Value with minimum Decimals
CustArtCode Kliendi artiklikood 20, Code String
Salesmen Müügimees (real) 60, Capital Characters Only
OrderType Tellimuse tüüp (real) 626, Int represented by a Set of String
UnitComment Ühiku kommentaar 200, String
DiscApprovedBy N/A 10, Code String
ServiceDelDate N/A 0, In Dataformat Order
RvrsVATCode 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>
Tellimus.png
Pärit leheküljelt "https://kaust.excellent.ee/opendoc/index.php?title=Müügitellimused&oldid=676"