pplBatchInventory

time

GMTtime(int)

The time the data was written to the Historical database.

offset

GMTOffset(smallint)

The minute offset of this timezone from Greenwich Mean Time (GMT).

pipeline

nameType(varchar(32))

The pipeline that this batch is in.

batchID

nameType(varchar(31))

The ID of the batch that was provided to Batch Tracking by the Batch Transfer or Virtual Flow Computer applications.

batchName

batchnameType

The name of the batch that was automatically generated by Batch Tracking.

prodtype

nameType(varchar(32))

The product type of the batch.

GSV

float

The gross standard volume that the batch is reporting.

stime

char(25)

The time at which the batch was created. It is represented in a date/time format.

shipper

nameType(varchar(32))

The name of entity shipping the batch.

prodgroup

nameType(varchar(32))

The product group associated with the prodtype of the batch.

dens

float

The average density of the batch.

volUnit

nameType(varchar(15))

The unit used for volume.

densUnit

nameType(varchar(15))

The unit used for density.

ownSysId

tagIDType(int)

The ID number of the owning system of the batch.

datasetId

tagIDType(int)

The ID number associated with the dataset.

extension

NVARCHAR(MAX)

A field where extended batch inventory data from the extension plugin is stored in string format.

mass

float

The mass of the batch.

massUnit

varchar(15)

The unit used for mass.