| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | OIUY3_TX_RPGDT | Royalty 2.0 - TX GLO/TAMU - Gas Report | 127 | GROSS_VALUE | Gross Value | decimal | 11 | 2 | | |
| 2 | OIUY3_TX_RPODT | Royalty 2.0 - TX GLO/TAMU - Oil Report | 41 | GROSS_VALUE | Gross Value | decimal | 11 | 2 | | |
| TOPProduction and Revenue Accounting |
| 3 | OIUREP_ARCROYHIS | Archived Reported Royalty and Volume Data | 15 | GROSS_VALUE | Gross Value From a Contract/Well | decimal | 13 | 2 | | |
| 4 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 15 | GROSS_VALUE | Gross Value From a Contract/Well | decimal | 13 | 2 | | |
| TOPRoyalty Reporting |
| 5 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 15 | GROSS_VALUE | Gross Value From a Contract/Well | decimal | 13 | 2 | | |
| 6 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 20 | GROSS_VALUE | Gross Value From a Contract/Well | decimal | 13 | 2 | | |
| 7 | OIUREP_VL_VOL | Gross Volume and Value after VL/RD | 15 | GROSS_VALUE | VL Gross Value | decimal | 13 | 2 | | |
