| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUREP_PRFL_LOG | Log for master data profile changes | 7 | LEGAL_REPORT_ID | Legal report Identifier for tax and royalty reports | nvarchar | 3 | 0 | | |
2 | OIUX1_RPT_LOG | Tax reporting log table for rpt | 5 | LEGAL_REPORT_ID | Legal report Identifier for tax reports | nvarchar | 3 | 0 | | |
3 | OIUX2_DOWNLOAD | Tax Reporting download table | 5 | LEGAL_REPORT_ID | Legal report Identifier for tax and royalty reports | nvarchar | 3 | 0 | | |
4 | OIUX2_EXEC_STATD | Execution Statistics for Tax Reporting | 6 | LEGAL_REPORT_ID | Legal report Identifier for tax and royalty reports | nvarchar | 3 | 0 | | |
5 | OIUY1_DOWNLOAD | The intermediate table for download | 5 | LEGAL_REPORT_ID | Legal report Identifier for tax and royalty reports | nvarchar | 3 | 0 | | |
6 | OIUY1_EXEC_STATD | Execution Statistics for Royalty Reporting | 6 | LEGAL_REPORT_ID | Legal report Identifier for tax and royalty reports | nvarchar | 3 | 0 | | |
7 | OIUY1_TXDOWNLOAD | The intermediate table for Texas download | 5 | LEGAL_REPORT_ID | Legal report Identifier for tax and royalty reports | nvarchar | 3 | 0 | | |
TOPRoyalty Reporting |
8 | OIUREP_LGL_RPTS | Legal Reports for Tax and Royalty Reporting | 1 | LEGAL_REPORT_ID | Legal report Identifier for tax and royalty reports | nvarchar | 3 | 0 | | |
9 | OIUREP_LGL_RPTTX | Text Table for Legal Reports (Tax and Royalty) | 2 | LEGAL_REPORT_ID | Legal report Identifier for tax and royalty reports | nvarchar | 3 | 0 | | |
10 | OIUREP_RPT_PRFL | Report Profile | 6 | LEGAL_REPORT_ID | Legal report Identifier for tax and royalty reports | nvarchar | 3 | 0 | | |
TOPTax Reporting |
11 | OIUX1_RPT_IDB | Legal report time dependent base table | 4 | LEGAL_REPORT_ID | Legal report Identifier for tax reports | nvarchar | 3 | 0 | | |