| 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 | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 2 | OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 3 | OIUREP_ENTTY_LOG | Log table for master data entity changes | 4 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 4 | OIUREP_OWNER_LOG | Log for master Data Owner Changes | 4 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 5 | OIUREP_PRFL_LOG | Log for master data profile changes | 4 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 6 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 7 | OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| TOPRoyalty Reporting |
| 8 | OIUREP_AGY_PDCD | Agency defined Product Code | 3 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 9 | OIUREP_AMND_STAT | Report Execution statistics for amended months | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 10 | OIUREP_EXEC_COMB | Possible Combinations of Royalty Executions | 4 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 11 | OIUREP_EXEC_STAT | Report Execution Statistics | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 12 | OIUREP_LGL_RPTS | Legal Reports for Tax and Royalty Reporting | 8 | OIL_GAS_IND | Oil/Gas Indicator for Reports (Oil, Gas or Both) | nvarchar | 1 | 0 | | |
| 13 | OIUREP_PDCD_XREF | Cross Reference Between State Agency and PRA Material | 3 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 14 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 15 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 16 | OIUREP_ROY_LOG | Changes to master data for reporting | 7 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 17 | OIUREP_RPT_ENTTY | Entities for Royalty Reporting | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 18 | OIUREP_RPT_OWNER | Owners for royalty reporting | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 19 | OIUREP_RPT_PRFL | Report Profile | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 20 | OIUREP_TAB_IND | Agency related fields for master data maintainence | 3 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 21 | OIUREP_VLTP_XREF | Cross reference between Agency defined & PRA volume types | 2 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 22 | OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 23 | OIUREP_VOL_DATA | Reported Volume Data by Reporting Entities | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 24 | OIUREP_XTRCT_ROY | Extract Royaty Data for the current reporting period | 4 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| 25 | OIUY1_REP_HIST | Reported data history | 5 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
| TOPTax Reporting |
| 26 | OIUX1_PDCD_XREF | Cross Reference Between State Agency and PRA Material | 3 | OIL_GAS_IND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
