Understand the TankCounter table
- Last UpdatedApr 24, 2025
- 1 minute read
The following table details the fields in the tankCounter table of the AVEVA Pipeline Operations for Liquids database.
|
Internal Field |
Data Type |
Description |
|---|---|---|
|
tankName |
char(15) |
Tank name. |
|
product |
char(15) |
Current product in tank at time of row insertion. |
|
time |
GMTtime |
The Greenwich Mean Time (GMT) at which the row was inserted. |
|
offset |
GMToffset |
The GMT offset. |
|
prodChange |
char(1), null |
Y if entry was the result of a prod change. |
|
netCounter |
char(1), null |
The type of volume:
|
|
counterType |
tinyint |
The type of counter:
|
|
shift |
doubleType |
Shift total. |
|
hour |
doubleType |
The hour counter. |
|
day |
doubleType |
The day counter. |
|
week |
doubleType |
The week counter. |
|
month |
doubleType |
The month counter. |
|
year |
doubleType |
The year counter. |
|
volUnit |
varchar(15), null |
The unit of measure for volume. |
|
ownSysId |
tagIDType, not null |
The owning system ID for tank. |
|
datasetId |
tagIDType, not null |
The dataset ID for the tank. |