| 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 | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
2 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
3 | OIUX1_ARCH_VOLH | Reported Volume Data by PUID | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
4 | OIUX1_ARCH_XMPH | Reporting history for tax exemptions | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
5 | OIUX1_RPT_LOG | Tax reporting log table for rpt | 7 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
6 | OIUX2_LNK_LOG | Tax Reporting log table for the link | 13 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
7 | OIUX2_PUIDLOG | Tax Reporting PUID log | 7 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
8 | OIUX2_PUID_MKTH | Reporting history for marketing costs for reporting | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
9 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
10 | OIUX2_PUID_XMPH | Reporting history for tax exemptions | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
11 | OIUX2_RE_LOG | Tax Reporting log table for the Log | 12 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
12 | OIUX2_RSG_LOG | Tax reporting log table for rpt | 7 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
TOPRoyalty Reporting |
13 | OIUREP_VL_VOL | Gross Volume and Value after VL/RD | 2 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
TOPTax Reporting |
14 | OIUX1_ADJ_TAXHC | Tax adjustments header for reporting | 2 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
15 | OIUX1_FLD_VALL | Log for field level data | 7 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
16 | OIUX1_PUID_MKTH | Reporting history for marketing costs for reporting | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
17 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
18 | OIUX1_PUID_VOLH | Reported Volume Data by PUID | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
19 | OIUX1_PUID_XMPH | Reporting history for tax exemptions | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
20 | OIUX1_RPT_MSTRL | Log for master data changes | 7 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
21 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
22 | OIUX1_RPT_VOLH | Reported Volume Data by Reporting Entities | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
23 | OIUX1_TAX_SUSP | Records for suspension | 11 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
24 | OIUX2_BA_LOG | Cross ref. betwn PRA prod/purchaser no. and its tax payer | 7 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |
25 | OIUX2_PUID_VOLH | Reported Volume Data by PUID | 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | | |