| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8_NM_MKTXRF | Tax 2.0 - NM - Marketing Type Xref | 3 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
2 | OIUY6_WY_MKTXRF | Royalty 2.0 - WY - Marketing Type Xref | 3 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
3 | OIUREP_MKTBACKUP | Marketing cost for skipped tax records | 3 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
4 | OIUX1_ARCH_MKTH | Reporting history for marketing costs for reporting | 12 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
5 | OIUX2_PUID_MKTH | Reporting history for marketing costs for reporting | 12 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
TOPRevenue |
6 | OIURV03_TAXMKT | Valuation Tax Marketing Detail | 7 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
TOPTax Reporting |
7 | OIUX1_ADJ_MKTC | Tax adjustments marketing costs for reporting | 9 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
8 | OIUX1_PUID_MKTH | Reporting history for marketing costs for reporting | 12 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
9 | OIUX1_RPT_MKTH | Reporting history for marketing costs for reporting | 3 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
10 | OIUX1_TRN_MKTC | Tax transaction marketing costs for reporting | 9 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
11 | OIUX1_TRN_MKTL | Tax transaction marketing costs for reporting | 9 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
12 | OIUX7_WY_MKT | Tax 2.0 - WYGP Marketing Types | 2 | MKT_TYPE | Tax 2.0 - WYGP Marketing Type | nvarchar | 1 | 0 | | |
13 | OIUX7_WY_MKTOVR | Tax 2.0 - WYGP Marketing Type Xref Override | 8 | MKT_TYPE | Tax 2.0 - WYGP Marketing Type | nvarchar | 1 | 0 | | |
14 | OIUX7_WY_MKTXRF | Tax 2.0 - WYGP Marketing Type Xref | 4 | MKT_TYPE | Tax 2.0 - WYGP Marketing Type | nvarchar | 1 | 0 | | |
15 | OIUX7_WY_MKT_TX | Tax 2.0 - WYGP Marketing Type Descriptions | 3 | MKT_TYPE | Tax 2.0 - WYGP Marketing Type | nvarchar | 1 | 0 | | |
TOPValuation |
16 | OIURV_DOC_FRMMKT | Valuation Transactions Level 3 - Marketing Detail | 6 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
17 | OIURV_DOC_TAXMKT | Valuation Tax Marketing Detail | 7 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
18 | OIURV_STS_MKT | Severance Tax Statistics - Marketing | 4 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |
19 | OIURV_TCD_MKT | Tax calculation data | 3 | MKT_TYPE | Marketing type code | nvarchar | 2 | 0 | | |