| View Name: | MARIPayrollStack |
| Based on table: | MPLohnStapel |
| Group: | Group: PayrollTypes |
| Description: | Payroll Interface: Export Header |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| Batch | Stapel INT Primary |
||
| Period | Periode INT Index |
MARIPeriods.Period | |
| DateFrom | DatumVon Datetime |
||
| DateTo | DatumBis Datetime |
||
| Description | Bezeichnung NVARCHAR (50) |
||
| PayRollStack | HRStapel INT |
||
| PostingDate | Buchungsdatum Datetime |
||
| Validated | Validiert SMALLINT (0=false,-1=true) |
||
| SessionType | Sitzungstyp INT |
||
| Company | Mandant INT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| ExportInformation | ExportInfo NVARCHAR (255) |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPayrollLine | Payroll Interface: Export Lines |
| MARIAttendanceRuleDays | Attandence: Actions "in the door" (Day header) |