MARIProject Database Structure

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

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

INT Primary

ContractPosServicePosType ContractPosServicePosType

INT

ContractID ContractID

INT Index

MARIContract.ContractID
ContractPosition ContractPosition

INT Index

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