| Table Name: | MPEquipmentCategorySubject |
| View Name: | MARIEquipmentCategorySubject |
| Group: | Group: EquipmentCategory |
| Description: | EquipmentCategory: Standard cost types for categories |
| ClassID: | 224. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| EquipmentSubject | EquipmentSubject NVARCHAR (20) Primary |
||
| EquipmentCategory | EquipmentCategory INT Index |
MPEquipmentCategory.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) |
MPLeistung.Leistungsnummer | |
| 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) |
MPReise2KostenArten.Reisekostenart | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPDocumentDraftPosition | Positions based on the order of the paper document |
| MPDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MPEKVertraegePositionen | Purchase Process: PO Process Position (equivilant to contract position) |
| MPEquipmentCategorySubjectRates | EquipmentCategory: Standard cost and sales prices for the cost types of categories |
| MPEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MPEquipmentSubjectRates | Equipment: Specific cost rates |
| MPEquipmentSubjectRatesBU | Equipment: Specific cost and sales rates for internal service charges |
| MPReise2ZeileProjekt | Travel Expenses Module: Trip receipt project line for invoice |
| MPVKVertraegePositionen | Contract Management: Contract positions (also service master positions) |
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |