| 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 | 129 | ROYALTY_DUE | Royalty 2.0 - Texas GLO/TAMU - Royalty Due | decimal | 11 | 2 | | |
2 | OIUY3_TX_RPODT | Royalty 2.0 - TX GLO/TAMU - Oil Report | 43 | ROYALTY_DUE | Royalty 2.0 - Texas GLO/TAMU - Royalty Due | decimal | 11 | 2 | | |
3 | OIUY3_TX_RPSM | Royalty 2.0 - TX GLO/TAMU - Report Summary | 10 | ROYALTY_DUE | Royalty 2.0 - Texas GLO/TAMU - Royalty Due | decimal | 11 | 2 | | |
TOPProduction and Revenue Accounting |
4 | OIUREP_ARCROYHIS | Archived Reported Royalty and Volume Data | 25 | ROYALTY_DUE | Royalty Amount due to the State Agency | decimal | 13 | 2 | | |
5 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 25 | ROYALTY_DUE | Royalty Amount due to the State Agency | decimal | 13 | 2 | | |
TOPRoyalty Reporting |
6 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 25 | ROYALTY_DUE | Royalty Amount due to the State Agency | decimal | 13 | 2 | | |
7 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 29 | ROYALTY_DUE | Royalty Amount due to the State Agency | decimal | 13 | 2 | | |