MARIProject Database Structure

Table Name:MPDocumentDraftPositionLinkSerial
View Name:MARIDocumentDraftPositionLinkSerial
Group:Group: DocumentDraftHead
Description:Used/reserved serial numbers
ClassID: 454. See Overview of ClassIDs by table.

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

INT Primary

DocumentDraftPosLinkID DocumentDraftPosLinkID

INT Index

MPDocumentDraftPositionLink.DocumentDraftPosLinkID
UseType UseType

INT

SysNumber SysNumber

INT

MnfSerial MnfSerial

NVARCHAR (36)

DistNumber DistNumber

NVARCHAR (36)

BatchID BatchID

NVARCHAR (36) Index

LotNumber LotNumber

NVARCHAR (36)

ExpDate ExpDate

Datetime

MnfDate MnfDate

Datetime

InDate InDate

Datetime

GrntStart GrntStart

Datetime

GrntExp GrntExp

Datetime

BinLocationAbsID BinLocationAbsID

INT Index

SourceBinLocationAbsID SourceBinLocationAbsID

INT Index

ContainerBinID ContainerBinID

INT Index

SourceContainerBinID SourceContainerBinID

INT Index

EquipmentCode EquipmentCode

NVARCHAR (20)

MPEquipment.EquipmentCode
MPInsID MPInsID

INT Index

MPCustomerEquipmentCard.MPinsID
BinLocationMode BinLocationMode

INT

FromBinLocationMode FromBinLocationMode

INT

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany