| 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 | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 2 | OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 3 | OIUREP_ENTTY_LOG | Log table for master data entity changes | 5 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 4 | OIUREP_OWNER_LOG | Log for master Data Owner Changes | 5 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 5 | OIUREP_PRFL_LOG | Log for master data profile changes | 5 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 6 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 7 | OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 8 | OIUY1_DOWNLOAD | The intermediate table for download | 2 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 9 | OIUY1_EXEC_STATD | Execution Statistics for Royalty Reporting | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 10 | OIUY1_TXDOWNLOAD | The intermediate table for Texas download | 2 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| TOPRoyalty Reporting |
| 11 | OIUREP_AMND_STAT | Report Execution statistics for amended months | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 12 | OIUREP_EXEC_COMB | Possible Combinations of Royalty Executions | 2 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 13 | OIUREP_EXEC_STAT | Report Execution Statistics | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 14 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 15 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 16 | OIUREP_ROY_LOG | Changes to master data for reporting | 5 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 17 | OIUREP_RPT_ENTTY | Entities for Royalty Reporting | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 18 | OIUREP_RPT_OWNER | Owners for royalty reporting | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 19 | OIUREP_RPT_PRFL | Report Profile | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 20 | OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 21 | OIUREP_VOL_DATA | Reported Volume Data by Reporting Entities | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
| 22 | OIUY1_REP_HIST | Reported data history | 3 | ORG_LEVEL1_NO | Company Code | nvarchar | 4 | 0 | | |
