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