| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | INTRENO | Internal Key of Real Estate Object | nvarchar | 13 | 0 | | | | Allow NULL? |
| 3 | TERMTYPE | Term Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | TERMNO | Term Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | RNRULETYPE | Type of Renewal Rule | char | 1 | 0 | | | | Allow NULL? |
| 6 | RNRULENO | Sequence Number of Extension Period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | RNEXTCOUNT | Number of Renewals | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | RNEXTYEARS | Contract Renewed for Number of Years | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | RNEXTMONTHS | Contract Renewed for Number of Months | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | RNEXTDAYS | Contract Renewed for Number of Days | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | RNEXTROUND | Rounding Rule for Determined Renewal Date | char | 1 | 0 | | | | Allow NULL? |
| 12 | RNNOTYEARS | Notification Must Be This No. of Years before Renewal Date | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | RNNOTMONTHS | Notification Must Be This No. of Months before Renewal Date | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | RNNOTWEEKS | Notification Must Be This No. of Weeks before Renewal Date | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | RNNOTDAYS | Notification Must Be This No. of Days before Renewal Date | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | RNNOTROUND | Rounding Rule for Determined Notification Date | char | 1 | 0 | | | | Allow NULL? |