| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BKKRS | Bank Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | MIN_DEPOSITTERM | Minimum Term | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | MIN_DEPOSITUNIT | Period Unit for Term | char | 1 | 0 | | | | Allow NULL? |
| 6 | MAX_DEPOSITTERM | Maximum Term | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | MAX_DEPOSITUNIT | Period Unit for Term | char | 1 | 0 | | | | Allow NULL? |
| 8 | DEPOSIT_TCUR | Account Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | MAX_DEPOSIT | Contract Total, Deposit | decimal | 17 | 2 | | | | |
| 10 | X_FIXTERM | Indicator: Fixed Term | char | 1 | 0 | | | | Allow NULL? |
| 11 | X_TDSTART_INP | Term Start for Each Entry | char | 1 | 0 | | | | Allow NULL? |
| 12 | ROLLOV_NUMBER | Number of Required Rollovers | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | ROLLOVER_TYPE | Action at Term End (Repayment or Rollover) | char | 1 | 0 | | | | Allow NULL? |
| 14 | ORIGIN_TERM | Original Term | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | ORIGIN_TERMUNIT | Period Unit for Term | char | 1 | 0 | | | | Allow NULL? |
| 16 | ACCOUNT_CLOSURE | Update Account Closure Date with End of Term Date | char | 1 | 0 | | | | Allow NULL? |
| 17 | X_PRINT_PRENOT | Prenotification of Term Agreement Maturity | char | 1 | 0 | | | | Allow NULL? |
| 18 | NUM_DAYS_BEFORE | Number of Days Before Maturity | decimal | 3 | 0 | | | | |
| 19 | X_PRINT_REDEEM | Correspondence on Calling Term Agreement | char | 1 | 0 | | | | Allow NULL? |
| 20 | X_PRINT_CERTIF | Correspondence on Fixing Term Agreement | char | 1 | 0 | | | | Allow NULL? |
| 21 | CRUSR | User who created the object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 22 | CRDAT | Date on which the object was created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | CRTIME | Time at which the object was created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 24 | CHUSR | Last user to change object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | CHDAT | Date on which the object was last changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | CHTIME | Time at Which Object was Last Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
