| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TREENR | Bank Account Relationship Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | BKK_RELNR | Allow NULL? |
| 3 | DATE_FROM | Valid from date | nvarchar | 8 | 0 | CHAR | (N' ') | No | | BKK_VF_INV | Allow NULL? |
| 4 | DATE_TO | Validity Date (Valid To) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_DATTO | Allow NULL? |
| 5 | BKKRS | Bank Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKK01 | BKK_BKKRS | Allow NULL? |
| 6 | ROOTACCNT | Internal Account Number for Current Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BKK40 | BKK_ACCNT | Allow NULL? |
| 7 | BANKS | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | BANKS | Allow NULL? |
| 8 | BANKL | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | BNKA | BANKK | Allow NULL? |
| 9 | BKS | Bank Control Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKK_BKS | Allow NULL? |
| 10 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACEXT | Allow NULL? |
| 11 | BUPA_NAME | Help Field for Conversion with XPRA - Length Change for 4.61 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_HY_BUPANAME_TMP | Allow NULL? |
| 12 | HYTYPE | Account Hierarchy: Hierarchy Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TBKK60 | BKK_HYTYPE | Allow NULL? |
| 13 | TRANSF_TYPE | Type of Carry Forward Determination | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_TRANSF_TYPE | Allow NULL? |
| 14 | ROUNDPOS | Cash Concentration: Rounding Off from Point | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BKK_RND_PS | Allow NULL? |
| 15 | TRNSTYPE_OUT | Transaction Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_TTYPE | Allow NULL? |
| 16 | PAYMETHOD_OUT | Payment Method | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_PAYMET | Allow NULL? |
| 17 | TRNSTYPE_IN | Transaction Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_TTYPE | Allow NULL? |
| 18 | PAYMETHOD_IN | Payment Method | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_PAYMET | Allow NULL? |
| 19 | CRUSER | User who created the object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BU_CRUSR | Allow NULL? |
| 20 | CRDATE | Date on which the object was created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_CRDAT | Allow NULL? |
| 21 | CRTIME | Time at which the object was created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BU_CRTIM | Allow NULL? |
| 22 | CHUSER | Last user to change object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BU_CHUSR | Allow NULL? |
| 23 | CHDATE | Date when object was last changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_CHDAT | Allow NULL? |
| 24 | CHTIME | Time at which object was last changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BU_CHTIM | Allow NULL? |
