MARIProject Database Structure

View Name:MARIContractCalculation
Based on table:MPContractCalculation
Group:
Description:Cotnract Sales Prices Calculation Method Head

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

INT Primary

ClassID ClassID

INT Primary

ClassID
Matchcode Matchcode

NVARCHAR (50) Index

IsActive IsActive

SMALLINT

CalculationFormular CalculationFormular

NTEXT

CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
CreateDate Erstanlage

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime

UpdateStamp UpdateStamp

INT


Linked by

Table Description
MARIItemGroupProperties Item Groups: Additional fields for maintenance and purchase order
MARIItemProperties Item Master: Additional fields for maintenance and purchase order
MARIPurchaseProcessPositions Purchase Process: PO Process Position (equivilant to contract position)
MARIContractPositions Contract Management: Contract positions (also service master positions)
MARIContractCalculationFields Cotnract Sales Prices Calculation Method Fields


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany