| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUY3_TX_PDCXRF | Royalty 2.0 - TX GLO/TAMU - Production Disposition XRef | 6 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
2 | OIUY3_TX_RPDTP | Royalty 2.0 - TX GLO/TAMU- Report Detail - Production | 11 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
3 | OIUY6_WY_RPDTP | Royalty 2.0 - WY - Lease/Unit Report Detail - Production | 9 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
TOPContractual Allocation |
4 | OIUCA_ENT_VT | CA Allocation Entitlement Volume Types | 6 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
TOPProduction |
5 | OIUPR_SKFV | Volumetric SKF | 4 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
6 | OIUPR_SSH | Supply Source Header | 8 | VT_CD | Volume Type Code | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
7 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 6 | VT_CD | Volume Type Code | nvarchar | 2 | 0 | | |
8 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 15 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
9 | OIUP_SB_ENTMP | MP level owner entitlements (PDM Shadow) | 11 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
10 | OIUP_SB_ENTWC | WC level owner entitlements (PDM Shadow) | 12 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
11 | OIUP_SB_RNEWC | Residue and NGL entitlements at a WC level (PDM Shadow) | 7 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
12 | OIU_PR_DNAPD | Network Allocation Profile Detail | 4 | VT_CD | Volume Type Code | nvarchar | 2 | 0 | | |
13 | OIU_PR_FRMDW | Formular Rules DW | 9 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
14 | OIU_PR_MPALB | PRA: Measurement Point Allocation Base | 6 | VT_CD | Volume Type Code | nvarchar | 2 | 0 | | |
15 | OIU_PR_MPAPD | Measure Point Allocation Profile Detail | 3 | VT_CD | Volume Type Code | nvarchar | 2 | 0 | | |
16 | OIU_PR_MPFUSD | Measurement Point Liquid Throughput | 4 | VT_CD | Volume Type Code | nvarchar | 2 | 0 | | |
17 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 5 | VT_CD | Volume Type Code | nvarchar | 2 | 0 | | |
18 | OIU_PR_MV_CFG | Vollume Allocation Metered Volume Configuration | 3 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
19 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 14 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
20 | OIU_PR_WCALB | PRA: Well Completion Allocation Base | 7 | VT_CD | Volume Type Code | nvarchar | 2 | 0 | | |
21 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 14 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
22 | OIU_PR_WCSSH | Well Completion Supply Source Dated Header | 7 | VT_CD | Volume Type Code | nvarchar | 2 | 0 | | |
23 | OIU_SB_ENTMP | MP level owner entitlements | 10 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
24 | OIU_SB_ENTMP_T | MP level owner entitlements | 10 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
25 | OIU_SB_ENTWC | WC level owner entitlements | 11 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
26 | OIU_SB_ENTWC_T | WC level owner entitlements | 11 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
27 | OIU_SB_RNEMP | Residue and NGL entitlements at a MP level | 5 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
28 | OIU_SB_RNEMP_T | Temporary Residue and NGL entitlements at a MP level | 5 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
29 | OIU_SB_RNEWC | Residue and NGL entitlements at a WC level | 6 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
30 | OIU_SB_RNEWC_T | Temporary Residue and NGL entitlements at a WC level | 6 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
TOPRoyalty Reporting |
31 | OIUREP_CODE_XREF | Reg Reporting Product/Volume Type to Report Code Cross Ref | 6 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
32 | OIUREP_STAT_SPLT | Regulatory Reporting: Well Status Split table | 7 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |
33 | OIUREP_VL_VOL | Gross Volume and Value after VL/RD | 12 | VT_CD | Volume type code | nvarchar | 2 | 0 | | |