| Table Name: | MPPersonenOrganisation |
| View Name: | MARIEmployeesOrganisation |
| Group: | Group: EmployeeMaster |
| Description: | Employee Master: One line per regular employee and valid from period, several lines for freelancer employees, per valid from period |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Personalnummer | EmployeeNumber NVARCHAR (20) Primary |
Link to employee | MPPersonenstamm.Personalnummer |
| Geschaeftsbereich | BusinessUnitID SMALLINT Primary |
Business Unit | MPSetupGeschaeftsbereich.GeschaeftsbereichID |
| GueltigAb | ValidFrom INT Primary |
Period valid from | MPPerioden.PeriodeJahr |
| Kostenstelle | OcrCode1 NVARCHAR (20) |
ProfitCenter in SBO | 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) | |
| Kostentraeger | ProjectCode NVARCHAR (20) |
Project Code in SBO | OPRJ.PrjCode |
| Kreditor | Creditor NVARCHAR (20) |
Travel Expense supplier equivilant for the employee | OCRD.CardCode |
| KreditorKreditkarte | CorpCreditCardCreditor NVARCHAR (20) |
Travel Expense supplier equivilant for the company credit card | OCRD.CardCode |
| KreditorKreditkarte2 | CorpCreditCardCreditor2 NVARCHAR (20) |
||
| KreditorKreditkarte3 | CorpCreditCardCreditor3 NVARCHAR (20) |
||
| Debitor | Debitor NVARCHAR (20) |
||
| Verantwortlicher | EmployeeSuperior NVARCHAR (20) |
Superior | MPPersonenstamm.Personalnummer |
| VerantwortlicherVertreter | EmployeeSuperior2 NVARCHAR (20) |
Second Superior | MPPersonenstamm.Personalnummer |
| HauptGeschaeftsbereich | MainBusinessUnit SMALLINT |
Main Business Unit for free lancers | |
| MitarbeiterVerweis | ERPEmployee INT |
Link to employees in SBO | OHEM.EmplID |
| KreditkarteInfo1 | CreditCardInfo1 NVARCHAR (50) |
||
| KreditkarteInfo2 | CreditCardInfo2 NVARCHAR (50) |
||
| KreditkarteInfo3 | CreditCardInfo3 NVARCHAR (50) |
||
| KreditkarteName1 | CreditCardName1 NVARCHAR (50) |
||
| KreditkarteName2 | CreditCardName2 NVARCHAR (50) |
||
| KreditkarteName3 | CreditCardName3 NVARCHAR (50) |
||
| CommissionTypeID | CommissionTypeID INT |
MPCommissionTypes.CommissionTypeID | |
| UpdateStamp | UpdateStamp INT |