MARIProject Database Structure

Table Name:MPEKVertraegeBelegePositionenCharge
View Name:MARIPurchaseProcessDocumentPositionsBatches
Group:Group: MPEKVertraegeBelege
Description:Purchase Process: Purchase Document (Positions+Batches)
ClassID: 535. See Overview of ClassIDs by table.

Field View(engl.field)/Type Description Related
MPBelPosChargeID DocPosSeriesID

INT Primary

MPBelPosID DocPosID

INT Index

MPEKVertraegeBelegePositionen.MPBelPosID
MPBelID MARIDocID

INT Index

MPEKVertraegeBelegePositionen.MPBelID
MPChargeID MPBatchID

INT Index

MPChargennummern.MPChargeID
AbsEntry AbsEntry

INT

OBTN.AbsEntry
SysNumber SysNumber

INT

OBTN.AbsEntry
DistNumber DistNumber

NVARCHAR (36)

OBTN.SysNumber
MnfSerial MnfSerial

NVARCHAR (36)

OBTN.MnfSerial
LotNumber LotNumber

NVARCHAR (36)

OBTN.LotNumber
Quantity Quantity

NUMERIC(19,6)

OBTN.Quantity
ExpDate ExpDate

Datetime

OBTN.ExpDate
MnfDate MnfDate

Datetime

OBTN.MnfDate
InDate InDate

Datetime

OBTN.InDate
GrntStart GrntStart

Datetime

OBTN.GrntStart
GrntExp GrntExp

Datetime

OBTN.GrntExp
Notes Notes

NTEXT

OBTN.Notes
BinLocations BinLocations

NTEXT

ContainerBins ContainerBins

NTEXT

FromBinLocations FromBinLocations

NTEXT

FromContainerBins FromContainerBins

NTEXT

EquipmentCode EquipmentCode

NVARCHAR (20)

MPEquipment.EquipmentCode
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 81
© by MARINGO Computers GmbH, Cologne Germany