| 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 | CERT_NO | BCA Time deposit certificate number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | TERM_TYPE | Term Agreement Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | TERM_STATUS | Term Agreement Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | TERM | Term Duration | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | TERM_PUNIT | Period Unit for Term | char | 1 | 0 | | | | Allow NULL? |
| 9 | X_CURRENT | BCA Time deposit current certificate indicator | char | 1 | 0 | | | | Allow NULL? |
| 10 | K_DATE | Key date | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | DEPOSIT | Contract Total, Deposit | decimal | 17 | 2 | | | | |
| 12 | TERMSTART | Term Start | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | LATEST_TERMSTART | Term Start | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | TERM_END | End of Term | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | X_EINZUG | Fixed Term Deposit Was Collected | char | 1 | 0 | | | | Allow NULL? |
| 16 | MATURITY_DATE | Maturity Date of Term Agreement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | REDUCTION | Amount | decimal | 17 | 2 | | | | |
| 18 | INCREASE | Amount | decimal | 17 | 2 | | | | |
| 19 | COLLECTION_DATE | Collection date of term initial amount | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | PAYMENTORDER_NO | Payment order number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | X_ROLLOVER | Flag indicating if Term Agreement is Rollover | char | 1 | 0 | | | | Allow NULL? |
| 22 | X_PRENOT_PRINTED | Flag indicating if Prenotification document was printed | char | 1 | 0 | | | | Allow NULL? |
| 23 | X_CORRECTION | Flag indicating if Term Agreement has been corrected | char | 1 | 0 | | | | Allow NULL? |
| 24 | FIXING_DATE | Condition Fixing Date for Fixed-Term Deposit Account | nvarchar | 8 | 0 | | | | Allow NULL? |