| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX6Y_WY_MSTPLT | Tax 2.0 - Wyoming Plant Master Data PPN | 2 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
2 | OIUX6_WY_MSTPLT | Tax 2.0 - Wyoming Plant Master Data | 2 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
TOPProduction and Revenue Accounting |
3 | OIUX1_ARCH_MKTH | Reporting history for marketing costs for reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
4 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
5 | OIUX1_ARCH_VOLH | Reported Volume Data by PUID | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
6 | OIUX1_ARCH_XMPH | Reporting history for tax exemptions | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
7 | OIUX1_RPT_LOG | Tax reporting log table for rpt | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
8 | OIUX2_DOWNLOAD | Tax Reporting download table | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
9 | OIUX2_EXEC_STATD | Execution Statistics for Tax Reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
10 | OIUX2_LNK_LOG | Tax Reporting log table for the link | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
11 | OIUX2_PUIDLOG | Tax Reporting PUID log | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
12 | OIUX2_PUID_MKTH | Reporting history for marketing costs for reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
13 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
14 | OIUX2_PUID_XMPH | Reporting history for tax exemptions | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
15 | OIUX2_RE_LOG | Tax Reporting log table for the Log | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
16 | OIUX2_RSG_LOG | Tax reporting log table for rpt | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
17 | OIUY1_DOWNLOAD | The intermediate table for download | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
18 | OIUY1_EXEC_STATD | Execution Statistics for Royalty Reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
19 | OIUY1_TXDOWNLOAD | The intermediate table for Texas download | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
TOPTax Reporting |
20 | OIUX1_ADJ_TAXHC | Tax adjustments header for reporting | 16 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
21 | OIUX1_AGY_DEFN | Agency definition | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
22 | OIUX1_EXEC_COMB | Execution Combinations for Tax Reporting | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
23 | OIUX1_EXEC_STAT | Execution Statistics for Tax Reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
24 | OIUX1_FLD_VALB | Base table for field level data | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
25 | OIUX1_FLD_VALL | Log for field level data | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
26 | OIUX1_LNK_REPUB | PUID and reporting entities link | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
27 | OIUX1_MAS_REB | Reporting entities base table | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
28 | OIUX1_PRD_UIDB | Base table for Production Units/Leases | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
29 | OIUX1_PROC_CNTRL | Reporting process control table | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
30 | OIUX1_PUID_MKTH | Reporting history for marketing costs for reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
31 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
32 | OIUX1_PUID_VOLH | Reported Volume Data by PUID | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
33 | OIUX1_PUID_XMPH | Reporting history for tax exemptions | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
34 | OIUX1_RPT_IDB | Legal report time dependent base table | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
35 | OIUX1_RPT_MKTH | Reporting history for marketing costs for reporting | 11 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
36 | OIUX1_RPT_MSTRL | Log for master data changes | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
37 | OIUX1_RPT_SGB | Report Submission Group base table | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
38 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
39 | OIUX1_RPT_VOLH | Reported Volume Data by Reporting Entities | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
40 | OIUX1_RPT_XMPH | Reporting history for tax exemptions | 11 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
41 | OIUX1_TAX_SUSP | Records for suspension | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
42 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 34 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
43 | OIUX1_TRN_TAXHL | Tax transaction header for reporting | 30 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
44 | OIUX1_TXCD_XREF | Cross reference between state tax codes and PRA entities | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
45 | OIUX2_BA_LOG | Cross ref. betwn PRA prod/purchaser no. and its tax payer | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
46 | OIUX2_PUID_VOLH | Reported Volume Data by PUID | 5 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
47 | OIUX6Y_WY_MASTER | Tax 2.0 - Wyoming Master Data PPN | 2 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
48 | OIUX6_WY_ASU_HD | Tax 2.0 - Wyoming Auto Suspend Header | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
49 | OIUX6_WY_COOSHST | Tax 2.0 - Wyoming Out Of Statute Conservation Trans Hist | 47 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
50 | OIUX6_WY_COOSTXN | Tax 2.0 - Wyoming Out Of Statute Conservation Transactions | 47 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
51 | OIUX6_WY_CPRDT | Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions | 49 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
52 | OIUX6_WY_CTAXHST | Tax 2.0 - Wyoming Conservation Tax Transactions History | 47 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
53 | OIUX6_WY_CTAXSTG | Tax 2.0 - Wyoming Conservation Tax Transactions Staging | 47 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
54 | OIUX6_WY_CTAXTXN | Tax 2.0 - Wyoming Conservation Tax Transactions | 47 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
55 | OIUX6_WY_GTAXSTG | Tax 2.0 - Wyoming Gross Prod Tax Transactions Staging | 62 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
56 | OIUX6_WY_GTAXTXN | Tax 2.0 - Wyoming Gross Prod Tax Transactions | 62 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
57 | OIUX6_WY_MASTER | Tax 2.0 - Wyoming Master Data | 2 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
58 | OIUX6_WY_RATE_CD | Tax 2.0 - Wyoming Rate Codes | 2 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
59 | OIUX6_WY_SOGXRF | Tax 2.0 - Wyoming Tax Oil/Gas Indicator XRef | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
60 | OIUX6_WY_SOLEDT | Tax Reporting - Statute of Limitation Exception Detail | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
61 | OIUX6_WY_SOOSHST | Tax 2.0 - Wyoming Out Of Statute Severance Trans History | 62 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
62 | OIUX6_WY_SOOSTXN | Tax 2.0 - Wyoming Out Of Statute Severance Transactions | 62 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
63 | OIUX6_WY_SPRDT | Tax 2.0 - Wyoming Severance Tax PRA Detail Transactions | 64 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
64 | OIUX6_WY_SRPDT | Tax 2.0 - Wyoming Severance Tax Report Detail | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
65 | OIUX6_WY_SRPDTDT | Tax 2.0 - Wyoming Severance Tax Report Detail Detail | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
66 | OIUX6_WY_SRPDT_H | Tax 2.0 - Wyoming Severance Tax Report Detail | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
67 | OIUX6_WY_STAXHST | Tax 2.0 - Wyoming Severance Tax Transactions History | 62 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
68 | OIUX6_WY_STAXSTG | Tax 2.0 - Wyoming Severance Tax Transactions Staging | 62 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
69 | OIUX6_WY_STAXTXN | Tax 2.0 - Wyoming Severance Tax Transactions | 62 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
70 | OIUX6_WY_STAX_RT | Tax 2.0 - Wyoming Severance Rate Codes | 3 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
71 | OIUX6_WY_ZVOL | Tax 2.0 - Wyoming Zero Volume Reporting Master | 2 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
72 | OIUX7_WY_GSALES | Tax 2.0 - WYGP Sales | 16 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
73 | OIUX7_WY_GSALHST | Tax 2.0 - WYGP Sales History | 15 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
74 | OIUX7_WY_GSALTXN | Tax 2.0 - WYGP Sales | 15 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
75 | OIUX7_WY_GTAX | Tax 2.0 - Wyoming Gross Prod Tax Transactions | 62 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
76 | OIUX7_WY_GTAXHST | Tax 2.0 - Wyoming Gross Prod Tax Transactions History | 61 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
77 | OIUX7_WY_MKT | Tax 2.0 - WYGP Marketing Types | 1 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
78 | OIUX7_WY_MKTOVR | Tax 2.0 - WYGP Marketing Type Xref Override | 4 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
79 | OIUX7_WY_MKTXRF | Tax 2.0 - WYGP Marketing Type Xref | 2 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |
80 | OIUX7_WY_MKT_TX | Tax 2.0 - WYGP Marketing Type Descriptions | 2 | OGIND | Oil and Gas Indicator | nvarchar | 1 | 0 | | |