| Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Reporting :: Royalty Reporting |
| Product | Version | Table | Columns | Indexes | Description | Module |
|---|
| 1 | ERP EHP7 | 6.0 | OIUH_TEMP_GL | 42 | 1 | Journal Entry General Ledger Table | Royalty Reporting |
| 2 | ERP EHP7 | 6.0 | OIUH_TEMP_OPSL | 52 | 1 | Journal Entry Owner Payable Subledger Table | Royalty Reporting |
| 3 | ERP EHP7 | 6.0 | OIUREPP_LEASE | 19 | 1 | MMS-2014 - Lease PPA | Royalty Reporting |
| 4 | ERP EHP7 | 6.0 | OIUREPP_OWNER | 13 | 1 | MMS-2014 - Owner PPA | Royalty Reporting |
| 5 | ERP EHP7 | 6.0 | OIUREPP_PRPAYXRF | 14 | 1 | MMS-2014 - Property / Payor XRef PPA | Royalty Reporting |
| 6 | ERP EHP7 | 6.0 | OIUREPP_SALETYPE | 20 | 1 | MMS-2014 - Sales Type PPA | Royalty Reporting |
| 7 | ERP EHP7 | 6.0 | OIUREPP_WCPAYXRF | 13 | 1 | MMS-2014 - Well Completion / Payor XRef PPA | Royalty Reporting |
| 8 | ERP EHP7 | 6.0 | OIUREP_2014_CONF | 3 | 1 | MMS-2014: Configurable Items | Royalty Reporting |
| 9 | ERP EHP7 | 6.0 | OIUREP_2014_INFO | 30 | 1 | MMS-2014 - Report Executions Start information | Royalty Reporting |
| 10 | ERP EHP7 | 6.0 | OIUREP_2014_REP | 53 | 1 | MMS-2014 - Supplemental Reports From Report Executions | Royalty Reporting |
| 11 | ERP EHP7 | 6.0 | OIUREP_2014_RUNS | 24 | 2 | MMS-2014 - Report Executions | Royalty Reporting |
| 12 | ERP EHP7 | 6.0 | OIUREP_ACTIVATE | 7 | 1 | Reg./Tax and Royalty Reporting - report activation | Royalty Reporting |
| 13 | ERP EHP7 | 6.0 | OIUREP_ADD_DATA | 9 | 1 | Regulatory Reporting Config for Additional Master Data | Royalty Reporting |
| 14 | ERP EHP7 | 6.0 | OIUREP_ADJCD_XRF | 3 | 1 | MMS-2014 - Reversal Rsn to Adjustment Reason Code XREF | Royalty Reporting |
| 15 | ERP EHP7 | 6.0 | OIUREP_ADJ_DTLA | 22 | 1 | MMS OGOR A Adjustment Detail Record | Royalty Reporting |
| 16 | ERP EHP7 | 6.0 | OIUREP_ADJ_DTLB | 21 | 1 | MMS OGOR B Adjustment Detail Record | Royalty Reporting |
| 17 | ERP EHP7 | 6.0 | OIUREP_ADJ_DTLC | 23 | 1 | MMS OGOR C Adjustment Detail Record | Royalty Reporting |
| 18 | ERP EHP7 | 6.0 | OIUREP_ADJ_HDR | 20 | 1 | Adjustment Header for MMS OGOR | Royalty Reporting |
| 19 | ERP EHP7 | 6.0 | OIUREP_ADJ_PASR | 19 | 1 | MMS PASR Adjustment Detail Record | Royalty Reporting |
| 20 | ERP EHP7 | 6.0 | OIUREP_ADJ_PASRH | 22 | 1 | MMS PASR Adjustment Header Record | Royalty Reporting |
| 21 | ERP EHP7 | 6.0 | OIUREP_AGENCIES | 3 | 1 | Regulatory Reporting Agencies | Royalty Reporting |
| 22 | ERP EHP7 | 6.0 | OIUREP_AGENCYTX | 3 | 1 | Regulatory Reporting Agencies | Royalty Reporting |
| 23 | ERP EHP7 | 6.0 | OIUREP_AGY_LSE | 29 | 1 | Agency assigned Leases | Royalty Reporting |
| 24 | ERP EHP7 | 6.0 | OIUREP_AGY_LSETX | 5 | 1 | Text Table for Agency assigned Leases | Royalty Reporting |
| 25 | ERP EHP7 | 6.0 | OIUREP_AGY_PCDTX | 4 | 1 | Agency defined Product Code Text | Royalty Reporting |
| 26 | ERP EHP7 | 6.0 | OIUREP_AGY_PDCD | 9 | 1 | Agency defined Product Code | Royalty Reporting |
| 27 | ERP EHP7 | 6.0 | OIUREP_AGY_VLTP | 4 | 1 | Agency defined Volume Types | Royalty Reporting |
| 28 | ERP EHP7 | 6.0 | OIUREP_AGY_VTPTX | 4 | 1 | Text table for Agency defined Volume Type | Royalty Reporting |
| 29 | ERP EHP7 | 6.0 | OIUREP_AMND_STAT | 9 | 1 | Report Execution statistics for amended months | Royalty Reporting |
| 30 | ERP EHP7 | 6.0 | OIUREP_BA_MASTER | 9 | 1 | Regulatory reporting: BA table to drive Partner reporting | Royalty Reporting |
| 31 | ERP EHP7 | 6.0 | OIUREP_CM_JIL | 3 | 1 | Activate JIL control table | Royalty Reporting |
| 32 | ERP EHP7 | 6.0 | OIUREP_CODE_CMLB | 7 | 1 | Regulatory Reporting Common Table List Box Setup | Royalty Reporting |
| 33 | ERP EHP7 | 6.0 | OIUREP_CODE_COMA | 10 | 1 | Common table to convert SAP codes to Ag. codes Apl.Table | Royalty Reporting |
| 34 | ERP EHP7 | 6.0 | OIUREP_CODE_COMN | 10 | 1 | Common table for converting SAP codes to Agency codes | Royalty Reporting |
| 35 | ERP EHP7 | 6.0 | OIUREP_CODE_FLDS | 4 | 1 | Fields available for customizing | Royalty Reporting |
| 36 | ERP EHP7 | 6.0 | OIUREP_CODE_FLDT | 6 | 1 | Descriptions for Code Fields | Royalty Reporting |
| 37 | ERP EHP7 | 6.0 | OIUREP_CODE_RDNG | 11 | 1 | Reg Reporting Rounding Configuration | Royalty Reporting |
| 38 | ERP EHP7 | 6.0 | OIUREP_CODE_RPTC | 4 | 1 | Report Columns available for customizing | Royalty Reporting |
| 39 | ERP EHP7 | 6.0 | OIUREP_CODE_RULE | 10 | 1 | Reg Reporting Rules for Column Data | Royalty Reporting |
| 40 | ERP EHP7 | 6.0 | OIUREP_CODE_VALS | 5 | 1 | Code Values available for customizing Reg Reporting | Royalty Reporting |
| 41 | ERP EHP7 | 6.0 | OIUREP_CODE_VLTX | 7 | 1 | Code Value Texts | Royalty Reporting |
| 42 | ERP EHP7 | 6.0 | OIUREP_CODE_XREF | 19 | 1 | Reg Reporting Product/Volume Type to Report Code Cross Ref | Royalty Reporting |
| 43 | ERP EHP7 | 6.0 | OIUREP_COMN_KEYS | 6 | 1 | Reg.Reporting - Field description for COMN table keys | Royalty Reporting |
| 44 | ERP EHP7 | 6.0 | OIUREP_DD_STRUCT | 6 | 1 | Master DD file structures | Royalty Reporting |
| 45 | ERP EHP7 | 6.0 | OIUREP_DN_XREF | 6 | 1 | Regulatory Reporting X-ref for Delivery Networks | Royalty Reporting |
| 46 | ERP EHP7 | 6.0 | OIUREP_EXEC_COMB | 17 | 1 | Possible Combinations of Royalty Executions | Royalty Reporting |
| 47 | ERP EHP7 | 6.0 | OIUREP_EXEC_STAT | 25 | 2 | Report Execution Statistics | Royalty Reporting |
| 48 | ERP EHP7 | 6.0 | OIUREP_EXT_COMP | 3 | 1 | External Company by State Agency | Royalty Reporting |
| 49 | ERP EHP7 | 6.0 | OIUREP_EXT_COMTX | 5 | 1 | Text Table for External Company Code | Royalty Reporting |
| 50 | ERP EHP7 | 6.0 | OIUREP_FEDINDIAN | 3 | 1 | MMS-2014 - Federal or Indian Leases | Royalty Reporting |
| 51 | ERP EHP7 | 6.0 | OIUREP_FIELDS | 15 | 1 | Regulatory Report Master Data set up | Royalty Reporting |
| 52 | ERP EHP7 | 6.0 | OIUREP_FIELDSTX | 7 | 1 | Regulatory Report Master Data set up | Royalty Reporting |
| 53 | ERP EHP7 | 6.0 | OIUREP_FIN_LEVEL | 8 | 1 | Regulatory Reporting Operator and Contact Xref | Royalty Reporting |
| 54 | ERP EHP7 | 6.0 | OIUREP_GEN_DATA | 16 | 1 | Reg. Reporting - Generic Transactional data | Royalty Reporting |
| 55 | ERP EHP7 | 6.0 | OIUREP_HISTCNTRL | 7 | 1 | Regulatory Reporting History Control table | Royalty Reporting |
| 56 | ERP EHP7 | 6.0 | OIUREP_INDIAN_TR | 3 | 1 | MMS-2014 - Indian Tribes | Royalty Reporting |
| 57 | ERP EHP7 | 6.0 | OIUREP_KEY_XREFD | 7 | 1 | Regulatory Reporting SAP Key Cross Reference Detail | Royalty Reporting |
| 58 | ERP EHP7 | 6.0 | OIUREP_KEY_XREFH | 7 | 1 | Regulatory Reporting SAP Key Cross Reference Header | Royalty Reporting |
| 59 | ERP EHP7 | 6.0 | OIUREP_LEASE | 19 | 2 | MMS-2014 - Lease | Royalty Reporting |
| 60 | ERP EHP7 | 6.0 | OIUREP_LGL_RPTS | 26 | 1 | Legal Reports for Tax and Royalty Reporting | Royalty Reporting |
| 61 | ERP EHP7 | 6.0 | OIUREP_LGL_RPTTX | 3 | 1 | Text Table for Legal Reports (Tax and Royalty) | Royalty Reporting |
| 62 | ERP EHP7 | 6.0 | OIUREP_MASTER | 81 | 1 | Regulatory Reporting Master Data | Royalty Reporting |
| 63 | ERP EHP7 | 6.0 | OIUREP_MASTER_MP | 27 | 1 | Re.Reporting - MP related Reg ID | Royalty Reporting |
| 64 | ERP EHP7 | 6.0 | OIUREP_MASTER_OV | 4 | 1 | RegID Split table (e.g. MMS Override Group split) | Royalty Reporting |
| 65 | ERP EHP7 | 6.0 | OIUREP_MASTER_PC | 4 | 1 | RegID Split table (e.g. LA Parish split) | Royalty Reporting |
| 66 | ERP EHP7 | 6.0 | OIUREP_MMS_ACTN | 4 | 1 | MMS Well Status Reason Code/Action Code Combos (OGOR-A) | Royalty Reporting |
| 67 | ERP EHP7 | 6.0 | OIUREP_MMS_DTEDT | 4 | 1 | MMS-2014 Edit Effective Date Table | Royalty Reporting |
| 68 | ERP EHP7 | 6.0 | OIUREP_MMS_REAS | 4 | 1 | MMS Well Status / Reason Code Combinations (OGOR-A) | Royalty Reporting |
| 69 | ERP EHP7 | 6.0 | OIUREP_MMS_REJS | 95 | 1 | MMS-2014 - Extraction Rejects | Royalty Reporting |
| 70 | ERP EHP7 | 6.0 | OIUREP_MP_XREF | 8 | 1 | Regulatory Reporting X-ref - MP to State Assigned ID | Royalty Reporting |
| 71 | ERP EHP7 | 6.0 | OIUREP_MRT_CRED | 10 | 1 | MMS-2014: Credits Against Monthly Report | Royalty Reporting |
| 72 | ERP EHP7 | 6.0 | OIUREP_MRT_HIST | 39 | 3 | MMS-2014 MMS Royalty Transaction Processed History | Royalty Reporting |
| 73 | ERP EHP7 | 6.0 | OIUREP_MRT_PEND | 39 | 2 | MMS-2014 MMS Royalty Transaction Processed - Pending | Royalty Reporting |
| 74 | ERP EHP7 | 6.0 | OIUREP_OWNER | 13 | 1 | MMS-2014 - Owner | Royalty Reporting |
| 75 | ERP EHP7 | 6.0 | OIUREP_PAYOR | 4 | 1 | MMS-2014 - Payor / Company Code XRef | Royalty Reporting |
| 76 | ERP EHP7 | 6.0 | OIUREP_PDCD_XREF | 6 | 1 | Cross Reference Between State Agency and PRA Material | Royalty Reporting |
| 77 | ERP EHP7 | 6.0 | OIUREP_PRDCDXREF | 3 | 1 | MMS: Possible Material No/MMS Prod Cd Combinations | Royalty Reporting |
| 78 | ERP EHP7 | 6.0 | OIUREP_PROWNERS | 5 | 1 | MMS-2014 - Property w/ Multiple Owners? | Royalty Reporting |
| 79 | ERP EHP7 | 6.0 | OIUREP_PRPAYXREF | 14 | 2 | MMS-2014 - Property / Payor XRef | Royalty Reporting |
| 80 | ERP EHP7 | 6.0 | OIUREP_RECOUP | 10 | 1 | MMS-2014 - Recoupable Balance | Royalty Reporting |
| 81 | ERP EHP7 | 6.0 | OIUREP_REG_HIST | 13 | 1 | Reporting history (System table INDX) | Royalty Reporting |
| 82 | ERP EHP7 | 6.0 | OIUREP_REG_OPER | 12 | 1 | Regulatory Reporting Operator and Contact Xref EFF Dated | Royalty Reporting |
| 83 | ERP EHP7 | 6.0 | OIUREP_REG_OPERA | 10 | 1 | Regulatory Reporting Operator and Contact Xref | Royalty Reporting |
| 84 | ERP EHP7 | 6.0 | OIUREP_REG_OUT | 9 | 1 | Regulatory Reporting Output Control | Royalty Reporting |
| 85 | ERP EHP7 | 6.0 | OIUREP_REPORTS | 17 | 1 | Supported Regulatory reports | Royalty Reporting |
| 86 | ERP EHP7 | 6.0 | OIUREP_REPORTSTX | 4 | 1 | Supported Regulatory reports | Royalty Reporting |
| 87 | ERP EHP7 | 6.0 | OIUREP_ROYHIST | 33 | 2 | Reported Royalty and Volume Data by Reporting Entities | Royalty Reporting |
| 88 | ERP EHP7 | 6.0 | OIUREP_ROY_AGY | 27 | 1 | Reporting Agencies for Tax and Royalty | Royalty Reporting |
| 89 | ERP EHP7 | 6.0 | OIUREP_ROY_AGYTX | 3 | 1 | Regulatory Reporting Agencies | Royalty Reporting |
| 90 | ERP EHP7 | 6.0 | OIUREP_ROY_DATA | 37 | 4 | Reported Royalty and Volume Data by Reporting Entities | Royalty Reporting |
| 91 | ERP EHP7 | 6.0 | OIUREP_ROY_FLDTX | 4 | 1 | Text Table for Report Fields | Royalty Reporting |
| 92 | ERP EHP7 | 6.0 | OIUREP_ROY_LOG | 13 | 1 | Changes to master data for reporting | Royalty Reporting |
| 93 | ERP EHP7 | 6.0 | OIUREP_ROY_PRFL | 16 | 1 | Royalty Reporting Profiles | Royalty Reporting |
| 94 | ERP EHP7 | 6.0 | OIUREP_ROY_PRFLD | 10 | 1 | Field Values in the Royalty Reporting Profiles | Royalty Reporting |
| 95 | ERP EHP7 | 6.0 | OIUREP_RPT_ENTTY | 19 | 2 | Entities for Royalty Reporting | Royalty Reporting |
| 96 | ERP EHP7 | 6.0 | OIUREP_RPT_OWNER | 8 | 1 | Owners for royalty reporting | Royalty Reporting |
| 97 | ERP EHP7 | 6.0 | OIUREP_RPT_PRFL | 9 | 1 | Report Profile | Royalty Reporting |
| 98 | ERP EHP7 | 6.0 | OIUREP_RRST | 27 | 1 | Regulatory Reporting Status Table | Royalty Reporting |
| 99 | ERP EHP7 | 6.0 | OIUREP_RRST_DET | 8 | 1 | Regulatory Reporting Status Table | Royalty Reporting |
| 100 | ERP EHP7 | 6.0 | OIUREP_RRST_NEW | 28 | 1 | NEW Regulatory Reporting Status Table (with Version Number) | Royalty Reporting |
| 101 | ERP EHP7 | 6.0 | OIUREP_RTPEND | 94 | 1 | MMS-2014 - Royalty Transaction Pending | Royalty Reporting |
| 102 | ERP EHP7 | 6.0 | OIUREP_RT_HIST | 94 | 2 | MMS-2014 - Royalty Transaction (Pending) History | Royalty Reporting |
| 103 | ERP EHP7 | 6.0 | OIUREP_RUNGRPKEY | 2 | 1 | Reg.Reporting - Report Submission groups | Royalty Reporting |
| 104 | ERP EHP7 | 6.0 | OIUREP_RUN_GROUP | 4 | 1 | Reg.Reporting - Report Submission grouping | Royalty Reporting |
| 105 | ERP EHP7 | 6.0 | OIUREP_RUN_REPNM | 2 | 1 | Reg.Reporting - Report run/submission names | Royalty Reporting |
| 106 | ERP EHP7 | 6.0 | OIUREP_RWC | 14 | 1 | WCs that have been changed since previous report run | Royalty Reporting |
| 107 | ERP EHP7 | 6.0 | OIUREP_SALESTY | 2 | 1 | MMS-2014: Sales Type Control Table | Royalty Reporting |
| 108 | ERP EHP7 | 6.0 | OIUREP_SALESTYPE | 20 | 1 | MMS-2014 - Sales Type | Royalty Reporting |
| 109 | ERP EHP7 | 6.0 | OIUREP_SALESTY_T | 4 | 1 | MMS-2014: Sales Type Control Table Description | Royalty Reporting |
| 110 | ERP EHP7 | 6.0 | OIUREP_STAT_SPLT | 11 | 1 | Regulatory Reporting: Well Status Split table | Royalty Reporting |
| 111 | ERP EHP7 | 6.0 | OIUREP_STRUC | 9 | 1 | Regulatory Reporting Structures | Royalty Reporting |
| 112 | ERP EHP7 | 6.0 | OIUREP_STRUCTX | 6 | 1 | Regulatory Reporting Structures | Royalty Reporting |
| 113 | ERP EHP7 | 6.0 | OIUREP_SUPL_REP | 5 | 1 | MMS-2014 - Supplemental Reports | Royalty Reporting |
| 114 | ERP EHP7 | 6.0 | OIUREP_SUPL_REPT | 5 | 1 | MMS-2014 - Supplemental Reports Description | Royalty Reporting |
| 115 | ERP EHP7 | 6.0 | OIUREP_TAB_IND | 5 | 1 | Agency related fields for master data maintainence | Royalty Reporting |
| 116 | ERP EHP7 | 6.0 | OIUREP_TEXT_STDD | 6 | 1 | Regulatory Reporting Standard Texts Detail | Royalty Reporting |
| 117 | ERP EHP7 | 6.0 | OIUREP_TEXT_STDH | 4 | 1 | Regulatory Reporting Valid Standard Texts Header | Royalty Reporting |
| 118 | ERP EHP7 | 6.0 | OIUREP_TEXT_XREF | 10 | 1 | Regulatory Reporting Texts for Diff Reporting Levels | Royalty Reporting |
| 119 | ERP EHP7 | 6.0 | OIUREP_TRAN_ERR | 2 | 1 | Transaction code to error code xref for edits/vals | Royalty Reporting |
| 120 | ERP EHP7 | 6.0 | OIUREP_TRAN_FLDS | 3 | 1 | MMS-2014 - Transaction Code Field Requirement XREF | Royalty Reporting |
| 121 | ERP EHP7 | 6.0 | OIUREP_UOM | 7 | 1 | Regulatory Report Unit of Measures | Royalty Reporting |
| 122 | ERP EHP7 | 6.0 | OIUREP_VALTABC | 5 | 1 | Reporting general value table - Customizing | Royalty Reporting |
| 123 | ERP EHP7 | 6.0 | OIUREP_VALTABCTX | 7 | 1 | Reporting general value table - Customizing | Royalty Reporting |
| 124 | ERP EHP7 | 6.0 | OIUREP_VALTABM | 6 | 1 | Reporting general value table - Customizing | Royalty Reporting |
| 125 | ERP EHP7 | 6.0 | OIUREP_VLTP_XREF | 4 | 1 | Cross reference between Agency defined & PRA volume types | Royalty Reporting |
| 126 | ERP EHP7 | 6.0 | OIUREP_VL_VOL | 21 | 1 | Gross Volume and Value after VL/RD | Royalty Reporting |
| 127 | ERP EHP7 | 6.0 | OIUREP_VOLHIST | 19 | 2 | Reported Volume Data by Reporting Entities | Royalty Reporting |
| 128 | ERP EHP7 | 6.0 | OIUREP_VOL_DATA | 23 | 4 | Reported Volume Data by Reporting Entities | Royalty Reporting |
| 129 | ERP EHP7 | 6.0 | OIUREP_WCOWNERS | 4 | 1 | MMS-2014 - Well Completion w/ Multiple Owners | Royalty Reporting |
| 130 | ERP EHP7 | 6.0 | OIUREP_WCPAYXREF | 13 | 2 | MMS-2014 - Well Completion / Payor XRef | Royalty Reporting |
| 131 | ERP EHP7 | 6.0 | OIUREP_XTRCT_ROY | 146 | 1 | Extract Royaty Data for the current reporting period | Royalty Reporting |
| 132 | ERP EHP7 | 6.0 | OIUY1_CAT_CD | 2 | 1 | Generic Category Code in New Royalty | Royalty Reporting |
| 133 | ERP EHP7 | 6.0 | OIUY1_CAT_CDTX | 4 | 1 | Descriptions for the categories | Royalty Reporting |
| 134 | ERP EHP7 | 6.0 | OIUY1_CAT_CD_VAL | 5 | 1 | Descriptions for the codes | Royalty Reporting |
| 135 | ERP EHP7 | 6.0 | OIUY1_GEN_CD_VAL | 8 | 1 | Maintain Code with Effective Dated | Royalty Reporting |
| 136 | ERP EHP7 | 6.0 | OIUY1_REP_HIST | 8 | 1 | Reported data history | Royalty Reporting |
