| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUX1_ARCH_MKTH | Reporting history for marketing costs for reporting | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
2 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
3 | OIUX1_ARCH_VOLH | Reported Volume Data by PUID | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
4 | OIUX1_ARCH_XMPH | Reporting history for tax exemptions | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
5 | OIUX1_RPT_LOG | Tax reporting log table for rpt | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
6 | OIUX2_DOWNLOAD | Tax Reporting download table | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
7 | OIUX2_EXEC_STATD | Execution Statistics for Tax Reporting | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
8 | OIUX2_LNK_LOG | Tax Reporting log table for the link | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
9 | OIUX2_PUIDLOG | Tax Reporting PUID log | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
10 | OIUX2_PUID_MKTH | Reporting history for marketing costs for reporting | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
11 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
12 | OIUX2_PUID_XMPH | Reporting history for tax exemptions | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
13 | OIUX2_RE_LOG | Tax Reporting log table for the Log | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
14 | OIUX2_RSG_LOG | Tax reporting log table for rpt | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
TOPTax Reporting |
15 | OIUX1_ADJ_TAXHC | Tax adjustments header for reporting | 14 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
16 | OIUX1_EXEC_COMB | Execution Combinations for Tax Reporting | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
17 | OIUX1_EXEC_STAT | Execution Statistics for Tax Reporting | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
18 | OIUX1_FLD_VALB | Base table for field level data | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
19 | OIUX1_FLD_VALL | Log for field level data | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
20 | OIUX1_LNK_REPUB | PUID and reporting entities link | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
21 | OIUX1_MAS_REB | Reporting entities base table | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
22 | OIUX1_PRD_UIDB | Base table for Production Units/Leases | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
23 | OIUX1_PROC_CNTRL | Reporting process control table | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
24 | OIUX1_PUID_MKTH | Reporting history for marketing costs for reporting | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
25 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
26 | OIUX1_PUID_VOLH | Reported Volume Data by PUID | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
27 | OIUX1_PUID_XMPH | Reporting history for tax exemptions | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
28 | OIUX1_RPT_MKTH | Reporting history for marketing costs for reporting | 9 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
29 | OIUX1_RPT_MSTRL | Log for master data changes | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
30 | OIUX1_RPT_SGB | Report Submission Group base table | 4 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
31 | OIUX1_RPT_SGRP | Report Submission Group | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
32 | OIUX1_RPT_SGRPTX | Text table for Report Submission Group | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
33 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
34 | OIUX1_RPT_VOLH | Reported Volume Data by Reporting Entities | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
35 | OIUX1_RPT_XMPH | Reporting history for tax exemptions | 9 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
36 | OIUX1_TAX_SUSP | Records for suspension | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
37 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 32 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
38 | OIUX1_TRN_TAXHL | Tax transaction header for reporting | 28 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
39 | OIUX2_BA_LOG | Cross ref. betwn PRA prod/purchaser no. and its tax payer | 2 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |
40 | OIUX2_PUID_VOLH | Reported Volume Data by PUID | 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | | |