MARIProject Database Structure

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

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

INT Primary

ContractPosServicePosType ContractPosServicePosType

INT

ContractID ContractID

INT Index

MARIPurchaseProcess.ContractID
ContractPosition ContractPosition

INT Index

MARIPurchaseProcessPositions.ContractPosition
WorkItemPosID WorkItemPosID

INT Index

MARIWorkItemPosition.WorkItemPosID
CustomerServiceObjectID CustomerServiceObjectID

INT Index

MARICustomerServiceObject.CustomerServiceObjectID
EquipmentCode EquipmentCode

NVARCHAR (20) Index

MARIEquipmentMaster.EquipmentCode
Quantity Quantity

NUMERIC(19,6)

Option1 Option1

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany