Müügitellimused: erinevus redaktsioonide vahel

Allikas: Excellent || Opendoc
Mine navigeerimisribale Mine otsikasti
Resümee puudub
 
(ei näidata sama kasutaja 11 vahepealset redaktsiooni)
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
|Invoice created (visible in browse window)
|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 (visible in browse window)
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''Prntdf'''
|'''Prntdf'''
|Saadetud? Peidetud väli
|Saadetud? Peidetud väli
|Sent? (Hidden field)
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''PayDeal'''
|'''PayDeal'''
|Tasumistingimus
|Tasumistingimus
|Pyment term
|2, Code String
|2, Code String
|-
|-
|'''CustCat'''
|'''CustCat'''
|Kliendiklass
|Kliendiklass
|Customer category code
|5, Code String
|5, Code String
|-
|-
|'''InvMark'''
|'''InvMark'''
|Arve
|Arve
|Invoice created (hidden field)
|0, As Bool but displayed as a Checkbox
|0, As Bool but displayed as a Checkbox
|-
|-
|'''ShipMark'''
|'''ShipMark'''
|Läh
|Lähetus
|Delivery created (hidden field)
|0, As Bool but displayed as a Checkbox
|0, As Bool but displayed as a Checkbox
|-
|-
|'''Objects'''
|'''Objects'''
|Objektid
|Objektid
|Objects
|60, Capital Characters Only
|60, Capital Characters Only
|-
|-
|'''ShipMode'''
|'''ShipMode'''
|Lähetusviis
|Lähetusviis
|Delivery mode
|5, Code String
|5, Code String
|-
|-
|'''OrderStatus'''
|'''OrderStatus'''
|Eksporditud linnuke (0=ei; 1=jah)
|Eksporditud linnuke (0=ei; 1=jah)
|Exported flag (0=no; 1=yes)
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''PlanShip'''
|'''PlanShip'''
|Planeeritud lähetus
|Planeeritud lähetus
|Planned delivery
|10, String
|10, String
|-
|-
|'''SalesMan'''
|'''SalesMan'''
|Müügimees
|Müügimees
|Salesman
|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)
|Order creator (Hidden field, username who created order)
|10, Code String
|10, Code String
|-
|-
|'''ShipDeal'''
|'''ShipDeal'''
|Lähtustingimus
|Lähtustingimus
|Delivery terms
|5, Code String
|5, Code String
|-
|-
|'''ShipAddr0'''
|'''ShipAddr0'''
|Lähetusaadressi 1. rida
|Lähetusaadressi 1. rida
|Delivery address line 1
|60, String
|60, String
|-
|-
|'''ShipAddr1'''
|'''ShipAddr1'''
|Lähetusaadressi 2. rida
|Lähetusaadressi 2. rida
|Delivery address line 2
|60, String
|60, String
|-
|-
|'''ShipAddr2'''
|'''ShipAddr2'''
|Lähetusaadressi 3. rida
|Lähetusaadressi 3. rida
|Delivery address line 3
|60, String
|60, String
|-
|-
|'''ShipAddr3'''
|'''ShipAddr3'''
|Lähetusaadressi 4. rida
|Lähetusaadressi 4. rida
|Delivery address line 4
|60, String
|60, String
|-
|-
|'''CurncyCode'''
|'''CurncyCode'''
|Valuuta
|Valuuta
|Currency code
|5, Code String
|5, Code String
|-
|-
|'''LangCode'''
|'''LangCode'''
|Keele
|Keele
|Language
|5, Code String
|5, Code String
|-
|-
|'''InvoiceToCode'''
|'''InvoiceToCode'''
|Arve saaja
|Arve saaja
|Invoice to
|20, Code String
|20, Code String
|-
|-
|'''Closed'''
|'''Closed'''
|Suletud
|Suletud
|Closed flag ((0=no; 1=yes)
|0, As Bool but displayed as a Checkbox
|0, As Bool but displayed as a Checkbox
|-
|-
|'''ToRateB1'''
|'''ToRateB1'''
|Baasvaluuta 1 (kurss)
|Baasvaluuta 1 (kurss)
|Base currency 1
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''BuildOn'''
|'''BuildOn'''
|N/A
|''N/A''
|''N/A''
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''PRCode'''
|'''PRCode'''
|Projekti kood
|Projekti kood
|Project
|20, Code String
|20, Code String
|-
|-
|'''Comment'''
|'''Comment'''
|Kommentaar
|Kommentaar
|Comment
|60, String
|60, String
|-
|-
|'''InvOnlyOnFull'''
|'''InvOnlyOnFull'''
|N/A
|''N/A''
|''N/A''
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''DownPaySent'''
|'''DownPaySent'''
|Ettemakstud (Aknas peidetud)
|Ettemakstud (Aknas peidetud)
|Prepayment sent (Hidden in GUI)
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''DownPayRedcd'''
|'''DownPayRedcd'''
|Ettemaks laekunud (Aknas peidetud)
|Ettemaks laekunud (Aknas peidetud)
|Prepayment recieved (Hidden in GUI)
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''OrderClass'''
|'''OrderClass'''
|Tellimuse klass
|Tellimuse klass
|Order class
|5, Code String
|5, Code String
|-
|-
|'''CustOrdNr'''
|'''CustOrdNr'''
|Kliendi tellimuse number
|Kliendi tellimuse number
|Customer order no
|60, String
|60, String
|-
|-
|'''PriceList'''
|'''PriceList'''
|Hinnakiri
|Hinnakiri
|Price list
|5, Code String
|5, Code String
|-
|-
|'''InclVAT'''
|'''InclVAT'''
|K.a. käibemaks (Aknas peidetud)
|K.a. käibemaks (Aknas peidetud)
|Includes VAT  (Hidden in GUI)
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''Sum0'''
|'''Sum0'''
|Ümardus (Aknas peidetud)
|Ümardus (Aknas peidetud)
|Rounding  (Hidden in GUI)
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Sum1'''
|'''Sum1'''
|Vahesumma
|Vahesumma
|Subtotal
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Sum2'''
|'''Sum2'''
|(Aknas peidetud)
|(Aknas peidetud)
|(Hidden in GUI)
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Sum3'''
|'''Sum3'''
|KM summa
|KM summa
|VAT
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Sum4'''
|'''Sum4'''
|Kokku
|Kokku
|TOTAL
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Reserved'''
|'''Reserved'''
|Reserveeritud linnuke
|Reserveeritud linnuke
|Reserveed flag
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''OSFlag'''
|'''OSFlag'''
|N/A
|''N/A''
|''N/A''
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''Location'''
|'''Location'''
|Ladu
|Ladu
|Location
|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)
|Customer VAT code (hidden in GUI)
|10, Code String
|10, Code String
|-
|-
|'''RebCode'''
|'''RebCode'''
|Hinnaalandusmaatriks
|Hinnaalandusmaatriks
|Discount matrix
|5, Code String
|5, Code String
|-
|-
|'''VATNr'''
|'''VATNr'''
|N/A
|N/A
|''N/A''
|20, String
|20, String
|-
|-
|'''Phone'''
|'''Phone'''
|Kliendi telefon
|Kliendi telefon
|Customer phone
|20, String with phone-number
|20, String with phone-number
|-
|-
|'''Fax'''
|'''Fax'''
|Kliendi faks
|Kliendi faks
|Customer fax
|20, String
|20, String
|-
|-
|'''ExportedFlag'''
|'''ExportedFlag'''
|N/A
|''N/A''
|''N/A''
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''BaseSum4'''
|'''BaseSum4'''
|Kokku (Baasvaluutas)
|Kokku (Baasvaluutas)
|TOTAL in Base 1
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''FrRate'''
|'''FrRate'''
|Kurss
|Kurss
|Rate
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''ToRateB2'''
|'''ToRateB2'''
|Baasvaluuta 2
|Baasvaluuta 2
|Base currency 2
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''BaseRate1'''
|'''BaseRate1'''
|Baasvaluuta 1
|Baasvaluuta 1
|Base currency 1
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''BaseRate2'''
|'''BaseRate2'''
|Baasvaluuta 2
|Baasvaluuta 2
|Base currency 2
|0, Value with 6 Decimals
|0, Value with 6 Decimals
|-
|-
|'''DiscPerc'''
|'''DiscPerc'''
|
|Allahindlusprotsent (aknas peidetud. NB: päise väli)
|Discount % (hidden in GUI)
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''DiscSum'''
|'''DiscSum'''
|
|Allahindluse summa (aknas peidetud. NB: päise väli)
|Discount sum (hidden in GUI)
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''TotGP'''
|'''TotGP'''
|
|Kokku müügikatte summa
|Total GP
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Probability'''
|'''Probability'''
|
|Tõnäosuse protsent (aknas peidetud, seotud pakkumisega)
|Probability (Hidden in GUI, comes from Quotation)
|0, Value with One Decimal
|0, Value with One Decimal
|-
|-
|'''CreditCard'''
|'''CreditCard'''
|
|Krediitkaardi kood
|Credi Card code
|20, Capital Characters Only
|20, Capital Characters Only
|-
|-
|'''AuthorizationCode'''
|'''AuthorizationCode'''
|
|Isikutuvastus
|Authorization Code
|10, Capital Characters Only
|10, Capital Characters Only
|-
|-
|'''GPProc'''
|'''GPProc'''
|
|Müügikate %
|GP %
|0, Value with One Decimal
|0, Value with One Decimal
|-
|-
|'''DespatchDate'''
|'''DespatchDate'''
|
|Saatmise kuupäev
|Dispatch date
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''DespatchTime'''
|'''DespatchTime'''
|
|Saatmise aeg (kellaaeg)
|Dispatch time
|0, Hour:Min:Secs
|0, Hour:Min:Secs
|-
|-
|'''SalesGroup'''
|'''SalesGroup'''
|
|Müügigrupp
|Sales Group
|30, Capital Characters Only
|30, Capital Characters Only
|-
|-
|'''Sorting'''
|'''Sorting'''
|
|Teekond
|Route
|20, String
|20, String
|-
|-
|'''TotQty'''
|'''TotQty'''
|
|Kogus kokku
|Total quantity
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''TotWeight'''
|'''TotWeight'''
|
|Kaal kokku
|Total weight
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''TotVolume'''
|'''TotVolume'''
|
|Maht kokku
|Total volume
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Commision'''
|'''Commision'''
|
|Komisjonitasu
|Comission
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''SumIncCom'''
|'''SumIncCom'''
|
|Kokku koos teenustasuga
|Total Incl. Com.
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''FrPrice'''
|'''FrPrice'''
|
|Transpordi hind
|Freight
|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
|Freight item code
|20, Code String
|20, Code String
|-
|-
|'''FrVATCode'''
|'''FrVATCode'''
|
|Transpordi KM kood
|Freight VAT code
|10, Code String
|10, Code String
|-
|-
|'''FrObjects'''
|'''FrObjects'''
|
|Transpordi objektid (aknas peidetud)
|Freight objects (hidden in window)
|60, Capital Characters Only
|60, Capital Characters Only
|-
|-
|'''InvAddr3'''
|'''InvAddr3'''
|
|Arve aadress rida 4
|Invoice address line 4
|60, String
|60, String
|-
|-
|'''InvAddr4'''
|'''InvAddr4'''
|
|Arve aadress rida 5
|Invoice address line 5
|60, String
|60, String
|-
|-
|'''DelAddr3'''
|'''DelAddr3'''
|
|Lähetusaadress rida 4
|Delivery address line 4
|60, String
|60, String
|-
|-
|'''DelAddr4'''
|'''DelAddr4'''
|
|Lähetusaadress rida 5
|Delivery address line 5
|60, String
|60, String
|-
|-
|'''DelAddrCode'''
|'''DelAddrCode'''
|
|Lähetusaadresssi kood
|Delivery address code
|20, Code String
|20, Code String
|-
|-
|'''TAX1Sum'''
|'''TAX1Sum'''
|
|Lisamaks
|Ext. Tax
|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
|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
|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
|Planned Delivery
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''PrepaidAmount'''
|'''PrepaidAmount'''
|
|Ettemakstud summa
|Prepaid Amount
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Region'''
|'''Region'''
|
|Regioon
|Region
|20, Code String
|20, Code String
|-
|-
|'''RefStr'''
|'''RefStr'''
|
|Viide
|Reference
|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
|Tax2
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''NoTax1'''
|'''NoTax1'''
|
|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)
|Without tax2 (hidden in window)
|0, Small Value with No Decimals
|0, Small Value with No Decimals
|-
|-
|'''BranchID'''
|'''BranchID'''
|
|Filiaal
|Branch
|20, Code String
|20, Code String
|-
|-
|'''NoTAXonVAT'''
|'''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
|0, Value with No Decimals
|-
|-
|'''TotalwoTAX'''
|'''TotalwoTAX'''
|
|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)
|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)
|Acceptance status (hidden in window)
|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)
|Terminal ID (hidden in window)
|60, String
|60, String
|-
|-
|'''OfficialSerNr'''
|'''OfficialSerNr'''
|
|Ametlik seerianumber
|Official no.
|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
|Reg date (hidden in window)
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''RegTime'''
|'''RegTime'''
|
|Kellaaeg
|Reg time (hidden in window)
|0, Hour:Min:Secs
|0, Hour:Min:Secs
|-
|-
|'''LocalMachineCode'''
|'''LocalMachineCode'''
|
|Terminalikoha kood (aknas peidetud)
|Local machine Code (hidden in window)
|20, Code String
|20, Code String
|-
|-
|'''InvCountry'''
|'''InvCountry'''
|
|Arve saaja riigi kood 2kohaline
|Invice country ID (2-letter)
|5, Code String
|5, Code String
|-
|-
|'''DelCountry'''
|'''DelCountry'''
|
|Lähetuse saaja riigi kood 2kohaline
|Delivery country ID (2-letter)
|5, Code String
|5, Code String
|-
|-
|'''TREONr'''
|'''TREONr'''
|
|TREO nr,
|Treo no
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''TREOExpDate'''
|'''TREOExpDate'''
|
|TREO kehtivuse kuupäev
|Treo date
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''ORCONr'''
|'''ORCONr'''
|
|Müügilepingu nr
|Sales Contract
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''AcceptanceBy'''
|'''AcceptanceBy'''
|
|Kinnitaja(d) (aknas peidetud)
|Acceptance user list (hidden in window)
|200, Comma separated List
|200, Comma separated List
|-
|-
|'''AcceptanceFYI'''
|'''AcceptanceFYI'''
|
|Infoks isikud (aknas peidetud)
|FYI user list (hidden in window)
|200, Comma separated List
|200, Comma separated List
|-
|-
|'''BankCode'''
|'''BankCode'''
|
|Pangakood (aknas peidetud)
|Bank code (hidden in window)
|10, Code String
|10, Code String
|-
|-
|'''InvCountryName'''
|'''InvCountryName'''
|
|Arve saaja riigi nimi
|Invice country Name
|100, String
|100, String
|-
|-
|'''DelCountryName'''
|'''DelCountryName'''
|
|Lähetuse saaja riigi nimi
|Delivery country Name
|100, String
|100, String
|-
|-
|'''OfficialSerNrSerie'''
|'''OfficialSerNrSerie'''
|
|Seeria (aknas peidetud)
|Official number series (hidden in window)
|30, String
|30, String
|-
|-
|'''RecipientGLN'''
|'''RecipientGLN'''
|
|Saaja GLN
|Invoice GLN
|20, String
|20, String
|-
|-
|'''DelRecipientGLN'''
|'''DelRecipientGLN'''
|
|Kauba Saaja GLN
|Delivery GLN
|20, String
|20, String
|-
|-
|'''IntrastatTransCode'''
|'''IntrastatTransCode'''
|
|Intrastati kandekood
|Intrastat code
|20, Code String
|20, Code String
|-
|-
|'''Comment2'''
|'''Comment2'''
|
|Kommentaar (rida 3)
|Comment line 3
|100, String
|100, String
|-
|-
|'''Comment3'''
|'''Comment3'''
|
|Kommentaar (rida 4)
|Comment line 4
|100, String
|100, String
|-
|-
|'''Comment4'''
|'''Comment4'''
|
|Kommentaar (rida 5)
|Comment line 5
|100, String
|100, String
|-
|-
|'''PONr'''
|'''PONr'''
|
|Ostutellimuse nr
|Purchase order no
|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'''
|
|''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
|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''
|200, Comma separated List
|200, Comma separated List
|-
|-
| colspan="3" |↓↓↓ '''Maatriksi  read korduvad tühja reani ↓↓↓'''
! 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
|Item code
|20, Code String
|20, Code String
|-
|-
|'''Quant'''
|'''Quant'''
|
|Kogus
|Qty
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Price'''
|'''Price'''
|
|Ühikuhind
|Unit Price
|0, Value with 2 or 3 Decimals
|0, Value with 2 or 3 Decimals
|-
|-
|'''Sum'''
|'''Sum'''
|
|Summa
|Sum
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''vRebate'''
|'''vRebate'''
|
|Allah %
|Discount %
|0, Value with One Decimal
|0, Value with One Decimal
|-
|-
|'''SalesAcc'''
|'''SalesAcc'''
|
|Müügikonto
|A/C
|10, Code String
|10, Code String
|-
|-
|'''Shipd1'''
|'''Shipd1'''
|
|Läh. 1
|Del
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Shipd2'''
|'''Shipd2'''
|
|Läh. 2
|Del. Ok
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Invd'''
|'''Invd'''
|
|Arveldatud
|Invoiced
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Objects'''
|'''Objects'''
|
|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
|GP
|0, Value 2 or 3 Decimals
|0, Value 2 or 3 Decimals
|-
|-
|'''Spec'''
|'''Spec'''
|
|Kirjeldus
|Description
|100, String
|100, String
|-
|-
|'''VATCode'''
|'''VATCode'''
|
|KM kood
|V-Cd
|10, Code String
|10, Code String
|-
|-
|'''Recepy'''
|'''Recepy'''
|
|Retsept
|Recepy
|20, Code String
|20, Code String
|-
|-
|'''SerialNr'''
|'''SerialNr'''
|
|Seerianumber
|Serial No.
|60, String
|60, String
|-
|-
|'''PriceFactor'''
|'''PriceFactor'''
|
|Hinnafaktor
|Price factor
|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
|Location
|10, Code String
|10, Code String
|-
|-
|'''Source'''
|'''Source'''
|
|Allikas
|Source
|10, Code String
|10, Code String
|-
|-
|'''PickingDate'''
|'''PickingDate'''
|
|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)
|Pick Time
|20, String
|20, String
|-
|-
|'''InloadingDate'''
|'''InloadingDate'''
|
|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)
|Inl Time
|20, String
|20, String
|-
|-
|'''DespatchRowDate'''
|'''DespatchRowDate'''
|
|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)
|Desp Time
|20, String
|20, String
|-
|-
|'''PlanShipRow'''
|'''PlanShipRow'''
|
|Rea planeeritud lähetus
|Plan Del
|10, String
|10, String
|-
|-
|'''ShipNote'''
|'''ShipNote'''
|
|Saateleht
|Delivery note
|60, String
|60, String
|-
|-
|'''UnitCode'''
|'''UnitCode'''
|
|Ühik
|Uni
|5, Code String
|5, Code String
|-
|-
|'''UnitFactQuant'''
|'''UnitFactQuant'''
|
|Ühiku kogus
|Unit quantity
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''UnitFactPrice'''
|'''UnitFactPrice'''
|
|Ühiku hind
|Unit price
|0, Value with 2 or 3 Decimals
|0, Value with 2 or 3 Decimals
|-
|-
|'''UnitXval'''
|'''UnitXval'''
|
|Ühiku laius
|Wight
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''UnitYval'''
|'''UnitYval'''
|
|Ühiku kõrgus
|Hight
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''UnitZval'''
|'''UnitZval'''
|
|Ühiku sügavus
|Depth
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''Coefficient'''
|'''Coefficient'''
|
|Koefitsent
|Coefficent
|0, Value with All Decimals
|0, Value with All Decimals
|-
|-
|'''VECode'''
|'''VECode'''
|
|Tarnija kood
|Cust item code
|20, Code String
|20, Code String
|-
|-
|'''Production'''
|'''Production'''
|
|Tootmine (aknas peidetud)
|Production (hidden in window)
|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.
|Customer service contact no
|0, Value with No Decimals
|0, Value with No Decimals
|-
|-
|'''CUServiceUntilDate'''
|'''CUServiceUntilDate'''
|
|Kl.teen.lep. kehtivuse aeg
|Customer service contact end date
|0, In Dataformat Order
|0, In Dataformat Order
|-
|-
|'''Position'''
|'''Position'''
|
|Asukoht
|Position
|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
|Serial no
|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
|Region
|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
|Recepie quantity
|0, Value with minimum Decimals
|0, Value with minimum Decimals
|-
|-
|'''CustArtCode'''
|'''CustArtCode'''
|
|Kliendi artiklikood
|Customer item code
|20, Code String
|20, Code String
|-
|-
|'''Salesmen'''
|'''Salesmen'''
|
|Müügimees (real)
|Salesman
|60, Capital Characters Only
|60, Capital Characters Only
|-
|-
|'''OrderType'''
|'''OrderType'''
|
|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
|Unit comment
|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
|}
|}

Viimane redaktsioon: 1. juuni 2023, kell 10:40

Ü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 Invoice created (visible in browse window) 0, Small Value with No Decimals
ShipFlag Lähetus tehtud? Linnuke sirvi aknas Delivery created (visible in browse window) 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 (hidden field) 0, As Bool but displayed as a Checkbox
ShipMark Lähetus Delivery created (hidden field) 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>
Tellimus.png
Pärit leheküljelt "https://kaust.excellent.ee/opendoc/index.php?title=Müügitellimused&oldid=1509"