MARIProject Database Structure

Table Name:MPEKVertraegePos2Service
View Name:MARIPurchaseProcessPos2Service
Group:Group: MPEKVertraege
Description:Purchase Process: Link Position to Customer Service Object or parts

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

INT Primary

ContractPosServicePosType ContractPosServicePosType

INT

ContractID ContractID

INT Index

MPEKVertraege.VertragsID
ContractPosition ContractPosition

INT Index

MPEKVertraegePositionen.Vertragsposition
WorkItemPosID WorkItemPosID

INT Index

MPWorkItemPosition.WorkItemPosID
CustomerServiceObjectID CustomerServiceObjectID

INT Index

MPCustomerEquipmentCard.MPinsID
EquipmentCode EquipmentCode

NVARCHAR (20) Index

MPEquipment.EquipmentCode
Quantity Quantity

NUMERIC(19,6)

Option1 Option1

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany