| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | J_3RF_DI_OCCODE | Assign Operator to Company Code | 4 | OPERATOR_ID | Operator ID | nvarchar | 3 | 0 | | |
2 | OIUY3_TX_INTSTG | Royalty 2.0 - TX GLO - Royalty Trans Interface Staging | 48 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
3 | OIUY3_TX_INTTXN | Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface | 48 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
4 | OIUY3_TX_OOSHST | Royalty 2.0 - TX - Out of Statute Royalty Transaction Hist | 45 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
5 | OIUY3_TX_OOSTXN | Royalty 2.0 - TX GLO - Out of Statute Royalty Transactions | 45 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
6 | OIUY3_TX_PRDT | Royalty 2.0 - TX GLO - Royalty PRA Details | 47 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
7 | OIUY3_TX_PRDTA | Royalty 2.0 - TX GLO - Royalty PRA Details (Allocated) | 48 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
8 | OIUY3_TX_ROYHST | Royalty 2.0 - TX GLO - Royalty Transaction History | 45 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
9 | OIUY3_TX_ROYHSTA | Royalty 2.0 - TX GLO - Royalty Trans History (Allocated) | 46 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
10 | OIUY3_TX_ROYSTG | Royalty 2.0 - TX GLO - Royalty Transactions (Staging) | 45 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
11 | OIUY3_TX_ROYTXN | Royalty 2.0 - TX GLO - Royalty Transactions | 45 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
12 | OIUY3_TX_ROYTXNA | Royalty 2.0 - TX GLO - Royalty Transactions (Allocated) | 46 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
13 | OIUY3_TX_RPGDT | Royalty 2.0 - TX GLO/TAMU - Gas Report | 18 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
14 | OIUY3_TX_RPODT | Royalty 2.0 - TX GLO/TAMU - Oil Report | 18 | OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | nvarchar | 10 | 0 | | |
TOPTax Reporting |
15 | OIUX6Y_WY_BAOPID | Tax 2.0 - Wyoming BA Operator ID PPN | 7 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
16 | OIUX6_WY_BAOPID | Tax 2.0 - Wyoming BA Operator ID | 6 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
17 | OIUX6_WY_COOSHST | Tax 2.0 - Wyoming Out Of Statute Conservation Trans Hist | 40 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
18 | OIUX6_WY_COOSTXN | Tax 2.0 - Wyoming Out Of Statute Conservation Transactions | 40 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
19 | OIUX6_WY_CPRDT | Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions | 42 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
20 | OIUX6_WY_CRPDT | Tax 2.0 - Wyoming Conservation Tax Report Detail | 3 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
21 | OIUX6_WY_CRPDTDT | Tax 2.0 - Wyoming Conservation Tax Report Detail Detail | 3 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
22 | OIUX6_WY_CTAXHST | Tax 2.0 - Wyoming Conservation Tax Transactions History | 40 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
23 | OIUX6_WY_CTAXSTG | Tax 2.0 - Wyoming Conservation Tax Transactions Staging | 40 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
24 | OIUX6_WY_CTAXTXN | Tax 2.0 - Wyoming Conservation Tax Transactions | 40 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
25 | OIUX6_WY_FORM2 | Tax 2.0 - Wyoming Conservation Summarized FORM 2 Data | 2 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
26 | OIUX6_WY_GTAXSTG | Tax 2.0 - Wyoming Gross Prod Tax Transactions Staging | 60 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
27 | OIUX6_WY_GTAXTXN | Tax 2.0 - Wyoming Gross Prod Tax Transactions | 60 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
28 | OIUX6_WY_SOOSHST | Tax 2.0 - Wyoming Out Of Statute Severance Trans History | 60 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
29 | OIUX6_WY_SOOSTXN | Tax 2.0 - Wyoming Out Of Statute Severance Transactions | 60 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
30 | OIUX6_WY_SPRDT | Tax 2.0 - Wyoming Severance Tax PRA Detail Transactions | 62 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
31 | OIUX6_WY_SRPDT | Tax 2.0 - Wyoming Severance Tax Report Detail | 4 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
32 | OIUX6_WY_SRPDTDT | Tax 2.0 - Wyoming Severance Tax Report Detail Detail | 4 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
33 | OIUX6_WY_SRPDT_H | Tax 2.0 - Wyoming Severance Tax Report Detail | 4 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
34 | OIUX6_WY_STAXHST | Tax 2.0 - Wyoming Severance Tax Transactions History | 60 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
35 | OIUX6_WY_STAXSTG | Tax 2.0 - Wyoming Severance Tax Transactions Staging | 60 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
36 | OIUX6_WY_STAXTXN | Tax 2.0 - Wyoming Severance Tax Transactions | 60 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
37 | OIUX6_WY_ZVOL | Tax 2.0 - Wyoming Zero Volume Reporting Master | 3 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
38 | OIUX7_WY_GSALES | Tax 2.0 - WYGP Sales | 21 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
39 | OIUX7_WY_GSALHST | Tax 2.0 - WYGP Sales History | 20 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
40 | OIUX7_WY_GSALTXN | Tax 2.0 - WYGP Sales | 20 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
41 | OIUX7_WY_GTAX | Tax 2.0 - Wyoming Gross Prod Tax Transactions | 60 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |
42 | OIUX7_WY_GTAXHST | Tax 2.0 - Wyoming Gross Prod Tax Transactions History | 59 | OPERATOR_ID | Tax 2.0 - Wyoming Operator ID | nvarchar | 4 | 0 | | |