MARIProject Database Structure

View Name:MARIContractDocumentPositionsBatches
Based on table:MPVKVertraegeBelegePositionenCharge
Group:Group: ContractDocument
Description:Contract Management: Document Positions Batches
ClassID: 537. See Overview of ClassIDs by table.

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

INT Primary

MARIDocPosID MPBelPosID

INT Index

MARIContractDocumentPositions.MARIDocPosID
MARIDocID MPBelID

INT Index

MARIContractDocument.MARIDocID
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)

MARIEquipmentMaster.EquipmentCode
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany