Müügitellimused

Allikas: Excellent || Opendoc
Redaktsioon seisuga 9. aprill 2018, kell 13:47 kasutajalt Kaupo (arutelu | kaastöö)
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

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>
Tellimus.png
Pärit leheküljelt "https://kaust.excellent.ee/opendoc/index.php?title=Müügitellimused&oldid=79"