| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BKK_SEPA_LIM_EV | Event Table for Mandate Limits | 10 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
2 | BKK_SEPA_LIM_HIS | History Table for Mandate Limits | 11 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
TOPAccount Management |
3 | BKKITNTC | Notice: Payment Item with Notice Lock Period > 0 | 8 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
TOPBank Customer Accounts |
4 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 30 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
5 | BKK_PRENOTE | Prenotes | 14 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
TOPGL transfer |
6 | BKKC02 | General Ledger: Posting Totals for FI | 14 | A_AMOUNT | Total | decimal | 23 | 2 | | |
7 | BKKC10 | Gen. Ledger: Balances in FI per BCA Cust.Acct. / Bal.Sh.Prep | 11 | A_AMOUNT | Total | decimal | 23 | 2 | | |
8 | BKKC11 | Gen. Ledger: BCA Balances per GL Transac. for Bal.Sh.Prep. | 11 | A_AMOUNT | Total | decimal | 23 | 2 | | |
9 | BKKC12 | Gen. Ledger: New Balances for Bal. Sheet Preparation | 14 | A_AMOUNT | Total | decimal | 23 | 2 | | |
10 | BKKC30 | Gen. Ledger: Log for Transfer Postings (Bal.Sh.Prep., etc.) | 20 | A_AMOUNT | Total | decimal | 23 | 2 | | |
11 | BKKCNOITGL | Table of Items not Updated on the Account | 14 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
TOPPayment Item |
12 | BKKIT | Payment Item | 30 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
13 | BKKITAI | Info Items for Interest Penalty at Balancing | 12 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
14 | BKKITENQ | Blocked Payment Items | 30 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
15 | BKKITREL | Payment Item | 30 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
16 | BKKITTMP | Planned Payment Items | 31 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
17 | BKKITTMP_DEL | Planned Payment Items - Completed | 31 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
18 | BKKPAYMEX_IT | EFT Management: Items in Outgoing Payment Transactions | 24 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
TOPPayment Order |
19 | BKKPOIT | Item in Payment Order | 29 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
20 | BKKPOIT_TMP | Items in Planned Payment Order | 30 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |
21 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 28 | A_AMOUNT | Amount in Account Currency | decimal | 17 | 2 | | |