| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BKK_PXPO_ORDER | Collective Payment Order | 9 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
2 | CNVTDMS_05_POERR | Fill Header table to store erroneous Payment Orders | 3 | ACNUM_EXT | Data Element for CHAR35 | nvarchar | 35 | 0 | | |
TOPBank Customer Accounts |
3 | BCA_US_BKK_TD | BCA: Time deposit account data | 14 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
4 | BKKCORRACCNT | Auxiliary Table: Accounts for Adjustments | 4 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
5 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 9 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
6 | BKKTERMPPRC | Term Agreements in Postprocessing Status | 5 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
7 | TBCA_US_DEA_REF | Escheat Account Closure Reference Data | 5 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
8 | TBKKIHB1 | In-House Bank ID from Payment Notes in Bank Statement | 3 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
9 | TBKKIHB4 | FI Data for Manual Outgoing Payments In-House Bank | 3 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
10 | TBKKIHB5 | Payt Method Determination HQ FI for Payment In-House Bank | 4 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
11 | TBKKIHB6 | Dispatcher per Account Number | 9 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
TOPCondition |
12 | BKK97 | Acct Balancing: Posting Data (Temporary Data)(for Deletion) | 12 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
TOPFSCM In-House Cash |
13 | IHC_DB_CMGRP2 | Cash Management Group: Account Assignment | 5 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
TOPMaster Data |
14 | BKK42 | Current Account Master Data: Operative Data | 4 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
15 | BKK42ENQ | Current Account: Block Fields | 3 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
16 | BKK610 | Account Hierarchy: Assignment of Root Account to Tree Number | 10 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
17 | BKK625 | Assign. of Int. No. to Ext. Root Acct. for Change Document | 5 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
18 | BKKOVR_ACCNT | Item Table: Accounts with Tolerated Overdraft | 5 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
TOPPayment Item |
19 | BKKIT | Payment Item | 9 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
20 | BKKITENQ | Blocked Payment Items | 9 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
21 | BKKITPRE | Parked Payment Items | 4 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
22 | BKKITREL | Payment Item | 9 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
23 | BKKITTMP | Planned Payment Items | 10 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
24 | BKKITTMP_DEL | Planned Payment Items - Completed | 10 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
25 | BKKPAYMIN_IT | Table of Imported Items | 8 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
TOPPayment Order |
26 | BKKPOIT | Item in Payment Order | 10 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
27 | BKKPOIT_TMP | Items in Planned Payment Order | 11 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |
28 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 10 | ACNUM_EXT | Account number for current account | nvarchar | 35 | 0 | | |