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 |