Tables with fields of type OIUREP_ROY_AGENCY
The data element OIUREP_ROY_AGENCY is used by fields in the following tables.
| | | |
|---|
| /PRA/XTRCT_ROY | New Royalty Engine - Royalty Extraction - Main | /PRA/TP | Tax Payable |
| /PRA/XTRCT_ROY_D | New Royalty Engine - Royalty Extraction - Deducts | /PRA/TP | Tax Payable |
| /PRA/XTRCT_ROY_M | New Royalty Engine - Royalty Extraction - Mkting Costs | /PRA/TP | Tax Payable |
| /PRA/XTRCT_ROY_T | New Royalty Engine - Royalty Extraction - Taxes | /PRA/TP | Tax Payable |
| OIUREP_ARCROYHIS | Archived Reported Royalty and Volume Data | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUREP_ENTTY_LOG | Log table for master data entity changes | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUREP_OWNER_LOG | Log for master Data Owner Changes | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUREP_PRFL_LOG | Log for master data profile changes | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUREP_ZERO_REJS | Rejection Criteria for Zero volume records | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUY1_DOWNLOAD | The intermediate table for download | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUY1_EXEC_STATD | Execution Statistics for Royalty Reporting | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUY1_TXDOWNLOAD | The intermediate table for Texas download | OIU | PRA Production and Revenue Accounting (Upstream Business) |
| OIUREP_AGY_LSE | Agency assigned Leases | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_AGY_LSETX | Text Table for Agency assigned Leases | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_AGY_PCDTX | Agency defined Product Code Text | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_AGY_PDCD | Agency defined Product Code | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_AGY_VLTP | Agency defined Volume Types | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_AGY_VTPTX | Text table for Agency defined Volume Type | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_AMND_STAT | Report Execution statistics for amended months | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_EXEC_COMB | Possible Combinations of Royalty Executions | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_EXEC_STAT | Report Execution Statistics | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_EXT_COMP | External Company by State Agency | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_EXT_COMTX | Text Table for External Company Code | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_LGL_RPTS | Legal Reports for Tax and Royalty Reporting | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_PDCD_XREF | Cross Reference Between State Agency and PRA Material | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_ROY_AGY | Reporting Agencies for Tax and Royalty | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_ROY_AGYTX | Regulatory Reporting Agencies | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_ROY_LOG | Changes to master data for reporting | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_RPT_ENTTY | Entities for Royalty Reporting | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_RPT_OWNER | Owners for royalty reporting | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_RPT_PRFL | Report Profile | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_TAB_IND | Agency related fields for master data maintainence | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_VLTP_XREF | Cross reference between Agency defined & PRA volume types | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_VOL_DATA | Reported Volume Data by Reporting Entities | OIU_REP | Production, Tax & Royalty Reporting |
| OIUREP_XTRCT_ROY | Extract Royaty Data for the current reporting period | OIU_REP | Production, Tax & Royalty Reporting |
| OIUY1_CAT_CD | Generic Category Code in New Royalty | OIU_Y1 | PRA Royalty Reporting - Migration To New Framework |
| OIUY1_CAT_CDTX | Descriptions for the categories | OIU_Y1 | PRA Royalty Reporting - Migration To New Framework |
| OIUY1_CAT_CD_VAL | Descriptions for the codes | OIU_Y1 | PRA Royalty Reporting - Migration To New Framework |
| OIUY1_GEN_CD_VAL | Maintain Code with Effective Dated | OIU_Y1 | PRA Royalty Reporting - Migration To New Framework |
| OIUY1_REP_HIST | Reported data history | OIU_Y1 | PRA Royalty Reporting - Migration To New Framework |
| OIUX1_PDCD_XREF | Cross Reference Between State Agency and PRA Material | OIU_X1 | PRA Tax Reporting - Tax Reporting Framework |
| OIUX1_VKEY_XREF | Table for variable key in Tax Reporting | OIU_X1 | PRA Tax Reporting - Tax Reporting Framework |