MARIProject Database Structure

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

Field Table(Germ.field)/Type Description Related
DocumentDraftPosLinkBatchID DocumentDraftPosLinkBatchID

INT Primary

DocumentDraftPosLinkID DocumentDraftPosLinkID

INT Index

MARIDocumentDraftPositionLink.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)

MARIEquipmentMaster.EquipmentCode
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany