| 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) | 32 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
2 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 31 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
3 | OIUREP_ARCROYHIS | Archived Reported Royalty and Volume Data | 14 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
4 | OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | 12 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
5 | OIUREP_EMPBACKUP | Exemptions for skipped tax records | 5 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
6 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 14 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
7 | OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | 12 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
8 | OIUX1_ARCH_VOLH | Reported Volume Data by PUID | 13 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
9 | OIUX1_ARCH_XMPH | Reporting history for tax exemptions | 14 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
10 | OIUX2_PUID_XMPH | Reporting history for tax exemptions | 14 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
11 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 31 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
12 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 30 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
13 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 30 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
14 | OIU_SB_CTRMP | Volumes for sale | 11 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
15 | OIU_SB_CTRMP_T | Volumes for sale | 11 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
16 | OIU_SB_CTRWC | Volumes for sale | 12 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
17 | OIU_SB_CTRWC_T | Volumes for sale | 12 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
18 | OIU_SB_OZOPD | Outside operated residual contract detail | 14 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
TOPRoyalty Reporting |
19 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 14 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
20 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 19 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
21 | OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | 12 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
22 | OIUREP_VOL_DATA | Reported Volume Data by Reporting Entities | 16 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
TOPTax Reporting |
23 | OIUX1_ADJ_XMPC | Tax adjustment exemptions for reporting | 12 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
24 | OIUX1_PUID_VOLH | Reported Volume Data by PUID | 13 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
25 | OIUX1_PUID_XMPH | Reporting history for tax exemptions | 14 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
26 | OIUX1_RPT_VOLH | Reported Volume Data by Reporting Entities | 18 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
27 | OIUX1_RPT_XMPH | Reporting history for tax exemptions | 5 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
28 | OIUX1_TRN_XMPC | Tax transaction exemptions for reporting | 12 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
29 | OIUX1_TRN_XMPL | Tax transaction exemptions for reporting | 11 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
30 | OIUX2_PUID_VOLH | Reported Volume Data by PUID | 13 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |
TOPValuation |
31 | OIURV_DOC_RUNTKT | Valuation Transaction - Run Ticket | 11 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | |