Müügitellimused

Ü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	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 = „Eesti“ 1 = „EL“, 2 = „EL (konteeri KM)“, 3 = „Mitte EL“ 4 = „Mitte EL (konteeri KM)	0, Small Value with No Decimals
InvFlag	Arve tehtud? Linnuke sirvi aknas	0, Small Value with No Decimals
ShipFlag	Lähetus tehtud? Linnuke sirvi aknas	0, Small Value with No Decimals
Prntdf	Saadetud? Peidetud väli	0, Small Value with No Decimals
PayDeal	Tasumistingimus	2, Code String
CustCat	Kliendiklass	5, Code String
InvMark	Arve	0, As Bool but displayed as a Checkbox
ShipMark	Läh	0, As Bool but displayed as a Checkbox
Objects	Objektid	60, Capital Characters Only
ShipMode	Lähetusviis	5, Code String
OrderStatus	Eksporditud linnuke (0=ei; 1=jah)	0, Small Value with No Decimals
PlanShip	Planeeritud lähetus	10, String
SalesMan	Müügimees	60, Capital Characters Only
Sign	Tellimuse koostaja (peidetud väli, programmi sisse logitud kasutaja, kes tellimuse koostas)	10, Code String
ShipDeal	Lähtustingimus	5, Code String
ShipAddr0	Lähetusaadressi 1. rida	60, String
ShipAddr1	Lähetusaadressi 2. rida	60, String
ShipAddr2	Lähetusaadressi 3. rida	60, String
ShipAddr3	Lähetusaadressi 4. rida	60, String
CurncyCode	Valuuta	5, Code String
LangCode	Keele	5, Code String
InvoiceToCode	Arve saaja	20, Code String
Closed	Suletud	0, As Bool but displayed as a Checkbox
ToRateB1	Baasvaluuta 1 (kurss)	0, Value with 6 Decimals
BuildOn	N/A	0, Small Value with No Decimals
PRCode	Projekti kood	20, Code String
Comment	Kommentaar	60, String
InvOnlyOnFull	N/A	0, Small Value with No Decimals
DownPaySent	Ettemakstud (Aknas peidetud)	0, Value 2 or 3 Decimals
DownPayRedcd	Ettemaks laekunud (Aknas peidetud)	0, Value 2 or 3 Decimals
OrderClass	Tellimuse klass	5, Code String
CustOrdNr	Kliendi tellimuse number	60, String
PriceList	Hinnakiri	5, Code String
InclVAT	K.a. käibemaks (Aknas peidetud)	0, Small Value with No Decimals
Sum0		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>