| Table Name: | MPProjektPlanungRessourcen |
| View Name: | MARIProjectPlanningResource |
| Group: | Group: ProjectMaster |
| Description: | Planning: Filter list for plannable resources (ex. G/L Accounts) |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ProjektPlannungsRessourcenID | ProjectPlanResourceID INT Primary |
||
| Projektnummer | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| RessourcenTyp | ResourceType SMALLINT Primary |
||
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| Mandant | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| AnsprechpartnerID | ContactPerson INT Index |
OCPR.CntctCode | |
| RessourceCode | ResourceCode NVARCHAR (20) |
||
| Matchcode | Matchcode NVARCHAR (100) Index |
||
| KalenderID | CalendarID INT Index |
MPKalender.KalenderID | |
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |