| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | HRESS_T7GB_ESS_F | HR GB ESS P60 form display settings | 3 | TAX_YEAR | Tax Year (F1 Help) | nvarchar | 4 | 0 | | |
| 2 | HRESS_T7IE_ESS_F | HR IE ESS P60 form display settings | 2 | TAX_YEAR | Tax Year (F1 Help) | nvarchar | 4 | 0 | | |
| 3 | J_3RVATD_RUN | Stored VAT-return Runs: Main Section | 9 | TAX_YEAR | Calendar Year | nvarchar | 4 | 0 | | |
| 4 | OIUX1_LA_EXCL | History table for LA Exclusion | 10 | TAX_YEAR | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
| TOPBank Customer Accounts |
| 5 | BKKSO | BCA: Standing Orders | 47 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 6 | RTP_US_HIST | Retirement plan history and audit table | 6 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 7 | RTP_US_RMD | Required minimum distribution | 4 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 8 | RTP_US_TOT | Total amounts for a retirement plan | 4 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| TOPPayment Item |
| 9 | BKKIT | Payment Item | 115 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 10 | BKKITENQ | Blocked Payment Items | 118 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 11 | BKKITPRE | Parked Payment Items | 23 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 12 | BKKITREL | Payment Item | 115 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 13 | BKKITTMP | Planned Payment Items | 119 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 14 | BKKITTMP_DEL | Planned Payment Items - Completed | 119 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| TOPPayment Order |
| 15 | BKKPOIT | Item in Payment Order | 56 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 16 | BKKPOIT_TMP | Items in Planned Payment Order | 49 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
| 17 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 47 | TAX_YEAR | Tax-year | nvarchar | 4 | 0 | | |
