| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | OIUY3_TX_BAXRF | Royalty 2.0 - TX GLO/TAU - BA Xref | 2 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 2 | OIUYC_BA_RPTID | Royalty 2.0 - Report ID Owner Cross Reference | 3 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| TOPProduction and Revenue Accounting |
| 3 | OIUCM_BADR | Business Associate Additional Addresses (Addr Grp = OIU1) | 2 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 4 | OIUCM_BA_LINK | Business Associate -> SAP Master Link | 2 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| TOPTax Reporting |
| 5 | OIUX2_BA_LOG | Cross ref. betwn PRA prod/purchaser no. and its tax payer | 5 | BA_NO | BA number of character length 10 | nvarchar | 10 | 0 | | |
| 6 | OIUX3Y_TX_BATXID | Tax Reporting - Texas BA Tax ID PPN | 2 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 7 | OIUX3_TX_BATXID | Tax Reporting - Texas BA Tax ID | 2 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 8 | OIUX5Y_OK_BATXID | Tax 2.0 - Oklahoma BA Tax ID PPN | 2 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 9 | OIUX5_OK_BATXID | Tax 2.0 - Oklahoma BA Tax ID | 2 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 10 | OIUX6Y_WY_BAOPID | Tax 2.0 - Wyoming BA Operator ID PPN | 2 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 11 | OIUX6_WY_BAOPID | Tax 2.0 - Wyoming BA Operator ID | 2 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 12 | OIUX7_WY_GSALES | Tax 2.0 - WYGP Sales | 19 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 13 | OIUX7_WY_GSALHST | Tax 2.0 - WYGP Sales History | 18 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
| 14 | OIUX7_WY_GSALTXN | Tax 2.0 - WYGP Sales | 18 | BA_NO | Business Associate | nvarchar | 6 | 0 | | |
