| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBank Customer Accounts |
| 1 | BKKSO | BCA: Standing Orders | 50 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| 2 | RTP_US_HIST | Retirement plan history and audit table | 9 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| 3 | RTP_US_TOT | Total amounts for a retirement plan | 7 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| TOPPayment Item |
| 4 | BKKIT | Payment Item | 118 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| 5 | BKKITENQ | Blocked Payment Items | 121 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| 6 | BKKITPRE | Parked Payment Items | 26 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| 7 | BKKITREL | Payment Item | 118 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| 8 | BKKITTMP | Planned Payment Items | 122 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| 9 | BKKITTMP_DEL | Planned Payment Items - Completed | 122 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| TOPPayment Order |
| 10 | BKKPOIT | Item in Payment Order | 59 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| 11 | BKKPOIT_TMP | Items in Planned Payment Order | 52 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
| 12 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 50 | IRS_DCODE | Retirement plan distribution code | nvarchar | 1 | 0 | | |
