Müügitellimused: erinevus redaktsioonide vahel
Mine navigeerimisribale
Mine otsikasti
Resümee puudub |
Resümee puudub |
||
1. rida: | 1. rida: | ||
Ühe täidetud müügitellimuse saab pärida siit: | |||
<code | <code>https://mars.excellent.ee:4455/api/1/orvc?sort=SerNr&range=103</code> | ||
=== Väljade loetelu === | |||
{| class="wikitable" | {| class="wikitable" | ||
!Kood | !Kood | ||
8. rida: | 9. rida: | ||
!Max pikkus, andme tüüp | !Max pikkus, andme tüüp | ||
|- | |- | ||
|UUID | |'''UUID''' | ||
| | | rowspan="3" |Tehnilised väljad | ||
|0, Universally unique identifier | |0, Universally unique identifier | ||
|- | |- | ||
|ServerSequence | |'''ServerSequence''' | ||
|0, Unsigned 64-bit value | |0, Unsigned 64-bit value | ||
|- | |- | ||
|SyncFlags | |'''SyncFlags''' | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|SerNr | |'''SerNr''' | ||
| | |Tellimuse nr | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|OrdDate | |'''OrdDate''' | ||
| | |Tellimuse kuupäev | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|CustCode | |'''CustCode''' | ||
| | |Kliendi kood | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|Addr0 | |'''Addr0''' | ||
| | |Kliendi arveaadressi 1. rida | ||
|60, String | |60, String | ||
|- | |- | ||
|Addr1 | |'''Addr1''' | ||
| | |Kliendi arveaadressi 2. rida | ||
|60, String | |60, String | ||
|- | |- | ||
|Addr2 | |'''Addr2''' | ||
| | |Kliendi arveaadressi 3. rida | ||
|60, String | |60, String | ||
|- | |- | ||
|Addr3 | |'''Addr3''' | ||
| | |Kliendi arveaadressi 4. rida | ||
|60, String | |60, String | ||
|- | |- | ||
|OurContact | |'''OurContact''' | ||
| | |Meie esindaja | ||
|20, String | |20, String | ||
|- | |- | ||
|CustContact | |'''CustContact''' | ||
| | |Kliendi esindaja | ||
|60, String | |60, String | ||
|- | |- | ||
|ExportFlag | |'''ExportFlag''' | ||
| | |Käibemaksutsoon | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|InvFlag | |'''InvFlag''' | ||
| | |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 | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|Prntdf | |'''Prntdf''' | ||
| | |Saadetud? Peidetud väli | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|PayDeal | |'''PayDeal''' | ||
| | |Tasumistingimus | ||
|2, Code String | |2, Code String | ||
|- | |- | ||
|CustCat | |'''CustCat''' | ||
| | |Kliendiklass | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|InvMark | |'''InvMark''' | ||
| | |Arve | ||
|0, As Bool but displayed as a Checkbox | |0, As Bool but displayed as a Checkbox | ||
|- | |- | ||
|ShipMark | |'''ShipMark''' | ||
| | |Läh | ||
|0, As Bool but displayed as a Checkbox | |0, As Bool but displayed as a Checkbox | ||
|- | |- | ||
|Objects | |'''Objects''' | ||
| | |Objektid | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|ShipMode | |'''ShipMode''' | ||
| | |Lähetusviis | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|OrderStatus | |'''OrderStatus''' | ||
| | |Eksporditud linnuke (0=ei; 1=jah) | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|PlanShip | |'''PlanShip''' | ||
| | | | ||
|10, String | |10, String | ||
|- | |- | ||
|SalesMan | |'''SalesMan''' | ||
| | | | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|Sign | |'''Sign''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|ShipDeal | |'''ShipDeal''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|ShipAddr0 | |'''ShipAddr0''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|ShipAddr1 | |'''ShipAddr1''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|ShipAddr2 | |'''ShipAddr2''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|ShipAddr3 | |'''ShipAddr3''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|CurncyCode | |'''CurncyCode''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|LangCode | |'''LangCode''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|InvoiceToCode | |'''InvoiceToCode''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|Closed | |'''Closed''' | ||
| | | | ||
|0, As Bool but displayed as a Checkbox | |0, As Bool but displayed as a Checkbox | ||
|- | |- | ||
|ToRateB1 | |'''ToRateB1''' | ||
| | | | ||
|0, Value with 6 Decimals | |0, Value with 6 Decimals | ||
|- | |- | ||
|BuildOn | |'''BuildOn''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|PRCode | |'''PRCode''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|Comment | |'''Comment''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|InvOnlyOnFull | |'''InvOnlyOnFull''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|DownPaySent | |'''DownPaySent''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|DownPayRedcd | |'''DownPayRedcd''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|OrderClass | |'''OrderClass''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|CustOrdNr | |'''CustOrdNr''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|PriceList | |'''PriceList''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|InclVAT | |'''InclVAT''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|Sum0 | |'''Sum0''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|Sum1 | |'''Sum1''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|Sum2 | |'''Sum2''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|Sum3 | |'''Sum3''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|Sum4 | |'''Sum4''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|Reserved | |'''Reserved''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|OSFlag | |'''OSFlag''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|Location | |'''Location''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|CustVATCode | |'''CustVATCode''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|RebCode | |'''RebCode''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|VATNr | |'''VATNr''' | ||
| | | | ||
|20, String | |20, String | ||
|- | |- | ||
|Phone | |'''Phone''' | ||
| | | | ||
|20, String with phone-number | |20, String with phone-number | ||
|- | |- | ||
|Fax | |'''Fax''' | ||
| | | | ||
|20, String | |20, String | ||
|- | |- | ||
|ExportedFlag | |'''ExportedFlag''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|BaseSum4 | |'''BaseSum4''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|FrRate | |'''FrRate''' | ||
| | | | ||
|0, Value with 6 Decimals | |0, Value with 6 Decimals | ||
|- | |- | ||
|ToRateB2 | |'''ToRateB2''' | ||
| | | | ||
|0, Value with 6 Decimals | |0, Value with 6 Decimals | ||
|- | |- | ||
|BaseRate1 | |'''BaseRate1''' | ||
| | | | ||
|0, Value with 6 Decimals | |0, Value with 6 Decimals | ||
|- | |- | ||
|BaseRate2 | |'''BaseRate2''' | ||
| | | | ||
|0, Value with 6 Decimals | |0, Value with 6 Decimals | ||
|- | |- | ||
|DiscPerc | |'''DiscPerc''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|DiscSum | |'''DiscSum''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|TotGP | |'''TotGP''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|Probability | |'''Probability''' | ||
| | | | ||
|0, Value with One Decimal | |0, Value with One Decimal | ||
|- | |- | ||
|CreditCard | |'''CreditCard''' | ||
| | | | ||
|20, Capital Characters Only | |20, Capital Characters Only | ||
|- | |- | ||
|AuthorizationCode | |'''AuthorizationCode''' | ||
| | | | ||
|10, Capital Characters Only | |10, Capital Characters Only | ||
|- | |- | ||
|GPProc | |'''GPProc''' | ||
| | | | ||
|0, Value with One Decimal | |0, Value with One Decimal | ||
|- | |- | ||
|DespatchDate | |'''DespatchDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|DespatchTime | |'''DespatchTime''' | ||
| | | | ||
|0, Hour:Min:Secs | |0, Hour:Min:Secs | ||
|- | |- | ||
|SalesGroup | |'''SalesGroup''' | ||
| | | | ||
|30, Capital Characters Only | |30, Capital Characters Only | ||
|- | |- | ||
|Sorting | |'''Sorting''' | ||
| | | | ||
|20, String | |20, String | ||
|- | |- | ||
|TotQty | |'''TotQty''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|TotWeight | |'''TotWeight''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|TotVolume | |'''TotVolume''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|Commision | |'''Commision''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|SumIncCom | |'''SumIncCom''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|FrPrice | |'''FrPrice''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|FrBase | |'''FrBase''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|FrItem | |'''FrItem''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|FrVATCode | |'''FrVATCode''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|FrObjects | |'''FrObjects''' | ||
| | | | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|InvAddr3 | |'''InvAddr3''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|InvAddr4 | |'''InvAddr4''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|DelAddr3 | |'''DelAddr3''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|DelAddr4 | |'''DelAddr4''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|DelAddrCode | |'''DelAddrCode''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|TAX1Sum | |'''TAX1Sum''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|QuoteNr | |'''QuoteNr''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|InvBeforeShip | |'''InvBeforeShip''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|colnr | |'''colnr''' | ||
| | | | ||
|46, Int represented by a Set of String | |46, Int represented by a Set of String | ||
|- | |- | ||
|OKFlag | |'''OKFlag''' | ||
| | | | ||
|0, As Bool but displayed as a Checkbox | |0, As Bool but displayed as a Checkbox | ||
|- | |- | ||
|PlanShipDate | |'''PlanShipDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|PrepaidAmount | |'''PrepaidAmount''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|Region | |'''Region''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|RefStr | |'''RefStr''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|GroupOrdNr | |'''GroupOrdNr''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|NoDelivery | |'''NoDelivery''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|NoInvoice | |'''NoInvoice''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|TAX2Sum | |'''TAX2Sum''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|NoTax1 | |'''NoTax1''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|NoTax2 | |'''NoTax2''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|BranchID | |'''BranchID''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|NoTAXonVAT | |'''NoTAXonVAT''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|TotalwoTAX | |'''TotalwoTAX''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|OrderType | |'''OrderType''' | ||
| | | | ||
|433, Int represented by a Set of String | |433, Int represented by a Set of String | ||
|- | |- | ||
|AcceptanceStatus | |'''AcceptanceStatus''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|CustTaxTemplateCode | |'''CustTaxTemplateCode''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|TaxMatrix | |'''TaxMatrix''' | ||
| | | | ||
|0, Packed Matrix, base64 data | |0, Packed Matrix, base64 data | ||
|- | |- | ||
|TerminalID | |'''TerminalID''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|OfficialSerNr | |'''OfficialSerNr''' | ||
| | | | ||
|100, String | |100, String | ||
|- | |- | ||
|Hash | |'''Hash''' | ||
| | | | ||
|255, String | |255, String | ||
|- | |- | ||
|HashKeyVersion | |'''HashKeyVersion''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|RegDate | |'''RegDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|RegTime | |'''RegTime''' | ||
| | | | ||
|0, Hour:Min:Secs | |0, Hour:Min:Secs | ||
|- | |- | ||
|LocalMachineCode | |'''LocalMachineCode''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|InvCountry | |'''InvCountry''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|DelCountry | |'''DelCountry''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|TREONr | |'''TREONr''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|TREOExpDate | |'''TREOExpDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|ORCONr | |'''ORCONr''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|AcceptanceBy | |'''AcceptanceBy''' | ||
| | | | ||
|200, Comma separated List | |200, Comma separated List | ||
|- | |- | ||
|AcceptanceFYI | |'''AcceptanceFYI''' | ||
| | | | ||
|200, Comma separated List | |200, Comma separated List | ||
|- | |- | ||
|BankCode | |'''BankCode''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|InvCountryName | |'''InvCountryName''' | ||
| | | | ||
|100, String | |100, String | ||
|- | |- | ||
|DelCountryName | |'''DelCountryName''' | ||
| | | | ||
|100, String | |100, String | ||
|- | |- | ||
|OfficialSerNrSerie | |'''OfficialSerNrSerie''' | ||
| | | | ||
|30, String | |30, String | ||
|- | |- | ||
|RecipientGLN | |'''RecipientGLN''' | ||
| | | | ||
|20, String | |20, String | ||
|- | |- | ||
|DelRecipientGLN | |'''DelRecipientGLN''' | ||
| | | | ||
|20, String | |20, String | ||
|- | |- | ||
|IntrastatTransCode | |'''IntrastatTransCode''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|Comment2 | |'''Comment2''' | ||
| | | | ||
|100, String | |100, String | ||
|- | |- | ||
|Comment3 | |'''Comment3''' | ||
| | | | ||
|100, String | |100, String | ||
|- | |- | ||
|Comment4 | |'''Comment4''' | ||
| | | | ||
|100, String | |100, String | ||
|- | |- | ||
|PONr | |'''PONr''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|CompNr | |'''CompNr''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|OYNr | |'''OYNr''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|OYDescription | |'''OYDescription''' | ||
| | | | ||
|200, String | |200, String | ||
|- | |- | ||
|SHShipSetToZero | |'''SHShipSetToZero''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|RvrsVAT | |'''RvrsVAT''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|PromotionCodes | |'''PromotionCodes''' | ||
| | | | ||
|200, Comma separated List | |200, Comma separated List | ||
586. rida: | 585. rida: | ||
| colspan="3" |↓↓↓ '''Maatriksi read korduvad tühja reani ↓↓↓''' | | colspan="3" |↓↓↓ '''Maatriksi read korduvad tühja reani ↓↓↓''' | ||
|- | |- | ||
|stp | |'''stp''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|ArtCode | |'''ArtCode''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|Quant | |'''Quant''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|Price | |'''Price''' | ||
| | | | ||
|0, Value with 2 or 3 Decimals | |0, Value with 2 or 3 Decimals | ||
|- | |- | ||
|Sum | |'''Sum''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|vRebate | |'''vRebate''' | ||
| | | | ||
|0, Value with One Decimal | |0, Value with One Decimal | ||
|- | |- | ||
|SalesAcc | |'''SalesAcc''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|Shipd1 | |'''Shipd1''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|Shipd2 | |'''Shipd2''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|Invd | |'''Invd''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|Objects | |'''Objects''' | ||
| | | | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|BasePrice | |'''BasePrice''' | ||
| | | | ||
|0, Value with 2 or 3 Decimals | |0, Value with 2 or 3 Decimals | ||
|- | |- | ||
|rowGP | |'''rowGP''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|Spec | |'''Spec''' | ||
| | | | ||
|100, String | |100, String | ||
|- | |- | ||
|VATCode | |'''VATCode''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|Recepy | |'''Recepy''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|SerialNr | |'''SerialNr''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|PriceFactor | |'''PriceFactor''' | ||
| | | | ||
|0, Value with All Decimals | |0, Value with All Decimals | ||
|- | |- | ||
|VARList | |'''VARList''' | ||
| | | | ||
|30, Capital Characters Only | |30, Capital Characters Only | ||
|- | |- | ||
|Location | |'''Location''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|Source | |'''Source''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|PickingDate | |'''PickingDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|PickingTime | |'''PickingTime''' | ||
| | | | ||
|20, String | |20, String | ||
|- | |- | ||
|InloadingDate | |'''InloadingDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|InloadingTime | |'''InloadingTime''' | ||
| | | | ||
|20, String | |20, String | ||
|- | |- | ||
|DespatchRowDate | |'''DespatchRowDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|DespatchRowTime | |'''DespatchRowTime''' | ||
| | | | ||
|20, String | |20, String | ||
|- | |- | ||
|PlanShipRow | |'''PlanShipRow''' | ||
| | | | ||
|10, String | |10, String | ||
|- | |- | ||
|ShipNote | |'''ShipNote''' | ||
| | | | ||
|60, String | |60, String | ||
|- | |- | ||
|UnitCode | |'''UnitCode''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|UnitFactQuant | |'''UnitFactQuant''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|UnitFactPrice | |'''UnitFactPrice''' | ||
| | | | ||
|0, Value with 2 or 3 Decimals | |0, Value with 2 or 3 Decimals | ||
|- | |- | ||
|UnitXval | |'''UnitXval''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|UnitYval | |'''UnitYval''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|UnitZval | |'''UnitZval''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|Coefficient | |'''Coefficient''' | ||
| | | | ||
|0, Value with All Decimals | |0, Value with All Decimals | ||
|- | |- | ||
|VECode | |'''VECode''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|Production | |'''Production''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|GroupOrdRow | |'''GroupOrdRow''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|TAX2Code | |'''TAX2Code''' | ||
| | | | ||
|5, Code String | |5, Code String | ||
|- | |- | ||
|TAX2Prc | |'''TAX2Prc''' | ||
| | | | ||
|0, Value with 2 or 3 Decimals | |0, Value with 2 or 3 Decimals | ||
|- | |- | ||
|TAX2Reb | |'''TAX2Reb''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|TAX1Reb | |'''TAX1Reb''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|TAX2Acc | |'''TAX2Acc''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|PlanShipRowDate | |'''PlanShipRowDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|CUServiceHistNr | |'''CUServiceHistNr''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|CUServiceUntilDate | |'''CUServiceUntilDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|Position | |'''Position''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|RowOrderType | |'''RowOrderType''' | ||
| | | | ||
|433, Int represented by a Set of String | |433, Int represented by a Set of String | ||
|- | |- | ||
|TaxTemplateCode | |'''TaxTemplateCode''' | ||
| | | | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|TaxMatrix | |'''TaxMatrix''' | ||
| | | | ||
|0, Packed Matrix, base64 data | |0, Packed Matrix, base64 data | ||
|- | |- | ||
|SerNr | |'''SerNr''' | ||
| | | | ||
|0, Value with No Decimals | |0, Value with No Decimals | ||
|- | |- | ||
|RoundVal | |'''RoundVal''' | ||
| | | | ||
|0, Value 2 or 3 Decimals | |0, Value 2 or 3 Decimals | ||
|- | |- | ||
|Region | |'''Region''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|Perceptions | |'''Perceptions''' | ||
| | | | ||
|0, Small Value with No Decimals | |0, Small Value with No Decimals | ||
|- | |- | ||
|MotherArtCode | |'''MotherArtCode''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|RecipeQuant | |'''RecipeQuant''' | ||
| | | | ||
|0, Value with minimum Decimals | |0, Value with minimum Decimals | ||
|- | |- | ||
|CustArtCode | |'''CustArtCode''' | ||
| | | | ||
|20, Code String | |20, Code String | ||
|- | |- | ||
|Salesmen | |'''Salesmen''' | ||
| | | | ||
|60, Capital Characters Only | |60, Capital Characters Only | ||
|- | |- | ||
|OrderType | |'''OrderType''' | ||
| | | | ||
|626, Int represented by a Set of String | |626, Int represented by a Set of String | ||
|- | |- | ||
|UnitComment | |'''UnitComment''' | ||
| | | | ||
|200, String | |200, String | ||
|- | |- | ||
|DiscApprovedBy | |'''DiscApprovedBy''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|- | |- | ||
|ServiceDelDate | |'''ServiceDelDate''' | ||
| | | | ||
|0, In Dataformat Order | |0, In Dataformat Order | ||
|- | |- | ||
|RvrsVATCode | |'''RvrsVATCode''' | ||
| | | | ||
|10, Code String | |10, Code String | ||
|} | |} | ||
=== XMLi näidis, Tellimus 4 reaga === | |||
<syntaxhighlight lang="xml" line="1"> | |||
<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> | |||
</syntaxhighlight> | |||
[[Pilt:Tellimus.png|tühi|pisi|737x737px]] |
Redaktsioon: 9. aprill 2018, kell 13:47
Ühe täidetud müügitellimuse saab pärida siit:
https://mars.excellent.ee:4455/api/1/orvc?sort=SerNr&range=103
Väljade loetelu
Kood | Kirjeldus | Max pikkus, andme tüüp |
---|---|---|
UUID | Tehnilised väljad | 0, Universally unique identifier |
ServerSequence | 0, Unsigned 64-bit value | |
SyncFlags | 0, Value with No Decimals | |
SerNr | Tellimuse nr | 0, Value with No Decimals |
OrdDate | Tellimuse kuupäev | 0, In Dataformat Order |
CustCode | Kliendi kood | 20, Code String |
Addr0 | Kliendi arveaadressi 1. rida | 60, String |
Addr1 | Kliendi arveaadressi 2. rida | 60, String |
Addr2 | Kliendi arveaadressi 3. rida | 60, String |
Addr3 | Kliendi arveaadressi 4. rida | 60, String |
OurContact | Meie esindaja | 20, String |
CustContact | Kliendi esindaja | 60, String |
ExportFlag | Käibemaksutsoon | 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 | 10, String | |
SalesMan | 60, Capital Characters Only | |
Sign | 10, Code String | |
ShipDeal | 5, Code String | |
ShipAddr0 | 60, String | |
ShipAddr1 | 60, String | |
ShipAddr2 | 60, String | |
ShipAddr3 | 60, String | |
CurncyCode | 5, Code String | |
LangCode | 5, Code String | |
InvoiceToCode | 20, Code String | |
Closed | 0, As Bool but displayed as a Checkbox | |
ToRateB1 | 0, Value with 6 Decimals | |
BuildOn | 0, Small Value with No Decimals | |
PRCode | 20, Code String | |
Comment | 60, String | |
InvOnlyOnFull | 0, Small Value with No Decimals | |
DownPaySent | 0, Value 2 or 3 Decimals | |
DownPayRedcd | 0, Value 2 or 3 Decimals | |
OrderClass | 5, Code String | |
CustOrdNr | 60, String | |
PriceList | 5, Code String | |
InclVAT | 0, Small Value with No Decimals | |
Sum0 | 0, Value 2 or 3 Decimals | |
Sum1 | 0, Value 2 or 3 Decimals | |
Sum2 | 0, Value 2 or 3 Decimals | |
Sum3 | 0, Value 2 or 3 Decimals | |
Sum4 | 0, Value 2 or 3 Decimals | |
Reserved | 0, Small Value with No Decimals | |
OSFlag | 0, Small Value with No Decimals | |
Location | 10, Code String | |
CustVATCode | 10, Code String | |
RebCode | 5, Code String | |
VATNr | 20, String | |
Phone | 20, String with phone-number | |
Fax | 20, String | |
ExportedFlag | 0, Small Value with No Decimals | |
BaseSum4 | 0, Value 2 or 3 Decimals | |
FrRate | 0, Value with 6 Decimals | |
ToRateB2 | 0, Value with 6 Decimals | |
BaseRate1 | 0, Value with 6 Decimals | |
BaseRate2 | 0, Value with 6 Decimals | |
DiscPerc | 0, Value with minimum Decimals | |
DiscSum | 0, Value 2 or 3 Decimals | |
TotGP | 0, Value 2 or 3 Decimals | |
Probability | 0, Value with One Decimal | |
CreditCard | 20, Capital Characters Only | |
AuthorizationCode | 10, Capital Characters Only | |
GPProc | 0, Value with One Decimal | |
DespatchDate | 0, In Dataformat Order | |
DespatchTime | 0, Hour:Min:Secs | |
SalesGroup | 30, Capital Characters Only | |
Sorting | 20, String | |
TotQty | 0, Value with minimum Decimals | |
TotWeight | 0, Value with minimum Decimals | |
TotVolume | 0, Value with minimum Decimals | |
Commision | 0, Value 2 or 3 Decimals | |
SumIncCom | 0, Value 2 or 3 Decimals | |
FrPrice | 0, Value 2 or 3 Decimals | |
FrBase | 0, Value 2 or 3 Decimals | |
FrItem | 20, Code String | |
FrVATCode | 10, Code String | |
FrObjects | 60, Capital Characters Only | |
InvAddr3 | 60, String | |
InvAddr4 | 60, String | |
DelAddr3 | 60, String | |
DelAddr4 | 60, String | |
DelAddrCode | 20, Code String | |
TAX1Sum | 0, Value 2 or 3 Decimals | |
QuoteNr | 0, Value with No Decimals | |
InvBeforeShip | 0, Small Value with No Decimals | |
colnr | 46, Int represented by a Set of String | |
OKFlag | 0, As Bool but displayed as a Checkbox | |
PlanShipDate | 0, In Dataformat Order | |
PrepaidAmount | 0, Value 2 or 3 Decimals | |
Region | 20, Code String | |
RefStr | 60, String | |
GroupOrdNr | 0, Value with No Decimals | |
NoDelivery | 0, Small Value with No Decimals | |
NoInvoice | 0, Small Value with No Decimals | |
TAX2Sum | 0, Value 2 or 3 Decimals | |
NoTax1 | 0, Small Value with No Decimals | |
NoTax2 | 0, Small Value with No Decimals | |
BranchID | 20, Code String | |
NoTAXonVAT | 0, Value with No Decimals | |
TotalwoTAX | 0, Small Value with No Decimals | |
OrderType | 433, Int represented by a Set of String | |
AcceptanceStatus | 0, Small Value with No Decimals | |
CustTaxTemplateCode | 10, Code String | |
TaxMatrix | 0, Packed Matrix, base64 data | |
TerminalID | 60, String | |
OfficialSerNr | 100, String | |
Hash | 255, String | |
HashKeyVersion | 0, Small Value with No Decimals | |
RegDate | 0, In Dataformat Order | |
RegTime | 0, Hour:Min:Secs | |
LocalMachineCode | 20, Code String | |
InvCountry | 5, Code String | |
DelCountry | 5, Code String | |
TREONr | 0, Value with No Decimals | |
TREOExpDate | 0, In Dataformat Order | |
ORCONr | 0, Value with No Decimals | |
AcceptanceBy | 200, Comma separated List | |
AcceptanceFYI | 200, Comma separated List | |
BankCode | 10, Code String | |
InvCountryName | 100, String | |
DelCountryName | 100, String | |
OfficialSerNrSerie | 30, String | |
RecipientGLN | 20, String | |
DelRecipientGLN | 20, String | |
IntrastatTransCode | 20, Code String | |
Comment2 | 100, String | |
Comment3 | 100, String | |
Comment4 | 100, String | |
PONr | 0, Value with No Decimals | |
CompNr | 0, Value with No Decimals | |
OYNr | 0, Value with No Decimals | |
OYDescription | 200, String | |
SHShipSetToZero | 0, Small Value with No Decimals | |
RvrsVAT | 0, Value 2 or 3 Decimals | |
PromotionCodes | 200, Comma separated List | |
↓↓↓ Maatriksi read korduvad tühja reani ↓↓↓ | ||
stp | 0, Small Value with No Decimals | |
ArtCode | 20, Code String | |
Quant | 0, Value with minimum Decimals | |
Price | 0, Value with 2 or 3 Decimals | |
Sum | 0, Value 2 or 3 Decimals | |
vRebate | 0, Value with One Decimal | |
SalesAcc | 10, Code String | |
Shipd1 | 0, Value with minimum Decimals | |
Shipd2 | 0, Value with minimum Decimals | |
Invd | 0, Value with minimum Decimals | |
Objects | 60, Capital Characters Only | |
BasePrice | 0, Value with 2 or 3 Decimals | |
rowGP | 0, Value 2 or 3 Decimals | |
Spec | 100, String | |
VATCode | 10, Code String | |
Recepy | 20, Code String | |
SerialNr | 60, String | |
PriceFactor | 0, Value with All Decimals | |
VARList | 30, Capital Characters Only | |
Location | 10, Code String | |
Source | 10, Code String | |
PickingDate | 0, In Dataformat Order | |
PickingTime | 20, String | |
InloadingDate | 0, In Dataformat Order | |
InloadingTime | 20, String | |
DespatchRowDate | 0, In Dataformat Order | |
DespatchRowTime | 20, String | |
PlanShipRow | 10, String | |
ShipNote | 60, String | |
UnitCode | 5, Code String | |
UnitFactQuant | 0, Value with minimum Decimals | |
UnitFactPrice | 0, Value with 2 or 3 Decimals | |
UnitXval | 0, Value with minimum Decimals | |
UnitYval | 0, Value with minimum Decimals | |
UnitZval | 0, Value with minimum Decimals | |
Coefficient | 0, Value with All Decimals | |
VECode | 20, Code String | |
Production | 20, Code String | |
GroupOrdRow | 0, Value with No Decimals | |
TAX2Code | 5, Code String | |
TAX2Prc | 0, Value with 2 or 3 Decimals | |
TAX2Reb | 0, Value 2 or 3 Decimals | |
TAX1Reb | 0, Value 2 or 3 Decimals | |
TAX2Acc | 10, Code String | |
PlanShipRowDate | 0, In Dataformat Order | |
CUServiceHistNr | 0, Value with No Decimals | |
CUServiceUntilDate | 0, In Dataformat Order | |
Position | 20, Code String | |
RowOrderType | 433, Int represented by a Set of String | |
TaxTemplateCode | 60, Capital Characters Only | |
TaxMatrix | 0, Packed Matrix, base64 data | |
SerNr | 0, Value with No Decimals | |
RoundVal | 0, Value 2 or 3 Decimals | |
Region | 20, Code String | |
Perceptions | 0, Small Value with No Decimals | |
MotherArtCode | 20, Code String | |
RecipeQuant | 0, Value with minimum Decimals | |
CustArtCode | 20, Code String | |
Salesmen | 60, Capital Characters Only | |
OrderType | 626, Int represented by a Set of String | |
UnitComment | 200, String | |
DiscApprovedBy | 10, Code String | |
ServiceDelDate | 0, In Dataformat Order | |
RvrsVATCode | 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>