Rockwell-automation FactoryTalk Historian Classic for Batch User Guide Manual de usuario descargar pdf (Pagina 32)

Chapter 3 Collecting Batch Data

Field Name Data Type Description Example

Printed

Date/Time

Last date the batch report was printed

2013-04-29 14:52:07.000

UserID

Text

Computer name/Windows user name

mjames1

PhaseDesc

Text

Phase class description

MaterialName

Text

Common name of the material

YELLOWPAINT

MaterialID Text

Inventory control system material ID used to track

the material

LotName

Text

Name assigned to a lot of material

TEST317_BRAND

Label

Text

ID assigned to a distributed portion of a lot

STANDARDBRANDYELLOW

Container Text

Container's name where material and lot were

distributed, or where material and lot are stored

WAREHOUSE2/PAINT_PALLET1

PromiseID Text

Unique ID used as a key to allow grouping of

separate event entries all resulting from a single

material addition

100

Signature Text

Used for event journal signatures by Batchsig

program to detect changes in .evt file.

Information stored here is a hexadecimal or a

single spaced character.

ERP_Flag

Text

Tag indicating information reported to SAP

RecordNo integer

Unique identifier assigned to the record when it is

added to the database

ArchivedGMT date/time

Time in Universal Coordinated Time when event

was archived to the database

2002-08-15 18:36:06.500

Reactivation

Number

integer

Number of times an active eProcedure control

step has been reactivated

Instruction

HTML

ntext HTML for completed eProcedure instruction steps

<FORM> Add a CIP Batch to the

Batch List. Click "OK" when

done. </FORM>

SQL Server columns that have a field type of `ntext' only retrieve 256 characters of data at a time using a standard SELECT statement. To

retrieve all the data use the READTEXT function. See How To Display All Instruction HTML Data From an SQL Database (page 33) for more

information.

SignatureID integer

A 32-bit unsigned integer that uniquely identifies

a Signature Request within the batch system.

ActionID integer

A 32-bit unsigned integer that uniquely identifies

an Action within the batch system. An Action is a

queued Execute command to the Batch Server

that is pending one or more Signature

completions prior to being performed.

32 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014

1 2 ... 27 28 29 30 31 32 33 34 35 36 37 ... 73 74

Comentarios a estos manuales

Sin comentarios

Rockwell-automation FactoryTalk Historian Classic for Batch User Guide Manual de usuario Pagina 32

Comentarios a estos manuales

Relacionado con productos y manuales para Equipo Rockwell-automation FactoryTalk Historian Classic for Batch User Guide