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 |