| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8Y_NM_MASTER | Tax 2.0 - NM - Master Data PPN | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
2 | OIUX8_NM_ASUE_HD | Tax 2.0 NM - Auto Suspend Exception Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
3 | OIUX8_NM_ASU_HD | Tax 2.0 - NM - Auto Suspend Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
4 | OIUX8_NM_MASTER | Tax 2.0 - NM - Master Data | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
5 | OIUX8_NM_SOLEHD | Tax 2.0 - NM - Statute of Limitation Exception Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
6 | OIUY3Y_TX_MASTER | Royalty 2.0 - TX GLO/TAMU - Master Data PPN | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
7 | OIUY3Y_TX_RRC | Royalty 2.0 - TX GLO/TAMU - RRC Master PPN | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
8 | OIUY3_TX_ASU_HD | Royalty 2.0 - TX GLO/TAMU - Auto Suspend Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
9 | OIUY3_TX_CTRL | Royalty 2.0 - TX GLO/TAMU Reporting Control Record Master | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
10 | OIUY3_TX_MASTER | Royalty 2.0 - TX GLO/TAMU - Master Data | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
11 | OIUY3_TX_PDCXRF | Royalty 2.0 - TX GLO/TAMU - Production Disposition XRef | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
12 | OIUY3_TX_RRC | Royalty 2.0 - TX GLO/TAMU - RRC Master | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
13 | OIUY3_TX_SOL | Royalty 2.0 - Texas GLO Statute of Limitation | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
14 | OIUY3_TX_SOLEHD | Royalty 2.0 - TX GLO/TAMU SOL Exception Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
15 | OIUY6Y_WY_MASTER | Royalty 2.0 - WY - Master Data PPN | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
16 | OIUY6_WY_ASU_HD | Royalty 2.0 - WY - Auto Suspend Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
17 | OIUY6_WY_MASTER | Royalty 2.0 - WY - Master Data | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
18 | OIUY6_WY_PRICE | Royalty 2.0 - WY - Report Pricing | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
19 | OIUY6_WY_RPDTM | Royalty 2.0 - WY - Lease/Unit Report Detail - Masters | 6 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
20 | OIUY6_WY_SOL | Royalty 2.0 - Wyoming Statute of Limitation | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
21 | OIUY6_WY_SOLEHD | Royalty 2.0 - WY Statute of Limitation Exception Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
22 | OIUY6_WY_ZVOL | Royalty 2.0 - WY - Zero Volume Master | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
23 | OIUYC_BA_RPTID | Royalty 2.0 - Report ID Owner Cross Reference | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
24 | OIUYC_OVR_MASTER | Override master - Pass Exception data to Royalty loaders | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
TOPTax Reporting |
25 | OIUX3Y_TX_MASTER | Tax Reporting - Texas Master Data PPN | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
26 | OIUX3Y_TX_MSTOVR | Tax Reporting - Texas Master Data Overrides | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
27 | OIUX3_MIG_GRPRX | Tax Reporting - Migration Group Report XRef | 3 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
28 | OIUX3_RPT | Tax Reporting - Reports | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
29 | OIUX3_RPT_COMP | Tax Reporting - Reporting Company | 3 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
30 | OIUX3_RPT_COMPT | Tax Reporting - Reporting Company Text | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
31 | OIUX3_RPT_COMPX | Tax Reporting - Reporting Company XRef | 3 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
32 | OIUX3_RPT_CONF | Tax Reporting - Report Specific Configuration | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
33 | OIUX3_RPT_CONFD | Tax Reporting - Report Specific Configuration (Dated) | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
34 | OIUX3_RPT_PROF | Tax Reporting - Reporting Profile | 3 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
35 | OIUX3_RPT_STEPX | Tax Reporting - Reporting/Step XRef | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
36 | OIUX3_RPT_TX | Tax Reporting - Reports | 3 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
37 | OIUX3_RUN_HDR | Tax Reporting - Run Header | 3 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
38 | OIUX3_STEPX_ST | Tax Reporting - Step Prerequisite Status | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
39 | OIUX3_TX_ASU_HD | Tax Reporting - Auto Suspend Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
40 | OIUX3_TX_MASTER | Tax Reporting - Texas Master Data | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
41 | OIUX3_TX_MSTOVR | Tax Reporting - Texas Master Data Overrides | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
42 | OIUX3_TX_SOL | Tax Reporting - Statute of Limitation | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
43 | OIUX3_TX_SOLEHD | Tax Reporting - Statute of Limitation Exception Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
44 | OIUX6_WY_SOL | Tax 2.0 - Wyoming Statute of Limitation | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
45 | OIUX6_WY_SOLEHD | Tax 2.0 - Wyoming Statute of Limitation Exception Header | 4 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |
46 | OIUXC_RPT_PP | Tax 2.0 - Report Specific Parallel Processing Config | 2 | RPT_ID | Report ID | nvarchar | 10 | 0 | | |