| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRoyalty Reporting |
1 | OIUREP_RRST_DET | Regulatory Reporting Status Table | 2 | PROD_YEAR | Reporting Year | nvarchar | 4 | 0 | | |
TOPTax Reporting |
2 | OIUX7_WY_4101 | Tax 2.0 - WYGP 4101 | 4 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
3 | OIUX7_WY_4101HST | Tax 2.0 - WYGP 4101 Up To Date History | 3 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
4 | OIUX7_WY_4101_OP | Tax 2.0 WYGP - 4101 Op/Non-Op Switch Info | 4 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
5 | OIUX7_WY_4111 | Tax 2.0 - WYGP 4111 | 4 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
6 | OIUX7_WY_4111HST | Tax 2.0 - WYGP 4111 Up To Date History | 3 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
7 | OIUX7_WY_4121 | Tax 2.0 - WYGP 4121 | 4 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
8 | OIUX7_WY_4121HST | Tax 2.0 - WYGP 4121 Up To Date History | 3 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
9 | OIUX7_WY_4201 | Tax 2.0 - WYGP 4201 | 4 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
10 | OIUX7_WY_4201HST | Tax 2.0 - WYGP 4201 Up To Date History | 3 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
11 | OIUX7_WY_4211 | Tax 2.0 - WYGP 4211 | 4 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
12 | OIUX7_WY_4211HST | Tax 2.0 - WYGP 4211 Up To Date History | 3 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
13 | OIUX7_WY_4221 | Tax 2.0 - WYGP 4221 | 4 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
14 | OIUX7_WY_4221HST | Tax 2.0 - WYGP 4221 Up To Date History | 3 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
15 | OIUX7_WY_4231 | Tax 2.0 - WYGP 4231 | 4 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
16 | OIUX7_WY_4231HST | Tax 2.0 - WYGP 4231 Up To Date History | 3 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
17 | OIUX7_WY_GSALES | Tax 2.0 - WYGP Sales | 18 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
18 | OIUX7_WY_GSALHST | Tax 2.0 - WYGP Sales History | 17 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
19 | OIUX7_WY_GSALTXN | Tax 2.0 - WYGP Sales | 17 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
20 | OIUX7_WY_GVOL | Tax 2.0 - WYGP Volume | 13 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
21 | OIUX7_WY_GVOLHST | Tax 2.0 - WYGP Volume History | 12 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |
22 | OIUX7_WY_GVOLTXN | Tax 2.0 - WYGP Volumes | 12 | PROD_YEAR | Tax 2.0 - Production Year | nvarchar | 4 | 0 | | |