| 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 | 7 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
| 2 | OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | 7 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
| 3 | OIUREP_ENTTY_LOG | Log table for master data entity changes | 12 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
| 4 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 7 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
| 5 | OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | 7 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
| TOPRoyalty Reporting |
| 6 | OIUREP_AGY_LSE | Agency assigned Leases | 3 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
| 7 | OIUREP_AGY_LSETX | Text Table for Agency assigned Leases | 4 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
| 8 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 7 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
| 9 | OIUREP_RPT_ENTTY | Entities for Royalty Reporting | 11 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
| 10 | OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | 7 | AGENCY_LEASE | Agency assigned Lease No. | nvarchar | 15 | 0 | | |
