| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8_NM_SUFFXRF | Tax 2.0 - New Mexico Suffix and tax rate x-ref | 10 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
TOPProduction and Revenue Accounting |
2 | OIUREP_TAXBACKUP | Backup tax table for old tax reporting SOL | 17 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
3 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 17 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
4 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 13 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
5 | OIUX2_LNK_LOG | Tax Reporting log table for the link | 16 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
6 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 13 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
7 | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | 4 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
8 | OIU_CM_LXSGL_TX | Description of Secondary Geographical Locations | 5 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
9 | OIU_DO_DI | Base Venture/DOI Relationship | 10 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
10 | OIU_DO_JV | PRA venture extension | 11 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
11 | OIU_PR_DN | Delivery Network | 7 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
12 | OIU_PR_MP | PRA Measurement Points | 10 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
13 | OIU_PR_WC | PRA: Well Completion | 21 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
TOPRevenue |
14 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 8 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
TOPTax Reporting |
15 | OIUX1_ADJ_TAXHC | Tax adjustments header for reporting | 24 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
16 | OIUX1_LNK_REPUB | PUID and reporting entities link | 13 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
17 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 13 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
18 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 23 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
19 | OIUX1_TRN_TAXHC | Tax transaction header for reporting | 21 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
20 | OIUX1_TRN_TAXHL | Tax transaction header for reporting | 21 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
21 | OIUX3_TX_CNTXRF | Tax Reporting - Texas County XRef | 2 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
TOPValuation |
22 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 8 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
23 | OIUVL_SEV | Severance tax | 15 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |
24 | OIUVL_STTR | State Tax Rates | 9 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | | |