| 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 | 11 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
2 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 11 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
3 | OIUX1_ARCH_XMPH | Reporting history for tax exemptions | 11 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
4 | OIUX2_PUID_MKTH | Reporting history for marketing costs for reporting | 11 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
5 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 11 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
6 | OIUX2_PUID_XMPH | Reporting history for tax exemptions | 11 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
TOPTax Reporting |
7 | OIUX1_ADJ_MKTC | Tax adjustments marketing costs for reporting | 8 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
8 | OIUX1_ADJ_TAXDC | Tax adjustments detail for reporting | 8 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
9 | OIUX1_ADJ_XMPC | Tax adjustment exemptions for reporting | 8 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
10 | OIUX1_PUID_MKTH | Reporting history for marketing costs for reporting | 11 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
11 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 11 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
12 | OIUX1_PUID_XMPH | Reporting history for tax exemptions | 11 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
13 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 16 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
14 | OIUX1_TRN_MKTC | Tax transaction marketing costs for reporting | 8 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
15 | OIUX1_TRN_MKTL | Tax transaction marketing costs for reporting | 8 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
16 | OIUX1_TRN_TAXDC | Tax transaction detail for reporting | 8 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
17 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 8 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
18 | OIUX1_TRN_XMPC | Tax transaction exemptions for reporting | 8 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |
19 | OIUX1_TRN_XMPL | Tax transaction exemptions for reporting | 8 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | | |