| Table Name: | MPNummernPool |
| View Name: | MARINumberPool |
| Group: | Group: Contract |
| Description: | Work Items: Number Pool |
| ClassID: | 13. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| NummernID | NumberID INT Primary |
||
| NummernText | NumberText NVARCHAR (50) Index |
||
| VerweisTyp | LinkType SMALLINT |
||
| Verweis | Reference NVARCHAR (50) Index |
||
| VerweisGB | ReferenceBU SMALLINT |
||
| Angewendet | Used SMALLINT |
||
| Erstanlage | CreateDate Datetime |
||
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |