MARIProject Database Structure

View Name:MARIEquipmentCategorySubject
Based on table:MPEquipmentCategorySubject
Group:Group: EquipmentCategory
Description:EquipmentCategory: Standard cost types for categories
ClassID: 224. See Overview of ClassIDs by table.

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

NVARCHAR (20) Primary

EquipmentCategory EquipmentCategory

INT Index

MARIEquipmentCategory.EquipmentCategory
SubjectName SubjectName

NVARCHAR (50) Index

Unit Unit

NVARCHAR (20)

UnitHandling UnitHandling

INT

clsImportEquipmentCategorySubject_eUnitHandling
CounterUnit CounterUnit

NVARCHAR (20)

CounterHandling CounterHandling

INT

CounterSource CounterSource

INT

DefaultCostMode DefaultCostMode

INT

clsImportEquipmentCategorySubject_eCostMode
DefaultService DefaultService

NVARCHAR (20)

MARIServices.DefaultService
TimeBookingMode TimeBookingMode

INT

ISCMode ISCMode

INT

ISCVariant ISCVariant

INT

Description1 Description1

NVARCHAR (200)

Description2 Description2

NVARCHAR (200)

Description3 Description3

NTEXT

Description4 Description4

NTEXT

TravelExpenseCategory TravelExpenseCategory

NVARCHAR (20)

MARITravelExpenseTypes.TravelExpenseCategory
CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MARIPurchaseProcessPositions Purchase Process: PO Process Position (equivilant to contract position)
MARITravelTripLineProject Travel Expenses Module: Trip receipt project line for invoice
MARIContractPositions Contract Management: Contract positions (also service master positions)
MARIEquipmentCategorySubjectRates EquipmentCategory: Standard cost and sales prices for the cost types of categories
MARIEquipmentSubjectBooking Time/Costbooking on Equipment data
MARIEquipmentSubjectRates Equipment: Specific cost rates
MARIEquipmentSubjectRatesBU Equipment: Specific cost and sales rates for internal service charges
MARIDocumentDraftPosition Positions based on the order of the paper document
MARIDocumentDraftPositionLink Linked positions in the sales contract and or purchase process
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