| Table Name: | MPPersonenProvisionsEinstellungen |
| View Name: | MARIEmployeesCommissionSettings |
| Group: | Group: EmployeeMaster |
| Description: | Employee Master: Standard Settings for Commission by Employee |
| ClassID: | 555. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| PersonenProvisionsEinstellungID | EmployeesCommissionSettingID INT Primary |
||
| Personalnummer | EmployeeNumber NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| Periode | Period INT Index |
MPPerioden.PeriodeJahr | |
| Einstellungstyp | SettingType INT Index |
||
| WertSys | ValueSys NUMERIC(19,6) |
||
| WertLocal | ValueLocal NUMERIC(19,6) |
||
| WertWKZ | ValueCurrency NVARCHAR (3) |
||
| Hinweis | Hint NVARCHAR (100) |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |