Understand the Ticket Total (TicketTotal) table

msrepl_tran_version

Uniqueidentifier

This field provides a unique record identifier

time

GMTtime (int)

This column supplies the Greenwich Mean Time (GMT) information.

offset

GMToffset(smallint)

This column supplies the GMT offset for the associated time zone.

ticketno

varchar(15)

This column supplies the ticket number for the completed ticket.

batchXfer

nameType

The name of the batch transfer (batchXfer) record that generated the completed ticket.

batchId

char(31)

This column provides the Batch ID information for the completed ticket.

ppltask

char(1)

Defines whether the ticket is a lift, delivery, or enroute.

manual

char(1)

Defines whether the ticket is a manual ticket.

remote

char(1)

Defines whether the ticket is a remote ticket.

contam

char(1)

Defines whether the ticket is a contaminated ticket.

rev

char(1)

Defines whether the ticket is a reversal.

prdTypCode

nameType

This column supplies the product type of the completed ticket.

prdGrp

nameType

This column supplies the product group information.

schgsv

float

This column supplies the scheduled volume information.

schsTime

char(25)

This column supplies the scheduled batch start time information.

scheTime

char(25)

This column supplies the scheduled batch end time information.

schcomment

char(80)

Scheduler comment.

shipper

nameType

Shipper.

sTime

char(25)

Actual batch start time.

sGMTTime

GMTtime(int)

Actual batch start time in GMT time.

SW_Volume

float

The volume of sediment and water in the pipe. This is calculated as follows:

GSV x (csw / 100).

eTime

char(25)

Actual batch end time.

eGMTTime

GMTtime(int)

Actual batch end time in GMT time.

IV

float null

Indicated Volume (IV).

GV

float null

Gross Volume (GV).

GSV

float null

Gross Standard Volume (GSV).

NSV

float null

Net Standard Volume (NSV).

csw

float null

Sediment and water percentage.

Opcomment

char(80)

Controller's comments.

waod

float

Weighted Average Observed Density (WAOD).

wad

float

Weighted Average Density (WAD).

wap

float

Weighted Average Pressure (WAP).

wat

float

Weighted Average Temperature (WAT).

wamcf

float

Weighted Average Meter Correction Factor (WAMCF).

wactl

float

Weighted Average Temperature Correction Factor (WACTL).

wacpl

float

Weighted Average Pressure Correction Factor (WACPL).

waf

float

Weighted Average Flow rate (WAF) over the time period of the ticket.

waswp

float

Weighted Average Sediment and Water Percent (WASWP) over the time period of the ticket.

wav

float

Weighted Average Viscosity (WAV) over the time period of the ticket.

wasp

float

Weighted Average Sulphur Percent (WASP) over the time period of the ticket.

curDayTot

float

Current day total volume.

curMonTot

float

Current month total volume.

volUnit

varchar(15)

Units in which the volume information is stored.

densUnit

varchar(15)

Units in which the density information is stored.

tempUnit

varchar(15)

Units in which the temperature information is stored.

presUnit

varchar(15)

Units in which the pressure information is stored.

viscUnit

varchar(15)

Units in which the viscosity information is stored.

accepted

char(1)

Whether the ticket has been verified. At this point, it can no longer be edited.

Audit_trail_revision

int

Revision number used for auditing purposes.

ownsysID

tagIDType(int)

The system ID that made the aggregation entry.

datasetID

tagIDType(int)

The dataset ID that the entry belongs to.

user

varchar(32)

The user who made the modification.

revisionTime

GMTtime(int)

The time that the modification was made.

nomID

int

Nomination ID.

modified

char1

Whether the ticket has been modified by the Controller.

original_GSV

float

The original Gross Standard Volume (GSV) prior to adjustment.

GSV_Adjustment

float

The GSV adjustment value.

mass

float

This column provides the mass information.

massUnit

varchar(15)

Units in which the mass information is stored.