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