| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTax Reporting |
1 | OIUX3_TX_EDITS2 | OBSOLETE - Tax 2.0 - Texas Report Field Edits #2 | 2 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
2 | OIUX3_TX_EDITS2T | OBSOLETE - Tax 2.0 - Texas Report Field Edits #2 | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
3 | OIUX3_TX_MSTOVR | Tax Reporting - Texas Master Data Overrides | 11 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
4 | OIUX3_TX_OOSHST | Tax Reporting - Texas Out Of Statute Transaction History | 17 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
5 | OIUX3_TX_OOSTXN | Tax Reporting - Texas Out Of Statute Transactions | 17 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
6 | OIUX3_TX_PRDTB | Tax Reporting - Texas PRA Detail Txns-Tier Tax Below | 18 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
7 | OIUX3_TX_PRDTI | Tax Reporting - Texas PRA Detail Txns-Tier Tax Incremental | 18 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
8 | OIUX3_TX_PRDTN | Tax Reporting - Texas PRA Detail Txns - No Tier Tax | 18 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
9 | OIUX3_TX_RPGDT | Tax Reporting - Texas Gas Report Details | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
10 | OIUX3_TX_RPGDTE | Tax Reporting - Texas Gas Report Details Errors | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
11 | OIUX3_TX_RPGSM | Tax Reporting - Texas Gas Report Summary | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
12 | OIUX3_TX_RPGSME | Tax Reporting - Texas Gas Report Summary Errors | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
13 | OIUX3_TX_RPODT | Tax Reporting - Texas Oil Report Details | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
14 | OIUX3_TX_RPODTE | Tax Reporting - Texas Oil Report Details Errors | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
15 | OIUX3_TX_RPOSM | Tax Reporting - Texas Oil Report Summary | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
16 | OIUX3_TX_RPOSME | Tax Reporting - Texas Oil Report Summary Errors | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
17 | OIUX3_TX_RP_EDT1 | OBSOLETE - Tax 2.0 - Texas Report Field Attribute Edits | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
18 | OIUX3_TX_RP_EDT2 | OBSOLETE - Tax 2.0 - Texas Report Field Edits #2 | 3 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
19 | OIUX3_TX_TAXHST | Tax Reporting - Texas Tax History Transactions | 17 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
20 | OIUX3_TX_TAXSTG | Tax Reporting - Texas Tax Transaction Staging | 17 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
21 | OIUX3_TX_TAXTXN | Tax Reporting - Texas Tax Transactions | 17 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
22 | OIUX5_OK_CONFL | Tax 2.0 - Oklahoma Exempt Decimal Conflict | 7 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
23 | OIUX5_OK_OOSHST | Tax 2.0 - Oklahoma Out Of Statute Transactions History | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
24 | OIUX5_OK_OOSTXN | Tax 2.0 - Oklahoma Out Of Statute Transactions | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
25 | OIUX5_OK_PRDT | Tax 2.0 - Oklahoma PRA Detail Tax Transactions | 17 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
26 | OIUX5_OK_PRDTC | Tax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count | 19 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
27 | OIUX5_OK_RPDT | Tax 2.0 - Oklahoma Gross Prod Report Detail | 7 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
28 | OIUX5_OK_TAXHST | Tax 2.0 - Oklahoma Tax Transactions History | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
29 | OIUX5_OK_TAXHSTC | Tax 2.0 - Oklahoma Tax Transactions History Multi-Counties | 17 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
30 | OIUX5_OK_TAXSTG | Tax 2.0 - Oklahoma Tax Transactions Staging | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
31 | OIUX5_OK_TAXTXN | Tax 2.0 - Oklahoma Tax Transactions | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
32 | OIUX5_OK_TAXTXNC | Tax 2.0 - Oklahoma Tax Transactions Multiple Counties | 17 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
33 | OIUX5_OK_ZVOL | Tax 2.0 - Oklahoma Zero Volume Reporting Master | 6 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
34 | OIUX6_WY_COOSHST | Tax 2.0 - Wyoming Out Of Statute Conservation Trans Hist | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
35 | OIUX6_WY_COOSTXN | Tax 2.0 - Wyoming Out Of Statute Conservation Transactions | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
36 | OIUX6_WY_CPRDT | Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions | 17 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
37 | OIUX6_WY_CTAXHST | Tax 2.0 - Wyoming Conservation Tax Transactions History | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
38 | OIUX6_WY_CTAXSTG | Tax 2.0 - Wyoming Conservation Tax Transactions Staging | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |
39 | OIUX6_WY_CTAXTXN | Tax 2.0 - Wyoming Conservation Tax Transactions | 15 | PROD_PURC_IND | Producer or Purchaser | nvarchar | 1 | 0 | | |