| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BCA_RCN_SUMSIN | Aggregated data for reconciliation | 6 | RECONC_SYSTEM | Source System ID | nvarchar | 10 | 0 | | |
2 | BKK_OPD_IT_EXT | External Item Selection Table - Outgoing Payment Dispatcher | 31 | RECONC_SYSTEM | Originating System for Payment Orders and Payment Items | nvarchar | 10 | 0 | | |
3 | BKK_PXPO_ORDER | Collective Payment Order | 18 | RECONC_SYSTEM | Originating System for Payment Orders and Payment Items | nvarchar | 10 | 0 | | |
TOPBank Customer Accounts |
4 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 110 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | | |
TOPPayment Item |
5 | BKKIT | Payment Item | 110 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | | |
6 | BKKITENQ | Blocked Payment Items | 110 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | | |
7 | BKKITREL | Payment Item | 110 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | | |
8 | BKKITTMP | Planned Payment Items | 111 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | | |
9 | BKKITTMP_DEL | Planned Payment Items - Completed | 111 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | | |
TOPPayment Order |
10 | BKKPOIT | Item in Payment Order | 53 | RECONC_SYSTEM | Identification of Supplying System | nvarchar | 10 | 0 | | |