| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | USERID | User Name in User Master Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | NEWS_LETTER | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 4 | FAX | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 5 | PHONE | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 6 | EMAIL | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
| 7 | SHOW_RECOMMANDTN | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | | | | Allow NULL? |
