| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRevenue |
1 | OIURV03_TAXDTL | Valuation Tax Master Detail | 34 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
TOPTax Reporting |
2 | OIUX1_ADJ_MKTC | Tax adjustments marketing costs for reporting | 6 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
3 | OIUX1_ADJ_TAXDC | Tax adjustments detail for reporting | 6 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
4 | OIUX1_ADJ_XMPC | Tax adjustment exemptions for reporting | 6 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
5 | OIUX1_TRN_MKTC | Tax transaction marketing costs for reporting | 6 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
6 | OIUX1_TRN_MKTL | Tax transaction marketing costs for reporting | 6 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
7 | OIUX1_TRN_TAXDC | Tax transaction detail for reporting | 6 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
8 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 6 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
9 | OIUX1_TRN_XMPC | Tax transaction exemptions for reporting | 6 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
10 | OIUX1_TRN_XMPL | Tax transaction exemptions for reporting | 6 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
11 | OIUX1_TXCD_XREF | Cross reference between state tax codes and PRA entities | 8 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |
12 | OIUX3_TX_OOSHST | Tax Reporting - Texas Out Of Statute Transaction History | 15 | TIER_TAX_IND | Tier Tax | nvarchar | 1 | 0 | | |
13 | OIUX3_TX_OOSTXN | Tax Reporting - Texas Out Of Statute Transactions | 15 | TIER_TAX_IND | Tier Tax | nvarchar | 1 | 0 | | |
14 | OIUX3_TX_TAXHST | Tax Reporting - Texas Tax History Transactions | 15 | TIER_TAX_IND | Tier Tax | nvarchar | 1 | 0 | | |
15 | OIUX3_TX_TAXSTG | Tax Reporting - Texas Tax Transaction Staging | 15 | TIER_TAX_IND | Tier Tax | nvarchar | 1 | 0 | | |
16 | OIUX3_TX_TAXTXN | Tax Reporting - Texas Tax Transactions | 15 | TIER_TAX_IND | Tier Tax | nvarchar | 1 | 0 | | |
TOPValuation |
17 | OIURV_DOC_TAXDTL | Valuation Tax Master Detail | 34 | TIER_TAX_IND | Tier tax indicator | nvarchar | 1 | 0 | | |