| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | OIUX8_NM_MKTXRF | Tax 2.0 - NM - Marketing Type Xref | 2 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 2 | OIUY6_WY_MKTXRF | Royalty 2.0 - WY - Marketing Type Xref | 2 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 3 | OIU_RV_LOAD_OIL | Valuation Load Oil Transactions | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| TOPBalancing |
| 4 | OIUBL01_PRD_GRPD | Ballancing Product Group Detail - Product code Xref | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| TOPContractual Allocation |
| 5 | OIUCA_ENT_VT | CA Allocation Entitlement Volume Types | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| TOPOwnership |
| 6 | OIUOW_DOEX_WK | Owner State Tax Exemption Worktable | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 7 | OIUOW_MKEX_WK | Marketing Cost Exemption Worktable | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| TOPProduction and Revenue Accounting |
| 8 | OIUCM_ACTG_OFST | Accounting Offset | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 9 | OIUCM_CMPNT | Common table for cross-referencing product codes and compo | 1 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 10 | OIUREP_TAXBACKUP | Backup tax table for old tax reporting SOL | 9 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 11 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 9 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 12 | OIUXI_PPNH | XI: Prior Period Notification Header | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 13 | OIU_CM_CPDC | Combined Product Code/Major Product Code (TBLRV031) | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 14 | OIU_CM_CPDC_TX | Combined Product Code/Major Product Code Text (TBLRV031) | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 15 | OIU_CM_MAT_PRCD | Material and Product Code (processing) Xref | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 16 | OIU_CM_MKCT | Marketing Cost Type Codes -TBLRV039 | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 17 | OIU_CM_MKCT_TX | Marketing Cost Type Codes - TBLRV039 - Text | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 18 | OIU_CM_PDCD | Product Codes - Tblcm003 | 1 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 19 | OIU_CM_PDCD_TX | Product Codes - Tblcm003 - Text | 2 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 20 | OIU_CM_SEVTGRP | Severance Type Group Table | 2 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 21 | OIU_DO_DOEX | Owner State Tax Exemption | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 22 | OIU_DO_DP | DOI Accounting Information | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 23 | OIU_DO_MKEX | Marketing Cost Exemption Table | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 24 | OIU_DO_TRGRI | Tract Gross Revenue Interest | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 25 | OIU_PR_DNSTH | Delivery Network Status Header | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 26 | OIU_PR_DNTCM | Delivery Network Theoretical Calculation Method | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 27 | OIU_PR_DN_UOMG | Unit of Measure Group | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 28 | OIU_PR_FIELD | Field | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 29 | OIU_PR_HPPNH | Volumetric Historical PPN Header | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 30 | OIU_PR_MPMTD | Measurement point meas. type derivation | 2 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 31 | OIU_PR_PPNH | Prior Period Notification Header | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 32 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 50 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 33 | OIU_PR_WCDHH | Downhole Commingled Well Completion | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 34 | OIU_PR_WCTCM | PRA: Well Completion Theoretical Calculation Method | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 35 | OIU_PR_WVMTD | Well Completion Volumes Measurement Type Determination | 2 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 36 | OIU_RV_CGPT | Contract General Price Terms | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 37 | OIU_RV_CPTR | Contract Product Tax Reimbursement Header | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 38 | OIU_RV_FRML | Valuation Formula Id | 12 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 39 | OIU_RV_MULT_DN | Multiple DN for same well | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 40 | OIU_RV_RVT | Rejected Valuation Transactions | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 41 | OIU_RV_TCLD | Tax Class | 8 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 42 | OIU_RV_VCR | Valuation Cross Reference | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 43 | OIU_RV_VLDP | Valuation Division Order Prior Period Process | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 44 | OIU_RV_VLRPT | Valuation Reporting | 10 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 45 | OIU_RV_VLRVS | Valuation Reversal Notificaton | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 46 | OIU_RV_VLTXNS | Valuation Transactions | 11 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 47 | OIU_RV_VPPN | Valuation Prior Period Notification | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 48 | OIU_RV_VPPNM | Manually Created Valuation Prior Period Notifications | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 49 | OIU_RV_VPPNU | Valuation Prior Period Notification | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 50 | OIU_RV_VXDS | Valuation Cross Reference Date Stamp | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 51 | OIU_SB_ACRD | Allocation Cross Reference Detail | 3 | MAJPD_CD | Major product code 1,2,4 | nvarchar | 1 | 0 | | |
| 52 | OIU_SB_DOIMP | Cross-reference for MP and DOI | 6 | MAJPD_CD | Major product code 1,2,4 | nvarchar | 1 | 0 | | |
| 53 | OIU_SB_DOIWC | DOI/WC Cross Reference | 7 | MAJPD_CD | Major product code 1,2,4 | nvarchar | 1 | 0 | | |
| 54 | OIU_SB_MGDH | Marketing Group Determination Header | 5 | MAJPD_CD | Major product code 1,2,4 | nvarchar | 1 | 0 | | |
| 55 | OIU_SB_MGOPMP | Marketing Group Owner Percent MP | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 56 | OIU_SB_MGOPMP_T | Marketing Group Owner Percent MP | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 57 | OIU_SB_MGOPWC | Marketing Group Owner Percent WC | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 58 | OIU_SB_MGOPWC_T | Marketing Group Owner Percent WC | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| TOPRevenue |
| 59 | OIUHS_JE_DBI | PRA: Destination Code for Posting Rules | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 60 | OIUH_NM_PDCD_XRF | New Mexico Product Code Cross Reference (TBLTR091) | 1 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 61 | OIURV03_CONFIG | MP to Well Completion Split Out Config | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 62 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 14 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 63 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 19 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| TOPRoyalty Reporting |
| 64 | OIUREP_CODE_RDNG | Reg Reporting Rounding Configuration | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 65 | OIUREP_CODE_RULE | Reg Reporting Rules for Column Data | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 66 | OIUREP_CODE_XREF | Reg Reporting Product/Volume Type to Report Code Cross Ref | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 67 | OIUREP_STAT_SPLT | Regulatory Reporting: Well Status Split table | 8 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 68 | OIUREP_UOM | Regulatory Report Unit of Measures | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| TOPTax Reporting |
| 69 | OIUX1_ADJ_TAXHC | Tax adjustments header for reporting | 18 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 70 | OIUX1_TRN_TAXHC | Tax transaction header for reporting | 16 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 71 | OIUX1_TRN_TAXHL | Tax transaction header for reporting | 16 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 72 | OIUX4_RESP_ID | Taxes Payable Responsibility ID | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| TOPValuation |
| 73 | OIURV_CRH_HST | Combined Run Header History | 5 | MAJPD_CD | OIUH_CHAR1 | nvarchar | 1 | 0 | | |
| 74 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 14 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 75 | OIURV_DOC_DTL_RV | Valuation Reversal Notificaton | 10 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 76 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 19 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 77 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 15 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 78 | OIURV_TAXCONFD | State tax configuration detail | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 79 | OIURV_TAXCONFH | State tax configuration header | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 80 | OIURV_TCD | Tax calculation data | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 81 | OIUVL_MTAH | Marketing Cost Tax Exemption - Header | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 82 | OIUVL_RPT | Valuation reporting header | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 83 | OIUVL_SEVCI | Severance tax check input | 6 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 84 | OIUVL_SEVMP | Severance tax measurement point | 7 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 85 | OIUVL_SEVWC | Severance tax well completion | 8 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 86 | OIUVL_STTR | State Tax Rates | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 87 | OIUVL_TCJV | Tax Class - Venture DOI's | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 88 | OIUVL_TCMP | Tax Class Measurement Points | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 89 | OIUVL_TCWC | Tax Class - Well Completion | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 90 | OIUVL_TTRD | Tax Tier Rate - Data | 5 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 91 | OIUVL_TTRPD | Tax Tier Rate by Project - Data | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 92 | OIU_CM_MKT | Marketing types table | 3 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
| 93 | OIU_CM_MKT_TX | Marketing type description table | 4 | MAJPD_CD | Major product code | nvarchar | 1 | 0 | | |
