| View Name: | MARIProjectGroups |
| Based on table: | MPProjektGruppen |
| Group: | Group: ProjectMaster |
| Description: | Project Master: Project Groups |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| GroupType | GruppenArt SMALLINT Primary |
clsImportGroups_eGroupType | |
| GroupID | GruppenID INT Primary |
||
| Indent | Indent INT |
||
| Parent | Parent INT |
||
| TreeType | BlattTyp SMALLINT |
||
| PositionID | Position SMALLINT Index |
||
| BusinessUnitID | Geschaeftsbereich SMALLINT |
not used | MARIBusinessUnitMaster.BusinessUnitID |
| Description | Bezeichnung NVARCHAR (40) |
||
| GroupMemo | GruppenMemo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| 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 |
|---|---|
| MARIProjectMaster | Project Master: Master Data |