| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | BKKRS | Bank Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TBKK01 | BKK_BKKRS | Allow NULL? |
| 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | CHAR | (N' ') | No | BKK40 | BKK_ACCNT | Allow NULL? |
| 4 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACEXT | Allow NULL? |
| 5 | BKS | Bank Control Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKK_BKS | Allow NULL? |
| 6 | ACNUM_IBAN | International Bank Account Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BKK_ACIBAN | Allow NULL? |
| 7 | CONDAREA | Condition Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_CONDAR | Allow NULL? |
| 8 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | FIPR_PRODUCT | BKK_PRODINT | Allow NULL? |
| 9 | VERSION | Version of a Product | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | BKK_PRODVERSION | Allow NULL? |
| 10 | ACKIND | Product (Old) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TBZ0 | BKK_ACKIND | Allow NULL? |
| 11 | XCTLFLGBAL | Flag: Control Indicator Account Balancing Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCTLFLGBAL | Allow NULL? |
| 12 | SENDTYPE | Dispatch Type of Bank Statement | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BKK_SENDTY | Allow NULL? |
| 13 | CONDCHDATE | Date of Last Change of Condition Group | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BKK_CONDCHDATE | Allow NULL? |
| 14 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BEGRU | Allow NULL? |
| 15 | GLGRP | General Ledger Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BKK_GLGRP | Allow NULL? |
| 16 | GLKEY | Netting Group GL | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BKK_GLKEY | Allow NULL? |
| 17 | ACTEXT | Account Description for Current Account | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | BKK_ACTEXT | Allow NULL? |
| 18 | WAERS | Currency of Current Account | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | BKK_ACCUR | Allow NULL? |
| 19 | CONDGR1 | Condition Group: Interest | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKK85 | BKK_CONGR1 | Allow NULL? |
| 20 | CONDGR2 | Condition Group: Charges | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKK85 | BKK_CONGR2 | Allow NULL? |
| 21 | CONDGR3 | Condition Group: Value Dates | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TBKK85 | BKK_CONGR3 | Allow NULL? |
| 22 | CAL_ID1 | Public Holiday Calendar Key 1 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | BKK_CAL1 | Allow NULL? |
| 23 | CAL_ID2 | Public Holiday Calendar Key 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | BKK_CAL2 | Allow NULL? |
| 24 | SHARE_ID | Indicator: Individual, AND or OR Account | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_SHARE | Allow NULL? |
| 25 | XTHIRD | Indicator: To the Benefit of a Third Party | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XTHIRD | Allow NULL? |
| 26 | SECUR_ID | Collateral ID | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BKK_SEC_ID | Allow NULL? |
| 27 | CONDIND1 | Flag: Individual Conditions for Interest Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_CONDX1 | Allow NULL? |
| 28 | CONDIND2 | Individual Charge Conditions Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_CONDX2 | Allow NULL? |
| 29 | CONDIND3 | Individual Value Date Conditions Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_CONDX3 | Allow NULL? |
| 30 | CONDIND4 | Flag: Interest Scale Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_CONDX4 | Allow NULL? |
| 31 | XACREF | Indicator: Account Used as Reference Account | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XACREF | Allow NULL? |
| 32 | XACCLO | Flag: Balancing on Reference Account | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XACCLO | Allow NULL? |
| 33 | XWHTAX | Indicator: Capital Yield Tax | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKK_XWHTAX | Allow NULL? |
| 34 | XCOLAUTH | Check for Collection Authorization Agreement | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_COLAUT | Allow NULL? |
| 35 | XVALREQ | Indicator: Value Date Specification Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XVALRQ | Allow NULL? |
| 36 | XOPITM | Open Items Posted to the Account | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XOPITM | Allow NULL? |
| 37 | XBLOCKDEBIT | Indicator: Debit Lock | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XBLOCKDEB | Allow NULL? |
| 38 | XBLOCKCREDIT | Indicator: Credit Lock | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XBLOCKCRED | Allow NULL? |
| 39 | XPOST_FEE_SEP | Post Charges Individually | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XPOST_FEE_SEP | Allow NULL? |
| 40 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 41 | BANKL_ACCT | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKK | Allow NULL? |
| 42 | MIN_DEPOSIT | Minimum Deposit Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | BKK_MINDEPOSIT | |
| 43 | AIMETH | Method of Interest Penalty Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_AIMETH | Allow NULL? |
| 44 | AI_POST | Type of Interest Penalty Debit | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_AIPOST | Allow NULL? |
| 45 | ESTCOND | Fixing Conditions | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_ESTCOND | Allow NULL? |
| 46 | XCIWLIST | Creditor Whitelist Check | char | 1 | 0 | CHAR | (N' ') | Yes | | BKK_XCIWLIST | Allow NULL? |
