| Table Name: | MPSetupGeschaeftsbereich |
| View Name: | MARIBusinessUnitMaster |
| Group: | |
| Description: | Business Units: Master Data |
| ClassID: | 14. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| GeschaeftsbereichID | BusinessUnitID SMALLINT Primary |
||
| Geschaeftsbereich | BusinessUnit NVARCHAR (50) Index |
||
| KHKMandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Kostenstelle | OcrCode1 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 | |
| Reihenfolge | LineOrder INT |
||
| GruppenID | CompanyGroup1 INT Index |
MPGruppen.GruppenID (WHERE GruppenArt=10010) clsImportGroups_eGroupType |
|
| GruppenID2 | CompanyGroup2 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10011) clsImportGroups_eGroupType |
|
| GruppenID3 | CompanyGroup3 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10012) clsImportGroups_eGroupType |
|
| PictureIcon | PictureIcon INT |
MPBilder.BildID | |
| PictureWeb | PictureWeb INT |
MPBilder.BildID | |
| InAktiv | Inactive SMALLINT (0=false,-1=true) Index |
Hide dataset | |
| LocationID | LocationID INT |
MPLocation.LocationID | |
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPAuswertungGeschaeftsbereiche | Plannings Simulator: Dimension Business Unit |
| MPAuswertungGruppen | Plannings Simulator: Dimension Groups |
| MPAuswertungKopf | Plannings Simulator: Header |
| MPAuswertungProjekte | Plannings Simulator: Dimension Projects |
| MPAuswertungRessourcen | Plannings Simulator: Dimension Resources |
| MPBenutzerGeschaeftsbereiche | ProjectManagement User Athorization to Business Units |
| MPChefInfoAuswertungenMA | Info Screen Management: Export Employees |
| MPChefInfoAuswertungenPool | Info Screen Management: Export Pools |
| MPChefInfoAuswertungenProjekt | Info Screen Management: Export Projects |
| MPDBCollection | Info Screen Management: Breakeven Analysis (Export Header) |
| MPEquipmentCategorySubjectRates | EquipmentCategory: Standard cost and sales prices for the cost types of categories |
| MPEquipmentDetails | Equipment: Master Data "date from" based |
| MPEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MPEquipmentSubjectRatesBU | Equipment: Specific cost and sales rates for internal service charges |
| MPFibuPositionenBeleg | Journal Entries Export Document Head |
| MPGruppen | Groups used for a long list of master data. See the GruppenArt enumeration |
| MPGruppenEquipment | Groups for Equipment and EquipmentCategories |
| MPHotlineGruppe | Support Module: Support Group: Header |
| MPPersonenOrganisation | Employee Master: One line per regular employee and valid from period, several lines for freelancer employees, per valid from period |
| MPPersonenVerrechnung | Employee Master: Cost Rates |
| MPProjektBuchungserfassung | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MPProjektGruppen | Project Master: Project Groups |
| MPProjektstamm | Project Master: Master Data |
| MPRessourcenGPTeamKostensaetze | Cost rates for external resource team |
| MPRessourcenPool | Resource Pool: Master Data |
| MPRessourcenPoolKostensaetze | Resource Pool: Cost Rates |
| MPSetupGBSettings | Master Data: Settings by business unit |
| MPSetupGBSettingsBuchungsVariante | Internal Service Changes: Setting of type BU vs. BU |
| MPSetupGBSettingsMatrix | Master Data: Settings by business unit in matrix |
| MPSysUserGroups | SDK: User-Defined Tables: Groups in UDT |
| MPTan | System: Transaction Table to handle the unique IDs of all data (master data and tasks) |
| MPTmpRptKalender | Reporting: Temporary Table: Calendar |