| 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 | XDELE | Account Closure Flag | char | 1 | 0 | | | | Allow NULL? |
| 5 | SEARCH1 | Search term 1 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 6 | SEARCH2 | Search term 2 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | ERFUSER | User Who Created Current Account | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | ERFDATE | Date on Which Current Account Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | ERFTIME | Time at Which Current Account Was Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | AENUSER | Last changed by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | AENDATE | Date on Which BCA Account was Last Changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | AENTIME | Time at Which Current Account was Last Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | STATUS | Account Status | char | 1 | 0 | | | | Allow NULL? |
| 14 | XPRINT | Print Correspondence | char | 1 | 0 | | | | Allow NULL? |
| 15 | DELDATE | Date Account Closed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | PRODDATE | Account Go-Live Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | BALDATE | Date of Balance Transfer | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | STATUS_ADD | Account Status Enhancement | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | XOFFER | Indicator: Create Account as Offer | char | 1 | 0 | | | | Allow NULL? |
| 20 | XCHKDIG | Indicator: No Check Digit Calculation | char | 1 | 0 | | | | Allow NULL? |
| 21 | OPENDATE | Date Account Opened | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | PLANNED_CL_DATE | Planned Account Closure Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | CLOSURE_REASON | Reason Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | CLS_REA_CLASS | Reason Class | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | PRENOT_CLOSURE | Prenotification for Account Closure | char | 1 | 0 | | | | Allow NULL? |
| 26 | PRENOT_DAYS | No. of Days for Acct Closure Prenotification Correspondence | decimal | 3 | 0 | | | | |
| 27 | PRENOT_PRINTED | Closure Prenotification Correspondence Generated Successfull | char | 1 | 0 | | | | Allow NULL? |
| 28 | CLOSURE_CORR | Account Closure Correspondence | char | 1 | 0 | | | | Allow NULL? |
| 29 | REACN_DATE | Reactivation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | REACN_REASON | Reason Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | REACN_REA_CLASS | Reason Class | nvarchar | 2 | 0 | | | | Allow NULL? |
| 32 | ROOT_ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | XARCH | Central Archiving Indicator | char | 1 | 0 | | | | Allow NULL? |
