Fields, Statistics API

Statistics.AddService

Information about additional charges on the order, for example for waiting time.

API	Fields in Opter
id	A number that identifies the extras in the database.
deliveryId	Order number
addServiceTypeName	Lisateenuste liik
invoiceStatusName	Arve olek
creditingStatusName	Ressursi krediteerimise olek
description	Kirjeldus
quantity	Kogus
resourceCreditingUnitId	A number that identifies the resource credit unit in the database.
income	Sissetulekud
cost	Maksumus

Statistics.Address

Information about the addresses on an order. An order may be divided into several shipments (stages). An address, such as a terminal, can be the recipient of one shipment and the sender of the next.

API	Fields in Opter
id	A number that identifies the address in the database.
deliveryId	Order number
countryName	Riik
geographicalZoneName	Geograafiline tsoon
customerId	A number that identifies the customer in the database.
customerCode	Kliendi kood
terminalId	A number that identifies the terminal in the database.
terminalCode	Kood
order	A number that identifies the address’s position in the delivery chain (sorting order).
addressLine1	Nimi
company	Firma
street	Tänav
streetNumber	Nr
postcode	Postiindeks
city	Linn
information	Teave
addressPositionAccuracyName	Accuracy of the address position.
longitude	Pikkuskraad
latitude	Laiuskraad

Statistics.Customer

Information about the customer paying for an order. Customers can also be linked to addresses.

API	Fields in Opter
id	A number that identifies the customer in the database.
customerCode	Kliendi kood
customerNumber	Kliendi number
name	Klient
addressLine1Visit	Nimi (visiting address)
streetVisit	Tänav (visiting address)
streetNumberVisit	Nr (visiting address)
cityVisit	Linn (visiting address)
zipCodeVisit	Postiindeks (visiting address)
countryNameVisit	Riik (visiting address)
phone	Telefon
emailAddress	E-post
invoiceReference	Meie viide
addressLine1Invoice	Nimi (billing address)
streetInvoice	Tänav (billing address)
invoiceStreetNumber	Nr (billing address)
cityInvoice	Linn (billing address)
zipCodeInvoice	Postiindeks (billing address)
invoiceCountryName	Riik (billing address)
podTimeLimitName	Time limit for POD registration.
podTimeLimitMinutesAfterOrdering	Time limit for POD registration after ordering (minutes).
podTimeLimitMinutesAfterCompletion	Time limit for POD registration after delivery (minutes).
costPoolName	Kulude kogumid
statisticalGroupName	Statistiline rühm
customerCategoryName	Kliendi kategooria
responsibleSalesPersonName	Vastutav müügiinimene

Statistics.Delivery

The main item in an order. An order is paid for by a customer and contains at least one shipment.

API	Fields in Opter
id	A number that identifies the order in the database.
customerId	A number that identifies the customer in the database.
customerCode	Kliendi kood
serviceTypeId	A number that identifies the order type in the database.
serviceTypeName	Teenuse tüüp
priceVehicleTypeId	A number that identifies the vehicle type in the database.
priceVehicleTypeName	Sõiduki tüüp
customerProjectId	A number that identifies the customer project in the database.
customerProjectName	Projekt
timeFailureReasonName	Hilinemise põhjus
invoiceStatusName	Arve olek
priceListName	Hinnakiri
deliveryCreateTypeName	Loo tüüp
regionId	A number that identifies the region in the database.
regionName	Piirkond
statusName	Staatus
freightBill	Veokiri
senderReference	Saatja viide
receiverReference	Saaja viide
projectNumber	Projekt
emissionForecast	CO2 emissions, estimated (g)
calculatedEmissionForecast	Calculated CO2 emissions (g)
extraId1–extraid5	Täiendav ID1–Extra id5. The field names are set on the Terminoloogia tab in the office settings.
calculatedExtraDimension1–calculatedExtraDimension5	Lisamõõde 1–Lisamõõde5. The names of the dimensions are set on the Terminoloogia tab in the office settings.
calculatedPackages	Pakkeüksused
calculatedWeight	Kaal
calculatedLoadMeter	Laadimismeeter
calculatedPalletSpaces	Kaubaaluste koht
calculatedVolume	Maht
pricingWeight	Hinnastamise kaal
calculatedDistanceKM	Kaugus
created	Loodud
changed	The date and time when the order was last amended.
transportDate	Tellimuse kuupäev
timeFailureComment	Viivituse kommentaar
income	Sissetulekud
cost	Maksumus
readyForInvoicing	Valmis arvete esitamiseks/krediteerimiseks
notToBeInvoiced	Arvet ei esitata
manualPrice	Manuaalne hind
isConsolidation	Konsolideerimine
consolidationOrderId	Order number for the consolidation order.
ediImportName	EDI ühendus (import)

Statistics.DeliveryCorrection

Information about correction invoices for an order. Correction invoices are usually issued after the order has been invoiced.

API	Fields in Opter
id	A number that identifies the correction invoice in the database.
deliveryId	Order number
priceFactor	Hinnategur (%)
manualPrice	Manuaalne hind
comment	Comment
created	Loodud
punishResource	Karistada ressurssi
currencyId	A code that identifies the currency in the database.
currencyName	Valuuta
invoiceStatusId	A number that identifies the invoice status in the database. The status name is returned in invoiceStatusName.
invoiceStatusName	Arve olek
customerId	A number that identifies the customer in the database.
customerCode	Kliendi kood
customerName	Klient

Statistics.DeliveryLog

An order log that is updated whenever an order is amended, allocated, collected, and so on. The order log can be found under Tellimuste logi in the order reception area.

API	Fields in Opter
id	A number that identifies the log entry in the database.
deliveryId	Order number
shipmentId	A number that identifies the shipment in the database.
deliveryStatusId	A number that identifies the order status in the database. The status name is returned in statusNameDelivery.
deliveryStatus	Tellimuse olek
shipmentStatusId	A number that identifies the order status in the database. The status name is returned in statusNameShipment.
shipmentStatus	Saadetise olek
employeeId	A number that identifies the driver in the database.
employeeCode employeeFirstName employeeLastName	Juht
vehicleId	A number that identifies the vehicle in the database.
vehicleCode vehicleName	Sõiduk
workingSessionId	A number that identifies the shift in the database.
subcontractorId	A number that identifies the subcontractor in the database.
subcontractorCode subcontractorName	Alltöövõtja
employeeIdUser	A number that identifies the user who logged the change in the database.
employeeFirstNameUser employeeLastNameUser	Kasutaja
logTime	Aeg
orderChanged	Indicates whether anything other than the order status has changed. Indicated by the icon in the first column of the order log.
orderViewed	Indicates whether the order was opened without being modified. Indicated by the icon in the first column of the order log.

Statistics.DeliveryOption

Information about the options on an order.

API	Fields in Opter
deliveryId	Order number
name	Valikud
code	Kood

Statistics.DeliveryProduct

Information about the products in an order. A product is usually a crate or a pallet, which is charged per item.

API	Fields in Opter
id	A number that identifies the product line in the database.
deliveryId	Order number
productId	A number that identifies the product in the database.
productName	Toode
quantity	Kogus
price	Hind
invoicedPrice	Arveldatud

Statistics.Deviation

Information about deviations in an order.

API	Fields in Opter
id	A number that identifies the deviation in the database.
deliveryId	Order number
typeName	Kahjustuse tüüp
reasonName	Kahjustuse põhjus
eventName	Kahju sündmus
comment	Comment
completed	Lõpetatud
created	Loodud
evaluationEffect	Hindamine/Mõju
longitude	Pikkuskraad
latitude	Laiuskraad
measure	Mõõtke
paidAmount	Makstud summa
value	Value
userIdCreated	A number identifying the user who added the deviation to the order.
userNameCreated	Loodud

Statistics.DirectExpense

Information about direct expense on an order. A direct expense is not treated as a sale but as an expense for the paying customer.

API	Fields in Opter
id	A number that identifies the direct expense in the database.
deliveryId	Order number
amount	Summa
created	Loodud
description	Kirjeldus
currencyId	A code that identifies the currency in the database.
currencyName	Valuuta

Statistics.Employee

Information about a driver assigned to a shipment (stage). The employee is usually the driver carrying out the transport.

API	Fields in Opter
id	A number that identifies the driver in the database.
code	Hüüdnimi
firstName surname	Juht
supplierId	A number that identifies the supplier in the database.
supplierCode	Kood (for the supplier to whom the driver is attached).
supplierName	Hankija (to which the driver is assigned).

Statistics.Invoice

Information about a customer invoice.

API	Fields in Opter
id	A number that identifies the invoice in the database.
invoiceNumber	Arve number
invoiceDate	Arve kuupäev
invoicePeriodNumber	Arve periood
untilDate	Lõppkuupäev (the invoice period)
invoiceTypeName	Arve tüüp
invoiceIdReferer	A reference number that identifies the original invoice which a correction invoice amends in the database.
customerId	A number that identifies the customer in the database.
customerCode	Kliendi kood
customerProjectName	Projekt
oCRNumber	OCR-number
created	Loodud
accountingDate	Arvestuskuupäev
maturityDate	Tagasimaksekuupäev
adminFee	Arve administreerimise tasu
fuelExtra	Kütuselisa
totalExcludingTax	Käive
tax	KM
amountPayable	Tasumisele kuuluv summa
directExpense	Otsene kulu

Statistics.InvoiceRow

Links an order to an invoice.

API	Fields in Opter
id	A number that identifies the invoice line in the database.
invoiceId	A number that identifies the invoice in the database.
invoiceNumber	Arve number
invoiceDate	Arve kuupäev
deliveryId	Order number
priceItemRowId	A number that identifies the item line in the database.
addServiceId	A number that identifies the extras in the database.
priceExpenseId	A number that identifies the expenses in the database.
directExpenseId	A number that identifies the direct expense in the database.
deliveryCorrectionId	A number that identifies the entry in the database.
price	Hind
fuelExtra	Kütuselisa

Statistics.LooseItemBalance

Information on the number of loose items collected from and delivered to an address. This is typically used to track the stock levels of pallets and crates for an order.

API	Fields in Opter
id	A number that identifies the balance row in the database.
deliveryId	Order number
looseItemTypeName	Eseme tüüp
startingQuantity	Algkogus
endingQuantity	Lõppkoguse kogus

Statistics.Package

Information about a parcel in an order. Usually the dimensions and parcel number for tracking and barcode scanning.

API	Fields in Opter
id	A number that identifies the consignment in the database.
packageNumber	Saadetiste id
deliveryId	Order number
productId	A number that identifies the product in the database.
quantity	Kogus
weight	Kaal
goodsType	Kauba tüüp
depth	Pikkus
height	Kõrgus
width	Laius
missingSince	Alates sellest ajast kadunud
packageType	Tüüp
text	Tekst
stackable	Virnastatav

Statistics.PackageWeightCorrection

Information regarding a change in weight on an order. Package weight corrections are usually made at terminals when the goods are weighed and measured.

API	Fields in Opter
id	A number that identifies the package weight correction in the database.
packageId	A number that identifies the consignment in the database.
packageNumber	Saadetise ID
weight	Kaal
volume	Maht
loadMeter	LDM
palletSpaces	Kaubaalused
height	Kõrgus
width	Laius
depth	Pikkus
originalPackageWeight	Originaalne saadetiste kaal
originalPackageVolume	Originaalne saadetiste maht
originalPackageLoadMeter	Originaal ldm
originalPackagePalletSpaces	Algne ala
originalPackageHeight	The original height of the package.
originalPackageWidth	Algne laius
originalPackageDepth	Algne pikkus
originalOrderCalculatedWeight	Originaalne saadetiste kaal (estimated)
originalOrderCalculatedVolume	Originaalne saadetiste maht (estimated)
originalOrderCalculatedLoadMeter	Originaal ldm (estimated)
originalOrderCalculatedPalletSpaces	Algne ala (estimated).
originalOrderPricingWeight	Algne hinnastamisekaal
originalOrderPrice	Algne hind
newOrderPricingWeight	Uus hinnakaal
newOrderPrice	Uus hind
created	Loodud

Statistics.Pod

Information about a pod for an order. A pod usually includes the date and time, the recipient’s name and signature.

API	Fields in Opter
id	A number that identifies the pod in the database.
deliveryId	Order number
shipmentId	Shipment number
dateTime	Kuupäev/Aeg
name	Nimi
comment	Comment
description	Märkus
packageCount	Pakkeüksus (scanned).
latitude	Laiuskraad
longitude	Pikkuskraad
podTypeId	A number that identifies the POD-type in the database.
podTypeIdSub	A number that identifies the sub-POD-type in the database.
podTypeName	POD-tüüpi
userId	A number that identifies the user in the database.
userName	Kasutajanimi

Statistics.PriceItemRow

Information about a price row on an order.

API	Fields in Opter
id	A number that identifies the price row in the database.
deliveryId	Order number
description	Kirjeldus
extraId1–extraId8	Extra Id 1–Extra ID 8 (manual price item entry)
unit1Quantity/unit2Quantity	Koguse ühik 1/Koguse ühik 2
contractorInvoiceNumber	Töövõtja arve nr
contractorInvoiceDone	Tehtud töövõtja arved
unit1Id/unit2Id	A number that identifies the units in the database.
unit1Name/unit2Name	1. üksuse nimi/2. üksuse nimi
priceListId	A number that identifies the price list in the database.
priceListName	Hinnakiri
priceItemId	A number that identifies the price item in the database.
priceItemName	Hinnaartikkel
priceItemCode	Hinnaartikli kood
resourceCreditingUnitId	A number that identifies the resource credit unit in the database.
income	Sissetulekud
cost	Maksumus
resourceCreditingStatusId	A number identifying the resource crediting status in the database (1 = Ärge krediteerige, 2 = Krediidi saamiseks, 3 = Krediteeritud, 4 = Eemaldatud, ära krediiteeri, 5 = Töötaja, ärge krediteerige, 6 = Saadetud, mitte krediiteerida, 7 = Arhiveeritud ajalugu, 8 = Omahinna artikkel asendab, ei krediteeri).
deliveryOptionId	A number that identifies the options in the database.
deliveryOptionName	Valikud
invoiceStatusId	A number that identifies the invoice status in the database (1 = EI esitata arvet, 2 = Arveldamiseks, 3 = Arveldatud, 4 = Ära visatud (arveldatus), 5 = Ainult krediteerimine).
priceItemTypeId	A number identifying the price item type in the database (1 = Teenus, 2 = Maksumus, 3 = Lisa, 4 = Valikud).

Statistics.PriceRow

Detailed information about the price lines on an order.

API	Fields in Opter
id	A number that identifies the price row in the database.
deliveryId	Order number
invoiceRowId	A number that identifies the invoice line in the database.
supplierBillRowId	A number that identifies the settlement line in the database.
price	Hind
discount	Allahindlus
commissionDiscount	Kickback
resourceValue	Ressursi väärtus
unitName	Üksuse nimi
unitQuantity	Kogus
productName	Toode
priceItemId	A number that identifies the price item in the database.
priceItemName	Hinnaartikkel
pricePriceTypeId	A code that identifies the price type in the database.

Statistics.ResourceCreditingUnit

Information about revenue and costs for an order. The resource credit units are actually used to pay drivers and subcontractors, but they also include the revenue allocation for the order. The resource credit unit contains all revenue and costs relating to the order and can therefore be used as a source of prices.

API	Fields in Opter
id	A number that identifies the resource credit unit in the database.
deliveryId	Order number
transportDate	Tellimuse kuupäev
creditingUnitTypeName	Ressursi krediteerimisüksuse tüüp
creditingStatusName	Ressursi krediteerimise olek
shipmentId	Tarnekuupäev
addServiceId	A number that identifies the extras in the database.
priceItemRowId	A number that identifies the price row in the database.
addressId	A number that identifies the address in the database.
income	Sissetulekud
indirectIncome	Indirect revenue.
cost	Maksumus
indirectCost	Indirect cost.
costFuelExtra	Kütuselisa (cost)
resourceValue	Ressursi väärtus
resourceValueFuelExtra	Kütuselisa (resource value)
terminalId	A number that identifies the terminal in the database.
terminalCode	Terminali kood
terminalName	Terminali nimi
employeeId	A number that identifies the employee in the database.
employeeCode	Hüüdnimi
employeeFirstName employeeLastName	Juht
vehicleId	A number that identifies the vehicle in the database.
vehicleCode	Number (vehicle)
vehicleName	Sõiduk
subcontractorId	A number that identifies the subcontractor in the database.
subcontractorCode	Kood (subcontractor)
subcontractorName	Alltöövõtja
supplierId	A number that identifies the supplier in the database.
supplierCode	Kood (supplier)
supplierName	Hankija
supplierBillId	A number that identifies the supplier bill in the database.
supplierBillNumber	Krediidi number
supplierBillDate	Arve kuupäev

Statistics.SalesLedgerTransactionItem

Accounting information regarding invoices and supplier bills. Usually contains an account number, an amount and other reference information.

API	Fields in Opter
id	A number that identifies the accounting line in the database.
salesLedgerTransactionId	A number that identifies the document in the database.
date	Arvestuskuupäev
salesLedgerTransactionTypeId	A number that identifies the transaction type in the database.
salesLedgerTransactionItemTypeId	A number that identifies the transaction row type in the database.
accountId	A number that identifies the account in the database.
accountName	Konto number
accountDescription	Kirjeldus
debit	Debet
credit	Krediit
taxRateId	A code that identifies the VAT rate in the database.
taxRateCode	Kood
taxRateName	KM
invoiceId	A number that identifies the invoice in the database.
supplierBillId	A number that identifies the supplier bill in the database.
deliveryId	Order number
shipmentId	Shipment number
addServiceId	A number that identifies the extras in the database.
priceExpenseId	A number that identifies the expenses in the database.
directExpenseId	A number that identifies the direct expense in the database.
priceItemRowId	A number that identifies the price row in the database.
supplierBillAdditionId	A number that identifies the supplier bill adjustments in the database.
regionId	A number that identifies the region in the database.
regionName	Piirkond
economicUnit1Id–economicUnit5Id	A number that identifies the economic units in the database.
economicUnit1Name–economicUnit5Name	Majandusüksused 1–Majandusüksused 5. The names of the economic units are entered on the Majandus tab in the office settings.
comment	Comment

Statistics.Scan

Information about a freight bill or parcel scan. Scans can be carried out upon collection, arrival at the terminal, departures from the terminal and delivery.

API	Fields in Opter
id	A number that identifies the scan in the database.
deliveryId	Order number
packageId	A number that identifies the consignment in the database.
packageNumber	Saadetise ID
scanTypeId	A number that identifies the scan type in the database.
terminalId	A number that identifies the terminal in the database.
userId	A number that identifies the user in the database.
loadCarrierId	A number that identifies the load carrier in the database.
employeeId	A number that identifies the employee in the database.
vehicleId	A number that identifies the vehicle in the database.
subcontractorId	A number that identifies the subcontractor in the database.
scanTime	Skaneerimise aeg
undoScanTime	Skannimine on tagasi võetud
batchId	Partii
comment	Comment
routes	Marsruut
longitude	Pikkuskraad
latitude	Laiuskraad

Statistics.Shipment

Information about a shipment on an order. Each order contains at least one shipment, but may contain more. An order goes from the sender to the recipient (A–B), but if the order is split across terminals, the shipments may be A–T1, T1–T2 and T2–B. The shipments may be carried out by different drivers, vehicles or subcontractors. Revenue and costs are also available at project level.

API	Fields in Opter
id	A number that identifies the shipment in the database.
deliveryId	Order number
deliveryIdConsignment	Consignment order no.
deliveryTransportDate	Tellimuse kuupäev
shipmentDate	Tarnekuupäev
shipmentTypeId	A number identifying the assignment type in the database (1 = Otsevedu, 2 = Korje, 3 = Liinivedu, 4 = Kohaletoimetamine).
regionId	A number that identifies the region in the database.
regionName	Piirkond
order	A number that identifies the shipment’s position in the supply chain (sorting order).
addressIdFrom	A number that identifies the starting address in the database.
addressIdTo	A number that identifies the final address in the database.
calculatedDistance	Kaugus (km)
sharingFactor	Jagamise tegur
earliestPickupTime	Varasem korje aeg
latestPickupTime	Viimane korje aeg
earliestDeliveryTime	Varasem tarneaeg
latestDeliveryTime	Viimane tarneaeg
loggedPickupTime	korje aeg (tegelik)
loggedDeliveryTime	Tarneaeg (tegelik)
income	Sissetulekud
internalIndirectIncome	Internal indirect revenue.
indirectIncome	Indirect revenue.
resourceValue	Ressursi väärtus
internalIndirectResourceValue	Internal indirect resource value.
cost	Maksumus
internalIndirectCost	Internal indirect cost.
indirectCost	Indirect cost.
emissionEstimate	CO2 emissions, estimated (g)
calculatedEmissionEstimate	CO2 emissions, calculated (g)
manualResourcePrice	Ressursi hind
employeeId	A number that identifies the employee in the database.
employeeCode	Hüüdnimi
employeeFirstName employeeLastName	Juht
vehicleId	A number that identifies the vehicle in the database.
vehicleCode	Number (vehicle)
vehicleName	Sõiduk
supplierId	A number that identifies the supplier in the database.
supplierCode	Kood (supplier)
supplierName	Hankija
subcontractorId	A number that identifies the subcontractor in the database.
subcontractorCode	Kood (subcontractor)
subcontractorName	Alltöövõtja
statusName	Staatus

Statistics.Subcontractor

Information about a subcontractor handling a shipment. A subcontractor is a separate company that manages its own dispatch, unlike vehicles or employees.

API	Fields in Opter
id	A number that identifies the subcontractor in the database.
code	Kood (subcontractor)
name	Alltöövõtja

Statistics.Supplier

Information about a supplier. The supplier owns the vehicles or employs drivers, and acts as an administrative unit for paying drivers/vehicles that are managed, but not owned, by the transport company.

API	Fields in Opter
id	A number that identifies the supplier in the database.
code	Kood (supplier)
name	Hankija

Statistics.SupplierBill

Information regarding a supplier bill to be paid to a subcontractor or supplier.

API	Fields in Opter
id	A number that identifies the supplier bill in the database.
vehicle number	Kreeditarve
billDate	Arve kuupäev
transportAmount	Saadetised
additionAmount	Lisad
totalTax	KM
roundingAmount	Ümardamine
total	Makstud
subcontractorId	A number that identifies the subcontractor in the database.
subcontractorCode	Kood (subcontractor)
subcontractorName	Alltöövõtja
supplierId	A number that identifies the supplier in the database.
supplierCode	Kood (supplier)
supplierName	Hankija

Statistics.Vehicle

Vehicle information.

API	Fields in Opter
id	A number that identifies the vehicle in the database.
code	Number
name	Nimi
registrationNumber	Registreerimisnumber
vehicleTypeId	A number that identifies the vehicle type in the database.
vehicleTypeName	Sõiduki tüüp
supplierId	A number that identifies the supplier to whom the vehicle is linked in the database.
supplierCode	Kood
supplierName	Hankija
emissionClass	Emissiooniklass
fuelConsumption	Fuel consumption per 100 km
emissionInGramPerKilometer	CO2 emissions (g/km)
emissionPricingWeightCapacity	Capacity converted into pricing weight (kg)
fuelName	Fuel
weight	Kaal
volume	Maht
loadMeter	Laadimismeeter
palletSpaces	Kaubaaluste koht
extraDimension1–extraDimension5	Lisamõõde1–Lisamõõde5. The names of the dimensions are set on the Terminoloogia tab in the office settings.
cost	Sihtkulu

Statistics.WorkingSession

Information about a shift. A shift is created when a driver logs in and contains information about the shipments handled during the shift, as well as the start and end times.

API	Fields in Opter
id	A number that identifies the shift in the database.
vehicleId	A number that identifies the vehicle in the database.
vehicleCode	Sõiduki number
vehicleName	Sõiduki nimi
employeeId	A number that identifies the employee in the database.
employeeCode	Hüüdnimi
employeeFirstName employeeLastName	Juht
supplierId	A number that identifies the supplier to whom the vehicle/driver is linked in the database.
supplierName	Hankija
startTime	Alusta
endTime	Lõpp
startLunch	Lõuna algus
endLunch	Lõuna lõpp
comment	Kommenteeri