| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | OIUX8_NM_OOSWO | Tax 2.0 - New Mexico Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 2 | OIUY3_TX_INTSTG | Royalty 2.0 - TX GLO - Royalty Trans Interface Staging | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 3 | OIUY3_TX_INTTXN | Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 4 | OIUY3_TX_OOSWO | Royalty 2.0 - Texas GLO Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 5 | OIUY6_WY_INTSTG | Royalty 2.0 - WY - Royalty Transaction Interface (Staging) | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 6 | OIUY6_WY_INTTXN | Royalty 2.0 - WY - Royalty Transaction Interface | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 7 | OIUY6_WY_OOSWO | Royalty 2.0 - Wyoming Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| TOPCheck Input |
| 8 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 9 | OIUCI_PDX | Purchaser DOI Cross Reference | 29 | OR_LVL_1_NO | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
| TOPRevenue |
| 10 | OIUE1_LSSL_SUM | Legal Suspense Summary | 14 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 11 | OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details | 15 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 12 | OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History | 15 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 13 | OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details | 15 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 14 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 15 | OIUE2_RUN_JE | Proc 2.0 - Process Run JE Batch Info | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 16 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 17 | OIUH_RV_JEINTF | PRA Journal Entries | 2 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 18 | OIUH_RV_TAXHA | New Mexico Tax History For Affiliated Txns | 19 | OR_LVL_1_NO | OIUH_CHAR3 | nvarchar | 3 | 0 | | |
| 19 | OIUH_RV_TAXHN | New Mexico Tax History For Non-Affiliated Txns | 19 | OR_LVL_1_NO | OIUH_CHAR3 | nvarchar | 3 | 0 | | |
| 20 | OIU_RV_CMKT | Check Detail Marketing Deductions | 2 | OR_LVL_1_NO | OIUH_CHAR3 | nvarchar | 3 | 0 | | |
| TOPTax Reporting |
| 21 | OIUX3_JEINTF | Tax Reporting - JE Interface Table | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 22 | OIUX3_RUN_JE | Tax Reporting - Report Run JE Batch Info | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 23 | OIUX3_TX_OOSWO | Tax Reporting - Texas Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 24 | OIUX5_OOSWO | Tax 2.0 - Out Of Statute Write Off | 5 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 25 | OIUX6_WY_OOSWO | Tax 2.0 - Wyoming Out Of Statute Write Off | 3 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| TOPValuation |
| 26 | OIURV_DOC_BCN | Revenue Document Concept - Batch Control Number | 4 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
| 27 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 4 | OR_LVL_1_NO | Company Name Code | nvarchar | 3 | 0 | | |
