| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIURV_TAXTYPES | State applicable Tax Types are maintained | 2 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
TOPCheck Write |
2 | OIUCW_NRIT_WH | States with Withholding requirement | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
TOPContractual Allocation |
3 | OIUCA_ENT_VT | CA Allocation Entitlement Volume Types | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
4 | OIUREP_TAXBACKUP | Backup tax table for old tax reporting SOL | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
5 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
6 | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
7 | OIU_CM_LXPGL_TX | Description of Primary Geographical Locations | 4 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
8 | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
9 | OIU_CM_LXSGL_TX | Description of Secondary Geographical Locations | 4 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
10 | OIU_CM_PRES | Location to Pressure Base Xref | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
11 | OIU_CM_SCHDCD | School district code | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
12 | OIU_CM_SEVTGRP | Severance Type Group Table | 4 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
13 | OIU_CM_TAXCLS | Tax Class - Table | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
14 | OIU_CM_TAXCLS_TX | Tax Class - Text | 4 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
15 | OIU_DO_DI | Base Venture/DOI Relationship | 9 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
16 | OIU_DO_JV | PRA venture extension | 10 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
17 | OIU_PR_DN | Delivery Network | 6 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
18 | OIU_PR_MP | PRA Measurement Points | 9 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
19 | OIU_PR_WC | PRA: Well Completion | 20 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
20 | OIU_RV_CPTD | Contract Product Tax Reimbursement Detail | 5 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
21 | OIU_RV_MULT_DN | Multiple DN for same well | 10 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
TOPRevenue |
22 | OIUE2_RUN_HDR | Proc 2.0 - Run Header | 11 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
23 | OIURV03_CONFIG | MP to Well Completion Split Out Config | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
24 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 7 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
TOPRoyalty Reporting |
25 | OIUREP_VL_VOL | Gross Volume and Value after VL/RD | 19 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
TOPTax Reporting |
26 | OIUX1_ADJ_TAXHC | Tax adjustments header for reporting | 23 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
27 | OIUX1_TRN_TAXHC | Tax transaction header for reporting | 20 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
28 | OIUX1_TRN_TAXHL | Tax transaction header for reporting | 20 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
29 | OIUX3_RPT | Tax Reporting - Reports | 5 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
30 | OIUX5_OOSWO | Tax 2.0 - Out Of Statute Write Off | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
TOPValuation |
31 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 28 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
32 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 7 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
33 | OIURV_TAXCONFD | State tax configuration detail | 2 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
34 | OIURV_TAXCONFH | State tax configuration header | 2 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
35 | OIURV_TCD | Tax calculation data | 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
36 | OIUVL_MTAH | Marketing Cost Tax Exemption - Header | 11 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
37 | OIUVL_SEV | Severance tax | 14 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
38 | OIUVL_STTR | State Tax Rates | 2 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
39 | OIUVL_TCJV | Tax Class - Venture DOI's | 10 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
40 | OIUVL_TCMP | Tax Class Measurement Points | 8 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
41 | OIUVL_TCWC | Tax Class - Well Completion | 9 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |
42 | OIUVL_TTRPD | Tax Tier Rate by Project - Data | 6 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | | |