| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BKK_SEPA_LIM_EV | Event Table for Mandate Limits | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
2 | BKK_SEPA_LIM_HIS | History Table for Mandate Limits | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
TOPAccount Management |
3 | BKK42_NTC | Master Data for Notice and Allowances | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
4 | BKKITNTC | Notice: Payment Item with Notice Lock Period > 0 | 4 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
5 | BKKNTC | Notice: Partial Amount and Full Amount Notice | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
6 | BKKVRS | Available Balance Series | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
7 | BKK_FA_USED | Utilization of Allowance | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
TOPBank Customer Accounts |
8 | BCA_US_BKK44A | Current account master data: Amount-dependent blocks | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
9 | BCA_US_BKK_TD | BCA: Time deposit account data | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
10 | BCA_US_DEA_ESCH | Escheat Accounts Data | 7 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
11 | BCA_US_MEM_ITEMS | Memo item table | 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
12 | BCA_US_OD_PLAN | Account master data: Overdraft plan | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
13 | BCA_US_OD_REL | Accounts - US specific overdraft relation details | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
14 | BCA_US_OD_TRANS | Transaction details for Overdraft protection | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
15 | BKK45_CORR | Correspondence Receiver Administration | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
16 | BKK58 | Master Data Savings Prod: Fxd-Term Deposit, Installmnt Savgs | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
17 | BKKCORRACCNT | Auxiliary Table: Accounts for Adjustments | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
18 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
19 | BKKSO | BCA: Standing Orders | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
20 | BKKSONT | Payment Notes of Standing Orders | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
21 | BKKSO_PACK | Saving Packages for Standing Order Posting | 4 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
22 | BKKSO_PAORN | BCA: Payment Orders of a Standing Order | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
23 | BKKSO_VAR_AMNT | Standing Order: Variable Amounts | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
24 | BKKTERM | Term Agreement for Fixed-Term Deposit and Installmt Savings | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
25 | BKKTERMPPRC | Term Agreements in Postprocessing Status | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
26 | BKK_PRENOTE | Prenotes | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
27 | BKK_RATE | Master Data for Installment Savings | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
28 | RTP_US_ACC | Linking table between a retirement plan and an account | 4 | ACNUM_INT | Retirement plan: Internal account number | nvarchar | 15 | 0 | | |
TOPCondition |
29 | BKK84 | Bank Account - Individual Condition | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
30 | BKK84T | Texts for Bank Account Individual Condition | 4 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
31 | BKK85 | Bank Account - Individual Condition Position | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
32 | BKK91 | Value Date Transaction Figures | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
33 | BKK92 | Account Balancing (Interest and Charges) | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
34 | BKK93 | Oldest Period for Return Posting | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
35 | BKK94 | Number of Items | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
36 | BKK95 | Account Specific Amount Limits for Graduated Conditions | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
37 | BKK96 | Account Balancing Detail Data | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
38 | BKK97 | Acct Balancing: Posting Data (Temporary Data)(for Deletion) | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
39 | BKK98 | Dispatch Expenses Number of Items | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
40 | BKK9A | Posting and Value Date Balances Carried Forward | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
41 | BKK9ACC | Interest Accrual/Deferral (Accounts With No Result) | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
42 | BKK9AI | Carryforward of Interest Penalty | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
43 | BKK9B | Value Date Transaction Figures | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
44 | BKK9C | Acct Balancing (Interest and Charges) Enhancement to BKK92 | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
45 | BKK9IW | Variant Condition Fixings | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
46 | BKK9RK | Oldest Period for Retroactive Condition Changes | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
TOPCorrespondence Tool |
47 | DFKKCOH | Correspondence - Correspondence Header | 66 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
48 | DFKKCOHI | Correspondence - Correspondence History | 43 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
TOPGL transfer |
49 | BKKC10 | Gen. Ledger: Balances in FI per BCA Cust.Acct. / Bal.Sh.Prep | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
50 | BKKC11 | Gen. Ledger: BCA Balances per GL Transac. for Bal.Sh.Prep. | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
51 | BKKC12 | Gen. Ledger: New Balances for Bal. Sheet Preparation | 7 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
52 | BKKC13 | Gen.Ledger: Changes GL Fields in Account Master | 4 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
53 | BKKC30 | Gen. Ledger: Log for Transfer Postings (Bal.Sh.Prep., etc.) | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
54 | BKKCNOITGL | Table of Items not Updated on the Account | 7 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
55 | BKKCVA | Administration Table Individual Value Adjustment | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
TOPInterestCharge Calculation |
56 | BKKM1 | BCA: Bank Statement Data | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
57 | BKKM2 | Account Time Periods | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
58 | BKKM2_NP | nonperiodic runs for periodic applications | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
59 | BKKM5 | BCA: Periods of Account Balancing to be Calculated (New) | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
60 | BKKMBALNOT | BCA: Balance Notification Data | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
61 | BKKM_TS | Bank statement time stamp | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
TOPMaster Data |
62 | BCA_US_HLD2REL | Hold Records which have not been released - Dual Control | 3 | ACNUM_INT | Paying Account Reference-Internal | nvarchar | 10 | 0 | | |
63 | BCA_US_HOLD | Hold Amounts Which Affect Available Balance | 3 | ACNUM_INT | Paying Account Reference-Internal | nvarchar | 10 | 0 | | |
64 | BKK40 | Current Account Master Data: General | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
65 | BKK40_ENQ_HY | Dummy Block Table for Accounts for Hierarchy Creation | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
66 | BKK42 | Current Account Master Data: Operative Data | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
67 | BKK42_CC | BCA Account Master Data: Currency Changeover | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
68 | BKK43 | BCA: Reference Accounts | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
69 | BKK44 | Current Account Master Data: Blocks | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
70 | BKK45 | Relationship: Current Account - Business Partner | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
71 | BKK45_HISTORY | History Table for Table BKK45 | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
72 | BKK46 | Current Account Master Data: Customer Appends | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
73 | BKK47 | BCA: Direct Debit Orders | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
74 | BKK48 | Control Indicator for Account Balancing | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
75 | BKK50 | Account balance | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
76 | BKK51 | Subj.Fin.Pay. Balance | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
77 | BKK54 | Account Balance of Hierarchies | 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
78 | BKK55 | Subject to Final Payment Balance of Hierarchies | 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
79 | BKK56 | Account Resubmission | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
80 | BKK62_CC | Value Date Transaction Figures for Cash Concentration | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
81 | BKK9B_CC | Value Date Transaction Figures for Cash Concentration | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
82 | BKKE1 | Current Account: Limits | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
83 | BKKOVR_ACCNT | Item Table: Accounts with Tolerated Overdraft | 4 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
TOPPayment Item |
84 | BKKI3 | Turnover Items Not Posted for Last Bank Statement | 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
85 | BKKIT | Payment Item | 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
86 | BKKITAI | Info Items for Interest Penalty at Balancing | 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
87 | BKKITENQ | Blocked Payment Items | 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
88 | BKKITREL | Payment Item | 5 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
89 | BKKITTMP | Planned Payment Items | 6 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
90 | BKKITTMP_DEL | Planned Payment Items - Completed | 6 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
TOPPayment Order |
91 | BKKPOIT | Item in Payment Order | 6 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
92 | BKKPOIT_TMP | Items in Planned Payment Order | 7 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
93 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 7 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
TOPPosition Management |
94 | BKKA4 | Current Account: Position Types Checks | 3 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
95 | BKKA6 | Means of Payt Mgmt: Stack Mgmt - Issued/Blocked Checks | 9 | ACNUM_INT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |