| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBank Customer Accounts |
1 | BKKSO | BCA: Standing Orders | 49 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
2 | RTP_US_HIST | Retirement plan history and audit table | 8 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
3 | RTP_US_TOT | Total amounts for a retirement plan | 6 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
4 | TRTP_US_CONT | Contribution codes for a retirement plan | 2 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
5 | TRTP_US_CONTT | Contribution codes for a retirement plan | 2 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
6 | TRTP_US_CONT_DAT | Contribution dates for a retirement plan | 3 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
TOPPayment Item |
7 | BKKIT | Payment Item | 117 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
8 | BKKITENQ | Blocked Payment Items | 120 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
9 | BKKITPRE | Parked Payment Items | 25 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
10 | BKKITREL | Payment Item | 117 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
11 | BKKITTMP | Planned Payment Items | 121 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
12 | BKKITTMP_DEL | Planned Payment Items - Completed | 121 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
TOPPayment Order |
13 | BKKPOIT | Item in Payment Order | 58 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
14 | BKKPOIT_TMP | Items in Planned Payment Order | 51 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |
15 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 49 | CONTRIB_ID | Contribution identifier | nvarchar | 2 | 0 | | |