Müügitellimused

Allikas: Excellent || Opendoc
Redaktsioon seisuga 12. aprill 2018, kell 07:48 kasutajalt Kaupo (arutelu | kaastöö) (→‎Väljade loetelu)
Mine navigeerimisribale Mine otsikasti

Ü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 Ümardus (Aknas peidetud) 0, Value 2 or 3 Decimals
Sum1 Vahesumma 0, Value 2 or 3 Decimals
Sum2 (Aknas peidetud) 0, Value 2 or 3 Decimals
Sum3 KM summa 0, Value 2 or 3 Decimals
Sum4 Kokku 0, Value 2 or 3 Decimals
Reserved Reserveeritud linnuke 0, Small Value with No Decimals
OSFlag N/A 0, Small Value with No Decimals
Location Ladu 10, Code String
CustVATCode Kliendi müügi KM kood (Aknas peidetud, tuleb kontaktikaardilt) 10, Code String
RebCode Hinnaalandusmaatriks 5, Code String
VATNr N/A 20, String
Phone Kliendi telefon 20, String with phone-number
Fax Kliendi faks 20, String
ExportedFlag N/A 0, Small Value with No Decimals
BaseSum4 Kokku (Baasvaluutas) 0, Value 2 or 3 Decimals
FrRate Kurss 0, Value with 6 Decimals
ToRateB2 Baasvaluuta 2 0, Value with 6 Decimals
BaseRate1 Baasvaluuta 1 0, Value with 6 Decimals
BaseRate2 Baasvaluuta 2 0, Value with 6 Decimals
DiscPerc 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>
Tellimus.png