| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TRKORR | Request/Task | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | ADDRNUMBER | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | PERSNUMBER | Person number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | DATE_FROM | Valid-from date - in current Release only 00010101 possible | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | CONSNUMBER | Sequence Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | FLGDEFAULT | Flag: this name is the default name | char | 1 | 0 | | | | Allow NULL? |
| 8 | FLG_NOUSE | Flag: This Communication Number is Not Used | char | 1 | 0 | | | | Allow NULL? |
| 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | char | 1 | 0 | | | | Allow NULL? |
| 10 | SYMB_DEST | Symbolic destination | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | RECVR_TYPE | Recipient type (not currently used) | char | 1 | 0 | | | | Allow NULL? |
| 12 | UMAND | RML- Client (Remote Mail, SAP - SAP - Communication) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | UNAME | RML Name (Remote Mail, SAP - SAP - Communication) | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | DFT_RECEIV | Flag: Recipient is the standard recipient for this name | char | 1 | 0 | | | | Allow NULL? |
| 15 | R3_USER | Flag: Connected to an SAP System | char | 1 | 0 | | | | Allow NULL? |
| 16 | VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 17 | VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | | | Allow NULL? |