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