MARIProject Database Structure

Table Name:MPDocumentDraftPositionLinkBatch
View Name:MARIDocumentDraftPositionLinkBatch
Group:Group: DocumentDraftHead
Description:Used batches
ClassID: 453. See Overview of ClassIDs by table.

Field View(engl.field)/Type Description Related
DocumentDraftPosLinkBatchID DocumentDraftPosLinkBatchID

INT Primary

DocumentDraftPosLinkID DocumentDraftPosLinkID

INT Index

MPDocumentDraftPositionLink.DocumentDraftPosLinkID
UseType UseType

INT

SysNumber SysNumber

INT

DistNumber DistNumber

NVARCHAR (36)

MnfSerial MnfSerial

NVARCHAR (36)

LotNumber LotNumber

NVARCHAR (36)

Quantity Quantity

NUMERIC(19,6)

ExpDate ExpDate

Datetime

MnfDate MnfDate

Datetime

InDate InDate

Datetime

GrntStart GrntStart

Datetime

GrntExp GrntExp

Datetime

BinLocations BinLocations

NTEXT

SourceBinLocations SourceBinLocations

NTEXT

ContainerBins ContainerBins

NTEXT

SourceContainerBins SourceContainerBins

NTEXT

EquipmentCode EquipmentCode

NVARCHAR (20)

MPEquipment.EquipmentCode
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany