Müügitellimused: erinevus redaktsioonide vahel

Allikas: Excellent || Opendoc
Mine navigeerimisribale Mine otsikasti
(Uus lehekülg: 'yes')
 
Resümee puudub
1. rida: 1. rida:
yes
Üks täidetud ostutellimus:
 
<code><nowiki>https://mars.excellent.ee:4455/api/1/orvc?sort=SerNr&range=103</nowiki></code>
 
{| class="wikitable"
|Andmevälja kood
|
|
|-
|UUID
|
|0, Universally unique identifier
|-
|ServerSequence
|
|0, Unsigned 64-bit value
|-
|SyncFlags
|
|0, Value with No Decimals
|-
|SerNr
|
|0, Value with No Decimals
|-
|OrdDate
|
|0, In Dataformat Order
|-
|CustCode
|
|20, Code String
|-
|Addr0
|
|60, String
|-
|Addr1
|
|60, String
|-
|Addr2
|
|60, String
|-
|Addr3
|
|60, String
|-
|OurContact
|
|20, String
|-
|CustContact
|
|60, String
|-
|ExportFlag
|
|0, Small Value with No Decimals
|-
|InvFlag
|
|0, Small Value with No Decimals
|-
|ShipFlag
|
|0, Small Value with No Decimals
|-
|Prntdf
|
|0, Small Value with No Decimals
|-
|PayDeal
|
|2, Code String
|-
|CustCat
|
|5, Code String
|-
|InvMark
|
|0, As Bool but displayed as a Checkbox
|-
|ShipMark
|
|0, As Bool but displayed as a Checkbox
|-
|Objects
|
|60, Capital Characters Only
|-
|ShipMode
|
|5, Code String
|-
|OrderStatus
|
|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
|-
| colspan="2" |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
|}

Redaktsioon: 9. aprill 2018, kell 13:18

Üks täidetud ostutellimus:

https://mars.excellent.ee:4455/api/1/orvc?sort=SerNr&range=103

Andmevälja kood
UUID 0, Universally unique identifier
ServerSequence 0, Unsigned 64-bit value
SyncFlags 0, Value with No Decimals
SerNr 0, Value with No Decimals
OrdDate 0, In Dataformat Order
CustCode 20, Code String
Addr0 60, String
Addr1 60, String
Addr2 60, String
Addr3 60, String
OurContact 20, String
CustContact 60, String
ExportFlag 0, Small Value with No Decimals
InvFlag 0, Small Value with No Decimals
ShipFlag 0, Small Value with No Decimals
Prntdf 0, Small Value with No Decimals
PayDeal 2, Code String
CustCat 5, Code String
InvMark 0, As Bool but displayed as a Checkbox
ShipMark 0, As Bool but displayed as a Checkbox
Objects 60, Capital Characters Only
ShipMode 5, Code String
OrderStatus 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
Pärit leheküljelt "https://kaust.excellent.ee/opendoc/index.php?title=Müügitellimused&oldid=76"