| View Name: | MARIEmployeesOrganisation |
| Based on table: | MPPersonenOrganisation |
| 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 | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| EmployeeNumber | Personalnummer NVARCHAR (20) Primary |
Link to employee | MARIEmployeeMaster.EmployeeNumber |
| BusinessUnitID | Geschaeftsbereich SMALLINT Primary |
Business Unit | MARIBusinessUnitMaster.BusinessUnitID |
| ValidFrom | GueltigAb INT Primary |
Period valid from | MARIPeriods.ValidFrom |
| OcrCode1 | Kostenstelle 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) | |
| ProjectCode | Kostentraeger NVARCHAR (20) |
Project Code in SBO | OPRJ.PrjCode |
| Creditor | Kreditor NVARCHAR (20) |
Travel Expense supplier equivilant for the employee | OCRD.CardCode |
| CorpCreditCardCreditor | KreditorKreditkarte NVARCHAR (20) |
Travel Expense supplier equivilant for the company credit card | OCRD.CardCode |
| CorpCreditCardCreditor2 | KreditorKreditkarte2 NVARCHAR (20) |
||
| CorpCreditCardCreditor3 | KreditorKreditkarte3 NVARCHAR (20) |
||
| Debitor | Debitor NVARCHAR (20) |
||
| EmployeeSuperior | Verantwortlicher NVARCHAR (20) |
Superior | MARIEmployeeMaster.EmployeeSuperior |
| EmployeeSuperior2 | VerantwortlicherVertreter NVARCHAR (20) |
Second Superior | MARIEmployeeMaster.EmployeeSuperior2 |
| MainBusinessUnit | HauptGeschaeftsbereich SMALLINT |
Main Business Unit for free lancers | |
| ERPEmployee | MitarbeiterVerweis INT |
Link to employees in SBO | OHEM.EmplID |
| CreditCardInfo1 | KreditkarteInfo1 NVARCHAR (50) |
||
| CreditCardInfo2 | KreditkarteInfo2 NVARCHAR (50) |
||
| CreditCardInfo3 | KreditkarteInfo3 NVARCHAR (50) |
||
| CreditCardName1 | KreditkarteName1 NVARCHAR (50) |
||
| CreditCardName2 | KreditkarteName2 NVARCHAR (50) |
||
| CreditCardName3 | KreditkarteName3 NVARCHAR (50) |
||
| CommissionTypeID | CommissionTypeID INT |
MARICommissionTypes.CommissionTypeID | |
| UpdateStamp | UpdateStamp INT |