| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8_NM_TAXDTL | Tax 2.0 - New Mexico Tax Details | 15 | TAX_AMT | Actual state tax amount | decimal | 15 | 2 | | |
TOPFinancial Accounting |
2 | FOTRFDITM | VAT Refund Items | 38 | TAX_AMT | Tax Amount in Document Currency | decimal | 15 | 2 | | |
3 | FOTRFDITMCHG | Change Documents, VAT Refund Item | 13 | TAX_AMT | Tax Amount in Document Currency | decimal | 15 | 2 | | |
TOPProduction and Revenue Accounting |
4 | OIUREP_ARCROYHIS | Archived Reported Royalty and Volume Data | 19 | TAX_AMT | Deduction Amount | decimal | 11 | 2 | | |
5 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 19 | TAX_AMT | Deduction Amount | decimal | 11 | 2 | | |
TOPRoyalty Reporting |
6 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 57 | TAX_AMT | Production: MMS-2014 - Tax Amount | decimal | 15 | 2 | | |
7 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 19 | TAX_AMT | Deduction Amount | decimal | 11 | 2 | | |
8 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 23 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
9 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 56 | TAX_AMT | Production: MMS-2014 - Tax Amount | decimal | 15 | 2 | | |
10 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 56 | TAX_AMT | Production: MMS-2014 - Tax Amount | decimal | 15 | 2 | | |
TOPTax Reporting |
11 | OIUX3_TX_OOSHST | Tax Reporting - Texas Out Of Statute Transaction History | 31 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
12 | OIUX3_TX_OOSTXN | Tax Reporting - Texas Out Of Statute Transactions | 31 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
13 | OIUX3_TX_PRDTB | Tax Reporting - Texas PRA Detail Txns-Tier Tax Below | 32 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
14 | OIUX3_TX_PRDTI | Tax Reporting - Texas PRA Detail Txns-Tier Tax Incremental | 32 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
15 | OIUX3_TX_PRDTN | Tax Reporting - Texas PRA Detail Txns - No Tier Tax | 32 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
16 | OIUX3_TX_TAXHST | Tax Reporting - Texas Tax History Transactions | 31 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
17 | OIUX3_TX_TAXSTG | Tax Reporting - Texas Tax Transaction Staging | 31 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
18 | OIUX3_TX_TAXTXN | Tax Reporting - Texas Tax Transactions | 31 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
19 | OIUX6_WY_COOSHST | Tax 2.0 - Wyoming Out Of Statute Conservation Trans Hist | 24 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
20 | OIUX6_WY_COOSTXN | Tax 2.0 - Wyoming Out Of Statute Conservation Transactions | 24 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
21 | OIUX6_WY_CPRDT | Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions | 26 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
22 | OIUX6_WY_CTAXHST | Tax 2.0 - Wyoming Conservation Tax Transactions History | 24 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
23 | OIUX6_WY_CTAXSTG | Tax 2.0 - Wyoming Conservation Tax Transactions Staging | 24 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
24 | OIUX6_WY_CTAXTXN | Tax 2.0 - Wyoming Conservation Tax Transactions | 24 | TAX_AMT | Tax Amount | decimal | 11 | 2 | | |
TOPValuation |
25 | OIURV_SSTD_TAX | Settlement statement detail | 6 | TAX_AMT | Severance tax amount | decimal | 15 | 2 | | |