MARIProject Database Structure

View Name:MARIQualityStatus
Based on table:MPQualityStatus
Group:Group: QualityProcess
Description:QualityStatus: Type of statuses
ClassID: 214. See Overview of ClassIDs by table.

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

INT Primary

ClassID
QualityStatus QualityStatus

INT Primary

Matchcode Matchcode

NVARCHAR (50) Index

Indent Indent

INT

PositionID Position

INT Index

TreeType BlattTyp

SMALLINT

Inactive InAktiv

SMALLINT Index

Hide dataset
DocumentBlockMethod BelegSperrMethode

INT

Will this quality stop document creation
PictureID PictureID

INT

MARIPictures.PictureID
CreateDate Erstanlage

Datetime

CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MARIQualityProcess QualityProcess Definition
MARITempReportDocumentPos Reporting: Temporary Table: Document Positions
MARIWorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany