| Table Name: | MPLohnZeile |
| View Name: | MARIPayrollLine |
| Group: | Group: PayrollTypes |
| Description: | Payroll Interface: Export Lines |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ZeilenID | LineID INT Primary |
||
| Stapel | Batch INT Index |
MPLohnStapel.Stapel | |
| ZeilenTyp | LineCategory INT |
||
| BuchungsID | EntryID INT Index |
||
| Personalnummer | EmployeeNumber NVARCHAR (50) Index |
MPPersonenstamm.Personalnummer | |
| PersonalnummerLohn | EmployeeNoInHR NVARCHAR (50) |
||
| Periode | Period INT |
MPPerioden.PeriodeJahr | |
| Lohnart | PayrollType NVARCHAR (20) |
MPLohnArten.LohnArt | |
| Text | Text NVARCHAR (50) |
||
| 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) | |
| Kostentraeger | ProjectCode NVARCHAR (20) |
OPRJ.PrjCode | |
| Betrag | Amount NUMERIC(19,6) |
||
| Stunden | Hours NUMERIC(19,6) |
||
| Prozent | PercentValue NUMERIC(19,6) |
||
| LeistungsTag | ServiceDate Datetime |
||
| Gesamt | TotalValue NUMERIC(19,6) |
||
| KontextInfo | ContextInfo NVARCHAR (50) |
||
| Status | Status SMALLINT |
||
| HRZeilenId | ReferenceToHRLine INT Index |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPLohnZeileAnhang | Payroll Interface: Export Lines Source Details |