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
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

ContainerBins ContainerBins

NTEXT

FromBinLocations FromBinLocations

NTEXT

FromContainerBins FromContainerBins

NTEXT

EquipmentCode EquipmentCode

NVARCHAR (20)

MPEquipment.EquipmentCode
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany