| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTax Reporting |
1 | OIUX3_TX_COMXRF | Tax Reporting - Texas Commodity XRef | 4 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
2 | OIUX3_TX_OOSHST | Tax Reporting - Texas Out Of Statute Transaction History | 45 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
3 | OIUX3_TX_OOSTXN | Tax Reporting - Texas Out Of Statute Transactions | 45 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
4 | OIUX3_TX_PRDTB | Tax Reporting - Texas PRA Detail Txns-Tier Tax Below | 46 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
5 | OIUX3_TX_PRDTI | Tax Reporting - Texas PRA Detail Txns-Tier Tax Incremental | 46 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
6 | OIUX3_TX_PRDTN | Tax Reporting - Texas PRA Detail Txns - No Tier Tax | 46 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
7 | OIUX3_TX_RPGDT | Tax Reporting - Texas Gas Report Details | 6 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
8 | OIUX3_TX_RPGDTE | Tax Reporting - Texas Gas Report Details Errors | 6 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
9 | OIUX3_TX_TAXHST | Tax Reporting - Texas Tax History Transactions | 45 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
10 | OIUX3_TX_TAXSTG | Tax Reporting - Texas Tax Transaction Staging | 45 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
11 | OIUX3_TX_TAXTXN | Tax Reporting - Texas Tax Transactions | 45 | COMMODITY_TYPE | Texas Commodity Type | nvarchar | 3 | 0 | | |
TOPTransaction Manager |
12 | TRCOC_CTY_TYPE | Commodity type | 2 | COMMODITY_TYPE | Type of Commodity | nvarchar | 3 | 0 | | |
13 | TRCOC_CTY_TYPE_T | Commodity type text | 3 | COMMODITY_TYPE | Type of Commodity | nvarchar | 3 | 0 | | |
14 | TRCOT_CTY_MASTER | Commodity master data | 4 | COMMODITY_TYPE | Type of Commodity | nvarchar | 3 | 0 | | |