MARIProject Database Structure

Table Name:MPVKVertraegePos2Service
View Name:MARIContractPosition2Service
Group:Group: Contract
Description:Contract Management: Contract position to Customer Service Object and parts

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

INT Primary

ContractPosServicePosType ContractPosServicePosType

INT

ContractID ContractID

INT Index

MPVKVertraege.VertragsID
ContractPosition ContractPosition

INT Index

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