| View Name: | MARIPayrollTypes |
| Based on table: | MPLohnArten |
| Group: | Group: PayrollTypes |
| Description: | Payroll Interface: Payroll Types Master Data by company |
| ClassID: | 104. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PayrollType | LohnArt NVARCHAR (20) Primary |
||
| Company | Mandant SMALLINT Primary |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| Description | Bezeichnung NVARCHAR (50) Index |
||
| Reference | Hinweis NVARCHAR (255) |
||
| AccountingMethod | AbrechnungsMode INT |
||
| ExportKey | ExportSchluessel NVARCHAR (50) |
||
| ExportKey2 | ExportSchluessel2 NVARCHAR (50) |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | LohnMemo NTEXT |
||
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
Hide dataset | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPurchaseProcessPositions | Purchase Process: PO Process Position (equivilant to contract position) |
| MARIPayrollLine | Payroll Interface: Export Lines |
| MARIAttendanceRuleShifts | Attendance: Working Time rules (Night shift additionals) |
| MARITravelExpenseTypesAccounts | Travel Expenses Module: Travel Expenses Types Company G/L Account Link |
| MARIContractPositions | Contract Management: Contract positions (also service master positions) |
| MARICommissionTypes | Commission: Basic Settings for different Types |
| MARIPayrollTypeGroupLink | Payroll Interface: Payroll Types Link |
| MARIProjectTimeKeepingLinesAddOnCategory | Time Keeping: AddOnCategoryDetails |