| Table Name: | MPSetupMandantSettingsMatrix |
| View Name: | MARISettingsCompanyMatrix |
| Group: | |
| Description: | Master Data: Settings by company in matrix |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Eigenschaft | Property INT Primary |
||
| Mandant | Company SMALLINT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| SpalteFuerMandant | ColumnForCompany SMALLINT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| GueltigAb | ValidFrom INT Primary |
MPPerioden.PeriodeJahr | |
| Bezeichnung | Description NVARCHAR (50) |
||
| WertTyp | ValueType SMALLINT |
||
| WertZahl | ValueNumber NUMERIC(19,6) |
||
| WertDatum | ValueDate Datetime |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| WertText | ValueText NTEXT |