| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 33 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
2 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 34 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
3 | OIUREP_ARCROYHIS | Archived Reported Royalty and Volume Data | 27 | ENERGY | energy | decimal | 21 | 8 | | |
4 | OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | 13 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
5 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 27 | ENERGY | energy | decimal | 21 | 8 | | |
6 | OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | 13 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
7 | OIUX1_ARCH_VOLH | Reported Volume Data by PUID | 14 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
8 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 32 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
9 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 33 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
10 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 33 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
11 | OIU_SB_CAP | Capacity Header | 6 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
TOPRoyalty Reporting |
12 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 27 | ENERGY | energy | decimal | 21 | 8 | | |
13 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 31 | ENERGY | energy | decimal | 21 | 8 | | |
14 | OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | 13 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
15 | OIUREP_VOL_DATA | Reported Volume Data by Reporting Entities | 17 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
TOPTax Reporting |
16 | OIUX1_PUID_VOLH | Reported Volume Data by PUID | 14 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
17 | OIUX1_RPT_VOLH | Reported Volume Data by Reporting Entities | 19 | ENERGY | Energy quantity | decimal | 13 | 3 | | |
18 | OIUX2_PUID_VOLH | Reported Volume Data by PUID | 14 | ENERGY | Energy quantity | decimal | 13 | 3 | | |