Understand the Flow Computer Ticket Device (FlowcomputerTicketDevice) table

msrepl_tran_version

uniqueidentifier

Unique record identifier.

time

GMTtime(int)

This provides the time the ticket was created, using Greenwich Mean Time (GMT).

offset

GMToffset (smallint)

GMT offset.

ticketno

varchar(15)

Ticket number.

nomId

int

batchXfer

nameType(varchar32)

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

deviceName

nameType(varchar32)

scountIV

float

Start of batch transfer Indicated Volume (IV).

ecountIV

float

End of batch transfer IV.

scountGSV

float

Start of batch transfer Gross Standard Volume (GSV).

ecountGSV

float

End of batch transfer GSV.

wad

float

Weighted Average Density (WAD).

wat

float

Weighted Average Temperature (WAT).

wap

float

Weighted Average Pressure (WAP).

waf

float

Weighted Average Flow rate (WAF).

cpl

decimal (17,15)

Volume Correction Factor for Temperature (CPL).

ctl

decimal (17,15)

Volume Correction Factor for Pressure (CTL).

ctpl

float

Combined Temperature and Pressure Factor (CTPL).

mcf

float

Meter Correction Factor (MCF).

IV

float

Gross Uncalibrated Volume.

GSV

float

Gross Standard Volume (GSV).

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 unit information is stored.

audit_trail_revision

int, null

Provides audit trail information.

ownsysID

tagIDtype(int)

ID of the system to which the ticket belongs.

datasetID

tagIDtype(int)

Dataset to which the ticket belongs.

userName

varchar(32)

The name of the user that made the modification.

revisionTime

GMTtime(int)

The time that the modification was made.