| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPProduction and Revenue Accounting |
| 1 | OIUREP_ARCROYHIS | Archived Reported Royalty and Volume Data | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
| 2 | OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
| 3 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
| 4 | OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
| TOPRoyalty Reporting |
| 5 | OIUREP_AMND_STAT | Report Execution statistics for amended months | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
| 6 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
| 7 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
| 8 | OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
| 9 | OIUREP_VOL_DATA | Reported Volume Data by Reporting Entities | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
| 10 | OIUY1_REP_HIST | Reported data history | 6 | YEAR_MONTH_AMND | Year and Month for Amended Reports | nvarchar | 6 | 0 | | |
