| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | BKK_SEPA_LIM_EV | Event Table for Mandate Limits | 8 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| 2 | BKK_SEPA_LIM_HIS | History Table for Mandate Limits | 9 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| Bank Customer Accounts | ||||||||||
| 3 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 108 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| 4 | BKKSO | BCA: Standing Orders | 33 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| Master Data | ||||||||||
| 5 | BKK43 | BCA: Reference Accounts | 22 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| Payment Item | ||||||||||
| 6 | BKKIT | Payment Item | 108 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| 7 | BKKITENQ | Blocked Payment Items | 108 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| 8 | BKKITREL | Payment Item | 108 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| 9 | BKKITTMP | Planned Payment Items | 109 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| 10 | BKKITTMP_DEL | Planned Payment Items - Completed | 109 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| Payment Order | ||||||||||
| 11 | BKKPOIT | Item in Payment Order | 49 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| 12 | BKKPOIT_TMP | Items in Planned Payment Order | 66 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||
| 13 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 64 | UCI | Creditor Identification | nvarchar | 35 | 0 | ||