| View Name: | MARIBusinessUnitMaster |
| Based on table: | MPSetupGeschaeftsbereich |
| Group: | |
| Description: | Business Units: Master Data |
| ClassID: | 14. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| BusinessUnitID | GeschaeftsbereichID SMALLINT Primary |
||
| BusinessUnit | Geschaeftsbereich NVARCHAR (50) Index |
||
| Company | KHKMandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| OcrCode1 | Kostenstelle NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=1) | |
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=3) | |
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| BPLId | BPLId INT |
OINF.BPLId | |
| LineOrder | Reihenfolge INT |
||
| CompanyGroup1 | GruppenID INT Index |
MARIGroups.CompanyGroup1 (WHERE GruppenArt=10010) clsImportGroups_eGroupType |
|
| CompanyGroup2 | GruppenID2 INT |
MARIGroups.CompanyGroup2 (WHERE GruppenArt=10011) clsImportGroups_eGroupType |
|
| CompanyGroup3 | GruppenID3 INT |
MARIGroups.CompanyGroup3 (WHERE GruppenArt=10012) clsImportGroups_eGroupType |
|
| PictureIcon | PictureIcon INT |
MARIPictures.PictureIcon | |
| PictureWeb | PictureWeb INT |
MARIPictures.PictureWeb | |
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
Hide dataset | |
| LocationID | LocationID INT |
MARILocation.LocationID | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIInfoSimulationBusinessUnits | Plannings Simulator: Dimension Business Unit |
| MARIInfoSimulationGroups | Plannings Simulator: Dimension Groups |
| MARIInfoSimulationHead | Plannings Simulator: Header |
| MARIInfoSimulationProjects | Plannings Simulator: Dimension Projects |
| MARIInfoSimulationResources | Plannings Simulator: Dimension Resources |
| MARIUserBusinessUnits | ProjectManagement User Athorization to Business Units |
| MARIInfoScreenManagementEmployee | Info Screen Management: Export Employees |
| MARIInfoScreenManagementPool | Info Screen Management: Export Pools |
| MARIInfoScreenManagementProject | Info Screen Management: Export Projects |
| MARIInfoScreenManagementBreakEvenCollection | Info Screen Management: Breakeven Analysis (Export Header) |
| MARIGroups | Groups used for a long list of master data. See the GruppenArt enumeration |
| MARISupportGroup | Support Module: Support Group: Header |
| MARIEmployeesOrganisation | Employee Master: One line per regular employee and valid from period, several lines for freelancer employees, per valid from period |
| MARIEmployeeCostRates | Employee Master: Cost Rates |
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MARIProjectGroups | Project Master: Project Groups |
| MARIProjectMaster | Project Master: Master Data |
| MARIResourcePool | Resource Pool: Master Data |
| MARIResourcePoolCostRates | Resource Pool: Cost Rates |
| MARISettingsBusinessUnit | Master Data: Settings by business unit |
| MARISettingsBusinessUnitAccountingVersion | Internal Service Changes: Setting of type BU vs. BU |
| MARISettingsBusinessUnitMatrix | Master Data: Settings by business unit in matrix |
| MARISysUserGroups | SDK: User-Defined Tables: Groups in UDT |
| MARITransactionID | System: Transaction Table to handle the unique IDs of all data (master data and tasks) |
| MARITempReportCalendar | Reporting: Temporary Table: Calendar |
| MARIEquipmentCategorySubjectRates | EquipmentCategory: Standard cost and sales prices for the cost types of categories |
| MARIEquipmentDetails | Equipment: Master Data "date from" based |
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MARIEquipmentSubjectRatesBU | Equipment: Specific cost and sales rates for internal service charges |
| MARIGroupsEquipment | Groups for Equipment and EquipmentCategories |
| MARIJournalEntryExportDocument | Journal Entries Export Document Head |
| MARIResourcePoolBPTeamCostRates | Cost rates for external resource team |