| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBank Customer Accounts |
| 1 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 78 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | nvarchar | 1 | 0 | | |
| TOPPayment Item |
| 2 | BKKIT | Payment Item | 78 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | nvarchar | 1 | 0 | | |
| 3 | BKKITENQ | Blocked Payment Items | 78 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | nvarchar | 1 | 0 | | |
| 4 | BKKITREL | Payment Item | 78 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | nvarchar | 1 | 0 | | |
| 5 | BKKITTMP | Planned Payment Items | 79 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | nvarchar | 1 | 0 | | |
| 6 | BKKITTMP_DEL | Planned Payment Items - Completed | 79 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | nvarchar | 1 | 0 | | |
| TOPPayment Order |
| 7 | BKKPOIT | Item in Payment Order | 41 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | nvarchar | 1 | 0 | | |
| 8 | BKKPOIT_TMP | Items in Planned Payment Order | 42 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | nvarchar | 1 | 0 | | |
| 9 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 40 | XCHK_EXTD_MND | Indicator: Extended Mandate Check Excluded? | nvarchar | 1 | 0 | | |
| TOPProduct definition |
| 10 | TBKKG3 | Transaction types | 27 | XCHK_EXTD_MND | Indicator: Execute Extended Mandate Checks | nvarchar | 1 | 0 | | |
